configuration freeradius with mysql

[David Seira]

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 <dj_dido2003 at hotmail.com>

>  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 root at 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! oot at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20100514/31523f6f/attachment.html>