Need Help to Troubleshoot MySQL Auth FreeRadius 2.1.X
Dear Freeradius Hackers, This is new implementation. Can someone help me to troubleshoot why freeradius mysql authentication is failing. i have cross check every expect but still seem that something is not in place. What is i have done: installed Freeradius + MySQL Databases Configured Freeradius Created MySQL Database. configured the following files: sql.conf radiusd.conf default enabled in radiusd.conf to $INCLUDE = sql.conf Radius is up and running without authentication even from localhost. Radius database is setup properly, no problem to start/stop radiusd radios_log are shown in section below. Results: tail -f /var/log/radius/radius.log - Output Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Attempting to connect to radius@localhost:3306/radius Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 Sat Dec 15 11:20:34 2012 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0 Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Connected new DB handle, #0 Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 Sat Dec 15 11:20:34 2012 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1 Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Connected new DB handle, #1 Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 Sat Dec 15 11:20:34 2012 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2 Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Connected new DB handle, #2 Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 Sat Dec 15 11:20:34 2012 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3 Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Connected new DB handle, #3 Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 Sat Dec 15 11:20:34 2012 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4 Sat Dec 15 11:20:34 2012 : Info: rlm_sql (sql): Connected new DB handle, #4 Sat Dec 15 11:20:34 2012 : Info: Loaded virtual server default Sat Dec 15 11:20:34 2012 : Info: Loaded virtual server inner-tunnel Sat Dec 15 11:20:34 2012 : Info: ... adding new socket proxy address * port 32959 Sat Dec 15 11:20:34 2012 : Info: Ready to process requests. = Output of radiusd -X ... adding new socket proxy address * port 51412 Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on command file /var/run/radiusd/radiusd.sock Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel Listening on proxy address * port 1814 Ready to process requests. Command to Check the radius Authentication: radtest mark mypassword localhost 1812 99THi49UGotool Output: Sending Access-Request of id 48 to 41.171.71.61 port 1812 User-Name = mark User-Password = radmin NAS-IP-Address = 192.168.3.106 NAS-Port = 100 Message-Authenticator = 0x == Two MySQL Radius Users PAY attention to the field OP (:= ==) But auth is not working for any user. mysql select * from radcheck where UserName='mark'; ++--+---++-+ | id | UserName | Attribute | op | Value | ++--+---++-+ | 3 | mark | radmin| := | 99THi49UGotool | ++--+---++-+ 1 row in set (0.00 sec) mysql select * from radcheck where UserName='dany'; ++--+---++-+ | id | UserName | Attribute | op | Value | ++--+---++-+ | 1 | dany | badmin | == | 99THi49UGotool| ++--+---++-+ radius is up and running without authentication == or := make no difference none of the user can authenticate. selinux off freeradius is up mysql db is up there are two database users why auth would be failing? Any tip or clue would be greatly appreciated Thanks / Regards - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Need Help to Troubleshoot MySQL Auth FreeRadius 2.1.X
Prabhpal S. Mavi wrote: This is new implementation. Can someone help me to troubleshoot why freeradius mysql authentication is failing. i have cross check every expect but still seem that something is not in place. You haven't read the documentation which says to run the server in debugging mode. Results: tail -f /var/log/radius/radius.log - Output You WILL NOT solve the problem by doing this. The documentation DOES NOT say to do this, because it is NOT HELPFUL. Output of radiusd -X ... adding new socket proxy address * port 51412 Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on command file /var/run/radiusd/radiusd.sock Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel Listening on proxy address * port 1814 Ready to process requests. Which is completely and totally useless. You do realize that the ENTIRE POINT of running the server in debugging mode is to see what happens when it receives packets... Command to Check the radius Authentication: We don't care. The documentation doesn't say to post this command to the list, because it is NOT HELPFUL. PAY attention to the field OP (:= ==) But auth is not working for any user. No. YOU need to pay attention to the documentation. mysql select * from radcheck where UserName='mark'; ++--+---++-+ | id | UserName | Attribute | op | Value | ++--+---++-+ | 3 | mark | radmin| := | 99THi49UGotool | ++--+---++-+ This is completely wrong. It's hard to describe just how wrong this is. Read the Wiki. It has DETAILED INSTRUCTIONS for getting SQL working. It includes EXAMPLES. These examples WILL WORK. radius is up and running without authentication == or := make no difference none of the user can authenticate. Because you've done something completely wrong. Any tip or clue would be greatly appreciated Follow the instructions on the wiki for configuring SQL. It should take no more than 10 minutes. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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
MySQL and FreeRADIUS environment
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?) ... 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? 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? Then, when I have got radrelay.conf file with listen block information from copy-acct-to-home-server file, where I should to define the second server? I think that in some place I should to define the second server for make the replica... Can you help me? Can you tell me about that? Thank you. -- View this message in context: http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4872393.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
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, -- View this message in context: http://freeradius.1045715.n5.nabble.com/MySQL-and-FreeRADIUS-environment-tp4845985p4845985.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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 www.fabergames.com Fabergames respeta su privacidadhttp://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.
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: about simultaneous when using mysql and freeradius
Spacelee wrote: my nas client is pptp and ppp, how can i set pptp to send updates every 5 minutes? See the PPTP documentation. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: about simultaneous when using mysql and freeradius
my nas client is pptp and ppp, how can i set pptp to send updates every 5 minutes? On Tue, Jun 1, 2010 at 7:13 PM, Marinko Tarlac mangi...@gmail.com wrote: Here we go again 1. add datetime column at the end of radacct table (name it for example last_update_column) 2. edit queries in dialup.conf (for 2.x FR) or sql.conf (for 1.x FR) so every update will update this column to (for example update radacct set , last_update_column = NOW() ). Now you will have the correct time when was the last update for specific session. 3. write php, perl, shell or any other script which you can start with cron and check if there is any active sessions (acctstoptime = null or acctstoptime = 0) which last update was X minutes ago. For example, X can be 11 minutes and you can set up your NAS to send updates every 5 minutes. This means that you can have at least 2 updates before you close session with cron script. This is not the only way to solve this problem but it works with all FR version, and it doesn't depend on your NAS(es). Also, this isn't ideal solution because if your NAS goes off and on again before you received stop packets, all users will need to wait X minutes before they can connect again. (there are no updates so last_update_column will be unchanged and the cron script will close all sessions after X minutes) Spacelee wrote: sorry, does the radcheck.pl http://radcheck.pl included in freeradius now? does you mean /usr/sbin/checkrad ? and i search the keywords Simultaneous mysql radius down , but found no results i need. 2010/6/1 Anton w...@stack.ru mailto:w...@stack.ru It should be done by NAS. For example PPPoE and PPTP have lcp packets, If no response for some time from client to NAS then NAS decides that session is down and sends acct-stop packet to radius server. Radius server sets the corresponding record to SQL session table. Or there is another method: depending on NAS type radiusd can connect to NAS and check activity of user session directly on NAS - this is more reliable source of information. See radcheck.pl http://radcheck.pl. On Tue, 1 Jun 2010 16:24:54 +0700 Spacelee fjct...@gmail.com mailto:fjct...@gmail.com wrote: i want to limit user's behavior, such as a username can login only once at the same time... 1、modifiy default and inner-tunnel in # Session database, used for checking Simultaneous-Use. Either the radutmp # or rlm_sql module can handle this. # The rlm_sql module is *much* faster session { #radutmp # See Simultaneous Use Checking Querie in sql.conf sql } 2、modify dialup.conf in etc/raddb/sql/mysql # Uncomment simul_count_query to enable simultaneous use checking simul_count_query = SELECT COUNT(*) \ FROM ${acct_table1} \ WHERE username = '%{SQL-User-Name}' \ AND acctstoptime IS NULL 3、add a entry to the table radgorucheck INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` , `Value` ) VALUES ( NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’ ); 4. update the user test to the group user i finally tried successfully, but if , i say if the radius server was down suddenly or the user logout improperly(such as he poweroff the computer directly). then the record will still be record in the table as he was still online ...so we need to modify the record, but how to ? can freeradius judge it by itself, or how to judge the user if offline ? -- Spacelee -- Spacelee -- Anton [WARM-RIPE] Stack ltd division head tel. 8 (3822) 555-797 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Spacelee - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Spacelee - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
about simultaneous when using mysql and freeradius
i want to limit user's behavior, such as a username can login only once at the same time... 1、modifiy default and inner-tunnel in # Session database, used for checking Simultaneous-Use. Either the radutmp # or rlm_sql module can handle this. # The rlm_sql module is *much* faster session { #radutmp # See Simultaneous Use Checking Querie in sql.conf sql } 2、modify dialup.conf in etc/raddb/sql/mysql # Uncomment simul_count_query to enable simultaneous use checking simul_count_query = SELECT COUNT(*) \ FROM ${acct_table1} \ WHERE username = '%{SQL-User-Name}' \ AND acctstoptime IS NULL 3、add a entry to the table radgorucheck INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` , `Value` ) VALUES ( NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’ ); 4. update the user test to the group user i finally tried successfully, but if , i say if the radius server was down suddenly or the user logout improperly(such as he poweroff the computer directly). then the record will still be record in the table as he was still online ...so we need to modify the record, but how to ? can freeradius judge it by itself, or how to judge the user if offline ? -- Spacelee -- Spacelee - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: about simultaneous when using mysql and freeradius
I already wrote about this problem on this list. Please search before asking... Spacelee wrote: i want to limit user's behavior, such as a username can login only once at the same time... 1、modifiy default and inner-tunnel in # Session database, used for checking Simultaneous-Use. Either the radutmp # or rlm_sql module can handle this. # The rlm_sql module is *much* faster session { #radutmp # See Simultaneous Use Checking Querie in sql.conf sql } 2、modify dialup.conf in etc/raddb/sql/mysql # Uncomment simul_count_query to enable simultaneous use checking simul_count_query = SELECT COUNT(*) \ FROM ${acct_table1} \ WHERE username = '%{SQL-User-Name}' \ AND acctstoptime IS NULL 3、add a entry to the table radgorucheck INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` , `Value` ) VALUES ( NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’ ); 4. update the user test to the group user i finally tried successfully, but if , i say if the radius server was down suddenly or the user logout improperly(such as he poweroff the computer directly). then the record will still be record in the table as he was still online ...so we need to modify the record, but how to ? can freeradius judge it by itself, or how to judge the user if offline ? -- Spacelee -- Spacelee - 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: about simultaneous when using mysql and freeradius
It should be done by NAS. For example PPPoE and PPTP have lcp packets, If no response for some time from client to NAS then NAS decides that session is down and sends acct-stop packet to radius server. Radius server sets the corresponding record to SQL session table. Or there is another method: depending on NAS type radiusd can connect to NAS and check activity of user session directly on NAS - this is more reliable source of information. See radcheck.pl. On Tue, 1 Jun 2010 16:24:54 +0700 Spacelee fjct...@gmail.com wrote: i want to limit user's behavior, such as a username can login only once at the same time... 1、modifiy default and inner-tunnel in # Session database, used for checking Simultaneous-Use. Either the radutmp # or rlm_sql module can handle this. # The rlm_sql module is *much* faster session { #radutmp # See Simultaneous Use Checking Querie in sql.conf sql } 2、modify dialup.conf in etc/raddb/sql/mysql # Uncomment simul_count_query to enable simultaneous use checking simul_count_query = SELECT COUNT(*) \ FROM ${acct_table1} \ WHERE username = '%{SQL-User-Name}' \ AND acctstoptime IS NULL 3、add a entry to the table radgorucheck INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` , `Value` ) VALUES ( NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’ ); 4. update the user test to the group user i finally tried successfully, but if , i say if the radius server was down suddenly or the user logout improperly(such as he poweroff the computer directly). then the record will still be record in the table as he was still online ...so we need to modify the record, but how to ? can freeradius judge it by itself, or how to judge the user if offline ? -- Spacelee -- Spacelee -- Anton [WARM-RIPE] Stack ltd division head tel. 8 (3822) 555-797 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: about simultaneous when using mysql and freeradius
sorry, does the radcheck.pl included in freeradius now? does you mean /usr/sbin/checkrad ? and i search the keywords Simultaneous mysql radius down , but found no results i need. 2010/6/1 Anton w...@stack.ru It should be done by NAS. For example PPPoE and PPTP have lcp packets, If no response for some time from client to NAS then NAS decides that session is down and sends acct-stop packet to radius server. Radius server sets the corresponding record to SQL session table. Or there is another method: depending on NAS type radiusd can connect to NAS and check activity of user session directly on NAS - this is more reliable source of information. See radcheck.pl. On Tue, 1 Jun 2010 16:24:54 +0700 Spacelee fjct...@gmail.com wrote: i want to limit user's behavior, such as a username can login only once at the same time... 1、modifiy default and inner-tunnel in # Session database, used for checking Simultaneous-Use. Either the radutmp # or rlm_sql module can handle this. # The rlm_sql module is *much* faster session { #radutmp # See Simultaneous Use Checking Querie in sql.conf sql } 2、modify dialup.conf in etc/raddb/sql/mysql # Uncomment simul_count_query to enable simultaneous use checking simul_count_query = SELECT COUNT(*) \ FROM ${acct_table1} \ WHERE username = '%{SQL-User-Name}' \ AND acctstoptime IS NULL 3、add a entry to the table radgorucheck INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` , `Value` ) VALUES ( NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’ ); 4. update the user test to the group user i finally tried successfully, but if , i say if the radius server was down suddenly or the user logout improperly(such as he poweroff the computer directly). then the record will still be record in the table as he was still online ...so we need to modify the record, but how to ? can freeradius judge it by itself, or how to judge the user if offline ? -- Spacelee -- Spacelee -- Anton [WARM-RIPE] Stack ltd division head tel. 8 (3822) 555-797 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Spacelee - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: about simultaneous when using mysql and freeradius
Yes, this is /usr/sbin/checkrad. Sorry for mistake. You should read this script ... Radiusd can be down or unrichable or packet can be loss. If You have NAS one of this type You can specify this type in clients.conf (nastype = cisco). After than radiusd should use /usr/sbin/checkrad to check simultaneous logins. But if You have a situation when NAS has opened working session and radiusd has no records about it in session table You can get double login. AFAIK in this case radiusd will not do simultaneous check at all. But it should not happen -- when radiusd goes down suddenly the records in SQL session table should be stay like opened sessions. And after radiusd starts again it thinks that that sessions are active :-), in this case radiusd will use checkrad if nastype is configured to check his SQL records. Moreover if You will connect simultaneously very fast (faster then Your SQL can handle queries) and without using checkrad then You will get simultaneous logins too. This is because there is no any transaction is SQL schema or no other method to make single unique login attempt in a time for SQL can see them like separate tries. On Tue, 1 Jun 2010 17:21:26 +0700 Spacelee fjct...@gmail.com wrote: sorry, does the radcheck.pl included in freeradius now? does you mean /usr/sbin/checkrad ? and i search the keywords Simultaneous mysql radius down , but found no results i need. 2010/6/1 Anton w...@stack.rumailto:w...@stack.ru It should be done by NAS. For example PPPoE and PPTP have lcp packets, If no response for some time from client to NAS then NAS decides that session is down and sends acct-stop packet to radius server. Radius server sets the corresponding record to SQL session table. Or there is another method: depending on NAS type radiusd can connect to NAS and check activity of user session directly on NAS - this is more reliable source of information. See radcheck.plhttp://radcheck.pl. On Tue, 1 Jun 2010 16:24:54 +0700 Spacelee fjct...@gmail.commailto:fjct...@gmail.com wrote: i want to limit user's behavior, such as a username can login only once at the same time... 1、modifiy default and inner-tunnel in # Session database, used for checking Simultaneous-Use. Either the radutmp # or rlm_sql module can handle this. # The rlm_sql module is *much* faster session { #radutmp # See Simultaneous Use Checking Querie in sql.conf sql } 2、modify dialup.conf in etc/raddb/sql/mysql # Uncomment simul_count_query to enable simultaneous use checking simul_count_query = SELECT COUNT(*) \ FROM ${acct_table1} \ WHERE username = '%{SQL-User-Name}' \ AND acctstoptime IS NULL 3、add a entry to the table radgorucheck INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` , `Value` ) VALUES ( NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’ ); 4. update the user test to the group user i finally tried successfully, but if , i say if the radius server was down suddenly or the user logout improperly(such as he poweroff the computer directly). then the record will still be record in the table as he was still online ...so we need to modify the record, but how to ? can freeradius judge it by itself, or how to judge the user if offline ? -- Spacelee -- Spacelee -- Anton [WARM-RIPE] Stack ltd division head tel. 8 (3822) 555-797 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Spacelee -- Anton [WARM-RIPE] Stack ltd division head tel. 8 (3822) 555-797 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: about simultaneous when using mysql and freeradius
Here we go again 1. add datetime column at the end of radacct table (name it for example last_update_column) 2. edit queries in dialup.conf (for 2.x FR) or sql.conf (for 1.x FR) so every update will update this column to (for example update radacct set , last_update_column = NOW() ). Now you will have the correct time when was the last update for specific session. 3. write php, perl, shell or any other script which you can start with cron and check if there is any active sessions (acctstoptime = null or acctstoptime = 0) which last update was X minutes ago. For example, X can be 11 minutes and you can set up your NAS to send updates every 5 minutes. This means that you can have at least 2 updates before you close session with cron script. This is not the only way to solve this problem but it works with all FR version, and it doesn't depend on your NAS(es). Also, this isn't ideal solution because if your NAS goes off and on again before you received stop packets, all users will need to wait X minutes before they can connect again. (there are no updates so last_update_column will be unchanged and the cron script will close all sessions after X minutes) Spacelee wrote: sorry, does the radcheck.pl http://radcheck.pl included in freeradius now? does you mean /usr/sbin/checkrad ? and i search the keywords Simultaneous mysql radius down , but found no results i need. 2010/6/1 Anton w...@stack.ru mailto:w...@stack.ru It should be done by NAS. For example PPPoE and PPTP have lcp packets, If no response for some time from client to NAS then NAS decides that session is down and sends acct-stop packet to radius server. Radius server sets the corresponding record to SQL session table. Or there is another method: depending on NAS type radiusd can connect to NAS and check activity of user session directly on NAS - this is more reliable source of information. See radcheck.pl http://radcheck.pl. On Tue, 1 Jun 2010 16:24:54 +0700 Spacelee fjct...@gmail.com mailto:fjct...@gmail.com wrote: i want to limit user's behavior, such as a username can login only once at the same time... 1、modifiy default and inner-tunnel in # Session database, used for checking Simultaneous-Use. Either the radutmp # or rlm_sql module can handle this. # The rlm_sql module is *much* faster session { #radutmp # See Simultaneous Use Checking Querie in sql.conf sql } 2、modify dialup.conf in etc/raddb/sql/mysql # Uncomment simul_count_query to enable simultaneous use checking simul_count_query = SELECT COUNT(*) \ FROM ${acct_table1} \ WHERE username = '%{SQL-User-Name}' \ AND acctstoptime IS NULL 3、add a entry to the table radgorucheck INSERT INTO `radgroupcheck` ( `id` , `GroupName` , `Attribute` , `op` , `Value` ) VALUES ( NULL , ’user’, ’Simultaneous-Use’, ’:=’, ’1’ ); 4. update the user test to the group user i finally tried successfully, but if , i say if the radius server was down suddenly or the user logout improperly(such as he poweroff the computer directly). then the record will still be record in the table as he was still online ...so we need to modify the record, but how to ? can freeradius judge it by itself, or how to judge the user if offline ? -- Spacelee -- Spacelee -- Anton [WARM-RIPE] Stack ltd division head tel. 8 (3822) 555-797 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- Spacelee - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
problems with queries and user database in mysql and freeradius
Hi all, I'm trying to manage the users in freeradius with mysql. Users can log in wireless network successfully but I get 2 problems. 1. Only post-authenticate query's implemented to insert information to radpostauth table in radius database. Accouting queries for accounting table in database're not implemented. 2. When I only use sql to manage users, I totally dont configure in users file of freeradius, users cant login to network. I hope someones will help me solve these problems. Here my out put from radiusd -X command: rad_recv: Access-Request packet from host 192.168.0.2 port 1024, id=141, length=145 User-Name = hung NAS-IP-Address = 192.168.0.2 NAS-Port = 0 Called-Station-Id = 00-1E-E5-9B-9A-FE:LCK Calling-Station-Id = 00-17-C4-8C-2C-C8 Framed-MTU = 1400 NAS-Port-Type = Wireless-802.11 Connect-Info = CONNECT 11Mbps 802.11b EAP-Message = 0x02090168756e67 Message-Authenticator = 0x92a2c1dd019f55542bef82c3b6b122b9 +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop [eap] EAP packet type response id 0 length 9 [eap] No EAP Start, assuming it's an on-going EAP conversation ++[eap] returns updated ++[unix] returns notfound [files] users: Matched entry hung at line 91 ++[files] returns ok [sql] expand: %{Stripped-User-Name} - [sql] expand: %{User-Name} - hung [sql] expand: %{%{User-Name}:-DEFAULT} - hung [sql] expand: %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} - hung [sql] sql_set_user escaped user -- 'hung' rlm_sql (sql): Reserving sql socket id: 4 [sql] expand: SELECT id, username, attribute, op, value FROM radcheck WHERE username = '%{SQL-User-Name}'ORDER BY id - SELECT id, username, attribute, op, value FROM radcheck WHERE username = 'hung'ORDER BY id [sql] expand: SELECT groupname FROM usergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority - SELECT groupname FROM usergroup WHERE username = 'hung' ORDER BY priority [sql] expand: SELECT id, groupname, attribute,op, Value FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id - SELECT id, groupname, attribute,op, Value FROM radgroupcheck WHERE groupname = 'WLANgroup' ORDER BY id [sql] User found in group WLANgroup [sql] expand: SELECT id, groupname, attribute,op, Value FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id - SELECT id, groupname, attribute,op, Value FROM radgroupreply WHERE groupname = 'WLANgroup' ORDER BY id rlm_sql (sql): Released sql socket id: 4 ++[sql] returns ok ++[expiration] returns noop ++[logintime] returns noop [pap] Found existing Auth-Type, not changing it. ++[pap] returns noop Found Auth-Type = EAP +- entering group authenticate {...} [eap] EAP Identity [eap] processing type tls [tls] Initiate [tls] Start returned 1 ++[eap] returns handled Sending Access-Challenge of id 141 to 192.168.0.2 port 1024 EAP-Message = 0x010100061520 Message-Authenticator = 0x State = 0x09945ffc09954a3c3aef342532c8f473 Finished request 0. Going to the next request Waking up in 4.9 seconds. rad_recv: Access-Request packet from host 192.168.0.2 port 1024, id=141, length=145 Sending duplicate reply to client localhost port 1024 - ID: 141 Sending Access-Challenge of id 141 to 192.168.0.2 port 1024 Waking up in 4.9 seconds. rad_recv: Access-Request packet from host 192.168.0.2 port 1024, id=142, length=160 User-Name = hung NAS-IP-Address = 192.168.0.2 NAS-Port = 0 Called-Station-Id = 00-1E-E5-9B-9A-FE:LCK Calling-Station-Id = 00-17-C4-8C-2C-C8 Framed-MTU = 1400 NAS-Port-Type = Wireless-802.11 Connect-Info = CONNECT 11Mbps 802.11b EAP-Message = 0x020100060319 State = 0x09945ffc09954a3c3aef342532c8f473 Message-Authenticator = 0x560713ad902723d908cff078aab76337 +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop [eap] EAP packet type response id 1 length 6 [eap] No EAP Start, assuming it's an on-going EAP conversation ++[eap] returns updated ++[unix] returns notfound [files] users: Matched entry hung at line 91 ++[files] returns ok [sql] expand: %{Stripped-User-Name} - [sql] expand: %{User-Name} - hung [sql] expand: %{%{User-Name}:-DEFAULT} - hung [sql] expand: %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} - hung [sql] sql_set_user escaped user -- 'hung' rlm_sql (sql): Reserving sql socket id: 3 [sql] expand: SELECT id, username, attribute, op, value FROM radcheck WHERE username = '%{SQL-User-Name}'ORDER BY id - SELECT id, username, attribute, op, value FROM radcheck WHERE username = 'hung
Freeradius AND Mysql ? or Freeradius-mysql package??? or both?
Dear all: i have installed debian, mysql server 5.0 (by aptitude install) and freeradius-server-2.1.7 by wget and untar -xvfz , manually. i have no errors on freeradius run. i have a 3com RAS with PPP and PPPoE users, i would like to put my debian-freeradius as a Radius for them (AAA). Question is: it is necessary install freeradius-mysql package? if yes, then: must i install freeradius-mysql as a repository package (aptitude install freeradius-mysql) ? or it's not recommended this way? Its better do it by downloading and untar manually ? there is no problem if i aptitude install freeradius-mysql with my actual freeradius version? thanks sorry my poor english. Carlos - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius AND Mysql ? or Freeradius-mysql package??? or both?
i have installed debian, mysql server 5.0 (by aptitude install) and freeradius-server-2.1.7 by wget and untar -xvfz , manually. Question is: it is necessary install freeradius-mysql package? If you installed freeradius from source - no. Source has complete server. But it is dependany on development headers. Ivan Kalik - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
MySql on Freeradius
Hello everyone! I have succeeded in most what i want to accomplice but stupid me forgot that I would also want to be able to administrate the users through a GUI instead of jump into the users.conf file everytime i need to add a new user. 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. The guides I have read is all about installing with the help of synaptic package manager in ubuntu 9.04 and install freeradius-mysql. A question I have is if that module comes with the build I make when im downloading from Freeradius site? If not do I need it to be able to get mysql work together with freeradius and if I do need it, how can I do a separate installation of it? Or can I use the one I find in Ubuntu´s Synaptic Package Manager? Lots of questions I know, hope you can find the time to answer them. Best regards/ Peter _ Windows Live: Keep your friends up to date with what you do online. http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_1:092010- 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
Using MySQL with FreeRADIUS.
Hello list, Can anyone help me with this. From what I gather, radcheck and radreply tables are sufficient to get an Access-Accept packet? Is there a way for radiusd to *not* check the radgroupcheck? Below is the output of radtest, my radcheck and radreply tables, and the output of radiusd -X. All help will be greatly appreciated. Best regards, Twanny. [EMAIL PROTECTED] ~]# /usr/bin/radtest barney betty localhost 1812 testing123 Sending Access-Request of id 136 to 127.0.0.1 port 1812 User-Name = barney User-Password = betty NAS-IP-Address = 255.255.255.255 NAS-Port = 1812 rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=136, length=20 [EMAIL PROTECTED] ~]# --- mysql select * from radcheck; +++---+++ | id | UserName | Attribute | op | Value | +++---+++ | 1 | fredf | password | == | wilma | | 2 | barney | password | == | betty | | 3 | dialrouter | password | == | dialup | +++---+++ 3 rows in set (0.00 sec) mysql select * from radreply; +++---++-+ | id | UserName | Attribute | op | Value | +++---++-+ | 1 | barney | Framed-IP-Address | := | 1.2.3.4 | | 2 | dialrouter | Framed-IP-Address | := | 2.3.4.1 | | 3 | dialrouter | Framed-IP-Netmask | := | 255.255.255.255 | | 4 | dialrouter | Framed-Routing| := | Broadcast-Listen| | 5 | dialrouter | Framed-Route | := | 2.3.4.0 255.255.255.248 | | 6 | dialrouter | Idle-Timeout | := | 900 | +++---++-+ 6 rows in set (0.00 sec) --- Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /etc/raddb/clients.conf Config: including file: /etc/raddb/snmp.conf Config: including file: /etc/raddb/eap.conf Config: including file: /etc/raddb/sql.conf main: prefix = /usr main: localstatedir = /var main: logdir = /var/log/radius main: libdir = /usr/lib main: radacctdir = /var/log/radius/radacct main: hostname_lookups = no main: snmp = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = /var/log/radius/radius.log main: log_auth = no main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = /var/run/radiusd/radiusd.pid main: user = radiusd main: group = shadow main: usercollide = no main: lower_user = no main: lower_pass = no main: nospace_user = no main: nospace_pass = no main: checkrad = /usr/sbin/checkrad main: proxy_requests = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients Using deprecated clients file. Support for this will go away soon. read_config_files: reading realms radiusd: entering modules setup Module: Library search path is /usr/lib Module: Loaded exec exec: wait = yes exec: program = (null) exec: input_pairs = request exec: output_pairs = (null) exec: packet_type = (null) rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = crypt Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: with_ntdomain_hack = no mschap: passwd = (null) mschap: ntlm_auth = (null) Module: Instantiated mschap (mschap) Module: Loaded System unix: cache = no unix: passwd = /etc/passwd unix: shadow = /etc/shadow unix: group = /etc/group unix: radwtmp = /var/log/radius/radwtmp unix: usegroup = no unix: cache_reload = 600 Module: Instantiated unix (unix) Module: Loaded eap eap: default_eap_type = md5 eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = Password: gtc: auth_type = PAP rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = /etc/raddb/huntgroups preprocess: hints = /etc/raddb/hints preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess:
Re: Using MySQL with FreeRADIUS.
Can anyone help me with this. From what I gather, radcheck and radreply tables are sufficient to get an Access-Accept packet? Is there a way for radiusd to *not* check the radgroupcheck? Below is the output of radtest, my radcheck and radreply tables, and the output of radiusd -X. All help will be greatly appreciated. sql is not the problem. .. users: Matched entry DEFAULT at line 152 modcall[authorize]: module files returns ok for request 0 .. 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 modcall: leaving group authenticate (returns notfound) for request 0 auth: Failed to validate the user. You are using an outdated version of the server (why?) that has DEFAULT entry in users file setting Auth-Type System. Comment out this entry. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Using MySQL with FreeRADIUS.
OK! Thanks Ivan, using version 1.1.3 which comes with CentOS for now. Best regards,Twanny Azzopardi.+356 79713618. To: freeradius-users@lists.freeradius.org Subject: Re: Using MySQL with FreeRADIUS. Date: Wed, 17 Sep 2008 12:32:15 +0100 From: [EMAIL PROTECTED] Can anyone help me with this. From what I gather, radcheck and radreply tables are sufficient to get an Access-Accept packet? Is there a way for radiusd to *not* check the radgroupcheck? Below is the output of radtest, my radcheck and radreply tables, and the output of radiusd -X. All help will be greatly appreciated. sql is not the problem. .. users: Matched entry DEFAULT at line 152 modcall[authorize]: module files returns ok for request 0 .. 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 modcall: leaving group authenticate (returns notfound) for request 0 auth: Failed to validate the user. You are using an outdated version of the server (why?) that has DEFAULT entry in users file setting Auth-Type System. Comment out this entry. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html _ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
help in basic configuration in connection mysql with freeradius
hi, I am trying to use mysql database with free radius 2.0.0 for the first time. I am using centOS 4.5 and mysql 4.1.2.The authentication works fine if I am using the unix username and password. I modified some configurations in radiusd.conf and sql.conf but it doesn't work. Please tell me the most basic steps to configure freeradius with mysql. Here is the log file while running in debugging mode: [EMAIL PROTECTED] ~]# radiusd -X FreeRADIUS Version 2.0.0, for host i686-pc-linux-gnu, built on Jan 29 2008 at 12:25:11 Copyright (C) 1999-2008 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License. Starting - reading configuration files ... including configuration file /usr/local/etc/raddb/radiusd.conf including configuration file /usr/local/etc/raddb/proxy.conf including configuration file /usr/local/etc/raddb/clients.conf including configuration file /usr/local/etc/raddb/snmp.conf including configuration file /usr/local/etc/raddb/eap.conf including configuration file /usr/local/etc/raddb/sql.conf including configuration file /usr/local/etc/raddb/sql/mysql/dialup.conf including configuration file /usr/local/etc/raddb/sql/mysql/counter.conf including configuration file /usr/local/etc/raddb/policy.conf including files in directory /usr/local/etc/raddb/sites-enabled/ including configuration file /usr/local/etc/raddb/sites-enabled/default including dictionary file /usr/local/etc/raddb/dictionary main { prefix = /usr/local localstatedir = /usr/local/var logdir = /usr/local/var/log/radius libdir = /usr/local/lib radacctdir = /usr/local/var/log/radius/radacct hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 allow_core_dumps = no pidfile = /usr/local/var/run/radiusd/radiusd.pid user = root checkrad = /usr/local/sbin/checkrad debug_level = 0 proxy_requests = no log { syslog_facility = daemon stripped_names = no file = /usr/local/var/log/radius/radius.log auth = yes auth_badpass = yes auth_goodpass = no } security { max_attributes = 200 reject_delay = 1 status_server = yes } } client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = johnson123 nastype = other } radiusd: Loading Realms and Home Servers proxy server { retry_delay = 5 retry_count = 3 default_fallback = no dead_time = 120 wake_all_if_all_dead = no } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = auth secret = johnson123 response_window = 20 max_outstanding = 65536 zombie_period = 40 status_check = status-server ping_check = none ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 num_pings_to_alive = 3 revive_interval = 120 status_check_timeout = 4 } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: Instantiating modules instantiate { Module: Linked to module rlm_exec Module: Instantiating exec exec { wait = yes input_pairs = request shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating expr Module: Linked to module rlm_expiration Module: Instantiating expiration expiration { reply-message = Password Has Expired } Module: Linked to module rlm_logintime Module: Instantiating logintime logintime { reply-message = You are calling outside your allowed timespan minimum-timeout = 60 } } radiusd: Loading Virtual Servers server { modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating pap pap { encryption_scheme = auto auto_header = no } Module: Linked to module rlm_chap Module: Instantiating chap Module: Linked to module rlm_mschap Module: Instantiating mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no } Module: Linked to module rlm_unix Module: Instantiating unix unix { radwtmp = NULL } Module: Linked to module rlm_eap Module: Instantiating eap eap { default_eap_type = md5 timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no } Module: Linked to sub-module rlm_eap_md5 Module: Instantiating eap-md5 Module: Linked to sub-module rlm_eap_leap Module: Instantiating eap-leap Module: Linked to sub
Re: help in basic configuration in connection mysql with freeradius
On Friday 08 February 2008 16:18:25 johnson elangbam wrote: hi, I am trying to use mysql database with free radius 2.0.0 for the first time. I am using centOS 4.5 and mysql 4.1.2.The authentication works fine if I am using the unix username and password. I modified some configurations in radiusd.conf and sql.conf but it doesn't work. Please tell me the most basic steps to configure freeradius with mysql. http://wiki.freeradius.org/SQL_HOWTO -- Iñaki Baz Castillo [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: help in basic configuration in connection mysql with freeradius
johnson elangbam wrote: hi, I am trying to use mysql database with free radius 2.0.0 for the first time. I am using centOS 4.5 and mysql 4.1.2.The authentication works fine if I am using the unix username and password. I modified some configurations in radiusd.conf and sql.conf but it doesn't work. Please tell me the most basic steps to configure freeradius with mysql. Here is the log file while running in debugging mode: Which contains nothing about SQL. You need to un-comment the uses of SQL in the configuration files. See radiusd.conf, sites-enabled/default, etc. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: help in basic configuration in connection mysql with freeradius
Hi, hi, I am trying to use mysql database with free radius 2.0.0 for the first time. I am using centOS 4.5 and mysql 4.1.2.The authentication works fine if I am using the unix username and password. I modified some configurations in radiusd.conf and sql.conf but it doesn't work. Please tell me the most basic steps to configure freeradius with mysql. Here is the log file while running in debugging mode: home-built with no sign of SQL activity in the log file. so. did the server build with mysql support? what errors were thrown during the ./configure stage? eg ./configure --with-whatever-arguments | grep WARNING you will need mysql-devel package installed to build mysql support into the system alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
need help in using mySql for freeRadius server.
hi, I am a new user in free radius with mysql, i've configure all the necessary .config files (viz., sql.conf and radiusd.conf) of the free radius for connecting to the mysql, but i wouldn't be able to connect to mysql database. Please tell me how to check that my free radius server is already connected to mysql and when i used the Unix username and password it receives access-accept packets. I've tried http://wiki.freeradius.org/SQL_HOWTO also but the instructions given there is slightly different from the one I am using. I am using free radius 2.0.0. Please help me in configuring this to connect to mysql. with regards Elangbam Johnson - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: need help in using mySql for freeRadius server.
johnson elangbam wrote: hi, I am a new user in free radius with mysql, i've configure all the necessary .config files (viz., sql.conf and radiusd.conf) of the free radius for connecting to the mysql, but i wouldn't be able to connect to mysql database. And the debug log says... ? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
need help in using mySql for freeRadius server.
hi, I am a new user in free radius with mysql, i've configure all the necessary .config files (viz., sql.conf and radiusd.conf) of the free radius for connecting to the mysql, but i wouldn't be able to connect to mysql database. Please tell me how to check that my free radius server is already connected to mysql and when i used the Unix username and password it receives access-accept packets. I've tried http://wiki.freeradius.org/SQL_HOWTO also but the instructions given there is slightly different from the one I am using. I am using free radius 2.0.0. Please help me in configuring this to connect to mysql. the debug log display like this Ready to process requests. rad_recv: Access-Request packet from host 127.0.0.1 port 32771, id=218, length=56 User-Name = john User-Password = radpass NAS-IP-Address = 192.168.1.227 NAS-Port = 0 +- entering group authorize ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop ++[unix] returns updated rlm_realm: No '@' in User-Name = john, looking up realm NULL rlm_realm: No such realm NULL ++[suffix] returns noop rlm_eap: No EAP-Message, not doing EAP ++[eap] returns noop ++[files] returns noop ++[expiration] returns noop ++[logintime] returns noop ++[pap] returns updated rad_check_password: Found Auth-Type auth: type PAP +- entering group PAP rlm_pap: login attempt with password radpass rlm_pap: Using CRYPT encryption. rlm_pap: Passwords don't match ++[pap] returns reject auth: Failed to validate the user. Found Post-Auth-Type Reject +- entering group REJECT expand: %{User-Name} - john attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 218 to 127.0.0.1 port 32771 Waking up in 4.9 seconds. Cleaning up request 0 ID 218 with timestamp +34 Ready to process requests. with regards Elangbam Johnson - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: need help in using mySql for freeRadius server.
Have you uncommented sql entries in radiusd.conf? Debug of the server startup (the bit that comes before the posted debug) would be more informative about what's configured (and what's not). Ivan Kalik Kalik Informatika ISP Dana 6/2/2008, johnson elangbam [EMAIL PROTECTED] piše: hi, I am a new user in free radius with mysql, i've configure all the necessary .config files (viz., sql.conf and radiusd.conf) of the free radius for connecting to the mysql, but i wouldn't be able to connect to mysql database. Please tell me how to check that my free radius server is already connected to mysql and when i used the Unix username and password it receives access-accept packets. I've tried http://wiki.freeradius.org/SQL_HOWTO also but the instructions given there is slightly different from the one I am using. I am using free radius 2.0.0. Please help me in configuring this to connect to mysql. the debug log display like this Ready to process requests. rad_recv: Access-Request packet from host 127.0.0.1 port 32771, id=218, length=56 User-Name = john User-Password = radpass NAS-IP-Address = 192.168.1.227 NAS-Port = 0 +- entering group authorize ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop ++[unix] returns updated rlm_realm: No '@' in User-Name = john, looking up realm NULL rlm_realm: No such realm NULL ++[suffix] returns noop rlm_eap: No EAP-Message, not doing EAP ++[eap] returns noop ++[files] returns noop ++[expiration] returns noop ++[logintime] returns noop ++[pap] returns updated rad_check_password: Found Auth-Type auth: type PAP +- entering group PAP rlm_pap: login attempt with password radpass rlm_pap: Using CRYPT encryption. rlm_pap: Passwords don't match ++[pap] returns reject auth: Failed to validate the user. Found Post-Auth-Type Reject +- entering group REJECT expand: %{User-Name} - john attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 218 to 127.0.0.1 port 32771 Waking up in 4.9 seconds. Cleaning up request 0 ID 218 with timestamp +34 Ready to process requests. with regards Elangbam Johnson - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: need help in using mySql for freeRadius server.
Hi, you are using 2.0.0 ... they output you posted is not complete... Ready to process requests. ...which is the LAST line of output before the server is ready - the output before gives us a lot of information. can you connect to the mysql database from the command line using the credentials you have supplied FR ? ie mysql -u username -p database also, is the box running eg 'selinux' - if so, the config for selinux will need to be updated/changed so that the process can talk to each other. just disable selinux (and reboot) or set it to permissive mode with error/warn logging to check this alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
need help in using mySql for freeRadius server.
hi, I am a new user in free radius with mysql, i've configure all the necessary .config files (viz., sql.conf and radiusd.conf) of the free radius for connecting to the mysql, but i wouldn't be able to connect to mysql database. Please tell me how to check that my free radius server is already connected to mysql and when i used the Unix username and password it receives access-accept packets. I've tried http://wiki.freeradius.org/SQL_HOWTO also but the instructions given there is slightly different from the one I am using. I am using free radius 2.0.0. Please help me in configuring this to connect to mysql. Debug of the server startup display like this [EMAIL PROTECTED] etc]# radiusd -X FreeRADIUS Version 2.0.0, for host i686-pc-linux-gnu, built on Jan 29 2008 at 12:25:11 Copyright (C) 1999-2008 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License. Starting - reading configuration files ... including configuration file /usr/local/etc/raddb/radiusd.conf including configuration file /usr/local/etc/raddb/proxy.conf including configuration file /usr/local/etc/raddb/clients.conf including configuration file /usr/local/etc/raddb/snmp.conf including configuration file /usr/local/etc/raddb/eap.conf including configuration file /usr/local/etc/raddb/sql.conf including configuration file /usr/local/etc/raddb/sql/mysql/dialup.conf including configuration file /usr/local/etc/raddb/sql/mysql/counter.conf including configuration file /usr/local/etc/raddb/policy.conf including files in directory /usr/local/etc/raddb/sites-enabled/ including configuration file /usr/local/etc/raddb/sites-enabled/default including dictionary file /usr/local/etc/raddb/dictionary main { prefix = /usr/local localstatedir = /usr/local/var logdir = /usr/local/var/log/radius libdir = /usr/local/lib radacctdir = /usr/local/var/log/radius/radacct hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 allow_core_dumps = no pidfile = /usr/local/var/run/radiusd/radiusd.pid checkrad = /usr/local/sbin/checkrad debug_level = 0 proxy_requests = yes log { syslog_facility = daemon stripped_names = no file = /usr/local/var/log/radius/radius.log auth = no auth_badpass = no auth_goodpass = no } security { max_attributes = 200 reject_delay = 1 status_server = yes } } client localhost { ipaddr = 127.0.0.1 require_message_authenticator = no secret = johnson123 nastype = other } radiusd: Loading Realms and Home Servers proxy server { retry_delay = 5 retry_count = 3 default_fallback = no dead_time = 120 wake_all_if_all_dead = no } home_server localhost { ipaddr = 127.0.0.1 port = 1812 type = auth secret = johnson123 response_window = 20 max_outstanding = 65536 zombie_period = 40 status_check = status-server ping_check = none ping_interval = 30 check_interval = 30 num_answers_to_alive = 3 num_pings_to_alive = 3 revive_interval = 120 status_check_timeout = 4 } home_server_pool my_auth_failover { type = fail-over home_server = localhost } realm example.com { auth_pool = my_auth_failover } realm LOCAL { } radiusd: Instantiating modules instantiate { Module: Linked to module rlm_exec Module: Instantiating exec exec { wait = yes input_pairs = request shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating expr Module: Linked to module rlm_expiration Module: Instantiating expiration expiration { reply-message = Password Has Expired } Module: Linked to module rlm_logintime Module: Instantiating logintime logintime { reply-message = You are calling outside your allowed timespan minimum-timeout = 60 } } radiusd: Loading Virtual Servers server { modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating pap pap { encryption_scheme = auto auto_header = no } Module: Linked to module rlm_chap Module: Instantiating chap Module: Linked to module rlm_mschap Module: Instantiating mschap mschap { use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no } Module: Linked to module rlm_unix Module: Instantiating unix unix { radwtmp = NULL } Module: Linked to module rlm_eap Module: Instantiating eap eap { default_eap_type = md5 timer_expire = 60
Freeradius-mysql and freeradius 1.1.5
Hi, i have installed freeradius 1.1.5 on debian machine now how i can install freeradius-mysql package? When i try 'apt-get install freeradius-mysql' this is the error: Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: freeradius-mysql Depends: freeradius(= 1.0.2-4sarge3) but 1.1.3 is to be installed E: Broken packages Help i can't use mysql 5 database with freeradius in this situation. i need freeradius-mysql. Andrea -- Leggi GRATIS le tue mail con il telefonino i-mode di Wind http://i-mode.wind.it - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius-mysql and freeradius 1.1.5
On 3/19/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, i have installed freeradius 1.1.5 on debian machine now how i can install freeradius-mysql package? freeradius-mysql Depends: freeradius(= 1.0.2-4sarge3) but 1.1.3 is to be installed E: Broken packages That is a distribution-specific problem of debian not a general freeradius one. So just as few hints: Current version in stable is 1.0.2-4sarge3. So wherever you got 1.1.5 from, would be the place to search for the pertinent freeradius-mysql (it would/should stem from the same source package). Under normal circumstances you cannot/should not mix interdependent packages from different sources. That leads to conflicting dependencies as you are told by apt-get. Those are there for a reason. hth K. Hoercher - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Problems with mysql and freeradius
Hi, I am starting the freeradius with my mysql server and I noticed this erro: rlm_sql_mysql: Mysql error 'Host 'mysql1.wireless.intranet' is not allowed to connect to this MySQL server' But I already give the privileges to my user radius and add the server mysql1.wireless.intranet to my list of hosts knowed. I use linux Debian and mysql 5.0.33 and the both are in the same machine, but they have different ip adress. In the freeradius/sql.conf file I configured this: sql { # Database type # Current supported are: rlm_sql_mysql, rlm_sql_postgresql, # rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc, rlm_sql_freetds driver = rlm_sql_mysql # Connect info server = mysql1.wireless.intranet # server = localhost login = radius password = radius_password #login = root # password = mysql_password # Database table configuration radius_db = radius # If you want both stop and start records logged to the # same SQL table, leave this as is. If you want them in # different tables, put the start table in acct_table1 # and stop table in acct_table2 acct_table1 = radacct acct_table2 = radacct Someone can help me? Thanks a lot, Marilene This the result of freeradius: freeradius -x Starting - reading configuration files ... Using deprecated naslist file. Support for this will go away soon. Module: Loaded exec rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP Module: Instantiated mschap (mschap) Module: Loaded System Module: Instantiated unix (unix) Module: Loaded eap rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap rlm_eap: Loaded and initialized type gtc rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess Module: Instantiated preprocess (preprocess) Module: Loaded realm Module: Instantiated realm (suffix) Module: Loaded files Module: Instantiated files (files) Module: Loaded SQL rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql_mysql: Couldn't connect socket to MySQL server [EMAIL PROTECTED]:radius rlm_sql_mysql: Mysql error 'Host 'mysql1.wireless.intranet' is not allowed to connect to this MySQL server' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): starting 1 rlm_sql (sql): starting 2 rlm_sql (sql): starting 3 rlm_sql (sql): starting 4 rlm_sql (sql): Failed to connect to any SQL server. Module: Instantiated sql (sql) Module: Loaded Acct-Unique-Session-Id Module: Instantiated acct_unique (acct_unique) Module: Loaded detail Module: Instantiated detail (detail) Module: Loaded radutmp Module: Instantiated radutmp (radutmp) Initializing the thread pool... Listening on authentication *:1812 Listening on accounting *:1813 Listening on proxy *:1814 Ready to process requests. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Mysql with freeradius Error again
Hello memebers, 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? Alan, thank U for your reply.But U didn't show me the way to get rid of the problem..U know I'm new here. Please help me out. -Monsur - 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
Mysql with freeradius Error
Dear Freeradius users , Would anyone please help me out of my problem ? I'm testing feeradius with mysql on Linux Enterprize edition 4.I did these following things with the help of internet users and members of this site. $INCLUDE ${confdir}/sql.conf authorize { preprocess auth_log chap sql #files mschap } accounting { acct_unique detail unix sql radutmp } session { sql } [EMAIL PROTECTED]:~# mysql -u root -p mysql create database freeradius mysqlinsert into user (Host, User, Password) values ('localhost', 'radius','radius'); mysqlgrant all on freeradius.* to radius mysql exit I install the FreeRadius MySQL schema into the freeradius database within MySQL. [EMAIL PROTECTED]:~# mysql -u root -p freeradius /usr/local/src/freeradius-1.1.1/src/modules/example/mysql.sql ** I configure sql.conf file sql { driver = rlm_sql_mysql server = localhost login = radius password = radius radius_db = freeradius ** I configure clients.conf client 127.0.0.1 { secret = radiustest shortname = localhost } After running the command Radiusd -X the output is --- [EMAIL PROTECTED] ~]# radiusd -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr/local/etc/raddb/clients.conf Config: including file: /usr/local/etc/raddb/snmp.conf Config: including file: /usr/local/etc/raddb/eap.conf Config: including file: /usr/local/etc/raddb/sql.conf main: prefix = /usr/local main: localstatedir = /usr/local/var main: logdir = /usr/local/var/log/radius main: libdir = /usr/local/lib main: radacctdir = /usr/local/var/log/radius/radacct main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = /usr/local/var/log/radius/radius.log main: log_auth = no main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = /usr/local/var/run/radiusd/radiusd.pid main: user = (null) main: group = (null) main: usercollide = no main: lower_user = no main: lower_pass = no main: nospace_user = no main: nospace_pass = no main: checkrad = /usr/local/sbin/checkrad main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = no proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients read_config_files: reading realms radiusd: entering modules setup Module: Library search path is /usr/local/lib Module: Loaded exec exec: wait = yes exec: program = (null) exec: input_pairs = request exec: output_pairs = (null) exec: packet_type = (null) rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = crypt Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: with_ntdomain_hack = no mschap: passwd = (null) mschap: authtype = MS-CHAP mschap: ntlm_auth = (null) Module: Instantiated mschap (mschap) Module: Loaded System unix: cache = no unix: passwd = (null) unix: shadow = (null) unix: group = (null) unix: radwtmp = /usr/local/var/log/radius/radwtmp unix: usegroup = no unix: cache_reload = 600 Module: Instantiated unix (unix) Module: Loaded eap eap: default_eap_type = md5 eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = Password: gtc: auth_type = PAP rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = /usr/local/etc/raddb/huntgroups preprocess: hints = /usr/local/etc/raddb/hints preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = suffix realm: delimiter = @ realm: ignore_default = no realm: ignore_null = no Module: Instantiated realm (suffix) Module: Loaded files files: usersfile = /usr/local/etc/raddb/users files
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
MYSQL and Freeradius
Hi , - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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 movethe 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
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
Using MySQL with Freeradius
Hi, I have got Freeradius working on a linux machine. It is authenticating users using a standard flat file in the /etc/raddb/users file. However, I now want to use MySQL to enter all the user criteria for authentication. Can someone help me with the following questions: 1) What is the schema of the MySQL database that has to be created 2) How do I include this database into the /etc/raddb/radiusd.conf file Many thanks in advance, Rgds, Sonesh Patel VC-NET 107-112 Leadenhall Street London EC3A 4AH Tel: 0207 398 3529 Fax: 0207 491 9511 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Using MySQL with Freeradius
Hi, I have got Freeradius working on a linux machine. It is authenticating users using a standard flat file in the /etc/raddb/users file. However, I now want to use MySQL to enter all the user criteria for authentication. Can someone help me with the following questions: 1) What is the schema of the MySQL database that has to be created radiusd/src/modules/rlm_sql/rlm_sql_mysql/ there is the .sql schema for MySQL 2) How do I include this database into the /etc/raddb/radiusd.conf file read the docs/rlm_sql file. you need to activate the sql{} parts of code alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
MySQL and FreeRadius
Hi All, Freeradius1.0.1 was installed on RH9.0 linux and it ran ok. Afterwards downloaded the standard version 4.0.23 of MySQL and installed. Radisud.conf was also edited to authenticate and authorize via MySQL. Debug output is as below. Is there a way forward from here? Please help! [EMAIL PROTECTED] raddb]# radiusd -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr/local/etc/raddb/clients.conf Config: including file: /usr/local/etc/raddb/snmp.conf Config: including file: /usr/local/etc/raddb/eap.conf Config: including file: /usr/local/etc/raddb/sql.conf main: prefix = /usr/local main: localstatedir = /usr/local/var main: logdir = /usr/local/var/log/radius main: libdir = /usr/local/lib main: radacctdir = /usr/local/var/log/radius/radacct main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = /usr/local/var/log/radius/radius.log main: log_auth = yes main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = /usr/local/var/run/radiusd/radiusd.pid main: user = (null) main: group = (null) main: usercollide = no main: lower_user = no main: lower_pass = no main: nospace_user = no main: nospace_pass = no main: checkrad = /usr/local/sbin/checkrad main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = yes proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients read_config_files: reading realms radiusd: entering modules setup Module: Library search path is /usr/local/lib Module: Loaded exec exec: wait = yes exec: program = (null) exec: input_pairs = request exec: output_pairs = (null) exec: packet_type = (null) rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = crypt Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: with_ntdomain_hack = no mschap: passwd = (null) mschap: authtype = MS-CHAP mschap: ntlm_auth = (null) Module: Instantiated mschap (mschap) Module: Loaded eap eap: default_eap_type = md5 eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = Password: gtc: auth_type = PAP rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = /usr/local/etc/raddb/huntgroups preprocess: hints = /usr/local/etc/raddb/hints preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = suffix realm: delimiter = @ realm: ignore_default = no realm: ignore_null = no Module: Instantiated realm (suffix) Module: Loaded SQL sql: driver = rlm_sql_mysql sql: server = localhost sql: port = sql: login = root sql: password = rootpass sql: radius_db = radius sql: acct_table = radacct sql: acct_table2 = radacct sql: authcheck_table = radcheck sql: authreply_table = radreply sql: groupcheck_table = radgroupcheck sql: groupreply_table = radgroupreply sql: usergroup_table = usergroup sql: nas_table = nas sql: dict_table = dictionary sql: sqltrace = no sql: sqltracefile = /usr/local/var/log/radius/sqltrace.sql sql: readclients = no sql: deletestalesessions = yes sql: num_sql_socks = 5 sql: sql_user_name = %{User-Name} sql: default_user_profile = sql: query_on_not_found = no sql: authorize_check_query = SELECT id,UserName,Attribute,Value,op FROM radche ck WHERE Username = '%{SQL-User-Name}' ORDER BY id sql: authorize_reply_query = SELECT id,UserName,Attribute,Value,op FROM radrep ly WHERE Username = '%{SQL-User-Name}' ORDER BY id sql: authorize_group_check_query = SELECT radgroupcheck.id,radgroupcheck.Group Name,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroup check,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND
AW: MySQL and FreeRadius
Hello yes you can Under Debian you must install the Packet freeradius-mysql for your Linux i don't know it -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Mike-Olumide, Johnson Gesendet: Montag, 17. Januar 2005 16:10 An: freeradius-users@lists.freeradius.org Betreff: MySQL and FreeRadius Hi All, Freeradius1.0.1 was installed on RH9.0 linux and it ran ok. Afterwards downloaded the standard version 4.0.23 of MySQL and installed. Radisud.conf was also edited to authenticate and authorize via MySQL. Debug output is as below. Is there a way forward from here? Please help! [EMAIL PROTECTED] raddb]# radiusd -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr/local/etc/raddb/clients.conf Config: including file: /usr/local/etc/raddb/snmp.conf Config: including file: /usr/local/etc/raddb/eap.conf Config: including file: /usr/local/etc/raddb/sql.conf main: prefix = /usr/local main: localstatedir = /usr/local/var main: logdir = /usr/local/var/log/radius main: libdir = /usr/local/lib main: radacctdir = /usr/local/var/log/radius/radacct main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = /usr/local/var/log/radius/radius.log main: log_auth = yes main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = /usr/local/var/run/radiusd/radiusd.pid main: user = (null) main: group = (null) main: usercollide = no main: lower_user = no main: lower_pass = no main: nospace_user = no main: nospace_pass = no main: checkrad = /usr/local/sbin/checkrad main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = yes proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients read_config_files: reading realms radiusd: entering modules setup Module: Library search path is /usr/local/lib Module: Loaded exec exec: wait = yes exec: program = (null) exec: input_pairs = request exec: output_pairs = (null) exec: packet_type = (null) rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = crypt Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: with_ntdomain_hack = no mschap: passwd = (null) mschap: authtype = MS-CHAP mschap: ntlm_auth = (null) Module: Instantiated mschap (mschap) Module: Loaded eap eap: default_eap_type = md5 eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = Password: gtc: auth_type = PAP rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = /usr/local/etc/raddb/huntgroups preprocess: hints = /usr/local/etc/raddb/hints preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = suffix realm: delimiter = @ realm: ignore_default = no realm: ignore_null = no Module: Instantiated realm (suffix) Module: Loaded SQL sql: driver = rlm_sql_mysql sql: server = localhost sql: port = sql: login = root sql: password = rootpass sql: radius_db = radius sql: acct_table = radacct sql: acct_table2 = radacct sql: authcheck_table = radcheck sql: authreply_table = radreply sql: groupcheck_table = radgroupcheck sql: groupreply_table = radgroupreply sql: usergroup_table = usergroup sql: nas_table = nas sql: dict_table = dictionary sql: sqltrace = no sql: sqltracefile = /usr/local/var/log/radius/sqltrace.sql sql: readclients = no sql: deletestalesessions = yes sql: num_sql_socks = 5 sql: sql_user_name = %{User-Name} sql: default_user_profile = sql: query_on_not_found
Re: AW: MySQL and FreeRadius
As mentioned before - you can install the RPM or get Freeradius source and compile the module from there [EMAIL PROTECTED] 17/01/2005 15:48:43 Hello yes you canUnder Debian you must install the Packet freeradius-mysql for your Linux idon't know it -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Mike-Olumide, Johnson Gesendet: Montag, 17. Januar 2005 16:10 An: freeradius-users@lists.freeradius.org Betreff: MySQL and FreeRadius Hi All, Freeradius1.0.1 was installed on RH9.0 linux and it ran ok. Afterwards downloaded the standard version 4.0.23 of MySQL and installed. Radisud.conf was also edited to authenticate and authorize via MySQL. Debug output is as below. Is there a way forward from here? Please help! [EMAIL PROTECTED] raddb]# radiusd -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr/local/etc/raddb/clients.conf Config: including file: /usr/local/etc/raddb/snmp.conf Config: including file: /usr/local/etc/raddb/eap.conf Config: including file: /usr/local/etc/raddb/sql.conf main: prefix = "/usr/local" main: localstatedir = "/usr/local/var" main: logdir = "/usr/local/var/log/radius" main: libdir = "/usr/local/lib" main: radacctdir = "/usr/local/var/log/radius/radacct" main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = "/usr/local/var/log/radius/radius.log" main: log_auth = yes main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid" main: user = "(null)" main: group = "(null)" main: usercollide = no main: lower_user = "no" main: lower_pass = "no" main: nospace_user = "no" main: nospace_pass = "no" main: checkrad = "/usr/local/sbin/checkrad" main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = yes proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients read_config_files: reading realms radiusd: entering modules setup Module: Library search path is /usr/local/lib Module: Loaded exec exec: wait = yes exec: program = "(null)" exec: input_pairs = "request" exec: output_pairs = "(null)" exec: packet_type = "(null)" rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = "crypt" Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: with_ntdomain_hack = no mschap: passwd = "(null)" mschap: authtype = "MS-CHAP" mschap: ntlm_auth = "(null)" Module: Instantiated mschap (mschap) Module: Loaded eap eap: default_eap_type = "md5" eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = "Password: " gtc: auth_type = "PAP" rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups" preprocess: hints = "/usr/local/etc/raddb/hints" preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = "suffix" realm: delimiter = "@" realm: ignore_default = no realm: ignore_null = no Module: Instantiated realm (suffix) Module: Loaded SQL sql: driver = "rlm_sql_mysql" sql: server = "localhost" sql: port = "" sql: login = "root" sql: password = "rootpass" sql: radius_db = "radius" sql: acct_table = "radacct" sql: acct_table2 = "radacct" sql: authcheck_table = "radcheck" sql: authreply_
MySQL and FreeRadius
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
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
mysql and freeradius
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. second, i want to make the authentication only on the NAS Ip, is there any way to do this. 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
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
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
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[3]: MySql and freeRadius
Wednesday, March 24, 2004, 6:19:51 PM, John escreveu: JQ I made a search in rpmfind.net for mysql ; then , i searched the JQ results for devel and there was not one result. Search for mysql-devel. You said you're using Red Hat 9, so you'll be much better if you use apt-get to search/download/install packets: http://apt.freshrpms.net When recompiling again, pay close attention to the warnings on the make output. -- Humberto Diógenes Administração de Redes -- Internet é Diginet http://www.digi.com.br -- Esta mensagem foi verificada pelo sistema de antivírus e acredita-se estar livre de perigo. - 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
RES: How to connect mysql with freeradius
Are you configure sql.conf ?run radiusd with -X option ( debug ) and check if rlm_mysql is running ok. The radius user have permission to access mysql database ? Sergio Jose Ferreira WGO Internet Brazil -Mensagem original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Em nome de aliEnviada em: quarta-feira, 24 de dezembro de 2003 10:42Para: [EMAIL PROTECTED]Assunto: How to connect mysql with freeradius How to connect mysql with freeradius? because freeradius and mysql setup ok. creating table and radius.confOK. but freeradius doesn'twrite calling log in tables of mysql.