(RADIATOR) SQL help

1999-03-11 Thread Richard Hawley
How would I go about having separate Radius Accounting logs for say, each day of the month, using an SQL database? I know I can do the following, but what I'm not sure about is if Radiator can create the tables or if the tables for each day have to be created already? AccountingTable ACCT%m%d

(RADIATOR) Simultaneous Use checking

1999-03-16 Thread Richard Hawley
Simultaneous Use checking does not seem to be working. I am not sure exactly why. I am using an SQL database with the following table AuthColumnDef 0, User-Password, check AuthColumnDef 1, Idle-Timeout, reply AuthColumnDef 2, Session-Timeout, reply AuthColumnDef 3,

(RADIATOR) mysql create statement

1999-03-22 Thread Richard Hawley
Maybe this list isn't the proper place to ask this, but I'm sure someone here can help me :). I have a pre-existing database that was already setup when I started working on the system. It has a username column as shown below. I am trying to duplicate the table into monthly tables for the

Re: (RADIATOR) Console errors

1999-03-22 Thread Richard Hawley
Sun Mar 21 21:44:12 1999: WARNING: SessSQL do failed for 'insert into RadiusSessions (UserName, NASIdent, NASPort, AcctSessionID, TimeStamp, FramedAddress, NASPortType, ServiceType) values ('gut', '209.150.6.3', 517, '33817274', 922070652, '209.150.16.71', '', 'Framed-User')': Got error -1 from

(RADIATOR) Re: Couple of things

1999-03-22 Thread Richard Hawley
Mike McCauley wrote: Hi Richard, On Mar 19, 11:56am, Richard Hawley wrote: Subject: Couple of things You mentioned that you needed to know what kind of database I ran before you could help me configure it for human readable dates. I run MySQL. In that case, you will need to make

(RADIATOR) Re: Couple of things

1999-03-22 Thread Richard Hawley
Thats what I do have. I'm new to SQL, but I'm not that new :). So, is there anything else that could be causing the blank fields? ..Rich Mike McCauley wrote: On Mar 22, 2:02pm, Richard Hawley wrote: Subject: Re: Couple of things Mike McCauley wrote: Hi Richard, On Mar 19

(RADIATOR) MySQL config file

1999-03-23 Thread Richard Hawley
I am having numerous problems with my config file using MySQL. If you are using MySQL for your users and for accounting, could you send me a copy of your radius.cfg file so I can see a working copy. Maybe that would help me troubleshoot mine. Thanks alot. ..Rich --

(RADIATOR) New radiator setup

1999-04-02 Thread Richard Hawley
I am setting up Radiator 2.13 on a new box and I am getting the following error. The accounting is working fine. I checked the select statement in my radius.cfg file by loading mysql and typing it in by hand and it works. sending Access-Request... DBD::mysql::st execute failed: You have an

(RADIATOR) Session database not being updated

1999-04-28 Thread Richard Hawley
I have had several instances since putting Radiator into production where the session database does not get updated. When I check the accounting files, I notice that the accounting database never received a stop request for that session. My question is, what would cause the stop request to

(RADIATOR) radwho.cgi and radacct.cgi

1999-05-03 Thread Richard Hawley
Slightly off topic, but... [Mon May 3 14:07:25 1999] [error] (2)No such file or directory: exec of /home/httpd/cgi-bin/radacct.cgi failed [Mon May 3 14:07:25 1999] [error] [client xxx.xxx.xxx.xxx] Premature end of script headers: /home/httpd/cgi-bin/radacct.cgi The directory exists and so

(RADIATOR) ODBC drivers for linux

1999-06-03 Thread Richard Hawley
We are switching our billing package to Platypus. I've been going through the Emerald and Platypus sections of the radiator manual and it mentions needing an ODBC driver to connect to MS SQL. I downloaded and installed iODBC. Is that all I need? There was no documentation that came with

Re: (RADIATOR) ODBC drivers for linux

1999-06-04 Thread Richard Hawley
p you used, so we can document it for others? Cheers. Kevin Sofnet, Inc. -Original Message----- From: Richard Hawley [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, June 03, 1999 4:42 PM Subject: (RADIATOR) ODBC drivers for linux We are switching our billi

Re: (RADIATOR) ODBC drivers for linux

1999-06-04 Thread Richard Hawley
: Richard Hawley [EMAIL PROTECTED] To: Kevin Wormington [EMAIL PROTECTED]; Mike McCauley [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, June 04, 1999 9:54 AM Subject: Re: (RADIATOR) ODBC drivers for linux What version of perl are you using? I am using 5.00405 and when I tried

(RADIATOR) Converting mysql to Platypus

1999-06-07 Thread Richard Hawley
In my ongoing struggle to setup radiator to authenticate off a SQL Server and Platypus, I have the following questions: I'm using the Authby EMERALD because we do have the Radius package add-on for platypus. However, I was looking at AuthbyEMERALD.pm. Can I not specify a custom select

(RADIATOR) SNMP errors update

1999-07-01 Thread Richard Hawley
I think I fixed the SNMP errors. I downloaded the patches-2.13.1.tar.gz file and installed that in the source directory and reinstalled. The SNMP errors stopped. However, I'm getting another error/warning now. Every couple of minutes, I get this error: Timeout: No Response from

(RADIATOR) New problem - External session database not working

1999-07-01 Thread Richard Hawley
During the week I was on vacation, the session database decided to stop working. And I am having trouble troubleshooting it because of the following: 1) The database is a MySQL database. The database server is working perfectly. The authentication and accounting work off of the same

Re: (RADIATOR) New problem - External session database not working

1999-07-02 Thread Richard Hawley
nt immediately think of a reason for this. To investigate closer, we will need to see your configuration file (no secrets), plus your log file at trace level 4, showing what happens during accounting requests. Cheers. On Jul 1, 3:21pm, Richard Hawley wrote: Subject: (RADIATOR) New problem - Exter

Fwd: Re: (RADIATOR) New problem - External session database not working

1999-07-02 Thread Richard Hawley
Let's try this again, but this time we will actually attach the files. :) ==BEGIN FORWARDED MESSAGE== From: "Richard Hawley" [EMAIL PROTECTED] To: "Mike McCauley" [EMAIL PROTECTED], "[EMAIL PROTECTED] " [EMAIL PROTECTED] D

Re: (RADIATOR) Radiator eats my machine!

1999-07-15 Thread Richard Hawley
I still get that error too. My simultaneous use checking has been flakey every since that error started. I even tried reinstalling Radiator with the tarball patch archive and I still get it. I was almost convinced it was not radiator and something with snmpget on RedHat but if you are