[no subject]

2011-10-14 Thread OzSpots - Carl Sawers
Hi All, I have searched high and low for a Radacct Terminate cause description for Freeradius, the terminate cause states Lost-Session , anyone know what it refers too? Regards Carl - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

terminate session

2011-10-13 Thread OzSpots - Carl Sawers
Hi All, I am using the latest freeradius and coovachilli and am having a terminate session problem. Some user sessions are not stopping, the session time shown in the DB stops but the user does not logout and there is also no reason given in the DB for termination... The user can also go over

RE: terminate session

2011-10-13 Thread OzSpots - Carl Sawers
OzSpots - Carl Sawers wrote: The user can also go over the ChilliSpot-Max-Total-Octets quota and the Idle-Timeout does not appear to work. Then it's a chillispot problem. It has nothing to do with FreeRADIUS. How does radius send a stop session command to the coovachilli router, perhaps

RE: radius.log test?

2011-07-18 Thread OzSpots - Carl Sawers
Thanks for that, rather odd, I ran radius -X and found the location the request was coming from, it was one of our pc's which must have been running a test in the background, a reboot turned it off. cheers Regards Carl - List info/subscribe/unsubscribe? See

radius.log test?

2011-07-17 Thread OzSpots - Carl Sawers
Hi all, I have suddenly started seeing this in the radius.log ( 2.2) Mon Jul 18 11:36:23 2011 : Auth: Login incorrect: [TEST/+\253\362\023\213\223-~\272\257]$\003\033\211] (from client localhost port 0) All seems well besides this. It started happening a day ago every 30 seconds. Anyone

RE: Slow Mysql Queries

2011-06-07 Thread OzSpots - Carl Sawers
Thanks for the help Fajar, We wish to fix this in house so don't want to pay for a dba BUT we are not getting much closer to the issue though I have found that a lot of the tables are actually indexed I just didn't know where to look. PHPmyadmin runtime info states that  Select_full_join  

RE: Slow Mysql Queries

2011-06-06 Thread OzSpots - Carl Sawers
Thanks for the advice everyone! I have removed scripts which caused the VERY slow queries and have now had the slow query log on for a few days. It is still showing loads of entry's but http access performance is not noticeably slow(on occasion there is a small delay). The slow queries appear to

RE: Slow Mysql Queries

2011-06-05 Thread OzSpots - Carl Sawers
Thanks Guys, The slow query log has a lot of entry's in it. It's not obvious which are causing the most issues but I have found a script that was always slowish so have removed it. The line read # Query_time: 5 Lock_time: 0 Rows_sent: 3 Rows_examined: 17286222 No idea where it thinks there

Slow Mysql Queries

2011-06-04 Thread OzSpots - Carl Sawers
Hi All, I have a freeradius server which has some slow mysql queries and some errors like the below happen now and again(daily). We have actually just upgraded to this server and have imported all the MYsql data into the new server (it was working fine on the older quite similar server). One