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. root@chillispot 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
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.
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.1111 (20050527) Information __________ This message was checked by NOD32 antivirus system. http://www.nod32.com
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 <rupak@sns.com.np> 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.1111 (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
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 -
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
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.1111 (20050527) Information __________ This message was checked by NOD32 antivirus system. http://www.nod32.com
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 <rupak@sns.com.np> 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.1111 (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
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.1111 (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
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.1111 (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
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.1111 (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
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-client....rpm 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 <rupak@sns.com.np> 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.
root@chillispot 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
participants (5)
-
A.L.M.Buxey＠lboro.ac.uk -
Chris Knipe -
Kamran Bukhari -
Rupak -
Sebastian Wild