Public bug reported:
Ubuntu Server 10.04 LTS AMD64
libapache2-mod-log-sql 1.100-14build1
mysql-server 5.1.41-3ubuntu12.6
apache2 2.2.14-5ubuntu8
Following the instructions in /usr/share/doc/libapache2-mod-log-
sql/manual.html with the basic settings for MySQL logging of a few
vHosts, I got:
[Wed Aug 11 22:32:57 2010] [error] mysql_query returned (1)
[Wed Aug 11 22:32:57 2010] [error] table does not exist, preserving query
[Wed Aug 11 22:32:57 2010] [error] table doesn't exist...creating now
[Wed Aug 11 22:32:57 2010] [error] failed to create table: score_board
Remedied by manually executing the "create table score_board" lines from
/usr/share/doc/libapache2-mod-log-sql/create_tables.sql (some of the
lines there are not really useful if your webserver has more than one
vhost).
Also got:
[Wed Aug 11 22:32:59 2010] [error] (13)Permission denied: attempted append of
local preserve file '/etc/apache2/logs/mod_log_sql-preserve' but failed.
Remedied by giving non-root access to /etc/apache2/logs clearly.
** Affects: libapache-mod-log-sql (Ubuntu)
Importance: Undecided
Status: New
--
Default installation with instructions followed to the letter produces errors
in apache logs
https://bugs.launchpad.net/bugs/616516
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
