(RADIATOR) SQL help
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 Thanks. ..Rich -- Richard W. Hawley - Network Engineer CyberZone Internet Services http://www.cyberzone.net [EMAIL PROTECTED] === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) Simultaneous Use checking
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, Simultaneous-Use, check
AuthColumnDef 4, Time, check
AuthColumnDef 5, GENERIC, check
AuthColumnDef 6, GENERIC, reply
AuthColumnDef 7, Framed-IP-Address, reply
My session database is as follows
SessionDatabase SQL
DBSource
DBUsername
DBAuth
AddQuery \
insert into Sessions (UserName, NASIdent, NASPort, \
AcctSessionID, TimeStamp, FramedAddress, NASPortType, \
ServiceType) values ('%n', '%N', %{NAS-Port},
'%{Acct-Session-Id
}', \
%{Timestamp}, '%{Framed-IP-Address}', '%{Port-Type}',
'%{Service
-Type}')
DeleteQuery \
delete from Sessions where UserName='%n' and \
NASIdent='%N' and NASPort=%{NAS-Port}
ClearNasQuery \
delete from Sessions where NASIdent='%N'
CountQuery \
select NASIdent, NASPort, AcctSessionID from Sessions \
where UserName='%n'
/SessionDatabase
I'm very new to SQL so forgive my inexperience. I am learning more
everyday but this problem can't wait for me to figure it out. :)
Also, could someone give me some pointers on making the Timestamp field
more human readable? The seconds since Jan 1, 1970 is functional but is
there a way to make it a normal date? I've read the section in the
Radiator reference manual on Formated date stamps, etc, but I am not
sure how to configure that for SQL. Plus I don't want to make a mistake
and corrupt the tables. Thanks all.
..Rich
--
Richard W. Hawley - Network Engineer
CyberZone Internet Services
http://www.cyberzone.net
[EMAIL PROTECTED]
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
(RADIATOR) mysql create statement
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 accounting, but I dont know the syntax of the create table statement that will give me a value of MUL in the Key. I assume MUL is short for multiple since you would need to have multiple entries of the same username. The MySQL docs don't really explain this. +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | UserName| char(50) | | MUL | | | Thanks. ..Rich -- Richard W. Hawley - Network Engineer CyberZone Internet Services http://www.cyberzone.net [EMAIL PROTECTED] === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) Console errors
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
table handler
Sun Mar 21 21:44:29 1999: WARNING: SessSQL do failed for 'insert into
RadiusSessions (UserName, NASIdent, NASPort, AcctSessionID, TimeStamp,
FramedAddress, NASPortType, ServiceType) values ('fightbac', '209.150.6.3', 1294,
'84738617', 922070669, '209.150.16.102', '', 'Framed-User')': Got error -1 from
table handler
Sun Mar 21 21:44:31 1999: WARNING: SessSQL do failed for 'insert into
RadiusSessions (UserName, NASIdent, NASPort, AcctSessionID, TimeStamp,
FramedAddress, NASPortType, ServiceType) values ('magnai', '209.150.6.5', 108,
'057d', 922070671, '209.150.6.21', '', 'Framed-User')': Got error -1 from table
handler
Sun Mar 21 21:44:39 1999: WARNING: SessSQL do failed for 'insert into
RadiusSessions (UserName, NASIdent, NASPort, AcctSessionID, TimeStamp,
FramedAddress, NASPortType, ServiceType) values ('dragontalon', '209.150.6.3',
1801, '117965370', 922070679, '209.150.16.197', '', 'Framed-User')': Got error -1
from table handler
As you can see, its happening every few seconds.
..Rich
Mike McCauley wrote:
Hi Rich,
On Mar 19, 12:36pm, Rich Hawley wrote:
Subject: (RADIATOR) Console errors
DBD::mysql::db do failed: Got error -1 from table handler at
/usr/lib/perl5/site_perl/Radius/SessSQL.pm line 103
The radius logs show that the failure is happening when it tries to add
an entry to the session database, but I'm not sure why that is failing.
The radius.cfg file has the following session info. The DBUsername and
DBAuth is the same as the AuthBy section and that works, so I doubt its
that.
I havent seen that one before.
It looks like an error thats been thrown back by mysql. It would be helpful if
we could see the SQL query that caused this (you can see them by running
Radiator at a trace level of 4). We could then determine if Radiator has sent a
bad query of if the problem originated in mysql.
Is it happening all the time, or just occasionally?
What revisions of mysql, DBI and DBD-mysql are you running?
Cheers.
SessionDatabase SQL
DBSource dbi:mysql:Radius
DBUsername
DBAuth
AddQuery \
insert into RadiusSessions (UserName, NASIdent, NASPort,
\
AcctSessionID, TimeStamp, FramedAddress, NASPortType, \
ServiceType) values ('%n', '%N', %{NAS-Port},
'%{Acct-Session-Id}', \
%{Timestamp}, '%{Framed-IP-Address}', '%{Port-Type}',
'%{Service-Type}')
DeleteQuery \
delete from RadiusSessions where UserName='%n' and \
NASIdent='%N' and NASPort=%{NAS-Port}
ClearNasQuery \
delete from RadiusSessions where NASIdent='%N'
CountQuery \
select NASIdent, NASPort, AcctSessionID from
RadiusSessions \
where UserName='%n'
/SessionDatabase
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
-- End of excerpt from Rich Hawley
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia Consulting and development
Phone, Fax: +61 3 9598-0985 http://www.open.com.au
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, external, etc etc on Unix, Win95/8, NT, Rhapsody
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
--
Richard W. Hawley - Network Engineer
CyberZone Internet Services
http://www.cyberzone.net
[EMAIL PROTECTED]
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
(RADIATOR) Re: Couple of things
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 your Timestamp column a DATETIME data type,
thnn you can have something like this in you Radiator config:
AcctColumnDef AcctColumnDef TIME_STAMP,Timestamp,formatted-date,'%Y-%m-%e
%H:%M:%S'
The timestamp is now coming out like this: '-00-00 0:00:00' on every accounting
start and stop. What did I do wrong?
Trace level 4 output
Mon Mar 22 13:56:48 1999: DEBUG: Query is: insert into Acct0399
(CallerID, UserName, ModType, InputOctets, OutputOctets,
StatusType, NASPort, FramedIPAddress, SessionID, SessionTime, TimeStamp, NASIdent,
TerminateCause, ConnectSpeed, PopID, DelayTime)
values
('4015965324', 'user', NULL, 212, 186, 'Stop', 109,
'209.150.4.208', '796c', 111, '922129008', '209.150.4.3',
'ACCT_TERM_USER_REQUEST', NULL, '3263000', 0)
Here is how I created the table:
CREATE TABLE Acct0399 (
UserName char(50) DEFAULT '' NOT NULL,
TimeStamp datetime,
StatusType char(10),
DelayTime int(11),
InputOctets int(11),
OutputOctets int(11),
SessionID char(30),
SessionTime int(11),
TerminateCause char(50),
NASIdent char(50),
NASPort int(11),
FramedIPAddress char(16),
ConnectSpeed char(50),
ModType char(50),
CallerID char(30),
PopID char(30),
KEY Accounting_I (UserName)
);
I need to fix this fast :). Thanks.
..Rich
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
(RADIATOR) Re: Couple of things
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, 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 your Timestamp column a DATETIME data
type,
thnn you can have something like this in you Radiator config:
AcctColumnDef AcctColumnDef
TIME_STAMP,Timestamp,formatted-date,'%Y-%m-%e
%H:%M:%S'
When I said "something like" I meant you will need to adjust it for your
particular field names. In your case, you will want exactly:
AcctColumnDef TimeStamp,Timestamp,formatted-date,'%Y-%m-%e %H:%M:%S'
The first name in the arg list is the name of the SQL column.
Cheers.
The timestamp is now coming out like this: '-00-00 0:00:00' on every
accounting
start and stop. What did I do wrong?
Trace level 4 output
Mon Mar 22 13:56:48 1999: DEBUG: Query is: insert into Acct0399
(CallerID, UserName, ModType, InputOctets, OutputOctets,
StatusType, NASPort, FramedIPAddress, SessionID, SessionTime, TimeStamp,
NASIdent,
TerminateCause, ConnectSpeed, PopID, DelayTime)
values
('4015965324', 'user', NULL, 212, 186, 'Stop', 109,
'209.150.4.208', '796c', 111, '922129008', '209.150.4.3',
'ACCT_TERM_USER_REQUEST', NULL, '3263000', 0)
Here is how I created the table:
CREATE TABLE Acct0399 (
UserName char(50) DEFAULT '' NOT NULL,
TimeStamp datetime,
StatusType char(10),
DelayTime int(11),
InputOctets int(11),
OutputOctets int(11),
SessionID char(30),
SessionTime int(11),
TerminateCause char(50),
NASIdent char(50),
NASPort int(11),
FramedIPAddress char(16),
ConnectSpeed char(50),
ModType char(50),
CallerID char(30),
PopID char(30),
KEY Accounting_I (UserName)
);
I need to fix this fast :). Thanks.
..Rich
-- End of excerpt from Richard Hawley
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia Consulting and development
Phone, Fax: +61 3 9598-0985 http://www.open.com.au
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, external, etc etc on Unix, Win95/8, NT, Rhapsody
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
(RADIATOR) MySQL config file
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 -- Richard W. Hawley - Network Engineer CyberZone Internet Services http://www.cyberzone.net [EMAIL PROTECTED] === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) New radiator setup
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 error in your SQL syntax near 'from Subscribers Where USERNAME = 'rhawley' and STATUS = 'A'' at line 1 at /usr/lib/perl5/site_perl/Radius/SqlDb.pm line 154. Log at trace 4 Fri Apr 2 10:50:17 1999: ERR: Execute failed for 'Select PASSWORD, IDLETIME, SESSIONTIME, SIMUSE, LOGONTIME, STATICIP, from Subscribers Where USERNAME = 'rhawley' and STATUS = 'A'': You have an error in your SQL syntax near 'from Subscribers Where USERNAME = 'rhawley' and STATUS = 'A'' at line 1 The accounting start and stop test worked fine. What am I missing that is causing this error. I know its not an error in the select statement because it works manually. So it must be a perl module I am missing? Radiator 2.13 Msql-Mysql-modules 1.2009 DBI 1.06 TimeDate 1.08 ..Rich === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) Session database not being updated
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 either not be sent, or not be received by Radiator? The NAS is a USR Hiper Modem Chassis. Could it be a problem with the dictionary file? I am using the dictionary.usr which came with Radiator. Thanks. ..Rich -- Richard W. Hawley - Network Engineer CyberZone Internet Services http://www.cyberzone.net [EMAIL PROTECTED] === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) radwho.cgi and radacct.cgi
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 does the filename. /home is a symlink to /usr/local/home and I configured the cgi-bin directory on the web server to follow sym links. Anyone have this problem? I'm sure it is a misconfiguration in the web server, but Im not sure why. I can run other cgi scripts from that directory. ..Rich -- Richard W. Hawley - Network Engineer CyberZone Internet Services http://www.cyberzone.net [EMAIL PROTECTED] === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) ODBC drivers for linux
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 iODBC, just a so file and the odbc.ini. Can someone who is using a similar setup send me an example of there odbc.ini and a location of any other odbc components I may need besides iODBC? Thanks. ..Rich -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) ODBC drivers for linux
What version of perl are you using? I am using 5.00405 and when I tried to run make test, I got a screen full of errors. Here is a few examples. /usr/lib/perl5/i386-linux/5.00405/CORE/scope.h:110: parse error before `bool' /usr/lib/perl5/i386-linux/5.00405/CORE/scope.h:110: warning: no semicolon at end of struct or union In file included from /usr/lib/perl5/site_perl/i386-linux/auto/DBI/DBIXS.h:13, from FreeTDS.h:45, from FreeTDS.xs:35: /usr/lib/perl5/i386-linux/5.00405/CORE/perl.h:1322: parse error before `Perl_nomemok' /usr/lib/perl5/i386-linux/5.00405/CORE/perl.h:1322: warning: data definition has no type or storage class The errors ended in this FreeTDS.c: In function `XS_DBD__FreeTDS__dr_discon_all_': FreeTDS.c:71: warning: unused variable `ix' FreeTDS.c: In function `XS_DBD__FreeTDS__st_fetchrow_arrayref': FreeTDS.c:434: warning: unused variable `ix' FreeTDS.c: In function `XS_DBD__FreeTDS__st_fetchrow_array': FreeTDS.c:451: warning: unused variable `ix' FreeTDS.c: In function `XS_DBD__FreeTDS__st_FETCH_attrib': FreeTDS.c:562: warning: unused variable `ix' make: *** [FreeTDS.o] Error 1 The Sybase option wont work with SQL 7.0 according to the Boardtown DBA who is here. And the Openlink multi-tier distribution is incomplete. The docs mention a udbc.ini file in the bin directory. There is no bin directory in the distribution, no udbc.ini file anywhere. "Our driver looks for a file pointed to by the environment variable UDBCINI, or the file /etc/udbc.ini if the environment variable is not defined. This file is located in the openlink/bin directory." Thanks for any help. ..Rich On Fri, 4 Jun 1999 08:23:27 -0500, Mike McCauley wrote: Hi Kevin On Jun 3, 4:41pm, Kevin Wormington wrote: Subject: Re: (RADIATOR) ODBC drivers for linux The only success that I have had is with DBI and DBD::FreeTDS which works very well connection to MS SQL 6.5 and 7.0 and requires no other client libraries. Thats interesting. we have not used that one. Can you send more details about where to get it and the setup 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 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 iODBC, just a so file and the odbc.ini. Can someone who is using a similar setup send me an example of there odbc.ini and a location of any other odbc components I may need besides iODBC? Thanks. ..Rich --- --- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- End of excerpt from Kevin Wormington -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) ODBC drivers for linux
The URL is ftp://freetds.internetcds.com/pub/freetds_dbd/ in case anyone else wants to take a peak. I have the latest version. 0.02. I'm using perl 5.00.4 and DBI 1.02. Any difference to your setup? ..Rich On Fri, 4 Jun 1999 14:31:43 -0500, Kevin Wormington wrote: I'm out of the office so I don't have access to the url, but if you look through the FreeTDS readme/docs it has the ftp address that you can get the latest version from, from memory it was something like ftp.internetcds.com, anyway that will fix your compile error. Kevin Sofnet, Inc. -Original Message- From: 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 to run make test, I got a screen full of errors. Here is a few examples. /usr/lib/perl5/i386-linux/5.00405/CORE/scope.h:110: parse error before `bool' /usr/lib/perl5/i386-linux/5.00405/CORE/scope.h:110: warning: no semicolon at end of struct or union In file included from /usr/lib/perl5/site_perl/i386-linux/auto/DBI/DBIXS.h:13, from FreeTDS.h:45, from FreeTDS.xs:35: /usr/lib/perl5/i386-linux/5.00405/CORE/perl.h:1322: parse error before `Perl_nomemok' /usr/lib/perl5/i386-linux/5.00405/CORE/perl.h:1322: warning: data definition has no type or storage class The errors ended in this FreeTDS.c: In function `XS_DBD__FreeTDS__dr_discon_all_': FreeTDS.c:71: warning: unused variable `ix' FreeTDS.c: In function `XS_DBD__FreeTDS__st_fetchrow_arrayref': FreeTDS.c:434: warning: unused variable `ix' FreeTDS.c: In function `XS_DBD__FreeTDS__st_fetchrow_array': FreeTDS.c:451: warning: unused variable `ix' FreeTDS.c: In function `XS_DBD__FreeTDS__st_FETCH_attrib': FreeTDS.c:562: warning: unused variable `ix' make: *** [FreeTDS.o] Error 1 The Sybase option wont work with SQL 7.0 according to the Boardtown DBA who is here. And the Openlink multi-tier distribution is incomplete. The docs mention a udbc.ini file in the bin directory. There is no bin directory in the distribution, no udbc.ini file anywhere. "Our driver looks for a file pointed to by the environment variable UDBCINI, or the file /etc/udbc.ini if the environment variable is not defined. This file is located in the openlink/bin directory." Thanks for any help. ..Rich On Fri, 4 Jun 1999 08:23:27 -0500, Mike McCauley wrote: Hi Kevin On Jun 3, 4:41pm, Kevin Wormington wrote: Subject: Re: (RADIATOR) ODBC drivers for linux The only success that I have had is with DBI and DBD::FreeTDS which works very well connection to MS SQL 6.5 and 7.0 and requires no other client libraries. Thats interesting. we have not used that one. Can you send more details about where to get it and the setup 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 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 iODBC, just a so file and the odbc.ini. Can someone who is using a similar setup send me an example of there odbc.ini and a location of any other odbc components I may need besides iODBC? Thanks. ..Rich --- --- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- End of excerpt from Kevin Wormington -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscrib
(RADIATOR) Converting mysql to Platypus
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 statement like the one used by AuthbySQL.pm? Must I use the default table structure that emerald uses? I tried setting the AuthSelect varilable but I am getting an error message in the logs. See below: BTW, I got the FreeTDS DBD to work. Thanks to Kevin Wormington for all the help. REALM blahblah AuthByPolicy ContinueWhileIgnore RewriteUsername s/^([^@]+).*/$1/ AuthBy EMERALD DBSource dbi:FreeTDS:database=somedb;host=somehostname;port=someport; DBUsernamesomeuser DBAuthsomepw AuthSelect select password, idletime, sessiontime, simuse, \ logontime, staticip from subscribers where username = '%n' \ and status = 'A' AuthColumnDef 0, User-Password, check AuthColumnDef 1, Idle-Timeout, reply AuthColumnDef 2, Session-Timeout, reply AuthColumnDef 3, Simultaneous-Use, check AuthColumnDef 4, Time, check AuthColumnDef 5, Framed-IP-Address, reply In the logs, I get this Mon Jun 7 16:01:55 1999: DEBUG: Query is: select DateAdd(Day, ma.extension, maE xpireDate), DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType, sa.password, sa.login, sa.shell, sa.TimeLeft Select password, idletime, sessiont ime, simuse, logontime, staticip from subscribers where username = '%n' and stat us = 'A' from masteraccounts ma, subaccounts sa where (sa.login = 'rhawley' or sa.shell = 'rhawley') and ma.customerid = sa.customerid and sa.active 0 and ma.active 0 Mon Jun 7 16:01:55 1999: ERR: Execute failed for 'select DateAdd(Day, ma.extens ion, maExpireDate), DateAdd(Day, sa.extension, saExpireDate), sa.AccountID, sa.AccountType, sa.password, sa.login, sa.shell, sa.TimeLeft Select password, idletime, sessiont ime, simuse, logontime, staticip from subscribers where username = '%n' and stat us = 'A' from masteraccounts ma, subaccounts sa where (sa.login = 'rhawley' or sa.shell = 'rhawley') and ma.customerid = sa.customerid and sa.active 0 and ma.active 0': Error processing tds packet. Coulnd't g et column information This is what leads me to believe that I cannot use the AuthSelect config option. :( ..Rich -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) SNMP errors update
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 xxx.xxx.xxx.xxx What is timing out? The ip address is one of my NAS's. ..Rich -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) New problem - External session database not working
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 database and they are both working. I can add, delete, and modify the session table manually with no problems. 2) Radiator is reporting NO errors in the log file (At trace level 5). It seems like it is not even trying to add or check the session database. I do see deleting session for user jondoe for the Stop records. 3) I have Hiper and TotalControl NAS's and I am using SNMP for sim-use checking. I have been having alot of problems with that (previous emails today will explain the problem), but I can't determine why the external session database is not being updated. ..Rich -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) New problem - External session database not working
Attached is the config and trace level 4 log. I do not specify MaxSessions but I do have Simultaneous-Use set as a check item in the AuthColumnDef. As I stated in my original message, the log file isn't reporting any errors which is why I couldn't figure it out. Any help is appreciated. ..Rich PS: Perhaps someone could also see the problem which is causing my SNMP errors? I am still getting error messages for SNMP, though it is no longer printing out the usage information for snmpget nor is it giving the bash error saying "sh: snmpcommunity: command not found" SNMP error which prints to the console: Error in packet Reason: (noSuchName) There is no such variable name in this MIB. This name doesn't exist: I know for a fact from typing out the snmpget command manually, that is should say "This name doesnt exist: snmpcommunity". For some reason it is blank. Any ideas? PSS: Could these two problems be related? Is it possible that radiator is snmp querying the NAS, not able to connect and clearing all the entries from the session database? Would it log that? On Fri, 2 Jul 1999 09:40:04 -0500, Mike McCauley wrote: Hi Richard, I cant 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 - External session database not working 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 database and they are both working. I can add, delete, and modify the session table manually with no problems. 2) Radiator is reporting NO errors in the log file (At trace level 5). It seems like it is not even trying to add or check the session database. I do see deleting session for user jondoe for the Stop records. 3) I have Hiper and TotalControl NAS's and I am using SNMP for sim-use checking. I have been having alot of problems with that (previous emails today will explain the problem), but I can't determine why the external session database is not being updated. ..Rich -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- End of excerpt from Richard Hawley -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Fwd: Re: (RADIATOR) New problem - External session database not working
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] Date: Fri, 02 Jul 1999 07:44:08 -0400 Reply-To: "Richard Hawley" [EMAIL PROTECTED] Priority: Normal X-Mailer: PMMail 98 Standard (2.01.1600) For Windows 98 (4.10.1998) MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Subject: Re: (RADIATOR) New problem - External session database not working Attached is the config and trace level 4 log. I do not specify MaxSessions but I do have Simultaneous-Use set as a check item in the AuthColumnDef. As I stated in my original message, the log file isn't reporting any errors which is why I couldn't figure it out. Any help is appreciated. ..Rich PS: Perhaps someone could also see the problem which is causing my SNMP errors? I am still getting error messages for SNMP, though it is no longer printing out the usage information for snmpget nor is it giving the bash error saying "sh: snmpcommunity: command not found" SNMP error which prints to the console: Error in packet Reason: (noSuchName) There is no such variable name in this MIB. This name doesn't exist: I know for a fact from typing out the snmpget command manually, that is should say "This name doesnt exist: snmpcommunity". For some reason it is blank. Any ideas? PSS: Could these two problems be related? Is it possible that radiator is snmp querying the NAS, not able to connect and clearing all the entries from the session database? Would it log that? On Fri, 2 Jul 1999 09:40:04 -0500, Mike McCauley wrote: Hi Richard, I cant 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 - External session database not working 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 database and they are both working. I can add, delete, and modify the session table manually with no problems. 2) Radiator is reporting NO errors in the log file (At trace level 5). It seems like it is not even trying to add or check the session database. I do see deleting session for user jondoe for the Stop records. 3) I have Hiper and TotalControl NAS's and I am using SNMP for sim-use checking. I have been having alot of problems with that (previous emails today will explain the problem), but I can't determine why the external session database is not being updated. ..Rich -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- End of excerpt from Richard Hawley -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 ===END FORWARDED MESSAGE=== -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED]
Re: (RADIATOR) Radiator eats my machine!
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 getting it, maybe we can correlate and figure out whats causing it. Here is my setup RedHat Linux 5.2 with kernel 2.2.9 (patched). All RH updates for 2.2.x installed. Radiator 2.13.1 with all patches perl-5.004m4-1 DBI-1.08 TimeDate-1.08 The error I get is Error in packet Reason: (noSuchName) There is no such variable name in this MIB. This name doesn't exist: We have 3com HiPer ARC's and NetServers and I use a NASType of Hiper and TotalControlSNMP. I have tried replacing RH's snmpget rpm with the latest compiled source of ucd-snmp. Same error. Radiator never crashes though. Error in packet Reason: (noSuchName) There is no such variable name in this MIB. This name doesn't exist: enterprises.15.2.16.1.2.1.3.1.36 -- Richard W. Hawley - Network Engineer CyberZone Internet Services [EMAIL PROTECTED] 942 Main Street http://www.cyberzone.net Hartford, CT. 06103 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
