Re: FreeBSD woes!
> It works for me now! I will gladly uphgrade from 0.7-but I cannot to > 0.8.1-because it will not work with freeBSD, maybe this is a bug? Because I > install 0.7 and it works! Strange... I'm using FreeRADIUS 0.8.1 on FreeBSD 4.7. I got it to work with both MySQL 4.0.13 and PostgreSQL 7.3.3 without any issues. *shrugs* Either way, I seriously doubt it's a bug with FreeRADIUS. If for some strange reason it didn't like FreeBSD, I'd probably be having problems by now ;-) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeBSD woes!
Did you use the --with-lib-path and --with-include-path when you ran the configure script? On Tuesday, Jun 17, 2003, at 03:27 Europe/London, Jeff Thompson - World Net Technical Support wrote: I have spent almost ALL DAY trying to get this to work. I have trolled the archives, and checked my ldconfig settings, but nothing seems to work. I am getting the COMMON : 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. error on startup I did install the rlm_sql_mysql driver in "/home/jefft/freeradius-0.8.1/src/modules/rlm_sql/drivers/ rlm_sql_mysql" and it reports all the files were installed in 'usr/local/lib' I added this path-along with /usr/local/lib/mysql to my profile-still nothing. What I am thinking is that I am missing the development headers for mysql. I have searched high and low on the net-but can only find rpm releases of these headres, I'm on FreeBSD and cannot get the rpms to install. I have reached the end of what I know to do-can someone guide me in the right direction? Im so confused and frustarted! - 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: FreeBSD woes!
- Original Message - From: "Frank Cusack" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 1:51 AM Subject: Re: FreeBSD woes! > On Mon, Jun 16, 2003 at 09:27:16PM -0500, Jeff Thompson - World Net Technical Support wrote: > > 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. > > > > error on startup > > > > I did install the rlm_sql_mysql driver in > > "/home/jefft/freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql" > > and it reports all the files were installed in 'usr/local/lib' > > You haven't by chance tried to mix an 0.8.1 driver with a non-0.8.1 radiusd? > This works up to 0.8.1, but as of CVS a couple of weeks ago, radiusd won't > load an older mysql driver. To test this theory, I redid an install of freeradius 0.8.1, from freeradius.org. When starting up freeradius-I get the sql module error again. I am using the driver that was unpacked in the source tarball... > > On Tue, Jun 17, 2003 at 12:29:45AM -0500, Jeff wrote: > > Well I got the sql module to load! I went into the ports collection > > (freeradius.7) after installing mysql4, and built it from source there > > If that's freeradius-0.7 you really shouldn't run that, it has known > problems. It works for me now! I will gladly uphgrade from 0.7-but I cannot to 0.8.1-because it will not work with freeBSD, maybe this is a bug? Because I install 0.7 and it works! > > /fc > > - > 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: FreeBSD woes!
On Mon, Jun 16, 2003 at 09:27:16PM -0500, Jeff Thompson - World Net Technical Support wrote: > 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. > > error on startup > > I did install the rlm_sql_mysql driver in > "/home/jefft/freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql" > and it reports all the files were installed in 'usr/local/lib' You haven't by chance tried to mix an 0.8.1 driver with a non-0.8.1 radiusd? This works up to 0.8.1, but as of CVS a couple of weeks ago, radiusd won't load an older mysql driver. On Tue, Jun 17, 2003 at 12:29:45AM -0500, Jeff wrote: > Well I got the sql module to load! I went into the ports collection > (freeradius.7) after installing mysql4, and built it from source there If that's freeradius-0.7 you really shouldn't run that, it has known problems. /fc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeBSD woes!
Duh, I had to CREATE the database 1st, sorry for the silly post been a LONG day and I forgot this step! Thanks for all the help Doh. I guess it helps if I check my e-mail before firing off a reply. Apologies for the rather redundant post!!! Anyway, no problem -- I remember when similar errors with Postgres drove me nuts until I realized it was ldconfig's problem. Well, it's almost midnight here and I've been trying to convince myself to work on something productive. So far it hasn't happened... ~Benjamin - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeBSD woes!
Well I got the sql module to load! I went into the ports collection (freeradius.7) after installing mysql4, and built it from source there Good, good... I don't know why it's looking for that radius database-this is supposed to build the file 'radius' from db_mysql.sql right? I'm s close now! Actually, db_mysql.sql contains the schemas necessary to create the needed tables within the radius database. You will need to create the database ``radius'' but hand and use a command similar to the following: mysql radius < db_mysql.sql But don't forget to connect to your MySQL server, create a database called ``radius,'' and then use the schemas to create the tables. The fun part will be populating the tables, however ;-) - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeBSD woes!
Duh, I had to CREATE the database 1st, sorry for the silly post been a LONG day and I forgot this step! Thanks for all the help - Original Message - From: "Jeff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 12:29 AM Subject: Re: FreeBSD woes! > Well I got the sql module to load! I went into the ports collection > (freeradius.7) after installing mysql4, and built it from source there > > I got it up and running, but when trying to use the schema outlined > (http://www.frontios.com/freeradius.html) I get the following: > > [/home/jefft/freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql]# > mysql -uroot -myrootpass radius < db_mysql.sql > ERROR 1049: Unknown database 'radius' > [MOCKINGBIRD.ROOT][/home/jefft/freeradius-0.8.1/src/modules/rlm_sql/drivers/ > rlm_sql_mysql]# > > I don't know why it's looking for that radius database-this is supposed to > build the file 'radius' from db_mysql.sql right? I'm s close now! > > Jeff > > > > > > - Original Message - > From: "Benjamin A. Shelton" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, June 16, 2003 11:31 PM > Subject: Re: FreeBSD woes! > > > > > > > > > > >I too love the ports. They are much easier to manage and edit than rpms, > I > > >have NEVER had a problem until now with using the BSD ports. > > > > > One of the things I've always appreciated about them is the fact that > > (usually) the necessary patches are pre-applied... and the source is > > built automagically. Quite fascinating. [purist plug] I've never > > really cared that much for the various flavors of Linux anyway and have > > pretty much always been a *BSD fanatic so far as my servers go [/purist > > plug]. Of course, if anyone were to look at my message headers, they'd > > notice right away that I'm writing this on a Win32 machine -- I'm such a > > hypocrite :-) -- but I do have my reasons. > > > > (BTW, speaking of the packages, you might want to make sure you have > > gmake installed. Sometimes BSD make barfs for silly reasons during a > > build...) > > > > >There is a 40 mysql port, but I will try the source install instead. I > hope > > >it works :) > > > > > > > > Heh, I can tell the ports temptation is there still :-D > > > > ~Benjamin > > > > > > > > - > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.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: FreeBSD woes!
Well I got the sql module to load! I went into the ports collection (freeradius.7) after installing mysql4, and built it from source there I got it up and running, but when trying to use the schema outlined (http://www.frontios.com/freeradius.html) I get the following: [/home/jefft/freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql]# mysql -uroot -myrootpass radius < db_mysql.sql ERROR 1049: Unknown database 'radius' [MOCKINGBIRD.ROOT][/home/jefft/freeradius-0.8.1/src/modules/rlm_sql/drivers/ rlm_sql_mysql]# I don't know why it's looking for that radius database-this is supposed to build the file 'radius' from db_mysql.sql right? I'm s close now! Jeff - Original Message - From: "Benjamin A. Shelton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 16, 2003 11:31 PM Subject: Re: FreeBSD woes! > > > > > >I too love the ports. They are much easier to manage and edit than rpms, I > >have NEVER had a problem until now with using the BSD ports. > > > One of the things I've always appreciated about them is the fact that > (usually) the necessary patches are pre-applied... and the source is > built automagically. Quite fascinating. [purist plug] I've never > really cared that much for the various flavors of Linux anyway and have > pretty much always been a *BSD fanatic so far as my servers go [/purist > plug]. Of course, if anyone were to look at my message headers, they'd > notice right away that I'm writing this on a Win32 machine -- I'm such a > hypocrite :-) -- but I do have my reasons. > > (BTW, speaking of the packages, you might want to make sure you have > gmake installed. Sometimes BSD make barfs for silly reasons during a > build...) > > >There is a 40 mysql port, but I will try the source install instead. I hope > >it works :) > > > > > Heh, I can tell the ports temptation is there still :-D > > ~Benjamin > > > > - > 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: FreeBSD woes!
I too love the ports. They are much easier to manage and edit than rpms, I have NEVER had a problem until now with using the BSD ports. One of the things I've always appreciated about them is the fact that (usually) the necessary patches are pre-applied... and the source is built automagically. Quite fascinating. [purist plug] I've never really cared that much for the various flavors of Linux anyway and have pretty much always been a *BSD fanatic so far as my servers go [/purist plug]. Of course, if anyone were to look at my message headers, they'd notice right away that I'm writing this on a Win32 machine -- I'm such a hypocrite :-) -- but I do have my reasons. (BTW, speaking of the packages, you might want to make sure you have gmake installed. Sometimes BSD make barfs for silly reasons during a build...) There is a 40 mysql port, but I will try the source install instead. I hope it works :) Heh, I can tell the ports temptation is there still :-D ~Benjamin - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeBSD woes!
A note to the aside... I too love the ports. They are much easier to manage and edit than rpms, I have NEVER had a problem until now with using the BSD ports. There is a 40 mysql port, but I will try the source install instead. I hope it works :) - Original Message - From: "Benjamin A. Shelton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 16, 2003 11:14 PM Subject: Re: FreeBSD woes! > > > > > >I will try the newest version source, should I just make sure it installs to > >the same path to ensure a proper upgrade? Any special commands I need to run > >at configure to ensure a clean install? > > > > > It should install to /usr/local/mysql by default (if I remember > correctly). When you unpack the tarball, you'll notice an > INSTALL-SOURCE file. It contains much more detailed information than I > can provide along with some suggestions for building the binaries under > FreeBSD (4.7). However, I should note that the only special options I > added were simply to install it in a different directory so it's up to you. > > Just make sure that after you install the latest version of MySQL you > rebuild FreeRADIUS after running a make distclean (just to be on the > safe side--at least this is what I usually do... saves having to unpack > the tarball again). If it is able to find all of your libraries, it > should build rlm_sql_mysql* and hopefully you will be able to get it up > and running :-) > > As an aside, I haven't had many problems with the ports/packages > collection with FreeBSD -- but then, I usually only install oddball > software from the ports or binaries I'm too lazy to build myself. I've > never actually tried installing MySQL from the ports collection before > although I can't imagine it would have failed... > > Let me know if downloading the source tarball helps out! > > ~Benjamin > > > > - > 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: FreeBSD woes!
I will try the newest version source, should I just make sure it installs to the same path to ensure a proper upgrade? Any special commands I need to run at configure to ensure a clean install? It should install to /usr/local/mysql by default (if I remember correctly). When you unpack the tarball, you'll notice an INSTALL-SOURCE file. It contains much more detailed information than I can provide along with some suggestions for building the binaries under FreeBSD (4.7). However, I should note that the only special options I added were simply to install it in a different directory so it's up to you. Just make sure that after you install the latest version of MySQL you rebuild FreeRADIUS after running a make distclean (just to be on the safe side--at least this is what I usually do... saves having to unpack the tarball again). If it is able to find all of your libraries, it should build rlm_sql_mysql* and hopefully you will be able to get it up and running :-) As an aside, I haven't had many problems with the ports/packages collection with FreeBSD -- but then, I usually only install oddball software from the ports or binaries I'm too lazy to build myself. I've never actually tried installing MySQL from the ports collection before although I can't imagine it would have failed... Let me know if downloading the source tarball helps out! ~Benjamin - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeBSD woes!
Yes, the output only refrences 1 file: lmysqlclient.10 => /usr/local/lib/mysql/libmysqlclient.so.10 I don't understand why it is not working-but it does not tell me which file it cannot load-so I'm assuming it wouldn't be the devel headers? Everything looks about right. I just built MySQL from source (version 4.0.13, however) and it worked perfectly fine with FreeRADIUS. Aside from my unusual directories, my linker has available the libmysqlclient in its search path: 264:-lmysqlclient.12 => /db/mysql/lib/mysql/libmysqlclient.so.12 And each of the rlm modules were built: [aquila-ii:raddb]# ls /usr/local/lib/rlm_sql_mysql* /usr/local/lib/rlm_sql_mysql.a /usr/local/lib/rlm_sql_mysql.so /usr/local/lib/rlm_sql_mysql.la /usr/local/lib/rlm_sql_mysql.so.0 If you have all of the rlm_sql_mysql* modules built and ld can find your libmysqlclient, I'm really not sure what to suggest except for downloading and building MySQL from source... I'm sure others on the list who have dealt with this issue continuously would be better able to help you than I since I am using PostgreSQL instead, and I was unable to duplicate the problem (albeit with a newer version of MySQL). ~Benjamin - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeBSD woes!
I will try the newest version source, should I just make sure it installs to the same path to ensure a proper upgrade? Any special commands I need to run at configure to ensure a clean install? Thanks! - Original Message - From: "Benjamin A. Shelton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 16, 2003 10:59 PM Subject: Re: FreeBSD woes! > > > > > >Yes, the output only refrences 1 file: > >lmysqlclient.10 => /usr/local/lib/mysql/libmysqlclient.so.10 > > > >I don't understand why it is not working-but it does not tell me which > >file it cannot load-so I'm assuming it wouldn't be the devel headers? > > > Everything looks about right. I just built MySQL from source (version > 4.0.13, however) and it worked perfectly fine with FreeRADIUS. Aside > from my unusual directories, my linker has available the libmysqlclient > in its search path: > 264:-lmysqlclient.12 => /db/mysql/lib/mysql/libmysqlclient.so.12 > > And each of the rlm modules were built: > > [aquila-ii:raddb]# ls /usr/local/lib/rlm_sql_mysql* > /usr/local/lib/rlm_sql_mysql.a /usr/local/lib/rlm_sql_mysql.so > /usr/local/lib/rlm_sql_mysql.la /usr/local/lib/rlm_sql_mysql.so.0 > > If you have all of the rlm_sql_mysql* modules built and ld can find your > libmysqlclient, I'm really not sure what to suggest except for > downloading and building MySQL from source... > > I'm sure others on the list who have dealt with this issue continuously > would be better able to help you than I since I am using PostgreSQL > instead, and I was unable to duplicate the problem (albeit with a newer > version of MySQL). > > ~Benjamin > > > > - > 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: FreeBSD woes!
>> >> >>I installed both mysql-323-server/client from the /usr/ports/databases >> port collection in freebsd. >> >> > Hmm, I would think it'd be able to find the MySQL libraries then. Have > you checked the output from ldconfig -r at all? > > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html Yes, the output only refrences 1 file: lmysqlclient.10 => /usr/local/lib/mysql/libmysqlclient.so.10 I don't understand why it is not working-but it does not tell me which file it cannot load-so I'm assuming it wouldn't be the devel headers? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeBSD woes!
I installed both mysql-323-server/client from the /usr/ports/databases port collection in freebsd. Hmm, I would think it'd be able to find the MySQL libraries then. Have you checked the output from ldconfig -r at all? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeBSD woes!
What I am thinking is that I am missing the development headers for mysql. I have searched high and low on the net-but can only find rpm releases of these headres, I'm on FreeBSD and cannot get the rpms to install. Did rlm_sql_mysql build? Did you install MySQL from the source or from a binary package? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: FreeBSD woes!
>> >> >>What I am thinking is that I am missing the development headers for >> mysql. I have searched high and low on the net-but can only find rpm >> releases of these headres, I'm on FreeBSD and cannot get the rpms to >> install. >> >> > Did rlm_sql_mysql build? Did you install MySQL from the source or from > a binary package? > > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html It appears to have built-here is the output from gmake install in the "/home/jefft/freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql" dir: [ "xrlm_sql_mysql" = "x" ] || /usr/home/jefft/freeradius-0.8.1/libtool --mode=install /usr/home/jefft/freeradius-0.8.1/install-sh -c -c rlm_sql_mysql.la /usr/local/lib/rlm_sql_mysql.la /usr/home/jefft/freeradius-0.8.1/install-sh -c -c .libs/rlm_sql_mysql.so.0 /usr/local/lib/rlm_sql_mysql.so.0 (cd /usr/local/lib && rm -f rlm_sql_mysql.so && ln -s rlm_sql_mysql.so.0 rlm_sql_mysql.so) (cd /usr/local/lib && rm -f rlm_sql_mysql.so && ln -s rlm_sql_mysql.so.0 rlm_sql_mysql.so) /usr/home/jefft/freeradius-0.8.1/install-sh -c -c .libs/rlm_sql_mysql.lai /usr/local/lib/rlm_sql_mysql.la /usr/home/jefft/freeradius-0.8.1/install-sh -c -c .libs/rlm_sql_mysql.a /usr/local/lib/rlm_sql_mysql.a ranlib /usr/local/lib/rlm_sql_mysql.a chmod 644 /usr/local/lib/rlm_sql_mysql.a -- Libraries have been installed in: /usr/local/lib If you ever happen to want to link against installed libraries in a given directory, LIBDIR, you must either use libtool, and specify the full pathname of the library, or use the `-LLIBDIR' flag during linking and do at least one of the following: - add LIBDIR to the `LD_LIBRARY_PATH' environment variable during execution - add LIBDIR to the `LD_RUN_PATH' environment variable during linking - use the `-Wl,--rpath -Wl,LIBDIR' linker flag - have your system administrator add LIBDIR to `/etc/ld.so.conf' See any operating system documentation about shared libraries for more information, such as the ld(1) and ld.so(8) manual pages. I installed both mysql-323-server/client from the /usr/ports/databases port collection in freebsd. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
FreeBSD woes!
I have spent almost ALL DAY trying to get this to work. I have trolled the archives, and checked my ldconfig settings, but nothing seems to work. I am getting the COMMON : 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. error on startup I did install the rlm_sql_mysql driver in "/home/jefft/freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql" and it reports all the files were installed in 'usr/local/lib' I added this path-along with /usr/local/lib/mysql to my profile-still nothing. What I am thinking is that I am missing the development headers for mysql. I have searched high and low on the net-but can only find rpm releases of these headres, I'm on FreeBSD and cannot get the rpms to install. I have reached the end of what I know to do-can someone guide me in the right direction? Im so confused and frustarted! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html