<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1251">
<META content="MSHTML 6.00.6000.16608" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2>Good afternoon!
After upgrade from 1.1.7 to 2.0.3 version</FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2>i have a problem in
sql-queries:</FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial
size=2>sql.conf:</FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2>AcctStopTime =
TO_TIMESTAMP_TZ('%{Event-Timestamp}','Mon dd YYYY hh24:mi:ss tzd'),
\</FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2>radiusd -X (ver
2.0.3)</FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial
size=2>...</FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2>AcctStopTime =
TO_TIMESTAMP_TZ('=22Mar 27 2008 18:35:25 MSK=22'....</FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial
size=2>...</FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2>rlm_sql_oracle:
execute query failed in sql_query: ORA-01843: not a valid
month<BR>rlm_sql_oracle: OCI_SERVER_NORMAL<BR>rlm_sql (sqlacct): Couldn't update
SQL accounting STOP record - ORA-01843: not a valid month<BR>rlm_sql (sqlacct):
Released sql socket id: 2</FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2>and radiusd -X (ver
1.1.7):<BR></FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2><SPAN
class=676503515-27032008><FONT face=Arial size=2>AcctStopTime =
TO_TIMESTAMP_TZ('Mar 27 2008 18:35:25 MSK'....</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2><SPAN
class=676503515-27032008></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2><SPAN
class=676503515-27032008>sql.conf on both servers is same
file</SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2><SPAN
class=676503515-27032008></SPAN></FONT></SPAN> </DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2><SPAN
class=676503515-27032008>/usr/local/sbin/radiusd -X | grep safe
(1.1.7)<BR> sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_:
/"<BR> sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_:
/"<BR> sql_log: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_:
/"</SPAN></FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=676503515-27032008><FONT face=Arial size=2><SPAN
class=676503515-27032008>è íà 2.0.3:<BR>/usr/local/sbin/radiusd -X | grep safe
(2.0.3)<BR> safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_:
/"<BR> safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_:
/"<BR> safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_:
/"</SPAN></FONT></SPAN></DIV></FONT></DIV></BODY></HTML>