Hi Chris,
>From your debug trace the example shown did not have any errors, therefore we
would need a trace that does explicityly show both the incoming request and the
resulting SQL statement that causes the error.
We suspect that the error is caused by a NAS-specific accounting request.
Cheers.
On Jul 18, 6:47pm, Chris M wrote:
> Subject: (RADIATOR) Session Database problems
> While turning on the SessionDatabase SQL feature with a Linux Postgres
> database I encountered lots of errors occasionally happening on stdout:
>
> DBD::Pg::db do failed: ERROR: parser: parse error at or near ","
> DBD::Pg::db do failed: ERROR: parser: parse error at or near ""
> DBD::Pg::db do failed: ERROR: parser: parse error at or near ""
> DBD::Pg::db do failed: ERROR: parser: parse error at or near ","
>
> etc. etc.
>
> The records in the Radiator log look normal, any ideas what is causing this?
>
> Chris
>
> Sun Jul 18 18:50:11 1999: DEBUG: Handling request with Handler 'Realm='
> Sun Jul 18 18:50:11 1999: DEBUG: Rewrote user name to mark
> Sun Jul 18 18:50:11 1999: DEBUG: Rewrote user name to mark
> Sun Jul 18 18:50:11 1999: DEBUG: Rewrote user name to mark
> Sun Jul 18 18:50:11 1999: DEBUG: Handling with Radius::AuthDBFILE
> Sun Jul 18 18:50:11 1999: DEBUG: SessionDB Adding session for mark,
> 207.174.103.7,
> 17
> Sun Jul 18 18:50:11 1999: DEBUG: do query is: delete from RADONLINE where
> NASIDENTI
> FIER='207.174.103.7' and NASPORT=17
>
> Sun Jul 18 18:50:12 1999: DEBUG: do query is: insert into RADONLINE
> (USERNAME, NASI
> DENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
> NASPORTTYPE, SERVIC
> ETYPE) values ('mark', '207.174.103.7', 17, '3D000E6E', 932345411,
> '204.144.244.65'
> , 'ISDN', 'Framed-User')
>
> Sun Jul 18 18:50:12 1999: DEBUG: Accounting accepted
> Sun Jul 18 18:50:12 1999: DEBUG: Packet dump:
> *** Sending to 207.174.103.7 port 1026 ....
> Code: Accounting-Response
> Identifier: 125
> Authentic: X<10><11>d.<172><212><191>N<160>S<30><2><135>Z<14>
>
>
>
>
> ===
> 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 M
--
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, 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.
