(RADIATOR) odd SQL error

[Hugh Irvine]

Hello Clayton -

I suspect this is modem noise that is being used as a username (check a 
trace 4 to make sure).

You should use the "UsernameCharset ..." parameter to limit the 
characters that you will accept.

Have a look at section 6.4.30 in the Radiator 3.1 reference manual.
("doc/ref.html").

regards

Hugh


On Tuesday, August 6, 2002, at 07:49 AM, Clayton Weise wrote:

> I keep getting odd errors like this that pop up on the console and also 
> are
> being written to the error log.  The junk inbetween the single quotes
> change, but the rest of the error stays the same.  I'm running Radiator 
> 3.1
> and below the error is my config.  If I need to post anything else, let 
> me
> know.
>
> DBD::mysql::st execute failed: You have an error in your SQL syntax near
> '^q~g#h{p~8v)n|O;$jGRi~Ap~^F9I'' at line 1 at Radius/SqlDb.pm line 179.
>
> [snip]
>
> LogDir		/var/log/radius
> DbDir		/usr/local/radius/raddb
> PidFile		/var/run/radius.pid
> AuthPort	1645
>
> DictionaryFile	%D/dictionary
> SnmpgetProg	/usr/local/bin/snmpget
> Trace 		2
>
> <ClientListSQL>
> DBSource	dbi:mysql:radius
> DBUsername	radius
> DBAuth		****
> </ClientListSQL>
>
> <SessionDatabase SQL>
> DBSource	dbi:mysql:radius
> DBUsername	radius
> DBAuth		****
> </SessionDatabase>
>
> <StatsLog SQL>
> DBSource	dbi:mysql:radius
> DBUsername	radius
> DBAuth		****
> Interval	86400
> </StatsLog SQL>
>
> <Realm DEFAULT>
>  RewriteUsername     s/^([^@]+).*/$1/
>  MaxSessions		2
>  PasswordLogFileName	%L/authentication.log
>  AcctLogFileName	%L/detail.%q.log
>   <AuthBy SQL>
> 	DBSource	dbi:mysql:radius
> 	DBUsername	radius
> 	DBAuth		****
> 	AccountingTable ACCOUNTING
> 	AuthSelect	SELECT vpopmail.pw_passwd,REPLYATTR \
> 			FROM users.vpopmail,radius.SUBSCRIBERS \
> 			WHERE pw_name=%0 \
> 			AND pw_domain='iswest.com' \
> 			AND dialstatus > 0 \
> 			AND acctstatus ='1';
> 	AuthColumnDef 	0, Encrypted-Password, check
> 	#AuthColumnDef	1, GENERIC, check
> 	AuthColumnDef	1, GENERIC, reply
> 	#AuthColumnDef	2, GENERIC, reply
> 	AcctColumnDef   USERNAME,User-Name
> 	AcctColumnDef   TIME_STAMP,Timestamp,integer
> 	AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
> 	AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
> 	AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer
> 	AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
> 	AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
> 	AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer
> 	AcctColumnDef   ACCTTERMINATECAUSE,Acct-Terminate-Cause
> 	AcctColumnDef   NASIDENTIFIER,NAS-Identifier
> 	AcctColumnDef   NASPORT,NAS-Port,integer
> 	AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
> 	AcctFailedLogFileName %L/missedaccounting
>   </AuthBy>
> </Realm>
>
> <Realm vcnet.com>
>  RewriteUsername     s/^([^@]+).*/$1/
>  MaxSessions		2
>  PasswordLogFileName	%L/vcnet/authentication.log
>  AcctLogFileName	%L/vcnet/detail.%q.log
>   <AuthBy SQL>
> 	DBSource	dbi:mysql:radius
> 	DBUsername	radius
> 	DBAuth		****
> 	AccountingTable ACCOUNTING
> 	AuthSelect	SELECT vpopmail.pw_passwd,REPLYATTR \
> 			FROM users.vpopmail,radius.SUBSCRIBERS \
> 			WHERE pw_name=%0 \
> 			AND pw_domain='vcnet.com' \
> 			AND dialstatus > 0 \
> 			AND acctstatus ='1';
> 	AuthColumnDef 	0, Encrypted-Password, check
> 	AuthColumnDef	1, GENERIC, reply
> 	AcctColumnDef   USERNAME,User-Name
> 	AcctColumnDef   TIME_STAMP,Timestamp,integer
> 	AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
> 	AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
> 	AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer
> 	AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
> 	AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
> 	AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer
> 	AcctColumnDef   ACCTTERMINATECAUSE,Acct-Terminate-Cause
> 	AcctColumnDef   NASIDENTIFIER,NAS-Identifier
> 	AcctColumnDef   NASPORT,NAS-Port,integer
> 	AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
> 	AcctFailedLogFileName %L/vcnet/missedaccounting
>   </AuthBy>
> </Realm>
>
> [/snip]
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>
--
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.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.