Oninit cdi / Archive
Talk to an expert →

raw device problem

Posted in 2006

Summary

SQL NET asked, running Informix 9.30 on SCO Unix, why tables could be created in rootdbs when the raw device had restrictive permissions. Jonathan Leffler explained the permissions are correct and oninit runs SUID root and SGID informix to open the chunks. SQL NET said the reply was not understood, and Marcus Haarmann asked what the real problem was. Unresolved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management, Server Administration

SQL NET — — source: IIUG Forums & Mailing Lists

my dbspaces is linked by raw device.but,i have some problem. /home/informix/data>l -rt crw-rw---- 1 informix informix 7679, 19 Aug 23 15:53 rootdbs@ /home/informix/data>> rootdbs i has covered this rootdbs,why can i create table,or insert data within it ? moreover,it can run after "onmode -ky" and "oninit -v" this database. sco unix7.1.1+informix 9.30 sqlnet 06.08.23

↪ replying to SQL NET
Jonathan Leffler — — source: IIUG Forums & Mailing Lists

On 8/23/06, SQL NET <sqlnet@126.com> wrote: > my dbspaces is linked by raw device.but,i have some problem. > /home/informix/data>l -rt > crw-rw---- 1 informix informix 7679, 19 Aug 23 15:53 rootdbs@ > /home/informix/data>> rootdbs > > i has covered this rootdbs,why can i create table,or insert data within it ? > moreover,it can run after "onmode -ky" and "oninit -v" this database. > > sco unix7.1.1+informix 9.30 Well, you wouldn't want to had to let the whole world scribble on you valuable data, so you wouldn't want the permissions any looser (public read blows any connection security). You do need the system to be able to modify the database - for any user. So, IDS runs a SUID root, SGID informix program called oninit, and uses the temporary, raised privileges to open and modify the underlying chunks. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

↪ replying to Jonathan Leffler
SQL NET — — source: IIUG Forums & Mailing Lists

sorry,i don't understand your reply.

↪ replying to SQL NET
Marcus Haarmann — — source: IIUG Forums & Mailing Lists

Hi, I believe you question has to be more specific, Jonathan did just point out that the permissions are set correctly for the rootdbs chunk. So, what is your problem really (since everything is working correctly as I understand ...) Marcus -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SQL NET Sent: Friday, August 25, 2006 10:04 AM To: ids@iiug.org Subject: Re: raw device problem [7350] sorry,i don't understand your reply. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary