Foundstone Collector - JDBC driver issue

[ab@novell.com]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

<quote>
I/O Error: DB server closed connection.
</quote>

This isn't a Sentinel problem. Find out from your DBA why the system is
closing the connection on you. You have reproduced it outside Sentinel so
start there. Using the JTDS driver should work unless Foundstone has
setup the mssql database in such a way that it prevents connections from
certain applications. Find out what those restrictions or limitations are
and go from there. Hopefully their log files will show something like
"don't like this connection so closing it" or synonymous.

Good luck.





lihwern wrote:
> I 'm getting this error in server0.0.log when I try to configure the
> event source for Foundstone collector.
> I'm use the jtds-1.2.4.jar JDBC driver.
>
> Audit High:: Call by user System to app DBConnector object DBConnector
> method CreateConnectionError client Unknown failed : Error creating
> connection to
> jdbc:jtds:sqlserver://172.18.216.36:1433/faultline;domain=;instance=;ssl=off.
> Error message from database is: I/O Error: DB server closed connection.;
> reqId(E0F3DD73-A40C-102C-A0BE-0025643B9EDA)
>
> I try to use the the jtds-1.2.4.jar JDBC driver using a 3rd party tool
> like dbvisualizer. I encounter the following error.
> "I/O Error: DB server closed connection."
> But, when I use the Microsoft JDBC driver 2.0 (sqljdbc4.jar) in
> dbvisualizer, I can successfully connect to the database.
>
> So, I use the Microsoft JDBC driver 2.0 in Sentinel Log Manager. I
> still received the same error "I/O Error: DB server closed connection."
>
> The Foundstone appliance (FS1000) is running MS SQL 2005 (Product
> version: 9.00.3042)
>
> What could be wrong?
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJK6X2OAAoJEF+XTK08PnB5hnYQAJQ4lWbwvk rYV9+pyzYR+Csv
WXl7LP7qlDnNkHLv6XbPBmS7HoaxMSPXWYHFwE/PiC7u28xK9YA3TU+Dq3w+5uqi
hTJ831ezKOj1hz4p5jQyAeuqZhCMmP7mVK0K9PrABlVht3089o t27eg0t8+o6p6o
57AkNl2EZ8D19sEHpjn01a9M6utCWxmBpFi8qOszSK1EZHtcLf dnqgEoKiAA5Qyu
f8AxR28F4DaxjFhB4MRj02n2E/fPmapwv3HQWi18oVsCuH7/yK9JBA79OXHzfUHO
4Un4gfnaTm1vpkPZRsiGVRW+dF44HJa7S6O6I6GU13sj3o+KGn lSwsGP49U58o8T
eMzI0YuvcZLvmg0VitWsXmdfrpZkmE4Ih7km4OE3YUmqeoZzWt J2YevIfMmzVF/f
+7HZCctZlwrt/nBOFSr8Vylq49EQuoRHzk7hL3PEO39s//On3fJSXbBJYUc34JWI
cLwRc6PbZNNQ2Wn9J2SA9WUfrzIgsyWsOT3LZHmakkm6Bb3OLN 2how2q3kVy/OY4
h3Uxjbsbyw+F5mg8WwW11+loJ0e+BkHljOEf0EVjecmhLhdhhS jXn3UGCv5CDRAV
2nbXU7QBR1qslJfHlQXSNCbMWQBIEtN2DTwRA5FxVi+161+ifZ bRIWifM9kKNwjH
pHiHkhvO6jeLLYHYpyNU
=q+35
-----END PGP SIGNATURE-----