SIM5.0.2 hpux mxinitconfig -a error configuring database

[art moore_2]

hello,
im trying to install SIM 5.0.2 on an rx2620 with hpux 11iv2.
before the swinstall i removed the mx directories.
rm -fr /opt/mx /etc/opt/mx

configuring SIM i get the following output:
rxdemo4 #
rxdemo4 # mxinitconfig -a
Checking Requisites (14):
1. Check Kernel Parameters ...OK
2. Server Property File ..OK
3. Server Authentication Keys ..OK
4. SSH Keys ..OK
5. Status Property File ..OK
6. Task Results Output Cleanup ..OK
7. Database Configuration ...OK
8. Database Content ..OK
9. Web Server ..OK
10. Setup Property File ..OK
11. JBoss Setup ..OK
12. Agent Configuration ..OK
13. Management Services ..OK
14. Initialization and Database Population ..OK
Requisite scan completed successfully.

Configuring Server Components (14):
1. Check Kernel Parameters ..Done
2. Server Property File ..Done
3. Server Authentication Keys ..Done
4. SSH Keys ..Done
5. Status Property File ..Done
6. Task Results Output Cleanup ..Done
7. Database Configuration ...Failed
Details can be found in the log file at /var/opt/mx/logs/initconfig.log
Configuration failed to complete due to the following exception:
Cannot connect to database, exception: com.hp.mx.core.repository.MxConnectionException: Connection to the repository server failed.
To diagnose PostgreSQL problems, please read PostgreSQL log file:
/var/opt/hpsmdb/pgsql/pgsql.log
If the log file is empty or nonexisting, please see your PostgreSQL administrator.


rxdemo4 # more /var/opt/hpsmdb/pgsql/pgsql.log
/opt/hpsmdb/pgsql/bin/pg_ctl[70]: /dev/null: Cannot create the specified file.
/opt/hpsmdb/pgsql/bin/pg_ctl[82]: /dev/null: Cannot create the specified file.
FATAL: "/var/opt/hpsmdb/pgsql" is not a valid data directory
DETAIL: File "/var/opt/hpsmdb/pgsql/PG_VERSION" is missing.
/opt/hpsmdb/pgsql/bin/pg_ctl[375]: /dev/null: Cannot create the specified file.
postmaster successfully started
/opt/hpsmdb/pgsql/bin/pg_ctl[70]: /dev/null: Cannot create the specified file.
/opt/hpsmdb/pgsql/bin/pg_ctl[82]: /dev/null: Cannot create the specified file.
/opt/hpsmdb/pgsql/bin/pg_ctl[375]: /dev/null: Cannot create the specified file.
postmaster successfully started
FATAL: "/var/opt/hpsmdb/pgsql" is not a valid data directory
DETAIL: File "/var/opt/hpsmdb/pgsql/PG_VERSION" is missing.
rxdemo4 #

any ideas ?
thanks,
Art Moore

[Per Christensen_1]

Hi Art

Had the same problem until I tried to run initdb script as hpsmdb user.
My problem was ownership and permissions on /var/opt/hpsmdb directory. Changed it to hpsmdb as owner and rwx perms for hpsmdb.
Now I can get on with the configuration.
Cheers Per

[Arvin E.]

YES, it worked!

except I dont have hpsmdb user, so I created it and changed owner of /var/opt/hpsmdb from root to hpsmdb user.

Thanks!