sqlippool - Duplicate IP

[Alan DeKok]

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.

  Alan DeKok.