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.
(RADIATOR) 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.
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.
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:
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,
> > &
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 Secret xxx DupInterval 0 PasswordLogFileName ./pwds DBSourcedbi:Sybase:rd3 DBUsername phone DBAuth AuthSelect select password from Users where user_name='%n' #AuthColumnDef 0, User-Password, check RewriteUsername s/^([^@]+).*/$1/ PasswordLogFileName ./pwds2 DBSourcedbi:Sybase:rd3 DBUsername ROD2login DBAuth xxx 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/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 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(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.
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.
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-l
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 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
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.
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.
(RADIATOR) DBD-Sybase
I am using Radiator and RODOPI as my billign system .. I can't seem to find the Sybase Client needed for Radiator .. All I have found is the DBD-Sybase DBD-Sybase-0.13.tar.gz anyone know where I can find the Sybase client library?
Re: (RADIATOR) DBD-Sybase 0.13 test failing on make test
Hi Yen, On Feb 9, 10:29am, Yen Choi wrote: > Subject: (RADIATOR) DBD-Sybase 0.13 test failing on make test > I feel as though I am 95% there! Im sorry its been such hard work. > > When I do a make test, it t/place fails with the following: > > I am using Redhat 5.2 and trying to connect to NT SQL 6.5. > sqsh works I suspect the test routine doesnt like the fact that its MS-SQL at the other end. I would be inclined to ignore the test results and try it out with Radiator now. Radiator does not use SQL placeholders I think you _are_ 95% of the way towards getting a working system. Cheers. > > ___begin snippet > > [root@cheetah DBD-Sybase-0.13]# make test > make -f Makefile.aperl perl > make[1]: Entering directory `/tmp/DBD-Sybase-0.13' > make[1]: `perl' is up to date. > make[1]: Leaving directory `/tmp/DBD-Sybase-0.13' > PERL_DL_NONLAZY=1 ./perl -Iblib/arch -Iblib/lib > -I/usr/lib/perl5/i386-linux/5.00502 -I/usr/lib/perl5/5.00502 -e 'use > Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t > > t/base..ok > t/login.ok > t/main..ok > t/place.Panic: dynamic SQL (? placeholders) are not > supported by the server you are connecting to at blib/lib/DBD/Sybase.pm > line 92. > Database handle destroyed without explicit disconnect. > dubious > Test returned status 11 (wstat 2816, 0xb00) > Undefined subroutine &Test::Harness::WCOREDUMP called at > /usr/lib/perl5/5.00502/Test/Harness.pm line 288. > make: *** [test_static] Error 2 > [root@cheetah DBD-Sybase-0.13]# > > -end > snippet- > > > Q: I know that Sybase is similar to NTSQL, are dynamic placeholders > something I should be concerned about? or am I not really 95% there? > > Thanks > > > > === > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. >-- End of excerpt from Yen Choi -- Mike McCauley[EMAIL PROTECTED] Open System Consultants Pty. Ltd Unix, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 AustraliaConsulting and development Phone, Fax: +61 3 9598-0985 http://www.open.com.au Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, external, etc etc etc on Unix, Win95, NT, Rhapsody === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) DBD-Sybase 0.13 test failing on make test
I feel as though I am 95% there! When I do a make test, it t/place fails with the following: I am using Redhat 5.2 and trying to connect to NT SQL 6.5. sqsh works ___begin snippet [root@cheetah DBD-Sybase-0.13]# make test make -f Makefile.aperl perl make[1]: Entering directory `/tmp/DBD-Sybase-0.13' make[1]: `perl' is up to date. make[1]: Leaving directory `/tmp/DBD-Sybase-0.13' PERL_DL_NONLAZY=1 ./perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/i386-linux/5.00502 -I/usr/lib/perl5/5.00502 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/base..ok t/login.ok t/main..ok t/place.Panic: dynamic SQL (? placeholders) are not supported by the server you are connecting to at blib/lib/DBD/Sybase.pm line 92. Database handle destroyed without explicit disconnect. dubious Test returned status 11 (wstat 2816, 0xb00) Undefined subroutine &Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00502/Test/Harness.pm line 288. make: *** [test_static] Error 2 [root@cheetah DBD-Sybase-0.13]# -end snippet- Q: I know that Sybase is similar to NTSQL, are dynamic placeholders something I should be concerned about? or am I not really 95% there? Thanks === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
