----- Forwarded message from Cron Daemon <root> -----
Date: Mon, 18 Sep 2000 00:25:36 +0300 (EEST)
From: root (Cron Daemon)
To: root
Subject: Cron <root@Eagle> /etc/counts/squid-logs/copy-to-sql.sh
pqReadData() -- read() failed: errno=60
Operation timed out
PQendcopy: resetting connection
----- End forwarded message -----
this is my /etc/counts/squid-logs/copy-to-sql.sh file:
----------
#!/bin/sh
rm -f /p/logs/log_to_sql >/dev/null ;
/etc/counts/squid-logs/log-squid-to-sql.perl \ /p/logs/access.log.0 /p/logs/log_to_sql &&
/usr/local/pgsql/bin/psql -h eagle -c \ "COPY squid_logs FROM STDIN USING
DELIMITERS'\t';" stats \ < /p/logs/log_to_sql && rm -f /p/logs/log_to_sql >/dev/null
----------
Where mistake?
-- Laa