Re: reconnecting to mysql

2013-09-17 Thread Arran Cudbard-Bell
On 17 Sep 2013, at 18:22, Edgars Makņa edg...@dtg.lv wrote: Hello, I just setup 2.2.0 from freebsd ports. In the testing environment it looks okey except this error: rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN rlm_sql (sql): Attempting to connect rlm_sql_mysql #1

Re: Freeradius2 + MySQL + Accouting

2013-09-17 Thread Arran Cudbard-Bell
On 17 Sep 2013, at 18:41, Wederson Rodrigues weder...@vipvilhena.com.br wrote: Regards, I have a server configured with freeradius2 rlm_mysql and have authentication working well. But the Accouting is only done on start and stop. Wanted it to be done every 5 minutes (300 interim-update)

Freeradius2 + MySQL + Accouting

2013-09-17 Thread Wederson Rodrigues
Regards, I have a server configured with freeradius2 rlm_mysql and have authentication working well. But the Accouting is only done on start and stop. Wanted it to be done every 5 minutes (300 interim-update) but is not working. Radtest result: Sending Access-Request of id 250 to 127.0.0.1 port

Re: Freeradius2 + MySQL + Accouting

2013-09-17 Thread Arran Cudbard-Bell
On 17 Sep 2013, at 19:02, Wederson Rodrigues weder...@vipvilhena.com.br wrote: I used radtest just to show the attributes that are returning. I'm using a debian (ppp) as NAS, with the enabled plugins: plugin rp-radius.so pppoe.so radattr.so Even better, RTFS. Arran Cudbard-Bell

reconnecting to mysql

2013-09-17 Thread Edgars Makņa
Hello, I just setup 2.2.0 from freebsd ports. In the testing environment it looks okey except this error: rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 rlm_sql (sql

Re: Groups in active directory and checks in MySQL

2013-08-26 Thread Atomikramp
Ldap-Group == fax, Auth-Type := Reject nbsp; i've tried commenting it out and adding this to mysql in the table radgroupcheck: nbsp; table: radgroupcheck Groupname: fax Attribute: Auth-Type op: := Value: Reject nbsp; but it's not giving the same result, the check against sql

Re: Groups in active directory and checks in MySQL

2013-08-26 Thread Phil Mayers
On 08/26/2013 09:04 AM, Atomikramp wrote: but it's not giving the same result, the check against sql is ignored and the user is authed successfully. Because: [sql] User sogo1 not found ++[sql] returns notfound - List info/subscribe/unsubscribe? See

Re: Groups in active directory and checks in MySQL

2013-08-26 Thread Atomikramp
;freeradius-users@lists.freeradius.orggt; Oggetto: Re: Groups in active directory and checks in MySQL Data: 26/08/13 13:22 On 08/26/2013 09:04 AM, Atomikramp wrote: gt; but it's not giving the same result, the check against sql is ignored gt; and the user is authed successfully

Groups in active directory and checks in MySQL

2013-08-23 Thread Atomikramp
already using MySQL for storing accounting informations i was really interested in being able to use the same backend (mysql) also for performing checks against groups. nbsp; If i perform checks against usernames using the table radcheck they work properly (users retrieved from the LDAP backend

Re: Groups in active directory and checks in MySQL

2013-08-23 Thread Alan DeKok
entry: DEFAULTLdap-Group == groupA, Auth-Type := Reject Reply-Message = Not Allowed. i successfully deny access to that user. That should map directly to the SQL tables. Since i'm already using MySQL for storing accounting informations i was really interested in being able to use

Re: Groups in active directory and checks in MySQL

2013-08-23 Thread Rampage
Il 23/08/2013 21:31, Alan DeKok ha scritto: Post the debug output. And what do you have in SQL? Hello, thanks for your reply and apologizes for the mistake, unfortunately (depending from the point of view) since it's weekend i won't be able to post any debug log till monday as i didn't bring the

Re: RLM_PERL mysql disconnect : what is the preferred handling ?

2013-08-13 Thread Alan DeKok
itquestioner wrote: We've found in the freeradius wiki, that the correct way to manage connection to mysql is to initiate the connection in the CLONE function. But where should we put $dbh-disconnect() to be sure that any connection will also be closed ? Whatever the result of the request

RLM_PERL mysql disconnect : what is the preferred handling ?

2013-08-12 Thread itquestioner
Hi,   First question from beginners We've found in the freeradius wiki, that the correct way to  manage connection to mysql is to initiate the connection in the CLONE function. But where should we put $dbh-disconnect() to be sure that any connection will also be closed ? Whatever the  result

Re: FreeRadius + MySql + Crypt-Password unable to authenticate

2013-07-29 Thread Alan DeKok
Marcel Kraan wrote: I'am marcel kraan from Holland and i have a problem with Crypt-passwords in the mysql table. FreeRadius is working really great with Cleartext-Password but it does not authenticate with Crypt-password You can't use Crypt-Password and MS-CHAP. http://deployingradius.com

Re: FreeRadius + MySql + Crypt-Password unable to authenticate

2013-07-29 Thread Marcel Kraan
Yes i want to use PAP (?) but where do i change that? into my Wifi router ? or in the Freeradius config? On 29 jul. 2013, at 13:52, Alan DeKok al...@deployingradius.com wrote: Marcel Kraan wrote: I'am marcel kraan from Holland and i have a problem with Crypt-passwords in the mysql table

Re: FreeRadius + MySql + Crypt-Password unable to authenticate

2013-07-29 Thread Alan DeKok
Marcel Kraan wrote: Yes i want to use PAP (?) but where do i change that? into my Wifi router ? or in the Freeradius config? No. You're doing 802.1X to the WiFi router. You *cannot* use PAP. You cannot pick an authentication protocol and demand that everyone use it. The AP, client PC,

Re: FreeRadius + MySql + Crypt-Password unable to authenticate

2013-07-29 Thread Marcel Kraan
I very clear understands.. thanks for the help On 29 jul. 2013, at 14:07, Alan DeKok al...@deployingradius.com wrote: Marcel Kraan wrote: Yes i want to use PAP (?) but where do i change that? into my Wifi router ? or in the Freeradius config? No. You're doing 802.1X to the WiFi

Re: FreeRadius + MySql + Crypt-Password unable to authenticate

2013-07-29 Thread Navodit Bhardwaj
Wifi router ? or in the Freeradius config? On 29 jul. 2013, at 13:52, Alan DeKok al...@deployingradius.com wrote: Marcel Kraan wrote: I'am marcel kraan from Holland and i have a problem with Crypt-passwords in the mysql table. FreeRadius is working really great with Cleartext-Password

Re: FreeRadius + MySql + Crypt-Password unable to authenticate

2013-07-29 Thread Phil Mayers
On 29/07/13 12:55, Marcel Kraan wrote: Yes i want to use PAP (?) but where do i change that? into my Wifi router ? or in the Freeradius config? On the client. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: FreeRadius + MySql + Crypt-Password unable to authenticate

2013-07-29 Thread Marcel Kraan
marcel kraan from Holland and i have a problem with Crypt-passwords in the mysql table. FreeRadius is working really great with Cleartext-Password but it does not authenticate with Crypt-password You can't use Crypt-Password and MS-CHAP. http://deployingradius.com/documents/protocols

Re: FreeRadius + MySql + Crypt-Password unable to authenticate

2013-07-29 Thread Fajar A. Nugraha
On Mon, Jul 29, 2013 at 7:39 PM, Marcel Kraan mar...@kraan.net wrote: Thanks… i think my wifi router does not have that option… On 29 jul. 2013, at 14:15, Navodit Bhardwaj navodit.bhard...@gmail.com wrote: By default PAP, CHAP.. are enabled in FR. You may need to change the authentication

Re: FreeRadius + MySql + Crypt-Password unable to authenticate

2013-07-29 Thread Marcel Kraan
Thanks. I have a genius en202 outdoor wifi router and i don't think i can change it to use PAP. So i'am only able to use ClearText-Password? If i'am wrong i will be very happy -- Marcel Kraan +31654378837 On 29 jul. 2013, at 15:04, Fajar A. Nugraha l...@fajar.net wrote: On Mon, Jul

Mysql xlat help

2013-06-14 Thread Go WiFi
Hello i am getting an issue with xlat i tried this sql sql2 { } sql sql_gowifi{ sql_user_name = %{sql2:select s.* from (select @userhttps://github.com/user:=BINARY '%{User-Name}' p) parm , upm s} } and using sql_gowifi in sites-enabled/default for mysql based login and accounting again when

Re: Mysql xlat help

2013-06-14 Thread Arran Cudbard-Bell
/default for mysql based login and accounting again when using sql_user_name = %{User-Name} it saves the username entered in login page of hotspot to radpostauth table but with the code above the username remains blank when i run the sql query above in mysql server it returns the correct

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: Huntgroups checking in MySQL radgroupcheck

2013-06-07 Thread Marco Marzetti
Il giorno gio, 06/06/2013 alle 09.21 +0200, Marco Marzetti ha scritto: Il giorno mer, 05/06/2013 alle 13.41 -0400, Alan DeKok ha scritto: Marco Marzetti wrote: Also, if i understand it correctly, it makes sense to me since == is a filtering operator while := add the attribute to

Re: Huntgroups checking in MySQL radgroupcheck

2013-06-06 Thread Marco Marzetti
Il giorno mer, 05/06/2013 alle 13.41 -0400, Alan DeKok ha scritto: Marco Marzetti wrote: Also, if i understand it correctly, it makes sense to me since == is a filtering operator while := add the attribute to the list for further checking Anyway, i've updated the record above and

Re: Huntgroups checking in MySQL radgroupcheck

2013-06-05 Thread Alan DeKok
Marco Marzetti wrote: mysql SELECT * FROM radgroupcheck; ++---+++--+ | id | groupname | attribute | op | value| ++---+++--+ | 1 | TECNICI | Huntgroup-Name | == | APPARATI

Re: Huntgroups checking in MySQL radgroupcheck

2013-06-05 Thread Marco Marzetti
Il giorno mer, 05/06/2013 alle 09.14 -0400, Alan DeKok ha scritto: Marco Marzetti wrote: mysql SELECT * FROM radgroupcheck; ++---+++--+ | id | groupname | attribute | op | value| ++---+++--+ | 1

Re: Huntgroups checking in MySQL radgroupcheck

2013-06-05 Thread Alan DeKok
Marco Marzetti wrote: Also, if i understand it correctly, it makes sense to me since == is a filtering operator while := add the attribute to the list for further checking Anyway, i've updated the record above and putting := and it doesn't work. It depends what you want to do. I thought

RE: MySQL Cluster as back-end for FreeRadius

2013-05-23 Thread David Peterson
MySQL cluster requires quite a bit of hardware to do properly. I went with the Network Raid 1 type of setup for Freeradius, MySQL and DHCP. This allows you some redundancy with a plain vanilla setup of FR Ubuntu has a great tutorial on how to set it up. https://help.ubuntu.com/community

MySQL Cluster as back-end for FreeRadius

2013-05-22 Thread Divyesh Raithatha
Newbie question. Has someone successfully configured a high-availability MySQL cluster as a back-end for FreeRadius? Trying to find out what architecture was used to achieve the cluster or high availabilty and how successful you have been in a Production Environment. 1. Master/Master

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

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: Username with spaces (MySQL)

2013-04-29 Thread Andres Gomez Ruiz
Hi Guys, I have another Cuestion. How can I convert the username to UPPERCASE in the authorization section? Or how can I Authorize only the Username wittren in UPPERCASE? Thanks 2013/4/19 Andres Gomez Ruiz andres.go...@urbalink.co Thanks a lot guys! Both methods work. Finally I used the

Re: Problem with Discarding packets. It is the Radius, MySQL or PostgreSQL?

2013-04-25 Thread Alan DeKok
Michell wrote: What are the parameters that could be changed to make the tuning of freeradius? Nothing. Fix your database. If you have 3000 clients connected simultaneously with 5min updates, that's 10 accounting packets/s. ANY database should be able to handle that with minimal tuning.

Problem with Discarding packets. It is the Radius, MySQL or PostgreSQL?

2013-04-24 Thread Michell
and accounting users in a mysql db. The time we have the message Discarding duplicate request ... and Discarding conflicting ... and in recent days began using ippool in postgresql where we started having problems duplicating IPs. We believed that such duplication was due to these messages which

Re: Problem with Discarding packets. It is the Radius, MySQL or PostgreSQL?

2013-04-24 Thread A . L . M . Buxey
Hi, I would like an opinion concerning a situation that is happening with us. I'm sure you have faced a similar situation. yes. live accounting to DB requires REALLY optimised DB. you've made the move to postgres, which will help...and you can spend some time adjusting the buffers,

Re: Problem with Discarding packets. It is the Radius, MySQL or PostgreSQL?

2013-04-24 Thread Fajar A. Nugraha
On Thu, Apr 25, 2013 at 3:20 AM, Michell bill.c...@gmail.com wrote: So we did the installation of new server Mysql and changed the parameters possible and even indicated by mysqltunner and mysqlprimer, but the message continued Discarding occurs. ( sigh ) no program can replace a qualified

Re: Username with spaces (MySQL)

2013-04-19 Thread Andres Gomez Ruiz
Thanks a lot guys! Both methods work. Finally I used the regex in the Authorize section. Best regards. Andrés - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Username with spaces (MySQL)

2013-04-18 Thread Wilco Baan Hofman
the sql counters) Not really a RADIUS question, but this is default behaviour for MySQL. Convert the VARCHAR Field to binary or use TRIM() for the counters. Regards, Wilco Baan Hofman - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Username with spaces (MySQL)

2013-04-18 Thread Marinko Tarlać
behaviour for MySQL. Convert the VARCHAR Field to binary or use TRIM() for the counters. Regards, Wilco Baan Hofman - 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: Username with spaces (MySQL)

2013-04-18 Thread A . L . M . Buxey
Hi, You can add if (%{User-Name} =~ / /) { reject } at the start of the authorize section. This rule will reject user(s) in case they add blank spaces before or after the username... invoke a policy. there are examples and usable methods already in policy.conf (2.x) and

Re: Username with spaces (MySQL)

2013-04-18 Thread Tony Peña
Hi I had same trouble.. in version 1.x of radius.. and had to did queries like above with regex... but for luck in the new version 2.x just have to enable the policy.conf in the authorization module.. and your problem will be solve regards. 2013/4/18 a.l.m.bu...@lboro.ac.uk Hi, You

Username with spaces (MySQL)

2013-04-17 Thread Andres Gomez Ruiz
Hi everybody. I'm using freeradius to log many wireless user, It works great. I have a MySQL table working with freeradius, and I use some SQL_counters to control the timeup of my users (based on the raddacct table of the database); everything work great, but I only have a problem: Using

[RESOLVED] Need both Local (MySQL database) and Active directory authentications.

2013-04-12 Thread ffgch2
set up Freeradius (v.2.1.10) Upgrade to v2.2.0. to do password authentication from MySQL database and it works fine but now I need to make some users be able to authenticate against Active directory accounts. I’ve setup winbind to authenticate windows accounts and it works

Need both Local (MySQL database) and Active directory authentications.

2013-04-11 Thread ffgch2
Hi all, I have set up Freeradius (v.2.1.10) to do password authentication from MySQL database and it works fine but now I need to make some users be able to authenticate against Active directory accounts. I’ve setup winbind to authenticate windows accounts and it works but as a result freeradius

Re: Need both Local (MySQL database) and Active directory authentications.

2013-04-11 Thread Alan DeKok
ffgch2 wrote: I have set up Freeradius (v.2.1.10) Upgrade to v2.2.0. to do password authentication from MySQL database and it works fine but now I need to make some users be able to authenticate against Active directory accounts. I’ve setup winbind to authenticate windows accounts

Re: Freeradius + MySQL + Daloradius

2013-04-10 Thread Alan DeKok
Erik Sellgren wrote: I am trying to setup wireless authentication through my mikrotik router using freeradius with mysql and daloradius. I have the server setup and working, I can use NTradtest from my pc and I get Access-Accept messages in return with my cleartext user/password, username

Freeradius + MySQL + Daloradius

2013-04-09 Thread Erik Sellgren
I am trying to setup wireless authentication through my mikrotik router using freeradius with mysql and daloradius. I have the server setup and working, I can use NTradtest from my pc and I get Access-Accept messages in return with my cleartext user/password, username userclear password clear

RE: Getting clients from a mysql table

2013-03-26 Thread Peter Kaagman
Try adding the SQL module to the jnstantiate section of radiusd.conf From the radiusd -X output: including configuration file /etc/raddb/modules-enabled/logintime including configuration file /etc/raddb/eap.conf including configuration file /etc/raddb/sql.conf Not sure what you mean by

Re: Getting clients from a mysql table

2013-03-26 Thread Phil Mayers
On 03/26/2013 12:52 PM, Peter Kaagman wrote: Try adding the SQL module to the jnstantiate section of radiusd.conf From the radiusd -X output: including configuration file /etc/raddb/modules-enabled/logintime including configuration file /etc/raddb/eap.conf including configuration file

Re: Getting clients from a mysql table

2013-03-26 Thread A . L . M . Buxey
Hi, Try adding the SQL module to the jnstantiate section of radiusd.conf From the radiusd -X output: including configuration file /etc/raddb/modules-enabled/logintime including configuration file /etc/raddb/eap.conf including configuration file /etc/raddb/sql.conf edit the dialup.conf

Re: Getting clients from a mysql table

2013-03-26 Thread Olivier Beytrison
On 26.03.2013 13:52, Peter Kaagman wrote: Try adding the SQL module to the jnstantiate section of radiusd.conf From the radiusd -X output: including configuration file /etc/raddb/modules-enabled/logintime including configuration file /etc/raddb/eap.conf including configuration file

RE: Getting clients from a mysql table

2013-03-26 Thread Peter Kaagman
Not sure what you mean by that... to me it looks like sql.conf is loaded Yes the configuration file is loaded. But it seems that you do not use the sql module anywhere within your virtual server. If you look at your debug output, you won't find a Module: Instantiating module sql If

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Muhammad Nadeem
Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory It seems that your mysql drivers have not been installed successfully, thanks to freeradius, it has the option to install mysql server along free

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Iftakhul Anwar
I've installed mysql-server on my system even before i installed freeradius server. Any another tips to solve this ? On Fri, Mar 8, 2013 at 2:59 PM, Muhammad Nadeem mnadeem8...@gmail.comwrote: Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Muhammad Nadeem
Ok man.. set LD_LIBRARY_PATH to your mysql drivers,, like for oracle it will be SET PATH=LD_LIBRARY_PATH=$ORACLE_HOME/lib On Fri, Mar 8, 2013 at 1:02 PM, Iftakhul Anwar an...@meruvian.org wrote: I've installed mysql-server on my system even before i installed freeradius server. Any another

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Fajar A. Nugraha
If you install using packages, it's usually contained on separate packages. For example: http://packages.ubuntu.com/search?suite=quantalkeywords=freeradius i.e. freeradius-mysql, freeradius-ldap. -- Fajar On Fri, Mar 8, 2013 at 7:02 PM, Iftakhul Anwar an...@meruvian.org wrote: I've

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Alan Buxey
As Fajar says, some distros split up the functions into separate packages (so you don't need to install loads of things just to have a basic server) use your package manager to find/install the sub packages alan -- This smartphone uses free WiFi around the world with eduroam, now that's what

Re: Freeradius with either LDAP or Mysql Error lib not found

2013-03-08 Thread Iftakhul Anwar
HI All, I just recompile my freeadius with specific directory library.I use command : ./configure --with-mysql-lib-dir=/usr/lib/mysql --with-ldap-lib-dir=/usr/lib/ldap Now ldap and mysql running well :D Thanks all On Fri, Mar 8, 2013 at 3:41 PM, Alan Buxey a.l.m.bu...@lboro.ac.uk wrote

hashed username in MySQL?

2013-03-08 Thread Adam Moffett
I had a user set up in the users file and it was all working. Now I'm experimenting with MySQL and in the debug output I'm looking at the SQL queries and instead of the actual clear text username I'm getting this: AE576AA1F2CB984F6D07750C01C0EAF9 ...which I assume is the username hashed

Re: hashed username in MySQL?

2013-03-08 Thread Alan DeKok
Adam Moffett wrote: I had a user set up in the users file and it was all working. Now I'm experimenting with MySQL and in the debug output I'm looking at the SQL queries and instead of the actual clear text username I'm getting this: AE576AA1F2CB984F6D07750C01C0EAF9 ...which I assume

Freeradius with either LDAP or Mysql Error lib not found

2013-03-07 Thread Iftakhul Anwar
Hi All I just try to config freeradius using either Mysql or LDAP. But i get same error like bellow : [errror Mysq] Fri Mar 8 13:44:46 2013 : Error: Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory Fri Mar 8 13:44:46 2013

Re: MAC-Auth + Freeradius + MySQL Database

2013-02-24 Thread Russell Mike
authentication is just checking if the MAC address is in a known list. Terminology matters. Using the right terminology means that the solution is usually simple. Using the wrong terminology means you're using the wrong design. How to store MACs in MySQL database. Perhaps, i need to create

RE: MAC-Auth + Freeradius + MySQL Database

2013-02-24 Thread David Peterson
+ Freeradius + MySQL Database Greetings Dear Alan D. List Members, First of all, thank you very much for developing such application. I need help, i have functional Freeradius server with MySQL backend. i have been asked to add MAC address authentication support for the servers. i googled the topic

Re: MAC-Auth + Freeradius + MySQL Database

2013-02-24 Thread Alan DeKok
Russell Mike wrote: Thanks for guidelines. exactly, as you stated I simple want to store MAC address somewhere compair against the request. Can they be in radcheck? I wouldn't do that. Just create your own table of MAC addresses. If all you want is to list known MACs, you can do that with

Re: MAC-Auth + Freeradius + MySQL Database

2013-02-24 Thread Russell Mike
On Sun, Feb 24, 2013 at 2:20 PM, Alan DeKok al...@deployingradius.comwrote: Russell Mike wrote: Thanks for guidelines. exactly, as you stated I simple want to store MAC address somewhere compair against the request. Can they be in radcheck? I wouldn't do that. Just create your own

Re: MAC-Auth + Freeradius + MySQL Database

2013-02-24 Thread Russell Mike
On Sun, Feb 24, 2013 at 1:55 PM, David Peterson dav...@wirelessconnections.net wrote: I know of one person doing something similar to what you are looking to do. If your NAS sends the MAC of the device with the EAP request, you can extract the MAC from the request using unlang and check that

RE: MAC-Auth + Freeradius + MySQL Database

2013-02-24 Thread David Peterson
-WirelessConnections; FreeRadius users mailing list Subject: Re: MAC-Auth + Freeradius + MySQL Database On Sun, Feb 24, 2013 at 1:55 PM, David Peterson dav...@wirelessconnections.net wrote: I know of one person doing something similar to what you are looking to do. If your NAS sends

Re: MAC-Auth + Freeradius + MySQL Database

2013-02-24 Thread Russell Mike
*Subject:* Re: MAC-Auth + Freeradius + MySQL Database ** ** ** ** ** ** On Sun, Feb 24, 2013 at 1:55 PM, David Peterson dav...@wirelessconnections.net wrote: I know of one person doing something similar to what you are looking to do. If your NAS sends the MAC of the device

MAC-Auth + Freeradius + MySQL Database

2013-02-23 Thread Russell Mike
Greetings Dear Alan D. List Members, First of all, thank you very much for developing such application. I need help, i have functional Freeradius server with MySQL backend. i have been asked to add MAC address authentication support for the servers. i googled the topic and got many many mail

Re: MAC-Auth + Freeradius + MySQL Database

2013-02-23 Thread Alan DeKok
is in a known list. Terminology matters. Using the right terminology means that the solution is usually simple. Using the wrong terminology means you're using the wrong design. How to store MACs in MySQL database. Perhaps, i need to create additional table to store MAC, Honestly, i am not sure how to go

Mysql - radusergroup

2013-02-12 Thread Neven
Hi, i'm using Freeradius 2, fedora16, mysql 5. 500 000 different users in table. i have a user in table radcheck (username and pass), i add that user in radusergroup, then I add usergroup in radgroupcheck and add attributes for that group. That works well as far as i know. Question: Can I add

move /etc/raddb/users file to mysql

2013-01-28 Thread Stefan König
Hello List, I inherited an old freeradius 1.1.8 system which is configured to use a mysql DB. So far so good, but now I discovered, that someone also created a /etc/raddb/users file with some DEFAULT information in it. The funny thing is, that I have also some DEFAULT information in my DB

Re: move /etc/raddb/users file to mysql

2013-01-28 Thread Alan DeKok
Stefan König wrote: I inherited an old freeradius 1.1.8 system which is configured to use a mysql DB. Upgrade So far so good, but now I discovered, that someone also created a /etc/raddb/users file with some DEFAULT information in it. The funny thing is, that I have also some DEFAULT

freeradius+mysql

2012-12-18 Thread nanthitha shanmugam
Hi, I am using mysql with free radius for user authorization and accounting with assignment of ip pools from iptables in mysql. These all are working. But, I would like to know if we can bypass the authorization phase with mysql and use only ip pool assignment. Can you help in this part. Like

Need Help to Troubleshoot MySQL Auth FreeRadius 2.1.X

2012-12-15 Thread Prabhpal S. Mavi
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

Re: Need Help to Troubleshoot MySQL Auth FreeRadius 2.1.X

2012-12-15 Thread Alan DeKok
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

Problem with MAC valitation + MySQL

2012-11-29 Thread Andres Gomez Ruiz
Hi everybody!! I'm using Freeradius since 6 months ago, and It works great. I'm Using freeradus + MySQL to store my users data in a database and authenticate it with an user and a password. Now I Have to attach to each user, 3 MAC-Address, so I'm editting my database (radcheck table

FreeRADIUS + Mysql + xl2tpd and pptpd

2012-11-15 Thread Dmitry Korzhevin
Hello, Can anyone please share working configs for freeradius + xl2tpd or pptpd? Radius server is already configured, and works with mysql backend + strongSwan ipsec (dirrect connection). But, i try several pptpd / xl2tpd configurations, and suddenly they doesn't work.. I even try

Re: FreeRADIUS + Mysql + xl2tpd and pptpd

2012-11-15 Thread Dmitry Korzhevin
, and works with mysql backend + strongSwan ipsec (dirrect connection). But, i try several pptpd / xl2tpd configurations, and suddenly they doesn't work.. I even try configuration from wiki: http://wiki.freeradius.org/config/PopTop And it is not working. I use Debian 6.0.6 x86_64, freeradius

Re: FreeRADIUS + Mysql + xl2tpd and pptpd

2012-11-15 Thread Matthew Newton
freeradius server works without any problems, while xl2tpd - doesn't 15.11.2012 12:52, Dmitry Korzhevin пишет: Hello, Can anyone please share working configs for freeradius + xl2tpd or pptpd? Radius server is already configured, and works with mysql backend + strongSwan ipsec (dirrect

Re: ChilliSpot-UAM-Allowed on witch mysql table ?

2012-11-09 Thread yzy-oui-fi
Ok i get farther, solving dictionary missing attribute. The problem is that this doesn't give what i was looking for. this attribute is only available for granted user, and tried to solve the uamallowed issue under DD-WRT box. I mean i want to replace the UAM allowed embed in DD-WRT chillispot

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
should prove that. mysql select username,acctstarttime,acctstoptime,acctinputoctets from radacct; +--+-+-+-+ | username | acctstarttime | acctstoptime| acctinputoctets

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

Mysql, Accounting and DialupAdmin

2012-11-07 Thread Erich Titl
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 blurry to me. Could someone point me to the right dos for the following? 1) I

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

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

  1   2   3   4   5   6   7   8   9   10   >