[OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Antonio Modesto
node's data files [mysqld] [mysqld] I know that this is not the best place to talk about database problems, but I think that there is a lot of people here that use Freeradius with MySQL Cluster that could help me. Thanks in advance. - List info/subscribe/unsubscribe? See http

Re: [OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Alan Buxey
Hi, I know that this is not the best place to talk about database problems, but I think that there is a lot of people here that use Freeradius with MySQL Cluster that could help me. used to - moved to postgres. anyway, there *are* other more useful resources for using MySQL: http

Re: [OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Fajar A. Nugraha
2012/2/27 Antonio Modesto mode...@isimples.com.br: Good Morning, I am doing some tests with MySQL Cluster, and I want to migrate my backend to it. But I am having some troubles/doubts with it. When I use a empty radius database, it works ok. But when I try to import my current database to

RE: [OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread David Peterson
=wirelessconnections.net@lists.freera dius.org] On Behalf Of Fajar A. Nugraha Sent: Monday, February 27, 2012 8:20 AM To: FreeRadius users mailing list Subject: Re: [OFF-TOPIC] Freeradius and MySQL Cluster 2012/2/27 Antonio Modesto mode...@isimples.com.br: Good Morning, I am doing some tests with MySQL Cluster, and I

Re: [OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Antonio Modesto
On Mon, 2012-02-27 at 20:20 +0700, Fajar A. Nugraha wrote: 2012/2/27 Antonio Modesto mode...@isimples.com.br: Good Morning, I am doing some tests with MySQL Cluster, and I want to migrate my backend to it. But I am having some troubles/doubts with it. When I use a empty radius database,

Re: [OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Fajar A. Nugraha
On Mon, Feb 27, 2012 at 9:48 PM, Antonio Modesto mode...@isimples.com.br wrote: I didn't know about the memory limit. So if I have a 10GB database, Must I have, at least, 10GB configured for each cluster node? David posted a link which can help assign memory on data nodes. Short version is: -

Re: [OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Antonio Modesto
On Mon, 2012-02-27 at 22:09 +0700, Fajar A. Nugraha wrote: On Mon, Feb 27, 2012 at 9:48 PM, Antonio Modesto mode...@isimples.com.br wrote: I didn't know about the memory limit. So if I have a 10GB database, Must I have, at least, 10GB configured for each cluster node? David posted a link

Documentation for Setting up Freeradius with MYSQL

2011-04-21 Thread Jaikanth Krishnaswamy
Hi All, I have a requirement to set up freeradius with MySQL in my environment. I was able to find the DDL Script required for MYSQL Database to be built. Is there a complete How-to from Scratch for compiling free radius to work with MySQL on Ubuntu. Please advice. Thanks JK - List info/subscribe

Re: Freeradius 2 + MySQL + MD5 hash don't work

2011-03-18 Thread joao...@gmail.com
Okay folks, I appreciate the help. Already managed to solve. Basically there were two details, the first was as the supplicant was trying to authenticate, it was either use MSCHAPv2, but the passwords were encrypted at the base with MD5, just like CHAP authentication would not work . By forcing

Freeradius 2 + MySQL + MD5 hash don't work

2011-03-17 Thread joao...@gmail.com
Hello, Someone already has implemented two freeradius with mysql I'm using version 2.1.10 of freeradius on a debian 6 If I try a plaintext based authentication, everything works. But if I try to do an authentication with an MD5 password, I get the message seguite: *[pap] ERROR: You set 'Auth

Re: Freeradius 2 + MySQL + MD5 hash don't work

2011-03-17 Thread Phil Mayers
On 03/17/2011 08:01 PM, joao...@gmail.com wrote: *[pap] ERROR: You set 'Auth-Type = PAP' for a request that does not contain a User-Password attribute!* This is very clear: mysql select * from radgroupcheck; +++---++---+ | id | groupname | attribute | op

Re: Freeradius 2 + MySQL + MD5 hash don't work

2011-03-17 Thread joao...@gmail.com
Dear Phil, By removing this option, it tries to authenticate with EAP/MSCHAPv2, and also fails. Authentication is what I'm doing wireless network. Below is the result of debugging when I removed the Auth-Type PAP table radgroupcheck: [sql_visitantes] expand: %{Stripped-User-Name} - usql2

Re: Freeradius 2 + MySQL + MD5 hash don't work

2011-03-17 Thread Alan Buxey
Hi, [pap] ERROR: You set 'Auth-Type = PAP' for a request that does not contain a User-Password attribute! its fair enough. you've set Auth-Type = PAP why? alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius 2 + MySQL + MD5 hash don't work

2011-03-17 Thread Alan Buxey
Hi, Dear Phil, By removing this option, it tries to authenticate with EAP/MSCHAPv2, and also fails. no...it works - but you havent got the 'sql' module enabled in the inner-tunnel (which is where the server goes to when its doing EAP) put sql into the inner-tunnel virtual-server

dhcp over freeradius with mysql

2011-02-18 Thread Ehart, Norbert
hi, i would like to implement dhcp over radius! is there any mysql support? my dhcp config looks like this! === snip == shared-network X { if substring(option vendor-class-identifier, 0, 2) = SN { next-server X.X.X.X; filename = concat(/inalp/, option vendor-class-identifier, _,

Re: Automatically Generating Expiration - Freeradius 2.1.9 / mysql 5.1 / dialup admin

2010-11-25 Thread YvesDM
On Wed, Nov 24, 2010 at 7:50 AM, mikal m...@atceast.com wrote: What I'm trying to do is enable a non-technical person to create temporary, guest like accounts using the dialup admin interface.  The accounts will be created as needed, they need to expire within a predetermined time frame(s)

RE: Automatically Generating Expiration - Freeradius 2.1.9 / mysql 5.1 / dialup admin

2010-11-24 Thread Ben Wiechman
@lists.freeradius.org] On Behalf Of mikal Sent: Wednesday, November 24, 2010 12:51 AM To: freeradius-users@lists.freeradius.org Subject: Automatically Generating Expiration - Freeradius 2.1.9 / mysql 5.1 / dialup admin What I'm trying to do is enable a non-technical person to create temporary

Automatically Generating Expiration - Freeradius 2.1.9 / mysql 5.1 / dialup admin

2010-11-23 Thread mikal
What I'm trying to do is enable a non-technical person to create temporary, guest like accounts using the dialup admin interface. The accounts will be created as needed, they need to expire within a predetermined time frame(s) and I'm trying to avoid asking the person creating the accounts to be

Re: Help: 802.1x with freeRadius and mySql database

2010-11-18 Thread Alan Buxey
Hi, Then I start to use mySql database, instead of clients.conf and users. I followed the instructions from this link [1]http://wiki.freeradius.org/SQL_HOWTO. I use the radtest command to test the username/password. It works fine. Then I use the Cisco switch to test the

Help: 802.1x with freeRadius and mySql database

2010-11-17 Thread Xuan Sun
Hi Everyone I have set up a freeRadius in Ubuntu server 10.0.4. I also set up a Cisco switch as a NAS and enable 802.1x in the switch port. I used the configuration first (clients.conf, users). The 802.1x authentication just works fine. Then I start to use mySql database, instead of clients.conf

Cisco LNS with Freeradius and MySQL

2010-10-18 Thread Stephane MAGAND
Hi I request a small help for my configuration, sorry for my english: I have a cisco router with VRF I have a Freeradius server with sql I have a lot of Adsl user in L2TP. I want add one user to a specific vrf, i have added to the mysql table: INSERT INTO `radgroupreply` VALUES (9,

Re: Cisco LNS with Freeradius and MySQL

2010-10-18 Thread Phil Mayers
On 10/18/2010 06:07 PM, Stephane MAGAND wrote: but when the user connect, that's don't work ... See the FAQ for it doesn't work. Second question: I use sqlippool for dynamic IP, if i want specify a IP to a username (static) what is the process ? create a specific group ? You can assign

Re: Cisco LNS with Freeradius and MySQL

2010-10-18 Thread Stephane MAGAND
2010/10/18 Phil Mayers p.may...@imperial.ac.uk: On 10/18/2010 06:07 PM, Stephane MAGAND wrote: but when the user connect, that's don't work ... See the FAQ for it doesn't work. Thanks for your answer Phil, but i don't see in the FAQ a answer at my question. Do you create the VRF on the

Re: Cisco LNS with Freeradius and MySQL

2010-10-18 Thread Stephane MAGAND
Ok i have resolved my problems ;=) 2010/10/18 Stephane MAGAND stmagconsult...@gmail.com: 2010/10/18 Phil Mayers p.may...@imperial.ac.uk: On 10/18/2010 06:07 PM, Stephane MAGAND wrote: but when the user connect, that's don't work ... See the FAQ for it doesn't work. Thanks for your

Re: Cisco LNS with Freeradius and MySQL

2010-10-18 Thread Phil Mayers
On 10/18/2010 06:51 PM, Stephane MAGAND wrote: 2010/10/18 Phil Mayersp.may...@imperial.ac.uk: On 10/18/2010 06:07 PM, Stephane MAGAND wrote: but when the user connect, that's don't work ... See the FAQ for it doesn't work. I meant literally the FAQ item It still doesn't work, which

Re: configuration freeradius with mysql

2010-05-14 Thread David Seira
Have you decommented the $INCLUDE sql.conf line in radiusd.conf? I had the same problem when I compiled freeradius-2.1.8. If I compiled freeradius without libmysqlclient15-dev package the problem appeared. Try it. 2010/5/14 dorra aa dj_dido2...@hotmail.com hi i installed mysql. and i

freeradius with mysql failed

2010-05-13 Thread dorra aa
hi i installed mysql. and i modify in /etc/freeradius/sql.conf: readclients=yes also, i decommented in /etc/freeradius/radiusd.conf: accounting { sql} authorize {... sql} i run again freeradius -X: but it seems failed because of sql: this is the output [...] sql: postauth_query = INSERT

Re: problem with reading user data in Freeradius with Mysql

2010-04-30 Thread David Seira
You can try to put Password attribute instead of Cleartext-Password. The operator is also important: user Password == pass 2010/4/29 John Dennis jden...@redhat.com On 04/29/2010 02:27 PM, VU VAN HUNG wrote: Hi all, I got a problem with freeradius and mysql. My freeradius server cannot read

Re: problem with reading user data in Freeradius with Mysql

2010-04-30 Thread Alan DeKok
David Seira wrote: You can try to put Password attribute instead of Cleartext-Password. Please no. Don't use Password or User-Password. The operator is also important: user Password == pass Again, no. userCleartext-Password := password The FAQ has an example of this. Alan

Re: problem with reading user data in Freeradius with Mysql

2010-04-30 Thread David Seira
I use MD5 pass and SHA pass: user SHA-Password := pass user MD5-Password := pass 2010/4/30 Alan DeKok al...@deployingradius.com David Seira wrote: You can try to put Password attribute instead of Cleartext-Password. Please no. Don't use Password or User-Password. The operator is

problem with reading user data in Freeradius with Mysql

2010-04-29 Thread VU VAN HUNG
Hi all, I got a problem with freeradius and mysql. My freeradius server cannot read data from radcheck table. It notice that No Cleartext-Password's Configured, even if I totally set Attribute field in radcheck table is Cleartext-Password. Could someones help me solve this problem ? Hung

Re: problem with reading user data in Freeradius with Mysql

2010-04-29 Thread John Dennis
On 04/29/2010 02:27 PM, VU VAN HUNG wrote: Hi all, I got a problem with freeradius and mysql. My freeradius server cannot read data from radcheck table. It notice that No Cleartext-Password's Configured, even if I totally set Attribute field in radcheck table is Cleartext-Password. Could

Freeradius AND Mysql ? or Freeradius-mysql package??? or both?

2009-12-02 Thread C. Diego Raffaelli A.
). 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

Re: Freeradius AND Mysql ? or Freeradius-mysql package??? or both?

2009-12-02 Thread tnt
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

Re: Remote access control in freeradius with mysql

2009-11-30 Thread cktan
Dear all, Problem solved. Using Auth-Type attribute in radcheck table solve the problem. Cheers. cktan wrote: Dear all, I've a freeradius server running with LDAP as the Authentication and Authorization where else Accounting running on Mysql. It was working well at the moment and I'm

Remote access control in freeradius with mysql

2009-11-29 Thread cktan
Dear all, I've a freeradius server running with LDAP as the Authentication and Authorization where else Accounting running on Mysql. It was working well at the moment and I'm looking to migrate from LDAP to run fully in Mysql. Question is I need to have control on remote access for certain

FreeRADIUS Cluster MySQL Webinar: online!

2009-10-14 Thread Alan DeKok
The webinar is now recorded, and available online: http://www.mysql.com/news-and-events/on-demand-webinars/display-od-419.html Anyone wanting to know more about cluster performance should check it out. Alan DeKok. - List info/subscribe/unsubscribe? See

Reminder: Webinar with FreeRADIUS and MySQL: Sept. 30

2009-09-28 Thread Alan DeKok
announcement is below. Alan DeKok. +++ FreeRADIUS MySQL Cluster: Scalable and Highly Available AAA Services Wednesday, September 30, 2009 As network use grows and services become more dynamic, so existing Authentication, Authorization

Re: unable to connection freeradius with mysql

2009-08-05 Thread Alan DeKok
shivashankar wrote: i am useing freeradius2.1.6 and mysql5.0 on solaris10. when ever i start the server radiusd -X . i am getting below problem. i think it is not connected to mysql.plz help me how to connect READ the debug messages? rlm_sql (sql): Attempting to connect rlm_sql_mysql

RE: unable to connection freeradius with mysql

2009-08-05 Thread Ben Wiechman
@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Wednesday, August 05, 2009 3:30 AM To: FreeRadius users mailing list Subject: Re: unable to connection freeradius with mysql shivashankar wrote: i am useing freeradius2.1.6 and mysql5.0 on solaris10. when ever i start the server radiusd -X . i

unable to connection freeradius with mysql

2009-08-04 Thread shivashankar
address * port 1814 Ready to process requests. -- View this message in context: http://www.nabble.com/unable-to-connection-freeradius-with-mysql-tp24820558p24820558.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http

FreeRadius and MySql custom attributes

2008-11-05 Thread Aaron Seibert
Hello, I work in the NOC of an isp. Currently we have VIRCOM Radius servers set up to authenticate against a MySql server cluster, but we'd like to switch to FreeRadius. There is a profiles column that contains a few different service definitions (slip for SlipStream, newsgroups, a combo

Re: FreeRadius and MySql custom attributes

2008-11-05 Thread Stephen Bowman
have created a dictionary.slipstream file with the following: VENDOR Slipstream 7000 ATTRIBUTE SlipStream-Auth True string Slipstream However, that will not authenticate the slip client. If I hardcode the attribute into the auth_reply query, the client is then authenticated. (Query =

Re: FreeRadius and MySql custom attributes

2008-11-05 Thread Aaron Seibert
I'll also add that the dictionary.slipstream is included in the dictionary file. FreeRadius running on freeBSD On Wed, 2008-11-05 at 12:14 -0500, Aaron Seibert wrote: Hello, I work in the NOC of an isp. Currently we have VIRCOM Radius servers set up to authenticate against a MySql server

Re: FreeRadius and MySql custom attributes

2008-11-05 Thread Aaron Seibert
Posting relevant sections along with an explanation - I was doing some fiddling in between posting and responding here. Here is the current setup, as I was trying to make it work: dictionary.slipstream - VENDOR Slipstream 7000 ATTRIBUTE Profile 1 string Slipstream reply query in mssql.conf -

Re: FreeRadius and MySql custom attributes

2008-11-05 Thread Stephen Bowman
authorize_reply_query = SELECT '',Username,'Profile',Profiles,':=' FROM radius_auth WHERE Username = '%{SQL-User-Name}' It's doing exactly what you tell it to do. query: SELECT '',Username,'Profile',Profiles,':=' FROM radius_auth WHERE Username = '[EMAIL PROTECTED]' There's the query

Re: FreeRadius and MySql custom attributes

2008-11-05 Thread Aaron Seibert
Becuase the database is already established with thousands of customers We're looking to migrate from an existing VOPRadius system. The MsSql database is tied into our account management system as well On Wed, 2008-11-05 at 16:45 -0500, Stephen Bowman wrote:

Re: FreeRadius and MySql custom attributes

2008-11-05 Thread Venkatesh K
You can extend the rlm_sql module to read from your schema though it is some work. Alternatively you can go with perl and scripting. I believe extending rlm_sql module to read your schema and generate AVP's will give better performance, but I might be wrong. I have taken this path for a custom

Re: FreeRadius and MySql custom attributes

2008-11-05 Thread Aaron Seibert
I think what I'll do is just change the reply query to pull from the Profiles table so the query would look like id,username,profiles,'true',';='. Then I'll change the dictionary file so the Slip profile gets the correct attributes, and true will be passed tith each of the account types On

Problems with Freeradius and MySQL

2008-10-30 Thread Andre Luiz B. Lemos
Hello, my name is Andre, I need your help for configuration of the Freeradius with MySQL. I can use the password in the tables of mysql with anything crypt, but I dont know the configuration. Please help-me. Sorry for my bad English. I am Brazilian. Andre Luiz B. Lemos- List info/subscribe

Re: Problems with Freeradius and MySQL

2008-10-30 Thread Leander S.
know i.e. isn't it possible to youse crypted passwords in combination with ms-chap ... Good luck! Regards, Leander Andre Luiz B. Lemos schrieb: Hello, my name is Andre, I need your help for configuration of the Freeradius with MySQL. I can use the password in the tables of mysql

Re: Problems with Freeradius and MySQL

2008-10-30 Thread tnt
Hello, my name is Andre, I need your help for configuration of the Freeradius with MySQL. I can use the password in the tables of mysql with anything crypt, but I dont know the configuration. There is nothing to configure. Just use appropriate password attribute. If you are using crypt - Crypt

Re: access rights for some users ou users groups with freeradius and mysql

2008-10-13 Thread tnt
If I understood you well, you want some users or groups to have access from NAS1 but not from NAS2. Add attribute NAS-IP Address with appropriate value to radcheck or radgroupcheck table. Ivan Kalik Kalik Informatika ISP Dana 13/10/2008, BADAOUI Nasr-Eddine (P) [EMAIL PROTECTED] piše: Hi,

access rights for some users ou users groups with freeradius and mysql

2008-10-13 Thread BADAOUI Nasr-Eddine (P)
Hi, I'd like to know how to authorize some users or users's group created in mysql tables can logged only on some mysql's clients, with freeradius. Mysql's tables are : nas table for clients radcheck table for users radgropucheck table usergroup table many thanks - List

Re: Startdate for sessions in FreeRadius with MySql?

2008-10-09 Thread Bladan2000
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- View this message in context: http://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with-MySql--tp19837587p19892931.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info

Re: Startdate for sessions in FreeRadius with MySql?

2008-10-09 Thread Marinko Tarlac
/users.html -- View this message in context: http://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with-MySql--tp19837587p19892931.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: Startdate for sessions in FreeRadius with MySql?

2008-10-09 Thread tnt
://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with-MySql--tp19837587p19892931.html Sent from the FreeRadius - User mailing list archive at Nabble.com. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org

Startdate for sessions in FreeRadius with MySql?

2008-10-08 Thread Bladan2000
://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with-MySql--tp19837587p19837587.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: Startdate for sessions in FreeRadius with MySql?

2008-10-08 Thread tnt
Any thoughts? Don't create the username before the startdate. There is absolutely no reason for it to be in the database before it. Make a script that creates the user entry when startdate is reached. Ivan Kalik Kalik Informatika ISP - List info/subscribe/unsubscribe? See

Re: freeradius 1 mysql Attribute

2008-02-29 Thread Ivan Kalik
Most likely. Can you post the content of your dictionary file? Or download 2.0.2 and see if that attribute is in dictionary.slipstream. If it is include it with the other dictionaries. Ivan Kalik Kalik Informatika ISP Dana 29/2/2008, Dustin Schuemann [EMAIL PROTECTED] piše: Can I just add it

Re: freeradius 1 mysql Attribute

2008-02-29 Thread Dustin Schuemann
Ok I found that. Where do I add the stuff in my mysql database to allow that attribute. On Feb 29, 2008, at 5:19 AM, Ivan Kalik wrote: Most likely. Can you post the content of your dictionary file? Or download 2.0.2 and see if that attribute is in dictionary.slipstream. If it is include

freeradius 1 mysql Attribute

2008-02-28 Thread Dustin Schuemann
Im working with dialup provider that is acting as the nas and they are authenticating off my radius server. Authentication works fine. They have this fastnet program that is supposed to make the internet faster. Attached is what they told me to do. I have added it to the dynamic group in

Re: freeradius 1 mysql Attribute

2008-02-28 Thread Ivan Kalik
Add to your dictionary file at /usr/local/etc/raddb/dictionary: Same file in Freeradius. VENDORATTR 7000 Slipstream-Auth 1 string You will find this in there: #ATTRIBUTE My-Local-String 3000string #ATTRIBUTE My-Local-IPAddr 3001ipaddr #ATTRIBUTE

Re: freeradius 1 mysql Attribute

2008-02-28 Thread Dustin Schuemann
I don't have anything like this in my dictionary. This is free radius 1 On Feb 28, 2008, at 5:51 PM, Ivan Kalik wrote: Add to your dictionary file at /usr/local/etc/raddb/dictionary: Same file in Freeradius. VENDORATTR 7000 Slipstream-Auth 1 string You will find this in there:

Re: freeradius 1 mysql Attribute

2008-02-28 Thread Ivan Kalik
So is this. 1.1.7 file /usr/local/etc/raddb/dictionary. Ivan Kalik Kalik Informatika ISP Dana 28/2/2008, Dustin Schuemann [EMAIL PROTECTED] piše: I don't have anything like this in my dictionary. This is free radius 1 On Feb 28, 2008, at 5:51 PM, Ivan Kalik wrote: Add to your dictionary

Re: freeradius 1 mysql Attribute

2008-02-28 Thread Dustin Schuemann
This is version 1.1.3 I don't see this anywhere in this file. #ATTRIBUTE My-Local-String 3000string #ATTRIBUTE My-Local-IPAddr 3001ipaddr #ATTRIBUTE My-Local-Integer3002integer On Feb 28, 2008, at 8:16 PM, Ivan Kalik wrote: So is this.

Re: freeradius 1 mysql Attribute

2008-02-28 Thread Dustin Schuemann
Can I just add it ? On Feb 28, 2008, at 5:51 PM, Ivan Kalik wrote: Add to your dictionary file at /usr/local/etc/raddb/dictionary: Same file in Freeradius. VENDORATTR 7000 Slipstream-Auth 1 string You will find this in there: #ATTRIBUTE My-Local-String 3000string

Re: freeradius 1 mysql Attribute

2008-02-28 Thread Scott Lambert
On Thu, Feb 28, 2008 at 05:08:46PM -0500, Dustin Schuemann wrote: Im working with dialup provider that is acting as the nas and they are authenticating off my radius server. Authentication works fine. They have this fastnet program that is supposed to make the internet faster. Attached

rlm_sql_mysql.so where do I locate this file and its associated files for CentOS to run freeRadius and MySQL

2008-02-14 Thread johnson elangbam
Hi, I am trying to build a radius with free radius 2.0.0 using MySql 4.1.2and I am getting the following errors rlm_sql (sql): Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory rlm_sql (sql): Make sure it (and all its dependent

Re: rlm_sql_mysql.so where do I locate this file and its associated files for CentOS to run freeRadius and MySQL

2008-02-14 Thread Alan DeKok
johnson elangbam wrote: Hi, I am trying to build a radius with free radius 2.0.0 using MySql 4.1.2 and I am getting the following errors rlm_sql (sql): Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory This is in the FAQ.

Re: Don't work freeradius with MySQL.

2008-01-24 Thread A . L . M . Buxey
hi, turn on the SQL debug logging in FreeRADIUS and see what the output of the SQl was alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Don't work freeradius with MySQL.

2008-01-24 Thread tnt
rad_recv: Access-Request packet from host 192.168.1.7:1119, id=0, length=44 User-Name = fred User-Password = wilma Processing the authorize section of radiusd.conf modcall: entering group authorize for request 0 modcall[authorize]: module preprocess returns ok for request 0

Don't work freeradius with MySQL.

2008-01-23 Thread mohsen rahmanian
Hi dears, I install freeradius, MySQL on Ubuntu 7 and work correctly with file authentication, but where follow http://wiki.freeradius.org/SQL_HOWTO; instruction don't get any response. my output when run 'freeradius -x' are: Starting - reading configuration files ... Using deprecated

Re: Don't work freeradius with MySQL.

2008-01-23 Thread tnt
Debug with capital X == radiusd -X. Ivan Kalik Kalik Informatika ISP Dana 23/1/2008, mohsen rahmanian [EMAIL PROTECTED] piše: Hi dears, I install freeradius, MySQL on Ubuntu 7 and work correctly with file authentication, but where follow http://wiki.freeradius.org/SQL_HOWTO; instruction don't

Re: Don't work freeradius with MySQL.

2008-01-23 Thread mohsen rahmanian
we see a request. 2008/1/23 [EMAIL PROTECTED]: Debug with capital X == radiusd -X. Ivan Kalik Kalik Informatika ISP Dana 23/1/2008, mohsen rahmanian [EMAIL PROTECTED] piše: Hi dears, I install freeradius, MySQL on Ubuntu 7 and work correctly with file authentication, but where

Re: data limit in Mikrotik with Freeradius and Mysql

2007-09-21 Thread ram
Hi iam trying to achive the same any inputs ram On 9/20/07, ravi sawant [EMAIL PROTECTED] wrote: Hi Does anyone have solution for limiting users with data traffic. I have working setup of Mikrotik with freeradius and mysql. Have searched on net and found one solution but I can put

Re: data limit in Mikrotik with Freeradius and Mysql

2007-09-21 Thread Guy Fraser
[EMAIL PROTECTED] wrote: Hi Does anyone have solution for limiting users with data traffic. I have working setup of Mikrotik with freeradius and mysql. Have searched on net and found one solution but I can put limit to max 4

data limit in Mikrotik with Freeradius and Mysql

2007-09-20 Thread ravi sawant
Hi Does anyone have solution for limiting users with data traffic. I have working setup of Mikrotik with freeradius and mysql. Have searched on net and found one solution but I can put limit to max 4 GB data. After 4 GB the counter resets to 0. I know the reason of that. It's b'coz of the values

Re: data limit in Mikrotik with Freeradius and Mysql

2007-09-20 Thread tnt
Upgrade to 1.1.7 or: http://www.netexpertise.eu/en/FreeRadius/GigaWordsSupport.html Ivan Kalik Kalik Informatika ISP Dana 20/9/2007, ravi sawant [EMAIL PROTECTED] piše: Hi Does anyone have solution for limiting users with data traffic. I have working setup of Mikrotik with freeradius

Re: Strange behaviour of rlm_chap (freeradius 1.1.7+mysql)

2007-09-06 Thread Dan Searle
Hi, Hello? Is there anybody out there? Can someone who knows how CHAP works please explain to me how this could be happening? Does a CHAP challenge time-out after a certain amount of time? Does the rlm_chap module hold a copy of old CHAP challenge's and prevent the same one being re-used to stop

Re: Strange behaviour of rlm_chap (freeradius 1.1.7+mysql)

2007-09-06 Thread tnt
And how can anyone help? You have deleted the most relevant parts of the debug (CHAP attributes and the password, which, according to the server, are not the same in both cases). If you don't want to use data from a real user, create a test one and post that. Ivan Kalik Kalik Informatika ISP

Re[2]: Strange behaviour of rlm_chap (freeradius 1.1.7+mysql)

2007-09-06 Thread Dan Searle
Hi, I can assure you the password is exactly the same in both cases. I'll try and setup a test user later on and post the results. But the passwords in the two traces I posted below were the same. Dan... Thursday, September 6, 2007, 10:47:34 AM, you wrote: And how can anyone help? You have

Re[4]: Strange behaviour of rlm_chap (freeradius 1.1.7+mysql)

2007-09-06 Thread Dan Searle
Hi, No, again I can assure you that the same password is sent in both cases, and it matches the password on the server (stored in clear text). Thursday, September 6, 2007, 11:04:12 AM, you wrote: Password on the server is most likely the same. Password sent most likely isn't. Ivan Kalik

Re: Strange behaviour of rlm_chap (freeradius 1.1.7+mysql)

2007-09-06 Thread Alan DeKok
Dan Searle wrote: Hello? Is there anybody out there? Are you going to read previous responses on this list? http://lists.freeradius.org/pipermail/freeradius-users/2007-August/065807.html Can someone who knows how CHAP works please explain to me how this could be happening? See the

Re: Strange behaviour of rlm_chap (freeradius 1.1.7+mysql)

2007-08-30 Thread Alan DeKok
Dan Searle wrote: Here's a trace of two login's the first works fine, the second a few moments later fails, the username and password supplied in both cases are correct and exactly the same. Can anyone shed any light on this? I've tried rebuilding the mysql database from scratch, and

Yeahh!!! Openser + Freeradius + CDRTool + MySQL + Freeradius-CDRTool python module almost working

2007-08-23 Thread Marc LEURENT
Thanks Dan!! I have successfully compiled freeradius 1.1.6 with the rlm_python compiled statically! So the freeradius-cdrtool module works!! My problem is that is cannot find the destination whereas it's in the Canonical-URI, so that with To=None, it cannot calculate the max session time But in

RE: freeradius and mysql

2007-08-05 Thread tnt
mailing list Objet :Re: freeradius and mysql I send the error in my email.this error is: ERROR 1064(42000) at line 1:you have an error in your sql syntax,.. [EMAIL PROTECTED]wrote: And the error is? Ivan Kalik Kalik Informatika ISP Dana 1/8/2007, zahra bahar piše: Hi I

RE: freeradius and mysql

2007-08-04 Thread zahra bahar
PROTECTED]la part de zahra bahar Envoyé : samedi 4 août 200706:05 À : FreeRadius users mailing list Objet :Re: freeradius and mysql I send the error in my email.this error is: ERROR 1064(42000) at line 1:you have an error in your sql syntax,.. [EMAIL PROTECTED]wrote

Re: freeradius and mysql

2007-08-03 Thread zahra bahar
I send the error in my email. this error is: ERROR 1064(42000) at line 1:you have an error in your sql syntax,.. [EMAIL PROTECTED] wrote: And the error is? Ivan Kalik Kalik Informatika ISP Dana 1/8/2007, zahra bahar pi¹e: Hi I am new in radius, I want to use sql for accounting in

RE: freeradius and mysql

2007-08-03 Thread wdg-tech
USE : # mysql -u root -p mysql.sql NOT : # mysql -u root -p mysql.sql By; -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] la part de zahra bahar Envoyé : samedi 4 août 2007 06:05 À : FreeRadius users mailing list Objet : Re: freeradius and mysql I

RE: freeradius and mysql

2007-08-03 Thread wdg-tech
Sorry, USE : # mysql -u root -p radius mysql.sql and not : # mysql -u root -p mysql.sql -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] la part de zahra bahar Envoyé : samedi 4 août 2007 06:05 À : FreeRadius users mailing list Objet : Re: freeradius

Re: freeradius and mysql

2007-08-01 Thread Peter Nixon
On Wed 01 Aug 2007, zahra bahar wrote: Hi I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use # mysql -u root -p mysql.sql after entering password there is this error: You are using the wrong pipe.. Use instead ERROR 1064(42000) at

freeradius and mysql

2007-08-01 Thread zahra bahar
Hi I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use # mysql -u root -p mysql.sql after entering password there is this error: ERROR 1064(42000) at line 1:you have an error in your sql syntax,... use the ql.sal rlm_sql Freeradius

Re: freeradius and mysql

2007-08-01 Thread Stefan Winter
# mysql -u root -p mysql.sql after entering password there is this error: ERROR 1064(42000) at line 1:you have an error in your sql syntax,... use the ql.sal rlm_sql Freeradius sql module. I don't know the reason of this error. You want to feed the commands from the file

Re: freeradius and mysql

2007-08-01 Thread tnt
And the error is? Ivan Kalik Kalik Informatika ISP Dana 1/8/2007, zahra bahar [EMAIL PROTECTED] piše: Hi I am new in radius, I want to use sql for accounting in freeradius. for creating tables of radius I use # mysql -u root -p mysql.sql after entering password there is this error:

RE: freeradius and mysql

2007-07-14 Thread Hugh Messenger
jose a. zúñiga said I need a tutorial in order to connect freeradius and mysql It kind of depends on what you want to do with the MySQL: Authenticate? Handle per-user check/return attributes? Handle per-group check/return attributes? Accounting? Dynamic IP assignment? Whatever your

freeradius and mysql

2007-07-13 Thread jose a. zúñiga
Hi: I need a tutorial in order to connect freeradius and mysql thanks jose a. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

freeradius-1.1.6 - mysql failover issue - bus error -

2007-07-03 Thread Francesco Cristofori
Hi all, I'm setting up module fail-over for mysql backend following the guide from the wiki, but something goes wrong. I included two sql.conf (mysql1.conf and mysql2.conf) in the modules section and radiusd -X reports the two files are included, but I only see the parameters from the first

R: freeradius-1.1.6 - mysql failover issue - bus error -

2007-07-03 Thread Francesco Cristofori
:[EMAIL PROTECTED] freeradius .org]Per conto di Francesco Cristofori Inviato: martedì 3 luglio 2007 9.54 A: freeradius-users@lists.freeradius.org Oggetto: freeradius-1.1.6 - mysql failover issue - bus error - Hi all, I'm setting up module fail-over for mysql backend following the guide

Freeradius and MySQL problem!!!

2007-07-02 Thread Ackbar Joolia
Dear all, I have been using freeradius properly configured with mysql for some time now. However it suddenly stopped working. What more, I upgraded to the 1.6 version, and now when I run radiusd -X, it doesn't even show that its tied in with the MySQL database... Can anyone please help me? I

  1   2   3   >