FreeRadius2.0.2+ mysql +dailupadmin help!

[Lance Buttars]

Ivan Kalik wrote:
>>> I have read the sql how to and to my knowledge I have configured
>>> sql.conf correctly.
>>>
>>> I am not certain about radiusd.conf it has the sql.conf include but
>>> when I run radiusd -X i don't see it loading the rlm_sql driver and I
>>> ran a netstat and I never see a sql connection.
>>>
>>>
>>> attached are my config files any help you can provided is very
>>> appreciated.
>>>
>>> I am thinking that when I compiled freeradius it didn't include the
>>> rlm_sql driver.
>>>
>>> it would be helpful to know if I need to do a --with option in the
>>> ./configure when I complile it. the sql documentation said that I
>>> needed to do it but it didn't say how I would go about doing it.
>>>
>>>       
>
> No, it's not that. It's:
>
> ######################################################################
> #
> #	As of 2.0.0, the "authorize", "authenticate", etc. sections
> #	are in separate configuration files, per virtual host.
> #
> ######################################################################
>
> They are not in radiusd.conf anymore (sorry). In your version they should
> be in sites-enabled configuration files. Find sql entries in those
> sections and uncomment them.
>
> Ivan Kalik
> Kalik Informatika ISP
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>
>   
thank you for your help I was able to find where to enable the sql but 
now I get this error.

rlm_sql (sql): Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: 
cannot open shared object file: No such file or directory
rlm_sql (sql): Make sure it (and all its dependent libraries!) are in 
the search path of your system's ld.
/usr/local/etc/raddb/sql.conf[21]: Instantiation failed for module "sql"
/usr/local/etc/raddb/sites-enabled/default[124]: Failed to find module 
"sql".
/usr/local/etc/raddb/sites-enabled/default[34]: Errors parsing authorize 
section.