Re: VoIP accounting MySQL vs. Postrgres

2003-07-12 Thread Umut Destan
, Umut Destan wrote: > > Hello list, > > I think I got the sql accounting working, thanx for the answers for that Q. > > Now I read the document Peter Nixon wrote about VoIP Accounting,.. Isn't > > MySQL just as par with PostgreSQL in terms of speed? If I had 1 AS5350 &g

Re: VoIP accounting MySQL vs. Postrgres

2003-07-12 Thread Matthew Schumacher
I must agree. If you just READING data and never really working with it at the query (or procedure) level then mysql is a quick and dirty way to do it. When it comes down to really putting the DB to work switch to postgres. It really is that much better. schu Peter Nixon wrote: On Sat July

Re: Freeradius - MySQL

2003-07-12 Thread Kostas Kalevras
On Fri, 11 Jul 2003, Dave wrote: > Hi, > > I'm using Freeradius with MySQL. It's run fine but > freeradius doesn't seems to write in the > AcctTerminateCause field in the Accounting table when > there's a failed login. This make the Failed Login > p

Re: VoIP accounting MySQL vs. Postrgres

2003-07-12 Thread Peter Nixon
On Sat July 12 2003 23:32, Umut Destan wrote: > Hello list, > I think I got the sql accounting working, thanx for the answers for that Q. > Now I read the document Peter Nixon wrote about VoIP Accounting,.. Isn't > MySQL just as par with PostgreSQL in terms of speed? If I had 1

VoIP accounting MySQL vs. Postrgre

2003-07-12 Thread Umut Destan
Hello list, I think I got the sql accounting working, thanx for the answers for that Q. Now I read the document Peter Nixon wrote about VoIP Accounting,.. Isn't MySQL just as par with PostgreSQL in terms of speed? If I had 1 AS5350 sending only little amount of accounting data to freer

Re: FreeRadius doesn't update MySQL database

2003-07-12 Thread Steven Fries
Do you have sql in your accounting {} section in the radius.conf file? - Original Message - From: "destan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 12, 2003 1:16 AM Subject: FreeRadius doesn't update MySQL database > Hello list, &

RE: FreeRadius doesn't update MySQL database

2003-07-12 Thread Paul Hampson
> From: destan > Sent: Saturday, 12 July 2003 4:16 PM > What could be the problem? Doesn't sql modules get run if I just > configure sql.conf ? Nope. You also have to tell FreeRADIUS to _use_ the sql module you've defined in sql.conf. You'll have to add the sql module to the accounting section

RE: Freeradius - MySQL

2003-07-11 Thread Paul Hampson
> From: Dave > Sent: Saturday, 12 July 2003 7:08 AM > I'm using Freeradius with MySQL. It's run fine but > freeradius doesn't seems to write in the > AcctTerminateCause field in the Accounting table when > there's a failed login. This make the Fail

FreeRadius doesn't update MySQL database

2003-07-11 Thread destan
Hello list, I have a Cisco AS5350 sending start-stop accounting info to my freeRadius 0.8.1. I have set the sql.conf correctly and created a user for freeradius in mysql and given it all priveledges to radius.* tables. Also created the radius database & tables according to the schema

Re: Freeradius - MySQL

2003-07-11 Thread Alan DeKok
Dave <[EMAIL PROTECTED]> wrote: > I'm using Freeradius with MySQL. It's run fine but > freeradius doesn't seems to write in the > AcctTerminateCause field in the Accounting table when > there's a failed login. Does it *recieve* that attribute?

Freeradius - MySQL

2003-07-11 Thread Dave
Hi, I'm using Freeradius with MySQL. It's run fine but freeradius doesn't seems to write in the AcctTerminateCause field in the Accounting table when there's a failed login. This make the Failed Login page of Dialup Admin empty with no records. Is there any additio

Re: md5 + freeradius + mysql

2003-07-09 Thread Jean Carlos
more help??? - Original Message - From: "Paul Hampson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 6:02 PM Subject: RE: md5 + freeradius + mysql > > From: [EMAIL PROTECTED] > > Sent: Thursday, 10 July 2003 3:45

RE: md5 + freeradius + mysql

2003-07-09 Thread Paul Hampson
> From: [EMAIL PROTECTED] > Sent: Thursday, 10 July 2003 3:45 AM > >> From: [EMAIL PROTECTED] > >> Sent: Wednesday, 9 July 2003 9:38 PM > >> how to use md5+radius+mysql, currently I use crypt of linux, but want to > >> use md5. in radiusd.conf, mo

RE: md5 + freeradius + mysql

2003-07-09 Thread jean
>> From: [EMAIL PROTECTED] >> Sent: Wednesday, 9 July 2003 9:38 PM > >> how to use md5+radius+mysql, currently I use crypt of linux, but want to >> use md5. in radiusd.conf, modified an option in pap for md5 but he did >> not >> advance, what I can make? &

RE: md5 + freeradius + mysql

2003-07-09 Thread Paul Hampson
> From: [EMAIL PROTECTED] > Sent: Wednesday, 9 July 2003 9:38 PM > how to use md5+radius+mysql, currently I use crypt of linux, but want to > use md5. in radiusd.conf, modified an option in pap for md5 but he did not > advance, what I can make? What do you mean by 'did not a

md5 + freeradius + mysql

2003-07-09 Thread jean
Hello, how to use md5+radius+mysql, currently I use crypt of linux, but want to use md5. in radiusd.conf, modified an option in pap for md5 but he did not advance, what I can make? Thank's Sorry, but my english is terrible! - List info/subscribe/unsubscribe? See http://www.freeradius.org

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 n

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 se

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 run

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 co

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"; > +-+--+--+

MySQL and DEFAULT

2003-07-08 Thread Thomas Krause (Webmatic)
Hello, I want to send our DNS servers to all users. My entries looks so: mysql> select * from radcheck where username="DEFAULT"; +-+--+--++-+ | id | UserName | Attribute| op | Value | +-+--+--++---

Re: updating session-timeout attribute in MySql db through Radius

2003-07-08 Thread Marcin Mańk
That`s simple: Add another SQL module, that You would use in accounting section. The query on accounting stop would update the Session-Timeout appropriately. Comment out other queries in this added module. All info is in sql.conf - copy that file, modify queries, and include in radiusd.conf that mo

re: updating session-timeout attribute in MySql db through Radius

2003-07-08 Thread Simon Mackey
Hello! I'm working on a prepaid public internet access system. And I would like to be able to update the value of the Session-Timeout attribute in the MySQL database through freeRadius, as opposed to just a direct SQL statement to the MySQL server. The reason for wanting to do this is so

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

RES: MySQL & radacc

2003-07-04 Thread sergio jose ferreira
[]'s Sergio Jose Ferreira WGO Internet Brazil -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nome de Lee Norvall Enviada em: sexta-feira, 4 de julho de 2003 18:44 Para: [EMAIL PROTECTED] Assunto: MySQL & radacc Hi I am currently setup with MySQL and I am n

MySQL & radacc

2003-07-04 Thread Lee Norvall
Hi I am currently setup with MySQL and I am not getting any information added to the radacc table when I make a make a request. I can auth ok and have attribs returned. Is there some setting I need to add somewhere or extra arrtibs that I need to send to the server?? I have set sql within the

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-in

Mysql driver - Solaris

2003-07-04 Thread Paul Flintoff
Title: Mysql driver - Solaris I am attempting to get freeradius 0.8.1 to compile with support for mysql. We are running Mysql 4.0 on a solaris 8 install. I have checked that what I believe are the mysql headers are present in /usr/local/mysql/include. However whenever I try and run

Re: Re: bypass proxy auth and mysql

2003-07-02 Thread 王振国
ribute`, `op`, >>`Value`) VALUES >> (1,'group1','Auth-Type',':=','Accept');  >> >>=== 2003-07-02 17:56:00 :=== >> >> >We have a customer that needs temp assistance with their auth. >> > >> >W

Re: bypass proxy auth and mysql

2003-07-02 Thread Drew Flickema
customer that needs temp assistance with their auth. > >We would like to temporarily accept all users from their realm until we >clear this issue up. > >We are proxying the realm through us to them. We also have a MySQL >database backend, so I assume we should add something like > &

Re: bypass proxy auth and mysql

2003-07-02 Thread 王振国
a customer that needs temp assistance with their auth. > >We would like to temporarily accept all users from their realm until we >clear this issue up. > >We are proxying the realm through us to them. We also have a MySQL >database backend, so I assume we should add something like &

bypass proxy auth and mysql

2003-07-02 Thread Drew Flickema
We have a customer that needs temp assistance with their auth. We would like to temporarily accept all users from their realm until we clear this issue up. We are proxying the realm through us to them. We also have a MySQL database backend, so I assume we should add something like [EMAIL

MYSQL check_error - rlm_sql_getvpdata - on Linux Slackware

2003-07-02 Thread sergio jose ferreira
Hi, I'm installing freeradius 0.8.1, linux slackware 8. Have any one that can help me to resolve this problem ? I configured with : ./configure --prefix=/usr/local/radius \ --with-rlm-mysql-lib-dir=/usr/local/lib/mysql \ --with-rlm-

Re: Radius log in MySQL

2003-06-27 Thread Keith Yoder
But, as I can see, radius duplicated the entries for on single call made, for example, in a Stop Sign there is two register in the database for that specific CalledStationId, but, sometimes, the timestamp (AcctStartTime) is different. What I need it, to pull up a report with all calls made b

Radius log in MySQL

2003-06-27 Thread Daniel Destro do Carmo
Hello all, I am doing a billing system where I read the information from MySQL, generated by radius. What I do is read the registers from the Radacct table. But, as I can see, radius duplicated the entries for on single call made, for example, in a Stop Sign there is two register in the

RE: Inserting fields in MySQL/FreeRadius database

2003-06-27 Thread Carlos Henrique de Souza Brito
t: RE: Inserting fields in MySQL/FreeRadius database You will need to change the query in the SQL config file. And you will need to make sure that the value you are trying to insert is a supported variable. Its all in the docs. -Ori

Re: Freeradius + Mysql + Dialup Admin problem

2003-06-26 Thread Nickitas
It works ok , thank you very much :) On Thu, 2003-06-26 at 11:30, Oliver Graf wrote: > On Thu, Jun 26, 2003 at 11:21:58AM +0300, Nickitas wrote: > > The passwords stored in mysql are encrypted in a strange way . For > > example using crypt encryption the password stored in

Re: Freeradius + Mysql + Dialup Admin problem

2003-06-26 Thread Oliver Graf
On Thu, Jun 26, 2003 at 11:21:58AM +0300, Nickitas wrote: > The passwords stored in mysql are encrypted in a strange way . For > example using crypt encryption the password stored in the database is > this :"$1$JLBPzLpM$hHtpEcBBpJiuzxs7RLr1P0" this is an md5 password

Freeradius + Mysql + Dialup Admin problem

2003-06-26 Thread Nickitas
Hello everyone and sorry cause this is gonna be a little bit long , I am having a problem making Freeradius , Dialup Admin and Mysql work correctly . I am using Freeradius v 0.8.1 and mysql verion 3.23.49 in a RedHat 7.3 Linux . I had no problem setting up radius to work authenticating

RE: Inserting fields in MySQL/FreeRadius database

2003-06-25 Thread Tim McCracken
Carlos Henrique de Souza BritoSent: Wednesday, June 25, 2003 12:14 PMTo: [EMAIL PROTECTED]Subject: RE: Inserting fields in MySQL/FreeRadius database OK, but if I create a field directly in mysql Radius will fill it ?     -Original Message- From: Chad Stalvey [mailto

RE: Inserting fields in MySQL/FreeRadius database

2003-06-25 Thread Carlos Henrique de Souza Brito
OK, but if I create a field directly in mysql Radius will fill it ? -Original Message- From: Chad Stalvey [mailto:[EMAIL PROTECTED] Sent: Wed 6/25/2003 1:45 PM To: [EMAIL PROTECTED] Cc: Subject: RE: Inserting fields in MySQL

RE: Inserting fields in MySQL/FreeRadius database

2003-06-25 Thread Chad Stalvey
It will be   mysql> alter table table_name add newfield_name newfield_type   The syntax is here:   http://www.mysql.de/doc/de/ALTER_TABLE.html       -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Carlos Henrique de Souza BritoS

Inserting fields in MySQL/FreeRadius database

2003-06-25 Thread Carlos Henrique de Souza Brito
Hello,   I need to add more fields in the MySQL, how can I do that ?   I found in phpMyAdmin an "Add new field at end of table". Radius automagically inserts data in this field ? If not, is there a command or option in radius?     Thanks,   Carlos Brito  - List info/subscribe/unsubs

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 productio

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

mySQL + radius

2003-06-24 Thread Truong Manh Cuong
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 connection? does mySQL have trigger or function that I can write function inside mySQL ? - List info/subscribe/unsubscribe? See http

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

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

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

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

MySQL: Unknown attribute SQL-User-Name

2003-06-18 Thread Dave
Hi, I having the following error: Unknown attribute SQL- User-Name When Authenticating using a MySQL Database. Here is the output of radiusd -X : Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config

Re: MySQL database error

2003-06-18 Thread Nick Davis
ius: You should configure it like this: ./configure --with-raddbdir=/etc/raddb --with-logdir=/var/log/radius --with-mysql-include-dir=/usr/include/mysql/ --with-mysql-lib-dir=/usr/lib/ --with-mysql-dir=/usr/bin/ Just adjust the mysql directories to fit your server. Nick -- Nick Davis

Re: error with mysql

2003-06-18 Thread Chris van Meerendonk
Victor, I've had the same problem, with an CVS release from about 5/2003. There have been fixes. With the latest snapshot used with MySQL 4.0.13, InnoDB tables and also with a snapshot of 11/02/2003 I didn't have these problems. Of course I don't know which version you're us

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 lib

Re: MySQL database error

2003-06-17 Thread Jeff
='rlm_sql_mysql.so.0' # Names of this library. library_names='rlm_sql_mysql.so.0 rlm_sql_mysql.so rlm_sql_mysql.so' # The name of the static archive. old_library='rlm_sql_mysql.a' # Libraries that this one depends upon. dependency_libs=' -L/usr/local/lib/mysql -lmysqlcli

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
T (No such file > or directory) > open("/usr/local/lib/libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such file > or directory) > open("/lib/libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such file or > directory) > open("/usr/lib/libmysqlclient.la", O_RDONLY) =

Re: MySQL database error

2003-06-17 Thread Jeff
And here's some more output, this is my buffer after trying to login to my NAS using the 'jefft' account I created in mysql database 'radius' rad_recv: Access-Request packet from host 204.57.72.47:1026, id=19, length=57 User-Name = "jefft" User

Re: MySQL database error

2003-06-17 Thread Jeff
/lib/libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such file or directory) open("/usr/lib/libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such file or directory) open("libmysqlclient.la", O_RDONLY) = -1 ENOENT (No such file or directory) open("/usr/local/lib/rlm_sql_m

Re: MySQL database error

2003-06-17 Thread Frank Cusack
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 radiusd -X intermingled with s

Re: MySQL database error

2003-06-17 Thread Jeff Thompson - World Net Technical Support
m_sql: starting 0 rlm_sql: Attempting to connect #0 rlm_sql: Starting connect to MySQL server for #0 rlm_sql: Connected new DB handle, #0 rlm_sql: starting 1 rlm_sql: Attempting to connect #1 rlm_sql: Starting connect to MySQL server for #1 rlm_sql: Connected new DB handle, #1 rlm_sql: start

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

MySQL database error

2003-06-17 Thread Jeff Thompson - World Net Technical Support
y 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? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

error with mysql

2003-06-17 Thread Victor Sanchez
today i add more client to my system and when i have 70 simultaneos users acounting with radius, i have this in logs. All sockets are being used! Please increase the maximum number of sockets! what i need to do ??? thnanks for all. - List info/subscribe/unsubscribe? See http://www.freeradius

Re: Missing rlm sql mysql

2003-06-17 Thread Benjamin A. Shelton
er missed the post or couldn't be bothered correcting it... And just to support your point, I've got MySQL installed in /db/mysql (incidentally, Postgres' data is stored in /db/pgsql ...). I just like to have my databases in a separate partition altogether... ~Benjamin

Re: Missing rlm sql mysql

2003-06-17 Thread Nick Davis
List, I know this thread is about dead, but I wanted to correct some things. On Monday 16 June 2003 11:35, [EMAIL PROTECTED] wrote: > Hi Michael, > > The rlm_sql_mysql file is for building the mysql database. Under the > /freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mys

Re: Missing rlm sql mysql

2003-06-16 Thread CW
Now you should understand that it isn't a freeradius problem. if you want to see exactly what files it is looking for you should execute. strace radius -X > radiusdebug.txt just wait for 20 seconds and the cat the radiusdebug.txt file looking for "No such file" and look and see what it's looking

Re: Missing rlm sql mysql

2003-06-16 Thread Benjamin A. Shelton
> I believe that I have the correct path to the mysql libaries but I dont > know what files are considered the mysql libaries. Depending on how you installed MySQL, you *may* need to download the libraries and header files separately: http://www.mysql.com/downloads/ Look for "Li

RE: Missing rlm sql mysql

2003-06-16 Thread Kenneth . L . Miller
Title: RE: Missing rlm sql mysql Hi Michael,     The rlm_sql_mysql file is for building the mysql database. Under the /freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql directory you will find the "configure" file. Just run this script by entering "./configu

RE: Missing rlm sql mysql

2003-06-16 Thread Michael Linval
Now for a dumb question... I believe that I have the correct path to the mysql libaries but I dont know what files are considered the mysql libaries. Can someone give me an example? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Missing rlm sql mysql

2003-06-16 Thread Benjamin A. Shelton
> I have read the FAQ thanks and tried what is said. Doesnt fix it! > > Please be more specific If you have ldconfig on your system, you may need to tell it where to find your MySQL libraries. For example, I had the same problems with PostgreSQL and since ld couldn't find libpq (i

RE: Missing rlm sql mysql

2003-06-16 Thread Tim McCracken
03 8:36 AM > To: [EMAIL PROTECTED] > Subject: RE: Missing rlm sql mysql > > > I have read the FAQ thanks and tried what is said. Doesnt fix it! > > Please be more specific > > > < > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.

RE: Missing rlm sql mysql

2003-06-16 Thread Michael Linval
I have read the FAQ thanks and tried what is said. Doesnt fix it! Please be more specific http://www.freeradius.org/list/users.html

Wireless and MySQL

2003-06-16 Thread Joachim Wickman
Hello, I'm having problems with dublicate entries in authacct table They have the same data in all SQL fields. I've uncommented "simul_count_query" in sql.conf And in radiusd.conf I use sql as session database. Anything else that maybe could cause this? First I used freeradius-0.8.1 and now I

Re: freeradius 0.8.1 + mysql + password md5

2003-06-15 Thread
Ldap using a md5 password.All work fine.The server radius takes the md5 password from ldap and the user can authenticate and accounting.I have ldap in authorize and authenticate section. After I try to use freeradius with mysql.With clear password all work fine,but with an md5 password stored in mysq

Re: freeradius 0.8.1 + mysql + password md5

2003-06-13 Thread Oliver Graf
On Fri, Jun 13, 2003 at 04:27:05PM +0200, Michael Davidson wrote: > > thanks but the problem is that I'm using the nokia p022 access controller > > that don't use Pap but normal radius. > > So in authorize I use sql but in authtntication I use local. > > What can I use for md5? > Hi, I think we are

RE: freeradius 0.8.1 + mysql + password md5

2003-06-13 Thread Michael Davidson
be doing? Regards Mike D. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roberto Pioli Sent: 13 June 2003 01:48 To: [EMAIL PROTECTED] Subject: Re: freeradius 0.8.1 + mysql + password md5 > The PAP method requires nothing. PAP states that a clear text pass

Re: freeradius 0.8.1 + mysql + password md5

2003-06-13 Thread Roberto Pioli
> The PAP method requires nothing. PAP states that a clear text password > is sent over the line. How it is compared against a stored password is > in your hands. > > It's the standart problem: will the hacker hijack your phone lines an > sniff clear text PAP passwords, or will he hack your servers

Re: freeradius 0.8.1 + mysql + password md5

2003-06-13 Thread Oliver Graf
d it is not possible!?! > > > > With PAP you can use any encryption supported by freeradius. the > > > standart crypt of glibc2 will also support md5 crypts, if the crypted > > > password (use the Crypt-Password Attribute in your mysql db) has a > > > certain fo

RE: freeradius 0.8.1 + mysql + password md5

2003-06-13 Thread Paul Hampson
radius. the > > standart crypt of glibc2 will also support md5 crypts, if the crypted > > password (use the Crypt-Password Attribute in your mysql db) has a > > certain format: $1$SEED$CRYPT (see man crypt o your glibc2 system). > mod PAP has a mutex against it, but you will have

Re: freeradius 0.8.1 + mysql + password md5

2003-06-13 Thread Oliver Graf
t crypt of glibc2 will also support md5 crypts, if the crypted > password (use the Crypt-Password Attribute in your mysql db) has a > certain format: $1$SEED$CRYPT (see man crypt o your glibc2 system). Just another note: if you don't use the pap module, please note that using the internal

Re: freeradius 0.8.1 + mysql + password md5

2003-06-13 Thread Oliver Graf
swords. With PAP you can use any encryption supported by freeradius. the standart crypt of glibc2 will also support md5 crypts, if the crypted password (use the Crypt-Password Attribute in your mysql db) has a certain format: $1$SEED$CRYPT (see man crypt o your glibc2 system). If you don

Re: freeradius 0.8.1 + mysql + password md5

2003-06-13 Thread Roberto Pioli
> Hi Robert, > It is the authentication method that the client-nas have decided on that > determines what format the password needs to be in. The CHAP method requires > clear text passwords. The MS-CHAP method requires a NT-PASSWORD or > LM-PASSWORD format. The PAP method requires... and so on

RE: freeradius 0.8.1 + mysql + password md5

2003-06-13 Thread Michael Davidson
. Regards Mike D. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roberto Pioli Sent: 13 June 2003 10:52 To: [EMAIL PROTECTED] Subject: freeradius 0.8.1 + mysql + password md5 I try to use freeradius whith user in mysql and all work fine if I use clear password. If

freeradius 0.8.1 + mysql + password md5

2003-06-13 Thread Roberto Pioli
I try to use freeradius whith user in mysql and all work fine if I use clear password. If I use the web interface to write md5 password in the mysql db when I try to anthenticate I'm reject. If I use the web interface whit clear password option I have no problem. How can I use cripted pas

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 car

Re: freeradius-0.8.1 with mysql on solaris8 Initialize Problem

2003-06-11 Thread Benjamin A. Shelton
> poor! Every file is there! but why does it tell me "could not link"! http://www.freeradius.org/faq/#4.14 Because it cannot find your MySQL libraries. On FreeBSD (with PostgreSQL), I solved this by telling ldconfig where to find my Postgres libraries (which are in /usr/local

freeradius-0.8.1 with mysql on solaris8 Initialize Problem

2003-06-11 Thread CatDog
Hi,all i have successfully compiled freeradius with mysql on my solaris8 rlm_sql_mysql.so rlm_sql_mysql.la is also successfully created in /usr/local/lib bash-2.05# ls -l /usr/local/lib/rlm_sql_mysql* -rw-r--r--1 root other 40558 6?? 12 08:42 /usr/local/lib/rlm_sql_mysql.a -rwxr-xr

Re: freeradius/mysql can't browse but everything else seems to work

2003-06-11 Thread Oliver Graf
On Wed, Jun 11, 2003 at 12:35:22PM -0400, Jason Lixfeld wrote: > FreeRadius wouldn't stop users from being able to browse, bottom line. > Your NAS may be doing something funky, and the fact that the bert user > who logs in last at the bottom of your -X seems to be getting the filter > std.ppp a

Re: freeradius/mysql can't browse but everything else seems to work

2003-06-11 Thread Jason Lixfeld
isn't busted and if you are doing filtering that it's sane and not dropping traffic that shouldn't be dropped. -Original Message- From: "UK1 Webmail Customer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Date: Wed, 11 Jun 2003 17:29:46 - (UTC)

freeradius/mysql can't browse but everything else seems to work

2003-06-11 Thread UK1 Webmail Customer
I am a freeradius newbie just installed 0.8.1 with mysql users can authenticate from mysql or users file ...several differing solutions tried see radiud -X output below. (specifically users chris - mysql , brian -mysql and bert -user file.) Everything seems to work ok except browsing on port 80

RE: transaction safe tables in mysql

2003-06-10 Thread Tim McCracken
> is it advisable to use transaction safe tables in mysql for freeradius? > > thanks for the feedback > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > I don't use them, but the answer really depends on how much of a problem i

transaction safe tables in mysql

2003-06-10 Thread Engelbert de Guzman
list, is it advisable to use transaction safe tables in mysql for freeradius? thanks for the feedback - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

convert citron radius accounting file to freeradius mysql

2003-06-10 Thread Chhai Thach
Hi all, I'm looking for a script that reads citron radius log file and dump into the FR mysql database. Thanks, Chhai - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Mysql Authentication

2003-06-06 Thread Mauro
I'm trying to pass wind value via dhcp to a remote client using mysql...every dhcp fields seems to be passed fine (dns,IP.)except wins ...during authentication on ras server I see the following 04:32:00: RADIUS: cisco AVPair ""ip:wins-servers=10.0.0.1"" not applied

Re: FreeRadius with Mysql under Solaris can't work

2003-06-05 Thread
this entry will be filled with= > "rlm_sql_mysql". > > Please check it. >=09 > > Jeson >[EMAIL PROTECTED] >=A1=A12003-06-05 > >>If I remember correctly the development package for MySQL that= > comes from sunfreeware puts the files in the wrong location

<    1   2   3   4   5   6   7   8   9   10   >