problem with postgresql startup, during installation.

[nayyares]

Hi All,

I am installing Hyperic Server 3.1.4 on solaris 10 machine, the setup.sh starts fine initially but when it reaches to Postgresql (built-in database) startup it fails. i am running installation script with non-root user i.e. hq.

Preparing to install...
Validating server install configuration...
Checking server webapp port...
Checking server secure webapp port...
Checking server JRMP port...
Checking server JNP port...
Verifying admin user properties
Validating server DB configuration...
Installing the server...
Unpacking server to: /etc/hyperic/server-3.1.4...
Creating server configuration files...
Copying binaries and libraries to server installation...
Copying server configuration file...
Copying server control file...
Copying server binaries...
Copying server libs...
Setting up server database...
Setting up JDBC driver...
Copying database files...
Configuring database...
Starting repopulation of configuration table...
Starting built-in database...
Waiting for built-in database to start (on port 9432)...
--------------------------------------------------------------------------------
An ERROR occurred, the installation cannot continue.

An error occurred trying to start the HQ built-in database. More
information may be available in the /etc/hyperic/server-3.1.4/logs/hqdb.log file.
--------------------------------------------------------------------------------
Waiting for server to stop...
Stopping built-in database...
--------------------------------------------------------------------------------
An ERROR occurred, the installation cannot continue.
FATAL EXCEPTION at /export/home/hq/hyperic-hq-installer/installer-3.1.4/data/setup.xml:434: : The following error occurred while executing this line:
/export/home/hq/hyperic-hq-installer/installer-3.1.4/data/setup.xml:440: The following error occurred while executing this line:
/export/home/hq/hyperic-hq-installer/installer-3.1.4/data/setup.xml:554: The following error occurred while executing this line:
/export/home/hq/hyperic-hq-installer/installer-3.1.4/data/setup-db-PostgreSQL.xml:153: The following error occurred while executing this line:
/export/home/hq/hyperic-hq-installer/installer-3.1.4/data/setup-db-PostgreSQL.xml:194: The following error occurred while executing this line:
/etc/hyperic/server-3.1.4/data/server.xml:168: exec returned: 1

even when i checked "/etc/hyperic/server-3.1.4/logs/hqdb.log file." i got this error !

pg_ctl: cannot be run as root
Please log in (using, e.g., "su") as the (unprivileged) user that will
own the server process.

but i am running installation script with non-root user i.e. hq.

please help me out....

thanks

[excowboy]

Hi,

are you trying to install hyperic-hq-installer-3.1.4-504-sparc-solaris.tgz ?
Could you please post your /etc/hyperic/server-3.1.4/logs/hqdb.log file ?
As a workaround, could you use an external database ? Documentation howto setup an external DB can be found here:
http://support.hyperic.com/confluence/display/DOCSHQ30/Database+Preparation

Cheers,
Mirko

P.S. I've just installed hyperic-hq-installer-3.1.4-504-sparc-solaris.tgz on Solaris 10 without any problems.


Message was edited by: excowboy

[Ray_hyperic]

I am having the same exact trouble on a 3.1.4 install on linux (centos 4.5). My hqdb.log file reads:

pg_ctl: PID file "/home/hqexte5/hyperic/server-3.1.4/hqdb/data/postmaster.pid" does not exist
Is postmaster running?


Please advise. Thanks.

[excowboy]

Sorry, but did you try to run the installer as root - user ?

Mirko

[Ray_hyperic]

Yes, I tried to install as root. But the setup.sh script complained that I should not run it as root and ended suggesting that I run it as a non-root user. I believe the issue is an underlying security lock down on the box,either TCP port restriction or a permission issue with the creation of the PID file. I am working with the administrators of the box to narrow down what would be causing this. But any direction would be appreciated.

Thx

[roger_symonds]

Sorry just read the original post, please ignore the below post.


On a side note have you tried connecting to a remote database as a work around to get you up and running?
http://support.hyperic.com/confluence/display/DOCSHQ30/Database+Preparation




Hi RayK,

I believe you need to run the installer as a non-root user.
Try creating a user "hyperic" and running the installer as this user.

Can you give this a try and let us know how it goes?

Regards,
Roger

Message was edited by: roger.symonds

Message was edited by: roger.symonds

[fahlenkp]

I have the same problem with fedora 4. In response to the current suggested answers-

external database? The instructions in the first line state that you should have a DBA watching this for you. Why in the heck would I go off on that tangent when I'm a 1 person IT shop? No DBA here. Just me. External Db is not an option as documented by requirements in Hyperic docs. And why would you suggest an advanced option instead of fixing the built in?

Running as root? No, setup does not allow you to run as root and boots you out of an install if you try.

I'm guessing a permissions problem once it gets to the database part of the install. the log files dont help. Here are my errors:

From install:


An error occurred trying to start the HQ built-in database. More
information may be available in the /usr/local/hyperic/server-3.2.1/logs/hqdb.log file.
--------------------------------------------------------------------------------
Waiting for server to stop...
Stopping built-in database...
--------------------------------------------------------------------------------
An ERROR occurred, the installation cannot continue.
FATAL EXCEPTION at /usr/local/src/hyperic-hq-installer/installer-3.2.1/data/setup.xml:442: : The following error occurred while executing this line:
/usr/local/src/hyperic-hq-installer/installer-3.2.1/data/setup.xml:448: The following error occurred while executing this line:
/usr/local/src/hyperic-hq-installer/installer-3.2.1/data/setup.xml:567: The following error occurred while executing this line:
/usr/local/src/hyperic-hq-installer/installer-3.2.1/data/setup-db-PostgreSQL.xml:153: The following error occurred while executing this line:
/usr/local/src/hyperic-hq-installer/installer-3.2.1/data/setup-db-PostgreSQL.xml:194: The following error occurred while executing this line:
/usr/local/hyperic/server-3.2.1/data/server.xml:168: exec returned: 127


From the logs
-/usr/local/hyperic/server-3.2.1/hqdb/bin/pg_ctl: error while loading shared libraries: /usr/local/hyperic/server-3.2.
1/hqdb/lib/libpq.so.5: file too short

[fahlenkp]

Im trying to build the db myself in postgres and running in to some problems. I installed it ok with yum. Now on trying to log in as postgres and fire it up I get this:

[/usr/local/src/hyperic-hq-installer] > psql
psql: FATAL: database "postgres" does not exist
[/usr/local/src/hyperic-hq-installer] > locate psql
[/usr/local/src/hyperic-hq-installer] >


Any ideas to people who know how to run a db?

[ama_hyperic]

So the external DB was suggested because the installer was having trouble starting the internal DB.

The DBA requirement in the docs is there simply because it would be generally sub optimal for someone with zero experience with oracle/postgres/mysql to go and install and configure it.

The postgres docs are a little different though. If you are on a red hat based system, the docs walk you thru the entire process of install and configuration including accounts/permissions. If you follow the steps in the docs you should have a HQ instance up and running without too much trouble.

[mihait_hyperic]

Same problem.
As you see libpq.so.5.0 is empty !!!

OS : Slackware 12.0

hyperic@gw:~/server-3.2.1/hqdb/lib$ ls -lah | grep libpq
-rw-r--r-- 1 hyperic users 135K 2007-11-27 18:03 libpq.a
lrwxrwxrwx 1 hyperic users 12 2008-03-26 19:19 libpq.so -> libpq.so.5.0
lrwxrwxrwx 1 hyperic users 12 2008-03-26 19:19 libpq.so.5 -> libpq.so.5.0
-rw-r--r-- 1 hyperic users 0 2007-11-27 18:03 libpq.so.5.0
hyperic@gw:~/server-3.2.1/hqdb/lib$

Message was edited by: mihait

[RubenITtec]

Hi all

im trying to install Hyperic on Centos 5 too, unsuccessfully. I have exactly same problem and i follow the steps (non root-user, etc) installing from tgz, no rpm. I dont understand the proposed solution. I think the easiest way is to install defautl BD of Hyperic. So two things only

1) Can we install Hyperic on Centos 5?
2) Where is the doc to install another BD?

Error:
[hyperic@ hyperic-hq-installer]$ cat /usr/local/hyperic/server-3.2.4/logs/hqdb.log
/usr/local/hyperic/server-3.2.4/hqdb/bin/pg_ctl: error while loading shared libraries: /usr/local/hyperic/server-3.2.4/hqdb/lib/libpq.so.5: file too short

Thanks!

Message was edited by: ittec

[RubenITtec]

Nobody? :(

[AngellFire]

SOLVED...!!

Execute

root@hqserver ~]#su hyperic /opt/hyperic/server-4.1.2/bin/hq-server.sh start

Starting HQ built-in database....

...
...
...

HQ Server booted.
Login to HQ at: http://127.0.0.1:7080