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 := 3
————— other relevent ————
modules/cui: database = “mysql”
radiusd.conf: $INCLUDE sql.conf
radiusd.conf: $INCLUDE sql/mysql/counter.conf
sql.conf: database = “mysql”
sql.conf:sql {
sql.conf: database = “mysql”
sql.conf:
sql.conf: driver = “rlm_sql_${database}”
sql.conf:
sql.conf: server = “localhost”
sql.conf: login = “radius”
sql.conf: password = “mysqlsvrpw”
sql.conf:
sql.conf: radius_db = “radius”
sql.conf:
sql.conf: acct_table1 = “radacct”
sql.conf: acct_table2 = “radacct”
sql.conf:
sql.conf: postauth_table = “radpostauth”
sql.conf:
sql.conf: authcheck_table = “radcheck”
sql.conf: authreply_table = “radreply”
sql.conf:
sql.conf: groupcheck_table = “radgroupcheck”
sql.conf: groupreply_table = “radgroupreply”
sql.conf:
sql.conf: usergroup_table = “radusergroup”
sql.conf:
sql.conf:
sql.conf: deletestalesessions = yes
sql.conf:
sql.conf: sqltrace = no
sql.conf: sqltracefile = ${logdir}/sqltrace.sql
sql.conf:
sql.conf: num_sql_socks = 5
sql.conf:
sql.conf: connect_failure_retry_delay = 60
sql.conf:
sql.conf: lifetime = 0
sql.conf:
sql.conf: max_queries = 0
sql.conf:
sql.conf:
sql.conf: nas_table = “nas”
sql.conf:
sql.conf: $INCLUDE sql/${database}/dialup.conf
sql.conf:}