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 -0000
Received: from unknown (HELO ernie) (216.226.64.59)
by mail.delanet.com with SMTP; 12 Dec 2000 01:45:58 -0000
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. Ltd Unix, 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.