Alexander Serkin wrote:
Edit oraclesql.conf to use the query you want. That's why the queries are configurable.
Shure i will. I've seen them occasionally :-)
The question was to guys who may did the trick already. Because in Oracle
You can parse the string "May 18 2005 12:08:18 +0400" easily, but i've no idea what to do with timezone specified as MSD or something else.
And finally i can modify the timezone presentation by Solaris zone info compiler so that it would be +0400, but radiusd modifies it into =2B0400, and that confuses oracle completely:
radius_xlat: 'INSERT into radacct (RadAcctId, AcctSessionId, CallingStationId, FramedIPAddress, CDMACorrelationId, CDMAHAAgent, UserName, CDMAPCFIPAddress, CDMABSMSCAddr, CDMAUserId, CDMAIPTech, CDMACompTunInd, CDMABadFrameCount, CDMAReceivedHDLCOctets, CDMAIPQoS, CDMAAirPriority, CDMARPSessionID, AcctAuthentic, NASPortType, NASPort, ServiceType, NASIPAddress, NASIdentifier, AcctUniqueId, Realm, TunnelServerEndpoint, TunnelClientEndpoint, TunnelAssignmentId, TunnelType, AcctTunnelConnection, TunnelClientAuthId, TunnelServerAuthId, AcctStartTime, FramedProtocol, AcctStartDelay) values ('', '1111111111111117', '250097004401111', '212.119.123.233', '0003A62F', '0.0.0.0', 'mobile', '212.119.99.40', '000000000001', '0', '1', '0', '0', '1140', '0', '13', '111111111', 'RADIUS', 'Virtual', '58503', 'Framed-User', '212.119.97.85', 'pdsn1.cell.ru', '0995358346e1d81e', 'NULL', '', '', '', '', '', '', '', TO_TIMESTAMP_TZ('Oct 7 2004 12:50:00 =2B0400','Mon dd YYYY hh24:mi:ss tzhtzm'), '', '')'
rlm_sql (sqlacct): Reserving sql socket id: 4
rlm_sql_oracle: execute query failed in sql_query: ORA-01858: a non-numeric character was found where a numeric was expected
rlm_sql (sqlacct): Attempting to connect rlm_sql_oracle #4
rlm_sql (sqlacct): Connected new DB handle, #4
rlm_sql_oracle: execute query failed in sql_query: ORA-01858: a non-numeric character was found where a numeric was expected
rlm_sql (sqlacct): failed after re-connect
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Sincerely Yours, Alexander
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
