safe_characters in freeradius 2.0.3

Dmitry A. Sysoev snaut at snaut.ru
Thu Mar 27 16:43:27 CET 2008


Good afternoon! After upgrade from 1.1.7 to 2.0.3 version
i have a problem in sql-queries:
 
sql.conf:
AcctStopTime = TO_TIMESTAMP_TZ('%{Event-Timestamp}','Mon dd YYYY hh24:mi:ss
tzd'), \
 
radiusd -X (ver 2.0.3)
...
AcctStopTime = TO_TIMESTAMP_TZ('=22Mar 27 2008 18:35:25 MSK=22'....
...
 
rlm_sql_oracle: execute query failed in sql_query: ORA-01843: not a valid
month
rlm_sql_oracle: OCI_SERVER_NORMAL
rlm_sql (sqlacct): Couldn't update SQL accounting STOP record - ORA-01843:
not a valid month
rlm_sql (sqlacct): Released sql socket id: 2
 
and radiusd -X (ver 1.1.7):

AcctStopTime = TO_TIMESTAMP_TZ('Mar 27 2008 18:35:25 MSK'....
 
sql.conf on both servers is same file
 
/usr/local/sbin/radiusd -X | grep safe (1.1.7)
 sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
 sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
 sql_log: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
 
и на 2.0.3:
/usr/local/sbin/radiusd -X | grep safe (2.0.3)
        safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
        safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
        safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20080327/78af53e3/attachment.html>


More information about the Freeradius-Users mailing list