Re: Help New User!!

>From: arg@temss2.main.temple.edu (ARG Study) >Date: 8 Nov 1995 05:23:15 GMT >X-Informix-List-Id: <news.18668> > >hi >we have recently installed informix in our office .. the problem is >that after setting the dbpath and other environment variables , i was >able to run the demodatabase in informix and create a new database. when As user informix? That would probably work, even if the product was improperly installed. >i tried to run informix from another users database (after setting the same >variables) i was getting error no. 461. That error means either a problem with a blob file or with a system file. I've encountered that in conjunction with itoxmsg.pam, but that's a 6.0x (or later) problem. Have you got INFORMIXDIR set correctly? Have you got DBLANG set to anything? Did you install the products in the correct order: TEN (tools, engines, network) -- meaning ISQL/I4GL, then SE. >now the thing is that after >unsuccessfully tryin to get informix demodatabase to run on that person >account , i tried >running it on some other person's account and i could do that What could you run? ISQL? Or could you get at the database? >..the problem >is that i am able to run informix on some accounts and unable to do so on >som other accts..i am able to access isql and r4gl screens on the accounts of >everyone.. I think you should double-check the permissions on your installation. $INFORMIXDIR/etc/sefiles lists the permissions (owner, group (= informix) and mode) for each file and directory. Some of them must be owned by root and SUID root and SGID informix. If these are not correct, then you may get sporadic errors. No-one except user informix should be in group informix. This is imperative, but is another common mistake. However, see also the notes on NFS below -- that is almost certainly the real cause of your trouble. >second question .. >how do i give the grant command to other users ? i mean i did isql in the >dba account. it asked me to select a database name .i ignored it and went >on to query language menu and ran the command "grant connect to all" .. >i got an error regarding this saying that i haven't selected a database yet. You can only give privileges on a specific database -- you must have a database selected to be able to 'GRANT CONNECT TO PUBLIC'. Unless you have a user with login ID 'all', the syntax you quote will do no good as it grants connect privilege to a user called 'all'. >also is it possible to install the demodatabase in the dba acct.(the acct >which contains the informix directories ) i tried doing it and got the message >"licenced for local database only" (something similar)... Now you are running NFS mounted stuff, aren't you? Because of problems with NFS locking, if you try to create a database on an NFS-mounted file system, the database tries to use an SE engine on the host which has the file system as a local file system. Your licence doesn't allow you network access -- hence the error message. Create all databases on locally mounted file systems. If you need network access, you need to buy and install Informix-Net. And NFS systems use networks and therefore need network access. >We are running INFORMIX -SE 5.01 on sun os 4.1.3. the 4gl version is 4.1 >and the sql version is 4.1 again.. Which version of 4.1x, because you have a choice of 4.10, 4.11, 4.12, 4.13, 4.14 or 4.15. It actually doesn't matter in this case, but in general you should quote at least the 3 digits, and preferably the whole version number (eg 4.13.UD1). Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>