Have you decommented the "$INCLUDE sql.conf" line in radiusd.conf?
I had the same problem when I compiled freeradius-2.1.8. If I compiled freeradius without libmysqlclient15-dev package the problem appeared. Try it. 2010/5/14 dorra aa <[email protected]> > hi > i installed mysql. > > and i modify in /etc/freeradius/sql.conf: > readclients=yes > > also, i decommented in /etc/freeradius/radiusd.conf: > accounting > {.... > sql} > authorize > {... > sql} > > i run again freeradius -X: > but it seems failed because of sql: this is the output > [...] > sql: postauth_query = "INSERT into radpostauth (user, pass, reply, date) > values ('%{User-Name}', '%{User-Password:-Chap-Password}', > '%{reply:Packet-Type}', NOW())" > sql: safe-characters = > "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" > rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and > linked > rlm_sql (sql): Attempting to connect to r...@localhost:/radius > rlm_sql (sql): starting 0 > rlm_sql (sql): Attempting to connect rlm_s! ql_mysql #0 > rlm_sql_mysql: Starting connect to MySQL server for #0 > rlm_sql_mysql: Couldn't connect socket to MySQL server r! o...@localhost > :radius > rlm_sql_mysql: Mysql error 'Access denied for user 'root'@'localhost' > (using password: YES)' > # but i check it and it's ok i have in sql.conf: sql{server = "localhost" > login = "root" > password = "rootpass"} > rlm_sql (sql): Failed to connect DB handle #0 > rlm_sql (sql): starting 1 > rlm_sql (sql): starting 2 > rlm_sql (sql): starting 3 > rlm_sql (sql): starting 4 > rlm_sql (sql): Failed to connect to any SQL server. > #but i begin with installing mysql-server and i add a user in the database > rlm_sql (sql): - generate_sql_clients > rlm_sql (sql): Query: SELECT * FROM nas > rlm_sql (sql): Ignoring unconnected handle 4.. > rlm_sql (sql): Ignoring unconnected handle 3.. > rlm_sql (sql): Ignoring unconnected handle 2.. > rlm_sql (s! ql): Ignoring unconnected handle 1.. > rlm_sql (sql): Ignoring unconn ected handle 0.. > rlm_sql (sql): There are no DB handles to use! sk! ipped 5, tried to > connect 0 > rlm_sql (sql): generate_sql_clients() r eturned error > rlm_sql (sql): Closing sqlsocket 4 > rlm_sql (sql): Closing sqlsocket 3 > rlm_sql (sql): Closing sqlsocket 2 > rlm_sql (sql): Closing sqlsocket 1 > rlm_sql (sql): Closing sqlsocket 0 > radiusd.conf[14]: sql: Module instantiation failed. > radiusd.conf[1860] Unknown module "sql". > radiusd.conf[1789] Failed to parse authorize section. > ------------------------------ > Hotmail: Trusted email with Microsoft’s powerful SPAM protection. Sign up > now. <https://signup.live.com/signup.aspx?id=60969> > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
