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