Re: rlm_sql errors
Shannon Johnson [EMAIL PROTECTED] wrote: I'm trying to get FreeRadius to work with MySQL, but it isn't working. Every time I run radiusd, it doesn't start, and the log gives me: Fri Jan 17 11:14:36 2003 : Error: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found You would think that this question would be addressed in the FAQ, or in the documentation which comes with the server. Oh, wait, it is... What's preventing you from reading the FAQ? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql errors
17-Jan-03 at 11:24, Shannon Johnson ([EMAIL PROTECTED]) wrote : Fri Jan 17 11:14:36 2003 : Error: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found Fri Jan 17 11:14:36 2003 : Error: rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. Fri Jan 17 11:14:36 2003 : Error: radiusd.conf[14]: sql: Module instantiation failed. Exactly which libraries does it need? I bought the Radius book from O'Reilly, and there isn't anything of use in there... I tried adding /usr/local/lib to the /etc/ld.so.conf and running ldconfig, but that didn't work (do I need to recompile freeradius afterwards?). I also tried compiling freeradius using the -disable-sharing flag, but that didn't work either. I have freeradius 0.8.1 and mysql 3.23.54a (bench, client, server, and devel). If anyone has any ideas on what I should try, or if you could provide a list of exactly which libraries it needs to find, I can link them manually...? Did you pass the options to configure in order to enable mysql at compile time? -- |-Simon White, Internet Services Manager, Certified Check Point CCSA. |-MTDS Internet, Security, Anti-Virus, Linux and Hosting Solutions. |-MTDS 14, rue du 16 novembre, Agdal, Rabat, Morocco. |-MTDS tel +212.3.767.4861 - fax +212.3.767.4863 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql errors
you may not have compiled the mysql module... you need the devel rpm (mysql-devel-X.X.X.X.rpm) Shannon Johnson a écrit: I?m trying to get FreeRadius to work with MySQL, but it isn?t working. Every time I run radiusd, it doesn?t start, and the log gives me: Fri Jan 17 11:14:36 2003 : Error: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found Fri Jan 17 11:14:36 2003 : Error: rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. Fri Jan 17 11:14:36 2003 : Error: radiusd.conf[14]: sql: Module instantiation failed. Exactly which libraries does it need? I bought the Radius book from O?Reilly, and there isn?t anything of use in there? I tried adding /usr/local/lib to the /etc/ld.so.conf and running ldconfig, but that didn?t work (do I need to recompile freeradius afterwards?). I also tried compiling freeradius using the ?disable-sharing flag, but that didn?t work either. I have freeradius 0.8.1 and mysql 3.23.54a (bench, client, server, and devel). If anyone has any ideas on what I should try, or if you could provide a list of exactly which libraries it needs to find, I can link them manually?? Thanks in advance! Shannon Johnson Systems Administrator -- --- CYBERDECK Solutions de bornes interactives --- Richard Genoud Ingenieur RD --- 300 route nationale 6 - 69760 Limonest - France Tel. : 0820 820 107 - International +33 4 78 66 74 00 Fax : +33 4 78 66 74 69 [EMAIL PROTECTED] - www.cyberdeck.com --- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql errors
This is Solaris UltraSparc I recompiled mysql with shared libs enabled and now it is working Rgds On Fri, 2003-01-17 at 11:32, Genoud Richard wrote: you may not have compiled the mysql module... you need the devel rpm (mysql-devel-X.X.X.X.rpm) Shannon Johnson a écrit: I?m trying to get FreeRadius to work with MySQL, but it isn?t working. Every time I run radiusd, it doesn?t start, and the log gives me: Fri Jan 17 11:14:36 2003 : Error: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found Fri Jan 17 11:14:36 2003 : Error: rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. Fri Jan 17 11:14:36 2003 : Error: radiusd.conf[14]: sql: Module instantiation failed. Exactly which libraries does it need? I bought the Radius book from O?Reilly, and there isn?t anything of use in there? I tried adding /usr/local/lib to the /etc/ld.so.conf and running ldconfig, but that didn?t work (do I need to recompile freeradius afterwards?). I also tried compiling freeradius using the ?disable-sharing flag, but that didn?t work either. I have freeradius 0.8.1 and mysql 3.23.54a (bench, client, server, and devel). If anyone has any ideas on what I should try, or if you could provide a list of exactly which libraries it needs to find, I can link them manually?? Thanks in advance! Shannon Johnson Systems Administrator -- _ __ Gustavo A. Lozano Noldata Corporation [EMAIL PROTECTED] Calle 46 No. 40-19 CTO Bogota D.C. Colombia Noldata Corporation http://noldata.com I know not with what weapons World War III will be fought, but World War IV will be fought with sticks and stones. Albert Einstein This Message has been scanned for Virus Content using RAV Antivirus. Get your copy of RAV Antivirus at Noldata, send mail to [EMAIL PROTECTED] http://noldata.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: re: rlm_sql errors
Shannon, Which options should I pass? I install all the MySQL parts (including devel) to their default places... the configuring and the compiling don't give me any errors, so I'm assuming it found mysql and enabled support for it. --with-mysql-include-dir=DIRDirectory where the MySQL includes can be found --with-mysql-lib-dir=DIRDirectory where the MySQL libraries can be found --with-mysql-dir=DIRBase directory where MySQL is installed --with-thread-pool Use a pool of threads for high-load systems. (default=no) ***very important to turn on*** --localstatedir=/varDirectory for logfiles [LOCALSTATEDIR/log] Here is what I use on a debian machine. Just change the paths to match your file locations. ./configure --localstatedir=/var --sysconfdir=/etc --with-thread-pool --with-mysql-include-dir=/usr/include/mysql/ --with-mysql-lib-dir=/usr/lib/ --with-mysql-dir=/usr/bin/ Where are the mysql shared libraries installed by default? I'm not exactly a mysql expert... This has nothing to do with being a mysql expert. It has to do with being a system admin and knowing how your system works. I don't know if you are new to linux or what.. but here it how to find out the answer to this question: try this: rpm -ql package name It will list all files and their locations that came from that rpm. If you don't know what it is expecting for package name, try this rpm -qa | grep mysql It will list all packages with mysql in their name:) Read man rpm for more info! Nick -- Nick Davis Associate Systems Administrator [EMAIL PROTECTED] Internet Exposure, Inc. http://www.iexposure.com (612)676-1946 Web Development-Web Marketing-ISP Services - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: re: rlm_sql errors
17-Jan-03 at 12:11, Shannon Johnson ([EMAIL PROTECTED]) wrote : From: Simon White [EMAIL PROTECTED] Fri Jan 17 11:14:36 2003 : Error: rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found Fri Jan 17 11:14:36 2003 : Error: rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. Fri Jan 17 11:14:36 2003 : Error: radiusd.conf[14]: sql: Module instantiation failed. Exactly which libraries does it need? I bought the Radius book from O'Reilly, and there isn't anything of use in there... I tried adding /usr/local/lib to the /etc/ld.so.conf and running ldconfig, but that didn't work (do I need to recompile freeradius afterwards?). I also tried compiling freeradius using the -disable-sharing flag, but that didn't work either. I have freeradius 0.8.1 and mysql 3.23.54a (bench, client, server, and devel). If anyone has any ideas on what I should try, or if you could provide a list of exactly which libraries it needs to find, I can link them manually...? Did you pass the options to configure in order to enable mysql at compile time? Which options should I pass? I install all the MySQL parts (including devel) to their default places... the configuring and the compiling don't give me any errors, so I'm assuming it found mysql and enabled support for it. It is possibly enabled by default in the freeradius compile, but only if that can find the libraries and stuff. You can specify them manually:- --with-mysql-include-dir=DIR Directory where the MySQL includes may be found --with-mysql-lib-dir=DIR Directory where the MySQL libraries may be found --with-mysql-dir=DIR Base directory where MySQL is installed (libs are usually foo.o files, already compiled binaries) (includes are usually foo.c and foo.h files, source code) For relevant other info, look here (starting from the path into which the tarball was extracted) src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql raddb/sql.conf doc/README -and- http://www.frontios.com/freeradius.html Regards, -- |-Simon White, Internet Services Manager, Certified Check Point CCSA. |-MTDS Internet, Security, Anti-Virus, Linux and Hosting Solutions. |-MTDS 14, rue du 16 novembre, Agdal, Rabat, Morocco. |-MTDS tel +212.3.767.4861 - fax +212.3.767.4863 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: re: rlm_sql errors
17-Jan-03 at 13:42, Shannon Johnson ([EMAIL PROTECTED]) wrote : Nick, I tried that... what I don't know is WHAT libraries it's looking for. Rather than saying it's looking for the mysql libraries, which I already know, can you list the file names? Here is what I use on a debian machine. Just change the paths to match your file locations. ./configure --localstatedir=/var --sysconfdir=/etc --with-thread-pool --with-mysql-include-dir=/usr/include/mysql/ --with-mysql-lib-dir=/usr/lib/ --with-mysql-dir=/usr/bin/ I've already done this. I've also tried including the --disable-shared option, which was mentioned in the all-mighty FAQ... didn't work. I have:- /usr/lib/mysql (files like libmysqlclient.a are in there) /var/lib/mysql (files like mysql.sock are there, plus the dbs in subdirectories) /usr/include/mysql (files like mysql.h are there) And I have mysqld in /usr/sbin Your mileage may vary. -- |-Simon White, Internet Services Manager, Certified Check Point CCSA. |-MTDS Internet, Security, Anti-Virus, Linux and Hosting Solutions. |-MTDS 14, rue du 16 novembre, Agdal, Rabat, Morocco. |-MTDS tel +212.3.767.4861 - fax +212.3.767.4863 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
re: re: rlm_sql errors
Nick, Which options should I pass? I install all the MySQL parts (including devel) to their default places... the configuring and the compiling don't give me any errors, so I'm assuming it found mysql and enabled support for it. --with-mysql-include-dir=DIR Directory where the MySQL includes can be found --with-mysql-lib-dir=DIR Directory where the MySQL libraries can be found --with-mysql-dir=DIR Base directory where MySQL is installed --with-thread-pool Use a pool of threads for high-load systems. (default=no) ***very important to turn on*** --localstatedir=/var Directory for logfiles [LOCALSTATEDIR/log]I tried that... what I dont know is WHAT libraries its looking for. Rather than saying its looking for the mysql libraries, which I already know, can you list the file names? Here is what I use on a debian machine. Just change the paths to match your file locations../configure --localstatedir=/var --sysconfdir=/etc --with-thread-pool --with-mysql-include-dir=/usr/include/mysql/ --with-mysql-lib-dir=/usr/lib/ --with-mysql-dir=/usr/bin/Ive already done this. Ive also tried including the --disable-shared option, which was mentioned in the all-mighty FAQ... didnt work. Where are the mysql shared libraries installed by default? I'm not exactly a mysql expert... This has nothing to do with being a mysql expert. It has to do with being a system admin and knowing how your system works. I don't know if you are new to linux or what.. but here it how to find out the answer to this question: try this: rpm -ql package name It will list all files and their locations that came from that rpm.It doesnt give me back any information at all, except on builds that were installed by the system when it was first built. If you don't know what it is expecting for package name, try this rpm -qa | grep mysql It will list all packages with mysql in their name:) Read man rpm for more info! Nick rpm qa | grep mysql gives me only 3 packages those packages were installed at build time. And before you ask, yes, I DID install all the mysql packages, and all of them are working (I can access the databases both at the machine and remotely). Is there any other command that I might not have thought of to give me information on an rpm that Ive installed? Shannon
Re: re: rlm_sql errors [OT] how to use RPM
Shannon, try this: rpm -ql package name It will list all files and their locations that came from that rpm. It doesn't give me back any information at all, except on builds that were installed by the system when it was first built. If this is in fact true. Your rpm database is corrupt. EVERY rpm you install should get added to the rpm database. This means that these commands I told you to run, should give your current information on what mysql packages are installed. Note this only works for packages installed via rpm. If you don't know what it is expecting for package name, try this rpm -qa | grep mysql It will list all packages with mysql in their name:) Read man rpm for more info! Nick 'rpm -qa | grep mysql ' gives me only 3 packages... those packages were installed at build time. And before you ask, yes, I DID install all the mysql packages, and all of them are working (I can access the databases both at the machine and remotely). Is there any other command that I might not have thought of to give me information on an rpm that I've installed? What 3 packages? The only command that will give you information on rpms you have installed is rpm itself. Read through it's man pages for more details. You might try: rpm --rebuilddb to rebuild rpms database. Nick -- Nick Davis Associate Systems Administrator [EMAIL PROTECTED] Internet Exposure, Inc. http://www.iexposure.com (612)676-1946 Web Development-Web Marketing-ISP Services - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
