Archiving Accounting Logs in MySQL

2003-08-14 Thread Ed H
About how long does one keep accounting session log records in a MySQL database before archiving? Also, has anyone written a program/cron to archive records that are not within said dates in the MySQL accounting tables? Ed _ Help

Re: Upgrade Problems - WAS: dictionary not being installed

2003-08-14 Thread Ed H
The latest CVS snapshot doesn't have this problem. Which file from the CVS should I download? Ed From: Alan DeKok [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Upgrade Problems - WAS: dictionary not being installed Date: Tue, 05 Aug 2003 12:31:32 -0400 Ed H

Re: Upgrade Problems - WAS: dictionary not being installed

2003-08-14 Thread Ed H
Any word on when the 0.9.1 release might be out? Ed From: Alan DeKok [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Upgrade Problems - WAS: dictionary not being installed Date: Tue, 05 Aug 2003 19:24:34 -0400 Ed H [EMAIL PROTECTED] wrote: Which file from

Re: dictionary not being installed

2003-08-04 Thread Ed H
Why would it isntall the first time (v. 0.8.1) and not the upgrade (v. 0.9.0)? Any suggestions? Ed From: Alan DeKok [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: dictionary not being installed Date: Sun, 03 Aug 2003 12:12:20 -0400 Ed H [EMAIL PROTECTED

Upgrade Problems - WAS: dictionary not being installed

2003-08-04 Thread Ed H
If anyone has a clue, it would be most helpful. I am ugrading from freeradius-0.8.1 to freeradius-0.9..0 on Redhat Linux 7.2, using MySQL for a backend dbase. For configure i used: ./configure --localstatedir=/var --sysconfdir=/etc --enable-ltdl-install

Re: Upgrade Problems - WAS: dictionary not being installed

2003-08-04 Thread Ed H
with no errors. I am running with the rlm_sqlcounter module so how do I go about configuring if I can't get configure to work with the --with-experimental-modules option? Ed From: Ed H [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Upgrade Problems - WAS: dictionary

RE: Upgrade Problems - WAS: dictionary not being installed

2003-08-04 Thread Ed H
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ed H Sent: 04 August 2003 23:51 To: [EMAIL PROTECTED] Subject: Re: Upgrade Problems - WAS: dictionary not being installed Well I've been trying to debug and found something interesting. When I run ./configure

RE: Experimental modules

2003-08-04 Thread Ed H
I am having the same problem installing --with-experimental-modules for version 0.9.0. Has this been fixed, or is there a workaround? Ed This means the 'experimental module' cannot be configured without the user specifically going to that directory and changing the execution permission bit,

Re: dictionary not being installed

2003-08-02 Thread Ed H
-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: dictionary not being installed Date: Sat, 02 Aug 2003 08:28:58 -0400 Ed H [EMAIL PROTECTED] wrote: I am upgrading from 0.8.1 to 0.9.0 and the /usr/local/share/freeradius/dictionary file is not being installed properly. Did you watch what

dictionary not being installed

2003-08-01 Thread Ed H
Hello, I am upgrading from 0.8.1 to 0.9.0 and the /usr/local/share/freeradius/dictionary file is not being installed properly. When running radtest I am getting the error/etc/raddb/dictionary[14]: Couldn't open dictionary /usr/local/share/freeradius/dictionary: No such file or directory Is

Re: problem installing free radius on redhat

2003-04-04 Thread Ed H
Hello, Make sure you have the dbm headers installed for redhat. Ed From: 0nefob [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: problem installing free radius on redhat Date: Thu, 3 Apr 2003 09:52:59 -0800 (PST) hi, i am having problem installing freeradius 0.8.1

Re: REPOST: rlm_sqlcounter not working...

2003-03-31 Thread Ed H
Hello Robert, Make sure you have a Max-Monthly-Session := 3600, for example (where 3600 is the time in seconds allowed per month) in your radgroupcheck or radcheck table. The same applies to the Max-All-Session and the Max-Daily-Session variables. Give it a shot and see if it works. Ed

sqlcounter.conf - What is sqlmod-inst = sqlcca3?

2003-03-21 Thread Ed H
I am using the rlm_sqlcounter module. According to the doc/rlm_sqlcounter file, the sqlcounter.conf file their should be an A/V pair for the monthlycounter {} directive that says 'sqlmod-inst = sqlcca3'. What is this? When I use it with 'sqlmod-inst = sqlcca3' I get an SQL error, however when

Preference for TimeZone for Accounting

2003-03-21 Thread Ed H
I was wondering what the preference for time zones are for Accounting user's time; ie GMT, or the RADIUS server's timezone -7, etc? I notice that the accounting tables in MySQL is logging the timestamp according the the server's timezone; ie, where it is physically located. Is there a way to

Re: Previnting Simultaneous-Use

2003-03-21 Thread Ed H
Simultaneous-Use := 1 must be in the radcheck or radgroupcheck tables, not the radreply or radgroupreply tables. Ed From: Travis Best [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Previnting Simultaneous-Use Date: Fri, 21 Mar 2003 16:02:10 -0500 I am

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: Simultanous use not working using sql

2003-03-19 Thread Ed H
Hello Wisam, I am no expert here, but it sounds like you need the Perl modules SNMP_Session and BER installed. You can find them at http://www.switch.ch/misc/leinen/snmp/perl/ This is documented in doc/Simultaneous-Use Ed From: Wisam Najim [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To:

Re: questions about checkrad

2003-03-19 Thread Ed H
Got it to work! I changed nastype=other in clients.conf. I had nastype=portslave. Now NTRadPing is giving Access-Reject when trying to log in multiple times. Hallelujah! Thanks for you help. Ed From: Ed H [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re

db.counter: Permission denied

2003-03-19 Thread Ed H
I just configured the counter module in radiusd.conf and I restarted radiusd and got this error: rlm_counter: Failed to open file /etc/raddb/db.counter: Permission denied Any suggestions on how to fix? Ed _ Help STOP SPAM

sqlcounter.conf Error

2003-03-19 Thread Ed H
I am using the rlm_sqlcounter module. I have configured per the documentation from doc/rlm_sqlcounter. When I run radiusd in debug mode I get the following error: Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /etc/raddb/proxy.conf

Re: sqlcounter.conf Error

2003-03-19 Thread Ed H
From: Ed H [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: sqlcounter.conf Error Date: Wed, 19 Mar 2003 23:08:40 + I am using the rlm_sqlcounter module. I have configured per the documentation from doc/rlm_sqlcounter. When I run radiusd in debug mode I get

rlm_sqlcounter: unknown xlat function [WAS: rlm_sqlcounter Help-me]

2003-03-19 Thread Ed H
I have the same problem below as this previous message posted below. Did this ever get solved? I need help with: WARNING: Attempt to use unknown xlat function or attribute in string %{sqlcca3: as in the original message below. Ed original message From Mon, 23 Dec 2002 03:33:47 -0800

Re: questions about checkrad

2003-03-18 Thread Ed H
Hello Alan, If I have an NAS box proxying to me, then how do I use Simultaneous-Use in a MySQL setup? Does it use checkrad? Ed From: Alan DeKok [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: questions about checkrad Date: Mon, 17 Mar 2003 19:30:45 -0500

Re: questions about checkrad

2003-03-18 Thread Ed H
directive. Ed From: Alan DeKok [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: questions about checkrad Date: Tue, 18 Mar 2003 08:13:05 -0500 Ed H [EMAIL PROTECTED] wrote: If I have an NAS box proxying to me, then how do I use Simultaneous-Use in a MySQL setup? Does

RE: Simultaneous-Use + MySQL + NTRadPing

2003-03-18 Thread Ed H
of the records for that username will be ended with the same AcctStopTime entered into the MySQL database, and every entry for that username has been stopped. Ed From: Scott Bartlett [EMAIL PROTECTED] To: Ed H [EMAIL PROTECTED] Subject: RE: Simultaneous-Use + MySQL + NTRadPing Date: Tue, 18 Mar

Re: questions about checkrad

2003-03-18 Thread Ed H
{ # Get an address from the IP Pool. #main_pool } Ed From: Alan DeKok [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: questions about checkrad Date: Tue, 18 Mar 2003 09:36:58 -0500 Ed H [EMAIL PROTECTED] wrote: How do I use Simultaneous-Use

rlm_counter: Failed to open file /etc/raddb/db.counter: Permission denied

2003-03-18 Thread Ed H
I just configured the counter module in radiusd.conf and I restarted radiusd and got this error: rlm_counter: Failed to open file /etc/raddb/db.counter: Permission denied Any suggestions on how to fix? Ed _ The new MSN 8:

Simultaneous-Use + MySQL + NTRadPing

2003-03-17 Thread Ed H
Hello, I am using MySQL with FreeRadius 0.8.1, and RedHat 8.2, and testing with NTRadPing. I also have SNMP_Session and BER installed. I have put Simultaneous-Use := 1 into my radgroupcheck table. However, I can still login the same user multiple times and it shows up into the radacct table.

Disabling Users with MySQL module

2003-03-07 Thread Ed H
What is the best method for disabling a user using the MySQL module? I have come up with two altervatives, if anybody knows of a better way, please let me know. ALTERNATIVE #1: Put a Auth-Type=Reject directly in the radcheck MySQL table for that user. Example (reject user fredf): mysql select

MySQL - Attributes:Values go in which tables?

2003-03-06 Thread Ed H
Newbie is confused... I have Freeradius running on a Redhat 8.2 system with MySQL tables. I actually have test accounts authenticating and being rejected, and the accounting working in the MySQL db tables. My question: Is there any good documentation on which Attributes and Values go into

Re: Newbie: Permissions on rlm_sql_mysql/db_mysql.sql

2003-02-27 Thread Ed H
PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Newbie: Permissions on rlm_sql_mysql/db_mysql.sql Date: Wed, 26 Feb 2003 17:15:36 -0800 (PST) On Thu, 27 Feb 2003, Ed H wrote: To add, this is all an attempt to get rid of the error below: rlm_sql: Could not link driver

Newbie: Permissions on rlm_sql_mysql/db_mysql.sql

2003-02-26 Thread Ed H
Hello: I am a newbie installing FreeRadius for the first time on a Redhat Linux 7.2 system with MySQL capabilities. I got the system to run without the SQL option and am now having problems reading the db_mysql.sql library. I added the rlm_sql_mysql path to my ld.so.conf file and also to the

Re: Newbie: Permissions on rlm_sql_mysql/db_mysql.sql

2003-02-26 Thread Ed H
To add, this is all an attempt to get rid of the error below: rlm_sql: Could not link driver rlm_sql_mysql: file not found rlm_sql: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. Ed