RE: (RADIATOR) FreeTDS DBD-Sybase Install
Title: RE: (RADIATOR) FreeTDS DBD-Sybase Install I've never managed to get DBD::Sybase to pass all of its tests, but the install has then worked fine. Instead of using the standard tests, might I suggest you roll your own - a swift perl script that tests a representative sample of the sort of queries you're going to be throwing at it live. I did this, got a build that worked correctly for the script, and have been running the build in production for over a year without problems. Then again, that was with freetds-0.53rc2 and DBD::Sybase 0.93 on Mandrake and BSD/OS, so YMMV. -Original Message- From: Tim Jung [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 10:31 AM To: [EMAIL PROTECTED] Subject: (RADIATOR) FreeTDS DBD-Sybase Install I am having a problem getting all the perl modules and database stuff installed correctly on my Red Hat 8.0 server. I was wondering if anyone might be able to help. I have installed all the MD4, MD5, LDAP, DBI modules without any problems. I am now working on getting the FreeTDS and DBD-Sybase stuff installed. I am trying to connect to a Windows 2000 SP3 server running MSSQL 7.0 SP3. I have downloaded both the FreeTDS v0.60 and today's CVS snapshot of v0.61 and I have tried telling it to do any one of the following: ./configure --with-tdsver=4.2 ./configure --with-tdsver=7.0 ./configure --with-tdsver=8.0 It compiles both v0.60 v0.61 versions with no errors and whatever version of the TDS protocol that I tell it. I then try and install the DBD-Sybase v0.95 module without much luck. If I use the FreeTDS v0.60 I then have to edit the DBD-Sybase file dbdimp.c and change all cs_ctx_global() to cs_ctx_alloc() to get it to compile at all. If I use the current snapshot of FreeTDS I don't have to do this. Regardless no matter which way I do it I can't seem to get the DBD-Sybase v0.95 to pass all the make test tests with 100%. I get from 84% to 86% of the tests passed. Now my question is which version of the TDS protocol should I be using for MSSQL 7.0 SP3? The other question is, am I getting these errors because I somehow screwed up my tempdb database trying all these different versions of the software or should I just ignore the errors since it won't pass all the tests but it will work well enough for Radiator? In case it matters I am using Radiator-Demo 3.5, and I eventually want to connect it to Rodopi v5.2 SP3. Any help that anyone can give me would be appreciated. Tim Jung System Admin Internet Gateway [EMAIL PROTECTED] === 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) FreeTDS DBD-Sybase Install
RE: (RADIATOR) FreeTDS DBD-Sybase InstallI found this information on the internet. There is an open source project - FreeTDS, http://www.freetds.org/ - to create an interface to TDS-compliant database servers such as Sybase and, MS SQL. MS SQL 7.0 speaks TDS version 7.0, but will also speak TDS 4.2. The distinction twixt 4.2 and 7.0 seems to be support for unicode and long varchars. The TDS 7.0 support in FreeTDS is incomplete. By building the OpenTDS code for the 4.2 protocol level, you get libraries that can talk to MS SQL 7.0 - presumably, so long as the databases aren't unicode and don't use long varchars. Does Radiator use Unicode or long varchars when talking to MS-SQL 7.0 using the Rodopi Auth? Tim Jung System Admin Internet Gateway [EMAIL PROTECTED] - Original Message - From: Matthew Trout To: 'Tim Jung' ; [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 6:53 AM Subject: RE: (RADIATOR) FreeTDS DBD-Sybase Install I've never managed to get DBD::Sybase to pass all of its tests, but the install has then worked fine. Instead of using the standard tests, might I suggest you roll your own - a swift perl script that tests a representative sample of the sort of queries you're going to be throwing at it live. I did this, got a build that worked correctly for the script, and have been running the build in production for over a year without problems. Then again, that was with freetds-0.53rc2 and DBD::Sybase 0.93 on Mandrake and BSD/OS, so YMMV. -Original Message- From: Tim Jung [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 10:31 AM To: [EMAIL PROTECTED] Subject: (RADIATOR) FreeTDS DBD-Sybase Install I am having a problem getting all the perl modules and database stuff installed correctly on my Red Hat 8.0 server. I was wondering if anyone might be able to help. I have installed all the MD4, MD5, LDAP, DBI modules without any problems. I am now working on getting the FreeTDS and DBD-Sybase stuff installed. I am trying to connect to a Windows 2000 SP3 server running MSSQL 7.0 SP3. I have downloaded both the FreeTDS v0.60 and today's CVS snapshot of v0.61 and I have tried telling it to do any one of the following: ./configure --with-tdsver=4.2 ./configure --with-tdsver=7.0 ./configure --with-tdsver=8.0 It compiles both v0.60 v0.61 versions with no errors and whatever version of the TDS protocol that I tell it. I then try and install the DBD-Sybase v0.95 module without much luck. If I use the FreeTDS v0.60 I then have to edit the DBD-Sybase file dbdimp.c and change all cs_ctx_global() to cs_ctx_alloc() to get it to compile at all. If I use the current snapshot of FreeTDS I don't have to do this. Regardless no matter which way I do it I can't seem to get the DBD-Sybase v0.95 to pass all the make test tests with 100%. I get from 84% to 86% of the tests passed. Now my question is which version of the TDS protocol should I be using for MSSQL 7.0 SP3? The other question is, am I getting these errors because I somehow screwed up my tempdb database trying all these different versions of the software or should I just ignore the errors since it won't pass all the tests but it will work well enough for Radiator? In case it matters I am using Radiator-Demo 3.5, and I eventually want to connect it to Rodopi v5.2 SP3. Any help that anyone can give me would be appreciated. Tim Jung System Admin Internet Gateway [EMAIL PROTECTED] === 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) FreeTDS DBD-Sybase Install
I found this out from the author of the DBD::Sybase module. He posted this to the FreeTDS mailing list back in October 2002. He is specifically talking about the errors that are generated when you run the 'make test' option on the DBD::Sybase module using FreeTDS. No. I haven't followed things here closely, but unless FreeTDS now supports dynamic sql for the MS-SQL version of TDS (i.e. ct_dynamic() and friends) then you will get these errors. DBD::Sybase also uses the ct_command(CS_RPC_CMD) and ct_param() calls, and I don't know if these are properly supported yet. And thirdly DBD::Sybase gives access to the ct_get/send_data() primitives (to read/write BLOB data in chunks). Again I don't know if these are supported by FreeTDS. All of these are tested (to some extent) during make test, and will cause errors if they are not implemented. So it would look like that until more work is done on FreeTDS that it doesn't support 100% of everything that MS-SQL is capable of doing. Thus the DBD::Sybase won't pass all the 'make test' tests using FreeTDS v0.60 or the CVS version v0.61 as of today. I guess it is possible that the release version of v0.61 might up the level of support though. Although it would seem than 85%-86% support isn't too bad for an Open Source package talking to a commercial closed source database. :) So the question that remains is which version of the TDS protocol is needed to talk with MS-SQL 7.0 SP3 so Radiator can talk to the Rodopi databases? Should I use the 4.2 protocol or the 7.0 protocol? Specifically I am interested in using the Auth Rodopi stuff in Radiator. Anyone here know for sure? Tim Jung System Admin Internet Gateway [EMAIL PROTECTED] - Original Message - From: Matthew Trout To: 'Tim Jung' ; [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 6:53 AM Subject: RE: (RADIATOR) FreeTDS DBD-Sybase Install I've never managed to get DBD::Sybase to pass all of its tests, but the install has then worked fine. Instead of using the standard tests, might I suggest you roll your own - a swift perl script that tests a representative sample of the sort of queries you're going to be throwing at it live. I did this, got a build that worked correctly for the script, and have been running the build in production for over a year without problems. Then again, that was with freetds-0.53rc2 and DBD::Sybase 0.93 on Mandrake and BSD/OS, so YMMV. -Original Message- From: Tim Jung [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 10:31 AM To: [EMAIL PROTECTED] Subject: (RADIATOR) FreeTDS DBD-Sybase Install I am having a problem getting all the perl modules and database stuff installed correctly on my Red Hat 8.0 server. I was wondering if anyone might be able to help. I have installed all the MD4, MD5, LDAP, DBI modules without any problems. I am now working on getting the FreeTDS and DBD-Sybase stuff installed. I am trying to connect to a Windows 2000 SP3 server running MSSQL 7.0 SP3. I have downloaded both the FreeTDS v0.60 and today's CVS snapshot of v0.61 and I have tried telling it to do any one of the following: ./configure --with-tdsver=4.2 ./configure --with-tdsver=7.0 ./configure --with-tdsver=8.0 It compiles both v0.60 v0.61 versions with no errors and whatever version of the TDS protocol that I tell it. I then try and install the DBD-Sybase v0.95 module without much luck. If I use the FreeTDS v0.60 I then have to edit the DBD-Sybase file dbdimp.c and change all cs_ctx_global() to cs_ctx_alloc() to get it to compile at all. If I use the current snapshot of FreeTDS I don't have to do this. Regardless no matter which way I do it I can't seem to get the DBD-Sybase v0.95 to pass all the make test tests with 100%. I get from 84% to 86% of the tests passed. Now my question is which version of the TDS protocol should I be using for MSSQL 7.0 SP3? The other question is, am I getting these errors because I somehow screwed up my tempdb database trying all these different versions of the software or should I just ignore the errors since it won't pass all the tests but it will work well enough for Radiator? In case it matters I am using Radiator-Demo 3.5, and I eventually want to connect it to Rodopi v5.2 SP3. Any help that anyone can give me would be appreciated. Tim Jung System Admin Internet Gateway [EMAIL PROTECTED] === 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) FreeTDS DBD-Sybase Install
Tim Jung wrote: I found this out from the author of the DBD::Sybase module. He posted this to the FreeTDS mailing list back in October 2002. He is specifically talking about the errors that are generated when you run the 'make test' option on the DBD::Sybase module using FreeTDS. So it would look like that until more work is done on FreeTDS that it doesn't support 100% of everything that MS-SQL is capable of doing. Thus Exactly. However, everything Radiator needs by default is supported. The reason why we dropped FreeTDS is because it didn't know how to handle broken connections, and hung perl. We still use FreeTDS with PHP. It's quirky, but we got it to work for what we need it to do. the DBD::Sybase won't pass all the 'make test' tests using FreeTDS v0.60 or the CVS version v0.61 as of today. I guess it is possible that the release version of v0.61 might up the level of support though. Although it would seem than 85%-86% support isn't too bad for an Open Source package talking to a commercial closed source database. :) Knowing that they don't have specs and need to reverse engineer, it's an achievement, however they had problems such as memory leaks and buffer overflows/segfaults in FreeTDS, which suggests they put features first, and stability/quality second. Not good. So the question that remains is which version of the TDS protocol is needed to talk with MS-SQL 7.0 SP3 so Radiator can talk to the Rodopi databases? Should I use the 4.2 protocol or the 7.0 protocol? Specifically I am interested in using the Auth Rodopi stuff in Radiator. Anyone here know for sure? If you read their documentation you'd know it's TDS 7.0. Have fun. === 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) Freetds and radius
Just a warning, the FreeTDS 5.0 and 5.1 both have given us alot of trouble with memory leaks. We had about 2000 incoming lines and authenticated on mysql, but sent out accounting to a MS SQL 6.5 server using DBD:Sybase 0.23 and FreeTDS (both versions above). Memory leaked such that 4 days run time left us with 50mb in memory for the radiator process. We decided to move accounting to Mysql instead and use a perl script to dump the contents of the accounting table into the MS SQL server on a regular interval. Hugh Irvine wrote: Hello Greg - On Fri, 15 Dec 2000, Greg Kornatowsky wrote: We are running SQL Server 7. Will the free Sybase drivers work with version 7? We are currently using OpenLink but it keeps crashing, we are looking for a backup solution. Yes. There is a patch for the first release MS-SQL 7 to fix the Sybase connectivity that was broken initially. This topic has been discussed on the list previously and there is something in the Radiator FAQ as well. regards Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- Stephen Comoletti - Network Engineer / Systems Administrator Delanet Inc. http://www.delanet.com Frontline Communications Corp. http://www.fcc.net phone: (302) 326-5800 fax: (302) 326-5802 x312 262 Quigley Blvd, New Castle, DE 19720, USA S/MIME Cryptographic Signature
RE: (RADIATOR) Freetds and radius
We are running SQL Server 7. Will the free Sybase drivers work with version 7? We are currently using OpenLink but it keeps crashing, we are looking for a backup solution. Greg Tyler ZooLink -Original Message- From: Hugh Irvine [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 6:53 PM To: Tyler Woodworth; '[EMAIL PROTECTED]' Subject: Re: (RADIATOR) Freetds and radius Hello Tyler - On Tue, 12 Dec 2000, Tyler Woodworth wrote: Recently I was using the OpenLink Drivers to connect to my MS SQL 7 database from my Linux computer running Radiator, and everything was working fine. Now I have installed FreeTDS and DBD-Sybase to connect to my database. In my radius.cfg I am using AuthBy EMERALD. This is the error message I get whenever an authentication comes in. Mon Dec 11 16:26:59 2000: ERR: Execute failed for 'select ra.RadAttributeID, Data, Value, Type from RadATConfigs rc, RadAttributes ra where ra.RadAttributeID = rc.RadAttributeID and rc.AccountType='PPP'': Server message number=105 severity=15 state=1 line=4 server=BECKS text=Unclosed quotation mark before the character string 'PPP'.Server message number=170 severity=15 state=1 line=4 server=BECKS text=Line 4: Incorrect syntax near 'PPP'. You do not have to use both FreeTDS and DBD-Sybase, you should just use DBD-Sybase and the free Sybase distribution for Linux. If you are not running on Linux, you may find that just using the DBD-Proxy module is a better approach. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
RE: (RADIATOR) Freetds and radius
Hello Greg - On Fri, 15 Dec 2000, Greg Kornatowsky wrote: We are running SQL Server 7. Will the free Sybase drivers work with version 7? We are currently using OpenLink but it keeps crashing, we are looking for a backup solution. Yes. There is a patch for the first release MS-SQL 7 to fix the Sybase connectivity that was broken initially. This topic has been discussed on the list previously and there is something in the Radiator FAQ as well. regards Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Freetds and radius
Hello Tyler - On Tue, 12 Dec 2000, Tyler Woodworth wrote: Recently I was using the OpenLink Drivers to connect to my MS SQL 7 database from my Linux computer running Radiator, and everything was working fine. Now I have installed FreeTDS and DBD-Sybase to connect to my database. In my radius.cfg I am using AuthBy EMERALD. This is the error message I get whenever an authentication comes in. Mon Dec 11 16:26:59 2000: ERR: Execute failed for 'select ra.RadAttributeID, Data, Value, Type from RadATConfigs rc, RadAttributes ra where ra.RadAttributeID = rc.RadAttributeID and rc.AccountType='PPP'': Server message number=105 severity=15 state=1 line=4 server=BECKS text=Unclosed quotation mark before the character string 'PPP'.Server message number=170 severity=15 state=1 line=4 server=BECKS text=Line 4: Incorrect syntax near 'PPP'. You do not have to use both FreeTDS and DBD-Sybase, you should just use DBD-Sybase and the free Sybase distribution for Linux. If you are not running on Linux, you may find that just using the DBD-Proxy module is a better approach. hth Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
RE: (RADIATOR) Freetds and radius
We are not using any custom SQL, only what is included in the AuthEmerald.pm
This is the perl source which is generating the SQL which is causing the
error.
# We only get the Account Type configs if there were no per
# user configs, or if AddATDefaults is set
if (!$got_configs)
{
$q = "select ra.RadAttributeID, Data, Value, Type
from RadATConfigs rc, RadAttributes ra
where ra.RadAttributeID = rc.RadAttributeID
and rc.AccountType='$account_type'";
$sth = $self-prepareAndExecute($q);
return undef unless $sth;
Greg Kornatowsky
ZooLink
-Original Message-
From: Mike McCauley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 12:07 PM
To: [EMAIL PROTECTED]
Subject: RE: (RADIATOR) Freetds and radius
--- Forwarded mail from [EMAIL PROTECTED]
Date: Tue, 12 Dec 2000 13:10:19 +1100 (EST)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from ["Ernest
G.
Wilson II" [EMAIL PROTECTED]]
From mikem Tue Dec 12 13:10:15 2000
Received: by oscar.open.com.au (8.9.0/8.9.0) id NAA07625
for [EMAIL PROTECTED]; Tue, 12 Dec 2000 13:10:14 +1100 (EST)
Received: from mail.delanet.com (mail-20.delanet.com [216.226.64.26]) by
perki.connect.com.au with SMTP id MAA25250
(8.8.8/IDA-1.7 for [EMAIL PROTECTED]); Tue, 12 Dec 2000 12:54:08
+1100
(EST)
Received: from mail.delanet.com (mail-20.delanet.com [216.226.64.26]) by
perki.connect.com.au with SMTP id MAA25250
(8.8.8/IDA-1.7 for [EMAIL PROTECTED]); Tue, 12 Dec 2000 12:54:08
+1100
(EST)
Received: (qmail 34545 invoked from network); 12 Dec 2000 01:45:58 -
Received: from unknown (HELO ernie) (216.226.64.59)
by mail.delanet.com with SMTP; 12 Dec 2000 01:45:58 -
From: "Ernest G. Wilson II" [EMAIL PROTECTED]
To: "Tyler Woodworth" [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: (RADIATOR) Freetds and radius
Date: Mon, 11 Dec 2000 20:53:58 -0500
Message-ID: [EMAIL PROTECTED]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
In-Reply-To: [EMAIL PROTECTED]
Importance: Normal
Content-Type: text/plain;
charset="iso-8859-1"
Check your SQL, you may have an extra quote after:
rc.AccountType='PPP''
It looks like two quotes after PPP, see above, also noted in your error
message below.
Thank you.
Ernest G. Wilson II
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Tyler Woodworth
Sent: Monday, December 11, 2000 7:35 PM
To: '[EMAIL PROTECTED]'
Subject: (RADIATOR) Freetds and radius
Recently I was using the OpenLink Drivers to connect to my MS SQL 7 database
from my Linux computer running Radiator, and everything was working fine.
Now I have installed FreeTDS and DBD-Sybase to connect to my database. In
my radius.cfg I am using AuthBy EMERALD. This is the error message I get
whenever an authentication comes in.
Mon Dec 11 16:26:59 2000: ERR: Execute failed for 'select ra.RadAttributeID,
Data, Value, Type
from RadATConfigs rc, RadAttributes ra
where ra.RadAttributeID = rc.RadAttributeID
and rc.AccountType='PPP'': Server message number=105 severity=15 state=1
line=4 server=BECKS text=Unclosed quotation mark before the character string
'PPP'.Server message number=170 severity=15 state=1 line=4 server=BECKS
text=Line 4: Incorrect syntax near 'PPP'.
Any suggestions? Thanks in advance.
Tyler Woodworth
ZooLink Communications
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
---End of forwarded mail from [EMAIL PROTECTED]
--
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, Active Directory etc etc
on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
RE: (RADIATOR) FreeTDS
More than likely what's happening is you don't have SYBASE exported correctly. FreeTDS will say 'failed to connect to 0.0.0.0:0 in its error log if it can't find the DSN name in a interfaces file (because SYBASE isn't exported to /usr/local/freetds/) -Original Message- From: Dean Brandt [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 12:39 AM To: [EMAIL PROTECTED] Subject: (RADIATOR) FreeTDS Hi, I have this as part of my radius.cfg file: Realm xxx.com.au RewriteUsername s/^([^@]+).*/$1/ AuthBy PLATYPUS DBSourcedbi:FreeTDS:plat DBUsername xxx DBAuth xxx /AuthBy But I am getting cannot connect to SQL database errors in my log file. Am I calling it correctly in the cfg? I installed the FreeTDS snapshot file perl module) as per the FAQ, and installed FreeTDS stating the version number as 4.2 (to connect to MS SQL 7.0), I also have an interfaces file that looks like this: plat query tcp ether 203.44.37.26 1433 master tcp ether 203.44.37.26 1433 Am I missing anything here? Thanks -- Dean Brandt Technical Director Cain Internet Services Pty Ltd ACN 091949405 Ph 61-3-95231065 Distributor of Patton RAS equipment www.cain.com.au === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) FreeTDS
Dean, Your DBSource line is incorrect. Form as follows: DBSource dbi:FreeTDS:database=radius;host=your.host.com;port=1433 Also, I'm not sure if using a version of 4.2 will work or not on MS SQL 7.0, however I am using a version of 7.0 on my FreeTDS with no problems as yet. It is a test server and not production though. Regards, Stephen Comoletti - Network Engineer / Systems Administrator Delanet Inc. http://www.delanet.com Frontline Communications Corp. http://www.fcc.net phone: (302) 326-5800 fax: (302) 326-5802 x312 262 Quigley Blvd, New Castle, DE 19720, USA Dean Brandt wrote: Hi, I have this as part of my radius.cfg file: Realm xxx.com.au RewriteUsername s/^([^@]+).*/$1/ AuthBy PLATYPUS DBSourcedbi:FreeTDS:plat DBUsername xxx DBAuth xxx /AuthBy But I am getting cannot connect to SQL database errors in my log file. Am I calling it correctly in the cfg? I installed the FreeTDS snapshot file perl module) as per the FAQ, and installed FreeTDS stating the version number as 4.2 (to connect to MS SQL 7.0), I also have an interfaces file that looks like this: plat query tcp ether 203.44.37.26 1433 master tcp ether 203.44.37.26 1433 Am I missing anything here? Thanks -- Dean Brandt Technical Director Cain Internet Services Pty Ltd ACN 091949405 Ph 61-3-95231065 Distributor of Patton RAS equipment www.cain.com.au === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- S/MIME Cryptographic Signature
Re: (RADIATOR) FreeTDS error messages: Unknown property 7/...results pending
i meant to post the same message... it does appear to be harmful because its causing my system to fall back to a flat file (i have auth groups set up just in case sql is down). the sql queries seam to work until the server gets busy, then it starts returning enough errors for radiator to temporarily stop sql logins. i need a solution for this one too derek - Original Message - From: Stuart Henderson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 26, 1999 2:59 PM Subject: (RADIATOR) FreeTDS error messages: Unknown property 7/...results pending Hi, does anyone here know whether the following messages are harmful? Unknown property 7 DBD::Sybase::st execute failed: Server message number=1 severity=7 state=0 line=1 server=OpenClient text=Attempt to initiate a new SQL Server operation with results pending. at Radius/SqlDb.pm line 154. Unknown property 7 This is with freetds-0.47 on FreeBSD 3.3-release against MSSQL (I think v6) and occurs usually once per authentication attempt. The authentications do succeed. Both messages are shown on screen (even without LogStdout) but only the DBD::Sybase...154 line is logged to disk. Stuart === 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) FreeTDS error messages: Unknown property 7/...results pending
Hello Stuart - On Wed, 27 Oct 1999, Stuart Henderson wrote: Hi, does anyone here know whether the following messages are harmful? Unknown property 7 DBD::Sybase::st execute failed: Server message number=1 severity=7 state=0 line=1 server=OpenClient text=Attempt to initiate a new SQL Server operation with results pending. at Radius/SqlDb.pm line 154. Unknown property 7 This is with freetds-0.47 on FreeBSD 3.3-release against MSSQL (I think v6) and occurs usually once per authentication attempt. The authentications do succeed. Both messages are shown on screen (even without LogStdout) but only the DBD::Sybase...154 line is logged to disk. There seems to be considerable confusion about which FreeTDS module should be used with Radiator. Note that Radiator requires a DBD module for Perl DBI. The correct reference is: ftp://freetds.internetcds.com/pub/freetds_dbd/freetds_dbd.snapshot.tgz FreeTDS_DBD must be installed just like Radiator and DBI, usually with: perl Makefile.PL make make test make install Please note that this version of freetds_dbd is incomplete and it does fail some of its make tests (note also that you must edit the file t/TestCommon.pm to reflect your configuration). Please read the README and INSTALL files in the distribution. Radiator works just fine with this version, as it doesn't use any of the missing freetds_dbd functions. Once you have freetds_dbd correctly installed, you will have to change your DBSource line(s) to refer to the freetds_dbd module: DBSourcedbi:FreeTDS:database=;host=;port=1433; There are examples in the radius.cfg file in the main Radiator distribution. 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, Rhapsod === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) FreeTDS error messages: Unknown property 7/...results pending
Hello Derek - On Wed, 27 Oct 1999, Derek Sanderson wrote: i meant to post the same message... it does appear to be harmful because its causing my system to fall back to a flat file (i have auth groups set up just in case sql is down). the sql queries seam to work until the server gets busy, then it starts returning enough errors for radiator to temporarily stop sql logins. i need a solution for this one too I just posted this to Stuart Henderson. There seems to be considerable confusion about which FreeTDS module should be used with Radiator. Note that Radiator requires a DBD module for Perl DBI. The correct reference is: ftp://freetds.internetcds.com/pub/freetds_dbd/freetds_dbd.snapshot.tgz FreeTDS_DBD must be installed just like Radiator and DBI, usually with: perl Makefile.PL make make test make install Please note that this version of freetds_dbd is incomplete and it does fail some of its make tests (note also that you must edit the file t/TestCommon.pm to reflect your configuration). Please read the README and INSTALL files in the distribution. Radiator works just fine with this version, as it doesn't use any of the missing freetds_dbd functions. Once you have freetds_dbd correctly installed, you will have to change your DBSource line(s) to refer to the freetds_dbd module: DBSource dbi:FreeTDS:database=;host=;port=1433; There are examples in the radius.cfg file in the main Radiator distribution. 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, Rhapsod === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
