Connect failed in Informix.2000 of Linux
jingker cheng installed IDS 2000 on RedHat 6.1 Linux; dbaccess worked locally but CONNECT, even as informix, failed with a password error (-952), as did Client SDK. Art Kagel asked about shadow passwords or PAM, which cause connection problems, and advised reverting to the standard password file. Mike Segel and Ronald Cole criticised the lack of PAM support. No confirmed fix.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi,ALL :
I have installed IDS2000 on Linux (RedHat6.1). Installation
is successful. I can use "dbaccess" to select data from databases.
But I cannot use the "connect" function in dbaccess to connect
my server itself successfully. I always get the "User's password is
not correct for the database server" message even use the
userid "informix". I cannot connect my database server using
Client SDK,either(error message is the same, sqlerr=-952).
Does anyone know what's wrong ? Thank you.
PS. I can use "dbaccess" to select data from remote server
successfully.
Jung-Hui Cheng
cheng@dbtel.com.tw
In article <383A8AF4.8AFADC1E@smtp.dbtel.com.tw>,
jingker cheng <jingker.cheng@smtp.dbtel.com.tw> wrote:
> Hi,ALL :
>
> I have installed IDS2000 on Linux (RedHat6.1). Installation
> is successful. I can use "dbaccess" to select data from databases.
> But I cannot use the "connect" function in dbaccess to connect
> my server itself successfully. I always get the "User's password is
> not correct for the database server" message even use the
> userid "informix". I cannot connect my database server using
> Client SDK,either(error message is the same, sqlerr=-952).
> Does anyone know what's wrong ? Thank you.
>
> PS. I can use "dbaccess" to select data from remote server
> successfully.
Are you using shadow passwords or PAM? There has been a problem
connecting to the engine if shadowing or PAM are used. If you are
doing so, revert to standard password file use.
Art S. Kagel
Sent via Deja.com http://www.deja.com/
Before you buy.
Hmmm that would imply that Informix isn't using std C calls to get access
to the passwd info and instead is trying to do a quick and dirty check
against etc/passwd.
-G
kagel@bloomberg.net wrote:
> In article <383A8AF4.8AFADC1E@smtp.dbtel.com.tw>,
> jingker cheng <jingker.cheng@smtp.dbtel.com.tw> wrote:
> > Hi,ALL :
> >
> > I have installed IDS2000 on Linux (RedHat6.1). Installation
> > is successful. I can use "dbaccess" to select data from databases.
> > But I cannot use the "connect" function in dbaccess to connect
> > my server itself successfully. I always get the "User's password is
> > not correct for the database server" message even use the
> > userid "informix". I cannot connect my database server using
> > Client SDK,either(error message is the same, sqlerr=-952).
> > Does anyone know what's wrong ? Thank you.
> >
> > PS. I can use "dbaccess" to select data from remote server
> > successfully.
>
> Are you using shadow passwords or PAM? There has been a problem
> connecting to the engine if shadowing or PAM are used. If you are
> doing so, revert to standard password file use.
>
> Art S. Kagel
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Mike Segel <mikey@NOSPAM.KING.OF.MY.DOMAIN.MAPSON.Segel.com> writes: > Hmmm that would imply that Informix isn't using std C calls to get access > to the passwd info and instead is trying to do a quick and dirty check > against etc/passwd. More than that, it means that Informix.2000 for Linux will not be PAM- aware. Crippling the OS security to get database security should be optional, not mandatory! That free copy of Sybase or Oracle for Linux is looking better... -- Forte International, P.O. Box 1412, Ridgecrest, CA 93556-1412 Ronald Cole <ronald@forte-intl.com> Phone: (760) 499-9142 President, CEO Fax: (760) 499-9152 My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084 4A88 8851 E6C8 69E3 B00B