This error by the update query has? ":-"? but? on my update query it
have not ":-" . Why debug still show errors and insert instead update !! my debug .. Wed Aug 31 11:45:08 2011 : Info: +- entering group accounting {...} Wed Aug 31 11:45:08 2011 : Info: [sql] expand: %{User-Name} -> ez68044 Wed Aug 31 11:45:08 2011 : Info: [sql] sql_set_user escaped user --> 'ez68044' Wed Aug 31 11:45:08 2011 : Info: [sql] expand: UPDATE radacct SET ClientIPAddress='%{Client-IP-Address}',FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}',AcctStatusType='%{Acct-Status-Type}',AcctOutputOctets = '%{Acct-Output-Octets}' ,NASIdentifier='%{NAS-Identifier}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStopTime=0 -> UPDATE radacct SET ClientIPAddress='124.122.22.45',FramedIPAddress = '192.168.182.8', AcctSessionTime = '602', AcctInputOctets = '2061724',AcctStatusType='Interim-Update',AcctOutputOctets = '87498073' ,NASIdentifier='112' WHERE AcctSessionId = '4e5dd06400000007' AND UserName = 'ez68044' AND NASIPAddress= '0.0.0.0' AND AcctStopTime=0 Wed Aug 31 11:45:08 2011 : Debug: rlm_sql (sql): Reserving sql socket id: 2 Wed Aug 31 11:45:08 2011 : Info: [sql] WARNING: Deprecated conditional expansion ":-". See "man unlang" for details Wed Aug 31 11:45:08 2011 : Info: [sql] WARNING: Deprecated conditional expansion ":-". See "man unlang" for details Wed Aug 31 11:45:08 2011 : Info: [sql] expand: INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStatusType,NASIdentifier,now_stamp,ClientIPAddress) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0' ,'%{Acct-Status-Type}','%{NAS-Identifier}',unix_timestamp('%S'),'%{Client-IP-Address}') -> INSERT into radacct (AcctSessionId, AcctUniqu eId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStart Wed Aug 31 11:45:08 2011 : Debug: rlm_sql (sql): Released sql socket id: 2 Wed Aug 31 11:45:08 2011 : Info: ++[sql] returns ok where can i fix it? please advice me. --
http://www.easyzonecorp.net - ????????????????????????? EasyZone Hotspot Billing, EasyZone PPPoE Billing, EasyZone Radius Billing, EasyZone VPN Billing http://www.EasyHorpak.com - ???????????????,???????????,???????,????? http://www.EasyHorpak.com/internet - ?????????????????????????????????????? http://www.EasyHorpak.com/move - ????????????????????? http://www.EasyHorpak.com/software - ???????????????????????????????? http://www.efooddata.com - ??????????????????????? ?????? ?????????, ???, ?????, ???, ????, ???,??, ???, ???, ????? http://www.thai-school.net - ????????????????????????? ??????? ????? ??????? http://www.SeamTour.com - ?????????? ??????????? ???????????, ??????????, ??????????????, ?????????, ???????, ???, ??????? |
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html