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. Ltd Unix, 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] 942 Main Street
http://www.cyberzone.net Hartford, CT. 06103
# MySQL radius.cfg
Trace 4
PidFile /usr/local/radius/radiusd.pid
AuthPort 1645
AcctPort 1646
LogDir /usr/local/radius/log
LogFile %L/%Y%m%d
DbDir /usr/local/radius/raddb
DictionaryFile /usr/local/radius/dictionary.usr
RewriteUsername tr/[A-Z]/[a-z]/
PmwhoProg /usr/local/sbin/pmwho
SnmpgetProg /usr/bin/snmpget
<Client xxx.xxx.xxx.xxx>
Secret xxxxxx
DefaultRealm cyberzone.net
IgnoreAcctSignature
NasType TotalControlSNMP
SNMPCommunity xxxxxx
IdenticalClients xxx.xxx.xxx.xxx etc.
</Client>
<Client xxx.xxx.xxx.xxx>
Secret xxxxxx
DefaultRealm cyberzone.net
IgnoreAcctSignature
NasType Hiper
SNMPCommunity xxxxxx
IdenticalClients xxx.xxx.xxx.xxx etc
</Client>
<Client DEFAULT>
Secret xxxxxx
DefaultRealm cyberzone.net
IgnoreAcctSignature
</Client>
<Client localhost>
Secret xxxxxx
DefaultRealm cyberzone.net
DupInterval 0
</Client>
<Realm cyberzone.net>
# AuthByPolicy ContinueUntilAccept
AuthByPolicy ContinueWhileIgnore
RewriteUsername s/^([^@]+).*/$1/
<AuthBy SQL>
DBSource dbi:mysql:radius:xxx.xxx.xxx.xxx
DBUsername xxxxx
DBAuth xxxxx
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
AccountingTable Acct%m%y
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIMESTAMP,Timestamp,formatted-date,'%Y-%m-%e %H:%M:%S'
AcctColumnDef STATUSTYPE,Acct-Status-Type
AcctColumnDef DELAYTIME,Acct-Delay-Time,integer
AcctColumnDef INPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef OUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef SESSIONID,Acct-Session-Id
AcctColumnDef SESSIONTIME,Acct-Session-Time,integer
AcctColumnDef TERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASIDENT,Client-Id
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
AcctColumnDef CONNECTSPEED,Connect-Speed
AcctColumnDef MODTYPE,Modulation-Type
AcctColumnDef CALLERID,Calling-Station-Id
AcctColumnDef POPID,Called-Station-Id
</AuthBy>
<AuthBy FILE>
Filename %D/users
</AuthBy>
<AuthBy RADIUS>
Host xxx.xxx.xxx.xxx
Secret xxxxxx
</AuthBy>
</Realm>
<SessionDatabase SQL>
DBSource dbi:mysql:radius:xxx.xxx.xxx.xxx
DBUsername xxxxxx
DBAuth xxxxxx
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>
Thu Jul 1 10:15:07 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1059 ....
Code: Access-Request
Identifier: 22
Authentic: 1234567890123456
Attributes:
User-Name = "rhawley"
Service-Type = Framed-User
Client-Id = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
User-Password = "<137><187>3<204><221>5w<246><188>8<9><160><216>}x<153>"
Thu Jul 1 10:15:07 1999: DEBUG: Rewrote user name to rhawley
Thu Jul 1 10:15:07 1999: DEBUG: Handling request with Handler 'Realm=cyberzone.net'
Thu Jul 1 10:15:07 1999: DEBUG: Rewrote user name to rhawley
Thu Jul 1 10:15:07 1999: DEBUG: Handling with Radius::AuthSQL
Thu Jul 1 10:15:07 1999: DEBUG: Handling with Radius::AuthSQL
Thu Jul 1 10:15:07 1999: DEBUG: Query is: Select PASSWORD, IDLETIME, SESSIONTIME,
SIMUSE, LOGONTIME, ST
ATICIP from Subscribers Where USERNAME = 'rhawley' and STATUS = 'A'
Thu Jul 1 10:15:07 1999: DEBUG: Radius::AuthSQL looks for match with rhawley
Thu Jul 1 10:15:07 1999: DEBUG: Radius::AuthSQL ACCEPT:
Thu Jul 1 10:15:07 1999: DEBUG: Access accepted for rhawley
Thu Jul 1 10:15:07 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 1059 ....
Code: Access-Accept
Identifier: 22
Authentic: 1234567890123456
Attributes:
Thu Jul 1 10:15:07 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1059 ....
Code: Accounting-Request
Identifier: 23
Authentic: <164><235><253><173>L3<156><185>~d<153><241><197>e<180><233>
Attributes:
User-Name = "rhawley"
Service-Type = Framed-User
Client-Id = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Start
Thu Jul 1 10:15:07 1999: DEBUG: Rewrote user name to rhawley
Thu Jul 1 10:15:07 1999: DEBUG: Handling request with Handler 'Realm=cyberzone.net'
Thu Jul 1 10:15:07 1999: DEBUG: Rewrote user name to rhawley
Thu Jul 1 10:15:07 1999: DEBUG: Handling with Radius::AuthSQL
Thu Jul 1 10:15:07 1999: DEBUG: Handling accounting with Radius::AuthSQL
Thu Jul 1 10:15:07 1999: DEBUG: do query is: insert into Acct0799
(USERNAME, SESSIONID, TIMESTAMP, NASIDENT, STATUSTYPE)
values
('rhawley', '00001234', '1999-07- 1 10:15:07', '203.63.154.1',
'Start')
Thu Jul 1 10:15:07 1999: DEBUG: Adding session for rhawley, 203.63.154.1, 1234
Thu Jul 1 10:15:07 1999: DEBUG: Accounting accepted
Thu Jul 1 10:15:07 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 1059 ....
Code: Accounting-Response
Identifier: 23
Authentic: <164><235><253><173>L3<156><185>~d<153><241><197>e<180><233>
Attributes:
Thu Jul 1 10:15:07 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 1059 ....
Code: Accounting-Request
Identifier: 24
Authentic: t<169>+<18><23><244><214>k<236>7+<224><219>3<177><197>
Attributes:
User-Name = "rhawley"
Service-Type = Framed-User
Client-Id = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Acct-Session-Id = "00001234"
Acct-Status-Type = Stop
Acct-Delay-Time = 0
Acct-Session-Time = 1000
Acct-Input-Octets = 20000
Acct-Output-Octets = 30000
Thu Jul 1 10:15:07 1999: DEBUG: Rewrote user name to rhawley
Thu Jul 1 10:15:07 1999: DEBUG: Handling request with Handler 'Realm=cyberzone.net'
Thu Jul 1 10:15:07 1999: DEBUG: Rewrote user name to rhawley
Thu Jul 1 10:15:07 1999: DEBUG: Handling with Radius::AuthSQL
Thu Jul 1 10:15:07 1999: DEBUG: Handling accounting with Radius::AuthSQL
Thu Jul 1 10:15:07 1999: DEBUG: do query is: insert into Acct0799
(USERNAME, SESSIONID, INPUTOCTETS, SESSIONTIME, OUTPUTOCTETS,
TIMESTAMP, NASIDENT, DELAY
TIME, STATUSTYPE)
values
('rhawley', '00001234', 20000, 1000, 30000, '1999-07- 1 10:15:07',
'203.63.154.1', 0, 'S
top')
Thu Jul 1 10:15:07 1999: DEBUG: Deleting session for rhawley, 203.63.154.1, 1234
Thu Jul 1 10:15:07 1999: DEBUG: Accounting accepted
Thu Jul 1 10:15:07 1999: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 1059 ....
Code: Accounting-Response
Identifier: 24
Authentic: t<169>+<18><23><244><214>k<236>7+<224><219>3<177><197>
Attributes:
