Re: (RADIATOR) DBD::Sybase::db do failed: Server messagenumber=8114 severity=16 state=1 line=0 server=CHOPINprocedure=Interface_VircomDetails text=Error converting data type varcharto numeric. at /usr/local/lib/site_perl/Radius/SqlDb.pm line 247.
Hello Andrew - This question has just raised its ugly head again, and the latest is that Microsoft no longer supports Sybase access to MS-SQL. I have sent you a separate mail with a suggestion from another of our customers for dealing with this. regards Hugh At 13:46 -0500 01/11/9, Andrew Kaplan wrote: This error pops up on my Radiator screen ever so often. Things appear to working. What's going on. DBD::Sybase::db do failed: Server message number=8114 severity=16 state=1 line=0 server=CHOPIN procedure=Interface_VircomDetails text=Error converting data type varchar to numeric. at /usr/local/lib/site_perl/Radius/SqlDb.pm line 247. Andrew P. Kaplan Network Administrator CyberShore, Inc. http://www.cshore.com I couldn't give him advice in business and he couldn't give me advice in technology. --Linus Torvalds, about why he wouldn't be interested in meeting Bill Gates. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.286 / Virus Database: 152 - Release Date: 10/9/01 === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- NB: I am travelling this week, so there may be delays in our correspondence. Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
Hello Chris,
Im still not convinced its the DBD code, since we dont see that behaviour here
with 0.13. I guess there is one other link in the chain, and thats the Sybase
client libraries. Have you investigated that possibility?
IN any case, here is a temporary fix for you. IN AuthSQL.pm,
add a line at about line 287 as shown below:
# Use the default assumption about returned cols:
# first is password, second is check items, third
# is reply items
my $password = shift @row;
# Chris, Add the next line to strip trailing NULs:
$password = s/\000*$//;
On Feb 25, 3:05pm, Chris Hanes wrote:
Subject: Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
I downloaded version .13 and it does it as well. I'm still not convinced the
NULs
are coming from the databse. It adds the NUL on every string coming from the
db,
even in the DBD::Sybase test programs. I've also got packets off the network
and
the strings being sent over the network do not seem to have NUL terminators.
Here's a sample packet.
.`g-E).P.\.i..E. 00 60 67 2d 45 29 00 50 8b 5c 02 69 08 00 45 00
.V..@..¼¤.. 00 56 8b c7 40 00 80 06 bc a4 d8 e6 00 16 d8 e6
.S...2.Z.g·..P. 00 53 05 99 04 32 05 5a a8 67 b7 8d a7 9c 50 18
.±$. 1f b1 24 c9 00 00 04 01 00 2e 00 00 00 00 a0 09
..password¡. 00 08 70 61 73 73 77 6f 72 64 a1 06 00 02 00 09
.'..nannie...Á. 00 27 80 d1 06 6e 61 6e 6e 69 65 fd 10 00 c1 00
01 00 00 00 00 00 00 00
DBD:Sybase interprets this as:
[root@linux-rad t]# od -c -x r.txt
000 | n a n n i e \0 | \0
6e7c 6e61 696e 0065 007c
011
[root@linux-rad t]#
If this triggers anything with anybody, let me know. I'm going to keep
plugging
away at this.
Thanks,
Chris
Mike McCauley wrote:
Hi Chris,
On Feb 24, 4:24pm, Chris Hanes wrote:
Subject: Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
Hi all,
Mike has identified the problem as a NUL character being added to the
password
coming from the SQLServer. The problem appears to be occuring in the
DBD:Sybase
module. I modified some example ct-lib code that came with FreeTDS and
it
pulled
strings from the SQLServer fine - no NUL terminator. I also got
DBD:FreeTDS
working with Radiator - unfortunately it doesn't seem to want to work
with
AuthByRodopi. Anyone else had this problem with DBD:Sybase? It does it
in
both
DBD:Sybase version .14 and .21 and it doesn't matter whether I use ct-lib
from
FreeTDS or ct-lib from sybase - the NUL character still shows up.
Help!!!
We use DBD-Sybase-0.13 without observing that problem. I wonder if the NULs
are
actually in the database, and FreeTDS just happens to strip the trailing
NUL
for free (I could imagine a C library doing that).
Anyone else with thoughts?
Thanks,
Chris
Mike McCauley wrote:
Hello Chris,
In order to get a handle on this, we would need to see your Radiator
log
file
at trace level 4, showing what Radiator is doing with the request, and
why
it
is rejecting it.
Your config file (no secrets) would also be helpful.
Cheers.
On Feb 22, 6:17pm, Chris Hanes wrote:
Subject: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
Hi all,
I've got a Redhat 6.1 Linux box configured with FreeTDS .50, DBD
Sybase
.21, Radiator 2.15 attempting to AuthSQL and AuthRodopi to a MS
SQLServer 7.0. After much hassle, I have the network connectivity
to
the SQLServer. However, I can't get AuthSQL or AuthRodopi working.
Radiator is looking up passwords correctly on the SQLServer and yet
it
still fails the auth request. Here's part of my password log file
for
an AuthSQL realm.
Tue Feb 22 17:56:42 2000:951260202:rcochran:yellow:yellow:FAIL
Tue Feb 22 18:11:04 2000:951261064:jladd:nannie:nannie:FAIL
Tue Feb 22 18:11:11 2000:951261071:cahcah:cahcah:cahcah:FAIL
Tue Feb 22 18:11:14 2000:951261074:cahcah:cahcah2:cahcah:FAIL
Any help would be GREATLY appreciated.
Thanks,
Chris Hanes
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
-- End of excerpt from Chris Hanes
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http
Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
I downloaded version .13 and it does it as well. I'm still not convinced the NULs
are coming from the databse. It adds the NUL on every string coming from the db,
even in the DBD::Sybase test programs. I've also got packets off the network and
the strings being sent over the network do not seem to have NUL terminators.
Here's a sample packet.
.`g-E).P.\.i..E. 00 60 67 2d 45 29 00 50 8b 5c 02 69 08 00 45 00
.V..@..¼¤.. 00 56 8b c7 40 00 80 06 bc a4 d8 e6 00 16 d8 e6
.S...2.Z.g·..P. 00 53 05 99 04 32 05 5a a8 67 b7 8d a7 9c 50 18
.±$. 1f b1 24 c9 00 00 04 01 00 2e 00 00 00 00 a0 09
..password¡. 00 08 70 61 73 73 77 6f 72 64 a1 06 00 02 00 09
.'..nannie...Á. 00 27 80 d1 06 6e 61 6e 6e 69 65 fd 10 00 c1 00
01 00 00 00 00 00 00 00
DBD:Sybase interprets this as:
[root@linux-rad t]# od -c -x r.txt
000 | n a n n i e \0 | \0
6e7c 6e61 696e 0065 007c
011
[root@linux-rad t]#
If this triggers anything with anybody, let me know. I'm going to keep plugging
away at this.
Thanks,
Chris
Mike McCauley wrote:
Hi Chris,
On Feb 24, 4:24pm, Chris Hanes wrote:
Subject: Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
Hi all,
Mike has identified the problem as a NUL character being added to the
password
coming from the SQLServer. The problem appears to be occuring in the
DBD:Sybase
module. I modified some example ct-lib code that came with FreeTDS and it
pulled
strings from the SQLServer fine - no NUL terminator. I also got DBD:FreeTDS
working with Radiator - unfortunately it doesn't seem to want to work with
AuthByRodopi. Anyone else had this problem with DBD:Sybase? It does it in
both
DBD:Sybase version .14 and .21 and it doesn't matter whether I use ct-lib
from
FreeTDS or ct-lib from sybase - the NUL character still shows up. Help!!!
We use DBD-Sybase-0.13 without observing that problem. I wonder if the NULs are
actually in the database, and FreeTDS just happens to strip the trailing NUL
for free (I could imagine a C library doing that).
Anyone else with thoughts?
Thanks,
Chris
Mike McCauley wrote:
Hello Chris,
In order to get a handle on this, we would need to see your Radiator log
file
at trace level 4, showing what Radiator is doing with the request, and why
it
is rejecting it.
Your config file (no secrets) would also be helpful.
Cheers.
On Feb 22, 6:17pm, Chris Hanes wrote:
Subject: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
Hi all,
I've got a Redhat 6.1 Linux box configured with FreeTDS .50, DBD Sybase
.21, Radiator 2.15 attempting to AuthSQL and AuthRodopi to a MS
SQLServer 7.0. After much hassle, I have the network connectivity to
the SQLServer. However, I can't get AuthSQL or AuthRodopi working.
Radiator is looking up passwords correctly on the SQLServer and yet it
still fails the auth request. Here's part of my password log file for
an AuthSQL realm.
Tue Feb 22 17:56:42 2000:951260202:rcochran:yellow:yellow:FAIL
Tue Feb 22 18:11:04 2000:951261064:jladd:nannie:nannie:FAIL
Tue Feb 22 18:11:11 2000:951261071:cahcah:cahcah:cahcah:FAIL
Tue Feb 22 18:11:14 2000:951261074:cahcah:cahcah2:cahcah:FAIL
Any help would be GREATLY appreciated.
Thanks,
Chris Hanes
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
-- End of excerpt from Chris Hanes
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
-- End of excerpt from Chris Hanes
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive
Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
Hi all, Mike has identified the problem as a NUL character being added to the password coming from the SQLServer. The problem appears to be occuring in the DBD:Sybase module. I modified some example ct-lib code that came with FreeTDS and it pulled strings from the SQLServer fine - no NUL terminator. I also got DBD:FreeTDS working with Radiator - unfortunately it doesn't seem to want to work with AuthByRodopi. Anyone else had this problem with DBD:Sybase? It does it in both DBD:Sybase version .14 and .21 and it doesn't matter whether I use ct-lib from FreeTDS or ct-lib from sybase - the NUL character still shows up. Help!!! Thanks, Chris Mike McCauley wrote: Hello Chris, In order to get a handle on this, we would need to see your Radiator log file at trace level 4, showing what Radiator is doing with the request, and why it is rejecting it. Your config file (no secrets) would also be helpful. Cheers. On Feb 22, 6:17pm, Chris Hanes wrote: Subject: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems Hi all, I've got a Redhat 6.1 Linux box configured with FreeTDS .50, DBD Sybase .21, Radiator 2.15 attempting to AuthSQL and AuthRodopi to a MS SQLServer 7.0. After much hassle, I have the network connectivity to the SQLServer. However, I can't get AuthSQL or AuthRodopi working. Radiator is looking up passwords correctly on the SQLServer and yet it still fails the auth request. Here's part of my password log file for an AuthSQL realm. Tue Feb 22 17:56:42 2000:951260202:rcochran:yellow:yellow:FAIL Tue Feb 22 18:11:04 2000:951261064:jladd:nannie:nannie:FAIL Tue Feb 22 18:11:11 2000:951261071:cahcah:cahcah:cahcah:FAIL Tue Feb 22 18:11:14 2000:951261074:cahcah:cahcah2:cahcah:FAIL Any help would be GREATLY appreciated. Thanks, Chris Hanes === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- End of excerpt from Chris Hanes -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
Hi Chris, On Feb 24, 4:24pm, Chris Hanes wrote: Subject: Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems Hi all, Mike has identified the problem as a NUL character being added to the password coming from the SQLServer. The problem appears to be occuring in the DBD:Sybase module. I modified some example ct-lib code that came with FreeTDS and it pulled strings from the SQLServer fine - no NUL terminator. I also got DBD:FreeTDS working with Radiator - unfortunately it doesn't seem to want to work with AuthByRodopi. Anyone else had this problem with DBD:Sybase? It does it in both DBD:Sybase version .14 and .21 and it doesn't matter whether I use ct-lib from FreeTDS or ct-lib from sybase - the NUL character still shows up. Help!!! We use DBD-Sybase-0.13 without observing that problem. I wonder if the NULs are actually in the database, and FreeTDS just happens to strip the trailing NUL for free (I could imagine a C library doing that). Anyone else with thoughts? Thanks, Chris Mike McCauley wrote: Hello Chris, In order to get a handle on this, we would need to see your Radiator log file at trace level 4, showing what Radiator is doing with the request, and why it is rejecting it. Your config file (no secrets) would also be helpful. Cheers. On Feb 22, 6:17pm, Chris Hanes wrote: Subject: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems Hi all, I've got a Redhat 6.1 Linux box configured with FreeTDS .50, DBD Sybase .21, Radiator 2.15 attempting to AuthSQL and AuthRodopi to a MS SQLServer 7.0. After much hassle, I have the network connectivity to the SQLServer. However, I can't get AuthSQL or AuthRodopi working. Radiator is looking up passwords correctly on the SQLServer and yet it still fails the auth request. Here's part of my password log file for an AuthSQL realm. Tue Feb 22 17:56:42 2000:951260202:rcochran:yellow:yellow:FAIL Tue Feb 22 18:11:04 2000:951261064:jladd:nannie:nannie:FAIL Tue Feb 22 18:11:11 2000:951261071:cahcah:cahcah:cahcah:FAIL Tue Feb 22 18:11:14 2000:951261074:cahcah:cahcah2:cahcah:FAIL Any help would be GREATLY appreciated. Thanks, Chris Hanes === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- End of excerpt from Chris Hanes -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- End of excerpt from Chris Hanes -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems
Ok. Here we are - the config and the logfile. Thanks again for the help. Foreground #LogStdout LogDir /usr/local/etc DbDir . Trace 5 DictionaryFile /usr/local/etc/dictionary.usr Client DEFAULT Secret xxx DupInterval 0 /Client Realm DEFAULT PasswordLogFileName ./pwds AuthBy SQL DBSourcedbi:Sybase:rd3 DBUsername phone DBAuth AuthSelect select password from Users where user_name='%n' #AuthColumnDef 0, User-Password, check /AuthBy /Realm Realm i-c.net RewriteUsername s/^([^@]+).*/$1/ PasswordLogFileName ./pwds2 AuthBy RODOPI DBSourcedbi:Sybase:rd3 DBUsername ROD2login DBAuth xxx /AuthBy /Realm And the logfile -Original Message- From: Mike McCauley [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Tuesday, February 22, 2000 10:12 PM Subject: Re: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems Hello Chris, In order to get a handle on this, we would need to see your Radiator log file at trace level 4, showing what Radiator is doing with the request, and why it is rejecting it. Your config file (no secrets) would also be helpful. Cheers. On Feb 22, 6:17pm, Chris Hanes wrote: Subject: (RADIATOR) DBD::Sybase/FreeTDS/MSSQL7 Problems Hi all, I've got a Redhat 6.1 Linux box configured with FreeTDS .50, DBD Sybase .21, Radiator 2.15 attempting to AuthSQL and AuthRodopi to a MS SQLServer 7.0. After much hassle, I have the network connectivity to the SQLServer. However, I can't get AuthSQL or AuthRodopi working. Radiator is looking up passwords correctly on the SQLServer and yet it still fails the auth request. Here's part of my password log file for an AuthSQL realm. Tue Feb 22 17:56:42 2000:951260202:rcochran:yellow:yellow:FAIL Tue Feb 22 18:11:04 2000:951261064:jladd:nannie:nannie:FAIL Tue Feb 22 18:11:11 2000:951261071:cahcah:cahcah:cahcah:FAIL Tue Feb 22 18:11:14 2000:951261074:cahcah:cahcah2:cahcah:FAIL Any help would be GREATLY appreciated. Thanks, Chris Hanes === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- End of excerpt from Chris Hanes -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody logfile
RE: (RADIATOR) DBD::Sybase
Hello, This is a little off topic but I'm having problems getting the make test on DBD::Sybase working and maybe someone here could offer me a few pointers. [root@scorpion DBD-Sybase-0.21]# perl Makefile.PL Using DBI 1.13 installed in /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI Writing Makefile for DBD::Sybase [root@scorpion DBD-Sybase-0.21]# make cc -c -I/opt/sybase/include -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto /DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2-DVERSION=\"0.21\" - DXS_VERSION=\"0.21\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE Sybase.c cc -c -I/opt/sybase/include -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto /DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2-DVERSION=\"0.21\" - DXS_VERSION=\"0.21\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE dbdimp.c Running Mkbootstrap for DBD::Sybase () chmod 644 Sybase.bs LD_RUN_PATH="/opt/sybase/lib:/lib" cc -o lib/arch/auto/DBD/Sybase/Sybase.so -L/opt/sybase/lib -shared -L/usr/local/l ib Sybase.o dbdimp.o-L/opt/sybase/lib -lct -lcs -lsybtcl -lcomn -lintl -linsck -lm chmod 755 blib/arch/auto/DBD/Sybase/Sybase.so cp Sybase.bs blib/arch/auto/DBD/Sybase/Sybase.bs chmod 644 blib/arch/auto/DBD/Sybase/Sybase.bs Manifying blib/man3/DBD::Sybase.3 [root@scorpion DBD-Sybase-0.21]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/ usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/autocommitCan't call method "do" on an undefined value at t/autocommit.t line 45. dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Test/Harness.pm line 288. make: *** [test_dynamic] Error 255 Anyone got any ideas on what I could be doing wrong? Regards, Leigh Spiegel [EMAIL PROTECTED] http://www.winshop.com.au/ === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) DBD::Sybase
Hi Leigh, Glad you have made some more progress. Looks like the DBD-Sybase is expecting some behaviour that ouyr MS_SQL does not have. We have tested with DBD-Sybase-0.13 and MS-SQL 6.5 without those problems. Might suggest you downgrade to 0.13? Cheers. On Feb 18, 11:33am, Leigh Spiegel wrote: Subject: RE: (RADIATOR) DBD::Sybase Hello, I managed to get a little further with this problem, I didn't have anything set in /opt/sybase/interfaces now make test reports the following: [root@scorpion DBD-Sybase-0.21]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/ usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/autocommitok t/base..ok t/fail..Panic: dynamic SQL (? placeholders) are not supported by the server you are connecting to at blib/lib/DBD/Sybase.pm line 95. dubious Test returned status 11 (wstat 2816, 0xb00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Test/Harness.pm line 288. make: *** [test_dynamic] Error 11 Regards, Leigh Spiegel [EMAIL PROTECTED] http://www.winshop.com.au/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Leigh Spiegel Sent: Friday, February 18, 2000 10:55 To: [EMAIL PROTECTED] Subject: RE: (RADIATOR) DBD::Sybase Hello, This is a little off topic but I'm having problems getting the make test on DBD::Sybase working and maybe someone here could offer me a few pointers. [root@scorpion DBD-Sybase-0.21]# perl Makefile.PL Using DBI 1.13 installed in /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI Writing Makefile for DBD::Sybase [root@scorpion DBD-Sybase-0.21]# make cc -c -I/opt/sybase/include -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto /DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2 -DVERSION=\"0.21\" - DXS_VERSION=\"0.21\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE Sybase.c cc -c -I/opt/sybase/include -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto /DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2 -DVERSION=\"0.21\" - DXS_VERSION=\"0.21\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE dbdimp.c Running Mkbootstrap for DBD::Sybase () chmod 644 Sybase.bs LD_RUN_PATH="/opt/sybase/lib:/lib" cc -o lib/arch/auto/DBD/Sybase/Sybase.so -L/opt/sybase/lib -shared -L/usr/local/l ib Sybase.o dbdimp.o-L/opt/sybase/lib -lct -lcs -lsybtcl -lcomn -lintl -linsck -lm chmod 755 blib/arch/auto/DBD/Sybase/Sybase.so cp Sybase.bs blib/arch/auto/DBD/Sybase/Sybase.bs chmod 644 blib/arch/auto/DBD/Sybase/Sybase.bs Manifying blib/man3/DBD::Sybase.3 [root@scorpion DBD-Sybase-0.21]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/ usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/autocommitCan't call method "do" on an undefined value at t/autocommit.t line 45. dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Test/Harness.pm line 288. make: *** [test_dynamic] Error 255 Anyone got any ideas on what I could be doing wrong? Regards, Leigh Spiegel [EMAIL PROTECTED] http://www.winshop.com.au/ === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- End of excerpt from Leigh Spiegel -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) DBD::Sybase
On Fri, Feb 18, 2000 at 12:49:29PM -0500, Mike McCauley wrote: Hi Leigh, Glad you have made some more progress. Looks like the DBD-Sybase is expecting some behaviour that ouyr MS_SQL does not have. We have tested with DBD-Sybase-0.13 and MS-SQL 6.5 without those problems. Might suggest you downgrade to 0.13? I have DBD-Sybase-0.21 and MS6.5 going ok. I never concerned myself with the failures from make test - there leads to the path to madness (ie the author says they will probably never succeed while the version is below 1). [EMAIL PROTECTED] === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
RE: (RADIATOR) DBD::Sybase
Hi Mike, I tried 0.14, I couldn't find 0.13 on CPAN. The results, not good unfortunately: [root@scorpion DBD-Sybase-0.14]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/ usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/base..install_driver(Sybase) failed: Can't load 'blib/arch/auto/DBD/Sybase/Sybase.so' for module DBD::Sybase: /opt/sybase/lib/libct.so: undefined symbol: scl_sess_alloc at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/base.t line 18 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Test/Harness.pm line 288. make: *** [test_dynamic] Error 255 While I was at CPAN I grabbed every other version I could find: This one look likes it works: [root@scorpion DBD-Sybase-0.20]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/ usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/autocommitok t/base..ok t/login.ok t/main..ok t/place.?-style placeholders aren't supported with this SQL Server. ok All tests successful. Files=5, Tests=35, 3 wallclock secs ( 1.42 cusr + 0.11 csys = 1.53 CPU) I guess this is good, will radiator use placeholders? If so I guess I still have a problem. Regards, Leigh Spiegel [EMAIL PROTECTED] http://www.winshop.com.au/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike McCauley Sent: Friday, February 18, 2000 9:49 To: Leigh Spiegel; [EMAIL PROTECTED] Subject: Re: (RADIATOR) DBD::Sybase Hi Leigh, Glad you have made some more progress. Looks like the DBD-Sybase is expecting some behaviour that ouyr MS_SQL does not have. We have tested with DBD-Sybase-0.13 and MS-SQL 6.5 without those problems. Might suggest you downgrade to 0.13? Cheers. On Feb 18, 11:33am, Leigh Spiegel wrote: Subject: RE: (RADIATOR) DBD::Sybase Hello, I managed to get a little further with this problem, I didn't have anything set in /opt/sybase/interfaces now make test reports the following: [root@scorpion DBD-Sybase-0.21]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/ usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/autocommitok t/base..ok t/fail..Panic: dynamic SQL (? placeholders) are not supported by the server you are connecting to at blib/lib/DBD/Sybase.pm line 95. dubious Test returned status 11 (wstat 2816, 0xb00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Test/Harness.pm line 288. make: *** [test_dynamic] Error 11 Regards, Leigh Spiegel [EMAIL PROTECTED] http://www.winshop.com.au/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Leigh Spiegel Sent: Friday, February 18, 2000 10:55 To: [EMAIL PROTECTED] Subject: RE: (RADIATOR) DBD::Sybase Hello, This is a little off topic but I'm having problems getting the make test on DBD::Sybase working and maybe someone here could offer me a few pointers. [root@scorpion DBD-Sybase-0.21]# perl Makefile.PL Using DBI 1.13 installed in /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI Writing Makefile for DBD::Sybase [root@scorpion DBD-Sybase-0.21]# make cc -c -I/opt/sybase/include -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto /DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2 -DVERSION=\"0.21\" - DXS_VERSION=\"0.21\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE Sybase.c cc -c -I/opt/sybase/include -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto /DBI -Dbool=char -DHAS_BOOL -I/usr/local/include -O2 -DVERSION=\"0.21\" - DXS_VERSION=\"0.21\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE dbdimp.c Running Mkbootstrap for DBD::Sybase () chmod 644 Sybase.bs LD_RUN_PATH="/opt/sybase/lib:/lib" cc -o lib/arch/auto/DBD/Sybase/Sybase.so -L/opt/sybase/lib -shared -L/usr/local/l ib Sybase.o dbdimp.o-L/opt/sybase/lib -lct -lcs -lsybtcl -lcomn -lintl -linsck -lm chmod 755 blib/arch/auto/DBD/Sybase/Sybase.so cp Sybase.bs blib/arch/auto/DBD/Sybase/Sybase.bs chmod 644 blib/arch/auto/DBD/Sybase/Sybase.bs Manifying blib/man3/DBD::Sybase.3 [root@scorpion DBD-Sybase-0.21]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/ usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/autocommitCa
RE: (RADIATOR) DBD::Sybase
Hello Leigh - On Sat, 19 Feb 2000, Leigh Spiegel wrote: Hi Mike, I tried 0.14, I couldn't find 0.13 on CPAN. The results, not good unfortunately: [root@scorpion DBD-Sybase-0.14]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/ usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/base..install_driver(Sybase) failed: Can't load 'blib/arch/auto/DBD/Sybase/Sybase.so' for module DBD::Sybase: /opt/sybase/lib/libct.so: undefined symbol: scl_sess_alloc at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. at (eval 1) line 3 at t/base.t line 18 dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Test/Harness.pm line 288. make: *** [test_dynamic] Error 255 While I was at CPAN I grabbed every other version I could find: This one look likes it works: [root@scorpion DBD-Sybase-0.20]# make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/ usr/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/autocommitok t/base..ok t/login.ok t/main..ok t/place.?-style placeholders aren't supported with this SQL Server. ok All tests successful. Files=5, Tests=35, 3 wallclock secs ( 1.42 cusr + 0.11 csys = 1.53 CPU) I guess this is good, will radiator use placeholders? If so I guess I still have a problem. This definitely looks better. And no - Radiator only does a very simple select statement to authenticate a user, so the ?-style placeholders shouldn't be a problem. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
