Re: SQL Anywhere 11 and FreeTDS

I have just compiled sqsh and the sybase_ct php module against the native
ct library, I assume that would be a better tcp dump to work with? I think
the logout would be very helpful, it'd be wonderful to use freetds rather
than the native library! I really appreciate your help.

On Sunday, October 12, 2014, Frediano Ziglio <[email protected]> wrote:

> Yes, this is correct. However the protocol the client is using is quite
> different from the one we actually use. I can try adding a logout stream if
> this helps.
> Il 07/ott/2014 22:40 "James Fisher" <[email protected]
> <javascript:;>> ha scritto:
>
> > 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 <[email protected]
> <javascript:;>>
> > 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 <[email protected]
> <javascript:;>>:
> > > > 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 <
> [email protected] <javascript:;>
> > >
> > > > 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
> > > > [email protected] <javascript:;>
> > > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > > >
> > > _______________________________________________
> > > FreeTDS mailing list
> > > [email protected] <javascript:;>
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > >
> >
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected] <javascript:;>
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> >
> _______________________________________________
> FreeTDS mailing list
> [email protected] <javascript:;>
> http://lists.ibiblio.org/mailman/listinfo/freetds
>