Re: Debian, LVM, udev, IDS
You need come up with a solution ( probably a script) to automatically reset it back to informix/informix whenever you rebooted the box or wwhatever other maintenance activities happened ... Frank On Fri, Dec 2, 2011 at 5:49 AM, Ian Goddard <goddai01@hotmail.co.uk> wrote: > Thanks, but I am the root user! It's mu private box so I'm > root/DBA/user. I can set the perms correctly, informix/informix/660, fire > up onmonitor, set the parameters give the go ahead to initialise the > instance and in the course of that something resets the ownership back to > root/root. It's not the initial setting that's the problem, it's the fact > that something, presumably udev, that's interfering. > > Ian > > ------------------------------ > Date: Thu, 1 Dec 2011 19:25:28 -0500 > Subject: Re: Debian, LVM, udev, IDS > From: yunyaoqu@gmail.com > To: goddai01@hotmail.co.uk > > > How abour ask the root user to change the chunk permission back to > informix/informix? > Frank > > > > On Thu, Dec 1, 2011 at 11:27 AM, Ian Goddard <goddai01@hotmail.co.uk>wrote: > > Old box: > > Ubuntu Hardy, LVM, IDS 7.3 (I said old) > Script in /etc/init.d to set ownership & permissions - > informix,informix,660 - before starting IDS. No problem. > > New box: > Debian Squeeze, LVM, IDS 11.7 > Same script. Check device permissions set as required. Try to > initialise new root chunk. IDS complains that the owner & root should > be informix. Check again & it's now set to root. > > My suspicion is that udev is butting in so I removed the script & tried > to set up udev permissions as per example at > > http://sourceware.org/cgi-bin/cvsweb.cgi/~checkout~/LVM2/udev/12-dm-permissions. rules?rev=1.6&content-type=text/plain&cvsroot=lvm2 > which in turn is as advised at > http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=606124 > > Result: everything's still owned by root. > > Has anyone got this combination working and if so how? > > > -- > Ian > > The Hotmail address is my spam-bin. Real mail address is iang > at austonley org uk > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > > --0015174a050c4c319204b3217c60
On an OpenSuse 11.3 i figured it out: Udev config is stored (under OpenSuse!) under /etc/udev/ There is a rules.d directory inside, with special .rules files I added a "10-informix.rules" file, that contains the following lines: KERNEL=="sdb1", GROUP:="informix", OWNER:="informix" KERNEL=="sdb2", GROUP:="informix", OWNER:="informix" KERNEL=="sdb3", GROUP:="informix", OWNER:="informix" KERNEL=="sdb4", GROUP:="informix", OWNER:="informix" KERNEL=="sdc1", GROUP:="informix", OWNER:="informix" KERNEL=="sdc2", GROUP:="informix", OWNER:="informix" Sdb1 etc are my raw devices without /dev/ in front of it. Hope that gives you hint. Regards, Joerg Volz ------------------------------------------------------------------------ ----- -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK Sent: Friday, December 02, 2011 9:16 PM To: ids@iiug.org Subject: Re: Debian, LVM, udev, IDS [25520] You need come up with a solution ( probably a script) to automatically reset it back to informix/informix whenever you rebooted the box or wwhatever other maintenance activities happened ... Frank On Fri, Dec 2, 2011 at 5:49 AM, Ian Goddard <goddai01@hotmail.co.uk> wrote: > Thanks, but I am the root user! It's mu private box so I'm > root/DBA/user. I can set the perms correctly, informix/informix/660, fire > up onmonitor, set the parameters give the go ahead to initialise the > instance and in the course of that something resets the ownership back to > root/root. It's not the initial setting that's the problem, it's the fact > that something, presumably udev, that's interfering. > > Ian > > ------------------------------ > Date: Thu, 1 Dec 2011 19:25:28 -0500 > Subject: Re: Debian, LVM, udev, IDS > From: yunyaoqu@gmail.com > To: goddai01@hotmail.co.uk > > > How abour ask the root user to change the chunk permission back to > informix/informix? > Frank > > > > On Thu, Dec 1, 2011 at 11:27 AM, Ian Goddard <goddai01@hotmail.co.uk>wrote: > > Old box: > > Ubuntu Hardy, LVM, IDS 7.3 (I said old) > Script in /etc/init.d to set ownership & permissions - > informix,informix,660 - before starting IDS. No problem. > > New box: > Debian Squeeze, LVM, IDS 11.7 > Same script. Check device permissions set as required. Try to > initialise new root chunk. IDS complains that the owner & root should > be informix. Check again & it's now set to root. > > My suspicion is that udev is butting in so I removed the script & tried > to set up udev permissions as per example at > > http://sourceware.org/cgi-bin/cvsweb.cgi/~checkout~/LVM2/udev/12-dm-perm issions.rules?rev=1.6&content-type=text/plain&cvsroot=lvm2 > which in turn is as advised at > http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=606124 > > Result: everything's still owned by root. > > Has anyone got this combination working and if so how? > > > -- > Ian > > The Hotmail address is my spam-bin. Real mail address is iang > at austonley org uk > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > > --0015174a050c4c319204b3217c60 ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. IT Handel und Beratung Jorg Volz Bernhard-Fruh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de
Hi, With Linux SUSE 11 Enterprise and LVM2/Mapper/udev, on x86-64, I encountered this problem several months back, and I have a posted a solution to it after my sig below. I opened a PMR with Informix Tech Support but no one there seemed to know very much about this issue or a proper way to configure Logical Volumes used as dbchunks so that the permissions and ownership of the chunks does not get reset back to what they were before they were configured. Worse yet, with us and others who responded to my post, the symbolic links created in /dev and used as dbchunk names/paths, and point to the actual device files for LVs used as dbchunks, were being removed at host system restart. So I then opened another PMR on their DBA documentation regarding configuring LVs as dbchunks on a Linux system. I was really peeved that the IDS documents will have big, bold notes and other things calling the readers attention to information that applies only to Windows or only to Unix, and absolutely nothing about nuances and differences in it which apply to the Linux variants of Unix. The docs still have the classic, old procedure used for commercial Unixs' such as HPUX, AIX, etc. which does not work if you are using LVM2 on Linux. The engineer was very sympathetic and cooperative but the best that she could do was to get some sort of "note" added in the appropriate part of the appropriate manual, or else in the Machine Notes file, that is not a procedure to use but is just a warning or "heads-up" that these problems may be encountered with IDS chunks on a Linux platform. Fortunately, a couple of IIUG members responded to my post and gave me working solutions that are certain to work no matter which Linux and LVM version you might be running. I used one of them and it seems to work fine So, let me state plainly that I am not to thank **at all** to thank for the following solution. ALL honor and credit for it should go to: Wyza, Jonathon <wyzaj@bethelcollege.edu> Here is what Jonathon wrote me. I implemented it exactly as his instructions indicate. Thanks again Jonathan!!!!! Jim Cramer Univ of Iowa On 6/21/2011, Wyza, Jonathon <wyzaj@bethelcollege.edu> wrote: Subject: RE: is there a way to find out the physical de.... [24104] Jim, I found using sym links to be a pain in the butt with sles. I found that it was much easier to just use persistent storage device minor numbers and make nodes that point to those devices like so: cd /dev/mapper ll lrwxrwxrwx 1 root root 16 2009-06-29 09:27 control -> ../device-mapper brw------- 1 root root 253, 4 2009-06-29 09:27 InformixMirror-IDSdbs brw------- 1 root root 253, 3 2009-06-29 09:27 InformixMirror-IDSRoot brw------- 1 root root 253, 2 2009-06-29 09:27 InformixPrimary-IDSdbs brw------- 1 root root 253, 0 2009-06-29 09:27 InformixPrimary-IDSRoot brw------- 1 root root 253, 1 2009-06-29 09:27 InformixPrimary-IDSTemp lvchange -M y --major 253 --minor 100 "/dev/mapper/InformixPrimary-IDSRoot" lvchange -M y --major 253 --minor 101 "/dev/mapper/InformixPrimary-IDSdbs" lvchange -M y --major 253 --minor 102 "/dev/mapper/InformixPrimary-IDSTemp" lvchange -M y --major 253 --minor 110 "/dev/mapper/InformixMirror-IDSRoot" lvchange -M y --major 253 --minor 111 "/dev/mapper/InformixMirror-IDSdbs" cd /opt/informix mkdir dev cd dev mknod dbs1.1 b 253 101 mknod dbs1.1m b 253 111 mknod dbsroot1.1 b 253 100 mknod dbsroot1.1m b 253 110 mknod dbstemp b 253 102 chown informix:informix * chmod 660 * ll /opt/informix/dev total 0 brw-rw---- 1 informix informix 253, 101 Jun 21 13:45 dbs1.1 brw-rw---- 1 informix informix 253, 111 Jun 21 13:45 dbs1.1m brw-rw---- 1 informix informix 253, 100 Jun 21 13:49 dbsroot1.1 brw-rw---- 1 informix informix 253, 110 Jun 21 13:49 dbsroot1.1m brw-rw---- 1 informix informix 253, 103 Jun 21 13:48 dbstemp Just a thought. Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-807-SQL5(7755) AIM: Iamwyza jonathon.wyza@bethelcollege.edu =============================== SLES 11x64 & IDS 11.50.FC6 JICS 7.4.1 & Cognos 8 "Don't document the problem, fix it." - Atli Björgvin Oddsson -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK Sent: Friday, December 02, 2011 2:05 PM To: ids@iiug.org Subject: Re: Debian, LVM, udev, IDS [25520] You need come up with a solution ( probably a script) to automatically reset it back to informix/informix whenever you rebooted the box or wwhatever other maintenance activities happened ... Frank On Fri, Dec 2, 2011 at 5:49 AM, Ian Goddard < <mailto:goddai01@hotmail.co.uk> goddai01@hotmail.co.uk> wrote: > Thanks, but I am the root user! It's mu private box so I'm > root/DBA/user. I can set the perms correctly, informix/informix/660, > fire up onmonitor, set the parameters give the go ahead to initialise > the instance and in the course of that something resets the ownership > back to root/root. It's not the initial setting that's the problem, > it's the fact that something, presumably udev, that's interfering. > > Ian > > ------------------------------ > Date: Thu, 1 Dec 2011 19:25:28 -0500 > Subject: Re: Debian, LVM, udev, IDS > From: <mailto:yunyaoqu@gmail.com> yunyaoqu@gmail.com > To: <mailto:goddai01@hotmail.co.uk> goddai01@hotmail.co.uk > > > How abour ask the root user to change the chunk permission back to > informix/informix? > Frank > > > > On Thu, Dec 1, 2011 at 11:27 AM, Ian Goddard < <mailto:goddai01@hotmail.co.uk> goddai01@hotmail.co.uk>wrote: > > Old box: > > Ubuntu Hardy, LVM, IDS 7.3 (I said old) Script in /etc/init.d to set > ownership & permissions - > informix,informix,660 - before starting IDS. No problem. > > New box: > Debian Squeeze, LVM, IDS 11.7 > Same script. Check device permissions set as required. Try to > initialise new root chunk. IDS complains that the owner & root should > be informix. Check again & it's now set to root. > > My suspicion is that udev is butting in so I removed the script & > tried to set up udev permissions as per example at > > <http://sourceware.org/cgi-bin/cvsweb.cgi/~checkout~/LVM2/udev/12-dm-permiss ions.rules?rev=1.6&content-type=text/plain&cvsroot=lvm2> http://sourceware.org/cgi-bin/cvsweb.cgi/~checkout~/LVM2/udev/12-dm-permissi ons.rules?rev
I came up against the same issue when migrating from RHEL 5 to RHEL 6 and Joerg is correct in that you have to look in udev. Check out http://www.dswcomputersystems.co.uk/howtos-2/informix-howtos/configuring-raw-dis ks-on-rhel-6/ and that solution should work for you on Debian. If it does work, could you post a reply/comment on that page to let me know. Neil