Re: mysql Connection error

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

Re: mysql Connection error

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

Re: mysql Connection error

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

RE: mysql Connection error

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

RE: mysql Connection error

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

Re: mysql Connection error

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

Re: mysql Connection error

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

Re: MySQL connection setup

2010-12-12 Thread Alan DeKok
Robin wrote: There is a configuration in SQL.conf. Num_sql_socks= I would like to know if this value is set to smaller, fx. 20, can it cause breaking stream or disconnecting for DSL users? No. There is *nothing* you can do to the RADIUS server to cause DSL users to disconnect

Re: MySQL connection setup

2010-12-12 Thread Marinko Tarlac
According to experiences on this list, 15-20 will be good. Also, no matter how many sql_socks do you set, it won't work if something blocks your database. Check your mysql on daily basis with tunning_primer and mysqltuner. Those two scripts will help you a lot to find a potential problems.

Re: mysql connection

2008-08-26 Thread Alan DeKok
Ahmet DÜLGAR wrote: i uncomment sql int sites-enabled/default then i try to runi but there was error in sql.conf about the mysqldriver driver=rlm_sql_mysql but there is no file for mysql driver, You will need to ensure it builds. This means having the MySQL client libraries development

RE: mysql connection

2008-08-26 Thread Ahmet DÜLGAR
thanks for your help alan dekok i installed the other packages of mysql that are mysql freeradius dialup admin now radisd dont broken up but when i looked the debug i see cant connect to mysql here is the debug log and how can i configure the user file for control the login users by the mysql

RE: mysql connection

2008-08-26 Thread Ivan Kalik
now radisd dont broken up but when i looked the debug i see cant connect to mysql So, what's this then: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius rlm_sql (sql): starting 0 rlm_sql (sql):

Re: mysql connection

2008-08-26 Thread A . L . M . Buxey
Hi, now radisd dont broken up but when i looked the debug i see cant connect to mysql here is the debug log I can clearly see the connection to MySQL - its in the SQL section of the debug log - it opens 5 concurrent sessions to your DB...successfully. to configure for authentication, read

Re: mysql connection

2008-08-26 Thread John Dennis
Ahmet DÜLGAR wrote: hi, i uncomment sql int sites-enabled/default then i try to runi but there was error in sql.conf about the mysqldriver driver=rlm_sql_mysql but there is no file for mysql driver, because i install freeradiys2.0.5 by yum insatall freeradius on fedora That's because the

RE: MySQL connection over SSL possible?

2008-06-23 Thread Anders Holm
in the configuration file and be done with it. //anders -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] g] On Behalf Of [EMAIL PROTECTED] Sent: 12 June 2008 18:18 To: FreeRadius users mailing list Subject: Re: MySQL connection over SSL possible? Hi, When I tried

Re: MySQL connection over SSL possible?

2008-06-12 Thread Anders Holm
quote From: you Sender: freeradius-users-bounces... Reply-To: [EMAIL PROTECTED] To: freeradius-users@ /quote Yes? That is still for one recipient. Reply-To is where replies to my mail would go. That's set by the MLM (Mailing List Manager) not by my mail client. //anders 2008/6/11 Alan DeKok

Re: MySQL connection over SSL possible?

2008-06-12 Thread Alan DeKok
This is getting off-topic, but... Anders Holm wrote: quote From: you Sender: freeradius-users-bounces... Reply-To: [EMAIL PROTECTED] To: freeradius-users@ /quote Yes? That is still for one recipient. Reply-To is where replies to my mail would go. That's set by the MLM (Mailing List

Re: MySQL connection over SSL possible?

2008-06-12 Thread Anders Holm
1/ Indeed I did. I did see that in the original mail I replied to. Where that was added is a good question, but I saw it in the mail that was replied to .. I'm saying that this is the way the mail was crafted, as I received it, before replying to it. 2/ Indeed it would be, if it did. Has anyone

Re: MySQL connection over SSL possible?

2008-06-12 Thread Nicolas Goutte
Am 12.06.2008 um 14:42 schrieb Anders Holm: 1/ Indeed I did. I did see that in the original mail I replied to. Where that was added is a good question, but I saw it in the mail that was replied to .. I'm saying that this is the way the mail was crafted, as I received it, before replying

Re: MySQL connection over SSL possible?

2008-06-12 Thread Anders Holm
2008/6/12 Nicolas Goutte [EMAIL PROTECTED]: [snip] For me it has worked since then. I have seen only one of each of your messages. Have a nice day! Excellent! One problem solved, and on to the next one. To get back on topic a tad then so, and to describe my experience with the SSL side of

Re: MySQL connection over SSL possible?

2008-06-12 Thread A . L . M . Buxey
Hi, When I tried setting the port number to something different I used port = port number .. That yielded cannot connect to server using socket error when running radiusd in debug mode. So, there's two things to take away from that experience. whoah. one missing step. did you test this

Re: MySQL connection over SSL possible?

2008-06-11 Thread Anders Holm
mailing list freeradius-users@lists.freeradius.org Sent: Monday, June 9, 2008 6:19:30 PM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: MySQL connection over SSL possible? Hi, No. Driver is sql_mysql.c file in src/modules/rlm_sql/drivers/rlm_sql_mysql/ folder of your distribution. You

Re: MySQL connection over SSL possible?

2008-06-11 Thread Anders Holm
, 2008 5:57:48 PM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: MySQL connection over SSL possible? Anders Holm wrote: So, that's a yes .. :) Yes. rlm_sql_mysql is the driver, and I'd rather not have my own version running, but would love to see that rolled in, if possible. My only

Re: MySQL connection over SSL possible?

2008-06-11 Thread Nicolas Goutte
are welcome in all cases .. //anders - Original Message - From: Alan DeKok [EMAIL PROTECTED] To: FreeRadius users mailing list freeradius- [EMAIL PROTECTED] Sent: Monday, June 9, 2008 5:57:48 PM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: MySQL connection over SSL possible

Re: MySQL connection over SSL possible?

2008-06-11 Thread Anders Holm
] To: FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Wednesday, June 11, 2008 11:15:38 AM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: MySQL connection over SSL possible? Please try to avoid to send emails to the list as TO *and* as CC. (I (and probably not only me

Re: MySQL connection over SSL possible?

2008-06-11 Thread Alan DeKok
Anders Holm wrote: Hitting Reply All in most MUAs would do this. The list should be smart enough to only forward on one copy per recipient ... It's not. We get 2 copies of every mail you send to the list. ALL mails I receive for this list has the list in *both* TO and CC headers

Re: MySQL connection over SSL possible?

2008-06-09 Thread Ivan Kalik
You will probably need to adapt the driver with mysql_ssl_set(): http://dev.mysql.com/doc/refman/5.0/en/mysql-ssl-set.html Ivan Kalik Kalik Informatika ISP Dana 9/6/2008, Anders Holm [EMAIL PROTECTED] piše: Hi folks. I'm wondering, would it be possible to encrypt the connection to the

Re: MySQL connection over SSL possible?

2008-06-09 Thread Anders Holm
Where $driver has a value of rlm_sql_mysql? //anders - Original Message - From: Ivan Kalik [EMAIL PROTECTED] To: FreeRadius users mailing list freeradius-users@lists.freeradius.org Sent: Monday, June 9, 2008 2:51:09 PM GMT +00:00 GMT Britain, Ireland, Portugal Subject: Re: MySQL

Re: MySQL connection over SSL possible?

2008-06-09 Thread Hoggins!
Hello, I assume that data integrity and secrecy is vital for you, between your RADIUS server and your MySQL server. Why not creating an IPSEC tunnel between the two ones ? It doesn't require any programming skills, and it's fully secure if it is well set. It might be any encrypted VPN

Re: MySQL connection over SSL possible?

2008-06-09 Thread A . L . M . Buxey
Hi, No. Driver is sql_mysql.c file in src/modules/rlm_sql/drivers/rlm_sql_mysql/ folder of your distribution. You will need to edit the source file and recompile to have freeradius mysql client ask for a SSL connection. hmm, i could see a future with sql.conf containing ssl = yes and each

Re: Mysql connection with SSL

2006-09-06 Thread Alan DeKok
Fabio Pedretti [EMAIL PROTECTED] wrote: Have things progressed since then? No. As always, patches are welcome. Or, you can try hiring a consultant to get it done. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog -

Re: MySQL Connection Failure

2005-07-13 Thread Randy Ross
It would be worth checking you SELinux settings on FC4. rjr Marcin Jessa wrote: On Mon, 11 Jul 2005 17:18:00 -0500 Thomas Tinsley [EMAIL PROTECTED] wrote: Marcin, Hi my name is Tom and I am installing FreeRadius for the first time. Specifications: OS: Fedora Core 4

Re: MySQL Connection Failure

2005-07-12 Thread Marcin Jessa
On Mon, 11 Jul 2005 17:18:00 -0500 Thomas Tinsley [EMAIL PROTECTED] wrote: Marcin, Hi my name is Tom and I am installing FreeRadius for the first time. Specifications: OS: Fedora Core 4 Linux Kernel 2.6.11smp Freeradius version : 1.0.2 1.0.2 has security holes.

Re: MySQL Connection Failure

2005-07-11 Thread Marcin Jessa
On Mon, 11 Jul 2005 14:20:51 -0500 Thomas Tinsley [EMAIL PROTECTED] wrote: Hi my name is Tom and I am installing FreeRadius for the first time. Specifications: OS: Fedora Core 4 Linux Kernel 2.6.11smp Freeradius version : 1.0.2 1.0.2 has security holes. Use 1.0.4