(RADIATOR) odd SQL error

[Clayton Weise]

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.