Re: Help! Can't start isql as non-root user.
Posted in 1996
Michael L Bendickson (bendi003@maroon.tc.umn.edu) wrote: : Ok. We've been using INFORMIX-SE and INFORMIX-SQL 4.00.UE1 for Interactive : 86/ix ("INTER./IX 386 2.2" is the label on the disk), but we're now going : to Solaris x86 2.4. I've installed the SE and SQL software on our Solaris x86 : system, and it seems to work fine as root, but I get the following error when : starting isql as a non-root user: : INFORMIX-SQL Version 4.00.UE1 : : 350: Index already exists on column. Are you using Yellow Pages (NIS)? If so, then this is a very old bug. But then, you're on a very old version. The bug is fixed in I-SQL 4.12. You can work around it by putting an entry for the user in the local /etc/passwd, or as a variation on this workaround, add the following entry in the local /etc/passwd: +username::0:0::: This allows the user to still use all the info from yp, but establishes the account locally as well. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park, on a break from Beijing ----