Hype ric server is not able to start

[amit_patil]

Hi All,

I have installed open-source postgresql 9.1 database and after that i have installed Hyperic Server 4.6 but while starting HQ server i am unable to start it

ERROR [WrapperStartStopAppMain] [org.hyperic.bootstrap.ProcessManagerImpl@119] Command did not execute successfully (exit code = 1)

ERROR [WrapperStartStopAppMain] [org.hyperic.bootstrap.HQServer@212] Error verifying if HQ schema is valid.  url= jdbc:postgresql://localhost:5432/hyperic?protocolVersion=2, Cause: org.postgresql.util.PSQLException:

Please help me

Please let me know if more information is required.

Thanks & Regards

Amit Patil

[MayanW]

Hi Amit,

you should move to Hyperic 5.0.0

Hyperic 4.6.x works only with postgres 8.2

[amit_patil]

Thanks Mayan . I will install Hyperic 5  .

[amit_patil]

Hi Mayan,

I am getting below error after installing Hyperic 5.0.0 in bootstrap.log file

2013-04-09 12:07:02,345 ERROR [main] [org.apache.tools.ant.UnknownElement@135] Task "dbupgrade" finished with error.
/opt/hyperic/server-5.0.0-EE/data/db-upgrade.xml:43: Error loading jdbc driver: jdbc:postgesql://(I/P -- This i have edited):5432/hyperic: java.lang.ClassNotFoundException: jdbc:postgesql://192.168.61.13:5432/hyperic
        at org.hyperic.tools.ant.dbupgrade.DBUpgrader.validateAttributes(DBUpgrader.java:282)

Thanks & Regards

Amit Patil

[admin]

Did you create the 'hyperic' schema before the installation?

[amit_patil]

Yes .

[admin]

What is the value of the server.database-url property inside the hq-server.conf file?

[amit_patil]

Location of file is /opt/hyperic/server-5.0.0-EE/conf

and entry in hq-server.conf

# The JDBC URL to connect to.
server.database-url=jdbc:postgesql://192.168.61.13:5432/hyperic

[admin]

And of the server.database-driver property?

[amit_patil]

server.database-driver=org.postgresql.Driver

[admin]

It seems that you have a typo in the jdbc url (you missed the r in postgresql) -

server.database-url=jdbc:postgesql://192.168.61.13:5432/hyperic

should be -

server.database-url=jdbc:postgresql://192.168.61.13:5432/hyperic

[amit_patil]

Yes .. i missed that. Thanks Mayan ...

I will remove Hyperic and install it again.

Will let you know if its sucessfull this time.

[admin]

BTW, why did you manually edit the configuration file after the installation?

[amit_patil]

I have actually created the file and kept at /etc/vmware/vfabric/hyperic Directory

And installed Hyperic using rpm. So that it will refer to my created vfabric_hyperic_server.properties

[admin]

I see, did the typo fix work?

[amit_patil]

Yes it worked but now stuck in another error.

Error loading starting schema version: org.postgresql.util.PSQLException: ERROR: relation "eam_config_props" does not exist
  Position: 15

[admin]

Can you look at the database and see if the 'hyperic' schema contains tables? If yes, see if the 'eam_config_props' table exists.

The installer should create this table if the db values in the properties file located in /etc/vmware/vfabric/hyperic are correct.

[amit_patil]

No there are no tables in hqadmin shcema. My database name is hyperic.

### Do you accept the terms of the agreement?
HQ_ACCEPT_EULA=y

### HQ server installation path
HQ_SERVER_INSTALL_PATH=/opt/hyperic

### email address that HQ will use as the sender for email messages
HQ_SENDER_EMAIL_ADDRESS=hqadmin@vmware.com

### database type of [mysql|oracle|postgesql]
HQ_DB_TYPE=PostgreSQL

### JDBC connection URL for HQ database
HQ_DB_URL=jdbc:postgresql://192.168.61.13:5432/hyperic

### username to use to connect to the database
HQ_DB_USERNAME=hqadmin

### password to use to connect to the database
HQ_DB_PASSWORD=hqadmin

### encryption key to use to encrypt the database password
HQ_DB_CRYPT_KEY=12345678

### username be for the initial admin user
HQ_ADMIN_USER=hqadmin

### password be for the initial admin user
HQ_ADMIN_PASSWORD=hqadmin

### email address be for the initial admin user
HQ_ADMIN_EMAIL_ADDRESS=hqadmin@vmware.com

### HQ server installation profile [small|medium|large]
HQ_SERVER_INSTALLATION_PROFILE=small

This is properties file.

[admin]

Can you attache the installer log?

[amit_patil]

hq-install.log is attach.

I removed the Hyperic server installation and did the installation again.

now the error is

ERROR [W-rapperStartStopAppMain] [org.hyperic.bootstrap.HQServer@205] HQ DB schema is in a bad state: 'No CAM_SCHEMA_VERSION property found'. This is most likely due to a failed upgrade.  Please either restore from backups and start your previous version of HQ or contact HQ support.  HQ cannot start while the current DB Schema version is in this state