Mysql and Freeradius

[Linda Pagillo]

Hello again:   I've been trying for days to get freeradius working with Mysql. I'm using Linux Redhat 9, Mysql 3.23 and Freeradius-0.9.3 At first i configured freeradius without any options.. i was able to get it working perfectly using text file authentication. Then i started to configure the Mysql part of it. I made a mysql DB and populated it with test data. When i edited my sql.conf and radiusd.conf files to use the Mysql, i received this error... Could not link driver rlm_sql_mysql: file not found as i stated previously in my last post. I researched this error and tried every solution given to me from other users, etc... it came to the point where i just uninstalled Freeradius completely and reconfigured it like this ./configure --disable-shared. then i tried to get it running in text file authentication mode once again. It installed correctly, and i edited my radiusd.conf, clients.conf and users files how i wanted them and then when i ran radiusd -x i kept getting errors for almost every module saying that entries were missing for all of these modules.. so i went through my radiusd.conf file and i commented out everytihng that had to do with these errors.. i got it up and running so i thought because it said i was "ready to recevie requests", but when i did a radtest, it refused me. So then i went in and decided that i was going to try to setup the Mysql and see what happens. Well, i put an "sql" entry in the radiusd.conf file where i needed them and i edited my sql.conf file accordingly, but i got an error about the sql module entries being missing. I could not find a way around this, so i went ahead and completely uninstalled Freeradius again. Now, this is where i'm at. Surely there are many people out there that have freeradius running with Mysql flawlessly. Can anyone give me exact directions on how i need to ./configure freeradius so that mysql works? I'm sorry about the long post, but i know you guys like for people to explain in detail the problems that they are having. Thank you.   Linda Pagillo Director of Technical Services N2 The Net