![]() | |
![]() |
| | Thread Tools | Search this Thread | Display Modes |
#11
| |||
| |||
|
|
On Jul 26, 2:35 pm, nate... (AT) gmail (DOT) com wrote: Check the permissions on the $INFORMIXDIR directory with the filesystem unmounted. The underlying permissions can mess with the mounted filesystem, allowing only root to write there. --EEM Will do, thanks. I'll give that a look before I reinstall. Well, I give up. I've tried everything I can possibly think of. |
|
As far as the file system permissions, I forgot this was an older box, and /dbms is the only file system (which has a bunch of other informix directories under it, all 9.4 though except the one I'm having problems with). So, I deleted /dbms/calcotest, and created a file system at /dbms/calcotest. Then did a clean install of informix 10 to / dbms/calcotest/informix. Copied the onconfig and sqlhosts back over, started em up, and onmonitor has the same problem. Actually, its worth noting that the problem happens whether the engine is up or not, even with just the onconfig.std in place of my onconfig. |
|
I forgot that we have a development box on HP11.11 with Informix 10 (10.00.H4). It has no problems with onmonitor. I spent some time comparing the permissions on the onmonitor excecutable, onconfig file, and directories to no avail. The permissions are the same or less restrictive on the box having problems. At this point, I'm thinking it has to be an HP specific bug with FC6, but I'm suprised googling doesn't turn up anything. I rarely post because I'm a good searcher, and someone almost always has the problem before me. Not to mention we're always behind in releases.I think an Informix support call is in order tomorrow. I'll let you know what they say. -Nate |
#12
| |||
| |||
|
|
nate... (AT) gmail (DOT) com wrote: On Jul 26, 2:35 pm, nate... (AT) gmail (DOT) com wrote: Check the permissions on the $INFORMIXDIR directory with the filesystem unmounted. The underlying permissions can mess with the mounted filesystem, allowing only root to write there. --EEM Will do, thanks. I'll give that a look before I reinstall. Well, I give up. I've tried everything I can possibly think of. Any question of 'nosuid' options when the file system was mounted? Most of the suggestions have been pretty much spot on, but if you were running ON-Monitor as user informix, it should have worked almost regardless. As far as the file system permissions, I forgot this was an older box, and /dbms is the only file system (which has a bunch of other informix directories under it, all 9.4 though except the one I'm having problems with). So, I deleted /dbms/calcotest, and created a file system at /dbms/calcotest. Then did a clean install of informix 10 to / dbms/calcotest/informix. Copied the onconfig and sqlhosts back over, started em up, and onmonitor has the same problem. Actually, its worth noting that the problem happens whether the engine is up or not, even with just the onconfig.std in place of my onconfig. Older versions of ON-Monitor were suid root. It shouldn't be necessary, and could be dangerous (for example, if you do a shell escape, is the shell running as root or informix or the user who runs ON-Monitor), but you might try it cautiously to see if that resolves the problem. If there are other instances in directories under /dbms, then it is unlikely to be a problem with 'nosuid' options. I forgot that we have a development box on HP11.11 with Informix 10 (10.00.H4). It has no problems with onmonitor. I spent some time comparing the permissions on the onmonitor excecutable, onconfig file, and directories to no avail. The permissions are the same or less restrictive on the box having problems. At this point, I'm thinking it has to be an HP specific bug with FC6, but I'm suprised googling doesn't turn up anything. I rarely post because I'm a good searcher, and someone almost always has the problem before me. Not to mention we're always behind in releases.I think an Informix support call is in order tomorrow. I'll let you know what they say. -Nate -- Jonathan Leffler #include <disclaimer.h Email: jleff... (AT) earthlink (DOT) net, jleff... (AT) us (DOT) ibm.com Guardian of DBD::Informix v2007.0226 --http://dbi.perl.org/- Hide quoted text - - Show quoted text - |
#13
| |||
| |||
|
#14
| |||
| |||
|
|
I suggest re running the install script That will reset the permissions on everything |
#15
| |||
| |||
|
|
On Jul 26, 9:28 pm, Jonathan Leffler <jleff... (AT) earthlink (DOT) net> wrote: nate... (AT) gmail (DOT) com wrote: On Jul 26, 2:35 pm, nate... (AT) gmail (DOT) com wrote: Check the permissions on the $INFORMIXDIR directory with the filesystem unmounted. The underlying permissions can mess with the mounted filesystem, allowing only root to write there. --EEM Will do, thanks. I'll give that a look before I reinstall. Well, I give up. I've tried everything I can possibly think of. Any question of 'nosuid' options when the file system was mounted? Most of the suggestions have been pretty much spot on, but if you were running ON-Monitor as user informix, it should have worked almost regardless. As far as the file system permissions, I forgot this was an older box, and /dbms is the only file system (which has a bunch of other informix directories under it, all 9.4 though except the one I'm having problems with). So, I deleted /dbms/calcotest, and created a file system at /dbms/calcotest. Then did a clean install of informix 10 to / dbms/calcotest/informix. Copied the onconfig and sqlhosts back over, started em up, and onmonitor has the same problem. Actually, its worth noting that the problem happens whether the engine is up or not, even with just the onconfig.std in place of my onconfig. Older versions of ON-Monitor were suid root. It shouldn't be necessary, and could be dangerous (for example, if you do a shell escape, is the shell running as root or informix or the user who runs ON-Monitor), but you might try it cautiously to see if that resolves the problem. If there are other instances in directories under /dbms, then it is unlikely to be a problem with 'nosuid' options. I forgot that we have a development box on HP11.11 with Informix 10 (10.00.H4). It has no problems with onmonitor. I spent some time comparing the permissions on the onmonitor excecutable, onconfig file, and directories to no avail. The permissions are the same or less restrictive on the box having problems. At this point, I'm thinking it has to be an HP specific bug with FC6, but I'm suprised googling doesn't turn up anything. I rarely post because I'm a good searcher, and someone almost always has the problem before me. Not to mention we're always behind in releases.I think an Informix support call is in order tomorrow. I'll let you know what they say. -Nate -- Jonathan Leffler #include <disclaimer.h Email: jleff... (AT) earthlink (DOT) net, jleff... (AT) us (DOT) ibm.com Guardian of DBD::Informix v2007.0226 --http://dbi.perl.org/-Hide quoted text - - Show quoted text - Thanks for the reply Jonathan. Here is all of the file systems on this box (from /etc/fstab): INFORMIX:asp27[calcotest] /etc$ cat fstab /dev/vg00/lvol3 / vxfs delaylog 0 1 [...] /dev/vg01/dbms_fs /dbms vxfs rw,suid,largefiles,delaylog,datainlog 0 2 [...] /dev/vg01/calco_fs /asp/calco vxfs rw,suid,largefiles,delaylog,datainlog 0 2 /dev/vg01/calcotest_fs /asp/calcotest vxfs rw,suid,largefiles,delaylog,datainlog 0 2 [...] /dev/vg01/calcoqa_fs /asp/calcoqa vxfs rw,suid,largefiles,delaylog,datainlog 0 2 /dev/vg01/dbms_calcotest /dbms/calcotest vxfs rw,suid,largefiles,delaylog,datain log 0 2 The last entry was the file system I created tonight to see if it would solve the problem. I usually choose pretty much default options when creating a file system in HP (except for always allowing large files). I'm wasn't quite clear if you were suggesting to try nosuid or not, but I went ahead and changed /dbms/calcotest to be nosuid: |
|
asp27:/etc # grep nosuid /etc/fstab /dev/vg01/dbms_calcotest /dbms/calcotest vxfs delaylog,nodatainlog,largefiles,rw,nosuid 0 2 But it doesn't help. Same error. Note that I get a warning message now, but I guess that is expected: INFORMIX:asp27[calcotest] $ onmonitor /dbms/calcotest/informix/bin/onmonitor: Setuid execution not allowed |
#16
| |||
| |||
|
|
On Jul 27, 7:50 am, scottishpoet <drybur... (AT) yahoo (DOT) com> wrote: I suggest re running the install script That will reset the permissions on everything Thanks, but I've done a clean install several times now. |
#17
| |||
| |||
|
#18
| |||
| |||
|
|
Before I answer anyones questions, a little more info: I downloaded FC5 and HC6 last night. Doing a clean install, FC5 has no problems with onmonitor. Using HC6, onmonitor has problems, but a slightly different error: Operating system error: 9. Press Return to continue. Operating system error: 9. WARNING: Cannot write to $INFORMIXDIR/etc. That error matcheshttp://www-1.ibm.com/support/entdocview.wss?uid=swg1IC51682&NotUpdate... Which since you need a login to see that, it says this: IC51682: ONMONITOR RETURNS AN ERROR -9 AND "CANNOT WRITE TO $INFORMIXDIR/ETC" WHEN INITIALIZING SHARED MEMORY APAR status OPEN Error description When trying to initialize shared memory with onmonitor the following error occurs: Operating system error: 9. Press Return to continue. Pressing continue produces: Operating system error: 9. WARNING: Cannot write to $INFORMIXDIR/etc Local fix Problem summary ************************************************** ************** USERS AFFECTED: All Users ************************************************** ************** PROBLEM DESCRIPTION: Onmonitor returns "Operating system error: 9" while trying to initialize shared memory. ************************************************** ************** RECOMMENDATION: Upgrade to 10.00.xC6 when available ************************************************** ************** Problem conclusion Problem was first fixed in IDS 10.00.xC6 Temporary fix Comments APAR information APAR number IC51682 Reported component name IBM IDS Reported component ID 5724L2300 Reported release A10 Status OPEN PE NoPE HIPER NoHIPER Special Attention NoSpecatt Submitted date 2007-01-26 Closed date Last modified date 2007-04-25 APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: So, if I'm reading that correctly, the problem was fixed in xC6, which doesn't make sense, since thats what I'm using. Or am I reading that wrong? The APAR is open which is confusing. |
#19
| |||
| |||
|
|
I spoke with Informix. [...] It may be fixed in the latest "pit drop"(sp? not familiar with that term, but he said it was like a service pack) or in FC7. |
#20
| |||
| |||
|
|
natebsi (AT) gmail (DOT) com wrote: I spoke with Informix. [...] It may be fixed in the latest "pit drop"(sp? not familiar with that term, but he said it was like a service pack) or in FC7. A PID is a post-interim drop, also redundantly called a PID-drop. It will have a version number such as 10.00.xC5P1 (where I think the letter is indeed P, but there is some capital letter used, followed by a number - and the letter is not X which would be a patch release - one-off for a specific customer.). A PID has a collection of fixes and some minimal level of QA, and the changes are expected to be rolled into the next interim (eg 10.00.xC6 for a 10.00.xC5P1). PIDs are generated quite frequently - like about every month. |
![]() |
| Thread Tools | Search this Thread |
| Display Modes | |
| |