SIM Installation - Database Population failure

[Antonio Creus_1]

Hi,

I am running the script /opt/mx/bin/mxinitconfig -a and getting an error on the last step. The Database Population is showing a message of "Cannot start the service".

I also had a problem with the libjvm.sl (dld.sl failure) and included the SHLIB_PATH variable in the environment, containing where java1.4 has the libraries.

I have read through the Forum messages and noticed some problems with MySQL and Oracle. I have Oracle 9i installed. Is there a problem having both databases installed? Is there a fix?

Regards,

Antonio

[Rick Garland]

The HPSIM applicationn uses the 'postgreswl' database. Oracle and/or MySQL should have no effect.

Is the postgresql loaded? This is what the mxinitconfig is looking for.

[Kent Ostby]

Check the installation instructions for the order of SGL / SIM installation .

Is there anything using port 50000 beside HP SIM ?

[Antonio Creus_1]

There are three processes running:

postgres: stats collector process
postgres: stats buffer process
/opt/iexpress/postgresql/bin/postmaster -i -D /var/opt/iexpress/postgresql

Is there anything else I should verify?

[Rick Garland]

From the look of your previous post, I am believing you have SIM installed on HPUX.

Did you test the prerequisites?
mxinitconfig -l

Are the mxagent, mxdomainmgr, & mxdtf daemons running? If not start with 'mxstart' command.
ps -ef | grep mx


Do remember to configure the snmp.

[Rick Garland]

Just hit me, a place to look for log entries;

/var/opt/mx/logs/initconfig.log

What does it say in there?

[Antonio Creus_1]

The /opt/mx/bin/mxinitconfig -l ran without errors.

The /opt/mx/bin/mxinitconfig -a finishes with a warning on the Database Population step. It indicates that it can not start the service.

I have attached the log file.

It also tries to launch the mx processes but all three die almost immediately.

Regards,

Antonio

[Rick Garland]

In the same directory is a file called 'mx.log'
What does this file say? Is there any clue why the mx services will not run?

[Antonio Creus_1]

There is no mx.log in that directory. I can only see two files, PgSQL_Config.log and initconfig.log.

[Rick Garland]

Does the /var/adm/syslog/syslog.log file have any entries related to mx?

Search the syslog file for 'mx'.

[Antonio Creus_1]

The syslog.log file did not have any entries for any of the mx services.

When I run the mxstart script, all three mx processes start. After a couple of seconds the processes die and I get a "Command is respawning too rapidly. ....." message in the console.

[Rick Garland]

Check the following:

Document description: INIT: Command is respawning too rapidly. id:samd
Document id: USAMKBRC00007275
http://www4.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000062922569

Looks like you have some network/hostname problems


Doc. id = UXDNKBRC00000918 about the subject (it will teach you how to boot in single user mode and identify the issue...):
http://www4.itrc.hp.com/service/cki/search.do?category=c0&mode=text&searchString=On+earlier+700%27s&searchCrit=exactphrase&docType=Security&docType=Patch&docType=EngineerNotes&docType=BugReports&docType=Hardware&docType=ReferenceMaterials&docType=ThirdParty&search.x=22&search.y=11

[Jan_95]

Hi Antonio,

I had the same frustrating problem as you have, but I think I figured this one out.

In the beginning mxinitconfig -a was slow to start and failed at the very last step.

I am running an iptables firewall on my CMS.
So when I added a rule specifying that the CMS should accept packages from itself through its public IP, not only 127.0.0.1, things started happening.

My rule is: iptables -A INPUT -s public-IP-of-CMS -j ACCEPT