Hello, When you "make" freeRadius and before you "make "install", scroll back in the "make" output to see if there were any errors in the compile. It sounds like the MySQL didn't compile, most likely it couldn't find the MySQL include files or the lib files it needs. To help you find these warnings, all the database files are made towards the end of the "make", and MySQL is done just before PostgreSQL.. You'll likely find a warning about not finding the <mysql/mysql.h> and instructing you on how to fix the problem. Note that there's a slight bug in the rlm_sql_mysql make (as documented below) so you'll have to work around it (again, as documented below). To someone who maintains the make/configure files of freeRADIUS: The default MySQL installation does not include a path and file named <mysql/mysql.h> as the make file looks for in the directory rlm_sql_mysql. On the other hand, it does include mysql<version>/include/mysql.h. Following the MySQL instructions, I create a symbolic link: "ln -s /usr/local/mysql<version> mysql". But that still doesn't solve the problem, because freeRADIUS is looking for <mysql/mysql.h>. If someone in freeRADIUS could change this to <mysql/include/mysql.h> or simply <mysql.h>: the latter would be better because the default paths freeRADIUS uses would be sufficient to find /usr/local/mysql/include/mysql.h. To work around this problem, one either has to hack the configure/make file for rlm_sql_mysql or create yet another symbolic link: "ln -s /usr/local/mysql/include mysql".
-----Original Message----- From: [EMAIL PROTECTED] on behalf of Yyc Sent: Sat 7/10/2004 6:24 AM To: Post Cc: Subject: FreeRadius+Mysql Problem After I install Mysql-standard-4.0.18-pc-linux-i686(in /usr/local/mysql-xxxxx-linux-i686) + Freeradius(1.0.0.pre3),my OS is RedHat 9.0,and i try to connect freeradius and mysql.... radiusd -X give me the following message: 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. Then I try some way that i got from faq and google... 1) rebuild the freeradius with ./configure --disable_shared make make install but it didn't work 2) cp /usr/local/lib/*.* /usr/lib (vi /etc/ld.so.conf ; add the item: /usr/local/lib;) they are same... and didn't work too 3) i reinstall the OS, and install mysql first,and then " cp /usr/local/mysql/include/*.h /usr/include/mysql" then build freeradius... nothing changed ...I almost got crazy.. i cannot find the rlm_sql_mysql.la under any dir,but the freeradius docs seems tell me that all db drivers are built into rlm_sql.so ,rlm_sql.a, rlm_sql.la....I don't understand, even if i am afraid that's problem of my os... anybody know about this? thanks a lot... ããããããããYyc [EMAIL PROTECTED] ãããããããããã2004-07-10