Re: MySQL Help!

2003-12-15 Thread Alan DeKok
"Deramus, Chris" <[EMAIL PROTECTED]> wrote: > What file(s) should I run ldd against? rlm_sql_mysql.so Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: MySQL Help!

2003-12-14 Thread Deramus, Chris
Title: RE: MySQL Help! Chris, Thanks for the input, however, when I updated the configure script with your extra code configure would not find lmysqlclient and prompted that I specify the path to the library files by using --with-mysql-lib= When I put in the path to the MySQL library files

RE: MySQL Help!

2003-12-14 Thread Deramus, Chris
Title: RE: MySQL Help! Alan, What file(s) should I run ldd against? Chris DeRamus OCIO VPN Administrator SAIC -Original Message- From: Alan DeKok [mailto:[EMAIL PROTECTED]] Sent: Friday, December 12, 2003 4:44 PM To: [EMAIL PROTECTED] Subject: Re: MySQL Help! "De

Re: MySQL Help!

2003-12-12 Thread Chris Parker
At 04:14 PM 12/12/2003, Chris Parker wrote: At 03:42 PM 12/12/2003, Rob Genovesi wrote: oh boy, I remember kicking this around for ever as well ... My solution was to 1) be sure you have development rpms installed and 2) do not use "--disable-shared" when running configure. I don't know exactly

Re: MySQL Help!

2003-12-12 Thread Chris Parker
At 03:42 PM 12/12/2003, Rob Genovesi wrote: oh boy, I remember kicking this around for ever as well ... My solution was to 1) be sure you have development rpms installed and 2) do not use "--disable-shared" when running configure. I don't know exactly why this changed things, but compiling with

Re: MySQL Help!

2003-12-12 Thread Alan DeKok
"Deramus, Chris" <[EMAIL PROTECTED]> wrote: > I have checked and verified the LD_LIBRARY_PATH variable, I have updated > ld.so.conf as well. I've tried multiple configuration options, including > disable-shared. Something isn't adding up. Any suggestions would be most > appreciated. Thanks and have

Re: MySQL Help!

2003-12-12 Thread Rob Genovesi
oh boy, I remember kicking this around for ever as well ... My solution was to 1) be sure you have development rpms installed and 2) do not use "--disable-shared" when running configure.  I don't know exactly why this changed things, but compiling with shared libraries it was able to find and use

Re: MySQL with FreeRadius (rlm_sql_mysql driver problem)

2003-12-04 Thread ZORBADELOS KONSTANTINOS
At Wed, 3 Dec 2003 13:22:14 -0500, Michael Shanafelt wrote: > Look into your ${exec_prefix}/lib to see if you have something like rlm_sql_mysql.so -> rlm_sql_mysql-0.9.2.so If you don't, make sure you have mysql-dev packages installed (header files and stuff) and recompile paying attention to con

Re: MySQL with FreeRadius (rlm_sql_mysql driver problem)

2003-12-03 Thread Breuer Nicolas - BelCenter.com
same problem.. On 3 Dec 2003 at 13:22, Michael Shanafelt wrote: > OK, I had my FreeRadius server working fine for Wireless LAN MAC > authentication using the clients and users text files. > > My next step was to setup a MySQL database that would store the > usernames and groups rather than havi

Re: MySQL Instructions . . .

2003-11-27 Thread ZORBADELOS KONSTANTINOS
At Thu, 27 Nov 2003 09:06:50 -0800, Jason Flatt wrote: > > When I first setup freeradius about 2 months ago, I was following a HOW-TO > someone had up which showed how to get freeradius working with mysql. Now > I'm looking for it and I cannot locate it. Can someone point me in the > correct

Re: Mysql undefined symbol _rad_malloc OSX

2003-11-18 Thread Julien Gabry
Ok I have been able to build something a little better: Building with disable shared everything and installing then compiling as static and then installing only the sql module Every module appear to work including rlm_sql_mysql but : rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) lo

Re: MySQL & Cisco Call Detail

2003-11-17 Thread Glen
Cisco conf: aaa group server radius WHATEVER server 5.5.5.5 auth-port 1812 acct-port 1813 aaa accounting connection h323 start-stop group WHATEVER I believe the radacct db structure for mysql is somewhere in the freeradius docs. -g This will log everything that happens over the dial peers

Re: MySQL & Cisco Call Detail

2003-11-14 Thread James Green
Mail_Man wrote: Can someone point me in the right direction to where I can find information on setting up Free Radius so that it collects all the call detail records from a cisco as5300 gateway and stores it in a database? TIA -Seth Call detail? You mean calltracker? If so then good luck :D.

Re: MySQL NAS-IP restriction by negative match

2003-11-13 Thread Chris Parker
At 01:23 PM 11/13/2003, Peter LaForest wrote: Hello All, Using 0.9.1 with MySQL. I have found an abundance of documentation about enforcing restrictions using positive NAS-IP matches. This works fine, ie: radgroupcheck id GroupName Attribute Value

RE: MySQL and encrypted passwords

2003-11-12 Thread Ulrich Walcher
Am Mit, 2003-11-12 um 01.03 schrieb Nikolas Geyer: > None of the suggestions seem to have worked. > > > > I have run radiusd in debugging mode and it comes up with this > however; > > > > auth: No authenticate method (Auth-Type) configuration found for the > request: Rejecting the user >

RE: MySQL and encrypted passwords

2003-11-11 Thread Nikolas Geyer
None of the suggestions seem to have worked.   I have run radiusd in debugging mode and it comes up with this however;   auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user auth: Failed to validate the user.   Below are the relevant tables

RE: MySQL and encrypted passwords

2003-11-10 Thread Paul Hampson
From: Nikolas Geyer Sent: Tuesday, 11 November 2003 12:26 PM > Hoping someone can help me. I have just installed FreeRadius on a FreeBSD > 5.1-STABLE system, using MySQL as the database backend. The problem I am > running into is it wont seem to authenticate users unless they are using > plain pas

Re: Re: Mysql Optimize Table without losing accounting-data???

2003-09-26 Thread m . prenger
Alan wrote: >Huh? Logging to the 'detail' file takes nearly zero time. > >Let me guess: You're running MySQL on the same machine as FreeRADIUS. > >The solution is simple: Don't do that. Hi Alan, thanks for replying. Yes, we're running mysqld on the same machine as radiusd, but we're not able to

Solved: Re: MySQL and md5 encrypted passwords

2003-09-25 Thread Martin Jessa
For further generations: I found my old notes and I obviously forgot one thing: To be able to read md5 hashed passwords from MySQL: insert into radgroupcheck (groupname,attribute,op,value) values ('user','Auth-Type',':=','MD5'); Cheers, YazzY On Wed, 24 Sep 2003 21:27:09 +0200 Martin Jessa <

Re: Mysql Optimize Table without losing accounting-data???

2003-09-09 Thread Alan DeKok
[EMAIL PROTECTED] wrote: > But during the mysql_optimize logging to detailfile takes so much > time that radiusd is discarding each request due to live request. Huh? Logging to the 'detail' file takes nearly zero time. Let me guess: You're running MySQL on the same machine as FreeRADIUS.

Re: MySQL Authentication Logging

2003-08-26 Thread Kostas Kalevras
On Mon, 18 Aug 2003, Adam Carmichael wrote: > Hi All! > > I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with MySQL4 for logging > accounting and retrieving authentication information. I am interested in knowing how > to log authentication attempts and even possibly why an attempt

Re: MySQL Authentication Logging

2003-08-20 Thread Adam Carmichael
- Original Message - From: "Nicolas Baradakis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 20, 2003 6:57 PM Subject: Re: MySQL Authentication Logging > Adam Carmichael wrote: > > > I was considering relearning C/C++ all over a

Re: MySQL Authentication Logging

2003-08-20 Thread Nicolas Baradakis
Adam Carmichael wrote: > I was considering relearning C/C++ all over again so I could help > with this just because we need this feature quite badly. I'd love to > finally submit something back to an opensource product, but I don't > think my coding skills are quite up to scratch for this kind of

Re: MySQL Authentication Logging

2003-08-20 Thread Adam Carmichael
Nic, I would love to help you test this!!! Adam - Original Message - From: "Nicolas Baradakis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 20, 2003 6:16 PM Subject: Re: MySQL Authentication Logging > Alan DeKok wrote: > > > &

Re: MySQL Authentication Logging

2003-08-20 Thread Nicolas Baradakis
Alan DeKok wrote: > "Adam Carmichael" <[EMAIL PROTECTED]> wrote: > > > I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with MySQL4 > > for logging accounting and retrieving authentication information. I am > > interested in knowing how to log authentication attempts and even > > poss

Re: MySQL Authentication Logging

2003-08-19 Thread Alan DeKok
"Adam Carmichael" <[EMAIL PROTECTED]> wrote: > I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with MySQL4 > for logging accounting and retrieving authentication information. I am > interested in knowing how to log authentication attempts and even > possibly why an attempt failled.

Re: MySQL Authentication Logging

2003-08-18 Thread Adam Carmichael
ios). If you'd like to further development, then I'll subscribe to freeradius-developers and help out where I can. Adam. - Original Message - From: "Nicolas Baradakis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 18, 2003 10:05 PM Subj

Re: MySQL Authentication Logging

2003-08-18 Thread Nicolas Baradakis
Chris van Meerendonk wrote: > On Mon, 2003-08-18 at 05:30, Adam Carmichael wrote: > > > I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with > > MySQL4 for logging accounting and retrieving authentication > > information. I am interested in knowing how to log authentication > > attem

Re: MySQL Authentication Logging

2003-08-18 Thread Chris van Meerendonk
On Mon, 2003-08-18 at 05:30, Adam Carmichael wrote: > Hi All! > > I'm currently running FreeRADIUS 0.9.0 on several *BSD boxes with > MySQL4 for logging accounting and retrieving authentication > information. I am interested in knowing how to log authentication > attempts and even possibly why an

Re: MySQL and DEFAULT

2003-07-08 Thread Oliver Graf
On Tue, Jul 08, 2003 at 04:26:01PM +0200, Thomas Krause (Webmatic) wrote: > > Hello, > I want to send our DNS servers to all users. My > entries looks so: > > mysql> select * from radcheck where username="DEFAULT"; > +-+--+--++-+ > | id | UserName | Attrib

Re: MySQL & radacc

2003-07-05 Thread Lee Norvall
Hi Sergio Yes, thanks for that, and it was a NAS problem. Think this is something to watch out for in the future!!! Rgds Lee - Original Message - From: "sergio jose ferreira" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 05, 2003 12:16 AM Subject: RES: MySQL & radacc

Re: Mysql driver - Solaris

2003-07-04 Thread Alan DeKok
"Paul Flintoff" <[EMAIL PROTECTED]> wrote: > I have checked that what I believe are the mysql headers are present in > /usr/local/mysql/include. However whenever I try and run configure from > src/modules/rlm_sql/drivers/rlm_sql_mysql (even with the > --with-mysql-include-dir=3D/usr/local/mysql/inc

Re: mySQL + radius

2003-06-24 Thread Tom Emerson
On Tuesday 24 June 2003 3:13 am, Tomas Bozsaky wrote: > hello, > > mysql does not support triggers. function inside mysql - you can, but > i do not know, how. According to the features, this is scheduled for inclusion in mysql version 5.0. The problem is that the current production release is 4.

Re: mySQL + radius

2003-06-24 Thread Tomas Bozsaky
hello, mysql does not support triggers. function inside mysql - you can, but i do not know, how. t Tuesday, June 24, 2003, 11:42:39 AM, you wrote: > Can I ask a question : > How can I update to mySQL database automatically a table that store money > that users must charge for the sections their

Re: MySQL database error

2003-06-18 Thread Jeff Thompson - World Net Technical Support
That was indeed it! It was set to system, changing it to Local worked! I'm finally done, and many many thanks to this list! > On Wednesday 18 June 2003 4:18 pm, Jeff Thompson - World Net Technical > Support wrote: >> Ok I got freeradius-0.8.1 installed! ... but now mysql is not >> authenticating

Re: MySQL database error

2003-06-18 Thread Tom Emerson
On Wednesday 18 June 2003 4:18 pm, Jeff Thompson - World Net Technical Support wrote: > Ok I got freeradius-0.8.1 installed! ... but now mysql is not > authenticating users... > > I get the following error from radiusd -X: > rad_recv: Access-Request packet from host 204.57.72.47:1026, id=33, > len

RE: MySQL database error

2003-06-18 Thread Jeff Thompson - World Net Technical Support
Ok I got freeradius-0.8.1 installed! It was indeed a malfunctioning linker, so I backed up all of my configs and reinstalled FreeBSD. I compiled mysql4 and freeradius8 without any problems, but now mysql is not authenticating users... I get the following error from radiusd -X: rad_recv: Access-Req

Re: MySQL: Unknown attribute SQL-User-Name

2003-06-18 Thread Chris Brotsos
At 02:29 PM 6/18/2003, you wrote: Hi, I having the following error: Unknown attribute SQL- User-Name When Authenticating using a MySQL Database. Here is the output of radiusd -X : [/usr/local/etc/raddb/users]:1 WARNING! Check item "Simultaneous-Use" ?found in reply item list for user "bibo". ?T

Re: MySQL database error

2003-06-18 Thread Nick Davis
On Tuesday 17 June 2003 22:16, Jeff Thompson - World Net Technical Support wrote: > This was covered all yesterday, but here is the output of radiusd -x when > compiled using the source tarball from freeradius.org using ./configure > --with-raddbdir=/etc/raddb --with-logdir=/var/log/radius: You s

RE: MySQL database error

2003-06-17 Thread Paul Hampson
> From: Jeff > Sent: Wednesday, 18 June 2003 3:14 PM > Ok I installed version 0.8.1, but I still see the > > open("/usr/local/lib/libradius-0.7.so", O_RDONLY) = 3 > line. This would indicate-as you said that the linker is not working > correctly? Or looking in the wrong place? This indicates tha

Re: MySQL database error

2003-06-17 Thread Frank Cusack
On Wed, Jun 18, 2003 at 12:14:12AM -0500, Jeff wrote: > Ok I installed version 0.8.1, but I still see the > > open("/usr/local/lib/libradius-0.7.so", O_RDONLY) = 3 > line. This would indicate-as you said that the linker is not working > correctly? Or looking in the wrong place? > > Here is the ou

Re: MySQL database error

2003-06-17 Thread Frank Cusack
On Wed, Jun 18, 2003 at 12:14:12AM -0500, Jeff wrote: > Ok I installed version 0.8.1, but I still see the > > open("/usr/local/lib/libradius-0.7.so", O_RDONLY) = 3 > line. This would indicate-as you said that the linker is not working > correctly? Or looking in the wrong place? No, if you see tha

Re: MySQL database error

2003-06-17 Thread Frank Cusack
On Wed, Jun 18, 2003 at 12:16:16AM -0500, Jeff wrote: > and the file /usr/local/lib/rlm_sql_mysql.la: ... > # Libraries that this one depends upon. > dependency_libs=' -L/usr/local/lib/mysql -lmysqlclient -lz' There you go. Your compile time config found the mysql and zlib libs in /usr/local/lib/

Re: MySQL database error

2003-06-17 Thread Jeff
27; - Original Message - From: "Jeff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 12:14 AM Subject: Re: MySQL database error > Ok I installed version 0.8.1, but I still see the > > open("/usr/local/lib/libradius-0.7.so"

Re: MySQL database error

2003-06-17 Thread Jeff
etc/raddb/dictionary.ascend", O_RDONLY) = 6 open("/etc/raddb/dictionary.bay", O_RDONLY) = 6 open("/etc/raddb/dictionary.cisco", O_RDONLY) = 6 open("/etc/raddb/dictionary.cisco.vpn3000", O_RDONLY) = 6 open("/etc/raddb/dictionary.cisco.vpn5000", O_RDONLY) = 6 ope

Re: MySQL database error

2003-06-17 Thread Frank Cusack
On Tue, Jun 17, 2003 at 10:40:57PM -0500, Jeff wrote: > [MOCKINGBIRD.ROOT][/home/jefft]# strace -e open radiusd really should have done radiusd -X, but still the info here is good: > open("/usr/local/lib/libradius-0.7.so", O_RDONLY) = 3 first of all, this is freeradius 0.7, not 0.8.1 or CVS (CVS

Re: MySQL database error

2003-06-17 Thread Jeff
_authorize: database query error rlm_sql: Released sql socket id: 1 rad_recv: Access-Request packet from host 204.57.72.47:1026, id=20, length=57 Sending Access-Reject of id 20 to 204.57.72.47:1026 - Original Message - From: "Frank Cusack" <[EMAIL PROTECTED]> To: &l

Re: MySQL database error

2003-06-17 Thread Jeff
/radius/radius.log", O_WRONLY|O_APPEND|O_CREAT, 0666) = 9 open("/usr/local/lib/rlm_files.la", O_RDONLY) = 10 open("/usr/local/lib/rlm_files.a", O_RDONLY) = 10 open("/usr/local/lib/rlm_files-0.7.so", O_RDONLY) = 10 open("/etc/raddb/users", O_RDONLY)

Re: MySQL database error

2003-06-17 Thread Frank Cusack
On Tue, Jun 17, 2003 at 10:16:55PM -0500, Jeff Thompson - World Net Technical Support wrote: > This was covered all yesterday, but here is the output of radiusd -x when See below > > On Tue, Jun 17, 2003 at 07:30:57PM -0500, Jeff Thompson - World Net > > Technical Support wrote: > >> Can someone

Re: MySQL database error

2003-06-17 Thread Jeff Thompson - World Net Technical Support
This was covered all yesterday, but here is the output of radiusd -x when compiled using the source tarball from freeradius.org using ./configure --with-raddbdir=/etc/raddb --with-logdir=/var/log/radius: [MOCKINGBIRD.ROOT][/home/jefft/freeradius-0.8.1]# radiusd -x Starting - reading configuration

Re: MySQL database error

2003-06-17 Thread Frank Cusack
On Tue, Jun 17, 2003 at 07:30:57PM -0500, Jeff Thompson - World Net Technical Support wrote: > Can someone give me some ideas here? 0.7 is the only version I can get to > work on FreeBSD, but would like to use .8.1 if it would load the mysql > modules. Anyone? It'd be good if you could post the r

RE: MySQL Authentication

2003-03-24 Thread Mace . Scott
OK, it's working now. Here is what I changed: in sql.conf I changed from sql_user_name = "%{Stripped-User-Name}" to sql_user_name = "%{User-Name}" Not sure there's a difference, but that's what I did... in radius.conf in the authorize section commented out all but preprocess, chap, mschap,

RE: MySQL Authentication

2003-03-24 Thread Scott Bartlett
osted To: FreeRadius > Conversation: MySQL Authentication > Subject: RE: MySQL Authentication > > > Well, I used the Dialup Admin tool with the default setting > of using crypt > passwords. > > Here's my DB info, thanks for your help! > --- This message (and any

RE: MySQL Authentication

2003-03-24 Thread Mace . Scott
gt; Sent by: [EMAIL PROTECTED] 03/22/2003 05:54 AM Please respond to freeradius-users To: <[EMAIL PROTECTED]> cc: Subject:RE: MySQL Authentication Scott, Your debug notes you've got PAP encryption set - is this the issue? I'd try with it se

Re: MySQL Authentication

2003-03-24 Thread Mace . Scott
ROTECTED]> Sent by: [EMAIL PROTECTED] 03/21/2003 07:29 PM Please respond to freeradius-users To: [EMAIL PROTECTED] cc: Subject: Re: MySQL Authentication El Fri, 21 Mar 2003 17:31:16 -0500 [EMAIL PROTECTED] escribió: > I've seen quite a few messa

Re: MySQL Authentication

2003-03-24 Thread Mace . Scott
t; <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/21/2003 07:05 PM Please respond to freeradius-users To: [EMAIL PROTECTED] cc: Subject: Re: MySQL Authentication Hello Scott: It looks like you might be trying to use unix passwd/shadow authenticatio

RE: MySQL Authentication

2003-03-22 Thread Scott Bartlett
Scott, Your debug notes you've got PAP encryption set - is this the issue? I'd try with it set to 'clear' first if I were you, then go from there once that works... Can you post examples of what you've got in the database? SB Scott Bartlett BTA Limited, 100 High Street Wandsworth, London SW18

Re: MySQL Authentication

2003-03-21 Thread Pablo Veliz
El Fri, 21 Mar 2003 17:31:16 -0500 [EMAIL PROTECTED] escribió: > I've seen quite a few messages in the archives regarding different issues > with MySQL authentication. I can get nothing to work. I tried this > patch, > http://www.mail-archive.com/[EMAIL PROTECTED]/msg12306.html > and this pa

Re: MySQL Authentication

2003-03-21 Thread Ed H
Hello Scott: It looks like you might be trying to use unix passwd/shadow authentication and sql both. Make sure your radiusd.conf file comments out all references to unix, and file. Should like something similar to this (this is just an example): authenticate { authtype PAP {

Re: MySQL connect problem

2003-03-13 Thread Nils Rønhovde
On Thu, 13 Mar 2003 11:32:52 +0100 Simon <[EMAIL PROTECTED]> wrote: > > Hmm, the mysql module seems to ignore the port that's passed to it via > the configuration files. > > I've included an (untested) one line fix against current cvs that > should help. It applies to 0.8.1 also. > > Does this

Re: MySQL connect problem

2003-03-13 Thread Simon
On Thu, Mar 13, 2003 at 10:08:46AM +0100, Nils Rønhovde wrote: > Regrettably a snoop on my MySQL-server reveals that the mysql module uses the > default mysql port: > > radius-server -> mysql-server TCP D=3306 S=52117 Rst Seq=4288337583 Len=0 Win=24820 > > Has anyone tried using a non-standard p

Re: MySQL connect problem

2003-03-13 Thread Nils Rønhovde
On Thu, 13 Mar 2003 09:09:32 +0100 Nils Rønhovde <[EMAIL PROTECTED]> wrote: > > radius-server> /local/db/mysql/3.23.43/bin/mysql -P15022 > -h10.122.95.163 -uradius -pradius radius Reading table information for > completion of table and column names You can turn off this feature to > get a quicker

Re: ~Re: MySQL connect problem

2003-03-13 Thread Nils Rønhovde
On Wed, 12 Mar 2003 15:02:38 -0500 "Matt Simpson" <[EMAIL PROTECTED]> wrote: > What operating system and what version are you using. I ran into a > similar problem with a fresh install of RedHat 8.0 and MySQL with > glibc. Aparently when you connect to MySQL via anything but localhost > it crashes

Re: MySQL connect problem

2003-03-12 Thread tarvid
On Wednesday 12 March 2003 14:53, Nils Rønhovde wrote: > Hi, > > Is this a rlm_my_sql problem, something else in the radius-server or a > problem with my database: > > Module: Loaded SQL > sql: driver = "rlm_sql_mysql" > sql: server = "10.122.95.163" > sql: port = "15022" > sql: login = "radius

~Re: MySQL connect problem

2003-03-12 Thread Matt Simpson
What operating system and what version are you using. I ran into a similar problem with a fresh install of RedHat 8.0 and MySQL with glibc. Aparently when you connect to MySQL via anything but localhost it crashes, so in your /etc/my.cnf file make sure you set your thread stack set to 256K in your

Re: MySQL - Attributes:Values go in which tables?

2003-03-07 Thread Alan DeKok
"Ed H" <[EMAIL PROTECTED]> wrote: > My question: Is there any good documentation on which Attributes and Values > go into which tables? I am confused about which stuff goes where. The SQL tables are an attempt to mirror the 'users' file. See 'man 5 users' > For example: The Radius book shows

Re: MySQL table definition for RADIUS accounting data and duplicates

2003-03-01 Thread Kostas Kalevras
On Fri, 28 Feb 2003, Derrik Pates wrote: > I ended up needing to modify the MySQL table for RADIUS accounting data > to mark the AcctSessionId and AcctUniqueId fields as UNIQUE. I was > having problems with receiving duplicate accounting records, showing > users logged in multiple times who actual

Re: MySQL table definition for RADIUS accounting data and duplicates

2003-02-28 Thread Jacob S. Barrett
Derrik Pates wrote: Is there ever a legitimate situation where the AcctSessionId field might end up with the same value twice? My Cisco 350 AP uses the same AcctSessionId for multiple association/deassociates as long as the client's MAC address remains the same. So for any given AcctSessionId th

Re: mysql authorization

2003-02-28 Thread Rick Evans
CTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 28, 2003 5:33 AM Subject: Re: mysql authorization > "John E Murphy" <[EMAIL PROTECTED]> wrote: > > I am trying to use mysql to authorize users. It seems that they are > > authorized but never get through because

Re: mysql authorization

2003-02-28 Thread Alan DeKok
"John E Murphy" <[EMAIL PROTECTED]> wrote: > I am trying to use mysql to authorize users. It seems that they are > authorized but never get through because the system looks at the /etc/passwd > file. Attached is the -X output. So configure the server to use a different Auth-Type. It comes con

Re: MYSQL Configuration Problem

2003-02-18 Thread Alan DeKok
[EMAIL PROTECTED] wrote: > ./configure --enable-sql=mysql --with-mysql-include-dir=/usr/local/mysql ... > checking for mysql/mysql.h... no ... > [root@svrwsb187 include]# pwd > /usr/local/mysql/include You can still edit the 'Makefile' in rlm_sql_mysql by hand. A short-term work-around woul

Re: MySQL Auth-Type

2003-02-01 Thread Alan DeKok
Michael Brininstool <[EMAIL PROTECTED]> wrote: > When I run in debug mode, I see the Auth-Type getting set to 'System' > somehow. I have not figured out exactly how. The 'users' file sets that, through the 'files' module. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freera

[OT] Re: mysql neat trick

2003-01-31 Thread Nick Davis
Yes, I am aware of doing Replication. Due to some system issues, I cannot do that. That is why I am happy to use that nice long command I found in the mysqldump man page. Thanks for the idea though! Nick On Friday 31 January 2003 18:10, Jonathan Hassell wrote: > ...which is also described on

RE: mysql neat trick

2003-01-31 Thread Jonathan Hassell
...which is also described on pp. 111-112 of the RADIUS book. Replication is a lot easier to control and use. -Original Message- From: Pete [mailto:[EMAIL PROTECTED]] Why not just backup the db using it's replication features: http://www.mysql.com/doc/en/Replication.html Pete - List inf

Re: mysql neat trick

2003-01-31 Thread Pete
Nick Davis wrote: > > I just figured this out and thought some others might benefit from it! > > Here is how you dump database(s) on one server into a database on another > server! > > mysqldump --opt -a LOCALDBNAME [LOCALTABLE1 [LOCALTABLE2]] -u USER -pPASSWORD > | mysql --host=REMOTEHOST REMOT

Re: MySQL

2003-01-29 Thread Genoud Richard
something like --with-rlm-rlm_sql_mysql-include-dir=/usr/include/mysql and --with-rlm_sql_mysql would be great. (mysql rpm installation) you have to install mysql-devel in order to get it work. the compilation worked if the file freeradius-0.8.x/src/modules/rlm_sql/drivers/rlm_sql_mysql/rlm_sql_m

Re: mysql radcheck field syntax

2003-01-29 Thread Alan DeKok
Doug Yeager <[EMAIL PROTECTED]> wrote: > This is an easy one: > I want to add a user to mysql. Can someone tell me the right values for the > attribute and op field? That depends on your local configuration. See the 'users' file for examples. Read 'doc/rlm_sql' in the latest CVS snapshot.

Re: mysql radcheck field syntax

2003-01-29 Thread Simon White
28-Jan-03 at 19:18, Doug Yeager ([EMAIL PROTECTED]) wrote : > This is an easy one: > I want to add a user to mysql. Can someone tell me the right values for the > attribute and op field? > I'm just trying to test to see if I can get something simple working. > Is this right: > Insert into radcheck

Re: MySQL timeout problem

2003-01-23 Thread Alan DeKok
Giuliano Zorzi <[EMAIL PROTECTED]> wrote: > I have a big problem with freeradius and mysql. After a 8 hours of > inactivity of the freeradius server it looses the connection to the > mysql server and I have to restart both to have the problem solved. Is > there a way to turn off or set an higher v

Re: Mysql Authentication

2003-01-22 Thread Ossama Suleiman
Alan DeKok wrote: Ossama Suleiman <[EMAIL PROTECTED]> wrote: i am using freeradius 0.8.1 with Redhat 8.0, i wanted to use mysql authentication, the problem is that i want to authenticate users depending on Calling-Station-Id, so i added an entry (blank username) Why? What's w

Re: mysql auth

2003-01-21 Thread Genoud Richard
the attribute can be also : User-Password and Crypt-Password ;) Shannon Johnson a écrit: Duane, They're in radcheck. It should be: Id number, username, attribute, op, value Where the attribute is the actual word "Password" the op is "==" and the value is whatever the password is for the user.

RE: mysql auth

2003-01-21 Thread Shannon Johnson
Duane, They're in radcheck. It should be: Id number, username, attribute, op, value Where the attribute is the actual word "Password" the op is "==" and the value is whatever the password is for the user. Shannon Message: 9 From: "Duane Barnes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Su

Re: mysql auth

2003-01-21 Thread Genoud Richard
radcheck Duane Barnes a écrit: Does anyone know which table the passwords for the users are stored in? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Mysql Authentication

2003-01-20 Thread Ossama Suleiman
Alan DeKok wrote: Ossama Suleiman <[EMAIL PROTECTED]> wrote: i am using freeradius 0.8.1 with Redhat 8.0, i wanted to use mysql authentication, the problem is that i want to authenticate users depending on Calling-Station-Id, so i added an entry (blank username)

Re: Mysql Authentication

2003-01-16 Thread Alan DeKok
Ossama Suleiman <[EMAIL PROTECTED]> wrote: > i am using freeradius 0.8.1 with Redhat 8.0, i wanted to use mysql > authentication, the problem is that i want to authenticate users > depending on Calling-Station-Id, so i added an entry (blank username) Why? What's wrong with the DEFAULT co

Re: MYSQL check_error: 1065 received

2002-12-09 Thread Genoud Richard
well... I upgraded to freeradius 0.8, and it's ok now... Genoud Richard a écrit: hello everyone ! I got freeradius0.7.1, with mysql module and I got this error on a radclient request : echo "User-Name = user, Password=guess" | radclient 127.0.0.1 auth guess I had previously a postgreSQL databa

Re: Mysql, dialup_admin and Freeradius Problem.

2002-11-20 Thread Chris Brotsos
At 11:12 PM 11/19/2002 -0200, you wrote: Chris Brotsos wrote: At 06:04 PM 11/19/2002 -0200, you wrote: rlm_sql (sql): Reserving sql socket id: 4 rlm_sql: The 'op' field for attribute 'User-Password = $1$C.zZID82$kp/ZF6uwfT3dIHwtLd1B70' is NULL, or non-existent. rlm_sql: You MUST FIX THIS if

Re: Mysql, dialup_admin and Freeradius Problem.

2002-11-19 Thread Jamil Buchalla Neto
Chris Brotsos wrote: At 06:04 PM 11/19/2002 -0200, you wrote: rlm_sql (sql): Reserving sql socket id: 4 rlm_sql: The 'op' field for attribute 'User-Password = $1$C.zZID82$kp/ZF6uwfT3dIHwtLd1B70' is NULL, or non-existent. rlm_sql: You MUST FIX THIS if you want the configuration to behave as y

Re: Mysql, dialup_admin and Freeradius Problem.

2002-11-19 Thread Chris Brotsos
At 06:04 PM 11/19/2002 -0200, you wrote: I have all of then installed and running and added an user with dialup_admin but when I try to connect to my tc nas that user doesn't pass. here is what I get: rad_recv: Access-Request packet from host :1645, id=55, length=146 User-Name =

Re: MySQL - need to change the authentication query

2002-11-17 Thread Alan DeKok
Ish-Lev Avshalom <[EMAIL PROTECTED]> wrote: > Anyone have any idea how to make freeradius associate the check > attributes with reply attributes with an additional key other then the > username? Edit the schema. > I was thinking of adding a 'record' column to both radcheck and radreply > tab

Re: mysql

2002-11-11 Thread Alan DeKok
Kevin Bonner <[EMAIL PROTECTED]> wrote: > Here's the output when I use the new changes. Just moving the type > of error from a NULL op to an empty op. For now, it's OK. The huge annoying warning messages I added to the module should help. Also, there's no 'doc/rlm_sql' which explains all of

Re: mysql op field

2002-11-11 Thread Alan DeKok
"Enesha Fairluck" <[EMAIL PROTECTED]> wrote: > Thanks for everything taht everyone did last weel about the op field. > Heh guess I opened a can of worms :) Anyway everyone seems to be saying > that the op value needs to be something. The problem is I don't know what. > I don't know what that

Re: mysql

2002-11-09 Thread Alan DeKok
Brian Kolaci <[EMAIL PROTECTED]> wrote: > I was amazed so I had to see it for myself. This seems to be a > major bug in mysql. I've grown used to oracle where the behaviour > is correct and doesn't allow the insertion to take place. I agree. That's a bug on the part of MySQL. > I guess a *ba

Re: mysql

2002-11-08 Thread Brian Kolaci
> On Friday 08 November 2002 16:56, Chris Parker wrote: > > I just committed updates for mysql,postgre,db2,oracle that change the > > order ( so op is "between" Attribute and Value ) and make it NOT NULL. > > > > I did not set a default. I think having the server reject invalid > > en

Re: mysql libraries

2002-11-08 Thread Todd T. Fries
Make sure you have the devel packages installed. freeradius does not find mysql without the headers installed. On Fri, 2002-11-08 at 09:56, Remus Anca wrote: > hi, > > i'am newbie in radius > i've tried to compile on Debian 3.0 freeradius 0.7. > it's ok, but i've got warning messages whe

Re: mysql

2002-11-08 Thread Kevin Bonner
On Friday 08 November 2002 16:56, Chris Parker wrote: > I just committed updates for mysql,postgre,db2,oracle that change the > order ( so op is "between" Attribute and Value ) and make it NOT NULL. > > I did not set a default. I think having the server reject invalid > entries upon an insert is t

Re: mysql

2002-11-08 Thread Chris Parker
At 04:36 PM 11/8/2002 -0500, Alan DeKok wrote: Kevin Bonner <[EMAIL PROTECTED]> wrote: > Well...here's a patch for mysql. I guess the default op value > should be chosen wisely, but I think that the != will hopefully > force people to set the op field instead of ignoring it. I agree. There i

Re: mysql

2002-11-08 Thread Kevin Bonner
> I noticed you re-ordered the 'op' field, too. So long as the query > doesn't change, the code in rlm_sql shouldn't have to be changed, > right? > > Alan DeKok. Correct. The database layout should not affect the queries and shouldn't affect the way people insert items into those tables. K

Re: mysql

2002-11-08 Thread Kevin Bonner
On Friday 08 November 2002 16:34, Brian Kolaci wrote: > > > Well...here's a patch for mysql. I guess the default op value should > > > be chosen wisely, but I think that the != will hopefully force people > > > to set the op field instead of ignoring it. > > > > > > Kevin Bonner > > >

Re: mysql

2002-11-08 Thread Alan DeKok
Kevin Bonner <[EMAIL PROTECTED]> wrote: > Well...here's a patch for mysql. I guess the default op value > should be chosen wisely, but I think that the != will hopefully > force people to set the op field instead of ignoring it. I agree. There is sometimes a good reason to set the defaults to

  1   2   3   >