Re: freeradius and mysql connectivity

2003-07-09 Thread Oliver Graf
On Wed, Jul 09, 2003 at 12:32:57PM +0300, Peter Nixon wrote: > > Where can I find this builddbm command? > > I think he means builddbm which would seem to be a command related to dbm and > nothing to do with MySQL. I think he is a little confused.. Normally I would say there is no such thing as

Re: freeradius and mysql connectivity

2003-07-09 Thread Peter Nixon
On Wed, 9 Jul 2003 12:17 pm, Oliver Graf wrote: > On Wed, Jul 09, 2003 at 09:30:17AM +0100, Nitin Kaushik wrote: > > hi, > > > > I am studying about the freeradius and want to connect it to the mysql > > server. > > > > But the problem is that mysql server refusses the connection when I run > > rad

Re: freeradius and mysql connectivity

2003-07-09 Thread Oliver Graf
On Wed, Jul 09, 2003 at 09:30:17AM +0100, Nitin Kaushik wrote: > hi, > > I am studying about the freeradius and want to connect it to the mysql server. > > But the problem is that mysql server refusses the connection when I run radius in > debug mode. Check if mysqld is running. Check if you

freeradius and mysql connectivity

2003-07-09 Thread Nitin Kaushik
hi,   I am studying about the freeradius and want to connect it to the mysql server.   But the problem is that mysql server refusses the connection when I run radius in debug mode.   even the "biulddbm" command doesn't work.   Please mail me some more information about the mysql connectivity.I am

FreeRadius and MySQL installation GENERAL ANSWER!!!

2003-06-12 Thread Oleg Ustinov
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi there, because exist too much question, please find one GENERAL answer to all question for Radius-MySQL installation is a file "RADIUS-SQL.schema" in /doc folder. or just: http://www.frontios.com/freeradius.html please read it carefully and inst

Re: freeradius and mysql on solaris

2003-04-01 Thread Chris Brotsos
At 02:13 AM 4/1/2003, you wrote: i'm having problems compiling freeradius v0.8.1 on a solaris 9 machine with mysql support and any help would be greatly appreciated. here's some more details on the setup. solaris 9 (12/02) freeradius v0.8.1 mysql 3.23.53 (from sunfreeware.com) mysql base dir is at

freeradius and mysql on solaris

2003-04-01 Thread bofh
i'm having problems compiling freeradius v0.8.1 on a solaris 9 machine with mysql support and any help would be greatly appreciated. here's some more details on the setup. solaris 9 (12/02) freeradius v0.8.1 mysql 3.23.53 (from sunfreeware.com) mysql base dir is at /usr/local/mysql with includes

Re: Freeradius and MySQL Initial Setup

2002-09-10 Thread Alan DeKok
NetNITCO Systems Administration <[EMAIL PROTECTED]> wrote: > We're looking to move from Merit radius/LDAP to Freeradius/MySQL, That's a good idea. > however , I seem to be at a loss for configuring Freeradius to use > MySQL. I didn't have any problems compiling Freeradius 0.7 with > MySQL sup

Freeradius and MySQL Initial Setup

2002-09-10 Thread NetNITCO Systems Administration
Hi, We're looking to move from Merit radius/LDAP to Freeradius/MySQL, however, I seem to be at a loss for configuring Freeradius to use MySQL. I didn't have any problems compiling Freeradius 0.7 with MySQL support and I have configured sql.conf. My question lies in how do you configure radiu

Re: Freeradius and MySQL

2002-07-16 Thread Nick Davis
On Tuesday 16 July 2002 02:56, Jorge Lanza wrote: > Hi... I think I've managed to run my radius server and client, but only > through the text files. > Now I need to run it interacting with mysql. Any help, > pleeeeee. > > And the accounting how does it work? If you re

Freeradius and MySQL

2002-07-16 Thread Jorge Lanza
Hi... I think I've managed to run my radius server and client, but only through the text files. Now I need to run it interacting with mysql. Any help, pleeeeee. And the accounting how does it work? TA Jorge Lanza Cald

Re: freeradius and mysql replication question

2002-07-10 Thread CheongMeng
CTED]'" > <[EMAIL PROTECTED]> > Cc: "Koyabu, Ken" <[EMAIL PROTECTED]> > Subject: freeradius and mysql replication question > > > > Does anyone have any tips regarding how to set up mysql replication with > freeradius for redundancy in p

Re: freeradius and mysql replication question

2002-07-10 Thread Chris Parker
At 07:40 PM 7/9/2002 -0700, Koyabu, Ken wrote: >I looked up Colin Bloch's documentation, and I managed to setup mysql >replication option. I'm running two identical freeradius 0.6 with mysql >3.23.38 radius database on two separate FreeBSD 4.5 servers, and our ISP is >proxing their radius authen

freeradius and mysql replication question

2002-07-09 Thread Koyabu, Ken
I looked up Colin Bloch's documentation, and I managed to setup mysql replication option. I'm running two identical freeradius 0.6 with mysql 3.23.38 radius database on two separate FreeBSD 4.5 servers, and our ISP is proxing their radius authentications to our radius servers, so we can have acc

Re: freeradius and mysql

2002-04-14 Thread Alan DeKok
Artur Hecker <[EMAIL PROTECTED]> wrote: > again, the problem was not the SQL and whatsoever dependint on it. for a > plenty of people here the problem are the *tmp files which DO NOT exist > even it the modules ARE active. Add debugging statements to the module, to track when/where/why it's mak

Re: freeradius and mysql accounting and use of called-station-id

2002-04-12 Thread Dirk Tanneberger
ent: Friday, April 12, 2002 8:25 AM Subject: Re: freeradius and mysql accounting and use of called-station-id > > Hello, > > if you make debugging in radius server and in Cisco ('debug > radius' :), you should find, that Cisco doesn't send this attribute in the >

RE: freeradius and mysql accounting and use of called-station-id

2002-04-12 Thread Lutrika Mufti R
From: Thomas Jalsovsky [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 1:25 PM To: [EMAIL PROTECTED] Subject: Re: freeradius and mysql accounting and use of called-station-id Hello, if you make debugging in radius server and in Cisco ('debug radius' :), you should find

Re: freeradius and mysql accounting and use of called-station-id

2002-04-11 Thread Thomas Jalsovsky
> Acct-Session-Time = 13 > X-Ascend-Data-Rate = 64000 > X-Ascend-Xmit-Rate = 64000 > X-Ascend-Multilink-ID = 14165 > Acct-Delay-Time = 0 > Client-IP-Address = 192.168.1.41 > Timestamp = 1018533274 > > Thanks Dirk > > -

Re: freeradius and mysql accounting and use of called-station-id

2002-04-11 Thread Alan DeKok
"Dirk Tanneberger" <[EMAIL PROTECTED]> wrote: > I think the Cisco AS5300 send not these values. > But how can I configure AS5300 to send the parameters? Read your Cisco manual, or talk to your Cisco support person. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.o

Re: freeradius and mysql accounting and use of called-station-id

2002-04-11 Thread Dirk Tanneberger
- From: "Chris Parker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 5:27 PM Subject: Re: freeradius and mysql accounting and use of called-station-id > At 05:09 PM 4/11/2002 +0200, Dirk Tanneberger wrote: > >Hello all, > >

Re: freeradius and mysql accounting and use of called-station-id

2002-04-11 Thread Chris Parker
At 05:09 PM 4/11/2002 +0200, Dirk Tanneberger wrote: >Hello all, > >I use freeradius 0.5 and my NAS is a Cisco AS5300. >I test with freeradius and mysql since 2 weeks and I have 2 problems: > >The radius server writes the accounting records in the mysql-table, but >the fo

freeradius and mysql accounting and use of called-station-id

2002-04-11 Thread Dirk Tanneberger
Hello all, I use freeradius 0.5 and my NAS is a Cisco AS5300. I test with freeradius and mysql since 2 weeks and I have 2 problems: The radius server writes the accounting records in the mysql-table, but the following entries leave blank for all records: ++ AcctUniqueId

Re: freeradius and mysql

2002-04-08 Thread Artur Hecker
Alan DeKok wrote: > > Artur Hecker <[EMAIL PROTECTED]> wrote: > > i don't use sql and it doesn't work either. the files are the > > aquivalents of the system-wide utmp, wtmp, etc. files, if i'm not > > completely wrong. > > SQL accounting is NOT the equivalent of utmp/wmtp. Even utmp/wmtp >

Re: freeradius and mysql

2002-04-08 Thread tywe
> I have a patch sitting somewhere which adds the ability for SQL to > do Simultaneous-Use checks, that might help. If you can dig up that patch and post it, I will greatly appreciate it. So other than Simultaneous-Use, what else do the tmp files do for me? I'm just trying to see if I need to g

Re: freeradius and mysql

2002-04-08 Thread Alan DeKok
Artur Hecker <[EMAIL PROTECTED]> wrote: > i don't use sql and it doesn't work either. the files are the > aquivalents of the system-wide utmp, wtmp, etc. files, if i'm not > completely wrong. SQL accounting is NOT the equivalent of utmp/wmtp. Even utmp/wmtp are not equivalent. They have diffe

Re: freeradius and mysql

2002-04-07 Thread Artur Hecker
ank > > - Original Message - > From: "Artur Hecker" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, April 06, 2002 7:34 AM > Subject: Re: freeradius and mysql > > > > > tywe wrote: > > > > > > That

Re: freeradius and mysql

2002-04-07 Thread tywe
Please let me know if you figure it out before then. Thanks! Frank - Original Message - From: "Artur Hecker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 7:34 AM Subject: Re: freeradius and mysql > > tywe wrote: > > > >

Re: freeradius and mysql

2002-04-07 Thread tywe
e info? If I'm wrong, please let me know, because this is all new to me. Thanks! Frank - Original Message - From: "Artur Hecker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 7:34 AM Subject: Re: freeradius and mysql > > tywe

Re: freeradius and mysql

2002-04-06 Thread Artur Hecker
tywe wrote: > > That did it!! My accounting is working just fine! And now I even see it > updating the mysql tables! Thanks a TON! > > Frank > does it write any radutmp, radwtmp, sradutmp files, etc.? can you use radwho? in which sequence did you send your Accounting messages? First an ON or

Re: freeradius and mysql

2002-04-05 Thread tywe
That did it!! My accounting is working just fine! And now I even see it updating the mysql tables! Thanks a TON! Frank - Original Message - From: "Mark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 6:10 PM Subject: Re: freeradius and m

Re: freeradius and mysql

2002-04-05 Thread tywe
Thanks Mark, I'll give it a shot! Frank - Original Message - From: "Mark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 6:10 PM Subject: Re: freeradius and mysql > If you have a windows machine that you can use, then NTRADPing i

Re: freeradius and mysql

2002-04-05 Thread Mark
"tywe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 4:38 PM Subject: Re: freeradius and mysql > Nicolas, > > Thanks a ton for the reply about my accounting issue. I thought the same > thing at first about it being due to an unknown NAS

Re: freeradius and mysql

2002-04-05 Thread tywe
and the mysql accounting tables when the radiusd first starts up, but doing a test with radtest, it doesn't cause any info at all to show up about accounting? Thanks again! Frank - Original Message - From: "Nicolas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

Re: freeradius and mysql

2002-04-04 Thread Nicolas
CTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 12:21 AM Subject: Re: freeradius and mysql > Ya, I don't know much about that file either. I just made an entry that > looked about like the default one, and added it below the default one: > > client 1.2.3.4 { >

Re: freeradius and mysql

2002-04-04 Thread tywe
I think I might have to use radclient to actually see the accounting kick in. Not sure though, but I'll let you know how it goes. Frank - Original Message - From: "Juan Hernandez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 2:27 PM

Re: freeradius and mysql

2002-04-04 Thread Juan Hernandez
the only problem I am having is I dont understand the clients.conf, is there a site that explains it, and etc. - Original Message - From: "tywe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 9:41 AM Subject: Re: freeradius and mysql &g

Re: freeradius and mysql

2002-04-04 Thread tywe
an Hernandez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 12:10 PM Subject: Re: freeradius and mysql > hey could you and I discouse off list what you did with free radius and > mysql? > - Original Message - > From: "tywe"

Re: freeradius and mysql

2002-04-04 Thread Juan Hernandez
hey could you and I discouse off list what you did with free radius and mysql? - Original Message - From: "tywe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 12:55 AM Subject: Re: freeradius and mysql > Hi, > > Thanks

Re: freeradius and mysql

2002-04-04 Thread tywe
Hi, Thanks to all for the help, I now have freeradius and mysql working together quite nicely :) My only question: Is it normal to see "Info: Sending duplicate authentication reply to client" whenever the request is rejected? Everything seems to work great, I was just wonderi

Re: freeradius and mysql

2002-04-03 Thread Nicolas
f sql in auth and acct chapters Do some tests (radiusd -X)and come back Nicolas - Original Message - From: "tywe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 5:20 AM Subject: Re: freeradius and mysql http://www.frontios.com/freeradiu

Re: freeradius and mysql

2002-04-03 Thread tywe
z To: [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 7:37 PM Subject: freeradius and mysql I know freeradius has the ability to work with mysql, to read from a mysql db, how do I configure it to do this?  you dont have to tell me, I just need to get to a website that explains

Re: freeradius and mysql

2002-04-03 Thread Vector
You should read the documentation that comes with freeradius in the doc directory.   vec - Original Message - From: Juan Hernandez To: [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 5:37 PM Subject: freeradius and mysql I know freeradius has the

freeradius and mysql

2002-04-03 Thread Juan Hernandez
I know freeradius has the ability to work with mysql, to read from a mysql db, how do I configure it to do this?  you dont have to tell me, I just need to get to a website that explains it. thanks for any help       Juan  

Re: FreeRadius and MySQL - notes...

2001-09-20 Thread aland
Joey Smith <[EMAIL PROTECTED]> wrote: > Is there anyone out there listening who can make website updates? This > be a really good addendum to the FAQ. I've added it in the source, as 'doc/RADIUS-SQL.schema' Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/

Re: FreeRadius and MySQL - notes...

2001-09-15 Thread Mike Machado
You asked about mysql replication. Here is a link to a guy using IC-RADIUS (same as FreeRADIUS as far as MySQL is concerned) and how he does his replication. http://www.ls-l.net/mysql/ freeradius-users wrote: > Not wanting to jump the gun, foil any faqs, or steal any thunders, but... > > Lots

Re: FreeRadius and MySQL - notes...

2001-09-13 Thread Joey Smith
I think this is the single most useful line of your entire document: "There is a file which describes this and is actually a SQL script file. It can be found at freeradius/src/modules/rlm_sql/drivers/ rlm_sql_mysql/db_mysql.sql. This is the bit that isn't really documented anywhere (like i

FreeRadius and MySQL - notes...

2001-09-13 Thread freeradius-users
Not wanting to jump the gun, foil any faqs, or steal any thunders, but... Lots of people seem to be asking about FreeRadius and (My)SQL integration etc. Until there's some more coherent docs, or until someone does a proper FAQ on it, and just in case on the off-chance someone out there finds

Freeradius and mysql continued...

2001-08-03 Thread David Eusse
t; and added record in table user and table db of database mysql. Then I call > via vpn on freeradius and MySQL work. In radchek I input record such > insert into radchek (UserName,Attribute,Value) > values("sveta","Crypt-Password",ENCRYPT("tttdfg90")); >