database – Difficulty of authentication in BD Informix

Question:

I need to develop a small report on a legacy basis with Informix database (this is the first time I work with Informix).

But I'm having trouble connecting. I'm getting the following error:

Connection failed: Incorrect password or user com.informix.asf.IfxASFRemoteException: informix@<user of my local machine> is not known on the database server.

It looks like it is denying connection to my machine.

How do I release access or disable this authentication step (the base is not production)?

Answer:

Apparently you are entering the wrong password of the informix user.

If you want to grant access, "no password" , you need to configure your host as trusted. This can be done in a couple of ways, but it depends on what platform and what version you are using;

Most basic, easy and fast method, in Linux/Unix:

  • Add a new line in the /etc/hosts.equiv file to your machine's IP.
    You can try with the hostname, but chances are it won't work.
    This method is valid at the operating system level, it can end up releasing other types of access to the machine.
    The effect is immediate.

If you are using windows the hosts.equiv file is in the %windir%\system32\drivers\etc . if it doesn't exist, it can create.

If you are using a newer version of the database, version 11.70 or higher, you do not need to change the OS hosts.equiv, you can use the specific version of the database:

  • change the parameter REMOTE_SERVER_CFG <nome_arquivo> where will be a file you will create in the $INFORMIXSERVER/etc folder, following the same pattern as hosts.equiv.
    To change the parameter, with user informix, on the bank server:
    onmode -wf REMOTE_SERVER_CFG=arquivoxyz
Scroll to Top