RadiusMysql setup checked using Karbonn Mobile and is working fine. Only entries in the following four tables is required.<\/p>\n
radcheck
\n5\tbdKarbonn\tCleartext-Password\t:=\tabcd1234<\/p>\n
radusergroup
\nbdKarbonn\tnmlsqlwifi\t1<\/p>\n
radgroupcheck
\n21\tnmlsqlwifi\tAuth-Type\t:=\tEAP<\/p>\n
radgroupreply
\n32\tnmlsqlwifi\tService-Type\t:=\tFramed-User
\n33\tnmlsqlwifi\tTunnel-Type\t:=\tVLAN
\n34\tnmlsqlwifi\tTunnel-Medium-Type\t:=\tIEEE-802
\n35\tnmlsqlwifi\tTunnel-Private-Group-ID\t:=\t3<\/p>\n
————— other relevent ————
\nmodules\/cui: database = “mysql”
\nradiusd.conf: $INCLUDE sql.conf
\nradiusd.conf: $INCLUDE sql\/mysql\/counter.conf
\nsql.conf: database = “mysql”<\/p>\n
sql.conf:sql {
\nsql.conf: database = “mysql”
\nsql.conf:
\nsql.conf: driver = “rlm_sql_${database}”
\nsql.conf:
\nsql.conf: server = “localhost”
\nsql.conf: login = “radius”
\nsql.conf: password = “mysqlsvrpw”
\nsql.conf:
\nsql.conf: radius_db = “radius”
\nsql.conf:
\nsql.conf: acct_table1 = “radacct”
\nsql.conf: acct_table2 = “radacct”
\nsql.conf:
\nsql.conf: postauth_table = “radpostauth”
\nsql.conf:
\nsql.conf: authcheck_table = “radcheck”
\nsql.conf: authreply_table = “radreply”
\nsql.conf:
\nsql.conf: groupcheck_table = “radgroupcheck”
\nsql.conf: groupreply_table = “radgroupreply”
\nsql.conf:
\nsql.conf: usergroup_table = “radusergroup”
\nsql.conf:
\nsql.conf:
\nsql.conf: deletestalesessions = yes
\nsql.conf:
\nsql.conf: sqltrace = no
\nsql.conf: sqltracefile = ${logdir}\/sqltrace.sql
\nsql.conf:
\nsql.conf: num_sql_socks = 5
\nsql.conf:
\nsql.conf: connect_failure_retry_delay = 60
\nsql.conf:
\nsql.conf: lifetime = 0
\nsql.conf:
\nsql.conf: max_queries = 0
\nsql.conf:
\nsql.conf:
\nsql.conf: nas_table = “nas”
\nsql.conf:
\nsql.conf: $INCLUDE sql\/${database}\/dialup.conf
\nsql.conf:}<\/p>\n","protected":false},"excerpt":{"rendered":"
RadiusMysql setup checked using Karbonn Mobile and is working fine. Only entries in the following four tables is required. radcheck 5 bdKarbonn Cleartext-Password := abcd1234 radusergroup bdKarbonn nmlsqlwifi 1 radgroupcheck 21 nmlsqlwifi Auth-Type := EAP radgroupreply 32 nmlsqlwifi Service-Type := Framed-User 33 nmlsqlwifi Tunnel-Type := VLAN 34 nmlsqlwifi Tunnel-Medium-Type := IEEE-802 35 nmlsqlwifi Tunnel-Private-Group-ID := … Continue reading Radius via MySQL<\/span>