Fwd: cannot connect to sql databse
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. Please help as i want to get the Dial Up Admin Page to work. Thank you. -- Devinder -- Devinder
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.
Hi Liran Yes MySQL is running and i have omport the database scheme in Radius db Im not sure whether i have configured the settings in dial up admin. I managed to configure admin.conf username and password as per acces to MySQL databae i eeven tried the root login and passwoed for mysql but cant acess. Regards Devinder 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
Hi Liran I amd using MySQL would daloradius work with MySQL Thanks Regards Devinder 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
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
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
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
Hey Devinder, On Jan 29, 2008 5:06 AM, Devinder Singh <devinbhullar@gmail.com> 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 <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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi Liran Where shoud i turn on the Logging in which file could you let me know what files are involved to do logging. Regards Devinder On 29/01/2008, liran tal <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 5:06 AM, Devinder Singh <devinbhullar@gmail.com> 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 <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 - 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
Hey Devinder, On Jan 29, 2008 9:41 AM, Devinder Singh <devinbhullar@gmail.com> 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 <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 5:06 AM, Devinder Singh <devinbhullar@gmail.com> 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 <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 - 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
Hi Liran The exact error message on Dial Up Admin is cannot connec to sql database. Rgds Devinder On 29/01/2008, Liran Tal <liran@enginx.com> wrote:
Hey Devinder,
On Jan 29, 2008 9:41 AM, Devinder Singh <devinbhullar@gmail.com> 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 <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 5:06 AM, Devinder Singh <devinbhullar@gmail.com> 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 <devinbhullar@gmail.com> 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 <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 - 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
Hey Devinder, On Jan 29, 2008 9:50 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran
The exact error message on Dial Up Admin is
cannot connec to sql database.
Well that's not too helpful now, is it? I'm not too familiar with dialupadmin, maybe someone else can donate his 2 cents if they had this problem as well. Like I said before, you should try debugging the problem by taking a look at log files instead of trying to guess the problem into discovery. Some thoughts to think about: - is this working if you run it from console? mysql -u freeradius -pmysuperpassword radius - do you have the necessary php mysql package installed? (php4-mysql or php5-mysql) Regards, Liran Tal.
On 29/01/2008, Liran Tal <liran@enginx.com> wrote:
Hey Devinder,
On Jan 29, 2008 9:41 AM, Devinder Singh <devinbhullar@gmail.com> 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 <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 5:06 AM, Devinder Singh <devinbhullar@gmail.com> 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 <devinbhullar@gmail.com> 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 <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 - 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
Hi Liran This is my log file i cant find any errors for cannot connect to sql database Thanks Devinder 080124 14:48:58 mysqld ended 080124 14:48:58 mysqld started 080124 14:48:58 InnoDB: Started; log sequence number 0 43655 080124 14:48:58 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 080124 15:26:09 [Note] /usr/sbin/mysqld: Normal shutdown 080124 15:26:09 InnoDB: Starting shutdown... 080124 15:26:11 InnoDB: Shutdown completed; log sequence number 0 43655 080124 15:26:11 [Note] /usr/sbin/mysqld: Shutdown complete 080124 15:26:11 mysqld ended 080124 15:26:11 mysqld started 080124 15:26:11 InnoDB: Started; log sequence number 0 43655 080124 15:26:11 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 080124 15:40:56 [Note] /usr/sbin/mysqld: Normal shutdown 080124 15:40:56 InnoDB: Starting shutdown... 080124 15:40:57 InnoDB: Shutdown completed; log sequence number 0 43655 080124 15:40:57 [Note] /usr/sbin/mysqld: Shutdown complete 080124 15:40:57 mysqld ended 080124 15:40:57 mysqld started 080124 15:40:57 InnoDB: Started; log sequence number 0 43655 080124 15:40:58 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM On 29/01/2008, liran tal <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 9:50 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran
The exact error message on Dial Up Admin is
cannot connec to sql database.
Well that's not too helpful now, is it? I'm not too familiar with dialupadmin, maybe someone else can donate his 2 cents if they had this problem as well. Like I said before, you should try debugging the problem by taking a look at log files instead of trying to guess the problem into discovery.
Some thoughts to think about: - is this working if you run it from console? mysql -u freeradius -pmysuperpassword radius
- do you have the necessary php mysql package installed? (php4-mysql or php5-mysql)
Regards, Liran Tal.
On 29/01/2008, Liran Tal <liran@enginx.com> wrote:
Hey Devinder,
On Jan 29, 2008 9:41 AM, Devinder Singh <devinbhullar@gmail.com> 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 <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 5:06 AM, Devinder Singh <devinbhullar@gmail.com> 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 <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 - 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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Devinder
On Jan 30, 2008 10:15 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran This is my log file i cant find any errors for cannot connect to sql database
Thanks Devinder
080124 14:48:58 mysqld ended
080124 14:48:58 mysqld started 080124 14:48:58 InnoDB: Started; log sequence number 0 43655 080124 14:48:58 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 080124 15:26:09 [Note] /usr/sbin/mysqld: Normal shutdown
080124 15:26:09 InnoDB: Starting shutdown... 080124 15:26:11 InnoDB: Shutdown completed; log sequence number 0 43655 080124 15:26:11 [Note] /usr/sbin/mysqld: Shutdown complete
080124 15:26:11 mysqld ended
080124 15:26:11 mysqld started 080124 15:26:11 InnoDB: Started; log sequence number 0 43655 080124 15:26:11 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 080124 15:40:56 [Note] /usr/sbin/mysqld: Normal shutdown
080124 15:40:56 InnoDB: Starting shutdown... 080124 15:40:57 InnoDB: Shutdown completed; log sequence number 0 43655 080124 15:40:57 [Note] /usr/sbin/mysqld: Shutdown complete
080124 15:40:57 mysqld ended
080124 15:40:57 mysqld started 080124 15:40:57 InnoDB: Started; log sequence number 0 43655 080124 15:40:58 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM
Does mysql actually keep running? What gives ps -ae | grep mysql Can you acces your database from the cli? kind regards, Y.
Yes i can access mysql rom CLI On 30/01/2008, YvesDM <ydmlog@gmail.com> wrote:
On Jan 30, 2008 10:15 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran This is my log file i cant find any errors for cannot connect to sql database
Thanks Devinder
080124 14:48:58 mysqld ended
080124 14:48:58 mysqld started 080124 14:48:58 InnoDB: Started; log sequence number 0 43655 080124 14:48:58 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 080124 15:26:09 [Note] /usr/sbin/mysqld: Normal shutdown
080124 15:26:09 InnoDB: Starting shutdown... 080124 15:26:11 InnoDB: Shutdown completed; log sequence number 0 43655 080124 15:26:11 [Note] /usr/sbin/mysqld: Shutdown complete
080124 15:26:11 mysqld ended
080124 15:26:11 mysqld started 080124 15:26:11 InnoDB: Started; log sequence number 0 43655 080124 15:26:11 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 080124 15:40:56 [Note] /usr/sbin/mysqld: Normal shutdown
080124 15:40:56 InnoDB: Starting shutdown... 080124 15:40:57 InnoDB: Shutdown completed; log sequence number 0 43655 080124 15:40:57 [Note] /usr/sbin/mysqld: Shutdown complete
080124 15:40:57 mysqld ended
080124 15:40:57 mysqld started 080124 15:40:57 InnoDB: Started; log sequence number 0 43655 080124 15:40:58 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM
Does mysql actually keep running? What gives ps -ae | grep mysql
Can you acces your database from the cli?
kind regards, Y.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Devinder
On Jan 30, 2008 10:15 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran This is my log file i cant find any errors for cannot connect to sql database
If you don't find any connection attempts information then it means that dialupadmin isn't initiating a connection due to one of the reasons I have mentioned before or something else. We've been exchanging so many emails so far and you haven't checked what I've told you to. I can't help you more with dialupadmin as I am not aware of its common configuration issues, if daloradius is an appropriate alternative for you I will be happy to assist you with it. Regards, Liran Tal.
On 29/01/2008, liran tal <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 9:50 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran
The exact error message on Dial Up Admin is
cannot connec to sql database.
Well that's not too helpful now, is it? I'm not too familiar with dialupadmin, maybe someone else can donate his 2 cents if they had this problem as well. Like I said before, you should try debugging the problem by taking a look at log files instead of trying to guess the problem into discovery.
Some thoughts to think about: - is this working if you run it from console? mysql -u freeradius -pmysuperpassword radius
- do you have the necessary php mysql package installed? (php4-mysql or php5-mysql)
Regards, Liran Tal.
On 29/01/2008, Liran Tal <liran@enginx.com> wrote:
Hey Devinder,
On Jan 29, 2008 9:41 AM, Devinder Singh <devinbhullar@gmail.com> 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 <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 5:06 AM, Devinder Singh <devinbhullar@gmail.com> 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 <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 > - > 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
- 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
Hi Liran Do u have Yahoo IM or IRC channel to chat Ok i will instal and configure daloradius Will it work well with FreeRadius server Where do i extract the tar file i have srv/www folder Thanks Devinder On 30/01/2008, Liran Tal <liran@enginx.com> wrote:
On Jan 30, 2008 10:15 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran This is my log file i cant find any errors for cannot connect to sql database
If you don't find any connection attempts information then it means that dialupadmin isn't initiating a connection due to one of the reasons I have mentioned before or something else. We've been exchanging so many emails so far and you haven't checked what I've told you to.
I can't help you more with dialupadmin as I am not aware of its common configuration issues, if daloradius is an appropriate alternative for you I will be happy to assist you with it.
Regards, Liran Tal.
On 29/01/2008, liran tal <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 9:50 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran
The exact error message on Dial Up Admin is
cannot connec to sql database.
Well that's not too helpful now, is it? I'm not too familiar with dialupadmin, maybe someone else can donate his 2 cents if they had this problem as well. Like I said before, you should try debugging the problem by taking a look at log files instead of trying to guess the problem into discovery.
Some thoughts to think about: - is this working if you run it from console? mysql -u freeradius -pmysuperpassword radius
- do you have the necessary php mysql package installed? (php4-mysql or php5-mysql)
Regards, Liran Tal.
On 29/01/2008, Liran Tal <liran@enginx.com> wrote:
Hey Devinder,
On Jan 29, 2008 9:41 AM, Devinder Singh <devinbhullar@gmail.com> 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 <liransgarage@gmail.com> wrote: > > Hey Devinder, > > On Jan 29, 2008 5:06 AM, Devinder Singh < > devinbhullar@gmail.com> 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 <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 > > - > > 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
- 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
1. You are not sending login requests to this server, or at least they are not getting there. Is server set up not to recieve auth requests from the network (only local reqests)? Can you log into it from a different machine? 2. Is this server restarting on it's own or are you doing that? Ivan Kalik Kalik Informatika ISP Dana 30/1/2008, "Devinder Singh" <devinbhullar@gmail.com> piše:
Hi Liran This is my log file i cant find any errors for cannot connect to sql database
Thanks Devinder
080124 14:48:58 mysqld ended
080124 14:48:58 mysqld started 080124 14:48:58 InnoDB: Started; log sequence number 0 43655 080124 14:48:58 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 080124 15:26:09 [Note] /usr/sbin/mysqld: Normal shutdown
080124 15:26:09 InnoDB: Starting shutdown... 080124 15:26:11 InnoDB: Shutdown completed; log sequence number 0 43655 080124 15:26:11 [Note] /usr/sbin/mysqld: Shutdown complete
080124 15:26:11 mysqld ended
080124 15:26:11 mysqld started 080124 15:26:11 InnoDB: Started; log sequence number 0 43655 080124 15:26:11 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM 080124 15:40:56 [Note] /usr/sbin/mysqld: Normal shutdown
080124 15:40:56 InnoDB: Starting shutdown... 080124 15:40:57 InnoDB: Shutdown completed; log sequence number 0 43655 080124 15:40:57 [Note] /usr/sbin/mysqld: Shutdown complete
080124 15:40:57 mysqld ended
080124 15:40:57 mysqld started 080124 15:40:57 InnoDB: Started; log sequence number 0 43655 080124 15:40:58 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 SUSE MySQL RPM
On 29/01/2008, liran tal <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 9:50 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
Hi Liran
The exact error message on Dial Up Admin is
cannot connec to sql database.
Well that's not too helpful now, is it? I'm not too familiar with dialupadmin, maybe someone else can donate his 2 cents if they had this problem as well. Like I said before, you should try debugging the problem by taking a look at log files instead of trying to guess the problem into discovery.
Some thoughts to think about: - is this working if you run it from console? mysql -u freeradius -pmysuperpassword radius
- do you have the necessary php mysql package installed? (php4-mysql or php5-mysql)
Regards, Liran Tal.
On 29/01/2008, Liran Tal <liran@enginx.com> wrote:
Hey Devinder,
On Jan 29, 2008 9:41 AM, Devinder Singh <devinbhullar@gmail.com> 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 <liransgarage@gmail.com> wrote:
Hey Devinder,
On Jan 29, 2008 5:06 AM, Devinder Singh <devinbhullar@gmail.com> 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 <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 > - > 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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Devinder
On Tue, Jan 29, 2008 at 04:50:07PM +0800, Devinder Singh <devinbhullar@gmail.com> wrote a message of 390 lines which said:
The exact error message on Dial Up Admin is ^^^^^ I doubt it because there is a typo in it
cannot connec to sql database. ^^^^^^ Learning to copy-and-paste may be useful :-)
I have hard times with Dial Up Admin Shoud i proceed with daloradius do i install in in srv/www folder like dial up 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
On Jan 30, 2008 10:42 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
I have hard times with Dial Up Admin
Shoud i proceed with daloradius
do i install in in srv/www folder like dial up
Yes you install it wherever you usually place your web projects on your distribution which is configured with apache. Please let's continue this discussion in a new thread, the daloradius mailing list or the on the irc channel #daloradius on freenode. 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
Thanks Liran On 30/01/2008, Liran Tal <liran@enginx.com> wrote:
On Jan 30, 2008 10:42 AM, Devinder Singh <devinbhullar@gmail.com> wrote:
I have hard times with Dial Up Admin
Shoud i proceed with daloradius
do i install in in srv/www folder like dial up
Yes you install it wherever you usually place your web projects on your distribution which is configured with apache.
Please let's continue this discussion in a new thread, the daloradius mailing list or the on the irc channel #daloradius on freenode.
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
participants (6)
-
Devinder Singh -
Ivan Kalik -
liran tal -
Liran Tal -
Stephane Bortzmeyer -
YvesDM