Re: informix not known

Hi, How do you connect to database server? Try dbaccess -> Connection -> Connect -> select server name -> enter informix/informixpassword. Does it connect? In fact, in my understanding it shouldn't have anything with system tables, since database server uses operation system authentication. Some stupid questions: 1. Are you sure you are connecting to the right database server on the right unix server (it is the most stupid question, but it could be the answer to the problem). 2. Check the informix server log. It should contain lines with something like: 13:25:37 listener-thread: err = -952: oserr = 0: errstr = : User's password isnot correct for the database server. Are there these lines (or may be other lines that can enlighten the situatuion)? Best Regards, Octav On Sun, Oct 03, 1999 at 10:19:15AM +0000, Gerhard Quell wrote: > Hi Michael, > > thank your for anser. > > I can login directly as User informix on UNIX. I changed the informix pass- > word without any result. Only the database engine answered unknown login. > > My next idea is to unload the database with dbexport and with the logins of > the db-users. It is a very long solution because there more than 20GByte > data in the db. I think our backup-system is in the same state. I think > that this is a problem of a system-table, but i couldn't look in the tables. > > > Gerhard > > Michael Krzepkowski wrote: > > Hi! > > Can you login directly to Unix as informix with the password you are using? > > If not, have user root (your system administrator) assign a new password to > > informix. > > HTH > > Michael > > -- > --------- SKE - Gerhard Quell - Institut f'r angewandten Nexialismus -------- > Moorstr. 7 eMail: gquell@skequell.de Fon: 05136-970009 > 30916 Isernhagen web : http://www.skequell.de Fax: 05136-970008 > ------------------------------------------------------------------------------ -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com

Hello Octav, today i took a complete backup with dbexport. After this i install the new 7.31 IDS engine in the same directory as the old 7.30. After the installation i started the engine. I can login as informix into the database and all looks very fine. My problem is, that i don't know what happened. Octav Chiriac wrote: > Hi, > How do you connect to database server? Try > dbaccess -> Connection -> Connect -> select server name -> > enter informix/informixpassword. Yes, i did. ------------- > Does it connect? No. ------------- > In fact, in my understanding it shouldn't have anything with > system tables, since database server uses operation system > authentication. I think too, but i can login into the solaris ------------- > > Some stupid questions: > 1. Are you sure you are connecting to the right database > server on the right unix server (it is the most stupid question, > but it could be the answer to the problem). Yes. ----------- > 2. Check the informix server log. It should contain lines > with something like: > 13:25:37 listener-thread: err = -952: oserr = 0: errstr = : User's password is> not correct for the database server. > Are there these lines (or may be other lines that can enlighten > the situatuion)? The online.log line: 951: Incorrect password or user informix is not known on the database server. -----------What is the problem, do you think? Best Regards and thank you for your help Gerhard --------- SKE - Gerhard Quell - Institut für angewandten Nexialismus -------- Moorstr. 7 eMail: gquell@skequell.de Fon: 05136-970009 30916 Isernhagen web : http://www.skequell.de Fax: 05136-970008 ------------------------------------------------------------------------------