[prev in list] [next in list] [prev in thread] [next in thread]
List: freeradius-users
Subject: Re: WARNING: Deprecated conditional expansion ":-". See "man unlang"
From: Arran Cudbard-Bell <a.cudbardb () freeradius ! org>
Date: 2011-08-31 6:12:59
Message-ID: 97ED5AFC-B4F0-4C7D-BD20-EB646A0CDD96 () freeradius ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Ignore the warnings they're harmless.
If you want to fix it then wrap another set of curly braces %{} around the \
conditional expansion.
-Arran
On 31 Aug 2011, at 06:54, EasyHorpak.com wrote:
> 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
Arran Cudbard-Bell
a.cudbardb@freeradius.org
RADIUS - Half the complexity of Diameter
[Attachment #5 (unknown)]
<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; \
-webkit-line-break: after-white-space; "><div>Ignore the warnings they're \
harmless.</div><div><br></div><div>If you want to fix it then wrap another set of \
curly braces %{} around the conditional \
expansion.</div><div><br></div><div>-Arran</div><div><br><div><div>On 31 Aug 2011, at \
06:54, <a href="http://EasyHorpak.com">EasyHorpak.com</a> wrote:</div><br \
class="Apple-interchange-newline"><blockquote type="cite">
<meta http-equiv="content-type" content="text/html; charset=TIS-620">
<div text="#000000" bgcolor="#ffffff">
This error by the update query has ":-" but on my update query \
it have not ":-" .<br>
Why debug still show errors and insert instead update !!<br>
<br>
my debug ..<br>
<br>
<span class="Apple-style-span" style="font-family: Sans; font-style: normal; \
font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: \
normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; \
widows: 2; word-spacing: 0px; font-size: medium; ">
<pre style="word-wrap: break-word; white-space: pre-wrap;">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</pre>
</span><br>
where can i fix it? please advice me.<br>
<br>
<div class="moz-signature">-- <br>
<meta http-equiv="Content-Type" content="text/html;
charset=TIS-620">
<a href="http://www.easyzonecorp.net/">http://www.easyzonecorp.net</a>
- โปรแกรมจัดการอินเตอร์เน็ต \
EasyZone Hotspot Billing, EasyZone PPPoE Billing, EasyZone Radius Billing, EasyZone \
VPN Billing <br> <a href="http://www.easyhorpak.com/">http://www.EasyHorpak.com</a>
- แหล่งค้นหาหอพัก,อพาร์ทเมนท์,แมนชั่น,คอนโด<br>
<a href="http://www.EasyHorpak.com/internet">http://www.EasyHorpak.com/internet</a>
- ผู้ให้บริการติดตั้งอินเตอร์เน็ตในหอพัก \
<br>
<a href="http://www.EasyHorpak.com/move">http://www.EasyHorpak.com/move</a>
- ผู้ให้บริการรับขนย้าย <br>
<a href="http://www.EasyHorpak.com/software">http://www.EasyHorpak.com/software</a>
- แหล่งรวมโปรแกรมบริหารอพาร์ทเมนท์<br>
<a href="http://www.efooddata.com/">http://www.efooddata.com</a> -
แหล่งขายส่งอาหารออนไลน์ \
ได้แก่ อาหารทะเล, หมู, เนื้อ, \
วัว, เป็ด, ไก่,ปู, ปลา, ผัก, ผลไม้<br>
<a href="http://www.thai-school.net/">http://www.thai-school.net</a>
- เว็บไซต์โรงเรียนสำเร็จรูป \
ใช้ง่าย สะดวก ปลอด ัย <br> <a \
href="http://www.SeamTour.com/">http://www.SeamTour.com</a> - \
แหล่งค้นหา บริษัททัวร์ \
แพคเกจทัวร์, ท่องเที่ยว, \
ตั๋วเครื่องบิน,
รถให้เช่า, สืบราคา, จอง, \
ทั่วโลก<br> </div>
</div>
-<br>List info/subscribe/unsubscribe? See <a \
href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></blockquote></div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, \
0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: \
normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; \
text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: \
0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; \
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; \
-webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" \
style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; \
font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: \
normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; \
white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: \
0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; \
-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; \
"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "><div>Arran Cudbard-Bell</div><div><a \
href="mailto:a.cudbardb@freeradius.org">a.cudbardb@freeradius.org</a></div><div><br></div><div>RADIUS \
- Half the complexity of Diameter</div></div></span></span> </div>
<br></div></body></html>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic