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

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

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 on

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

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

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

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

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

Re: Freeradius and MySQL problem!!!

2007-07-02 Thread tnt
You haven't posted your radiusd -X output. Ivan Kalik Kalik Informatika ISP Dana 2/7/2007, Ackbar Joolia [EMAIL PROTECTED] piše: 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

RE: Freeradius and MySQL problem!!!

2007-07-02 Thread Ackbar Joolia
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 02 July 2007 12:38 To: FreeRadius users mailing list Subject: Re: Freeradius and MySQL problem!!! You haven't posted your radiusd -X output. Ivan Kalik Kalik Informatika ISP Dana 2/7/2007, Ackbar Joolia [EMAIL

RE: Freeradius and MySQL problem!!!

2007-07-02 Thread tnt
users mailing list Subject: Re: Freeradius and MySQL problem!!! You haven't posted your radiusd -X output. Ivan Kalik Kalik Informatika ISP Dana 2/7/2007, Ackbar Joolia [EMAIL PROTECTED] piše: Dear all, I have been using freeradius properly configured with mysql for some time now. However

RE: Freeradius and MySQL problem!!!

2007-07-02 Thread Ackbar Joolia
HI Ivan The sql in authorize and accounting are all uncommented. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 02 July 2007 14:16 To: FreeRadius users mailing list Subject: RE: Freeradius and MySQL problem!!! Have you included

RE: Freeradius and MySQL problem!!!

2007-07-02 Thread tnt
] On Behalf Of [EMAIL PROTECTED] Sent: 02 July 2007 14:16 To: FreeRadius users mailing list Subject: RE: Freeradius and MySQL problem!!! Have you included sql in your radiusd.conf or are sql entries still commented out? Ivan Kalik Kalik Informatika ISP Dana 2/7/2007, Ackbar Joolia [EMAIL PROTECTED

RE: Freeradius and MySQL problem!!!

2007-07-02 Thread Ackbar Joolia
Of [EMAIL PROTECTED] Sent: 02 July 2007 15:50 To: FreeRadius users mailing list Subject: RE: Freeradius and MySQL problem!!! It's not reading sql.conf. Check permissions on that file. Ivan Kalik Kalik Informatika ISP Dana 2/7/2007, Ackbar Joolia [EMAIL PROTECTED] piše: HI Ivan The sql in authorize

Re: Freeradius and MySQL problem!!!

2007-07-02 Thread Alan DeKok
Ackbar Joolia wrote: Ivan, I've given all permissions to sql.confnothing...it's still the same. Its strange, this used to work well before for the previous version of freeradius. Seems simple, yet!!! Any other advice? Is the server reading the file you are editing? ...

RE: Freeradius and MySQL problem!!!

2007-07-02 Thread Ackbar Joolia
: Freeradius and MySQL problem!!! Ackbar Joolia wrote: Ivan, I've given all permissions to sql.confnothing...it's still the same. Its strange, this used to work well before for the previous version of freeradius. Seems simple, yet!!! Any other advice? Is the server reading the file you

Re : FreeRadius+Dialup_admin+Mysql

2007-03-15 Thread Eshun Benjamin
check your settings in .../conf/admin.conf # # can be one of mysql,pg where: # mysq: MySQL database (port 3306) # pg: PostgreSQL database (port 5432) # sql_type: mysql sql_server: localhost sql_port: 3306 sql_username: dialup_admin sql_password: XX sql_database: radius sql_accounting_table:

Re: Freeradius-1.1.3 + Mysql ?

2007-01-11 Thread Alan DeKok
adreas Polyxronopoulos wrote: Hi list, I have compiled freeradius-1.1.3 with out any configure option. I don't have mySql server on my pc (ubuntu 6.10) . If i would like to store accounting information in mySql , what i have to do? When i download mySql server package do i have to

Re: Freeradius-1.1.3 + Mysql ?

2007-01-11 Thread adreas Polyxronopoulos
freeradius-users@lists.freeradius.org Sent: Thursday, 11 January, 2007 7:23:53 PM Subject: Re: Freeradius-1.1.3 + Mysql ? Hi, Hi list, I have compiled freeradius-1.1.3 with out any configure option. I don't have mySql server on my pc (ubuntu 6.10) . If i would like to store accounting information

Re: FreeRadius and MySQL boot problem

2006-11-25 Thread olisa
I check it freeradius scripts rc.radiusd .it is same as /usr/local/sbin/rc.radiusd. I am using operating system fedora core 4 and chillispot is chillispot-1.0.i386.rpm and freeradius is freeradius-1.1.0.tar.gz . and whenever i reboot the radiusd server there is the error in radiusd log file

Re: FreeRadius and MySQL boot problem

2006-11-24 Thread olisa
hello i configure chillispot and freeradius and it is working. But whenever i reboot this radiusd server i have to run manually all the time. So how to run this radiusd server at boot time. chillispot ,apche and mysql all run at boot time but radiusd is not.i try it by

Re: FreeRadius and MySQL boot problem

2006-11-24 Thread Hernan Antolini
Check the scripts dir that came with the freeradius source; there is a rc.radiusd file to do that. regards Hernan Antolini [EMAIL PROTECTED] wrote on 11/24/2006 03:52:53 AM: hello i configure chillispot and freeradius and it is working. But whenever i reboot this radiusd

Re: freeradius and mysql fails

2006-05-23 Thread Alan DeKok
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: first its 'local' and with sql its 'system', is this ok? That's what you told it to do. id UserNameAttribute Value op 3 test1 User-Password $1$BnzqweeZ$EJ66Aqwe0/YANJdc8hBC/ := That's not a clear-text

RE: Freeradius and MySQL

2006-05-11 Thread Seferovic Edvin
Hello Jeremy, PLEASE ! SPECIFY YOUR PROBLEM ! you have sent 2-3 comments to the mailing list and nobody ( besides Alan ) wanted to respond! Why? No needed information ( aka I have car, car has tires, but I cannot drive, why? ). You are using db. Okay. What DB? Firebird, MySql, MSSQL, Oracle?

Re: freeradius + pptp + mysql

2006-05-02 Thread Phil Mayers
Michael Gale wrote: Hello, I have it working I believe, more testing is required but so far everything seems good. Most of the docs I have come across say to set Auth-Type to Local or something in the mysql database. Those docs are WRONG, as you've discovered. If possible, could you

Re: freeradius + pptp + mysql

2006-05-01 Thread Alan DeKok
Michael Gale [EMAIL PROTECTED] wrote: My client is a XP Pro laptop using MS-CHAP v2 I believe Nope. It's not sending MS-CHAP in the request packet. I have followed the documents from the following locations: http://poptop.sourceforge.net/dox/radius_mysql.html

Re: freeradius + pptp + mysql

2006-05-01 Thread Michael Gale
Hello, Ok, I removed freeradius and re-installed the package. The only configuration changes I made where: username and password in sql.conf Uncommented sql options in radius.conf I also add the dictionary.mirosoft file to the /etc/radiusclient/ directory as I came across a document that

Re: freeradius + pptp + mysql

2006-05-01 Thread Michael Gale
Hello, I have it working I believe, more testing is required but so far everything seems good. Most of the docs I have come across say to set Auth-Type to Local or something in the mysql database. I came across the following post by Alan DeKok:

Re: Freeradius and mysql

2006-04-25 Thread Alan DeKok
Mario Casola [EMAIL PROTECTED] wrote: Hello, I've installed freeradius and I've configured it to comunicate with mysql...all work fine, but I don't understand the meaning of the mysql database structure and all the possible values I can put in the database...if someone could illuminate me.

Re: Freeradius and mysql

2006-04-25 Thread Olaf Schaefer
quick, very short and uncomplete answer :) *check tables:information which have to be checked from freeRADIUS, like user password *reply tables:information which freeRADIUS sends back to your NAS (e.g. IP-pool, data rate etc.) *acct tables: here are the accounting information stored by

Re: FreeRadius and MySQL boot problem

2006-02-28 Thread Alan DeKok
Diniz Da Rocha [EMAIL PROTECTED] wrote: do you know how long it *should* take before retrying?? Why ask me? See the server source. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: FreeRadius and MySQL boot problem

2006-02-27 Thread Alan DeKok
Diniz Da Rocha [EMAIL PROTECTED] wrote: The MySQL server is on another server with ip myip I initially thought it was a firewall block but even with no firewall I get this error. But once the server has started and I run service radiusd restart from a terminal the connect to the MySQL server

Re: FreeRadius and MySQL boot problem

2006-02-27 Thread Dennis Skinner
Diniz Da Rocha wrote: The MySQL server is on another server with ip myip I initially thought it was a firewall block but even with no firewall I get this error. But once the server has started and I run service radiusd restart from a terminal the connect to the MySQL server works fine and has

Re: FreeRadius and MySQL boot problem

2006-02-27 Thread Diniz Da Rocha
do you know how long it *should*take before retrying?? On 2/27/06, Alan DeKok [EMAIL PROTECTED] wrote: Diniz Da Rocha [EMAIL PROTECTED] wrote: The MySQL server is on another server with ip myip I initially thought it was a firewall block but even with no firewall I get this error. But once the

Re: FreeRadius and MySQL boot problem

2006-02-27 Thread Diniz Da Rocha
I also had that impression so I did a sleep for 30 secs but still no luck, I was wondering if it has something to do with the user who runs at startup if its not root??? but havent any info on this yet... what os are you runningyour FreeRadius on??? On 2/28/06, Dennis Skinner [EMAIL PROTECTED]

Re: freeradius 1.0.4 + mysql cannot authincate

2006-01-11 Thread Alan DeKok
Jonathan Carpenter [EMAIL PROTECTED] wrote: I have the authorize section in my radius.conf, what other authorize section do I need? It wasn't included in the debug output, or in the snippets from radiusd.conf. So one of two situations exist: a) it wasn't in radiusd.conf b) you edited

Re: freeradius 1.0.4 + mysql cannot authincate

2006-01-11 Thread Dennis Skinner
Jonathan Carpenter wrote: Here is the entry from my radius.conf authenticate { Auth-Type PAP { pap } Auth-Type CHAP { chap } } Read what I wrote below. It says authorize section. That is the 1 section you did not show us. As Alan said, you are either

Re: Freeradius 1.1.0 Mysql 5.x

2006-01-10 Thread Nicolas Baradakis
Chadwick Sorrell wrote: On 1/9/06, Nicolas Baradakis [EMAIL PROTECTED] wrote: It looks like a local setup issue: you should double-check if the version of the libmysqlclient binaries matches the version of the libmysqlclient headers on your system. PHP is accessing Mysql fine, well more

Re: Freeradius 1.1.0 Mysql 5.x

2006-01-10 Thread Chadwick Sorrell
Nicolas, As soon as I remove the --disable-static from the configure it seems to work fine. What do you think could be causing that? Thanks, Chad On 1/10/06, Nicolas Baradakis [EMAIL PROTECTED] wrote: Chadwick Sorrell wrote: On 1/9/06, Nicolas Baradakis [EMAIL PROTECTED] wrote: It looks

Re: freeradius 1.0.4 + mysql cannot authincate

2006-01-10 Thread Dennis Skinner
Jonathan Carpenter wrote: Config: including file: /etc/raddb/sql.conf That's good. rad_recv: Access-Request packet from host 127.0.0.1:32784 http://127.0.0.1:32784, id=125, length=58 User-Name = scooby User-Password = scooby NAS-IP-Address = 255.255.255.255

Re: freeradius 1.0.4 + mysql cannot authincate

2006-01-10 Thread Jonathan Carpenter
Here is the entry from my radius.conf authenticate { Auth-Type PAP { pap } Auth-Type CHAP { chap } } # # Pre-accounting. Decide which accounting type to use. # preacct { preprocess acct_unique suffix #files } # # Accounting. Log the accounting data. # accounting { acct_unique

Re: freeradius 1.0.4 + mysql cannot authincate

2006-01-10 Thread Lewis Bergman
Jonathan Carpenter wrote: auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user auth: Failed to validate the user. This doesn't look promising. -- Lewis Bergman Texas Communications 4309 Maple St. Abilene, TX 79602-8044 Off. 325-691-1301 Cell

Re: freeradius 1.0.4 + mysql cannot authincate

2006-01-10 Thread Alan DeKok
Jonathan Carpenter [EMAIL PROTECTED] wrote: Here is the entry from my radius.conf ... And no authorize section. From the debug log you posted, it looks like you deleted it completely. Don't do that. Alan DeKok. - List info/subscribe/unsubscribe? See

Re: freeradius 1.0.4 + mysql cannot authincate

2006-01-10 Thread Jonathan Carpenter
I have the authorize section in my radius.conf, what other authorize section do I need?On 1/10/06, Alan DeKok [EMAIL PROTECTED] wrote:Jonathan Carpenter [EMAIL PROTECTED] wrote: Here is the entry from my radius.conf...And no authorize section.From the debug log you posted, it lookslike you

Re: Freeradius 1.1.0 Mysql 5.x

2006-01-09 Thread Nicolas Baradakis
Chadwick Sorrell wrote: I am trying to get freeradius 1.1.0 up with mysql 5.0 and it is giving me trouble. [...] rlm_sql ((null)): Attempting to connect rlm_sql_mysql #300 It looks like a local setup issue: you should double-check if the version of the libmysqlclient binaries matches the

Re: Freeradius 1.1.0 Mysql 5.x

2006-01-09 Thread Chadwick Sorrell
On 1/9/06, Nicolas Baradakis [EMAIL PROTECTED] wrote: It looks like a local setup issue: you should double-check if the version of the libmysqlclient binaries matches the version of the libmysqlclient headers on your system. PHP is accessing Mysql fine, well more to the point, PHP was compiled

Re: Freeradius 1.1.0 Mysql 5.x

2006-01-06 Thread Alan DeKok
Chadwick Sorrell [EMAIL PROTECTED] wrote: radiusd -X shows that the sql connection is established but radiusd doesn't limit the connections based on num_sql_socks and it continues to connect until my mysql hits its max connections. At that point it begins this... rlm_sql ((null)):

Re: freeradius and mysql - no matching entry in db

2005-10-25 Thread Lewis Bergman
Luqman H said: No matching entry in the database for request from user [luqe] but if i'm quering manually on mysql: mysql SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'luqe' ORDER BY id; +-+--+---+--++ | id | UserName |

Re: freeradius and mysql - no matching entry in db

2005-10-25 Thread Luqman H
2005/10/25, Lewis Bergman [EMAIL PROTECTED]: mysql SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'luqe' ORDER BY id; +-+--+---+--++ | id | UserName | Attribute | Value| op |

Re: freeradius and mysql - no matching entry in db

2005-10-25 Thread Luqman H
if i include the user file, - rlm_sql_mysql: query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'luqe' AND usergroup.GroupName = radgroupreply.GroupName ORDER

RE: freeradius and MySQL 4.1.12-1

2005-07-23 Thread Reza Toghraee
Hello shell mysql Client does not support authentication protocol requested by server; consider upgrading MySQL client To solve this problem, you should use one of the following approaches: Upgrade all client programs to use a 4.1.1 or newer client library. When connecting to the server

Re: freeradius and MySQL 4.1.12-1

2005-07-22 Thread Nicolas Baradakis
Didier Wintgens wrote: How update the MySQL client version of freeradius to 4.1 protocol ? Don't use the RPM package and rebuild FreeRADIUS from source against MySQL 4.1 client library. -- Nicolas Baradakis - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius and MySQL -- missing libraries?

2005-04-02 Thread Paul Hampson
On Fri, Apr 01, 2005 at 12:42:18PM -0800, Rick Kunkel wrote: Hello all, When I run an ldd though, I see this: # ldd rlm_sql_mysql.so libmysqlclient.so.12 = not found libz.so.1 = /usr/lib/libz.so.1 (0x4000b000) libcrypt.so.1 = /lib/libcrypt.so.1 (0x40019000)

Re: FreeRADIUS and MySQL+SSL

2005-03-31 Thread Wolfram Schlich
* Wolfram Schlich [EMAIL PROTECTED] [2005-03-19 13:11]: * Paul Hampson [EMAIL PROTECTED] [2005-03-19 04:56]: On Sat, Mar 19, 2005 at 03:52:52AM +0100, Wolfram Schlich wrote: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-17 00:55]: [ FreeRADIUS + MySQL + SSL ] Ok, I have sat down and

Re: FreeRADIUS and MySQL+SSL

2005-03-31 Thread Paul Hampson
On Fri, Apr 01, 2005 at 01:34:37AM +0200, Wolfram Schlich wrote: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-19 13:11]: * Paul Hampson [EMAIL PROTECTED] [2005-03-19 04:56]: On Sat, Mar 19, 2005 at 03:52:52AM +0100, Wolfram Schlich wrote: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-17

Re: FreeRADIUS and MySQL+SSL

2005-03-21 Thread Wolfram Schlich
* Paul Hampson [EMAIL PROTECTED] [2005-03-20 03:50]: On Sat, Mar 19, 2005 at 02:06:56PM +0100, Wolfram Schlich wrote: * Paul Hampson [EMAIL PROTECTED] [2005-03-19 04:56]: On Sat, Mar 19, 2005 at 03:52:52AM +0100, Wolfram Schlich wrote: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-17

Re: FreeRADIUS and MySQL+SSL

2005-03-19 Thread Marcin Jessa
I never said to use stunnel on the box with MySQL. Use it on the box with Freeradius and dont use untested patches on what I take is gonna be a production server. Stunnel is very stable and reliable. Anyway, I'd rather make SSL connection between two MySQL servers with database replication and

Re: FreeRADIUS and MySQL+SSL

2005-03-19 Thread Wolfram Schlich
* Marcin Jessa [EMAIL PROTECTED] [2005-03-19 13:17]: On Sat, 19 Mar 2005 04:14:11 +0100 Wolfram Schlich [EMAIL PROTECTED] wrote: * Marcin Jessa [EMAIL PROTECTED] [2005-03-19 04:05]: On Sat, 19 Mar 2005 03:52:52 +0100 Wolfram Schlich [EMAIL PROTECTED] wrote: * Wolfram Schlich [EMAIL

Re: FreeRADIUS and MySQL+SSL

2005-03-19 Thread Wolfram Schlich
* Paul Hampson [EMAIL PROTECTED] [2005-03-19 04:56]: On Sat, Mar 19, 2005 at 03:52:52AM +0100, Wolfram Schlich wrote: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-17 00:55]: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-16 09:05]: Hey guys, we would like to implement the following

Re: FreeRADIUS and MySQL+SSL

2005-03-19 Thread Paul Hampson
On Sat, Mar 19, 2005 at 02:06:56PM +0100, Wolfram Schlich wrote: * Paul Hampson [EMAIL PROTECTED] [2005-03-19 04:56]: On Sat, Mar 19, 2005 at 03:52:52AM +0100, Wolfram Schlich wrote: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-17 00:55]: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-16

Re: FreeRADIUS and MySQL+SSL

2005-03-18 Thread Marcin Jessa
All you need is stunnel. On Sat, 19 Mar 2005 03:52:52 +0100 Wolfram Schlich [EMAIL PROTECTED] wrote: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-17 00:55]: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-16 09:05]: Hey guys, we would like to implement the following setup: -

Re: FreeRADIUS and MySQL+SSL

2005-03-18 Thread Wolfram Schlich
* Marcin Jessa [EMAIL PROTECTED] [2005-03-19 04:05]: On Sat, 19 Mar 2005 03:52:52 +0100 Wolfram Schlich [EMAIL PROTECTED] wrote: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-17 00:55]: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-16 09:05]: Hey guys, we would like to implement

Re: FreeRADIUS and MySQL+SSL

2005-03-18 Thread Paul Hampson
On Sat, Mar 19, 2005 at 03:52:52AM +0100, Wolfram Schlich wrote: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-17 00:55]: * Wolfram Schlich [EMAIL PROTECTED] [2005-03-16 09:05]: Hey guys, we would like to implement the following setup: - FreeRADIUS radiusd on machine A - MySQL

Re: FreeRADIUS and MySQL+SSL

2005-03-16 Thread Wolfram Schlich
* Wolfram Schlich [EMAIL PROTECTED] [2005-03-16 09:05]: Hey guys, we would like to implement the following setup: - FreeRADIUS radiusd on machine A - MySQL mysqld on machine B FreeRADIUS should use the MySQL database on machine A over an SSL secured connection. Does FreeRADIUS support

Re: Freeradius/Poptop/Mysql-Problem -- failed authentication

2005-01-07 Thread Alan DeKok
Harald Mueller [EMAIL PROTECTED] wrote: auth: type Local I think you set Auth-Type := Local somewhere. Why? Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius/Poptop/Mysql-Problem -- failed authentication

2005-01-07 Thread Harald Mueller
Hi Alan! Thanks for your answer!!! --- Alan DeKok [EMAIL PROTECTED] schrieb: I think you set Auth-Type := Local somewhere. Mh ...I don't think so ... pptpd1:/etc/raddb # grep Local users #steve Auth-Type := Local, User-Password == testing #John Doe Auth-Type := Local,

Re: FreeRadius and MySQL

2004-11-30 Thread Alan DeKok
TJ Burbank [EMAIL PROTECTED] wrote: When attempting to start the FreeRadius server in Debugging mode I get unable to bind port to ip address 0.0.0.0:1812 It should tell you why. i.e. here's another RADIUS server running. Alan DeKok. - List info/subscribe/unsubscribe? See

Re: FreeRadius and Mysql

2004-11-29 Thread Toby Liu
All, I've successfully set up my freeradius to lookup the users in MySql. I've two questions: 1. Is it possible to configure the RADIUS Clients in MySql too? I'm using Freeradius 1.0.0 , simply put the following line in sql.conf. readclients = yes Please remember: It only loaded when

Re: Freeradius and MySQL

2004-11-28 Thread Keith Yoder
Stefan escreveu: All, I've successfully set up my freeradius to lookup the users in MySql. I've two questions: 1. Is it possible to configure the RADIUS Clients in MySql too? There is a nas table in the db schema now but I don't know how it works. 2. would it be possible to write specific

Re: freeradius with Mysql Data Base

2004-10-08 Thread Thor Spruyt
Hi, Just some suggestions: 1) use plain text mail 2) split up your problem in several parts (e.g. the mysql part and the Cisco part) For the Cisco part, reading the Cisco manuals might help For the Mysql part, reading documentation and configuration files might help (e.g. /etc/raddb/sql.conf and

RE : freeradius and mysql

2004-09-15 Thread EROS
Hi , Have you done the Configurable failover in /doc ? If you want send me your radius.conf and sql.conf or I give you mine to see what happens. What is exactly the pb ? Could we have your log (radiusd -X) ? thx -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la

RE: FreeRADIUS and MySQL

2004-07-20 Thread Lopez, A.
- From: jesk [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 4:45 PM To: [EMAIL PROTECTED] Subject: Re: FreeRADIUS and MySQL All these things can be done with freeradius. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe

Re: FreeRADIUS and MySQL

2004-07-20 Thread jesk
you can execute a programm for every reply item. Attribute-Name = `{%exec:/path/to/program args}` in the program itself you can use the environment variables for reading the nasipaddress or something else, all request items are placed into the enviroment of the forked programm. the output of the

Re: FreeRADIUS and MySQL

2004-07-19 Thread jesk
All these things can be done with freeradius. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: freeradius--with mysql database???

2004-07-14 Thread Julius Igugu
Hi, There's a howto here: http://www.frontios.com/freeradius.html Regards --- Joel n.solanki [EMAIL PROTECTED] wrote: Dear freeradius gurus, I am very new to radius.Just know what is radius nothing more :) I have downloaded freeradius-0.9.2.tar.gz and installed it. My system is Redhat

Re: Freeradius Using Mysql Database

2004-06-10 Thread Kiran
--- Nagesh Boyina [EMAIL PROTECTED] wrote: Dear Mr.Kiran, Where can I create the usernames and passwords for authentication in the database. in two two tables - radcheck and radreply And also send example of cisco av pairs. mysql select * from radcheck limit 1;

RE: Freeradius Using Mysql Database

2004-06-08 Thread Nagesh Boyina
Dear Alan Dekok, I have installed Freeradius with help of document. And also I installed Mysql database, but I am not able to create the usernames and passowrds. And I will tell u my requirement is I want use this radius server for ISDN users for authentication. And we have a cisco 3600 series

RE: Freeradius Using Mysql Database

2004-06-08 Thread Nagesh Boyina
Dear Alan Dekok, I have installed Freeradius with help of document. And also I installed Mysql database, but I am not able to create the usernames and passowrds. And I will tell u my requirement is I want use this radius server for ISDN users for authentication. And we have a cisco 3600 series

  1   2   >