[squid-users] Squidalyser

From: Simon Bryan <sbryan@dont-contact.us>
Date: Thu, 1 May 2003 09:48:18 +1000

Hi all,
I have been happily using squidalyser to parse my logs into MYSql and to
retire records older then two months (other scipts then pick out excess
users and add them to a delay_pools list)

As of the 1st May I get the following error, I have rotated the logs to see
if it was a probelm in the log itself and have set the time format to both
UK and US - anybody got any other ideas why it would fail today?

DBD::mysql::st execute failed: Got error 127 from table handler at
/usr/local/squidparse/squidparse.pl line 138, <LOG> line 30828.
Died at /usr/local/squidparse/squidparse.pl line 140, <LOG> line 30828.

Running /usr/local/squidparse/squidparse.pl at Thu May 1 09:40:26 2003

DB Name: squid
DB Host: localhost
DB User: squidalyser
Squidlog: /usr/local/squid/var/logs/access.log.0
DELETE FROM logfile WHERE time < 1046907626

_________________________________________
Simon Bryan
IT Manager
OLMC Parramata
ICQ#: 137562751
_________________________________________
Received on Wed Apr 30 2003 - 17:47:54 MDT

This archive was generated by hypermail pre-2.1.9 : Tue Dec 09 2003 - 17:15:45 MST