<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi All;<BR>
<BR>
I have Freeradius 2 setup with the MySQL database back-end and it is working really well with one Cisco VPN 3060, I also allow multiple logins from the same user.<BR>
<BR>
But yesterday i have added a second VPN server and whole thing stop working, user gets authenticated across the 2 NAS, but i belive the freeradius is getting confused with the 2 NAS.<BR>
<BR>
As a test I have edited the: ippool.conf<BR>
<BR>
FROM: <BR>
<BR>
## The ORDER BY clause of this query tries to allocate the same IP-address<BR>## which user had last session...<BR>#####allocate-find = "SELECT framedipaddress FROM ${ippool_table} \<BR>##### WHERE pool_name = '%{control:Pool-Name}' AND (expiry_time < NOW() OR expiry_time IS NULL) \<BR>##### ORDER BY (username <> '%{User-Name}'), \<BR>##### (callingstationid <> '%{Calling-Station-Id}'), \<BR>##### expiry_time \<BR>##### LIMIT 1 \<BR>##### FOR UPDATE"<BR>
<BR>
TO: <BR>
<BR>
# ## If you prefer to allocate a random IP address every time, i<BR># ## use this query instead<BR> allocate-find = "SELECT framedipaddress FROM ${ippool_table} \<BR> WHERE pool_name = '%{control:Pool-Name}' \<BR> AND expiry_time = NULL \<BR> ORDER BY RAND() \<BR> LIMIT 1 \<BR> FOR UPDATE"<BR><BR>
All worked well and then it stopped. <BR>
<BR>
Is there any other place i have to change to allow simultaneus logins across 2 NAS, pls?<BR>
<BR>
<BR>
Many thanks<BR>
<BR>
Lucio<BR> <br /><hr />Not got a Hotmail account? <a href='http://clk.atdmt.com/UKM/go/197222280/direct/01/' target='_new'>Sign-up now - Free</a></body>
</html>