Re: Missing rlm sql mysql
List, I know this thread is about dead, but I wanted to correct some things. On Monday 16 June 2003 11:35, [EMAIL PROTECTED] wrote: Hi Michael, The rlm_sql_mysql file is for building the mysql database. Under the /freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql directory you will find the configure file. Just run this script by entering ./configure and it will create your mysql database for you. rlm_sql is a module that freeradius uses to interact with databases. rlm_sql_mysql is a module that rlm_sql uses to interact with a mysql database. Running configure builds that module for you, it does not build the database. The database must by built by you, by hand! The tricky part is the fact that you must have the mysql development libraries installed on your system before these modules will build. The file ~/freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql is the file you pass into mysql to create the tables in the database for you. However, you must have created the database itself prior to trying to create the tables. If you look the the first few lines of db_mysql.sql you will see this: # db_mysql.sql rlm_sql - FreeRADIUS SQL Module # # # # Database schema for MySQL rlm_sql module# # # # To load:# # mysql -uroot -prootpass radius db_mysql.sql # This is assuming that you create a database called radius by hand before you run the above mysql command. The mysql libraries are kept in /usr/lib/mysql. The database is kept in /var/lib/mysql. Here you will find a directory for mysql and the mysql.sock driver file. If you create a new database, it will be stored in this directory under the database name. These above paths may be correct on your system, but different linux distributions and other OS's can have different paths. I don't want to sound like an a$$, I just wanted to make some clarifications. Hope this helps! Nick Kenneth L. Miller Information Technology Specialist CENWP-IM-C Portland, Oregon (503) 808-5056 -- 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: Missing rlm sql mysql
I don't want to sound like an a$$, I just wanted to make some clarifications. Hope this helps! Nick No, you're not sounding anything close to that, Nick :-) I think you're pretty much speaking for the rest of us. The difference is that the rest of us either missed the post or couldn't be bothered correcting it... And just to support your point, I've got MySQL installed in /db/mysql (incidentally, Postgres' data is stored in /db/pgsql ...). I just like to have my databases in a separate partition altogether... ~Benjamin - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Missing rlm sql mysql
I have read the FAQ thanks and tried what is said. Doesnt fix it! Please be more specific The FAQ. Tim - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Missing rlm sql mysql
I dont know how to get much more specific than the FAQ section 4.14 One of the following is the problem: The file is not on the system One of its dependent libraries is not on the system The file or one of its dependent libraries is not in the search path of the linker because the linker is misconfigured or the files are in the wrong location. You just have to verify each of the above items until you find out which one it is. Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Linval Sent: Monday, June 16, 2003 8:36 AM To: [EMAIL PROTECTED] Subject: RE: Missing rlm sql mysql I have read the FAQ thanks and tried what is said. Doesnt fix it! Please be more specific The FAQ. Tim - 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: Missing rlm sql mysql
I have read the FAQ thanks and tried what is said. Doesnt fix it! Please be more specific If you have ldconfig on your system, you may need to tell it where to find your MySQL libraries. For example, I had the same problems with PostgreSQL and since ld couldn't find libpq (it is installed in /usr/local/pgsql/lib by default), I simply ran ldconfig -m /usr/local/pgsql/lib and FreeRADIUS started up just fine. This is a problem with your linker and not FreeRADIUS, as the FAQ states... ~Benjamin - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Missing rlm sql mysql
Now for a dumb question... I believe that I have the correct path to the mysql libaries but I dont know what files are considered the mysql libaries. Can someone give me an example? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Missing rlm sql mysql
Title: RE: Missing rlm sql mysql Hi Michael, The rlm_sql_mysql file is for building the mysql database. Under the /freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql directory you will find the configure file. Just run this script by entering ./configure and it will create your mysql database for you. The mysql libraries are kept in /usr/lib/mysql. The database is kept in /var/lib/mysql. Here you will find a directory for mysql and the mysql.sock driver file. If you create a new database, it will be stored in this directory under the database name. Hope this helps. Regards Kenneth L. Miller Information Technology Specialist CENWP-IM-C Portland, Oregon (503) 808-5056 -Original Message- From: Michael Linval [mailto:[EMAIL PROTECTED]] Sent: Monday, June 16, 2003 9:04 AM To: [EMAIL PROTECTED] Subject: RE: Missing rlm sql mysql Now for a dumb question... I believe that I have the correct path to the mysql libaries but I dont know what files are considered the mysql libaries. Can someone give me an example? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Missing rlm sql mysql
I believe that I have the correct path to the mysql libaries but I dont know what files are considered the mysql libaries. Depending on how you installed MySQL, you *may* need to download the libraries and header files separately: http://www.mysql.com/downloads/ Look for Libraries and Header Files. I built MySQL from source and this is what I have: libdbug.a libmyisammrg.a libmysqlclient.so.10 libheap.a libmysqlclient.alibmystrings.a libmerge.a libmysqlclient.la libmysys.a libmyisam.a libmysqlclient.so libnisam.a You may also want to verify that rlm_sql_mysql was built. If it wasn't, then FreeRADIUS was unable to find the libraries at build time. I don't use MySQL personally, so I may have gotten something wrong (correct me if I did :-) but these requirements are pretty much the same across the board... ~Benjamin - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Missing rlm sql mysql
Now you should understand that it isn't a freeradius problem. if you want to see exactly what files it is looking for you should execute. strace radius -X radiusdebug.txt just wait for 20 seconds and the cat the radiusdebug.txt file looking for No such file and look and see what it's looking for. Most of the time they are libraries that were placed in your /mysqldist/lib/ directory. You should also consider looking through this list a little bit more before you ask questions. Many people have answered that question time and time over. Cheers, Watson - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
