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: Sun, 12 Oct 2014 03:47:33 -0500

Frediano,
I have attached two tcp dumps of a successful disconnect; one using sqsh,
and another using php's sybase_ct. Both were compiled with the native CT
libraries. Please let me know if you need anything else. I hope this helps,
and thanks again.

On Sun, Oct 12, 2014 at 3:26 AM, James Fisher <ganoopluslinux AT gmail.com>
wrote:

> 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 <freddy77 AT gmail.com> 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" <ganoopluslinux AT gmail.com> 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 <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
>> > >
>> >
>> > _______________________________________________
>> > 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: sybase_ct.tcpdump
Description: Binary data

Attachment: sqsh-native.tcpdump
Description: Binary data




Archive powered by MHonArc 2.6.24.

Top of Page