[freetds] SQL Anywhere 11 and FreeTDS

Discussion:

James Fisher

2014-10-06 18:57:51 UTC

OP: http://thread.gmane.org/gmane.comp.db.tds.freetds/11976

Hello, I am new to mailing lists, so sorry if it's bad that I am reviving
this old thread - but I am having the same issue as this guy from several
years back...

I setup a few debian and ubuntu servers to talk to our database(Sybase SQL
Anywhere 11) using sqsh and adodb(php) with FreeTDS. Once configured to
use TDS v5.0, both sqsh and adodb can connect and execute queries on the
database. However, when I began looking at the log on the server I found

Connection terminated abnormally
Disconnected TCPIP client's AppInfo: HOST=debian-vm;PID=2605

The database doesn't *seem* affected - as far as I can tell...

The statements return the rows or insert the data.

I see no performance hit, etc... but it is concerning none the less.

I have also tested with SQL Anywhere 10, 11, 12, & 16, all have the same
issue(and so does their development versions). I have tried tsql/isql and
both produce the same error.
Sybase's dbisql/sa_php extension/native odbc client all work without the
error.

I have a FreeTDS log here:

https://gist.github.com/anonymous/b9146103bb16d4eb94c9

I will be happy to do any other dump that might be helpful,
including setting up an test environment on digitalocean
for anyone who'd like to take a look.

Thanks to anyone willing to help in any way.

James Fisher

2014-10-07 18:18:55 UTC

Permalink

While reviewing the old thread I found that someone(Mr. James Lowden)
requested a tcpdump in order to capture a 'proper' disconnect but I didn't
see that the OP followed up.
http://lists.ibiblio.org/pipermail/freetds/2009q4/025362.html

I have attached mine here. If this isn't the right information, please let
me know. Thanks again to anyone willing to help.

On Mon, Oct 6, 2014 at 1:57 PM, James Fisher <ganoopluslinux at gmail.com>

Post by James Fisher
OP: http://thread.gmane.org/gmane.comp.db.tds.freetds/11976
Hello, I am new to mailing lists, so sorry if it's bad that I am reviving
this old thread - but I am having the same issue as this guy from several
years back...
I setup a few debian and ubuntu servers to talk to our database(Sybase SQL
Anywhere 11) using sqsh and adodb(php) with FreeTDS. Once configured to
use TDS v5.0, both sqsh and adodb can connect and execute queries on the
database. However, when I began looking at the log on the server I found

Connection terminated abnormally
Disconnected TCPIP client's AppInfo: HOST=debian-vm;PID=2605

The database doesn't *seem* affected - as far as I can tell...
The statements return the rows or insert the data.
I see no performance hit, etc... but it is concerning none the less.
I have also tested with SQL Anywhere 10, 11, 12, & 16, all have the same
issue(and so does their development versions). I have tried tsql/isql and
both produce the same error.
Sybase's dbisql/sa_php extension/native odbc client all work without the
error.
https://gist.github.com/anonymous/b9146103bb16d4eb94c9
I will be happy to do any other dump that might be helpful,
including setting up an test environment on digitalocean
for anyone who'd like to take a look.
Thanks to anyone willing to help in any way.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: tcpdump.log
Type: application/octet-stream
Size: 136 bytes
Desc: not available
URL: <http://lists.ibiblio.org/pipermail/freetds/attachments/20141007/0976fcb0/attachment.obj>

Frediano Ziglio

2014-10-07 20:08:22 UTC

Permalink

Looks not correct. The capture contains a single UDP packet. Sql
server use TCP connections.

Frediano

Post by James Fisher
While reviewing the old thread I found that someone(Mr. James Lowden)
requested a tcpdump in order to capture a 'proper' disconnect but I didn't
see that the OP followed up.
http://lists.ibiblio.org/pipermail/freetds/2009q4/025362.html
I have attached mine here. If this isn't the right information, please let
me know. Thanks again to anyone willing to help.
On Mon, Oct 6, 2014 at 1:57 PM, James Fisher <ganoopluslinux at gmail.com>

Connection terminated abnormally
Disconnected TCPIP client's AppInfo: HOST=debian-vm;PID=2605

The database doesn't *seem* affected - as far as I can tell...
The statements return the rows or insert the data.
I see no performance hit, etc... but it is concerning none the less.
I have also tested with SQL Anywhere 10, 11, 12, & 16, all have the same
issue(and so does their development versions). I have tried tsql/isql and
both produce the same error.
Sybase's dbisql/sa_php extension/native odbc client all work without the
error.
https://gist.github.com/anonymous/b9146103bb16d4eb94c9
I will be happy to do any other dump that might be helpful,
including setting up an test environment on digitalocean
for anyone who'd like to take a look.
Thanks to anyone willing to help in any way.

_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

James Fisher

2014-10-07 20:39:37 UTC

Permalink

Frediano,

Thank you so much for your response, I have attached here a new tcpdump.
Sorry I am not too familiar with that tool. Please let me know if this is
correct.

I am running tcpdump on the client using this:

tcpdump -i eth0 -w native.log -s0 host {client IP}

Thanks again.

Post by Frediano Ziglio
Looks not correct. The capture contains a single UDP packet. Sql
server use TCP connections.
Frediano

Post by James Fisher
While reviewing the old thread I found that someone(Mr. James Lowden)
requested a tcpdump in order to capture a 'proper' disconnect but I

didn't

Post by James Fisher
see that the OP followed up.
http://lists.ibiblio.org/pipermail/freetds/2009q4/025362.html
I have attached mine here. If this isn't the right information, please

let

Post by James Fisher
me know. Thanks again to anyone willing to help.
On Mon, Oct 6, 2014 at 1:57 PM, James Fisher <ganoopluslinux at gmail.com>

Post by James Fisher
OP: http://thread.gmane.org/gmane.comp.db.tds.freetds/11976
Hello, I am new to mailing lists, so sorry if it's bad that I am

reviving