Bug #121595 for DBD-Sybase: failure to connect to newer ASE server

Wed May 10 03:53:36 2017 nohez [...] cmie.com - Ticket created

Subject:	failure to connect to newer ASE server
Date:	Wed, 10 May 2017 13:09:13 +0530 (IST)
To:	bug-DBD-Sybase [...] rt.cpan.org
From:	Nohez Poonawala <nohez [...] cmie.com>

We tried newer ASE 16.0 SP02 PL05 HF2 and found that DBD-Sybase cannot connect to ASE. We searched SAP website and found an article in SAP knowledge base with the same problem. The URL for the SAP Knowledge base article is: 2367843 - Perl module errors with buffer overflow detected - SAP SDK https://launchpad.support.sap.com/#/notes/2367843 SAP support says "Michael Peppler's perl module has a bug when connecting to new ASE databases" and the resolution is "Instead of using Peppler's perl module (sybase.so), use SAP perl module (sybaseASE.so)" Requesting for a bug fix. Thanks & regards,

Wed Aug 30 15:19:27 2017 PERLDBA [...] cpan.org - Correspondence added

RT-Send-CC:

mpeppler [...] peppler.org, andreas.koenig.gmwojprw+pause [...] franz.ak.mind.de, andreas.koenig [...] anima.de

Hi Nohez, This is caused due to an issue with the underlying implementation code written for DBD::Sybase in C. It occurs when DBD::Sybase tries to retrieve the serverVersion of the ASE it is trying to connect to. This is done by default for all servers of serverType ASE which is set in DBD::Sybase by default. I have sent Michael et al. additional details regarding the same and have tried to explain the severity of this issue as this error not only severs the database connection but also causes end-user Perl applications to crash. This hopefully gets some attention and we get a bug fix quickly. In the meantime, if you can afford to change the application source code you can update the DBI connect string to include the serverType parameter and set it to anything but ASE. This will tell DBD::Sybase to disable the behavior of retrieving serverVersion by default.. < my $db_connect = "dbi:Sybase:server=$server;encryptPassword=yes;interfaces=$interfaces"; --- Show quoted text

> my $db_connect = "dbi:Sybase:server=$server;serverType=NOTASE;encryptPassword=yes;interfaces=$interfaces";

I will resolve this ticket when i get the required authorizations to release a new version with the bug fix. Thanks, Shiva Venkateswaran

Wed Aug 30 15:19:28 2017 The RT System itself - Status changed from 'new' to 'open'

Wed Aug 30 15:25:29 2017 PERLDBA [...] cpan.org - Severity Critical added

Wed Aug 30 15:25:29 2017 PERLDBA [...] cpan.org - Broken in 1.15 added

Sun Sep 10 10:39:19 2017 mpeppler [...] peppler.org - Correspondence added

Uploaded 1.16 which should fix this issue. There are no other changes vs 1.15.

Sun Sep 10 10:39:19 2017 mpeppler [...] peppler.org - Status changed from 'open' to 'resolved'

Sun Sep 10 10:39:19 2017 mpeppler [...] peppler.org - Fixed in 1.16 added

Wed Oct 03 04:19:46 2018 nohez [...] cmie.com - Correspondence added

Subject:	Re: [rt.cpan.org #121595] failure to connect to newer ASE server
Date:	Wed, 3 Oct 2018 12:45:05 +0530 (IST)
To:	Shiva Venkateswaran via RT <bug-DBD-Sybase [...] rt.cpan.org>
From:	Nohez Poonawala <nohez [...] cmie.com>

Hello, I am now facing the same problem with ASE 16.0 SP03 PL05 HF1. I changed the connection string to include serverType. It works. my $db_connect= DBI->connect("dbi:Sybase:scriptName=$progname;database=$database;serverType=Anything"; This problem does not occur with ASE 16.0 SP03 PL05. It occurs with "HF1" version. Thanks & regards, Nohez On Wed, 30 Aug 2017, Shiva Venkateswaran via RT wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=121595 > > > Hi Nohez, > > This is caused due to an issue with the underlying implementation code written for DBD::Sybase in C. It occurs when DBD::Sybase tries to retrieve the serverVersion of the ASE it is trying to connect to. This is done by default for all servers of serverType ASE which is set in DBD::Sybase by default. > > I have sent Michael et al. additional details regarding the same and have tried to explain the severity of this issue as this error not only severs the database connection but also causes end-user Perl applications to crash. This hopefully gets some attention and we get a bug fix quickly. > > In the meantime, if you can afford to change the application source code you can update the DBI connect string to include the serverType parameter and set it to anything but ASE. This will tell DBD::Sybase to disable the behavior of retrieving serverVersion by default.. > > < my $db_connect = "dbi:Sybase:server=$server;encryptPassword=yes;interfaces=$interfaces"; > ---

>> my $db_connect = "dbi:Sybase:server=$server;serverType=NOTASE;encryptPassword=yes;interfaces=$interfaces";

> > I will resolve this ticket when i get the required authorizations to release a new version with the bug fix. > > Thanks, > Shiva Venkateswaran

Wed Oct 10 12:17:36 2018 mpeppler [...] peppler.org - Correspondence added

Hi What does select @@version return on that ASE version? Thanks On Wed Oct 03 04:19:46 2018, nohez@cmie.com wrote: Show quoted text

> > Hello, > > I am now facing the same problem with ASE 16.0 SP03 PL05 HF1. > > I changed the connection string to include serverType. It works. > > my $db_connect= DBI-

> >connect("dbi:Sybase:scriptName=$progname;database=$database;serverType=Anything";

> > This problem does not occur with ASE 16.0 SP03 PL05. It occurs with > "HF1" version. > > Thanks & regards, > Nohez > > On Wed, 30 Aug 2017, Shiva Venkateswaran via RT wrote: >

> > <URL: https://rt.cpan.org/Ticket/Display.html?id=121595 > > > > > Hi Nohez, > > > > This is caused due to an issue with the underlying implementation > > code written for DBD::Sybase in C. It occurs when DBD::Sybase tries > > to retrieve the serverVersion of the ASE it is trying to connect to. > > This is done by default for all servers of serverType ASE which is > > set in DBD::Sybase by default. > > > > I have sent Michael et al. additional details regarding the same and > > have tried to explain the severity of this issue as this error not > > only severs the database connection but also causes end-user Perl > > applications to crash. This hopefully gets some attention and we get > > a bug fix quickly. > > > > In the meantime, if you can afford to change the application source > > code you can update the DBI connect string to include the serverType > > parameter and set it to anything but ASE. This will tell DBD::Sybase > > to disable the behavior of retrieving serverVersion by default.. > > > > < my $db_connect = > > "dbi:Sybase:server=$server;encryptPassword=yes;interfaces=$interfaces"; > > ---

> >> my $db_connect = > >> "dbi:Sybase:server=$server;serverType=NOTASE;encryptPassword=yes;interfaces=$interfaces";

> > > > I will resolve this ticket when i get the required authorizations to > > release a new version with the bug fix. > > > > Thanks, > > Shiva Venkateswaran

Thu Oct 11 01:27:47 2018 nohez [...] cmie.com - Correspondence added

Subject:	Re: [rt.cpan.org #121595] failure to connect to newer ASE server
Date:	Thu, 11 Oct 2018 10:53:31 +0530 (IST)
To:	Michael Peppler via RT <bug-DBD-Sybase [...] rt.cpan.org>
From:	Nohez Poonawala <nohez [...] cmie.com>

Hi, @@version returns the following: # isql Show quoted text

1> select @@version

Show quoted text

2> go

---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ------------------------------------------------------- Adaptive Server Enterprise/16.0 SP03 PL05 HF1/EBF 28622 SMP/P/x86_64/SLES 11.1/ase160sp03pl05x/3463/64-bit/FBO/Thu Sep 13 09:24:26 2018 Thanks Nohez

Thu Oct 11 03:51:33 2018 mpeppler [...] peppler.org - Correspondence added

Are you using DBD::Sybase 1.16 ? On Thu Oct 11 01:27:47 2018, nohez@cmie.com wrote: Show quoted text

> > Hi, > > @@version returns the following: > > # isql

> 1> select @@version

> 2> go

> > > ---------------------------------------------------------------------------------------------------- > ---------------------------------------------------------------------------------------------------- > ------------------------------------------------------- > Adaptive Server Enterprise/16.0 SP03 PL05 HF1/EBF 28622 > SMP/P/x86_64/SLES > 11.1/ase160sp03pl05x/3463/64-bit/FBO/Thu Sep 13 09:24:26 2018 > > > > Thanks > Nohez

Tue Oct 30 03:11:34 2018 nohez [...] cmie.com - Correspondence added

Subject:	Re: [rt.cpan.org #121595] failure to connect to newer ASE server
Date:	Tue, 30 Oct 2018 11:37:21 +0530 (IST)
To:	Michael Peppler via RT <bug-DBD-Sybase [...] rt.cpan.org>
From:	Nohez Poonawala <nohez [...] cmie.com>

My apologies. I tried it on a server with an older version of the module. Module works fine. I am sorry for the trouble caused. Regards, Nohez