Migrate users file to mysql?

Ivan Kalik tnt at kalik.net
Sun Jun 14 13:29:47 CEST 2009


> Currently I have declared the same user with different parameters and
> conditions.
>

The only difference between the entries is that one NAS checks caller id
and other doesn't.

> NAS1= 192.168.25.20
>
> NAS2= 192.168.25.30
>
>
> frank  Auth-Type := LDAP, NAS-IP-Address == "192.168.25.20",
> Calling-Station-Id == "76415044", Simultaneous-Use := 1
>          Service-Type = Framed-User,
>          Framed-Protocol = PPP,
>          Framed-MTU = 1500,
>          Framed-Compression = Van-Jacobsen-TCP-IP,
>          Framed-Protocol = PPP,
> 	Framed-IP-Address = 192.168.28.110,
>          Framed-IP-Netmask = 255.255.255.0,
>          Idle-Timeout = 0
>
> frank  Auth-Type := LDAP, NAS-IP-Address == "192.168.25.30",
> Simultaneous-Use := 1
>          Service-Type = Framed-User,
>          Framed-Protocol = PPP,
>          Framed-MTU = 1500,
>          Framed-Compression = Van-Jacobsen-TCP-IP,
>          Framed-Protocol = PPP,
>          Framed-IP-Address = 192.168.29.110,
>          Framed-IP-Netmask = 255.255.255.0,
>          Idle-Timeout = 0
>
>
>
> As would be declared to migrate to mysql?


You can remove Auth-Type for starters. Which of this is user specific and
which is NAS specific? I assume caller id and ip are user specific while
rest is NAS specific.

>
> I have to repeat them twice as I have done here?
>

That depends on what operator you use not where you store attributes.

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list