RE: Trouble connecting to netxms-0.2.5 on gentoo-linux

Hello!

It's an already known issue with PostgreSQL driver (issue #50 in
bugtracker), and already solved in CVS version. Attached is an updated
PostgreSQL driver, which should solve your problem.

Best regards,
Victor

-----Original Message-----
From: Christoffer Blindheim [mailto:netxms_at_christoffer.totalnett.no]
Sent: Friday, October 21, 2005 1:10 AM
To: NetXMS Developers talks
Subject: [netxms-dev] Trouble connecting to netxms-0.2.5 on gentoo-linux

When I'm trying to connect to my netxms-0.2.5 server it crashes. Tried
to clean and reinstall client/server/database with no luck...

Seems like there is a database issue in session.cpp function
ClientSession::SendEventDB :

At this line a crash occur, seems like DBGetFieldAsync is returning
null: msg.SetVariable(VID_NAME, DBGetFieldAsync(hResult, 1, szBuffer,
1024));

DBGetFieldAsyncULong(hResult, 0) returns 0 (Shouldn't it return 1 ?)

I wonder if the ran ok at all?

My postgres server is v8.0.1.

thanks,

Debug info below:

./netxmsd --debug-all --dump-sql standalone
Using configuration file "/etc/netxmsd.conf"
Configuration file OK
[20-Oct-2005 21:47:12] Database driver
"/usr/netxms/lib/libnxddr_pgsql.so" loaded and initialized successfully
[20-Oct-2005 21:47:12] DEBUG: Successfully connected to database
netxmsdb_at_localhost
---- STARTUP INFO REMOVED ----

NetXMS Server V0.2.5 Ready
Enter "help" for command list or "down" for server shutdown System
Console

netxmsd: *CSCP(0)* Received message CMD_GET_SERVER_INFO
*CSCP(0)* Sending message CMD_REQUEST_COMPLETED
*CSCP(0)* Received message CMD_REQUEST_ENCRYPTION
*CSCP(0)* Sending message CMD_REQUEST_SESSION_KEY
*CSCP(0)* Sending message CMD_REQUEST_COMPLETED
*CSCP(0)* Received message CMD_LOGIN
*CSCP(0)* User admin_at_80.203.118.68 authenticated
*CSCP(0)* Sending message CMD_LOGIN_RESP
*CSCP(0)* Received message CMD_GET_CONTAINER_CAT_LIST
*CSCP(0)* Sending message CMD_CONTAINER_CAT_DATA
*CSCP(0)* Sending message CMD_CONTAINER_CAT_DATA
*CSCP(0)* Sending message CMD_CONTAINER_CAT_DATA
*CSCP(0)* Sending message CMD_CONTAINER_CAT_DATA
*CSCP(0)* Received message CMD_GET_OBJECTS
*CSCP(0)* Sending message CMD_REQUEST_COMPLETED
*CSCP(0)* Sending message CMD_OBJECT
*CSCP(0)* Sending message CMD_OBJECT
*CSCP(0)* Sending message CMD_OBJECT
*CSCP(0)* Sending message CMD_OBJECT
*CSCP(0)* Sending message CMD_OBJECT
*CSCP(0)* Sending message CMD_OBJECT
*CSCP(0)* Sending message CMD_OBJECT
*CSCP(0)* Sending message CMD_OBJECT
*CSCP(0)* Sending message CMD_OBJECT_LIST_END
*CSCP(0)* Received message CMD_LOAD_USER_DB
*CSCP(0)* Sending message CMD_REQUEST_COMPLETED
*CSCP(0)* Sending message CMD_USER_DATA
*CSCP(0)* Sending message CMD_USER_DATA
*CSCP(0)* Sending message CMD_GROUP_DATA
*CSCP(0)* Sending message CMD_USER_DB_EOF
*CSCP(0)* Received message CMD_LOAD_ACTIONS
*CSCP(0)* Sending message CMD_REQUEST_COMPLETED
*CSCP(0)* Sending message CMD_ACTION_DATA
*CSCP(0)* Received message CMD_GET_MIB_LIST
*CSCP(0)* Sending message CMD_MIB_LIST
*CSCP(0)* Received message CMD_LOAD_EVENT_DB
*CSCP(0)* Sending message CMD_REQUEST_COMPLETED
Successful async query: "SELECT
event_code,event_name,severity,flags,message,description FROM event_cfg"
[0 ms] Killed

ldd /usr/netxms/bin/netxmsd
         linux-gate.so.1 => (0xffffe000)
         libpthread.so.0 => /lib/libpthread.so.0 (0x40017000)
         libnetxms.so.0 => /usr/netxms/lib/libnetxms.so.0 (0x40069000)
         libnxcscp.so.0 => /usr/netxms/lib/libnxcscp.so.0 (0x40071000)
         libnxsnmp.so.0 => /usr/netxms/lib/libnxsnmp.so.0 (0x40079000)
         libnxsrv.so.0 => /usr/netxms/lib/libnxsrv.so.0 (0x4007f000)
         libnxcore.so.0 => /usr/netxms/lib/libnxcore.so.0 (0x40089000)
         libstdc++.so.6 =>
//usr/lib/gcc/i686-pc-linux-gnu/3.4.3-20050110/libstdc++.so.6
(0x400df000)
         libreadline.so.5 => /lib/libreadline.so.5 (0x401aa000)
         libtermcap.so.2 => /lib/libtermcap.so.2 (0x401e1000)
         libdl.so.2 => /lib/libdl.so.2 (0x401e5000)
         libcrypto.so.0.9.7 => /usr/lib/libcrypto.so.0.9.7 (0x401e9000)
         libpq.so.3 => /usr/lib/libpq.so.3 (0x402e4000)
         libz.so.1 => /lib/libz.so.1 (0x40305000)
         libm.so.6 => /lib/libm.so.6 (0x4031e000)
         libgcc_s.so.1 =>
//usr/lib/gcc/i686-pc-linux-gnu/3.4.3-20050110/libgcc_s.so.1
(0x40341000)
         libc.so.6 => /lib/libc.so.6 (0x4034a000)
         /lib/ld-linux.so.2 (0x40000000)
         libncurses.so.5 => /lib/libncurses.so.5 (0x4045f000)
         libssl.so.0.9.7 => /usr/lib/libssl.so.0.9.7 (0x404b5000)
         libcrypt.so.1 => /lib/libcrypt.so.1 (0x404e5000)
         libresolv.so.2 => /lib/libresolv.so.2 (0x40513000)
         libnsl.so.1 => /lib/libnsl.so.1 (0x40526000)
         libgpm.so.1 => /lib/libgpm.so.1 (0x4053b000)

-- 
Christoffer Blindheim