Hi Liran The exact error message on Dial Up Admin is
cannot connec to sql database. Rgds Devinder On 29/01/2008, Liran Tal <[EMAIL PROTECTED]> wrote: > > Hey Devinder, > > On Jan 29, 2008 9:41 AM, Devinder Singh <[EMAIL PROTECTED]> wrote: > > > Hi Liran > > > > Where shoud i turn on the Logging in which file could you let me know > > what files are involved to do logging. > > > > > > Turning on the mysql logging is done in mysql's configuration > file (on debian it's found at /etc/mysql/my.cnf). > > What is the exact error message you receive in the web page? > "Dial Up admin page i get cannot connect to sql databse" is too ambiguous. > Copy and paste it here. > > > Regards, > Liran Tal. > > > > > > > > > > On 29/01/2008, liran tal <[EMAIL PROTECTED]> wrote: > > > > > > Hey Devinder, > > > > > > On Jan 29, 2008 5:06 AM, Devinder Singh <[EMAIL PROTECTED]> > > > wrote: > > > > > > > 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. > > > > > > > > > > > > > I guess that looks alright but you haven't done any debugging like > > > I suggested. Turn on mysql logging and see if there's even a > > > connection > > > attempt and if there is you can track what query is going wrong. > > > > > > You haven't detailed what is the exact error, it could just as well be > > > that > > > everything is configured fine but you haven't installed any php-mysql > > > package and you have error_reporting turned off and so you are not > > > seeing > > > the error. > > > > > > Please check these things first. > > > > > > Regards, > > > Liran Tal. > > > > > > > > > > > > > > > > > > > > > > > > > On 28/01/2008, Devinder Singh <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Hi Liran > > > > > > > > > > Are the a lot of changes to be made on Dial Up Admin admin.conffile > > > > > > > > > > > > > > > Could you suggest any specific changes as well in > > > > > etc/raddb/sql.conf > > > > > > > > > > > > > > > Regards > > > > > Devinder > > > > > > > > > > > > > > > On 28/01/2008, Liran Tal <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > Hey Devinder, > > > > > > > > > > > > On Jan 28, 2008 8:44 AM, Devinder Singh <[EMAIL PROTECTED]> > > > > > > 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 <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > > > > > > > > Hey Devinder, > > > > > > > > > > > > > > > > On Jan 28, 2008 4:35 AM, Devinder Singh < > > > > > > > > [EMAIL PROTECTED]> 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 > > > > - > > > > 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 > > > > - > > 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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html