Informix

Hi,

  I am learning InformixHQ. I was practicing adding a server and deploy agent to it. When I added the server, I specified informix as the monitor admin credential and root as the admin credential. I signed out and am not able to login any more, no matter if I used the initial password, the monitor admin credential or the admin credential. Wonder how I could regain access the the InformixHQ. Your advice would be really appreciated.

Regards,

Jim

Hi,

  I am learning InformixHQ. I was practicing adding a server and deploy agent to it. When I added the server, I specified informix as the monitor admin credential and root as the admin credential. I signed out and am not able to login any more, no matter if I used the initial password, the monitor admin credential or the admin credential. Wonder how I could regain access the the InformixHQ. Your advice would be really appreciated.

Regards,

Jim

I assume you've been reading the documentation, correct? Unfortunately required start up information is not well organized and some is buried quite deep in another topic.

As Hedwig states, there is a Master IHQ admin ID. This is called admin and the password was set in the IHQ server properties file. If you forgot what the password is, shutdown the IHQ server/agents, erase the little flatfile database in the IHQ directory, set a new password in the server property file, start the IHQ server again. It will create a new database and you're back to the beginning.

With the IHQ Master ID, you can administer two other "classes" of IDs. The first class are the IDs which actually do the work in IHQ. these are the IDs set for instances for administration and monitoring. NEITHER SHOULD INFORMIX. Because these IDs are connecting to the instance, they must be "real" IDs in the O/S for authentication. There are additional requirements for these IDs documented Here.  You can use the same IDs for multiple instances on the same or other servers if you want.

Finally the second ID class are the IHQ end user IDs and these are defined wholly within IHQ. They do not need O/S authentication since they never connect to the instances, the admin/monitor IDs do the work for them. These IDs are created by the IHQ Master Admin ID.

Hopefully this helps understand the different IDs and how they interact.

Hi,

  I am learning InformixHQ. I was practicing adding a server and deploy agent to it. When I added the server, I specified informix as the monitor admin credential and root as the admin credential. I signed out and am not able to login any more, no matter if I used the initial password, the monitor admin credential or the admin credential. Wonder how I could regain access the the InformixHQ. Your advice would be really appreciated.

Regards,

Jim

Hedwig and Calton,

    Thanks very much for your help.  After resetting the initialAdminPassword, I have able able to login now.

    Regarding the first of the the two classes, namely monitoring and administration mentioned by Calton, I assumed that I would have to take two steps: (1) create account in the OS and (2) grant needed access levels to required databases per subtype (i.e., monitoring or administration) using dbaccess scripts. Am I reading it correctly?

I assume you've been reading the documentation, correct? Unfortunately required start up information is not well organized and some is buried quite deep in another topic.

As Hedwig states, there is a Master IHQ admin ID. This is called admin and the password was set in the IHQ server properties file. If you forgot what the password is, shutdown the IHQ server/agents, erase the little flatfile database in the IHQ directory, set a new password in the server property file, start the IHQ server again. It will create a new database and you're back to the beginning.

With the IHQ Master ID, you can administer two other "classes" of IDs. The first class are the IDs which actually do the work in IHQ. these are the IDs set for instances for administration and monitoring. NEITHER SHOULD INFORMIX. Because these IDs are connecting to the instance, they must be "real" IDs in the O/S for authentication. There are additional requirements for these IDs documented Here.  You can use the same IDs for multiple instances on the same or other servers if you want.

Finally the second ID class are the IHQ end user IDs and these are defined wholly within IHQ. They do not need O/S authentication since they never connect to the instances, the admin/monitor IDs do the work for them. These IDs are created by the IHQ Master Admin ID.

Hopefully this helps understand the different IDs and how they interact.

Hi,

  I am learning InformixHQ. I was practicing adding a server and deploy agent to it. When I added the server, I specified informix as the monitor admin credential and root as the admin credential. I signed out and am not able to login any more, no matter if I used the initial password, the monitor admin credential or the admin credential. Wonder how I could regain access the the InformixHQ. Your advice would be really appreciated.

Regards,

Jim

Yes, that is correct.  Don't forget the admin ID has to be part of the DBSA group so you'll have to modify that ID and add it into group informix. Good luck.

p.s. here's the script I use. My O/S /IHQ worker IDs are called ihq_admin and ihq_monitor for obvious reasons.

set_perms.bsh

#!/bin/bash

echo ""

echo "Setting permissions in the sysadmin database"

echo ""

dbaccess sysadmin - <<EOF1

grant connect to ihq_mon_user;

grant connect to ihq_admin_user;

grant select on ph_task to ihq_mon_user;

grant select on ph_run to ihq_mon_user;

grant select on ph_alert to ihq_mon_user;

grant select on ph_bg_jobs to ihq_mon_user;

grant select on ph_bg_jobs_results to ihq_mon_user;

grant select on ph_threshold to ihq_mon_user;

grant select on ph_task to ihq_admin_user;

grant select on ph_run to ihq_admin_user;

grant select on ph_alert to ihq_admin_user;

grant select on ph_bg_jobs to ihq_admin_user;

grant select on ph_bg_jobs_results to ihq_admin_user;

grant select on ph_threshold to ihq_admin_user;

EOF1

echo ""

echo ""

echo "Setting permissions in the sysmaster database"

echo ""

dbaccess sysmaster - <<EOF2

grant connect to ihq_mon_user;

grant connect to ihq_admin_user;

grant select on sysconblock to ihq_mon_user;

grant select on syssqltrace to ihq_mon_user;

grant select on syssqltrace_info to ihq_mon_user;

grant select on syssqltrace_hvar to ihq_mon_user;

grant select on syssqltrace_iter to ihq_mon_user;

grant select on sysconblock to ihq_admin_user;

grant select on syssqltrace to ihq_admin_user;

grant select on syssqltrace_info to ihq_admin_user;

grant select on syssqltrace_hvar to ihq_admin_user;

grant select on syssqltrace_iter to ihq_admin_user;

EOF2

echo ""

echo "Permissions set!"

Hedwig and Calton,

    Thanks very much for your help.  After resetting the initialAdminPassword, I have able able to login now.

    Regarding the first of the the two classes, namely monitoring and administration mentioned by Calton, I assumed that I would have to take two steps: (1) create account in the OS and (2) grant needed access levels to required databases per subtype (i.e., monitoring or administration) using dbaccess scripts. Am I reading it correctly?

I assume you've been reading the documentation, correct? Unfortunately required start up information is not well organized and some is buried quite deep in another topic.

As Hedwig states, there is a Master IHQ admin ID. This is called admin and the password was set in the IHQ server properties file. If you forgot what the password is, shutdown the IHQ server/agents, erase the little flatfile database in the IHQ directory, set a new password in the server property file, start the IHQ server again. It will create a new database and you're back to the beginning.

With the IHQ Master ID, you can administer two other "classes" of IDs. The first class are the IDs which actually do the work in IHQ. these are the IDs set for instances for administration and monitoring. NEITHER SHOULD INFORMIX. Because these IDs are connecting to the instance, they must be "real" IDs in the O/S for authentication. There are additional requirements for these IDs documented Here.  You can use the same IDs for multiple instances on the same or other servers if you want.

Finally the second ID class are the IHQ end user IDs and these are defined wholly within IHQ. They do not need O/S authentication since they never connect to the instances, the admin/monitor IDs do the work for them. These IDs are created by the IHQ Master Admin ID.

Hopefully this helps understand the different IDs and how they interact.

Hi,

  I am learning InformixHQ. I was practicing adding a server and deploy agent to it. When I added the server, I specified informix as the monitor admin credential and root as the admin credential. I signed out and am not able to login any more, no matter if I used the initial password, the monitor admin credential or the admin credential. Wonder how I could regain access the the InformixHQ. Your advice would be really appreciated.

Regards,

Jim