VMware Cloud Community
Morten_hyperic
Contributor
Contributor

Builtin db won't accept connections

I installed the HQ Server 2.7.5 and am getting this error. I did look around and I do have the Microsoft loopback adapter installed. When I try to start the db manually I get a message about "cannot connect to "???", so I guess the localhost can't be determined by the hqdb engine.


2006-11-10 19:47:16,669 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
Reply
0 Kudos
5 Replies
Morten_hyperic
Contributor
Contributor

A bit more info dfrom file hqdb.log

[2006-11-10 22:24:04.790 ] LOG: could not create IPv6 socket: An address incompatible with the requested protocol was used.


[2006-11-10 22:24:06.292 ] LOG: database system was shut down at 2006-11-09 07:27:11 Eastern Standard Time
[2006-11-10 22:24:06.302 ] LOG: incomplete startup packet
[2006-11-10 22:24:06.352 ] LOG: checkpoint record is at 0/38CA40
[2006-11-10 22:24:06.352 ] LOG: redo record is at 0/38CA40; undo record is at 0/0; shutdown TRUE
[2006-11-10 22:24:06.352 ] LOG: next transaction ID: 569; next OID: 16386
[2006-11-10 22:24:06.352 ] LOG: next MultiXactId: 1; next MultiXactOffset: 0
[2006-11-10 22:24:06.452 ] LOG: database system is ready
[2006-11-10 22:24:06.743 ] LOG: transaction ID wrap limit is 2147484146, limited by database "postgres"
[2006-11-10 22:24:16.748 ] LOG: invalid entry in file "c:/hyperic/server-2.7.5/bin/../hqdb/data/pg_hba.conf" at line 62, token "127.0.0.1"
[2006-11-10 22:24:16.748 ] FATAL: missing or erroneous pg_hba.conf file
[2006-11-10 22:24:16.748 ] HINT: See server log for details.
[2006-11-10 22:24:19.913 ] LOG: received smart shutdown request
[2006-11-10 22:24:19.913 ] LOG: shutting down
[2006-11-10 22:24:19.973 ] LOG: database system is shut down

---------------------- pg_hba.conf file ----------------
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all 127.0.0.1 255.255.255.255 trust
# IPv4-style local connections:
host all all 10.166.56.174 255.255.255.255 trust
# IPv6-style local connections:
#host all all ::1/128 trust
Reply
0 Kudos
Morten_hyperic
Contributor
Contributor

One other thing:

I guess the embedded database is Postgres which is not allowed to run under user Administrator on Windows. My account on Win XP has Admin rights. I tried to install a standalone Postgres but no luck since I can't get it to start even when I create a new user. I am only interested in using the embedded db in the Hyperic Server, just trying to debug
Reply
0 Kudos
Morten_hyperic
Contributor
Contributor

Running pg_ctl.exe start -D ../data

C:\hyperic\server-2.7.5\hqdb\bin>[2006-11-10 23:18:19.061 ] LOG: database syste
m was shut down at 2006-11-10 23:17:59 Eastern Standard Time
[2006-11-10 23:18:19.061 ] LOG: checkpoint record is at 0/38CB18
[2006-11-10 23:18:19.061 ] LOG: redo record is at 0/38CB18; undo record is at 0
/0; shutdown TRUE
[2006-11-10 23:18:19.061 ] LOG: next transaction ID: 569; next OID: 16386
[2006-11-10 23:18:19.061 ] LOG: next MultiXactId: 1; next MultiXactOffset: 0
[2006-11-10 23:18:19.061 ] LOG: database system is ready
[2006-11-10 23:18:19.071 ] LOG: transaction ID wrap limit is 2147484146, limite
d by database "postgres"


---------------------------- psql.exe ---------------------

C:\hyperic\server-2.7.5\hqdb\bin>psql.exe
psql: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "???" and accepting
TCP/IP connections on port 5432?
Reply
0 Kudos
Morten_hyperic
Contributor
Contributor

I am able to get into the database by running db-psql.bat from the server directory.

here is waht I can see
hqdb=# \db
List of tablespaces
Name | Owner | Location
------------+---------+----------
pg_default | rmorgan |
pg_global | rmorgan |
(2 rows)

So I guess the db is up

-------------
this is where it gets stuck

C:\hyperic\server-2.7.5\bin>hq-server.exe start
00:00:39,384 INFO [Server] Starting JBoss (MX MicroKernel)...
00:00:39,394 INFO [Server] Release ID: JBoss [Zion] 4.0.3SP1 (build: CVSTag=JBo
ss_4_0_3_SP1 date=200510231054)
00:00:39,394 INFO [Server] Home Dir: C:\hyperic\server-2.7.5\hq-engine
00:00:39,394 INFO [Server] Home URL: file:/C:/hyperic/server-2.7.5/hq-engine/
00:00:39,394 INFO [Server] Patch URL: null
00:00:39,394 INFO [Server] Server Name: default
00:00:39,394 INFO [Server] Server Home Dir: C:\hyperic\server-2.7.5\hq-engine\s
erver\default
00:00:39,394 INFO [Server] Server Home URL: file:/C:/hyperic/server-2.7.5/hq-en
gine/server/default/
00:00:39,394 INFO [Server] Server Temp Dir: C:\hyperic\server-2.7.5\hq-engine\s
erver\default\tmp
00:00:39,394 INFO [Server] Root Deployment Filename: jboss-service.xml
00:00:39,815 INFO [ServerInfo] Java version: 1.4.2_06,Sun Microsystems Inc.
00:00:39,815 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.4.2_06-b03
,Sun Microsystems Inc.
00:00:39,815 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
00:00:40,376 INFO [Server] Core system initialized
00:00:42,459 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resour
ce:log4j.xml

------------
web console error

Error

The page requested cannot be displayed due to some error. You can hide the stack trace,Return to the previous page, Dashboard, or Browse Resources page.

Exception:
org.hyperic.util.ConfigPropertyException: Unable to find config property at org.hyperic.hq.common.server.session.ServerConfigManagerEJBImpl.getConfig(ServerConfigManagerEJBImpl.java:161) at org.hyperic.hq.common.server.session.ServerConfigManagerEJBImpl.getConfig(ServerConfigManagerEJBImpl.java:106) at
Reply
0 Kudos
Morten_hyperic
Contributor
Contributor

I am able to manually start the db and then the server.

When I try using the windows service, it doesn't work, I guess I will try to remove the windows services and add them again.
Reply
0 Kudos