Informix

nested-group-icon.png

DB2

Expand all | Collapse all

informix@IP: Incorrect password or user informix@IP is not known on the database server.

  • 1.  informix@IP: Incorrect password or user informix@IP is not known on the database server.

    Posted Thu May 28, 2020 09:48 AM
    Hi Members,

    just joined 'cos I can't seem to work this one out. Been searching the Internet, but no solution that works for me.

    We are running Informix 10 on windows server 2003 in an AD domain. Yes, I know it is old, both Informix and Windows, but we cannot upgrade just yet.

    For the upgrade possibility to come in sight, I have set up a separate environment with a DC running a separate Windows domain, and a windows 2003 server as a member. The "informix" user is a domain user and groups such as Informix-Admin are set up. The database was backed up in production (which is a different windows domain) and restored in the test environment. Dbaccess, onstat, etc all work, as user administrator and informix. IDS runs as the domain user informix. I can auth to the domain as user informix as well (with RDP for example).

    But when I try to connect over the network as user informix, I get that the password is incorrect or the user is unknown. IDS logs:

    11:29:42 listener-thread: err = -951: oserr = 0: errstr = informix@192.168.212.150: Incorrect password or user informix@192.168.212.150 is not known on the database server.

    There is communication with the DC (tcpdump shows connections over port 445), group membership is requested and returned, but no dice. As far as I understand the concepts, the registry on the domain member also contains correct entries for IDS.

    Can someone point me to the right direction?

    Thanks and best regards,
    Arjen Van Drie,
    Antwerp, Belgium.

    ------------------------------
    Arjen Van Drie
    ------------------------------


  • 2.  RE: informix@IP: Incorrect password or user informix@IP is not known on the database server.

    Posted Thu May 28, 2020 10:02 AM

    Arjen,

     

     

    This user is not authenticated on the database server, this is why you have this error.

    Considering you run V10, which is very old yes, you should on one side authenticate the client host on the server machine at OS level: no clue on how to do this on windows. In unix this would be hosts.equiv

    Then you should authenticate the USER on the server. In unix, this is filling the client name in the server, home directory of the user; in the .rhosts file.

     

    If you had 12.10 or 14.10, you could use 2 files in $INFORMIXDIR/etc/ that you declare in the ONCONFIG file. This is much more simple to handle.

    Hoping a windows specialist will help here

     

    Regards

    Eric

     






  • 3.  RE: informix@IP: Incorrect password or user informix@IP is not known on the database server.

    Posted Thu May 28, 2020 10:41 AM
    Edited by Martin Graney Thu May 28, 2020 10:41 AM

    Arjen:

    As Eric had said you should actually be able to use the hosts.equiv file to get around the issue you are seeing.  On a Windows server this would be created by you in:  "C:\Windows\System32\drivers\etc\hosts.equiv".  In this file you can list the system in question 192.168.212.150.  This should then allow connections from 192.168.212.150 to the Informix instance.  I do not recommend this as a permanent solution as it somewhat circumvents the Windows pass-through authentication security. 

    Is there a reason that the system is showing up as an IP (192.168.212.150) rather than the system name or a FQDN?  This may be one issue.  I have found that Informix is always happier when DNS is working.

    Also, I would check the Windows Server's Security event log on the system hosting the Informix instance to see if there are any entries referencing the authentication error.  This will give you a better idea of why your domain user is not being authorized to connect to the Informix server.



    ------------------------------
    Best regards,
    Martin Graney
    Queues Enforth Development, Inc.
    Stoneham, MA 02148
    ------------------------------



  • 4.  RE: informix@IP: Incorrect password or user informix@IP is not known on the database server.

    Posted Thu May 28, 2020 11:26 AM
    Hello Eric, Martin,

    I have tried (just now) hosts.equiv with therein the client IP address; the error remains.

    The reason why DNS doesn't work is because I connect from a different subnet. The subnet in which is the windows server running IDS does not know (as far as name resolving) about any other subnet. It is the router in between that allows access on a network level.

    The Security event log shows that authentication for user informix succeeds.

    Currently comparing the registry...

    Thanks,
    Arjen.

    ------------------------------
    Arjen Van Drie
    ------------------------------



  • 5.  RE: informix@IP: Incorrect password or user informix@IP is not known on the database server.

    Posted Thu May 28, 2020 04:21 PM
    Hi again,

    I have crawled through the registry and compared it with production, looks pretty much similar. Accounts, SQLHOSTS, Groups, it is all in there.

    Could somewhere in the restored database itself be a reference to the production environment where it is coming from, being a different windows domain than the separate testing env?

    Regards,
    Arjen.

    ------------------------------
    Arjen Van Drie
    ------------------------------



  • 6.  RE: informix@IP: Incorrect password or user informix@IP is not known on the database server.

    Posted Thu May 28, 2020 04:29 PM
    Arjen:

    This is definitely some kind of trusted host issue.

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.








  • 7.  RE: informix@IP: Incorrect password or user informix@IP is not known on the database server.

    Posted Fri May 29, 2020 05:44 AM
    Thank you all for replying,

    I have now tried a connection from a host within the same subnet, where reverse DNS works, with an entry in C:\WINDOWS\system32\drivers\etc\hosts.equiv like so:

    st98svr1.uat.gugu.be informix

    but still

    11:37:24 listener-thread: err = -951: oserr = 0: errstr = informix@st98svr1.uat.gugu.be: Incorrect password or user informix@st98svr1.uat.gugu.be is not known on the database server.

    I am at a loss for the moment...

    ------------------------------
    Arjen Van Drie
    ------------------------------



  • 8.  RE: informix@IP: Incorrect password or user informix@IP is not known on the database server.

    Posted Fri June 05, 2020 10:52 AM

    Hi!

    How do you try to connect to the database server? 

    dbaccess/jdbc/odbc?

    Have you tried to connect with "DOMAIN\informix"?




    ------------------------------
    Kind Regards
    Stefan
    ------------------------------



  • 9.  RE: informix@IP: Incorrect password or user informix@IP is not known on the database server.

    Posted Fri June 05, 2020 11:01 AM
    Hi Stefan,

    thanks for picking this up, still no success here. Currently I am trying to connect with jdbc (squirrel SQL). I am 100% certain that the jdbc connection string is correct.

    I have tried with GUGUAT\informix, no go...

    Currently building an entirely new w2k3r2 domain member with a virgin registry.

    Best,
    Arjen.

    ------------------------------
    Arjen Van Drie
    ------------------------------



  • 10.  RE: informix@IP: Incorrect password or user informix@IP is not known on the database server.

    Posted 28 days ago
    Hi Arjen,

                 I also had the same issue earlier with same error. In my case someone had changed the password for unix user which was the bridge between Informix and .Net Application (SQL Server authentication) .

    Not sure same issue , but please try to check the user password and Informix privilege. 


    Regards
    Amit Patel

    ------------------------------
    AMIT PATEL
    ------------------------------