Authentication difficulty in BD Informix

Question

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

However I am having difficulty connecting. I am 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 seems he’s denying connection to my machine.

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

Answer 1

Apparently you are giving the wrong password to the Informix user.

If you want to free access, "no password", you need to set your host to reliable. This can be done in some ways, but it depends on which platform and which version you are using;

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

• Add a new line to the file /etc/hosts.equiv the IP of your machine.
  You can try with hostname, but it has great chances of not working.
  This method is valid at operating system level, it can end up freeing other types of machine access.
  The effect is immediate.

If using windows the hosts.equiv file is in the folder %windir%\system32\drivers\etc. if it does not 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 hosts.equiv of the S.O. 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 Informix user, on the database server :
  onmode -wf REMOTE_SERVER_CFG=arquivoxyz