Re: Mysql xlat help

2013-06-14 Thread Arran Cudbard-Bell
On 14 Jun 2013, at 18:22, Go WiFi i...@gowifi.in wrote: Hello i am getting an issue with xlat i tried this sql sql2 { } sql sql_gowifi{ sql_user_name = %{sql2:select s.* from (select @user:=BINARY '%{User-Name}' p) parm , upm s} } and using sql_gowifi in

Re: Mysql xlat help

2013-06-14 Thread Go WiFi
this is the section i am having issues so i don't think it's needed to post the full config also there is nothing special in debug just the sql_user_name field is blank also i managed to write some sql functions to archive the same - List info/subscribe/unsubscribe? See

Re: Mysql xlat help

2013-06-14 Thread Alan DeKok
Go WiFi wrote: this is the section i am having issues so i don't think it's needed to post the full config If you're smarter than the experts on this list, you can figure it out for yourself. Or, if you're not going to follow instructions, you shouldn't be asking questions on this list.

Re: Mysql xlat help

2013-06-14 Thread Arran Cudbard-Bell
On 14 Jun 2013, at 19:07, Go WiFi i...@gowifi.in wrote: this is the section i am having issues so i don't think it's needed to post the full config if you want help, post the full sql config sans queries and any sensitive information. also there is nothing special in debug just the

Re: Mysql xlat help

2013-06-14 Thread Go WiFi
sql sql2 { } sql sql_gowifi{ driver = rlm_sql_mysql # Connection info: server = localhost #port = 3306 login = dbuser password = pass radius_db = radius # Print all SQL statements when in debug mode (-x) sqltrace = yes sqltracefile = ${logdir}/custom.sql # number of sql connections to make to

Re: Mysql xlat help

2013-06-14 Thread Go WiFi
ok after a close look at the debug i found the log [sql_gowifi] WARNING: Unknown module sql2 in string expansion % [sql_gowifi] sql_set_user escaped user -- '' it's not able to find the module sql2 but in my config the very first line is sql sql2 { - List info/subscribe/unsubscribe? See

Re: Mysql xlat help

2013-06-14 Thread Matthew Newton
On Sat, Jun 15, 2013 at 12:42:49AM +0530, Go WiFi wrote: also i denied to give the full code as it's part of my confidential company files if i give the full code then someone might get the details about the table structure Sorry, 'Go', but nobody here cares about your confidential files. If

Re: Mysql xlat help

2013-06-14 Thread Arran Cudbard-Bell
On 14 Jun 2013, at 20:21, Go WiFi i...@gowifi.in wrote: ok after a close look at the debug i found the log [sql_gowifi] WARNING: Unknown module sql2 in string expansion % [sql_gowifi] sql_set_user escaped user -- '' it's not able to find the module sql2 but in my config the very first line

Re: Mysql xlat help

2013-06-14 Thread Go WiFi
can you tell what files you need?? and the code i am giving is form sql configurations file to simulate this according to your instruction i changed the file like sql sql2{ sql_user_name = %{sql_inst2:select s.* from (select @user:=BINARY '%{User-Name}' p) parm , upm s} } and in sql sql_gowifi{

Re: Mysql xlat help

2013-06-14 Thread Arran Cudbard-Bell
On 14 Jun 2013, at 22:36, Go WiFi i...@gowifi.in wrote: can you tell what files you need?? and the code i am giving is form sql configurations file to simulate this according to your instruction i changed the file like sql sql2{ sql_user_name = %{sql_inst2:select s.* from (select

RE: MySQL Cluster as back-end for FreeRadius

2013-05-23 Thread David Peterson
To: FreeRadius users mailing list Subject: Re: MySQL Cluster as back-end for FreeRadius On 22 May 2013, at 18:11, Alan DeKok al...@deployingradius.com wrote: Divyesh Raithatha wrote: Has someone successfully configured a high-availability MySQL cluster as a back-end for FreeRadius? Yes. There's

Re: MySQL Cluster as back-end for FreeRadius

2013-05-22 Thread Alan DeKok
Divyesh Raithatha wrote: Has someone successfully configured a high-availability MySQL cluster as a back-end for FreeRadius? Yes. There's even a white paper on it from MySQL. Trying to find out what architecture was used to achieve the cluster or high availabilty and how successful you

Re: MySQL Cluster as back-end for FreeRadius

2013-05-22 Thread Arran Cudbard-Bell
On 22 May 2013, at 18:11, Alan DeKok al...@deployingradius.com wrote: Divyesh Raithatha wrote: Has someone successfully configured a high-availability MySQL cluster as a back-end for FreeRadius? Yes. There's even a white paper on it from MySQL. Trying to find out what architecture was

Re: MySQL Cluster as back-end for FreeRadius

2013-05-22 Thread Fajar A. Nugraha
On Thu, May 23, 2013 at 6:48 AM, Arran Cudbard-Bell a.cudba...@freeradius.org wrote: On 22 May 2013, at 18:11, Alan DeKok al...@deployingradius.com wrote: Divyesh Raithatha wrote: Has someone successfully configured a high-availability MySQL cluster as a back-end for FreeRadius? Yes.

Re: Mysql, Accounting and DialupAdmin

2012-11-08 Thread Fajar A. Nugraha
On Thu, Nov 8, 2012 at 2:43 PM, Erich Titl erich.t...@think.ch wrote: Hi Fajar on 08.11.2012 08:16, Fajar A. Nugraha wrote: ... IIRC only one of them will be used. I suggest you dop MD5 (since it's useless for your purpose) and Cleartext (you don't want that, right?) and verify you use

Re: Mysql, Accounting and DialupAdmin

2012-11-08 Thread Fajar A. Nugraha
On Thu, Nov 8, 2012 at 2:08 PM, Erich Titl erich.t...@think.ch wrote: 2) I could see login and logout information, but no data usage, e.g. dowload and upload sizes appear to be zeroes. Some NAS (e.g. AP's flashed with dd-wrt) simply doesn't send accounting packets. Blame your NAS :P :-(

Re: Mysql, Accounting and DialupAdmin

2012-11-08 Thread Erich Titl
on 08.11.2012 09:01, Fajar A. Nugraha wrote: ... It is a ZyXEL, so basically a black box, even to the local vendor. Just to be sure, you HAVE enabled sql in accounting section, right? I guess the fact that I have entries in the radacct table which correspond to actual connection attempts

Re: Mysql, Accounting and DialupAdmin

2012-11-08 Thread Fajar A. Nugraha
On Thu, Nov 8, 2012 at 4:27 PM, Erich Titl erich.t...@think.ch wrote: I _guess_ it shows some accounting rad_recv: Accounting-Request packet from host 194.124.158.62 port 47037, id=165, length=135 Acct-Session-Id = 509ACAB9-000F Acct-Status-Type = Start Do some stuff

Re: Mysql, Accounting and DialupAdmin

2012-11-07 Thread Fajar A. Nugraha
On Wed, Nov 7, 2012 at 10:16 PM, Erich Titl erich.t...@think.ch wrote: Hi Folks I succeeded to get my set up running with FR 2.2.0 and Mysql, e.g. I can connect through a ZyXEL NWA 3160 using credentials in the MySQL database using a M$ Windows 7 client. Everything is still quite raw and

Re: Mysql, Accounting and DialupAdmin

2012-11-07 Thread Erich Titl
Hi Fajar on 08.11.2012 03:35, Fajar A. Nugraha wrote: On Wed, Nov 7, 2012 at 10:16 PM, Erich Titl erich.t...@think.ch wrote: Hi Folks I succeeded to get my set up running with FR 2.2.0 and Mysql, e.g. I can connect through a ZyXEL NWA 3160 using credentials in the MySQL database using a M$

Re: Mysql, Accounting and DialupAdmin

2012-11-07 Thread Fajar A. Nugraha
On Thu, Nov 8, 2012 at 2:08 PM, Erich Titl erich.t...@think.ch wrote: Thanks, I read that URL, actually that one guided me to enter a Cleartext Password at all. See the column labeled NT hash? mysql select * from radcheck;

Re: Mysql, Accounting and DialupAdmin

2012-11-07 Thread Erich Titl
Hi Fajar on 08.11.2012 08:16, Fajar A. Nugraha wrote: ... IIRC only one of them will be used. I suggest you dop MD5 (since it's useless for your purpose) and Cleartext (you don't want that, right?) and verify you use the correct NT-Password (use smbencrypt if you haven't already done so)

Re: mysql Connection error

2012-10-31 Thread Fajar A. Nugraha
On Wed, Oct 31, 2012 at 3:57 PM, QASIM RAO qasim2...@hotmail.com wrote: hi, i am having a problem in free radius, when i connect free radius with db by using ip of db server it is not connecting with db database is installed on localhost so when i give db sever=localhost it connects with

Re: mysql Connection error

2012-10-31 Thread Alan DeKok
QASIM RAO wrote: hi, i am having a problem in free radius, when i connect free radius with db by using ip of db server it is not connecting with db database is installed on localhost so when i give db sever=localhost it connects with db... please help me in this why radius is doing this

Re: mysql Connection error

2012-10-31 Thread Arran Cudbard-Bell
On 31 Oct 2012, at 09:02, Fajar A. Nugraha l...@fajar.net wrote: On Wed, Oct 31, 2012 at 3:57 PM, QASIM RAO qasim2...@hotmail.com wrote: hi, i am having a problem in free radius, when i connect free radius with db by using ip of db server it is not connecting with db database is installed

RE: mysql Connection error

2012-10-31 Thread QASIM RAO
From: al...@deployingradius.com To: freeradius-users@lists.freeradius.org Subject: Re: mysql Connection error QASIM RAO wrote: hi, i am having a problem in free radius, when i connect free radius with db by using ip of db server it is not connecting with db database is installed

RE: mysql Connection error

2012-10-31 Thread QASIM RAO
how can i change localhost to public IP Subject: Re: mysql Connection error From: a.cudba...@freeradius.org Date: Wed, 31 Oct 2012 09:11:04 + To: freeradius-users@lists.freeradius.org On 31 Oct 2012, at 09:02, Fajar A. Nugraha l...@fajar.net wrote: On Wed, Oct 31, 2012 at 3:57

Re: mysql Connection error

2012-10-31 Thread alan buxey
Hi, i want to connect db using ip because no i am testing after this i will connect i to remote db.  How can i tel Db to listen on a public ip  ?? now this is a MySQL question - not a FreeRADIUS question, mysql has its own mailing lists (and its own configuration file and users table

Re: mysql Connection error

2012-10-31 Thread Alan DeKok
QASIM RAO wrote: i want to connect db using ip because no i am testing after this i will connect i to remote db. How can i tel Db to listen on a public ip ?? Go read the MySQL documentation. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: mysql ip pool guide or documentation

2012-10-19 Thread Phil Mayers
Sebastien Boucher cannibal...@gmail.com wrote: hello, Sorry for asking a question that was probably asked and answered before but i could not find anything. Can anyone direct me to a guide or some sort of documentation on how to configure ip pool for freeradius using a mysql database ? thank

Re: mysql ip pool guide or documentation

2012-10-19 Thread Sebastien Boucher
heh ok .. the module was right in front of my eyes and i did not see it. i found the sql schema for ippool also. thanks ! S. On Fri, Oct 19, 2012 at 1:24 PM, Phil Mayers p.may...@imperial.ac.ukwrote: Sebastien Boucher cannibal...@gmail.com wrote: hello, Sorry for asking a question that

Re: MySQL Segmentation Fault

2012-09-28 Thread Alan DeKok
Bryan Dobson wrote: I have a new installation and configuration that I am working on for FreeRadius on CentOS 6.3 the versions are: freeradius-2.1.12-3.el6.x86_64 Testing authentication, which goes to a remote MySQL database which was pre-existing with all user data. It executes the query

Re: MySQL Segmentation Fault

2012-09-28 Thread Bryan Dobson
Thank you for the reply, I thought this as well, but, checking the system all I only see a single set of client libraries installed: [root@radiusdev ~]# rpm -qa | grep mysql mysql-5.1.61-4.el6.x86_64 mysql-devel-5.1.61-4.el6.x86_64 mysql-libs-5.1.61-4.el6.x86_64 mysql-server-5.1.61-4.el6.x86_64

Re: MySQL Segmentation Fault

2012-09-28 Thread Thomas Glanzmann
Hello Bryan, [root@radiusdev ~]# rpm -qa | grep mysql mysql-5.1.61-4.el6.x86_64 mysql-devel-5.1.61-4.el6.x86_64 mysql-libs-5.1.61-4.el6.x86_64 mysql-server-5.1.61-4.el6.x86_64 they all belong to same release. Do I need all of those or is one causing me the issue still with the faults?

Re: MySQL Segmentation Fault

2012-09-28 Thread Alan DeKok
Bryan Dobson wrote: Thank you for the reply, I thought this as well, but, checking the system all I only see a single set of client libraries installed: shrug It's not a FreeRADIUS problem. Something, somewhere, is using the wrong library. Use ldd to figure out which are being used.

Re: MySQL Backend

2012-06-12 Thread Alan DeKok
Rampage wrote: Let's say i successfully managed to bind freeRADIUS to mysql, i can connect it and no errors are present, i created all proper tables, and database accounts to have freeRADIUS talk to mysql. the problem is.. ok but now, which informations do i put where? See doc/rlm_sql.

Re: MySQL Backend

2012-06-12 Thread Rampage
Il 12/06/2012 23:11, Alan DeKok ha scritto: Rampage wrote: i also noticed that the radacct table contains one account for each time i perform a login for the specific user, is it normal? That's what your NAS is telling it to do. The NAS is sending an accounting start for each login. And

Re: MySQL Backend

2012-06-12 Thread Fajar A. Nugraha
On Wed, Jun 13, 2012 at 5:08 AM, Rampage atomikr...@email.it wrote: acctstoptime seems to be the timestamp of when the NAS sends the stop, still the entry from the db is not deleted, so i have an entry for each session start, That's the default setup. Most people will need the historical

Re: mySQL user wifi authentication error on freeradius

2012-05-09 Thread xadow20
Hi! here is de debug. FreeRADIUS Version 2.1.8, for host i486-pc-linux-gnu, built on Jan 5 2010 at 02:49:11 Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute

Re: mySQL user wifi authentication error on freeradius

2012-05-09 Thread xadow20
Hi! here is de debug. FreeRADIUS Version 2.1.8, for host i486-pc-linux-gnu, built on Jan 5 2010 at 02:49:11 Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute

Re: mySQL user wifi authentication error on freeradius

2012-05-09 Thread Alan DeKok
xadow20 wrote: Hi! here is de debug. Nope. It doesn't show the server receiving any packets. Post the debug output for THAT. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: mySQL user wifi authentication error on freeradius

2012-05-09 Thread xadow20
I can't post all debug http://freeradius.1045715.n5.nabble.com/file/n5697736/debug2.txt debug2.txt -- View this message in context: http://freeradius.1045715.n5.nabble.com/mySQL-user-wifi-authentication-error-on-freeradius-tp5693432p5697736.html Sent from the FreeRadius - User mailing list

Re: mySQL user wifi authentication error on freeradius

2012-05-09 Thread Fajar A. Nugraha
On Wed, May 9, 2012 at 10:39 PM, xadow20 joaofigueired...@gmail.com wrote: I can't post all debug http://freeradius.1045715.n5.nabble.com/file/n5697736/debug2.txt debug2.txt What do you get if you execute this query directly on your db? SELECT id, username, attribute, value, op FROM

Re: mySQL user wifi authentication error on freeradius

2012-05-09 Thread xadow20
Hi! With clear-text password it works. I Thought it work with encripted password too. Thanks -- View this message in context: http://freeradius.1045715.n5.nabble.com/mySQL-user-wifi-authentication-error-on-freeradius-tp5693432p5698103.html Sent from the FreeRadius - User mailing list archive at

Re: mySQL user wifi authentication error on freeradius

2012-05-08 Thread Tobias Hachmer
On 08.05.2012 13:36, xadow20 wrote: I'm new to freeradius. My Setup is: Ubuntu Server 10.04 Freeradius 2.1.8 daloRADIUS 0.9-9 When I try to authenticate on AP wireless with a user on /etc/freeradius/users it succedd well. But When I create a user on daloradius it gives the output above, can

Re: mySQL user wifi authentication error on freeradius

2012-05-08 Thread xadow20
Hi! tanks for reply. Here is the debug. FreeRADIUS Version 2.1.8, for host i486-pc-linux-gnu, built on Jan 5 2010 at 02:49:11 Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You

Re: mySQL user wifi authentication error on freeradius

2012-05-08 Thread xadow20
Hi! tanks for reply. Here is the debug. FreeRADIUS Version 2.1.8, for host i486-pc-linux-gnu, built on Jan 5 2010 at 02:49:11 Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You

Re: mySQL user wifi authentication error on freeradius

2012-05-08 Thread xadow20
Hi! tanks for reply. Here is the debug. FreeRADIUS Version 2.1.8, for host i486-pc-linux-gnu, built on Jan 5 2010 at 02:49:11 Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You

Re: mySQL user wifi authentication error on freeradius

2012-05-08 Thread Tobias Hachmer
On 08.05.2012 16:06, xadow20 wrote: Hi! tanks for reply. Here is the debug. I took it for granted to send the whole debug output including the radius request and processing and not only the freeradius instantiating output. My fault ;-) Please start radiusd -X, or freeradius -X , then

Re: mySQL user wifi authentication error on freeradius

2012-05-08 Thread Tobias Hachmer
On 08.05.2012 16:09, xadow20 wrote: Hi! tanks for reply. Here is the debug. Please stop posting your posts three times!! Regards, Tobias Hachmer - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: mysql module help

2011-11-15 Thread Alan DeKok
Ski Mountain wrote: I am trying to get freeradius working with mysql on a new system. I even copied the configuration files from a working system, but I am still having trouble getting the mysql module to load. Yes I have $INCLUDE sql.conf uncommitted from radius.conf Read

Re: mysql module help

2011-11-15 Thread Ski Mountain
freeradius-users@lists.freeradius.org Sent: Tuesday, November 15, 2011 4:10 AM Subject: Re: mysql module help Ski Mountain wrote: I am trying to get freeradius working with mysql on a new system.  I even copied the configuration files from a working system, but I am still having trouble getting

Re: mysql module help

2011-11-15 Thread Fajar A. Nugraha
On Wed, Nov 16, 2011 at 5:44 AM, Ski Mountain ski_the_mount...@yahoo.com wrote: Yes I have already edited the freeradius/sites-available/default Did you edit the right file? If you did, sql would show up on the debug log. The correct file (based on your debug output) should be

Re: mysql module help

2011-11-15 Thread Ski Mountain
list freeradius-users@lists.freeradius.org Sent: Tuesday, November 15, 2011 6:57 PM Subject: Re: mysql module help On Wed, Nov 16, 2011 at 5:44 AM, Ski Mountain ski_the_mount...@yahoo.com wrote: Yes I have already edited the freeradius/sites-available/default Did you edit the right file

Re: MySQL and FreeRADIUS environment

2011-10-06 Thread tonimanel
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

Re: MySQL and FreeRADIUS environment

2011-10-06 Thread Arran Cudbard-Bell
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,

Re: MySQL and FreeRADIUS environment

2011-10-06 Thread Alan DeKok
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

2011-10-06 Thread tonimanel
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:

Re: MySQL and FreeRADIUS environment

2011-10-06 Thread Arran Cudbard-Bell
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

Re: MySQL and FreeRADIUS environment

2011-10-05 Thread tonimanel
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

Re: MySQL and FreeRADIUS environment

2011-10-05 Thread tonimanel
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

Re: MySQL and FreeRADIUS environment

2011-10-05 Thread Fajar A. Nugraha
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,

Re: MySQL and FreeRADIUS environment

2011-10-05 Thread tonimanel
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

Re: MySQL and FreeRADIUS environment

2011-10-05 Thread Alan DeKok
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

Re: MySQL and FreeRADIUS environment

2011-10-05 Thread tonimanel
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

Re: MySQL and FreeRADIUS environment

2011-10-05 Thread Alan DeKok
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

Re: MySQL and FreeRADIUS environment

2011-10-04 Thread tonimanel
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

Re: MySQL and FreeRADIUS environment

2011-10-04 Thread Alan DeKok
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

Re: MySQL and FreeRADIUS environment

2011-09-30 Thread tonimanel
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

RE: MySQL and FreeRADIUS environment.

2011-09-30 Thread tonimanel
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

Re: MySQL and FreeRADIUS environment

2011-09-30 Thread Fajar A. Nugraha
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

Re: MySQL and FreeRADIUS environment.

2011-09-27 Thread Alan Buxey
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

RE: MySQL and FreeRADIUS environment.

2011-09-27 Thread Tim Sylvester
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

Re: MySQL and FreeRADIUS environment.

2011-09-27 Thread Alexander Clouter
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

Re: MySQL and FreeRADIUS environment

2011-09-27 Thread Fajar A. Nugraha
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

Re: MySQL performance

2011-09-22 Thread Alan DeKok
Lorenzo Milesi wrote: This radius has been successfully running for 4y now. Problems raised since when we increased the number of users. So? Since you're using the same configuration, the performance problems must be related to your configuration. So, by the way, seems like there are two

Re: MySQL performance

2011-09-20 Thread Lorenzo Milesi
Don't. Fix the database so that it isn't too slow. See the logs. If the DB is slow, the logs will usually say. I have no slow queries on mysql-slow.log. thanks -- Lorenzo Milesi - lorenzo.mil...@yetopen.it YetOpen S.r.l. - http://www.yetopen.it/ Via Carlo Torri Tarelli 19 - 23900 Lecco -

Re: MySQL performance

2011-09-20 Thread Lorenzo Milesi
is the db on the same server as freeradius? yes there should be something on FR log file. If not, then run the server in debug mode and see which part is slow or spitting out errors. will try to look for something -- Lorenzo Milesi - lorenzo.mil...@yetopen.it YetOpen S.r.l. -

Re: MySQL performance

2011-09-20 Thread Alan DeKok
Lorenzo Milesi wrote: Don't. Fix the database so that it isn't too slow. See the logs. If the DB is slow, the logs will usually say. I have no slow queries on mysql-slow.log. Then it must be magic. Hire a wizard to fix the problem. Something *you did* broke the server. Either say what

Re: MySQL performance

2011-09-20 Thread Lorenzo Milesi
Then it must be magic. Hire a wizard to fix the problem. Thanks, your sarcasm is really helpful! Something *you did* broke the server. Either say what you did, or good luck solving it yourself. i.e. See the FAQ for useless comments like it doesn't work, which is what your messages amount

Re: MySQL performance

2011-09-20 Thread Lorenzo Milesi
there should be something on FR log file. If not, then run the server in debug mode and see which part is slow or spitting out errors. I ran in debug, and saw something which maybe could be wrong: User-Name = MYUSERNAME User-Password =

Re: MySQL performance

2011-09-20 Thread Alan DeKok
Lorenzo Milesi wrote: Then it must be magic. Hire a wizard to fix the problem. Thanks, your sarcasm is really helpful! It seems to work better than honest suggestions. You've ignored those. I *DID* say what I did: increased the amount of accounted users, nothing else. The *default

Re: MySQL performance

2011-09-20 Thread Alan DeKok
Lorenzo Milesi wrote: there should be something on FR log file. If not, then run the server in debug mode and see which part is slow or spitting out errors. I ran in debug, and saw something which maybe could be wrong: User-Name = MYUSERNAME User-Password =

Re: MySQL performance

2011-09-20 Thread Fajar A. Nugraha
On Tue, Sep 20, 2011 at 8:23 PM, Lorenzo Milesi lorenzo.mil...@yetopen.it wrote: there should be something on FR log file. If not, then run the server in debug mode and see which part is slow or spitting out errors. There are several reasons why I suggest you run the server in debug mode (as

Re: MySQL performance

2011-09-20 Thread Lorenzo Milesi
For one, it can show you which part is slow (is it really the db, or is it something else). Another one is it can show relevant parts of the config which can help others pinpoint the problem. Pasting only PART of the debug log will only get you (at best) partial guesses. Ok, I missed this, I

Re: MySQL performance

2011-09-20 Thread Fajar A. Nugraha
On Tue, Sep 20, 2011 at 10:22 PM, Lorenzo Milesi lorenzo.mil...@yetopen.it wrote: For one, it can show you which part is slow (is it really the db, or is it something else). Another one is it can show relevant parts of the config which can help others pinpoint the problem. Pasting only PART of

Re: MySQL performance

2011-09-20 Thread Lorenzo Milesi
The *default configuration* doesn't have the problem you described. So... what did you change? adding users is *not* the answer I'm looking for. This radius has been successfully running for 4y now. Problems raised since when we increased the number of users. You edited radiusd.conf to

Re: MySQL performance

2011-09-20 Thread Lorenzo Milesi
Your output does not look llike it comes from FR2's debug log. This first debug log was a -x. And yes, it's FR 1.1.7! (yes, could have said that before) Let's say most of the problems come from a newly deployed nas. Then start from there. If the db is slow and FR is late to respond,

Re: MySQL performance

2011-09-20 Thread Alan DeKok
Lorenzo Milesi wrote: Ok, I missed this, I thought was a suggestion to me :-) http://paste.ubuntu.com/693812/ Ugh. Upgrade to 2.1.x. Another weird thing I noticed is that as you can see at line 155 in the middle of an Access-Accept report there's another rad_recv, like it's mixing up

Re: MySQL performance

2011-09-20 Thread Johan Meiring
On 2011/09/20 05:22 PM, Lorenzo Milesi wrote: Ok, I missed this, I thought was a suggestion to me :-) http://paste.ubuntu.com/693812/ What is: Can't connect to SNMP agent with SMUX: Connection refused Is an SNMP connetion of some sorts not maybe slowing it down while authenticating? --

Re: MySQL performance

2011-09-19 Thread Fajar A. Nugraha
On Mon, Sep 19, 2011 at 7:33 PM, Lorenzo Milesi lorenzo.mil...@yetopen.it wrote: Hi. I have a Freeradius server with MySQL backend, which has worked great so far. Right now we're increasing the users accounting here, and we're facing some login issues.  Freeradius is used as an accounting

Re: MySQL performance

2011-09-19 Thread Alan DeKok
Lorenzo Milesi wrote: Hi. I have a Freeradius server with MySQL backend, which has worked great so far. Right now we're increasing the users accounting here, and we're facing some login issues. Freeradius is used as an accounting service for Chillispot. I tried increasing num_sql_socks

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread Alan DeKok
Det Det wrote: When I shutdown one of the DB, it generates an error. How do I tell freeradius to ignore that and proceed if it can connect to at least one of the DB? You don't. The only way to change this is via source code patches. Alan DeKok. - List info/subscribe/unsubscribe? See

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread Det Det
...@deployingradius.com To: Det Det det.explo...@yahoo.com; FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Monday, August 29, 2011 6:21 PM Subject: Re: MySQL Fail Over Error When 1 DB is Down Det Det wrote: When I shutdown one of the DB, it generates an error. How do I tell freeradius

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread Alan DeKok
Det Det wrote: Really? sigh If you think I'm lying, why ask questions? What is the failover feature for? Read the docs. It's explained. I can specify multiple DBs but if FreeRADIUS cannot connect to at least one of the DBs it will have an error and will not be able to start. There

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread Rich Graves
When I shutdown one of the DB, it generates an error. How do I tell freeradius to ignore that and proceed if it can connect to at least one of the DB? /etc/freeradius/sql2.conf[22]: Instantiation failed for module sql2 Both databases must be up at the time of radiusd startup. This seems

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread det.explo...@yahoo.com
Hi, Sorry, I honestly don't mean it that way. I just want to clarify some of that thoughts/concepts. I understand now what you mean by this. Fail-over is for when something goes wrong while the server is running. Thanks, Det Sent from my iPad On Aug 29, 2011, at 9:34 PM, Alan DeKok

Re: MySQL Fail Over Error When 1 DB is Down

2011-08-29 Thread det.explo...@yahoo.com
Thanks so much! I understand it now. And thanks for the suggestions and additional inputs. BRegards, Det Sent from my iPad On Aug 29, 2011, at 10:56 PM, Rich Graves rgra...@carleton.edu wrote: When I shutdown one of the DB, it generates an error. How do I tell freeradius to ignore that and

Re: [mysql+freeradius]add attribute for freeradius

2011-07-28 Thread Fajar A. Nugraha
2011/7/28 gary gary.y...@browan.com: Hi All I would like to create radcheck table and new attribute as below. How do I configure the freeradius server to recognize and send the attribute value? -- id   | username

Re: [mysql+freeradius]add attribute for freeradius

2011-07-28 Thread gary
@lists.freeradius.org Sent: Thursday, July 28, 2011 3:45 PM Subject: Re: [mysql+freeradius]add attribute for freeradius 2011/7/28 gary gary.y...@browan.com: Hi All I would like to create radcheck table and new attribute as below. How do I configure the freeradius server to recognize and send the attribute

  1   2   3   4   5   6   >