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.htm
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 tab
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" wrote:
>
&
100
> 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 serve
On 31 Oct 2012, at 09:02, "Fajar A. Nugraha" wrote:
> On Wed, Oct 31, 2012 at 3:57 PM, 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
>
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 doin
On Wed, Oct 31, 2012 at 3:57 PM, 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 hel
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 ???
regards,
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.
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 mid-s
Hi Friends,
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? If I set it to larger, can
it cause MySQL problem of “Too many connection”.
I can’t find detai
=rasana@lists.freeradius.org]
On Behalf Of Apostolos Pantsiopoulos
Sent: Wednesday, April 07, 2010 13:37
To: freeradius-users@lists.freeradius.org
Subject: Re: Permanent mysql connection in mod_perl
Have a look at the CLONE special function in rlm_perl documentation.
Initiate your db connections
: freeradius-users@lists.freeradius.org
> Subject: Re: Permanent mysql connection in mod_perl
>
> Have a look at the CLONE special function in rlm_perl documentation.
> Initiate your db connections in that function.
>
Unfortunately I'm not familiar with this function, as I have searched , I thi
Have a look at the CLONE special function in rlm_perl documentation.
Initiate your db connections in that function.
--
---
Apostolos Pantsiopoulos
Kinetix Tele.com R & D
email: r...@kinetix.gr
---
On 7/4/2010 12:01 μ
Hi,
I'm using mod_perl in my radius configuration and using it I write some
logs to database.
Today I noticed that, there are lots of mysql connections in TIME_WAIT
state.
# netstat -epn --tcp | grep TIME_WAIT | wc -l
15015
netstat -epn --tcp | grep TIME_WAIT | tail -1
tcp 0 0 192.168.1.4:49060
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 FreeRAD
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, rea
>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): A
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
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 && developme
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
i then i download the all of files from www.fre
just have it all 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 setting the port number to something different I used "port =
> " .. 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 setup
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 sid
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 to
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 se
This is getting off-topic, but...
Anders Holm wrote:
>
> From: you
> Sender: freeradius-users-bounces...
> Reply-To: [EMAIL PROTECTED]
> To: freeradius-users@
>
>
> 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 Manag
From: you
Sender: freeradius-users-bounces...
Reply-To: [EMAIL PROTECTED]
To: freeradius-users@
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 <[EMAIL PROTECT
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
> ..
t;[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
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".
few. Would you have others as well?
Suggestions are welcome in all cases ..
//anders
- Original Message -
From: "Alan DeKok" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list" [EMAIL PROTECTED]>
Sent: Monday, June 9, 2008 5:57:48 PM GMT +00:00 GMT Britain,
Ir
y, June 9, 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
ng list"
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 will need to edit th
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 ea
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
system,
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 problem with
> creating a patch and send it in is more that I am not a coder really. I'd be
> more li
create more problems then I'd solve .. ;)
//anders
- Original Message -
From: "Ivan Kalik" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
Sent: Monday, June 9, 2008 5:28:44 PM GMT +00:00 GMT Britain, Ireland, Portugal
Subject: Re: MySQL connection o
t; <[EMAIL PROTECTED]> piše:
>Where $driver has a value of rlm_sql_mysql?
>
>//anders
>
>
>- Original Message -
>From: "Ivan Kalik" <[EMAIL PROTECTED]>
>To: "FreeRadius users mailing list"
>Sent: Monday, June 9, 2008 2:51:09 PM GMT +00:00 G
Where $driver has a value of rlm_sql_mysql?
//anders
- Original Message -
From: "Ivan Kalik" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
Sent: Monday, June 9, 2008 2:51:09 PM GMT +00:00 GMT Britain, Ireland, Portugal
Subject: Re: MySQL connecti
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
Hi folks.
I'm wondering, would it be possible to encrypt the connection to the backend
data store (it being MySQL) using SSL? MySQL would have support for this, but I
sppear to not find any documentation for Freeradius on how to set that side up
for it .. Any pointers appreciated ..
//anders
Hi,
> I add the following line to the /etc/init.d/radiusd :
> start)
># Palliatif au pb du non-demarrage de radiusd apres reboot
># cf freeradius-users@lists.freeradius.org thread "no start of
> radiusd after reboot : mysql connection error"
>
at can be done in
FreeRADIUS to fix that
OK, I'm not expert enough in networking to debug that. So I come back to
my dirty solution.
I add the following line to the /etc/init.d/radiusd :
start)
# Palliatif au pb du non-demarrage de radiusd apres reboot
# cf freeradius-users
mailinglists wrote:
> After reboot, freeradius does'nt start, and says this is because it
> could'nt reach the mysql database. But it doesn't even tries to contact
> it (networkingly-speaking : tcpdump sees nothing).
> Just after reboot, if root runs "/etc/init.d/radiusd start", freeradius
> starts
I'm sorry to bother you with debug log files, but I really dont' see
what to do...
before the log... I summarize my problem :
After reboot, freeradius does'nt start, and says this is because it
could'nt reach the mysql database. But it doesn't even tries to contact
it (networkingly-speaking : t
Jeffrey Hutzelman a écrit :
Wed Feb 6 16:17:49 2008 : Error: rlm_sql_mysql: Mysql error 'Can't
connect to MySQL server on '192.168.1.1' (113)'
Errno 113 is EHOSTUNREACH. Either there is no route to the MySQL
server, or it locally-connected and not answering ARP's, or something
is filtering
--On Thursday, February 07, 2008 10:24:11 AM +0100 Alan DeKok
<[EMAIL PROTECTED]> wrote:
mailinglists wrote:
Hello,
I use freeradius-1.1.3-1.2.el5 and freeradius-mysql-1.1.3-1.2.el5. the
mysql database (mysql-server-5.0.22-2.1.0.1) is hosted on a remote host
(both centos5).
When I use /etc/ini
Hi,
> Yes I already check that, SELINUX is disabled
>
> [EMAIL PROTECTED] ~]# cat /etc/selinux/config
> SELINUX=disabled
> SELINUXTYPE=targeted
> SETLOCALDEFS=0
>
> another idea ? perhaps something with permissions on binaries ?
what happens if you start the daemon from the command line
with
[EMAIL PROTECTED] a écrit :
Hi,
Do you mean that I must allow my user on the mysql server ? I don't think
so, since there is no traffic from the freeradius to mysql at boot time.
And furthermore, the user *is* allowed to connect to database from the
free-radius host
There are perhaps permi
Hi,
> Do you mean that I must allow my user on the mysql server ? I don't think
> so, since there is no traffic from the freeradius to mysql at boot time.
> And furthermore, the user *is* allowed to connect to database from the
> free-radius host
> There are perhaps permissions problems on the
Alan DeKok a écrit :
mailinglists wrote:
Hello,
I use freeradius-1.1.3-1.2.el5 and freeradius-mysql-1.1.3-1.2.el5. the
mysql database (mysql-server-5.0.22-2.1.0.1) is hosted on a remote host
(both centos5).
When I use /etc/init.d/radiusd as root it starts up correctly. But when
the service is
mailinglists wrote:
> Hello,
> I use freeradius-1.1.3-1.2.el5 and freeradius-mysql-1.1.3-1.2.el5. the
> mysql database (mysql-server-5.0.22-2.1.0.1) is hosted on a remote host
> (both centos5).
> When I use /etc/init.d/radiusd as root it starts up correctly. But when
> the service is launched at bo
Hello,
I use freeradius-1.1.3-1.2.el5 and freeradius-mysql-1.1.3-1.2.el5. the
mysql database (mysql-server-5.0.22-2.1.0.1) is hosted on a remote host
(both centos5).
When I use /etc/init.d/radiusd as root it starts up correctly. But when
the service is launched at boot time, I get this error-lo
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
Hi,
I'd like to know if there is a way to securing access to a Mysql
server from freeradius. I found this thread with a patch enabling SSL
connections:
http://lists.freeradius.org/mailman/htdig/freeradius-users/2005-March/042059.html
Have things progressed since then?
Fabio
-
List info/su
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:
>>>
I am running FC 4 with freeradius 1.0.3 and mysql 4.1.11. I can
authenticate to a MYSQL database, with NTRadPing Test Utility, when running
in debug BUT, I can not get FreeRadius to authenticate when I am running the
daemon.
I have changed the user and group both to root and I still can not get
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
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.
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
MySQL version : 4.1.11
DEBUG Info:
Mon Jul 11 14:05:01 2005 : Error: rlm_sql (sql): Failed to connect DB handle
#4
Mon J
I've noticed a strange behaviuor of radius and mysql:
When starting radius presistent connections created to the mysql server.
then load goes higher, once freeradius stops using one or more of the
connections. When connection timeout reached (nothing done on that
connection) or the
61 matches
Mail list logo