Re: MySQL and FreeRADIUS environment
Sorry, can you tell me where are detail file readers for examples? Thank you for your help. We apologize for any inconvenience caused -- View this message in context: http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4875532.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
On 6 Oct 2011, at 09:59, tonimanel wrote: Sorry, can you tell me where are detail file readers for examples? Thank you for your help. We apologize for any inconvenience caused raddb/sites-available/buffered-sql -Arran Arran Cudbard-Bell a.cudba...@freeradius.org Betelwiki, Betelwiki, Betelwiki http://wiki.freeradius.org/ ! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
Arran Cudbard-Bell wrote: raddb/sites-available/buffered-sql He's already been told MULTIPLE times where to look. I can only conclude he's lazy, or he's trying to be rude. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
Sorry did not mean to cause this series of comments to me. I just found something missing, I think, by the discrepancy between files with respect to the installation I have done and what you say here. Once again I apologize. Thanks. -- View this message in context: http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4875626.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
On 6 Oct 2011, at 10:19, Alan DeKok wrote: Arran Cudbard-Bell wrote: raddb/sites-available/buffered-sql He's already been told MULTIPLE times where to look. I can only conclude he's lazy, or he's trying to be rude. Ah, was in auto-help mode. Blame it on the iGrief. Arran Cudbard-Bell a.cudba...@freeradius.org Betelwiki, Betelwiki, Betelwiki http://wiki.freeradius.org/ ! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
Hi again, How can I do freeradius replication with radrelay? Do you know any tutorial or howto? I have a basic freeradius service installed and function!!! Thanks! -- View this message in context: http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4872147.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
My FreeRADIU version is 2.1.10 on Debian. Suggest me update? Or is a valid verstion to work and implement freeradius replication with radrelay? Thanks, -- View this message in context: http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4872269.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
On Wed, Oct 5, 2011 at 4:57 PM, tonimanel antoniofernan...@fabergames.com wrote: Hi again, How can I do freeradius replication with radrelay? Do you know any tutorial or howto? Have you READ the suggested documentation? For example, Alan said Also, raddb/sites-available/copy-acct-to-home-server I also wrote earlier rerarding FR-managed replication: In this setup the user data needs to be synced manually though. -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
I'm going to read this example file. I don't know if I will understand it but I will try it. Thanks, -- View this message in context: http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4872336.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
tonimanel wrote:
I have readed the example file. I have some doubts.
Do I get with this example file? I don't have a radrelay.conf example (or is
this?)
Yes, you do. See the raddb/ directory.
... I have readed in Internet that in radiusd.conf I should to define
a detail block information like detail detail-name {some information} to get
two binary files with my main server data (then the other server should to
use to replicate data), it is true?
You could try reading the examples that come with the server. The
examples you were told to read.
Why search the internet when you have the answers in front of you?
And then I should create radrelay.conf
file (because not exists in /etc/freeradius) with what information? I think
that with listen block of copy-acct-to-home-server file, it is true?
The server comes with a sample radrelay.conf. See the tar file on
the web site.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
I have readed the sites-available/example file that contains an example of how to define a client and a server. I should to define a client and a server in both machines (serverA's client is server B AND serverB's client is server A). Do you understand me? Thanks again. -- View this message in context: http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4872439.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
tonimanel wrote: I have readed the sites-available/example file that contains an example of how to define a client and a server. i.e. you didn't do what you were told to do. I should to define a client and a server in both machines (serverA's client is server B AND serverB's client is server A). Do you understand me? I have no idea. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
Hi again, I have a doubt, what happen if in my company we want to have two servers, both with freeradius service and mysql service and this two servers could be actives with mysql data replicated? We would like to have two servers as actives with the ability to be both functional. I think that is more difficult than the other solution but this is best. Is possible to make the data replica with TCP protocol with FreeRADIUS? Do you prefer FreeRADIUS replica or mysql replica? What is the best solution to make the replica? Thank you very much!!! I hope your answers!! -- View this message in context: http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4868964.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
tonimanel wrote: Is possible to make the data replica with TCP protocol with FreeRADIUS? Do you prefer FreeRADIUS replica or mysql replica? What is the best solution to make the replica? The best solution is to use RADIUS replication. FreeRADIUS knows how to do conflict resolution in the database. MySQL does not. See raddb/radrelay.conf, and the detail file readers for examples. Also, raddb/sites-available/copy-acct-to-home-server Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
Hi, thank you for your answer. We are thinking in two servers: First server with one freeradius and mysql service, both services as actives. Second server, another freeradius service with mysql service running also. Two servers must to have data replicated. I think that this is the best solution for my company, it's possible with mysql and freeradius in Debian? Thanks -- View this message in context: http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4857276.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MySQL and FreeRADIUS environment.
Hi, thank you for your answer. I think the same. We are thinking in two servers: First server with one freeradius and mysql service, both services as actives. Second server, another freeradius service with mysql service running also. Two servers must to have data replicated. I think that this is the best solution for my company, it's possible with mysql and freeradius in Debian? Do you know how we have to make the configuration to replicate data for mysql and freeradius? Thanks -- View this message in context: http://freeradius.1045715.n5.nabble.com/Fwd-MySQL-and-FreeRADIUS-environment-tp4846037p4857295.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
On Fri, Sep 30, 2011 at 9:19 PM, tonimanel antoniofernan...@fabergames.com wrote: Hi, thank you for your answer. We are thinking in two servers: First server with one freeradius and mysql service, both services as actives. Second server, another freeradius service with mysql service running also. Two servers must to have data replicated. Like I said, eaerlier there are many possible configuration with varying degrees of cost and complexity, depending on how much you can tolerate a single point of failure. If you have a somewhat experienced MySQL admin you could create a master-master replication. It's not really a cluster, but should be enough for simple purposes: http://www.google.co.id/search?q=mysql+master+master+replication On the other hand, if you have more experience in freeradius, you could create two independent instances and have FR replicate accounting data to each other (or have each FR instance write to two db, possibly with buffered sql) to maintain sync. In this setup the user data needs to be synced manually though. I think that this is the best solution for my company, it's possible with mysql and freeradius in Debian? It's not really a matter of which distro, but rather expertise. If you use a distro with recent-enough version of freeradius, or willing to compile from source, it should work. -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment.
Master/slave, or replication and remote accounting, if you want one true source let radius deal with the sql rather than trying anything with sql. Final advice would be to use postgresql rather than mysql, our performance increase was a magnitude better when we ditched mysql alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MySQL and FreeRADIUS environment.
I would recommend two servers using MySQL Replication. 1. Master Server with FreeRADIUS and MySQL Master; write accounting packets to MySQL 2. Replica Server with FreeRADIUS and MySQL Replica; forward accounting packets to Master for writing to MySQL As for performance, my record is 3,000 authentications/sec on a server using MySQL. Thats over 10 million authentications per hour and a ¼ billion per day. That should be enough to start with. Tim From: freeradius-users-bounces+tim.sylvester=networkradius@lists.freeradius.or g [mailto:freeradius-users-bounces+tim.sylvester=networkradius.com@lists.freer adius.org] On Behalf Of Antonio Fernández Pérez Sent: Tuesday, September 27, 2011 9:33 AM To: freeradius-users@lists.freeradius.org Subject: Fwd: MySQL and FreeRADIUS environment. Hi everybody, In my company we are thinking to implement a FreeRADIUS server with MySQL on Linux. We need to duplicate FreeRADIUS service because we think that this is a critical service for us but the authentication process only could be done with the master server(FreeRADIUS and MySQL service, both in only one server). For the other hand, if we want to replicate the data base servers, we would have to synchronize two database servers but we would not know wich would be the best solution, cluster or synchronize. Maybe we will not to need a MySQL cluster service and we will need two servers only. First with master FreeRADIUS service and master MySQL service and the second with slave FreeRADIUS service and slave MySQL service. What do you think about the best solution to implement this environment? I hope your answer. Thank you very much. Regards, -- Antonio Manuel Fernández Pérez Ingeniero Técnico Informático Dpto. Informático Fabergames S.L. TLF:96626 / FAX:966551801 http://www.fabergames.com/ www.fabergames.com Fabergames respeta su privacidad http://www.fabergames.com/index.php/component/content/article/57/1-politica -de-privacidad * * * ADVERTENCIA LEGAL * * * Le informamos, como destinatario de este mensaje, que el correo electrónico y las comunicaciones por medio de Internet no permiten asegurar ni garantizar la confidencialidad de los mensajes transmitidos, así como tampoco su integridad o su correcta recepción, por lo que FABERGAMES S.L. no asume responsabilidad alguna por tales circunstancias. Si no consintiese en la utilización del correo electrónico o de las comunicaciones vía Internet le rogamos nos lo comunique y ponga en nuestro conocimiento de manera inmediata. Este mensaje va dirigido, de manera exclusiva, a su destinatario y contiene información confidencial y sujeta al secreto profesional, cuya divulgación no está permitida por la ley. En caso de haber recibido este mensaje por error, le rogamos que, de forma inmediata, nos lo comunique mediante correo electrónico remitido a nuestra atención o a través del teléfono (+ 34) 966 26 11 11 y proceda a su eliminación, así como a la de cualquier documento adjunto al mismo. Asimismo, le comunicamos que la distribución, copia o utilización de este mensaje, o de cualquier documento adjunto al mismo, cualquiera que fuera su finalidad, están prohibidas por la ley. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment.
Alan Buxey a.l.m.bu...@lboro.ac.uk wrote: Master/slave, or replication and remote accounting, if you want one true source let radius deal with the sql rather than trying anything with sql. Final advice would be to use postgresql rather than mysql, our performance increase was a magnitude better when we ditched mysql Our experience has been that using MySQL pretty much guarantees you *will* be burnt...especially with the replication. Cheers -- Alexander Clouter .sigmonster says: I'm having a MID-WEEK CRISIS! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRADIUS environment
On Tue, Sep 27, 2011 at 11:32 PM, tonimanel antoniofernan...@fabergames.com wrote: Hi everybody, In my company we are thinking to implement a FreeRADIUS server with MySQL on Linux. We need to duplicate FreeRADIUS service because we think that this is a critical service for us but the authentication process only could be done with the master server(FreeRADIUS and MySQL service, both in only one server). For the other hand, if we want to replicate the data base servers, we would have to synchronize two database servers but we would not know wich would be the best solution, cluster or synchronize. Maybe we will not to need a MySQL cluster service and we will need two servers only. First with master FreeRADIUS service and master MySQL service and the second with slave FreeRADIUS service and slave MySQL service. What do you think about the best solution to implement this environment? Hire someone who have implement a similar setup. There are many possible configuration with varying degrees of cost and complexity, depending on how much you can tolerate a single point of failure. The easiest way would be to have two or more servers running FR with one mysql master and many mysql slaves (FR and mysql can use the same server), with distributed sql reads (i.e. SELECT) and writes only to the master. In the event of failure, you need to manually (for maximum consistency) promote one slave to be master. The most complex way would be to setup a full mysql cluster, possibly with each server acting as FR, data node, and sql node. -- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySql on Freeradius
Since I want OpenSSL support i need to make my own build which Ubuntu´s own Freeradius release in Synaptic does not seem to have support for. I have tried to find information on the net about how to make a build of Freeradius that works together with MySql. If you built from source mysql is supported if you have mysql development libraries. All you have to do is remove comments from $INCLUDE sql.conf in radiusd.conf and from sql entries you want in virtual servers. Ivan Kalik - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql with freeradius Error again
Many thanks for quick reply.I'll do and try then must inform U about the result. Thanks again. On 5/16/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Quoting Abul Monsur Mannan [EMAIL PROTECTED]: how can I configure freeradius to accept request from mysql ? I'm using Freeradius1.1.1 on Redhat Enterprise4.Should I populate the tables 'redrely' as well as 'redgroup' with others? You need to populate all the tables except accounting with the correct information. Spend 10 minutes on google and search for a freeradius+mysql tutorial, there's plenty arround explaining what goes in what tables, with examples etc. -- Chris - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql with freeradius Error
Monsur Mannan [EMAIL PROTECTED] wrote: radius is not accept request other than root user. Read the output of the debug log. rad_check_password: Found Auth-Type System auth: type System Processing the authenticate section of radiusd.conf modcall: entering group authenticate for request 0 modcall[authenticate]: module unix returns notfound for request 0 You've configured it to look in /etc/passwd. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql with freeradius Error
Hello memebers, how can I configure freeradius to accept request from mysql ? Alan, thank U for your reply.But U didn't show me the way to get rid of the problem.. Monsur _ FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MYSQL and FreeRadius
Maybe a firewall script at startup? Regards, Edvin From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] g] On Behalf Of Diniz Da Rocha Sent: Samstag, 25. Februar 2006 06:51 To: freeradius-users@lists.freeradius.org Subject: MYSQL and FreeRadius Hi I have currently setup FreeRadius 1.0.4 with ldap authentication and authorization as well as mysql authorization and its all working fine. The problem exists when I restart the server, freeradius starts on boot but it fails in connecting to the MYSQL server. If I then shutdown the service and start it again it works fine. I have move the boot order to be S99 but it still fails. The MYSQL server is on a seperate server, so I am wondering whether the ports are blocked until startup is complete, if this is the case How can I get round this??? I am using Fedora Core 4... Has anyone else had this problem??? thanks diniz - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRadius
Mike-Olumide, Johnson [EMAIL PROTECTED] 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. How can I correct this pls? Please read the FAQ. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRadius
--- Alan DeKok [EMAIL PROTECTED] wrote: Mike-Olumide, Johnson [EMAIL PROTECTED] 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. How can I correct this pls? Please read the FAQ. Alan DeKok. I have read the FAQ and chose to make make install from source, but it returned with plenty errors as below. The other options with lib path and linker are strange as i couldn't figure out what to do. Will appreciate any help on this! ibraries 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. -- gmake[6]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_realm' Making install in rlm_sql... gmake[6]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql' if [ xrlm_sql != x ]; then \ /root/freeradius-1.0.1/libtool --mode=install /root/freeradius-1.0.1/install -sh -c -c \ rlm_sql.la /usr/local/lib/rlm_sql.la; \ rm -f /usr/local/lib/rlm_sql-1.0.1.la; \ ln -s rlm_sql.la /usr/local/lib/rlm_sql-1.0.1.la; \ fi libtool: install: `rlm_sql.la' is not a valid libtool archive Try `libtool --help --mode=install' for more information. gmake[7]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql' gmake[8]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql' Making install in drivers... gmake[9]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql/drivers ' /usr/bin/gmake -w WHAT_TO_MAKE=install common gmake[10]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql/driver s' Making install in rlm_sql_iodbc... gmake[11]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql/driver s/rlm_sql_iodbc' [ x = x ] || /root/freeradius-1.0.1/libtool --mode=install /root/freeradius- 1.0.1/install-sh -c -c .la /usr/local/lib/.la gmake[11]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql/drivers /rlm_sql_iodbc' Making install in rlm_sql_mysql... gmake[11]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql/driver s/rlm_sql_mysql' [ xrlm_sql_mysql = x ] || /root/freeradius-1.0.1/libtool --mode=install /roo t/freeradius-1.0.1/install-sh -c -c rlm_sql_mysql.la /usr/local/lib/rlm_sql_mysq l.la libtool: install: `rlm_sql_mysql.la' is not a valid libtool archive Try `libtool --help --mode=install' for more information. gmake[11]: *** [install] Error 1 gmake[11]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql/drivers /rlm_sql_mysql' gmake[10]: *** [common] Error 1 gmake[10]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql/drivers ' gmake[9]: *** [install] Error 2 gmake[9]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql/drivers' gmake[8]: *** [common] Error 1 gmake[8]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql' gmake[7]: *** [install-drivers] Error 2 gmake[7]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql' gmake[6]: *** [install] Error 2 gmake[6]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql' gmake[5]: *** [common] Error 1 gmake[5]: Leaving directory `/root/freeradius-1.0.1/src/modules' gmake[4]: *** [install] Error 2 gmake[4]: Leaving directory `/root/freeradius-1.0.1/src/modules' gmake[3]: *** [common] Error 1 gmake[3]: Leaving directory `/root/freeradius-1.0.1/src' gmake[2]: *** [install] Error 2 gmake[2]: Leaving directory `/root/freeradius-1.0.1/src' gmake[1]: *** [common] Error 1 gmake[1]: Leaving directory `/root/freeradius-1.0.1' make: *** [install] Error 2 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Thanks for your help. Mike = Michael-Olumide Johnson B.Sc.(Phy), PG.D(Fin.Mgt), MCP, CCNA 08033133324 __ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRadius
I think you need MySQl development package installed [EMAIL PROTECTED] 17/01/2005 16:52:48 --- Alan DeKok [EMAIL PROTECTED] wrote: "Mike-Olumide, Johnson" [EMAIL PROTECTED] 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.How can I correct this pls? Please read the FAQ. Alan DeKok.I have read the FAQ and chose to make make installfrom source, but it returned with plenty errors asbelow. The other options with lib path and linker arestrange as i couldn't figure out what to do. Willappreciate any help on this!ibraries have been installed in: /usr/local/libIf you ever happen to want to link against installedlibrariesin a given directory, LIBDIR, you must either uselibtool, andspecify the full pathname of the library, or use the`-LLIBDIR'flag during linking and do at least one of thefollowing: - add LIBDIR to the `LD_LIBRARY_PATH' environmentvariable during execution - add LIBDIR to the `LD_RUN_PATH' environmentvariable 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 sharedlibraries formore information, such as the ld(1) and ld.so(8)manual pages.--gmake[6]: Leaving directory`/root/freeradius-1.0.1/src/modules/rlm_realm'Making install in rlm_sql...gmake[6]: Entering directory`/root/freeradius-1.0.1/src/modules/rlm_sql'if [ "xrlm_sql" != "x" ]; then \ /root/freeradius-1.0.1/libtool --mode=install/root/freeradius-1.0.1/install-sh -c -c \ rlm_sql.la /usr/local/lib/rlm_sql.la; \ rm -f /usr/local/lib/rlm_sql-1.0.1.la; \ ln -s rlm_sql.la /usr/local/lib/rlm_sql-1.0.1.la;\filibtool: install: `rlm_sql.la' is not a valid libtoolarchiveTry `libtool --help --mode=install' for moreinformation.gmake[7]: Entering directory`/root/freeradius-1.0.1/src/modules/rlm_sql'gmake[8]: Entering directory`/root/freeradius-1.0.1/src/modules/rlm_sql'Making install in drivers...gmake[9]: Entering directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers'/usr/bin/gmake -w WHAT_TO_MAKE=install commongmake[10]: Entering directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers'Making install in rlm_sql_iodbc...gmake[11]: Entering directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_iodbc'[ "x" = "x" ] || /root/freeradius-1.0.1/libtool--mode=install /root/freeradius-1.0.1/install-sh -c -c .la /usr/local/lib/.lagmake[11]: Leaving directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_iodbc'Making install in rlm_sql_mysql...gmake[11]: Entering directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_mysql'[ "xrlm_sql_mysql" = "x" ] ||/root/freeradius-1.0.1/libtool --mode=install /root/freeradius-1.0.1/install-sh -c -c rlm_sql_mysql.la/usr/local/lib/rlm_sql_mysql.lalibtool: install: `rlm_sql_mysql.la' is not a validlibtool archiveTry `libtool --help --mode=install' for moreinformation.gmake[11]: *** [install] Error 1gmake[11]: Leaving directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_mysql'gmake[10]: *** [common] Error 1gmake[10]: Leaving directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers'gmake[9]: *** [install] Error 2gmake[9]: Leaving directory`/root/freeradius-1.0.1/src/modules/rlm_sql/drivers'gmake[8]: *** [common] Error 1gmake[8]: Leaving directory`/root/freeradius-1.0.1/src/modules/rlm_sql'gmake[7]: *** [install-drivers] Error 2gmake[7]: Leaving directory`/root/freeradius-1.0.1/src/modules/rlm_sql'gmake[6]: *** [install] Error 2gmake[6]: Leaving directory`/root/freeradius-1.0.1/src/modules/rlm_sql'gmake[5]: *** [common] Error 1gmake[5]: Leaving directory`/root/freeradius-1.0.1/src/modules'gmake[4]: *** [install] Error 2gmake[4]: Leaving directory`/root/freeradius-1.0.1/src/modules'gmake[3]: *** [common] Error 1gmake[3]: Leaving directory`/root/freeradius-1.0.1/src'gmake[2]: *** [install] Error 2gmake[2]: Leaving directory`/root/freeradius-1.0.1/src'gmake[1]: *** [common] Error 1gmake[1]: Leaving directory `/root/freeradius-1.0.1'make: *** [install] Error 2 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Thanks for your help.Mike=Michael-Olumide Johnson B.Sc.(Phy), PG.D(Fin.Mgt), MCP, CCNA08033133324 __ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySQL and FreeRadius
Thanks! Please could you help with any guide to be able to install MySQL development package? Have done some googling! Pls help. - Original Message - From: Neil Craig To: freeradius-users@lists.freeradius.org Sent: Monday, January 17, 2005 5:58 PM Subject: Re: MySQL and FreeRadius I think you need MySQl development package installed [EMAIL PROTECTED] 17/01/2005 16:52:48 --- Alan DeKok [EMAIL PROTECTED] wrote: Mike-Olumide, Johnson [EMAIL PROTECTED] 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. How can I correct this pls? Please read the FAQ. Alan DeKok. I have read the FAQ and chose to make make install from source, but it returned with plenty errors as below. The other options with lib path and linker are strange as i couldn't figure out what to do. Will appreciate any help on this! ibraries 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. -- gmake[6]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_realm' Making install in rlm_sql... gmake[6]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql' if [ xrlm_sql != x ]; then \ /root/freeradius-1.0.1/libtool --mode=install /root/freeradius-1.0.1/install -sh -c -c \ rlm_sql.la /usr/local/lib/rlm_sql.la; \ rm -f /usr/local/lib/rlm_sql-1.0.1.la; \ ln -s rlm_sql.la /usr/local/lib/rlm_sql-1.0.1.la; \ fi libtool: install: `rlm_sql.la' is not a valid libtool archive Try `libtool --help --mode=install' for more information. gmake[7]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql' gmake[8]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql' Making install in drivers... gmake[9]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql/drivers ' /usr/bin/gmake -w WHAT_TO_MAKE=install common gmake[10]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql/driver s' Making install in rlm_sql_iodbc... gmake[11]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql/driver s/rlm_sql_iodbc' [ x = x ] || /root/freeradius-1.0.1/libtool --mode=install /root/freeradius- 1.0.1/install-sh -c -c .la /usr/local/lib/.la gmake[11]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql/drivers /rlm_sql_iodbc' Making install in rlm_sql_mysql... gmake[11]: Entering directory `/root/freeradius-1.0.1/src/modules/rlm_sql/driver s/rlm_sql_mysql' [ xrlm_sql_mysql = x ] || /root/freeradius-1.0.1/libtool --mode=install /roo t/freeradius-1.0.1/install-sh -c -c rlm_sql_mysql.la /usr/local/lib/rlm_sql_mysq l.la libtool: install: `rlm_sql_mysql.la' is not a valid libtool archive Try `libtool --help --mode=install' for more information. gmake[11]: *** [install] Error 1 gmake[11]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql/drivers /rlm_sql_mysql' gmake[10]: *** [common] Error 1 gmake[10]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql/drivers ' gmake[9]: *** [install] Error 2 gmake[9]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql/drivers' gmake[8]: *** [common] Error 1 gmake[8]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql' gmake[7]: *** [install-drivers] Error 2 gmake[7]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql' gmake[6]: *** [install] Error 2 gmake[6]: Leaving directory `/root/freeradius-1.0.1/src/modules/rlm_sql' gmake[5]: *** [common] Error 1 gmake[5]: Leaving directory `/root/freeradius-1.0.1/src/modules' gmake[4]: *** [install] Error 2 gmake[4]: Leaving directory `/root/freeradius-1.0.1/src/modules' gmake[3]: *** [common] Error 1 gmake[3]: Leaving directory `/root/freeradius-1.0.1/src' gmake[2]: *** [install] Error 2 gmake[2]: Leaving directory `/root/freeradius-1.0.1/src' gmake[1]: *** [common] Error 1 gmake[1]: Leaving directory `/root/freeradius-1.0.1' make: *** [install] Error 2 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Thanks for your help. Mike = Michael-Olumide Johnson B.Sc.(Phy), PG.D(Fin.Mgt), MCP, CCNA 08033133324 __ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do
Re: MySQL and FreeRadius
Don, If you are in the directory where you unpacked freeradius it would be in: src/modules/rlm_sql/drivers/rlm_sql_mysql/ Hope that helps. D.J. On Mon, 17 Jan 2005 10:26:09 -0600, don [EMAIL PROTECTED] wrote: Hello list, I am running freeradius and mysql on Gentoo Linux. I have installed mysql, but can't seem to find the file, db_mysql.sql, so that I can create the radius database using the command: mysql -uroot -prootpass radius db_mysql.sql Does anyone out there have a clue where db_mysql.sql is hiding? Thanks, Don James Henderson, Texas USA - 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: mysql and freeradius
On Wed, 21 Jul 2004, wadih jalad wrote: hi all i make a freeradius with mysql on redhat 9. i have two problems: i notice that the symbol # is written as =23 , is there any way to fix this? i will appreciate. Open sql.conf, look for safe-characters. second, i want to make the authentication only on the NAS Ip, is there any way to do this. What do you mean by that exactly? In any case check out the users file and the checkval module for that (if i understand you correctly). any help will be appreciate. thanks _ Take charge with a pop-up guard built on patented Microsoft? SmartScreen Technology. http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN? Premium right now and get the first two months FREE*. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySql and freeRadius
use mysql 4.0 not 4.1alpha or 5.0alpha. They have a bug in authentication of mysql which might get you into troubles. On 24.03.2004, at 23:30, Kirti S. Bajwa wrote: Hello List: I want to make sure I am installing freeRADIUS MySQL correctly. I installed (test installation) freeRADIUS (0.9.3) and MySQL 5.0.0 (?) from binaries on a RH9 machine. It tested fine. In the next couple of days, I am going to do a final installation of freeRADIUS MySQL (with InnoDB). Questions: == (1) with the above setup, what version of MySQL (binaries or rpm) should I use? (2) Do I still need a develoment package of MySQL to work with freeRADIUS? If YES, what version of MySQL? I am new to MySQL!! Kirti -Original Message- From: Keith Yoder [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 2:36 PM To: [EMAIL PROTECTED] Subject: Re: MySql and freeRadius John Que escreveu: As I understand , I must install the sources of MySql if I want to use rlm_sql in freeRadius (and not install the rpm for mySql Server and client). Actually, you can install the -devel rpms and that will allow you to compile the rlm_sql_mysql module. This will make sure all the libraries and header files get to the right places. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html Andreas Fink Global Networks Switzerland AG -- Tel: +41-61-330 Fax: +41-61-334 Mobile: +41-79-2457333 Global Networks, Inc. Clarastrasse 3, 4058 Basel, Switzerland Web: http://www.global-networks.ch/ [EMAIL PROTECTED] -- PGP Fingerprint: B982 00B7 FFB5 0B33 BFF8 0F77 1E23 F3CA B4A3 D0B8 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql and Freeradius--WORKING FINE
Hi Mr. DeKok I just wanted to let you know that i did exatly what you said to do. I installed the Mysql Development package and i now have freeradius up and running using mysql with no problems at all. Everything is beautiful thanks to your help. I just wanted to show you my appreciation. Thank you, sir. - Original Message - From: Alan DeKok [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 30, 2004 3:01 PM Subject: Re: Mysql and Freeradius Linda Pagillo [EMAIL PROTECTED] wrote: Your previous post said Normally, you don't have to do anything. FreeRADIUS will find MySQL, and automatically build the rlm_sql_mysql driver. FreeRADIUS will find it: IF MYSQL EXISTS ON YOUR SYSTEM. It is very clear that the MySQL development package DOES NOT exist on your system. No amount of playing games with FreeRADIUS is going to install the MySQL development package. Stop playing with FreeRADIUS, it's not the problem. Install the MySQL development RPM. Now. So what you're telling me is that i should have an actual file called rlm_sql_mysql, is that correct? No. I never said that. I have no idea how you got that conclusion from my posts. Stop trying to interpret my responses. Because you're unfamiliar with the system, your interpretations are wrong. Take my responses at face value, believe them, and do what they say. Also, Mr.DeKok, please forgive me for asking questions that may seem simple to most people. I'm very new at this and Linux in general. I realize that you are a very intelligent man and being a programmer, you probably don't have the time to deal with newbies like me. Just know that your time is appreciated by me. Thank you again. I don't mind that you're unfamiliar with the process. I do mind that you seem to have trouble following instructions. Alan DeKok. - 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: Mysql and Freeradius--WORKING FINE
Hi Mr. DeKok I just wanted to let you know that i did exatly what you said to do. I installed the Mysql Development package and i now have freeradius up and running using mysql with no problems at all. Everything is beautiful thanks to your help. I just wanted to show you my appreciation. Thank you, sir. well done. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql and Freeradius--WORKING FINE
Linda Pagillo [EMAIL PROTECTED] wrote: I just wanted to let you know that i did exatly what you said to do. g That's what I like to hear. I installed the Mysql Development package and i now have freeradius up and running using mysql with no problems at all. Everything is beautiful thanks to your help. I just wanted to show you my appreciation. Thank you, sir. You're welcome. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql and Freeradius
Hello again: I've been trying for days to get freeradius working with Mysql. I'm using Linux Redhat 9, Mysql 3.23 and Freeradius-0.9.3 At first i configured freeradius without any options.. i was able to get it working perfectly using text file authentication. Then i started to configure the Mysql part of it. I made a mysql DB and populated it with test data. When i edited my sql.conf and radiusd.conf files to use the Mysql, i received this error... Could not link driver rlm_sql_mysql: file not found as i stated previously in my last post. I researched this error and tried every solution given to me from other users, etc... it came to the point where i just uninstalled Freeradius completely and reconfigured it like this ./configure --disable-shared. then i tried to get it running in text file authentication mode once again.It installed correctly, and i edited my radiusd.conf, clients.conf and users files how i wanted them and then when i ran radiusd -x i kept getting errors for almost every module saying that entries were missing for all of these modules.. so i went through my radiusd.conf file and i commented out everytihng that had to do with these errors.. i got it up and running so i thought because it said i was "ready to recevie requests", but when i did a radtest, it refused me. So then i went in and decided that i was going to try to setup the Mysql and see what happens. Well, i put an "sql" entry in the radiusd.conf file where i needed them and i edited my sql.conf file accordingly, but i got an error about the sql module entries being missing. I could not find a way around this, so i went ahead and completely uninstalled Freeradius again. Now, this is where i'm at. Surely there are many people out there that have freeradius running with Mysql flawlessly. Can anyone give me exact directions on how i need to ./configurefreeradius so that mysql works?I'm sorry about the long post, but i know you guys like for people to explain in detail the problems that they are having. Thank you. beside from mysql package, make sure you also have mysql-server package. see to it that your configure commands includes compiling freeradius with rlm_sqlcounter support. sql.conf and sqlcounter.conf files must also exists and be included with radiusd.conf. it seems that freeradius cannot find some sql files from your system. radiusd -X would give you a hint. if this is not the first time you install freeradius, removing all the commnets from radiusd.conf would help on easing tension on reading and modifying it. more to browse with freeradius list also helps, and more to google. good luck then.
Re: Mysql and Freeradius (OFF THE LIST)
it should work,one box that ihave is the exact platform, RH9, MySQL 3.23+freeradius 0.9.3 and it's still working, it's not a bug, there must be something wrong with your config. by the way, i can offer my service to you, setting up freeradius+mysql, (administration isoptional)not for money, but only for a book, not that i cannot buy a book, just a simple token from simple accomplishments. let me know your thoughts. //milver - Original Message - From: Linda Pagillo To: [EMAIL PROTECTED] Sent: Friday, April 30, 2004 5:58 PM Subject: Mysql and Freeradius Hello again: I've been trying for days to get freeradius working with Mysql. I'm using Linux Redhat 9, Mysql 3.23 and Freeradius-0.9.3 At first i configured freeradius without any options.. i was able to get it working perfectly using text file authentication. Then i started to configure the Mysql part of it. I made a mysql DB and populated it with test data. When i edited my sql.conf and radiusd.conf files to use the Mysql, i received this error... Could not link driver rlm_sql_mysql: file not found as i stated previously in my last post. I researched this error and tried every solution given to me from other users, etc... it came to the point where i just uninstalled Freeradius completely and reconfigured it like this ./configure --disable-shared. then i tried to get it running in text file authentication mode once again.It installed correctly, and i edited my radiusd.conf, clients.conf and users files how i wanted them and then when i ran radiusd -x i kept getting errors for almost every module saying that entries were missing for all of these modules.. so i went through my radiusd.conf file and i commented out everytihng that had to do with these errors.. i got it up and running so i thought because it said i was "ready to recevie requests", but when i did a radtest, it refused me. So then i went in and decided that i was going to try to setup the Mysql and see what happens. Well, i put an "sql" entry in the radiusd.conf file where i needed them and i edited my sql.conf file accordingly, but i got an error about the sql module entries being missing. I could not find a way around this, so i went ahead and completely uninstalled Freeradius again. Now, this is where i'm at. Surely there are many people out there that have freeradius running with Mysql flawlessly. Can anyone give me exact directions on how i need to ./configurefreeradius so that mysql works?I'm sorry about the long post, but i know you guys like for people to explain in detail the problems that they are having. Thank you. Linda PagilloDirector of Technical ServicesN2 The Net
Re: Mysql and Freeradius
Linda Pagillo [EMAIL PROTECTED] wrote: ... Please edit your text so it's not all one run-on sentence. Arranging text neatly not only looks pretty, it ensures that the ideas are communicated clearly. When i edited my sql.conf and radiusd.conf files to use the Mysql, i received this error... Could not link driver rlm_sql_mysql: file not found as i stated previously in my last post. And there was a reply with a solution for you to implement. I researched this error and tried every solution given to me from other users, etc... it came to the point where i just uninstalled Freeradius completely and reconfigured it like this ./configure --disable-shared. then i tried to get it running in text file authentication mode once again. It installed correctly, and i edited my radiusd.conf, clients.conf and users files how i wanted them and then when i ran radiusd -x i kept getting errors for almost every module saying that entries were missing for all of these modules.. so i went through my radiusd.conf file and i commented out everytihng that had to do with these errors.. Which was a complete and total waste of your time. You should be configuring the server to use MySQL, not deleting everything else from the server. So then i went in and decided that i was going to try to setup the Mysql and see what happens. Well, i put an sql entry in the radiusd.conf file where i needed them and i edited my sql.conf file accordingly, but i got an error about the sql module entries being missing. It helps if you post the *actual* error message. We can't read your mind, and we can't read your terminal remotely. I could not find a way around this, so i went ahead and completely uninstalled Freeradius again. Which is again a complete and total waste of your time. It's not a Windows program, you don't need to re-install it if it hiccups. Now, this is where i'm at. Surely there are many people out there that have freeradius running with Mysql flawlessly. Can anyone give me exact directions on how i need to ./configure freeradius so that mysql works? My previous reply explains what you have to do to get FreeRADIUS to know about MySQL. Work on that stage first. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql and Freeradius
Hi, I've seen your posts and you have my sympathy. The best I can say is that everything magically works if it's set up right. I think you've already seen the web site with the config notes? My suggestions would be to rebuild with a fresh dump from the tar file, in case you made some changes that arent working. Alan mentioned that you might not have the MySQL development package installed, which sounds like a good guess to me. On my system that's mysql-devel-3.23.58-1, but the version number should match what's on your machine. When you run configure, make sure you get some lines that look like this: checking for mysql/mysql.h... yes checking for mysql_init in -lmysqlclient... yes If youre missing the devel package these probably say no. There is also a faq about link problems. I dont think that applies to your case, but it's a common problem so you might check it out. Dave - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Mysql and Freeradius
Hi Mr.DeKok, Your previous post said Normally, you don't have to do anything. FreeRADIUS will find MySQL, and automatically build the rlm_sql_mysql driver. When i configured freeradius the first time, i didn't do anything special. I just did the basic ./configure and that was it. As i posted previously, i ended up with a rlm_sql_mysql directory, not an actual file. Inside the directory showed files such as configure and MakeFile. This made me wonder if i had to do something with it. So what you're telling me is that i should have an actual file called rlm_sql_mysql, is that correct? If yes, where would i find that file? i have looked everywhere so that i could link it correctly, but it's not on my system. Also, Mr.DeKok, please forgive me for asking questions that may seem simple to most people. I'm very new at this and Linux in general. I realize that you are a very intelligent man and being a programmer, you probably don't have the time to deal with newbies like me. Just know that your time is appreciated by me. Thank you again. - Original Message - From: Alan DeKok [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 30, 2004 12:59 PM Subject: Re: Mysql and Freeradius Linda Pagillo [EMAIL PROTECTED] wrote: ... Please edit your text so it's not all one run-on sentence. Arranging text neatly not only looks pretty, it ensures that the ideas are communicated clearly. When i edited my sql.conf and radiusd.conf files to use the Mysql, i received this error... Could not link driver rlm_sql_mysql: file not found as i stated previously in my last post. And there was a reply with a solution for you to implement. I researched this error and tried every solution given to me from other users, etc... it came to the point where i just uninstalled Freeradius completely and reconfigured it like this ./configure --disable-shared. then i tried to get it running in text file authentication mode once again. It installed correctly, and i edited my radiusd.conf, clients.conf and users files how i wanted them and then when i ran radiusd -x i kept getting errors for almost every module saying that entries were missing for all of these modules.. so i went through my radiusd.conf file and i commented out everytihng that had to do with these errors.. Which was a complete and total waste of your time. You should be configuring the server to use MySQL, not deleting everything else from the server. So then i went in and decided that i was going to try to setup the Mysql and see what happens. Well, i put an sql entry in the radiusd.conf file where i needed them and i edited my sql.conf file accordingly, but i got an error about the sql module entries being missing. It helps if you post the *actual* error message. We can't read your mind, and we can't read your terminal remotely. I could not find a way around this, so i went ahead and completely uninstalled Freeradius again. Which is again a complete and total waste of your time. It's not a Windows program, you don't need to re-install it if it hiccups. Now, this is where i'm at. Surely there are many people out there that have freeradius running with Mysql flawlessly. Can anyone give me exact directions on how i need to ./configure freeradius so that mysql works? My previous reply explains what you have to do to get FreeRADIUS to know about MySQL. Work on that stage first. Alan DeKok. - 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: Mysql and Freeradius
FreeRADIUS will find it: IF MYSQL EXISTS ON YOUR SYSTEM. I agree. It is very clear that the MySQL development package DOES NOT exist on your system. No amount of playing games with FreeRADIUS is going to install the MySQL development package. Stop playing with FreeRADIUS, it's not the problem. my guess is not on freeradius, MySQL mailling list to the rescue? Install the MySQL development RPM. Now. So what you're telling me is that i should have an actual file called rlm_sql_mysql, is that correct? if you are going to implement MySQL, ofcourse you do not need Oracle SQL or something Also, Mr.DeKok, please forgive me for asking questions that may seem simple to most people. I'm very new at this and Linux in general. I realize that you are a very intelligent man and being a programmer, you probably don't have the time to deal with newbies like me. Just know that your time is appreciated by me. Thank you again. google will lead you to lots of linux mailing list. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MySql and freeRadius
Can you send link to RPMS and will this work on redhat 9 ? I dont know but i supose yes, i use fedora core 1 Mysql and freeradius from the oroginal distribution: and sqlcounter from here: http://rpm.pbone.net/index.php3/stat/4/idpl/1061499/com/freeradius-sqlcounter-0.9.3-alt3.i586.rpm.html freeradius-mysql you can get it here: ALTLinux ftp.altlinux.ru/pub/distributions/ALTLinux/Sisyphus/files/i586/RPMS/freeradius-mysql-0.9.3-alt3.i586.rpm Mandrake Other carroll.cac.psu.edu/pub/linux/distributions/mandrake-devel/contrib/i586/freeradius-mysql-0.9.2-3mdk.i586.rpm Fedora Core 1 download.fedora.redhat.com/pub/fedora/linux/core/1/i386/os/Fedora/RPMS/freeradius-mysql-0.9.1-1.i386.rpm Fedora Other download.fedora.redhat.com/pub/fedora/linux/core/development/i386/Fedora/RPMS/freeradius-mysql-0.9.1-1.i386.rpm Mandrake 9.X carroll.cac.psu.edu/pub/linux/distributions/mandrake/9.1/contrib/i586/freeradius-mysql-0.8.1-1mdk.i586.rpm Juan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: MySql and freeRadius
snip Can you send link to RPMS and will this work on redhat 9 ? Thanks ! I use apt for rpm at apt.freshrpms.net 50 Radius installs later and not a hiccup. Jeremy - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySql and freeRadius
John Que escreveu: As I understand , I must install the sources of MySql if I want to use rlm_sql in freeRadius (and not install the rpm for mySql Server and client). Actually, you can install the -devel rpms and that will allow you to compile the rlm_sql_mysql module. This will make sure all the libraries and header files get to the right places. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: MySql and freeRadius
Now I might be popping off cause I don't know with certainty... but have a look at these things. Make sure you added the proper lines in /etc/ld.so.conf and run ldconfig to update your libraries after you install MySQL. Also many applications will require the addition of ./configure --with-mysql=/usr/local/mysql or wherever your mysql was installed. Just a few thoughts. good luck... JK On Wed, 24 Mar 2004 22:27:42 +0300 John Que [EMAIL PROTECTED] wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* Hello, I want to use MySql with freeRadius. I want to use rlm_sql_mysql I am developing on RedHat Linux 9. As I understand , I must install the sources of MySql if I want to use rlm_sql in freeRadius (and not install the rpm for mySql Server and client). Now, I had done so. And I had used the ordinary chain; ./configure make make install both for MySql and afterwards for freeRadius. Now , I had prepared and configured sql tables to be used by freeRadius. when I try to run ./freeRadius -X I get the following error rlm_sql: Could not link driver rlm_sql_mysql: file not found I had seen the 4.14 section of the FAQ of freeradius and I do not know what I did wrong. I have 2 questiions: 1) Is it ok to use the usual chain ./configure make make install when we want to use MySql with freeRadius ? or should I had some attribute to the configure ? (the thing is that I sea, in freeRadius tree, src\modules\rlm_sql\drivers\rlm_sql_mysql, in config.log , an error that it does not find mysql.h ; Any idea what can cause it?) 2) This error : rlm_sql: Could not link driver rlm_sql_mysql: file not found should the make of freeRadius create a file rlm_sql_mysql.so or lm_sql_mysql.o or lm_sql_mysql.a or something like it? Any help will be appreciated. regards, sting _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - 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: MySql and freeRadius
Hello List: I want to make sure I am installing freeRADIUS MySQL correctly. I installed (test installation) freeRADIUS (0.9.3) and MySQL 5.0.0 (?) from binaries on a RH9 machine. It tested fine. In the next couple of days, I am going to do a final installation of freeRADIUS MySQL (with InnoDB). Questions: == (1) with the above setup, what version of MySQL (binaries or rpm) should I use? (2) Do I still need a develoment package of MySQL to work with freeRADIUS? If YES, what version of MySQL? I am new to MySQL!! Kirti -Original Message- From: Keith Yoder [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 2:36 PM To: [EMAIL PROTECTED] Subject: Re: MySql and freeRadius John Que escreveu: As I understand , I must install the sources of MySql if I want to use rlm_sql in freeRadius (and not install the rpm for mySql Server and client). Actually, you can install the -devel rpms and that will allow you to compile the rlm_sql_mysql module. This will make sure all the libraries and header files get to the right places. - 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: MySql and freeRadius
I have a working instalation all with binary rpm, i didnt compile anything. all from freshrpms. freeradius, mysql, freeradius-mysql (i think this is the name i cant check now) and freerdius-sqlcounter (not for red hat, but i moved the files to the right place and it works) juan. Keith Yoder dijo: John Que escreveu: As I understand , I must install the sources of MySql if I want to use rlm_sql in freeRadius (and not install the rpm for mySql Server and client). Actually, you can install the -devel rpms and that will allow you to compile the rlm_sql_mysql module. This will make sure all the libraries and header files get to the right places. - 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: MySql and freeRadius
Can you send link to RPMS and will this work on redhat 9 ? Thanks ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Juan Pablo Fava Sent: Wednesday, March 24, 2004 3:48 PM To: [EMAIL PROTECTED] Subject: Re: MySql and freeRadius I have a working instalation all with binary rpm, i didnt compile anything. all from freshrpms. freeradius, mysql, freeradius-mysql (i think this is the name i cant check now) and freerdius-sqlcounter (not for red hat, but i moved the files to the right place and it works) juan. Keith Yoder dijo: John Que escreveu: As I understand , I must install the sources of MySql if I want to use rlm_sql in freeRadius (and not install the rpm for mySql Server and client). Actually, you can install the -devel rpms and that will allow you to compile the rlm_sql_mysql module. This will make sure all the libraries and header files get to the right places. - 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
