Path: utzoo!attcan!uunet!samsung!zaphod.mps.ohio-state.edu!usc!ucsd!ucbvax!hplabs!nsc!pyramid!infmx!aland
From: aland@infmx.UUCP (Dr. Scump)
Newsgroups: comp.databases
Subject: Re: Bug creating a db in Informix
Summary: can't reproduce
Message-ID: <3820@infmx.UUCP>
Date: 7 Apr 90 00:56:37 GMT
References: <1990Apr3.175133.12382@aqdata.uucp>
Reply-To: aland@infmx.UUCP (alan denney)
Organization: INFORMIX Professional Services ("Peace thru Normalization")
Lines: 43

In article <1990Apr3.175133.12382@aqdata.uucp> sullivan@aqdata.uucp (Michael T. Sullivan) writes:
>I (as root) created a project directory for people to work in.  I
>gave the directory group rwx permission.  Somebody in the group tried
>to create a database in the project directory.  It didn't work.  The
>error message (as usual) was no help.  I got a funny feeling and
>changed the ownership of the directory to that of the person creating
>the database.  Sure enough, that worked.  Note that this person had
>already mkdir'd several directories previously, so permission to
>create directories was definitely there.

I tried, but I can't reproduce this.  If I have a directory /tmp/foo:
   1 dr-xrwx---  4 root     CN            512 Apr  6 17:48 /tmp/foo
   
and I belong to group CN, I can create a database there just fine
(as me, not necessarily as root).

Check to make sure your permissions in INFORMIXDIR aren't hosed.  For
example, $INFORMIXDIR/lib/sqlexec mode bits and permissions should
be like this:

file $INFORMIXDIR/lib/sqlexec:
/usr/informix/lib/sqlexec:  ...  set-uid set-gid executable not stripped
ls -lsgt $INFORMIXDIR/lib/sqlexec:
 280 -rwsr-sr-x  1 root     informix   ...     /usr/informix/lib/sqlexec

>Has anybody else come across this?  If not, you have been forewarned.
>Note that this isn't a major problem, just an annoyance that the
>manual page didn't mention.

I'd consider it more than an annoyance ... if I could reproduce it.
I tested using ISQL version 2.10.03B, which shouldn't be any newer than
what you are running.  I also tried it in 4.00 - no problem there,
either.

>Michael Sullivan          uunet!jarthur!aqdata!sullivan

--
Alan S. Denney  @  Informix Software, Inc.       "We're homeward bound
aland@informix.com  {pyramid|uunet}!infmx!aland   ('tis a damn fine sound!)
-----------------------------------------------   with a good ship, taut & free
 Disclaimer:  These opinions are mine alone.      We don't give a damn, 
 If I am caught or killed, the secretary          when we drink our rum
 will disavow any knowledge of my actions.        with the girls of old Maui."