On Nov 26, 2007 4:05 PM, Clayton Dukes <[EMAIL PROTECTED]> wrote: > Sounds like your logrotate script failed to run properly. > Try running it manually and look at the output.
I've seen that the RENAME query is not running correctly in some cases that I'm not sure why. The problem I receive is: that the user does not have permission, I don't have the error right now, but it was related to DROP/ALTER permissions, which the user have. So I changed: --------- from here ------- // Rename the two tables $query = "RENAME TABLE ".DBNAME.".".DEFAULTLOGTABLE." TO ".DBNAME.".".DEFAULTLOGTABLE.$today.", " .DBNAME.".temp".DEFAULTLOGTABLE." TO ".DBNAME.".".DEFAULTLOGTABLE; perform_query($query, $dbLink); ---------- until here ------ to: --------- from here ------- // Rename the two tables $query = "RENAME TABLE ".DBNAME.".".DEFAULTLOGTABLE." TO ".DBNAME.".".DEFAULTLOGTABLE.$today; perform_query($query, $dbLink); $query = "RENAME TABLE ".DBNAME.".temp".DEFAULTLOGTABLE." TO ".DBNAME.".".DEFAULTLOGTABLE; perform_query($query, $dbLink); ---------- until here ------ And the rotation was done. -- Sergio Guzmán Lorz ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Php-syslog-ng-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
