artext-Password := "myclientspassword"
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 FreeR
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 ,Pas
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
> 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 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 serv
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" piše:
>Post the entire debug from start to finish and as well as some tests. The
>first whack of debug tells you h
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 wrote:
> Just a stupid question.
>
> Is your freeradius compiled with mysql support?
>
> Do you have rlm_sql_mysql in your module dir?
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 wrote:
> hi, first of all, i thank all people who are giving thier time to help.
>
> before i subscribe here an
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 wrote:
> hi,
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 hotspot
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 --with-openssl-
the dynamic linker path. See
> "man crle".
>
> Alan DeKok.
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
--
View this message in context:
http://www.nabble.com/FreeRadius-Mysql-Problem-Solaris-tp18126620p18147768.
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 s
; alan
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
--
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
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 info/
e help me what should i do?
--
View this message 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
: 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
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
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]&
;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?
>
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
"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
: 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
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
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
?
If so is the solution just not running radrelay on the primary?
_
From: Jeff [mailto:[EMAIL PROTECTED]
To: FreeRadius users mailing list [mailto:[EMAIL PROTECTED]
Sent: Wed, 20 Jun 2007 10:52:01 -0400
Subject: Primary, Secondary, Radrelay, Mysql Problem
I am doing the following
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 radiu
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 i
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
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
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?
>
>
"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 pass
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
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 incorrec
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
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 evidenc
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
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 dou
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
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 th
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 th
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 th
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 <[E
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:
Du
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
a
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
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 Acc-
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
>
- Original Message - From: "Radius" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
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 the sql
- IT Solutions
- Original Message -
From: "Radius" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
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
ge - From: "Radius" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
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.
s users mailing list"
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 radius re
t; <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
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 UPP
er = before
lower_pass = before
Nick Marino - IT Solutions
- Original Message -
From: "Radius" <[EMAIL PROTECTED]>
To: "FreeRadius users mailing list"
Sent: Saturday, July 02, 2005 12:42 PM
Subject: Re: [radius] Freeradius/MySql problem
OK, let me try this way,
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"
Sent: Saturday, July 02, 2005 12:36 PM
Subject: Re: [radius] Freeradius/MySql problem
t;
To:
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
and solved it by changing it in the config.
Nick Marino - IT Solutions
- Original Message - From: "Radius" <[EMAIL PROTECTED]>
To:
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
In the config file you can set it to force all lower case.
I had this problem and solved it by changing it in the config.
Nick Marino - IT Solutions
- Original Message -
From: "Radius" <[EMAIL PROTECTED]>
To:
Sent: Saturday, July 02, 2005 12:10 PM
Subject: [radius]
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 UPPER-
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, U
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 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:
ve
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;
++--+++
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 |
++--+--
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: Faile
Melkin dev" <[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
ymbolic link:
"ln -s /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 instal
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-x-lin
After I install Mysql-standard-4.0.18-pc-linux-i686(in
/usr/local/mysql-x-linux-i686) + Freeradius(1.0.0.pre3),my OS is RedHat 9.0,and i
try to connect freeradius and mysql
radiusd -X give me the following message:
rlm_sql (sql): Could not link driver rlm_sql_mysql: file not foun
> 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 in
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
CTED]
Sent: 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]&
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:
>
>I
June 08, 2004 11:24 AM
Subject: 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
> 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 : I
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' AN
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.
>
ostas
Kalevras
Enviado el: martes, 24 de febrero de 2004 13:08
Para: [EMAIL PROTECTED]
Asunto: Re: rlm_ippool + mysql problem
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.
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 probl
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: Load
81 matches
Mail list logo