IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
Almost done with the polemics of the Java setup for InformixHQ but this is a different issue:
I am now in this screen:
I have the identical credentials for the admin section. My host name is maxwell2l. The group name is omni, containing 1 server named ol_first, which is set up in sqlhosts as a TCP connection. The port number, listed in both sqlhosts and /etc/services is 10091. These are entered in the above credentials (I didn't screen-capture the whole window). Now I click on [Test Connection]. I am rewarded with the following message:
[x] Could not connect to Informix: jdbc:informix-sqli://maxwell2l:10091: sysmaster. Incorrect password or user com.informix.asf.IfxASFRemoteException: informix@localhost[maxwell2l] is not known on the database server.]
Now I know the informix password so I'm not getting that wrong. I got similar result using admin and that password that I had set up in properties so I know that's not the issue.
Do I need to enter the informix (or admin) password in yet another config file? (Today's seminar didn't address HQ neophytes.)
So my question, as with the previous thread is: What am I missing?
Thanks much for help!
If your db server is AIX try this:
chmod o+x /etc/security
chmod o+r /etc/security/pwdalg.cfg
Hithe password set in the properties file of HQServer is ONLY for logging in into the HQ GUI.
What you see here is a standard "can't connect to the informix instance" error.And in most cases it really means that wrong password is used for user informix on machine maxwell2l.Is there a message in the message logfile? A message will confirm that the try to connect has reached the Informix Instance. What happens when you try to connect with dbaccess using informix and the password. Maybe you have dbaccess on another machine and you can try a remote login. What happens when you open up informix for the world with a + in .rhosts (just for a test).And not sure what informix@localhost[maxwell2l] here means exactly.I only have informix@myhost in the message when I enter a wrong password.
BTW the informix server name in the HQ GUI is not really relevant. It must not be a DBSERVERNAME/DBSERVERALIAS. It can help when it is the same.A java program only needs ip and port to connect to the instance.
It does not matter. The name will be used internally within HQ -It may help to identify the informix server when you have more then one set up in HQ when it is the same as DBSERVERNAME or DBSERVERALIAS.But it also can be a different name. The test in dbaccess must be with connect - user - password
If I may -- I Strongly discourage the use of the informix ID as the monitoring and administration ID. Since that is the ID that actually executes operations within the instance, that give all IHQ users greater levels of authorization than they deserve, possibly to their detriment. What you need to do is create two O/S IDs, such as ihq_monitor and ihq_admin and grant them the specific instance privileges they need then use them in the instance configuration scripts. The permissions required for ether ID are documented. If you've been to any of my classes where IHQ was used, part of the class exercises included granted the privileges. There is a script in the lab documentation (Appendix C) which shows the process. If you can't find it, contact me directly for a copy.