Freeradius+mysql+error
Hello everybody. I have configured free radius yo work with my sql.my sql server is also running.I have configured sql.conf and freeradius.conf to work with free radius.But when i start radius in debugging mode then i find the following errors.What can be the error. [EMAIL PROTECTED] mysql]# /usr/local/freeradius/sbin/radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded SQL Counter Module: Instantiated sqlcounter (noresetcounter) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id Module: Instantiated acct_unique (acct_unique) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Listening on proxy *:1814 Ready to process requests. and it does not authenticate any users Rupak - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql+error
On Wed, Jun 01, 2005 at 07:07:02AM +0545, [EMAIL PROTECTED] wrote: radius.But when i start radius in debugging mode then i find the following errors.What can be the error. rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' What can the errors be? Let's see, what don't you understand about the above error? -- Chris. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql+error
Hello, Check your sql configuration in sql.conf in the following area # Connect info server = yousqlip login = user password = pws Abdul Lateef Kapilvastu Lumbini __ Discover Yahoo! Find restaurants, movies, travel and more fun for the weekend. Check it out! http://discover.yahoo.com/weekend.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql+error
Thank you I just finished it successfully. Actually the problem was with the sql server.Now I am defining the attribute Max-All-Session in seconds. That means I am defining time limitations. [Prepaid].But what I want is that I will make a user and it can surf unlimited.But the total time should be automatically appended in my sql.What is the Attribute for this and the Value also. And can we define time limitations in minutes/hours Hello, Check your sql configuration in sql.conf in the following area # Connect info server = yousqlip login = user password = pws Abdul Lateef Kapilvastu Lumbini __ Discover Yahoo! Find restaurants, movies, travel and more fun for the weekend. Check it out! http://discover.yahoo.com/weekend.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql error
Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section authorize { preprocess # counter # attr_filter # eap suffix sql files # mschap } accounting { # acct_unique detail # counter unix sql radutmp # sradutmp } and I have not commented the default values.Will make any problem?. On Mon, May 30, 2005 at 04:23:24PM -0700, Rupak wrote: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Compile freeradius with MySQL support, or alternatively get a RPM which already have this support compiled into it. -- Chris. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
Try installing the Mysql rpm separately and then check wether ur MySQL is running correctly or not. Try this tweak,hope it will clear the mess. On 6/1/05, Rupak [EMAIL PROTECTED] wrote: Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section authorize { preprocess # counter # attr_filter # eap suffix sql files # mschap } accounting { # acct_unique detail # counter unix sql radutmp # sradutmp } and I have not commented the default values.Will make any problem?. On Mon, May 30, 2005 at 04:23:24PM -0700, Rupak wrote: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Compile freeradius with MySQL support, or alternatively get a RPM which already have this support compiled into it. -- Chris. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kamran Bukhari - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql error
Well I have installed the following things of my sql.The things are the following. rpm -q mysql--it is installed rpm -q mysql-server--it is installed rpm -q mysql-devel---it is installed. These packages were installed from redhat9.But when I start the service Service mysqld start/status it says mysqld dead but subsys locked.what may be the problem?. Try installing the Mysql rpm separately and then check wether ur MySQL is running correctly or not. Try this tweak,hope it will clear the mess. : Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section authorize { preprocess # counter # attr_filter # eap suffix sql files # mschap } accounting { # acct_unique detail # counter unix sql radutmp # sradutmp } and I have not commented the default values.Will make any problem?. rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Compile freeradius with MySQL support, or alternatively get a RPM which already have this support compiled into it. -- Chris. -- Kamran Bukhari - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql error
Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = root Password = password.But I don't know how to configure mysql.Does any one have a link to a good tutorial.As I am a newbie in the world of mysql Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
U dont have to change anything to my.cnf as when u install the new rpm, the cnf file will be automatically adjusted. After succesful installation, run the mysql client. After the successful running, do some changes to sql.conf in raddb as u wish. for tutorial , try mysql website as they got good manual. On 6/1/05, Rupak [EMAIL PROTECTED] wrote: Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = root Password = password.But I don't know how to configure mysql.Does any one have a link to a good tutorial.As I am a newbie in the world of mysql Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kamran Bukhari - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
Rupak wrote: Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = root Password = password.But I don't know how to configure mysql.Does any one have a link to a good tutorial.As I am a newbie in the world of mysql Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html usually there is no need to change anythin in my.cnf by default. Per default the mysql user root exists and has *NO* password set! If u want to restrict him to use password or restrict him to hosts u can either use the mysql-set-permission utility or enter the mysql console and use sql like that: grant all privileges on database.tables to root@host identified by password; wildards at database and tables are allowed. U may use *.* if u want to restrict root for all existing databases! host can be your hostname, or localhost or an ip address. Usually it is a good thing to restrict root to connections from localhost. And do not forget the semicolon at the end of the line :D U should not restrict the privileges of root ;) cheers Sebastian - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
Rupak wrote: Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = root Password = password.But I don't know how to configure mysql.Does any one have a link to a good tutorial.As I am a newbie in the world of mysql Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Additionally, if mysql failed to start have a look at /var/log/mysql_error.log or something similar to that. It will tell you the reason... Also something could have screwed your /var/run/mysql/mysqld.sock. For testing u may rename the file and restart mysqld then. It should then create a new socket... cheers Sebastian - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Freeradius+mysql error
I checked bu there is no mysqld.sock in /var/run/mysqld. May be because my sql is not started. Because it gives back an error telling that mysqld dead but subsys locked Rupak Rupak wrote: Ya you must be right. I have'nt configured the file /etc/my.cnf.I saw the file and found that the value of user= was set to mysql. Where as in the sql.conf file I pointed out the following Login = root Password = password.But I don't know how to configure mysql.Does any one have a link to a good tutorial.As I am a newbie in the world of mysql Hi, Thank you for the reply I think I have compiled free radius with mysql support because I had installed it --with-experimental-modules.Now if I start the sql server by giving the command mysql -u root -p rootpass radius db_mysql.sql then it returns me with the following error Error 2002: can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) What may be the problem.The following is my radius.conf for authorize and accounting section this isnt a FreeRADIUS problem at this point - the above error message is a straight 'mysql cannot talk to mysql server'. check that 1) mysql is running 2) mysql is configured to allow your host to talk to it 3) mysql is configured to allow root account to talk to it - and that the password is correct 4) firewall issues - check that you arent blocking mysql conversations in some wierd way alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __ NOD32 1. (20050527) Information __ This message was checked by NOD32 antivirus system. http://www.nod32.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Additionally, if mysql failed to start have a look at /var/log/mysql_error.log or something similar to that. It will tell you the reason... Also something could have screwed your /var/run/mysql/mysqld.sock. For testing u may rename the file and restart mysqld then. It should then create a new socket... cheers Sebastian - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius+mysql error
I configured freeradius it was working well.Now I wanted to make it work with my sql.My distro is redhat9 and I am using the version mysql-3.23.54a-11.rpm.Free radius was working and authenticating user.But after configuring the files to make it work with sql it is not working well.It gave me the following errors.I did exactly that was defined in the resources.Like in the forum section of chillispot.org .Tutorial was posted by barteki. And other sites as well. [EMAIL PROTECTED] rlm_sql_mysql]# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded SQL Counter Module: Instantiated sqlcounter (noresetcounter) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Can any one point me to a correct lane Thanking you - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
On Mon, May 30, 2005 at 04:23:24PM -0700, Rupak wrote: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Compile freeradius with MySQL support, or alternatively get a RPM which already have this support compiled into it. -- Chris. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+mysql error
Hello Download MYSQL with all its libraries e.g. i got MySQL 4.11. You are missing with libraries, thats y this message is prompting U. after downloading the libraries, Use following command rpm -Uvh --nodeps MySQL-server-... .rpm (use ur server version at ...) rpm -Uvh MySQL-share.rpm (use the share version u got) rpm -Uvh Mysql-clientrpm then use # /etc/init.d/mysql start Then compile freeradius and make again.Hope u wont get the message back. Bye On 5/31/05, Rupak [EMAIL PROTECTED] wrote: I configured freeradius it was working well.Now I wanted to make it work with my sql.My distro is redhat9 and I am using the version mysql-3.23.54a-11.rpm.Free radius was working and authenticating user.But after configuring the files to make it work with sql it is not working well.It gave me the following errors.I did exactly that was defined in the resources.Like in the forum section of chillispot.org .Tutorial was posted by barteki. And other sites as well. [EMAIL PROTECTED] rlm_sql_mysql]# radiusd -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded SQL Counter Module: Instantiated sqlcounter (noresetcounter) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded SQL rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Can any one point me to a correct lane Thanking you - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kamran Bukhari - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html