Skip to Content.
Sympa Menu

freetds - Re: [freetds] SQL Anywhere 11 and FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: James Fisher <ganoopluslinux AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] SQL Anywhere 11 and FreeTDS
  • Date: Tue, 7 Oct 2014 15:39:37 -0500

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.

On Tue, Oct 7, 2014 at 3:08 PM, Frediano Ziglio <freddy77 AT gmail.com> wrote:

> Looks not correct. The capture contains a single UDP packet. Sql
> server use TCP connections.
>
> Frediano
>
>
> 2014-10-07 19:18 GMT+01:00 James Fisher <ganoopluslinux AT gmail.com>:
> > 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.
> > https://lists.ibiblio.org/sympa/arc/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>
> > wrote:
> >
> >> 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
> >> that each time either application disconnects, it shows a message like:
> >>
> >> >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.
> >>
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

Attachment: native.log
Description: Binary data




Archive powered by MHonArc 2.6.24.

Top of Page