<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18813">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>I've facing a problem since rebuild, where every user is being allocated
the same IP from the sqlippool, and I'm not sure why this is
happening.</DIV>
<DIV> </DIV>
<DIV>I have a DaloRadius / FreeRadius2.1.6 / Poptop (pptpd) 1.3.4 / ppp 2.4.4.-2
/ mysql 5.0.45</DIV>
<DIV> </DIV>
<DIV>pppd does not pass back Client-IP-Address or Client-Station-Id</DIV>
<DIV> </DIV>
<DIV>table structure for radipool is</DIV>
<DIV> </DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>( `id` int(11) unsigned NOT NULL
auto_increment,</SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>`pool_name` varchar(30) NOT NULL, </SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>`framedipaddress` varchar(15) NOT NULL default
'',</SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>`nasipaddress` varchar(15) NOT NULL default '',
</SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>`calledstationid` varchar(30) NOT
NULL,</SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>`callingstationid` varchar(30) NOT
NULL,</SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>`expiry_time` datetime default NULL,</SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>`username` varchar(64) NOT NULL default
'',</SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>`pool_key` varchar(30) NOT NULL, PRIMARY KEY (`id`)
)</SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span></SPAN></SPAN> </DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>1st Login</SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span></SPAN></SPAN> </DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>Ready to process requests.<BR>rad_recv: Access-Request
packet from host NASIPHERE port 53621, id=117,
length=147<BR> Service-Type =
Framed-User<BR> Framed-Protocol =
PPP<BR> User-Name =
"TESTUSER"<BR> MS-CHAP-Challenge =
0xe325bfbeb22fbbb7a33a21326e5ce18a<BR>
MS-CHAP2-Response =
0x51009da7f84750dd0f01bed231e11bab1f9a00000000000000002b9f4dad6844332eaec4aabcc1d8f03911ff654b6a7a8e96<BR>
NAS-Identifier = "NASIPHERE"<BR>
NAS-Port = 0<BR>+- entering group authorize {...}<BR>++[preprocess] returns
ok<BR>[auth_log] expand:
/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d ->
/var/log/radius/radacct/NASIPHERE/auth-detail-20090831<BR>[auth_log]
/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to
/var/log/radius/radacct/NASIPHERE/auth-detail-20090831<BR>[auth_log]
expand: %t -> Mon Aug 31 22:47:05 2009<BR>++[auth_log] returns ok<BR>[mschap]
Found MS-CHAP attributes. Setting 'Auth-Type = mschap'<BR>++[mschap]
returns ok<BR>[sql] expand: %{User-Name} -> TESTUSER<BR>[sql]
sql_set_user escaped user --> 'TESTUSER'<BR>rlm_sql (sql): Reserving sql
socket id: 3<BR>[sql] expand: SELECT id, username, attribute, value,
op FROM
radcheck WHERE
username =
'%{SQL-User-Name}'
ORDER BY id -> SELECT id, username, attribute, value,
op FROM
radcheck WHERE
username =
'TESTUSER' ORDER BY
id<BR>[sql] User found in radcheck table<BR>[sql] expand: SELECT id,
username, attribute, value,
op FROM
radreply WHERE
username =
'%{SQL-User-Name}'
ORDER BY id -> SELECT id, username, attribute, value,
op FROM
radreply WHERE
username =
'TESTUSER' ORDER BY
id<BR>[sql] expand: SELECT
groupname FROM
radusergroup WHERE
username =
'%{SQL-User-Name}'
ORDER BY priority -> SELECT
groupname FROM
radusergroup WHERE
username =
'TESTUSER' ORDER BY
priority<BR>[sql] expand: SELECT id, groupname,
attribute, Value,
op FROM
radgroupcheck WHERE
groupname =
'%{Sql-Group}' ORDER
BY id -> SELECT id, groupname,
attribute, Value,
op FROM
radgroupcheck WHERE
groupname = 'USUKTV'
ORDER BY id<BR>[sql] User found in group USUKTV<BR>[sql] expand:
SELECT id, groupname,
attribute, value,
op FROM
radgroupreply WHERE
groupname =
'%{Sql-Group}' ORDER
BY id -> SELECT id, groupname,
attribute, value,
op FROM
radgroupreply WHERE
groupname = 'USUKTV'
ORDER BY id<BR>rlm_sql (sql): Released sql socket id: 3<BR>++[sql] returns
ok<BR>++[expiration] returns noop<BR>++[logintime] returns noop<BR>Found
Auth-Type = MSCHAP<BR>+- entering group MS-CHAP {...}<BR>[mschap] Told to do
MS-CHAPv2 for TESTUSER with NT-Password<BR>[mschap] adding MS-CHAPv2 MPPE
keys<BR>++[mschap] returns ok<BR>+- entering group session {...}<BR>++[sql]
returns noop<BR>Login OK: [TESTUSER/<via Auth-Type = mschap>] (from client
VPN1-UK port 0)<BR>+- entering group post-auth {...}<BR>rlm_sql (sql): Reserving
sql socket id: 2<BR>[sqlippool] expand: %{User-Name}
-> TESTUSER<BR>[sqlippool] sql_set_user escaped user -->
'TESTUSER'<BR>[sqlippool] expand: START TRANSACTION
-> START TRANSACTION<BR>[sqlippool] expand: UPDATE
radippool SET nasipaddress = '', pool_key = 0,
callingstationid = '', username = '', expiry_time = NULL
WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress =
'%{Nas-IP-Address}' -> UPDATE radippool SET nasipaddress = '',
pool_key = 0, callingstationid = '', username = '',
expiry_time = NULL WHERE expiry_time <= NOW() - INTERVAL 1
SECOND AND nasipaddress =
'NASIPHERE'<BR>[sqlippool] expand: SELECT
framedipaddress FROM radippool WHERE pool_name = '%{control:Pool-Name}'
AND (expiry_time < NOW() OR expiry_time IS NULL) ORDER BY (username
<> '%{User-Name}'), (callingstationid <>
'%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE ->
SELECT framedipaddress FROM radippool WHERE pool_name = 'tvpool' AND
(expiry_time < NOW() OR expiry_time IS NULL) ORDER BY (username
<> 'TESTUSER'), (callingstationid <> ''),
expiry_time LIMIT 1 FOR
UPDATE<BR>[sqlippool] expand: UPDATE radippool SET
nasipaddress = '%{NAS-IP-Address}', pool_key = '%{NAS-Port}',
callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}',
expiry_time = NOW() + INTERVAL 3600 SECOND WHERE framedipaddress =
'192.168.0.5' AND expiry_time IS NULL -> UPDATE radippool SET
nasipaddress = 'NASIPHERE', pool_key = '0', callingstationid = '',
username = 'TESTUSER', expiry_time = NOW() + INTERVAL 3600 SECOND
WHERE framedipaddress = '192.168.0.5' AND expiry_time IS NULL<BR>[sqlippool]
Allocated IP 192.168.0.5 [0500a8c0]<BR>[sqlippool]
expand: COMMIT -> COMMIT <BR></SPAN></SPAN></DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span></SPAN></SPAN> </DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span>2nd Login, same user ID</SPAN></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN
style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 13px 'Times New Roman'; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); 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"
class=Apple-style-span><SPAN
style="FONT-FAMILY: 'Courier New'; WHITE-SPACE: pre; FONT-SIZE: 14px"
class=Apple-style-span><BR>Ready to process requests.<BR>rad_recv:
Access-Request packet from host NASIPHERE port 37354, id=119,
length=147<BR> Service-Type =
Framed-User<BR> Framed-Protocol =
PPP<BR> User-Name =
"TESTUSER"<BR> MS-CHAP-Challenge =
0x29bb177d40bae79e1ad242c8d9383704<BR>
MS-CHAP2-Response =
0x4400294af6559f212980c4c7942ba81c19e600000000000000003100115915f0d911531610a4f4f639f56de1115a1f9ca249<BR>
NAS-Identifier = "NASIPHERE"<BR>
NAS-Port = 1<BR>+- entering group authorize {...}<BR>++[preprocess] returns
ok<BR>[auth_log] expand:
/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d ->
/var/log/radius/radacct/NASIPHERE/auth-detail-20090831<BR>[auth_log]
/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to
/var/log/radius/radacct/NASIPHERE/auth-detail-20090831<BR>[auth_log]
expand: %t -> Mon Aug 31 22:47:35 2009<BR>++[auth_log] returns ok<BR>[mschap]
Found MS-CHAP attributes. Setting 'Auth-Type = mschap'<BR>++[mschap]
returns ok<BR>[sql] expand: %{User-Name} -> TESTUSER<BR>[sql]
sql_set_user escaped user --> 'TESTUSER'<BR>rlm_sql (sql): Reserving sql
socket id: 3<BR>[sql] expand: SELECT id, username, attribute, value,
op FROM
radcheck WHERE
username =
'%{SQL-User-Name}'
ORDER BY id -> SELECT id, username, attribute, value,
op FROM
radcheck WHERE
username =
'TESTUSER' ORDER BY
id<BR>[sql] User found in radcheck table<BR>[sql] expand: SELECT id,
username, attribute, value,
op FROM
radreply WHERE
username =
'%{SQL-User-Name}'
ORDER BY id -> SELECT id, username, attribute, value,
op FROM
radreply WHERE
username =
'TESTUSER' ORDER BY
id<BR>[sql] expand: SELECT
groupname FROM
radusergroup WHERE
username =
'%{SQL-User-Name}'
ORDER BY priority -> SELECT
groupname FROM
radusergroup WHERE
username =
'TESTUSER' ORDER BY
priority<BR>[sql] expand: SELECT id, groupname,
attribute, Value,
op FROM
radgroupcheck WHERE
groupname =
'%{Sql-Group}' ORDER
BY id -> SELECT id, groupname,
attribute, Value,
op FROM
radgroupcheck WHERE
groupname = 'USUKTV'
ORDER BY id<BR>[sql] User found in group USUKTV<BR>[sql] expand:
SELECT id, groupname,
attribute, value,
op FROM
radgroupreply WHERE
groupname =
'%{Sql-Group}' ORDER
BY id -> SELECT id, groupname,
attribute, value,
op FROM
radgroupreply WHERE
groupname = 'USUKTV'
ORDER BY id<BR>rlm_sql (sql): Released sql socket id: 3<BR>++[sql] returns
ok<BR>++[expiration] returns noop<BR>++[logintime] returns noop<BR>Found
Auth-Type = MSCHAP<BR>+- entering group MS-CHAP {...}<BR>[mschap] Told to do
MS-CHAPv2 for TESTUSER with NT-Password<BR>[mschap] adding MS-CHAPv2 MPPE
keys<BR>++[mschap] returns ok<BR>+- entering group session {...}<BR>++[sql]
returns noop<BR>Login OK: [TESTUSER/<via Auth-Type = mschap>] (from client
VPN1-UK port 1)<BR>+- entering group post-auth {...}<BR>rlm_sql (sql): Reserving
sql socket id: 2<BR>[sqlippool] expand: %{User-Name}
-> TESTUSER<BR>[sqlippool] sql_set_user escaped user -->
'TESTUSER'<BR>[sqlippool] expand: START TRANSACTION
-> START TRANSACTION<BR>[sqlippool] expand: UPDATE
radippool SET nasipaddress = '', pool_key = 0,
callingstationid = '', username = '', expiry_time = NULL
WHERE expiry_time <= NOW() - INTERVAL 1 SECOND AND nasipaddress =
'%{Nas-IP-Address}' -> UPDATE radippool SET nasipaddress = '',
pool_key = 0, callingstationid = '', username = '',
expiry_time = NULL WHERE expiry_time <= NOW() - INTERVAL 1
SECOND AND nasipaddress =
'NASIPHERE'<BR>[sqlippool] expand: SELECT
framedipaddress FROM radippool WHERE pool_name = '%{control:Pool-Name}'
AND (expiry_time < NOW() OR expiry_time IS NULL) ORDER BY (username
<> '%{User-Name}'), (callingstationid <>
'%{Calling-Station-Id}'), expiry_time LIMIT 1 FOR UPDATE ->
SELECT framedipaddress FROM radippool WHERE pool_name = 'tvpool' AND
(expiry_time < NOW() OR expiry_time IS NULL) ORDER BY (username
<> 'TESTUSER'), (callingstationid <> ''),
expiry_time LIMIT 1 FOR
UPDATE<BR>[sqlippool] expand: UPDATE radippool SET
nasipaddress = '%{NAS-IP-Address}', pool_key = '%{NAS-Port}',
callingstationid = '%{Calling-Station-Id}', username = '%{User-Name}',
expiry_time = NOW() + INTERVAL 3600 SECOND WHERE framedipaddress =
'192.168.0.5' AND expiry_time IS NULL -> UPDATE radippool SET
nasipaddress = 'NASIPHERE', pool_key = '1', callingstationid = '',
username = 'TESTUSER', expiry_time = NOW() + INTERVAL 3600 SECOND
WHERE framedipaddress = '192.168.0.5' AND expiry_time IS
NULL<BR><STRONG>[sqlippool] Allocated IP 192.168.0.5
[0500a8c0]<BR></STRONG>[sqlippool] expand: COMMIT ->
COMMIT</SPAN></SPAN></DIV>
<DIV><FONT face="Courier New"></FONT> </DIV>
<DIV><FONT face="Courier New"></FONT> </DIV>
<DIV><FONT face="Courier New">Thx</FONT></DIV>
<DIV><FONT face="Courier New">Nev</FONT></DIV></BODY></HTML>