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.-_:
/"