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: