Hi All,
I have a requirement to set up freeradius with MySQL in my environment.
I was able to find the DDL Script required for MYSQL Database to be built.
Is there a complete How-to from Scratch for compiling free radius to work
with MySQL on Ubuntu. Please advice.
Thanks
JK
-
List info/subscribe
hi,
i would like to implement dhcp over radius! is there any mysql support?
my dhcp config looks like this!
=== snip ==
shared-network X {
if substring(option vendor-class-identifier, 0, 2) = "SN" {
next-server X.X.X.X;
filename = concat("/inalp/", option vendor-class-identifier,
Have you decommented the "$INCLUDE sql.conf" line in radiusd.conf?
I had the same problem when I compiled freeradius-2.1.8. If I compiled
freeradius without libmysqlclient15-dev package the problem appeared.
Try it.
2010/5/14 dorra aa
> hi
> i installed mysql.
>
> and i modify in /etc/freera
hi
i installed mysql.
and i modify in /etc/freeradius/sql.conf:
readclients=yes
also, i decommented in /etc/freeradius/radiusd.conf:
accounting
{
sql}
authorize
{...
sql}
i run again freeradius -X:
but it seems failed because of sql: this is the output
[...]
sql: postauth_query = "INSERT i
hi
i installed mysql.
and i modify in /etc/freeradius/sql.conf:
readclients=yes
also, i decommented in /etc/freeradius/radiusd.conf:
accounting
{
sql}
authorize
{...
sql}
i run again freeradius -X:
but it seems failed because of sql: this is the output
[...]
sql: postauth_query = "INSERT i
I use MD5 pass and SHA pass:
user SHA-Password := pass
user MD5-Password := pass
2010/4/30 Alan DeKok
> David Seira wrote:
> > You can try to put "Password" attribute instead of "Cleartext-Password".
>
> Please no. Don't use "Password" or "User-Password".
>
> > The operator is also impor
David Seira wrote:
> You can try to put "Password" attribute instead of "Cleartext-Password".
Please no. Don't use "Password" or "User-Password".
> The operator is also important:
>
> user Password == pass
Again, no.
userCleartext-Password := "password"
The FAQ has an example of th
You can try to put "Password" attribute instead of "Cleartext-Password". The
operator is also important:
user Password == pass
2010/4/29 John Dennis
> On 04/29/2010 02:27 PM, VU VAN HUNG wrote:
>
>> Hi all,
>> I got a problem with freeradius and mysql. My freeradius server cannot
>> read data f
On 04/29/2010 02:27 PM, VU VAN HUNG wrote:
Hi all,
I got a problem with freeradius and mysql. My freeradius server cannot
read data from radcheck table. It notice that No Cleartext-Password's
Configured, even if I totally set Attribute field in radcheck table is
Cleartext-Password.
Could someones
Hi all,
I got a problem with freeradius and mysql. My freeradius server cannot
read data from radcheck table. It notice that No Cleartext-Password's
Configured, even if I totally set Attribute field in radcheck table is
Cleartext-Password.
Could someones help me solve this problem ?
Hung,
-
Li
Dear all,
Problem solved. Using Auth-Type attribute in radcheck table solve the
problem.
Cheers.
cktan wrote:
Dear all,
I've a freeradius server running with LDAP as the Authentication and
Authorization where else Accounting running on Mysql. It was working
well at the moment and I'm look
Dear all,
I've a freeradius server running with LDAP as the Authentication and
Authorization where else Accounting running on Mysql. It was working
well at the moment and I'm looking to migrate from LDAP to run fully in
Mysql.
Question is I need to have control on remote access for certain u
man.lists=gmail@lists.freeradius.org] On Behalf Of Alan
> DeKok
> Sent: Wednesday, August 05, 2009 3:30 AM
> To: FreeRadius users mailing list
> Subject: Re: unable to connection freeradius with mysql
>
> shivashankar wrote:
> > i am useing freeradius2.1.6 and mysql5.0 on solaris1
shivashankar wrote:
> i am useing freeradius2.1.6 and mysql5.0 on solaris10.
>
> when ever i start the server radiusd -X . i am getting below problem.
>
> i think it is not connected to mysql.plz help me how to connect
READ the debug messages?
> rlm_sql (sql): Attempting to connect rlm_sql_my
ser-Name, Acct-Session-Id, NAS-IP-Address,
Client-IP-Address, NAS-Port"
}
Module: Checking accounting {...} for more modules to load
Module: Instantiating detail
detail {
detailfile =
"/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d"
header = &
gt; Ivan Kalik
>> Kalik Informatika ISP
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>>
>
>--
>View this message in context:
>http://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with
he user entry when startdate is reached.
> >
> > Ivan Kalik
> > Kalik Informatika ISP
> >
> > -
> > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
> >
> >
>
> --
> View this message in context:
> http://w
n startdate is reached.
>
> Ivan Kalik
> Kalik Informatika ISP
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
--
View this message in context:
http://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with-MySql--tp1983
>Any thoughts?
>
Don't create the username before the startdate. There is absolutely no
reason for it to be in the database before it. Make a script that
creates the user entry when startdate is reached.
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See http://www.freeradiu
Any thoughts?
Johan
--
View this message in context:
http://www.nabble.com/Startdate-for-sessions-in-FreeRadius-with-MySql--tp19837587p19837587.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>rad_recv: Access-Request packet from host 192.168.1.7:1119, id=0, length=44
>User-Name = "fred"
>User-Password = "wilma"
> Processing the authorize section of radiusd.conf
>modcall: entering group authorize for request 0
> modcall[authorize]: module "preprocess" returns ok for re
hi,
turn on the SQL debug logging in FreeRADIUS and see
what the output of the SQl was
alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
His name
Thanx,
I do it and get this output:
*freeradius -X output:*
Starting - reading configuration files ...
reread_config: reading radiusd.conf
Config: including file: /etc/freeradius/proxy.conf
Config: including file: /etc/freeradius/clients.conf
Config: including file: /etc/freeradiu
Debug with capital X ==> radiusd -X.
Ivan Kalik
Kalik Informatika ISP
Dana 23/1/2008, "mohsen rahmanian" <[EMAIL PROTECTED]> piše:
>Hi dears,
>
>I install freeradius, MySQL on Ubuntu 7 and work correctly with file
>authentication, but where follow "http://wiki.freeradius.org/SQL_HOWTO";
>instru
Hi dears,
I install freeradius, MySQL on Ubuntu 7 and work correctly with file
authentication, but where follow "http://wiki.freeradius.org/SQL_HOWTO";
instruction don't get any response. my output when run 'freeradius -x' are:
Starting - reading configuration files ...
Using deprecated nasl
It works!
Thank you for answering!
Daniel Bojczuk
> Daniel Bojczuk wrote:
> ...
>> rlm_sql (sql): Released sql socket id: 4
>> modcall[authorize]: module "sql" returns ok for request 0
>> modcall: group authorize returns ok for request 0
>> rad_check_password: Found Auth-Type System
>> auth:
Daniel Bojczuk wrote:
...
> rlm_sql (sql): Released sql socket id: 4
> modcall[authorize]: module "sql" returns ok for request 0
> modcall: group authorize returns ok for request 0
> rad_check_password: Found Auth-Type System
> auth: type "System"
> ERROR: Unknown value specified for Auth-Ty
> Run the server in debugging mode, as suggested in the FAQ, README,
> INSTALL, and daily on this list.
Thank's for the tip. I'm new on this list too!
I run freeradius in debug mode. The error is bellow:
rlm_sql (sql): Released sql socket id: 4
modcall[authorize]: module "sql" returns ok for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alan DeKok wrote:
>> Someone can help-me? It's the first time I'm using freeradius.
>
> Run the server in debugging mode, as suggested in the FAQ, README,
> INSTALL, and daily on this list.
>
Launch, as root, "radiusd -X -A" and study the output.
Daniel Bojczuk wrote:
> Hi.. I'm developing an authentication system using Freeradius 1.0.2
Please upgrade to 1.1.4, which should be in Debian.
> The log file shows me:
> Tue Feb 27 11:01:14 2007 : Auth: Login incorrect: [daniel] (from client
> testee port 0)
>
> Someone can help-me? It's the
Hi.. I'm developing an authentication system using Freeradius 1.0.2 with
mysql
4.0.24_Debian-10sarge2-log.
In mysql I have the database radius:
+--+
| Tables_in_radius |
+--+
| nas |
| radacct |
| radcheck |
| radgroupcheck|
| radgr
Hello,
I have installed a freeradius with mysql and dialupadmin , but I need to
migrate theusers of system and the passwords that are in /etc/shadow
are encrypted with DES and crypt of dialupadmin use MD5, How Do I can
do to migrate this users? any idea? or How do I make for that crypt of
Hi all,
As suggested by Michael, I've recompiled Mysql with
--enable-thread-safe-client and now it works.
Thanks to Michael
Best regards,
-- Disclaimer
Ce message ainsi que les eventuelles pieces jointes constituent une
correspondance privee et confidenti
> It works for 1.0.5 but not for 1.1.1 (and also KO for 1.1.0):
[...]
> checking for mysql_init in -lmysqlclient_r... no
> configure: warning: mysql libraries not found. Use
> --with-mysql-lib-dir=.
> checking for mysql/mysql.h... yes
I had the same problem yesterday. You have to recompile
"Philippe JOYEZ" <[EMAIL PROTECTED]> wrote:
> I'm trying to upgrade my 1.0.5 Freeradius server to 1.1.1 on my Solaris
> 8 system but it fails to find mysql libs. On the same server, I use the
> same configure scripts options:
Use:
$ LIBS=-lm -lz ./configure
Alan DeKok.
-
List info/s
users@lists.freeradius.org
Subject: Failed Compilation of Freeradius with Mysql since 1.1.0 (Works
on1.0.5)
Hello All,
I've seen many topics about that problem but no one of them has solved my
problem.
I'm trying to upgrade my 1.0.5 Freeradius server to 1.1.1 on my Solaris
8 system but it fail
Hello All,
I've seen many topics about that problem but no one of them has solved my
problem.
I'm trying to upgrade my 1.0.5 Freeradius server to 1.1.1 on my Solaris
8 system but it fails to find mysql libs. On the same server, I use the
same configure scripts options:
./configure --local
On Sat, 2006-25-02 at 14:52 -0500, Alan DeKok wrote:
> [EMAIL PROTECTED] wrote:
> > the ports for freeradius don't seem to install correctly, and when we
> > build from lates binaries there is errors when trying to load mysql... In
> > the mandrake 10.2 system I had - all I did was install mysqlxx-
[EMAIL PROTECTED] wrote:
> We've been trying to get freeradius, freebsd and mysql to all work
> together now for a week... If anyone has figured out how to do this -
> please let me know. There are literally hundreds of posts on various
> forums I found by googleing the errors and all are having th
[EMAIL PROTECTED] wrote:
> the ports for freeradius don't seem to install correctly, and when we
> build from lates binaries there is errors when trying to load mysql... In
> the mandrake 10.2 system I had - all I did was install mysqlxx-dev
> development extensions, and all was good... I can't fin
On 2/25/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> We've been trying to get freeradius, freebsd and mysql to all work
> together now for a week... If anyone has figured out how to do this -
> please let me know. There are literally hundreds of posts on various
> forums I found by googleing
We've been trying to get freeradius, freebsd and mysql to all work
together now for a week... If anyone has figured out how to do this -
please let me know. There are literally hundreds of posts on various
forums I found by googleing the errors and all are having the same
issues...
the ports for f
ed help on sering
freeradius with MySQL
Install the header files
( which should be automatically placed in /usr/include/mysql ), and then run
the configure script like
. ./configure --with-mysql-include-dir= --with-mysql-lib-dir= --with-mysql-dir=
Just as marco said... that shouldn’t
be
Seferovic
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alex M
Sent: Sonntag, 23. Oktober 2005
19:40
To: [EMAIL PROTECTED];
'FreeRadius users mailing list'
Subject: RE: meed help on sering
freeradius with MySQL
Ok, I just tested that
mysql client
?
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Seferovic Edvin
Sent: Sunday, October 23, 2005
1:27 PM
To: 'FreeRadius users mailing
list'
Subject: RE: meed help on sering
freeradius with MySQL
Hi,
while installing RedHat (
again I suppose )..
. Oktober 2005
18:45
To: 'FreeRadius
users mailing list'
Subject: RE: meed help on sering
freeradius with MySQL
I tried that but it
doesn’t work L what can I do?
Let me try to start all
over again, I will do:
Install Red Hat
Install MySQL Client
Test MySQL Clint (How?
list
Subject: Re: meed help on sering
freeradius with MySQL
Hi,For example the following line tells you that during installation the header files weren't foundsql_mysql.c:40:19: mysql.h: No such file or directoryIf you have installed mysql you have to tell the configure script, where the
Hi,For example the following line tells you that during installation the header files weren't foundsql_mysql.c:40:19: mysql.h: No such file or directoryIf you have installed mysql you have to tell the configure script, where the mysql- include- library- and the mysql programmon you box "lives" l
Hi, im newbie to Linux, but I was able to install freeradius
to red hat 9.0 and it works with text file….
Then I allow it to use SQL, but is start with error that no
driver is found in libabry, I did everythin was said in FAQ, such as
–disable-shared, but that didnr work, that I figured th
On Tue, 2005-01-11 at 17:47 +0200, Mark Elkins wrote:
> I'm in need of some advice - ... move to freeradius...
> In my current MySql structure - I have a master user table (useracct) -
> containing fields like...
>
> | userid | usertype | username | fullname | password | contact | uid |
> gid | p
I'm in need of some advice - I'm playing with a quite old icradius setup
and also looking to move to freeradius...
In my current MySql structure - I have a master user table (useracct) -
containing fields like...
| userid | usertype | username | fullname | password | contact | uid |
gid | phone |
/etc/raddb/radiusd.conf)
--
Regards,
Thor Spruyt
E: [EMAIL PROTECTED]
W: www.thor-spruyt.com
M: +32 (0)475 67 22 65
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, October 08, 2004 5:26 PM
Subject: freeradius with Mysql Data Base
Dear list:
This is
Dear list:
This is my first experience with freeradius.
I installed freeradius-1.0.1.tar.gz
into a Red Hat box 7.3 (it is
old but I don´t have other option), however radius server is running OK.
This week I worked with PPP basic authentication and authorization options
working clients and user fl
Hi,
There's a howto here: http://www.frontios.com/freeradius.html
Regards
--- "Joel n.solanki" <[EMAIL PROTECTED]> wrote:
> Dear freeradius gurus,
>
> I am very new to radius.Just know what is radius nothing more :)
>
> I have downloaded freeradius-0.9.2.tar.gz and installed it. My system
> is
h, 14. Juli 2004 10:44
An: freeradius-users
Betreff: freeradius--with mysql database???
Dear freeradius gurus,
I am very new to radius.Just know what is radius nothing more :)
I have downloaded freeradius-0.9.2.tar.gz and installed it. My system is
Redhat 9.0
Problem:- I want my pppoe use
Dear freeradius gurus,
I am very new to radius.Just know what is radius nothing more :)
I have downloaded freeradius-0.9.2.tar.gz and installed it. My system is
Redhat 9.0
Problem:- I want my pppoe users to authenticate with freeradius and the
(Usernames / Passwords) should be in mysql database
"Milver S. Nisay" <[EMAIL PROTECTED]> wrote:
> My problem is that I would like to make use of Exec-Program-Wait to
> execute a script in order to process some additional authentication
> parameters. Is there anyway I can do this since I'm using MySQL for
> authorisation?
Yes. List it in "radrep
On Mon, May 17, 2004 at 01:40:08PM +0200, Joe Borg wrote:
> Thanks for the tip. By any chance, would you be able to refer me to some
> documentation/information on how to go about doing this? I'm still
> somewhat green to MySQL. Thanks.
If you already understand how to use the users file, then the
- Original Message -
Hi,
Im in the process of seeting up a
new RADIUS server using Freeradius. I intend using MySQL for Authorisation and
Accounting. As a result, I will not be making use of the users file (since
MySQL is configured for use in Radiusd.conf, there
t: 17 May 2004 12:36
To: [EMAIL PROTECTED]
Subject: Re: Freeradius with MySQL and Exec-Program-Wait
On Mon, May 17, 2004 at 12:14:40PM +0200, Joe Borg wrote:
> I'm in the process of seeting up a new RADIUS server using Freeradius.
I
> intend using MySQL for Authorisation and Accounting
On Mon, May 17, 2004 at 12:14:40PM +0200, Joe Borg wrote:
> I'm in the process of seeting up a new RADIUS server using Freeradius. I
> intend using MySQL for Authorisation and Accounting. As a result, I will
> not be making use of the 'users' file (since MySQL is configured for use
> in Radiusd.co
Hi,
I’m in the process of seeting up a new RADIUS
server using Freeradius. I intend using MySQL for Authorisation and Accounting.
As a result, I will not be making use of the ‘users’ file (since
MySQL is configured for use in Radiusd.conf, thereby bypassing the use of the
users file). My p
-Original Message-
From: Keith Yoder [mailto:[EMAIL PROTECTED]
Sent: Friday, April 02, 2004 2:07 PM
To: [EMAIL PROTECTED]
Subject: Re: freeRADIUS with MySQL???
Kirti S. Bajwa escreveu:
>Is there anybody who has successfully installed freeRADIUS 0.9.3 & MySQL
>4.1? Is there a
Kirti S. Bajwa escreveu:
Is there anybody who has successfully installed freeRADIUS 0.9.3 & MySQL
4.1? Is there any special procedure to follow? Has someone written a toaster
for such installation?
I've used Freeradius with MySQL 4.0.18, 4.1.0 and 4.1.1 without any
problems. The
Hello List:
This question is for anyone using freeRADIUS with MySQL (with InnoDB
tables).
I have installed and tested freeRADIUS 0.9.3 & MySQL 5.?? on a RH9 LINUX. It
works fine. Now I want to install and test MySQL with InnoDB tables &
freeRADIUS. My understanding is that MySQL 4.1 is t
s,
>
> Raymond
> - Original Message -
> From: "Laurent RAYSSIGUIER" <[EMAIL PROTECTED]>
> To: "FREERADIUS" <[EMAIL PROTECTED]>
> Sent: Thursday, February 19, 2004 2:51 AM
> Subject: FREERADIUS WITH MYSQL DOC ( FRENCH AND ENGLISH )
>
&
good man :)
我爱臭豆腐
http://www.chinaunix.net
- Original Message -
From: "Laurent RAYSSIGUIER" <[EMAIL PROTECTED]>
To: "FREERADIUS" <[EMAIL PROTECTED]>
Sent: Wednesday, February 18, 2004 11:51 PM
Subject: FREERADIUS WITH MYSQL DOC ( FRENCH AND ENGLISH )
&g
HI,
Can I follow you doc to install free radius in MANDRAKE 9.2
Cheers,
Raymond
- Original Message -
From: "Laurent RAYSSIGUIER" <[EMAIL PROTECTED]>
To: "FREERADIUS" <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 2:51 AM
Subject: FREERADIUS WIT
Hello,
I had made a howto in French and now in english to setup a freeradius
server with mysql module for user auth.
I'm not a freeradius guru and also I'M NOT SHAKESPEARE...
I'm just a poor french radius user :-))
I try to help those who have the same problem than me to use basically
freeradius
69 matches
Mail list logo
