IDS Forum

RE: Debian, LVM, udev, IDS

Posted By: jim-cramer@uiowa.edu
Date: Friday, 2 December 2011, at 6:43 p.m.

In Response To: Re: Debian, LVM, udev, IDS (FRANK)

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 reader’s 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 Unix’s' 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=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>
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

> <mailto:Informix-list@iiug.org> Informix-list@iiug.org

> <http://www.iiug.org/mailman/listinfo/informix-list>
http://www.iiug.org/mailman/listinfo/informix-list

>

>

>

--0015174a050c4c319204b3217c60

****************************************************************************
***

Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Re: Debian, LVM, udev, IDS
  FRANK -- Friday, 2 December 2011, at 3:05 p.m.
  • RE: Debian, LVM, udev, IDS
    Joerg Volz -- Friday, 2 December 2011, at 4:17 p.m.
  • RE: Debian, LVM, udev, IDS
    jim-cramer@uiowa.edu -- Friday, 2 December 2011, at 6:43 p.m.
  • Re: Debian, LVM, udev, IDS
    NEIL STEVENSON -- Monday, 5 December 2011, at 7:44 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.