Migrate users file to mysql?
Hello As you will see I'm still a beginner in freeradius I recently upgrade my version of freeradius to latest version V2.1.6, my users or the same parameters are declared in the file "users" These authenticate against an LDAP. I have several two NAS, NAS1 a module with an analog modems and NAS2 digital modems to connect where Dialin using the service. My question is: 1 - How can my users migrate users from the file into mysql? 2 - I have users connecting to both Access Server, but when they connect the NAS1, my server raidus assigned different parameters when connecting the NAS2 to pass other parameters or conditions, Framed-IP-Address etc... Currently I have declared the same user with different parameters and conditions. 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? I have to repeat them twice as I have done here? Thank you ---------------------------------------------- Webmail, servicio de correo electronico Casa de las Americas - La Habana, Cuba.
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
Hi Ivan The only difference between a NAS1 and NAS2 is because the first NAS1 have installed a module that allows digital modems set the user's account to a phone number, while the NAS2 has a module with analog modems that do not allow this. Equally be used both for serving Dialin. I removed the setting Auth-Type from the beginning. Now, if you look though the difference for this user when you connect both NAS, they assigned different IP that are not in the same block. besides that one checks the telephone number from which you are connected, the other by the type of technology. My question is how could accommodate all on one line, I mean to avoid having to repeat the same user twice with different parameters? I think the state is more flexible configuration of my users in the users file for this type of scheme, I can not even see it in a mysql database. could show if possible, an example would be like mysql? ---------------------------------------------- Webmail, servicio de correo electronico Casa de las Americas - La Habana, Cuba.
participants (2)
-
Ivan Kalik -
michel＠casa.co.cu