Dear Liran this is my dialup_admin.conf file sql_type: mysql sql_server: localhost sql_port: 3306 sql_username: freeradius sql_password: mysuperpassword sql_database: radius sql_accounting_table: radacct sql_badusers_table: badusers sql_check_table: radcheck sql_reply_table: radreply sql_user_info_table: userinfo sql_groupcheck_table: radgroupcheck sql_groupreply_table: radgroupreply sql_usergroup_table: usergroup and this is the /usr/raddb/sql.conf confihguration sql { # Database type # Current supported are: rlm_sql_mysql, rlm_sql_postgresql, # rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds driver = "rlm_sql_mysql" # Connect info server = "localhost" login = "freeradius" password = "mysuperpassword" # Database table configuration radius_db = "radius" # If you want both stop and start records logged to the # same SQL table, leave this as is. If you want them in # different tables, put the start table in acct_table1 # and stop table in acct_table2 acct_table1 = "radacct" acct_table2 = "radacct" # Allow for storing data after authentication postauth_table = "radpostauth" Is there anything that i as missing pls advise. Regards Devinder On 28/01/2008, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran
Are the a lot of changes to be made on Dial Up Admin admin.conf file
Could you suggest any specific changes as well in etc/raddb/sql.conf
Regards Devinder
On 28/01/2008, Liran Tal <liran@enginx.com> wrote:
Hey Devinder,
On Jan 28, 2008 8:44 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran
I amd using MySQL would daloradius work with MySQL
Yes, daloradius has native support for mysql. You check on dialupadmin for configuring errors - what is the error message that you get?
It is also very useful to turn on mysql logging to see if there's even a connection attempt and if there is, what is causing the error.
Regards, Liran Tal.
On 28/01/2008, liran tal <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 28, 2008 4:35 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi
I am using Dial Up Admin on Free radius
Free Radius is Running but when i acccess Dial Up admin page i get cannot connect to sql databse
I have done most of the configuration settings and followed the wiki tutorial on Free Radius.
Did you check that your sql server is actually running? Did you import the radius database schema into the sql server? Did you configure all the required settings to connect to the sql server in dialupadmin?
You also might want to take a look at daloRADIUS for easy web management of freeradius with sql servers: http://sourceforge.net/projects/daloradius/
Regards, Liran.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Devinder - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Devinder
-- Devinder