(RADIATOR) Install on windows 95
Hi, Try using the -s flag in radpwtst to explicitly specify the address of your server That fixed it. I have been up and running for some time now but too busy to reply. Thanks very much for the help. I will be able to leave you alone for a while at least! Arnie *** Arnold Roberts Satelcom UK LTD Silwood Park Buckhurst Road Ascot Berkshire UK SL5 7PW Tel: +44 1344 872677 Fax +44 1344 872206 *** === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) syncing multiple users files question...
Greetings! We have two radiator servers, each is independent but the configurations and user files are identical. Our NAS is setup to query the first, and if there is no reply to query the second. In this way, if one server fails the other is available to respond. Is there a slick neato way to sync up the users file between the two? It's a pain to have to add new users in two places. We'd prefer to not have one spot (like a remote SQL database, etc.) because this introduces a single point of failure. The first method that comes to mind is setting up a cron job to rcp or ftp the users file on one machine or the other. We're not crazy about allowing rcp or ftp into our radius servers though... Is there another method anyone has found? Jay West === 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) syncing multiple users files question...
I use 'rsync' combined with 'ssh'. This allows for secure transmission between the servers and rsync is a more advanced version of rdist (plus it uses the ssh stuff for security.) rysnc: http://rsync.samba.org ssh: http://www.cs.hut.fi/ssh -- Aaron Holtz ComNet Inc. UNIX Systems Specialist Email: [EMAIL PROTECTED] "It's not broken, it just lacks duct tape." -- On Mar 22, Jay West molded the electrons to say Greetings! We have two radiator servers, each is independent but the configurations and user files are identical. Our NAS is setup to query the first, and if there is no reply to query the second. In this way, if one server fails the other is available to respond. Is there a slick neato way to sync up the users file between the two? It's a pain to have to add new users in two places. We'd prefer to not have one spot (like a remote SQL database, etc.) because this introduces a single point of failure. The first method that comes to mind is setting up a cron job to rcp or ftp the users file on one machine or the other. We're not crazy about allowing rcp or ftp into our radius servers though... Is there another method anyone has found? Jay West === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) syncing multiple users files question...
The first method that comes to mind is setting up a cron job to rcp or ftp the users file on one machine or the other. We're not crazy about allowing rcp or ftp into our radius servers though... Is there another method anyone has found? How does rsync or scp (part of ssh) sound to you? Scp encrypts everything and can be configured to require preset keys, and is the more secure of the two, although rsync is nicer about not copying things that haven't changed, and only sending the updates across rather than the whole file. === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
RE: (RADIATOR) syncing multiple users files question...
Hi Jay. Try rsync from samba.org. Treat the primary as the source, make your changes only there, and copy everything to the secondary at regular intervals. The first copy takes a (relatively) long time, subsequent "copies" move only the differences across the wire. The nicest thing about it is that it uses a channel you set up - such as ssh, which will encrypt the lot, and which doesn't require having rcp/rsh holes on either server. It doesn't even require root access on the source machine. Depending on your setup, you might want to weave a "stop radiator/stop database" in there at the critical moments, otherwise you might copy inconsistent data. Regards, K. Am 22-Mar-99 schrieb Jay West: Greetings! We have two radiator servers, each is independent but the configurations and user files are identical. Our NAS is setup to query the first, and if there is no reply to query the second. In this way, if one server fails the other is available to respond. Is there a slick neato way to sync up the users file between the two? It's a pain to have to add new users in two places. We'd prefer to not have one spot (like a remote SQL database, etc.) because this introduces a single point of failure. The first method that comes to mind is setting up a cron job to rcp or ftp the users file on one machine or the other. We're not crazy about allowing rcp or ftp into our radius servers though... Is there another method anyone has found? Jay West === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. --- ~ Karl Auer ([EMAIL PROTECTED]) Geschaeft/work +41-1-6327531 Kommunikation, ETHZ RZ Privat/home +41-1-4517941 Clausiusstrasse 59 Fax +41-1-6321225 CH-8092 ZUERICH Switzerland === 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) SCO
Hi All, Is there anyone running Radiator on SCO Openserver? -- 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.
Re: (RADIATOR) mysql create statement
On Mar 22, 10:30am, Richard Hawley wrote: Subject: (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. From my experiments, it seems that the MUL means that UserName is a non-unique index. There might be other columns that also are part of the index; only the first one seems to get MUL. You could create one with something like. create table xxx ( UserName char(50) not null, index somename (UserName)); Cheers. +-+--+--+-+-+---+ | 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. -- 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) Re: Couple of things
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) Re: Some Questions
Hi Peter, I would recommend that you use dictionary.ascend You can ignore for the moment the error messages from dictionary.ascend, and we will try to find the Ascend vendor-specific attribute definitions. Anyone have a dictionary with the ascend vendor specific attributes (vendor code 529) in it? On Mar 22, 11:52pm, Peter Chow wrote: Subject: Some Questions Hi Mike, I am able to use the radiator with the system password and through a MAX4000. But I have problem when I use proxy radius withe the radiator. My radius is running on Ascend AAC. And, we are using Ascend MAX4000 with dialup pool set to pool 8. Here is config file for RADIATOR. ** Foreground LogStdout DbDir /etc/raddb LogDir /etc/radacct # This clause defines a single client to listen to # You will probably want to change localhost and mysecret # to suit your site. Client localhost Secret mysecret /Client Client 202.60.252.23 Secret secret /Client # This clause means we will handle any real that arrives Realm DEFAULT AuthBy FILE Filename /etc/raddb/users /AuthBy # Log accounting to the detail file in LogDir AcctLogFileName /etc/radacct/detail /Realm # This clause defines an authorisation method that will be used # by any users in the database with Auth-Type="System". It will # match the "Identifier System" Realm dummyrealmforholdingauthbyunix AuthBy UNIX Identifier System Filename /etc/shadow /AuthBy /Realm users DEFAULT Auth-Type = System Framed-Protocol = PPP, Framed-IP-Netmask = 255.255.255.255, Framed-Routing = None, Framed-MTU = 1500, Framed-Compression = Van-Jacobson-TCP-IP, Ascend-Assign-IP-Pool = 8 *** If I use the default dictionary, I cannot log in and it generate the error You have received a message! Mon Mar 22 23:22:32 1999: ERR: Attribute number 125 (vendor 529) is not defined in your dictionary Mon Mar 22 23:22:32 1999: ERR: Attribute number 244 (vendor 529) is not defined in your dictionary If I use the ascend dictionary, I can log in but it generate more errors. [root@highed1 raddb]# tail -f /etc/radacct/detail Ascend-Pre-Input-Packets = 4 Ascend-Pre-Output-Packets = 9 Ascend-First-Dest = 202.60.252.8 Ascend-Modem-PortNo = 10 Ascend-Modem-SlotNo = 7 Called-Station-Id = "7188" Framed-Protocol = PPP Framed-IP-Address = 203.85.251.11 Timestamp = 922115239 Mon Mar 22 23:28:02 1999: ERR: Attribute number 32 (vendor ) is not defined in your dictionary Mon Mar 22 23:28:02 1999: ERR: Attribute number 125 (vendor 529) is not defined in your dictionary Mon Mar 22 23:28:02 1999: ERR: Attribute number 244 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:04 1999: ERR: Attribute number 32 (vendor ) is not defined in your dictionary Mon Mar 22 23:29:04 1999: ERR: Attribute number 125 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:04 1999: ERR: Attribute number 244 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:05 1999: ERR: Attribute number 120 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:05 1999: ERR: Attribute number 121 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:05 1999: ERR: Attribute number 32 (vendor ) is not defined in your dictionary Mon Mar 22 23:29:05 1999 User-Name = "tested1" NAS-Identifier = 202.60.252.23 NAS-Port = 20118 NAS-Port-Type = Async Acct-Status-Type = Start Acct-Delay-Time = 0 Acct-Session-Id = "290717039" Acct-Authentic = RADIUS Client-Port-DNIS = "7188" Framed-Protocol = PPP Framed-Address = 203.85.251.18 Ascend-Handle-IPX = 1952805748 Proxy-State = 0 Timestamp = 922116545 Mon Mar 22 23:29:44 1999: ERR: Attribute number 195 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:44 1999: ERR: Attribute number 196 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:44 1999: ERR: Attribute number 255 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:44 1999: ERR: Attribute number 197 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:44 1999: ERR: Attribute number 198 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:44 1999: ERR: Attribute number 190 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:44 1999: ERR: Attribute number 191 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:44 1999: ERR: Attribute number 192 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:44 1999: ERR: Attribute number 193 (vendor 529) is not defined in your dictionary Mon Mar 22 23:29:44 1999: ERR: Attribute number 189 (vendor
Re: (RADIATOR) Console errors
Hi Richard,
That doesnt look too good. What happens when you run the SQL command
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')
directly by mysql?
On Mar 22, 12:22pm, Richard Hawley wrote:
Subject: 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]
-- 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,
(RADIATOR) Re: arg priority
Hi Steve What is the priority of command line arguments? If I specify the port number will it override the port number in the config file? Yes, command line overrides config file. Cheers. -- 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) reports?
Heres a question forwarded from a customer: 8) I've been looking for some cgi's to display things like modem usage over time (by hour, day of week), modem usage list (for location of dead modems, etc.) Do such CGI's exist for Radiator either in the stock distribution or contrib directory? Anyone? -- 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.
Re: (RADIATOR) Simultaneous-Use!!!
On Mon, 22 Mar 1999, True Communications Corp. wrote: defined to 1 as the default for all users in the users file. I was under the impression that you can override the default for any of the users by using the Simultaneous-Use attribute in the users file. Which is exactly what I did. Wouldn't that be nice. Unfortunately it doesn't work that way. It uses the MOST restrictive setting. I would really love to have a "DefaultSessionMax" or something. That meant without a specific Sim-Use setting use the default. Then the sim-use setting would OVERRIDE the default. Much better. :-) Steve === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) Newbie Problem
Howdy all, Just a quick newbie quesiton for you all. I'm trying to evaluate emerald and radiator. I'm experiencing a two tear error mesage so to speak. Radiator gives me a message that says install_driver(sybase) failed: Can't load 'g:\perl\site\lib/auto/DBD/Sybase/Sybase.dll' for module DBD::sybase: load_file:The specified module could not be found at g:\perl\lib/DynaLoader.pm line 168. at eval 19 line 2 at g:\perl\site\lib/Radius/SqlDB.pm Line 97. and at the same time WindowsNt informs me that libct.dll could not be found. I'm using the standard Emerald.cfg file with the following changes DBSourcedbi:Sybase:emerald DBUsername radiususer DBAuth secret Am I right in saying the dbsource is what I defined the system DSN as (ie. the sql server one which I called Emerald); the username is the user I defined in SQL Enterprise Manager for the emerald databases?, and the Auth is? . . . not used for emerald? Sooo basically my question is that, where to I obtain this libct.dll from which windows nt requires, and what do I change so the paths that radiator wants can be found. they do exist but the / slashes kills it I think, I.E in windows nt you can get to a dir called dbd-sybase, but try a "cd dbd-sybase" and it doesn't work. I'm sorry for the stupid question, but I only learned what Radius was a week ago :-). cheers, Aaron -- Aaron Miles ([EMAIL PROTECTED]) -- System Administrator - Impact Creativity Centre. Have: -- 1988 BMW 325i Executive. Need: -- 236kw E36 M3 === 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) services / inetd
Hi, Does any one know whether radiator will run from /etc/services? This is a much quicker way to restart the server if it dies, or is there a parameter I can use like squid has, so it will auto restart? Regards, Paul Thornton. ,- __ -, DOVE AUSTRALIA SYSADMIN TEAM / \___/ /__ _ _/ \ / _ / _ / _ \ |/ / -_) _ \ Account queries: [EMAIL PROTECTED] /.- \_,_/\___/___/\__/-.\ Tech Support: [EMAIL PROTECTED] A U S T R A L I A Sales queries: [EMAIL PROTECTED] http://dove.net.auAdmin queries: [EMAIL PROTECTED] === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
Re: (RADIATOR) services / inetd
Hi Paul, On Mar 23, 1:32pm, Paul Thornton wrote: Subject: (RADIATOR) services / inetd Hi, Does any one know whether radiator will run from /etc/services? Perhaps you mean from /etc/inetd with the appropriate entry in /etc/services? If so, yes. Details are in the reference manual. Or do you mean "run as a service on NT" Thats also a yes, with details in the same place. This is a much quicker way to restart the server if it dies, or is there a parameter I can use like squid has, so it will auto restart? There is also a wrapper in the goodies directory that will restart it as soon as it stops, and optionally email you to say so. Details in the same place. Are you seeing it dying periodically? I think most people are finding it to be very robust. If you are seeing it die, please send me what details you can, and I will see what the problem is. Are you at revision 2.13.x yet? Cheers. Regards, Paul Thornton. ,- __ -, DOVE AUSTRALIA SYSADMIN TEAM / \___/ /__ _ _/ \ / _ / _ / _ \ |/ / -_) _ \ Account queries: [EMAIL PROTECTED] /.- \_,_/\___/___/\__/-.\ Tech Support: [EMAIL PROTECTED] A U S T R A L I A Sales queries: [EMAIL PROTECTED] http://dove.net.auAdmin queries: [EMAIL PROTECTED] === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. -- End of excerpt from Paul Thornton -- 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.
Re: (RADIATOR) services / inetd
Hi, I am always getting a problem of Out of Memory when trying to run radiusd and even quicker when using the restartWrapper program. These are the system loads before running. --- Snip --- load averages: 1.46, 1.96, 1.81 14:35:52 185 processes: 1 running, 184 sleeping CPU states: % user, % nice, % system, % interrupt, %idle Memory: Real: 49M/76M Virt: 91M/978M Free: 132M PID USERNAME PRI NICE SIZE RES STATE TIME WCPUCPU COMMAND 12621 root 20 15M 15M sleep 0:08 1.22% 1.22% radiusd ^ Different Radius Server :( These are the system loads after running. --- Snip --- load averages: 3.14, 2.32, 1.89 14:33:34 186 processes: 2 running, 184 sleeping CPU states: 78.1% user, 0.0% nice, 21.9% system, 0.0% interrupt, 0.0% idle Memory: Real: 148M/171M Virt: 192M/1080M Free: 36M PID USERNAME PRI NICE SIZE RES STATE TIME WCPUCPU COMMAND 13471 root 910 96M 96M run 0:27 83.23% 66.46% radiusd Radiator Does any one know how to fix this. The unlimit datasize used to work but now that even bombs out. Thanks, Paul Thornton. === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
