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 > 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 a

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 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: - while mysql cluster can

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 : > > 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 o

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 : > Good Morning, > > I am doing some tests with MySQL Cluster, and I want to m

Re: [OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Fajar A. Nugraha
2012/2/27 Antonio Modesto : > 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 MySQL with the NDB

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:

[OFF-TOPIC] Freeradius and MySQL Cluster

2012-02-27 Thread Antonio Modesto
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 MySQL with the NDBCLUSTER engine, I got this error: ERRO

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 tes

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

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 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". I meant literally the FAQ item "It still doesn't work", which advises posting the debu

Re: Cisco LNS with Freeradius and MySQL

2010-10-18 Thread Stephane MAGAND
Ok i have resolved my problems ;=) 2010/10/18 Stephane MAGAND : > 2010/10/18 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". >> > > > Thanks for your answer Phil, but i don't se

Re: Cisco LNS with Freeradius and MySQL

2010-10-18 Thread Stephane MAGAND
2010/10/18 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". > 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 cisco ? Do yo

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

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, 'IAccess'

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

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

2009-12-02 Thread C. Diego Raffaelli A.
Dear all: i have installed debian, mysql server 5.0 (by aptitude install) and freeradius-server-2.1.7 by wget and "untar -xvfz" , manually. i have no errors on freeradius run. i have a 3com RAS with PPP and PPPoE users, i would like to put my debian-freeradius as a Radius for them (AAA). Questi

Reminder: Webinar with FreeRADIUS and MySQL: Sept. 30

2009-09-28 Thread Alan DeKok
wed by Q&A. WHERE: Simply access the web seminar from the comfort of your own office. WHY: To learn more about how you can use FreeRADIUS and MySQL Cluster 7.0 to deliver highly available and scalable AAA Services - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Webinar with FreeRADIUS and MySQL

2009-09-09 Thread Alan DeKok
y access the web seminar from the comfort of your own office. WHY: To learn more about how you can use FreeRADIUS and MySQL Cluster 7.0 to deliver highly available and scalable AAA Services - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Webinar with FreeRADIUS and MySQL: Sept. 30

2009-09-09 Thread Alan DeKok
wed by Q&A. WHERE: Simply access the web seminar from the comfort of your own office. WHY: To learn more about how you can use FreeRADIUS and MySQL Cluster 7.0 to deliver highly available and scalable AAA Services - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

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 O

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 dat

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: > > > authorize

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'

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 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 serve

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. (Quer

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 slip-new

Re: Problems with Freeradius and MySQL

2008-10-30 Thread Leander S.
Are you trying to get your FreeRADIUS SQL able, or are you trying to use crypted passwords for users in the SQL table? Case one: (Talking of FreeRADIUS versions 2.*.*) First of all you need the SQL schemes provided in freeradius-server-2.1.1/raddb/sql/mysql/ You also might want to have a look a

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 - Cry

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/unsu

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 info/subscri

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

"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 lib

Re: data limit in Mikrotik with Freeradius and Mysql

2007-09-21 Thread Guy Fraser
> > 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. > >

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 f

Re: data limit in Mikrotik with Freeradius and Mysql

2007-09-20 Thread tnt
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 stored in protocol are 32 bits >only. > >Awaiti

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

RE: freeradius and mysql

2007-08-05 Thread tnt
[mailto:[EMAIL 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

RE: freeradius and mysql

2007-08-04 Thread zahra bahar
ED][mailto:[EMAIL 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 PROTE

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: fre

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

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 i

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

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 m

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 er

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-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?

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

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 s

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

RE: Freeradius and MySQL problem!!!

2007-07-02 Thread Ackbar Joolia
Behalf 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]&

RE: Freeradius and MySQL problem!!!

2007-07-02 Thread tnt
;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 sql in your radiusd.conf or are sql entries still >commented out? >

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
"no" >Module: Instantiated files (files) >Module: Loaded Acct-Unique-Session-Id > acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address, > Client-IP-Address, NAS-Port" >Module: Instantiated acct_unique (acct_unique) >Module: Loaded detail > detail: de

RE: Freeradius and MySQL problem!!!

2007-07-02 Thread Ackbar Joolia
: detailperm = 384 detail: dirperm = 493 detail: locking = no Module: Instantiated detail (detail) Module: Loaded radutmp radutmp: filename = "/usr/local/var/log/radius/radutmp" radutmp: username = "%{User-Name}" radutmp: case_sensitive = yes radutmp: check_with_nas = yes

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

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 ha

Re: Problem with freeradius and mysql

2007-04-09 Thread José Christian Rodríguez
Thank all for your help. My freeradius with mysql is working now. Christian - Original Message - From: satish patel To: FreeRadius users mailing list Sent: Friday, April 06, 2007 2:55 AM Subject: Re: Problem with freeradius and mysql Dear all Here I

Re: Problem with freeradius and mysql

2007-04-06 Thread satish patel
Dear all Here I am shareing my Knowledge. for freeradius users. i have done freeradius-1.1.4 with mysql with cisco VPDN configuration as well as i have configuraed per user base bandwidth configuration and simultanious user login configuration i have sharing my configuration f

Re: Problem with freeradius and mysql

2007-04-05 Thread Alan DeKok
José Christian Rodríguez wrote: ... > *ERROR: Cannot find a configuration entry for module "sql". > radiusd.conf[1801] Unknown module "sql". > radiusd.conf[1730] Failed to parse authorize section. You didn't configure the SQL module. Read radiusd.conf, and look for the word "sql". Configure

Problem with freeradius and mysql

2007-04-05 Thread José Christian Rodríguez
Hello all When i try to run in debug mode, show and error messages # /usr/local/sbin/radiusd -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /etc/raddb/clients.conf Config: including file: /etc/raddb/snmp.conf Config: including file

Re: Cisco enable authentication on freeradius and mysql

2007-02-16 Thread Peter Nixon
If you look in sql.conf you should see: # Safe characters list for sql queries. Everything else is replaced # with their mime-encoded equivalents. # The default list should be ok safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" You can add $ to that list

Re: Cisco enable authentication on freeradius and mysql

2007-02-16 Thread Alan DeKok
[EMAIL PROTECTED] wrote: > I am trying to authenticate Cisco enable password requests via freeradius > (1.1.3.) on a mysql > (5.0.26) database. > > As per http://wiki.freeradius.org/Cisco, the router tries to authenticate > user $enab15$ but it > doesn't get matched on mysql query because '$' ge

Cisco enable authentication on freeradius and mysql

2007-02-16 Thread [EMAIL PROTECTED]
I am trying to authenticate Cisco enable password requests via freeradius (1.1.3.) on a mysql (5.0.26) database. As per http://wiki.freeradius.org/Cisco, the router tries to authenticate user $enab15$ but it doesn't get matched on mysql query because '$' gets escaped to '=24' radius_xlat: '$en

Re: Why Freeradius and Mysql dont work? [unclas]

2007-02-01 Thread yao guoxian
r/lib/mysql regards Frank Ranner -- *From:* freeradius-users-bounces+frank.ranner= [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] *On Behalf Of *yao guoxian *Sent:* Monday, 29 January 2007 15:14 *To:* [EMAIL PROTECTED]; FreeRadius users mailing list *Subject:* Re: Why Free

Re: Why Freeradius and Mysql dont work?

2007-01-31 Thread Dennis Skinner
yao guoxian wrote: > input command:./bin/mysql -u root > output results:Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 2 to server version: 5.0.20-standard-log *sigh* You installed MySQL but did none of the security things that it probably told you

Re: Why Freeradius and Mysql dont work?

2007-01-30 Thread yao guoxian
Yes, 202.117.7.243 is the MySQL server's IP.The problem is that I can not login to MySQL on the command line. The following is the input commands and output responses to them: input command: ./bin/mysqld_safe --user=root output results: Starting mysqld daemon with databases from /home/ygx

Re: Why Freeradius and Mysql dont work?

2007-01-30 Thread yao guoxian
Where is the default config file and how to config it? I copyed surpport-files/my-medium.cnf to /etc/my.medim.cnf and its content is as follow: [client] #password = your_password port= 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs

Re: Why Freeradius and Mysql dont work?

2007-01-29 Thread Dennis Skinner
yao guoxian wrote: > rlm_sql_mysql: Mysql error 'Host '202.117.7.243 ' > is not allowed to connect to this MySQL server' I assume this is a test server and is tightly controlled Login to MySQL as root on the command line. Type this: GRANT ALL ON *.* TO [EMAIL PROTECTED]

Re: Why Freeradius and Mysql dont work?

2007-01-29 Thread yao guoxian
Yes,I compiled FR myself. Originally I installed mysql with *.rpm packages(MySQL-*-5.0.20-0.i386.rpm, include MySQL-devel-5.0.20-0.i386.rpm),but it doent works. So I uninstall rpm packages and use mysql-standard-5.0.20-linux-i686.tar.gz to install Mysql. Thanks. 2007/1/29, YvesDM <[EMAIL PROTEC

Re: Why Freeradius and Mysql dont work?

2007-01-29 Thread A . L . M . Buxey
Hi, > But i couldn't use " mysql -u root -p rootpass" to enter the command line > enviroment any longer. The output is :ERROR 1045 (28000): Access denied for > user 'root'@'localhost' (using password: YES). Seems strange,isnt? Anyway, I > might better re-install Mysql. not strange at all - does t

Re: Why Freeradius and Mysql dont work?

2007-01-29 Thread yao guoxian
Thanks a lot! I dont know why Freeradius and MySQL suddenly works after I did the following step. 1 insert into radgroupreply (groupname,attribute,op,values) values ('user','Auth-Type',':=','Local'); insert into radgroupreply (groupname,attribute

Re: Why Freeradius and Mysql dont work?

2007-01-29 Thread A . L . M . Buxey
hi, thanks, now that you supplied the full debug we can clearly see that freeradius is unable to connect to your SQL database. so, questions arise such as - is your database server running? is it configured for that 'root' account and password (check using command line tools etc), is it firewalled

Re: Why Freeradius and Mysql dont work?

2007-01-28 Thread YvesDM
On 1/29/07, satish patel <[EMAIL PROTECTED]> wrote: Install mysql again Did you compile FR yourself? Did you install the mysql-dev files? Kind regards, Yves - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Why Freeradius and Mysql dont work?

2007-01-28 Thread satish patel
Install mysql again yao guoxian <[EMAIL PROTECTED]> wrote: Thanks again. The file "/var/lib/mysql/mysql.sock" does not exist.When I use an IP in sql.conf instead of the "localhost", I get the following result: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm

RE: Why Freeradius and Mysql dont work?

2007-01-28 Thread satish patel
this is problem of mysql configuration check /etc/my.cnf file for socket path and check your mysql working ??? or some mysql put mysql.sock file in /tmp/mysql.sock so plz check where your sock file in your env ? install mysql again and try it Edvin Seferovic <[EMAIL PROTECTED]> wrote:

RE: Why Freeradius and Mysql dont work? [unclas]

2007-01-28 Thread Ranner, Frank MR
On Behalf Of yao guoxian Sent: Monday, 29 January 2007 15:14 To: [EMAIL PROTECTED]; FreeRadius users mailing list Subject: Re: Why Freeradius and Mysql dont work? Thanks again. The file "/var/lib/mysql/mysql.sock" does not exist

Re: Why Freeradius and Mysql dont work?

2007-01-28 Thread yao guoxian
Thanks again. The file "/var/lib/mysql/mysql.sock" does not exist.When I use an IP in sql.conf instead of the "localhost", I get the following result: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius

RE: Why Freeradius and Mysql dont work?

2007-01-28 Thread Edvin Seferovic
rlm_sql_mysql: Mysql error 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' rlm_sql (sql): Failed to connect DB handle #0 rlm_sql (sql): Failed to connect to any SQL server. your socket file is not in the place.. maybe you should use an IP in your sql.conf inst

Re: Why Freeradius and Mysql dont work?

2007-01-28 Thread yao guoxian
Sorry. The debug result I listed is only the response to access request. The original display of "radiusd -X" is as follows: Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr

Re: Why Freeradius and Mysql dont work?

2007-01-28 Thread yao guoxian
Thanks for reply. The startup message(in debug mode) on my machine: sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED

Re: Why Freeradius and Mysql dont work?

2007-01-28 Thread A . L . M . Buxey
Hi, > 3.Edit radiusd.conf and sql.conf; > Debug Result: > Nothing to do. Sleeping until we see a request. no. thats not the debug result. you've edited all the lines before that output. alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Why Freeradius and Mysql dont work?

2007-01-28 Thread Markus Krause
Zitat von yao guoxian <[EMAIL PROTECTED]>: Platform and Environment: Freeradius:1.0.5 on Redhat 9 MySQL:MySQL-standard-5.0.20-linux-i686 Step: 1. create database radius; 2.mysql -uroot -prootpass radius < db_mysql.sql ; 3.Edit radiusd.conf and sql.conf; Debug Result: Nothing t

Why Freeradius and Mysql dont work?

2007-01-28 Thread yao guoxian
Platform and Environment: Freeradius:1.0.5 on Redhat 9 MySQL:MySQL-standard-5.0.20-linux-i686 Step: 1. create database radius; 2.mysql -uroot -prootpass radius < db_mysql.sql ; 3.Edit radiusd.conf and sql.conf; Debug Result: Nothing to do. Sleeping until we see a request. rad_r

FreeRadius and MySQL boot problem

2006-11-26 Thread HSS-NOC
>> > 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 no problems. I even >> > tried >&g

Re: FreeRadius and MySQL boot problem

2006-11-25 Thread olisa
> 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 no problems. I even >

Re: FreeRadius and MySQL boot problem

2006-11-24 Thread Hernan Antolini
> > the connect to the MySQL server works fine and has no problems. I even > > tried > > running the service from rc.local but it still fails did anyone have this > > problem??? is anyone running the MySQL server on another machine Is > > there a fix for this??? >

Re: FreeRadius and MySQL boot problem

2006-11-24 Thread olisa
ice from rc.local but it still fails did anyone have this > problem??? is anyone running the MySQL server on another machine Is > there a fix for this??? > > thanks > > diniz > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html

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-t

freeradius and mysql fails

2006-05-23 Thread [EMAIL PROTECTED]
hello, i was wondering what sql tables i need to have. Im trying to setup freeradius with mysql and i cant get out. i've got the following tables: radius (12) * Browse badusers * Browse mtotacct * Browse nas * Browse radacct * Browse radcheck * Browse radgroupcheck

RE: Freeradius and MySQL

2006-05-11 Thread Seferovic Edvin
Behalf Of Jeremy ohara Sent: Donnerstag, 11. Mai 2006 20:23 To: freeradius-users@lists.freeradius.org Subject: Freeradius and MySQL Hi there i have free radius updated on fedora. got a mysql database. but from what i'm noticing its not being check on the database. got dialup

Freeradius and MySQL

2006-05-11 Thread Jeremy ohara
Hi there i have free radius updated on fedora. got a mysql database. but from what i'm noticing its not being check on the database. got dialupadmin installed and using that to put the accounts into the database. and have setup freeradisu with the db Jeremy -

Re: Re: Re: Privileged Login on CISCO using freeradius and MySQL [Virus checked]

2006-05-11 Thread thomas . pudil
Hi Alan, >> So the Cisco DOES receive the attributes in the reply packet, but obviously >> ignores them?? > >what does your CISCO IOS config look like for radius ? It appears that you may >only have the authentication line and not the authorization line...eg > >aaa new-model >aaa authentication lo

Re: Re: Privileged Login on CISCO using freeradius and MySQL [Virus checked]

2006-05-11 Thread A . L . M . Buxey
Hi, > So the Cisco DOES receive the attributes in the reply packet, but obviously > ignores them?? what does your CISCO IOS config look like for radius ? It appears that you may only have the authentication line and not the authorization line...eg aaa new-model aaa authentication login default r

Re: Re: Privileged Login on CISCO using freeradius and MySQL [Virus checked]

2006-05-11 Thread thomas . pudil
Hi again, >The priv lvl I use in my users file is: > >Cisco-AVPair := "shell:priv-lvl=1" > >Debug output would help determine what isn't working. > >Kevin Bonner here is a debug from my radius-server: rad_recv: Access-Request packet from host 10.0.2.241:1645, id=9, length=76 NAS-

Re: Privileged Login on CISCO using freeradius and MySQL [Virus checked]

2006-05-10 Thread Kevin Bonner
On Wednesday 10 May 2006 13:16, [EMAIL PROTECTED] wrote: > Is the 'cisco-avpair' parameter misplaced, or should I look for the error > on the CISCO-config (using IOS 12.1)? > > thanks alot > thomas The priv lvl I use in my users file is: Cisco-AVPair := "shell:priv-lvl=1" Debug output wo

Privileged Login on CISCO using freeradius and MySQL [Virus checked]

2006-05-10 Thread thomas . pudil
Hi, I hope someone can help me with that - I dont seem to be able to, after hours of Googling and trying ... :-( I want to allow an admin to login to a Cisco-box, authenticated via radius and get immediately to privileged level ( so he doesnt have to do a "enable" when he logged in to the box)

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 freeRAD

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

  1   2   >