Neville wrote:
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.
...
pppd does not pass back Client-IP-Address or Client-Station-Id

 "Calling-Station-Id".

table structure for radipool is

 Yes... we have access to the source code, too.

rad_recv: Access-Request packet from host NASIPHERE port 53621, id=117,
length=147
        Service-Type = Framed-User
        Framed-Protocol = PPP
        User-Name = "TESTUSER"
        MS-CHAP-Challenge = 0xe325bfbeb22fbbb7a33a21326e5ce18a
        MS-CHAP2-Response =
0x51009da7f84750dd0f01bed231e11bab1f9a00000000000000002b9f4dad6844332eaec4aabcc1d8f03911ff654b6a7a8e96
        NAS-Identifier = "NASIPHERE"
        NAS-Port = 0

 OK.  So how is the IP pool module supposed assign a unique IP for each
user?  There's no MAC address in the request (i.e. Calling-Station-Id).
The SQL queries (if you read them) use Calling-Station-Id.  How are
they supposed to work if there's no Calling-Station-Id?

 Fix your PPPd so that it sends *useful* information.

Dear Alan,

It's not as simple as your making it. Also, I am using %{NAS-Port} and not %{Calling-Station-Id} due to the Lack of Calling-Station-Id.

pool-key = "%{NAS-Port}"
# pool-key = "%{Calling-Station-Id}"

 $INCLUDE sql/mysql/ippool.conf
#$INCLUDE sql/postgresql/ippool.conf

if I use ippool module, it works fine so something wrong with the SQL.

Please can you confirm in want sections I have to add sqlippool module in order that I can test this again, but given the flakiness of sqlippool I might just stick with ippool module.

Thx
Nev
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to