it works fine. As soon as i try this on the mysql System i do not get the
access. The Allowd hosts access still works fine
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Freeradius-mysql-problem-tp4638453p4643540.html
Sent from the FreeRadius - User mailing list
Hi everyone,
I'm new here. My name is Gábor Nagy from Hungary. I'm doing my thesis.
I have some problems with configure the SQL in freeradius-dialupadmin.
Right now when I click on User Statistics or Accounting or Statistics ...
etc...
I get this: DEBUG(SQL,MYSQL DRIVER): Connect: User= root
hi,
got sql defined in your authenticate section of the inner-tunnel (where EAP
packets by default get proxied to) ?
alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi All,
I'm
using mysql server 5.1.30 for storing radius accounting details. The
system works fine and accounting is done to log file and to mysql
server installed in a separate machine.
But the problem arises
when the mysql server is not working. When the radius accounting
But the problem arises
when the mysql server is not working. When the radius accounting server
lost the connectivity to the mysql server it does not report any kind
of error. The radius daemon is working fine in the radius accounting
server. But it does not respond to any requests.
So it
hi, first of all, i thank all people who are giving thier time to help.
before i subscribe here and post my email, i am searching around in
internet since a week
and trying my best to solve it, i have learned many things,but there is one
problem i cannot get it solved.
i am trying to make
Post the entire debug from start to finish and as well as some tests. The
first whack of debug tells you how freeradius is parsing your config.
Once you have that done we should be able to figure where the issue lie.
Take Care,
Leigh
On Fri, Jan 16, 2009 at 8:49 AM, obaid ghaznawi
Just a stupid question.
Is your freeradius compiled with mysql support?
Do you have rlm_sql_mysql in your module dir?
Regards
Luciano
On Fri, Jan 16, 2009 at 11:49 AM, obaid ghaznawi ona...@gmail.com wrote:
hi, first of all, i thank all people who are giving thier time to help.
before i
I would assume that it is, otherwise it would not start with the INCLUDE
uncommented and sql set in authorize.
On Fri, Jan 16, 2009 at 9:18 AM, Luciano Afranllie listas.luaf...@gmail.com
wrote:
Just a stupid question.
Is your freeradius compiled with mysql support?
Do you have
Yes. Post the whole debug including startup. Something is not right here.
authorize is not in radiusd.conf in 2.x.
Ivan Kalik
Kalik Informatika ISP
Dana 16/1/2009, Leigh Martell leigh.mart...@gmail.com piše:
Post the entire debug from start to finish and as well as some tests. The
first whack
Hi,
crle -u -v -l
/usr/local/ssl/lib:/usr/local/lib:/usr/local/BerkeleyDB.4.2/lib:/etc/lib:/usr/share/l
ib:/etc/security/lib:/usr/sfw/lib:/usr/openwin/lib:/usr/css/lib:/usr/xpg4/lib:/usr/dt/lib:/usr/loca
l/mysql/lib/mysql
its cant find development headers - ensure that the
Hi,
I tried to install FreeeRadius 2 on Solaris 10_X86. But it got error on make
here is the error.
firstly, this is 2.0.3 - use 2.0.5
secondly, dd you specify the location / PATH
for the mysql link libraries on the configure
line? are you building as a static or dynamic?
alan
-
List
--
View this message in context:
http://www.nabble.com/FreeRadius-Mysql-Problem-Solaris-tp18126620p18132739.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Umar wrote:
Thanks for your reply. After using 2.0.5 problem is solved but there is
another problem and that is rlm_eap_tls
checking for OpenSSL support... no
...
I have installed openssl from sunfreeware.com and the path is
(/usr/local/ssl). I don't know why freeradius did not found ssl
? See
http://www.freeradius.org/list/users.html
--
View this message in context:
http://www.nabble.com/FreeRadius-Mysql-Problem-Solaris-tp18126620p18147768.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org
in context:
http://www.nabble.com/FreeRadius-Mysql-Problem-Solaris-tp18126620p18126620.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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
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
-
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
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
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
] 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
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
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?
...
: 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
I am doing the following and have an issue
Issue is on the primary I get duplicate entry on accounting in mysql for a user
I don't use this accounting for nothing but users online listing, I have to use
accounting from the detail file for that.
Ok heres the expanation
I use radrelay so each
Sri, ¿it never works ? ¿how did you
build your radius ? ¿what's your platform and mysql version ? ¿sis you
remember to have mysql-devel (mysql headers) available when you build freeradius
?, it seems to me that the driver is not working.
In the message below driver
rlm_sql_mysq is
a typo (should
Hello all, I am trying to configure freeradius with mysql. I
did the relevent changes in radiusd.conf and when i start the server in
debug mode, it is giving an error:"rlm_sql (sql): Could not link driver rlm_sql_mysq: file not foundrlm_sql (sql): Make sure it (all its dependent libraries) are in
On Thu, 2006-16-03 at 10:45 +0100, KNO wrote:
On 3/16/06, Alan DeKok [EMAIL PROTECTED] wrote:
Fabiano Rodrigo Boscatto [EMAIL PROTECTED] wrote:
Hi there, i have freeradius working fine with mysql authentication. The
problem is that the User-Password is stored in mysql table as clear text.
On 3/16/06, Alan DeKok [EMAIL PROTECTED] wrote:
Fabiano Rodrigo Boscatto [EMAIL PROTECTED] wrote:
Hi there, i have freeradius working fine with mysql authentication. The
problem is that the User-Password is stored in mysql table as clear text. Is
there a way to crypt that?
Change
KNO [EMAIL PROTECTED] wrote:
And what I must to do if I want to use MD5 to store the passwords?
Source code modifications.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi there, i have freeradius working fine with mysql
authentication. The problem is that the User-Password is stored in mysql table
as clear text. Is there a way to crypt that?
Thanx
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Fabiano Rodrigo Boscatto [EMAIL PROTECTED] wrote:
Hi there, i have freeradius working fine with mysql authentication. The
problem is that the User-Password is stored in mysql table as clear text. Is
there a way to crypt that?
Change User-Password to Crypt-Password, and encrypt the password
Radius [EMAIL PROTECTED] wrote:
A recent post explained how to fix this. I suggest going back, and
reading all of the messages in this thread.
The uncomment of the lines under sql.conf and
putting the lower_user lower_pass to no
did not fix it.
Because that's not the problem.
The
Some log in errors
Warning: Found 2 auth-types on request for user 'rniclh'
Any idea what this is about?
I seem to be getting this on most of the logins. Even the ones that work.
rlm_unix: Attribute User-Password is required for authentication.
Cannot use CHAP-Password.
Login incorrect:
Radius [EMAIL PROTECTED] wrote:
After updated to 1.04 and making the changes again what you recommend below
and when I try to run radtest I get all kinds of these dup error.
radclient: dict_init:
/usr/local/radius/share/freeradius/dictionary.acc[110]: dict_addvalue:
Duplicate value name
OK,, I'm confused
$ cp ./raddb/dictionary /etc/raddb/dictionary
I have a directory /etc/raddb/dictonary
Do I also need to create ./raddb/dictonary ?
Thanks
Alan DeKok wrote:
Radius [EMAIL PROTECTED] wrote:
After updated to 1.04 and making the changes again what you recommend below
Alan DeKok wrote:
Radius [EMAIL PROTECTED] wrote:
After updated to 1.04 and making the changes again what you recommend below
and when I try to run radtest I get all kinds of these dup error.
radclient: dict_init:
/usr/local/radius/share/freeradius/dictionary.acc[110]: dict_addvalue:
Well, actually it was ver 1.01
But after loading the backup, I now get the same errors.
Well, I guess I just hosed a production server now.
It was all working fine before I tried to make the update.
That will teach me to fix something not broke.
Radius wrote:
Alan DeKok wrote:
Radius
I did get back to 0.93 but I still get the same errors with a local radtest.
But at least people can log in and get authenticated.
Why did they have to mess with directories.
It was working fine where they had it, now this system is totally hosed
because I can find what else they embedded in
Radius [EMAIL PROTECTED] wrote:
I have a directory /etc/raddb/dictonary
FreeRADIUS never created that.
It should be a file.
See raddb/dictionary in the 1.0.4 source distribution.
it says in there that they are at /usr/local/share/freeradius/
and they are there. I did the default
Alan DeKok wrote:
Radius [EMAIL PROTECTED] wrote:
I have a directory /etc/raddb/dictonary
FreeRADIUS never created that.
It should be a file.
It was a file. I should have been more clear.
See raddb/dictionary in the 1.0.4 source distribution.
it says in there
Sorry, I take that back
I used ./configure --localstatedir=/var --sysconfdir=/etc
because when I went to 0.93 last year I was using Cistron.
Alan DeKok wrote:
Radius [EMAIL PROTECTED] wrote:
I have a directory /etc/raddb/dictonary
FreeRADIUS never created that.
It should
I re-ran the install as you said below.
I think it's working, I just have to get used to adding /opt/freeradius
in the command lines.
Been watching with the radiusd -x and can even run a radtest
But now I'm back to the original problem to deny anything with UPPER
CASE letters to
prevent
Radius [EMAIL PROTECTED] wrote:
I re-ran the install as you said below.
I think it's working, I just have to get used to adding /opt/freeradius
in the command lines.
Been watching with the radiusd -x and can even run a radtest
Exactly. The problem, as evidenced by your multiple recent
Alan DeKok wrote:
Radius [EMAIL PROTECTED] wrote:
I re-ran the install as you said below.
I think it's working, I just have to get used to adding /opt/freeradius
in the command lines.
Been watching with the radiusd -x and can even run a radtest
Exactly. The problem, as
I currently run ver.0.9.3
I have MySql database that is used with FreeRadius.
What were are having a problem with is that if the
user logs in with UPPER-NAME or lower-name
either one works.
I have tried lower_user lower_pass before/after/no
and the radius system still authenticates all
Subject: [radius] Freeradius/MySql problem
I currently run ver.0.9.3
I have MySql database that is used with FreeRadius.
What were are having a problem with is that if the
user logs in with UPPER-NAME or lower-name
either one works.
I have tried lower_user lower_pass before/after
and solved it by changing it in the config.
Nick Marino - IT Solutions
- Original Message - From: Radius [EMAIL PROTECTED]
To: freeradius-users@lists.freeradius.org
Sent: Saturday, July 02, 2005 12:10 PM
Subject: [radius] Freeradius/MySql problem
I currently run ver.0.9.3
I have MySql database
@lists.freeradius.org
Sent: Saturday, July 02, 2005 12:10 PM
Subject: [radius] Freeradius/MySql problem
I currently run ver.0.9.3
I have MySql database that is used with FreeRadius.
What were are having a problem with is that if the
user logs in with UPPER-NAME or lower-name
either one works.
I have tried
Let me look at my files and find the exact entry.
Nick Marino - IT Solutions
- Original Message -
From: Radius [EMAIL PROTECTED]
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Saturday, July 02, 2005 12:36 PM
Subject: Re: [radius] Freeradius/MySql problem
- Original Message -
From: Radius [EMAIL PROTECTED]
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Saturday, July 02, 2005 12:42 PM
Subject: Re: [radius] Freeradius/MySql problem
OK, let me try this way, when our wholesale provider receives a realm,
they know
]
To: FreeRadius users mailing list
freeradius-users@lists.freeradius.org
Sent: Saturday, July 02, 2005 12:36 PM
Subject: Re: [radius] Freeradius/MySql problem
In the radius.conf under lower_user lower_pass
I tried all three. before/after/no and they will still authenticate
all UPPER CASE.
What
, 2005 12:42 PM
Subject: Re: [radius] Freeradius/MySql problem
OK, let me try this way, when our wholesale provider receives a
realm, they know where
to send the request.
If the user sends [EMAIL PROTECTED] or [EMAIL PROTECTED]
our radius regardless if I have lower_user before/after
freeradius-users@lists.freeradius.org
Sent: Saturday, July 02, 2005 12:42 PM
Subject: Re: [radius] Freeradius/MySql problem
OK, let me try this way, when our wholesale provider receives a
realm, they know where
to send the request.
If the user sends [EMAIL PROTECTED] or [EMAIL PROTECTED]
our
- IT Solutions
- Original Message -
From: Radius [EMAIL PROTECTED]
To: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Sent: Saturday, July 02, 2005 1:23 PM
Subject: Re: [radius] Freeradius/MySql problem
Yes, I found what you mention below in the radius.conf
I
- Original Message - From: Radius [EMAIL PROTECTED]
To: FreeRadius users mailing list
freeradius-users@lists.freeradius.org
Sent: Saturday, July 02, 2005 1:23 PM
Subject: Re: [radius] Freeradius/MySql problem
Yes, I found what you mention below in the radius.conf
I will look through
On Sat, Jul 02, 2005 at 10:42:44AM -0700, Radius wrote:
OK, let me try this way, when our wholesale provider receives a realm,
they know where
to send the request.
If the user sends [EMAIL PROTECTED] or [EMAIL PROTECTED]
our radius regardless if I have lower_user before/after/no
They
After updated to 1.04 and making the changes again what you recommend below
and when I try to run radtest I get all kinds of these dup error.
radclient: dict_init:
/usr/local/radius/share/freeradius/dictionary.acc[110]: dict_addvalue:
Duplicate value name Administrative-reset for attribute
Hi all!
I'm having heavy problem to get my poptop-server
authenticate with freeradius. I can't locate the error
... so, here I am!
freeradius:
pptpd1:~ # /usr/sbin/radiusd -v
radiusd: FreeRADIUS Version 1.0.0, for host , built on
Oct 5 2004 at 00:13:22
(SuSe 9.2 precompiled-rpm-package)
ppp:
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
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,
Im testing the expiration attribute in a freeradius 1.0.1 + mysql instalation.
I have a user with the following attributes:
mysql select * from radcheck;
++--+++-+
| id | UserName | Attribute | op | Value |
I think u need to use for exapmle :
8 October 2004 12:00:00
For me this format works great!
Greetings
Im testing the expiration attribute in a freeradius 1.0.1 + mysql
instalation.
I have a user with the following attributes:
mysql select * from radcheck;
Dear all
I have installed new FreeRadius version 1.0+MySQL and
configured rml_sql
RADIUS server running ok
while registering a user server throws error. Error message is
auth: No authenticate method (Auth-Type) configuration found
for the request: Rejecting the user
auth: Failed
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, July 11, 2004 9:24 PM
Subject: Re: FreeRadius+Mysql Problem
Hi,
I have already installed freeradius 0.9.3 in Redhat
Linux 9.0 and mysql 3.23.33 I am sending the
supportive files if u have any doubt plz contact me
with the subject
G'Day
Did you build FreeRADIUS with MySQL support? Did you specify the MySQL
header files location? Also, you need to have MySQL-devel-x.x.xx-x installed
before building the FreeRADIUS binaries.
Regards,
Eki
After I install Mysql-standard-4.0.18-pc-linux-i686(in=
/usr/local/mysql/include mysql.
-Original Message-
From: [EMAIL PROTECTED] on behalf of Yyc
Sent: Sat 7/10/2004 6:24 AM
To: Post
Cc:
Subject: FreeRadius+Mysql Problem
After I install Mysql-standard-4.0.18-pc
hi,
the problem is with the syntax,
the quotes are missing for the %{Acct-Delay-Time}
just add the quotes like in AcctStopDelay = '%{Acct-Delay-Time}'
WHERE.
this shld solve the problem
regards,
manjunath
Thankyou.
--
technik :-)
ICQ: 270532579
AIM: gyuriszabo
-
List
On Wed, Jun 09, 2004 at 09:33:45AM +0530, Manjunath M Prabhu wrote:
hi,
the problem is with the syntax,
the quotes are missing for the %{Acct-Delay-Time}
just add the quotes like in AcctStopDelay = '%{Acct-Delay-Time}'
WHERE.
this shld solve the problem
regards,
manjunath
send the complete query please, here appears as a sintax error, would help
seeing the query
- Original Message -
From: Szabó György [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 11:01 AM
Subject: MySQL problem
Hi.
The radius.log contains the following lines
Hi.
The radius.log contains the following lines:
Info: rlm_sql (sql): received Acct On/Off packet
Error: rlm_sql (sql): Couldn't update SQL accounting for Acct On/Off packet -
You have an error in your SQL syntax near 'WHERE AcctSessionTime=0 AND
AcctStopTime=0 AND NASIPAddress= '192.168.1.4'
send the complete query please, here appears as a sintax error, would help
seeing the query
Ok. I have attached.
--
technik :-)
ICQ: 270532579
AIM: gyuriszabo
Tue Jun 8 18:19:43 2004 : Info: Using deprecated naslist file. Support for this will go away soon.
Tue Jun 8 18:19:43 2004 :
: Re: MySQL problem
send the complete query please, here appears as a sintax error, would
help
seeing the query
Ok. I have attached.
--
technik :-)
ICQ: 270532579
AIM: gyuriszabo
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Szabó_György,ÄúºÃ£¡
i have meeted the same problem recently, i don't know what's wrong.
i just modify the sql query and ignore it cause of i have to use my own special sql
query.
=== 2004-06-09 02:01:05 ÄúÔÚÀ´ÐÅÖÐдµÀ£º===
Hi.
The radius.log contains the following lines:
: Wednesday, June 09, 2004 1:33 AM
To: [EMAIL PROTECTED]
Subject: Re: MySQL problem
send the complete query please, here appears as a sintax error, would help
seeing the query
- Original Message -
From: Szabó György [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 11:01
Hello all!,
I would like to config my freeradius server to store all the auth. info (also the
acct. info) in a mysql database. I've deployed the database definition included with
the freeradius source code, but it seems there is a problem with the rlm_ippool
interaction:
Module:
On Tue, 24 Feb 2004, Javier Castillo Alcibar wrote:
Hello all!,
I would like to config my freeradius server to store all the auth. info (also
the acct. info) in a mysql database. I've deployed the database definition
included with the freeradius source code, but it seems there is a problem
78 matches
Mail list logo