Framed IP and and Protocol in SQL written as Null

[Alan DeKok]

On Oct 16, 2024, at 8:44 AM, Saied Ahadi <saiedahadi at gmail.com> wrote:
> 
> I am having some trouble moving from FR2 to FR3. I did a fresh install
> recently on FR3. Authentication part is working correctly. However I
> noticed that most of the time the Framed IP address and FramedProtocol are
> not written correctly into the mysql database.

  What does that mean?

> I am sure I have incorrectly
> setup something but since I don't understand how I can go ahead and trouble
> shoot this matter.

  The usual approach of reading the debug output should help.

> Here are the logs use freeradius -X
> 
> ...
> (0) Received Access-Request Id 91 from 143.198.146.8:56216 to
> 67.205.156.27:1812 length 186
> (0)   Service-Type = Framed-User
> (0)   Framed-Protocol = PPP
> (0)   NAS-Port = 15728640
> (0)   NAS-Port-Type = Ethernet
> (0)   User-Name = "saied"
> (0)   Calling-Station-Id = "0C:DC:B7:B1:00:00"
> (0)   NAS-Port-Id = "ether2"
> (0)   Acct-Session-Id = "81b00000"
> (0)   MS-CHAP-Challenge = 0x1e86ccb35ca835cd91f0010ed05ef9f8
> (0)   MS-CHAP2-Response =
> 0x0100b82b5ae17cd5f3d5c529bd97d16f686d0000000000000000d6856ebb6089ace13cb4d8e5dccdb75bc2ab423d994b19d8
> (0)   NAS-Identifier = "MikroTik"
> (0)   NAS-IP-Address = 192.168.122.30

  The packet has Framed-Protocol, but no Framed-IP-Address.  The rest of the debug output shows that it's writing Framed-Protocol=PPP to SQL.  And then no value for Framed-IP-Address.  That's correct.

  So... what's the problem?  Do you want a value written for Framed-IP-Address?  If so, how does FreeRADIUS write a value that it doesn't have?

  Alan DeKok.