VMware Cloud Community
fwong_hyperic
Contributor
Contributor
‎10-31-2006 08:33 PM

Sybase question - please help

Hi,

Does anyone know how to setup the sybase plugin? I have configured the sybase resource and it does not talk to the Sybase. There are settings on the "Install Path" and "jdbcUrl". Is the "Install Path" using the higher level of directory like /opt/sybase?

Thanks.
Reply
0 Kudos
2 Replies
BradFelmey
Hot Shot
Hot Shot
‎11-01-2006 09:09 AM

Ours is set up to point to /sybase/syb12_5. Our JDBC string looks like this:

jdbc:sybase:Tds:systemname:2001/master

Substitute systemname with your actual hostname, of course.
Reply
0 Kudos
fwong_hyperic
Contributor
Contributor
‎11-01-2006 05:32 PM

Thanks Brad,

I have configured the "Install Path" and "jdbcUrl" but the agent still does not collect the data. Both agent and server logs do not have any messages on Sybase. I ran lsof and found that the connection between hyperic and Sybase has been established.

[root@dhsdev:/sbin/init.d]# /usr/local/bin/lsof -i @150.173.242.160:4110-5076
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
dataserve 2375 sybase 23u IPv4 0x5cae8b40 0t0 TCP dhsdev.mel.mantrack.com:4110 (LISTEN)
dataserve 2375 sybase 24u IPv4 0x5da7d280 0t0 TCP dhsdev.mel.mantrack.com:4110->10.91.253.1:30060 (ESTABLISHED)
dataserve 2375 sybase 25u IPv4 0x5dc547c0 0t0 TCP dhsdev.mel.mantrack.com:4110->10.91.253.1:25476 (ESTABLISHED)
backupser 2406 sybase 6u IPv4 0x5da7d880 0t0 TCP dhsdev.mel.mantrack.com:4115 (LISTEN)
dataserve 2441 sybase 22u IPv4 0x5cc483c0 0t0 TCP dhsdev.mel.mantrack.com:4120 (LISTEN)
dataserve 2441 sybase 23u IPv4 0x5dc54040 0t0 TCP dhsdev.mel.mantrack.com:4120->dhsdev.mel.mantrack.com:52828 (ESTABLISHED)
backupser 2463 sybase 6u IPv4 0x5da9f880 0t0 TCP dhsdev.mel.mantrack.com:4125 (LISTEN)
dataserve 2503 sybase 22u IPv4 0x5dc544c0 0t0 TCP dhsdev.mel.mantrack.com:5056 (LISTEN)
backupser 2545 sybase 6u IPv4 0x5da7de80 0t0 TCP dhsdev.mel.mantrack.com:5061 (LISTEN)
dataserve 2568 sybase 45u IPv4 0x5dbe5c40 0t0 TCP dhsdev.mel.mantrack.com:5076 (LISTEN)
dataserve 2568 sybase 47u IPv4 0x5e53b0c0 0t0 TCP dhsdev.mel.mantrack.com:5076->10.91.253.1:57831 (ESTABLISHED)
dataserve 2649 sybase 67u IPv4 0x5e23c840 0t0 TCP dhsdev.mel.mantrack.com:5058 (LISTEN)
backupser 2668 sybase 6u IPv4 0x5e11cb00 0t0 TCP dhsdev.mel.mantrack.com:5059 (LISTEN)
java 14853 hyperic 59u IPv4 0x5e3249c0 0t270 TCP dhsdev.mel.mantrack.com:52828->dhsdev.mel.mantrack.com:4120 (ESTABLISHED)

Is there any other tricks I need to be aware?
Reply
0 Kudos