Bug 95693

Summary:	mod_log_sql install but can't access mysql database and/or can't write to sql file
Product:	Gentoo Linux	Reporter:	Claudinei Matos <claudineimatos>
Component:	[OLD] Server	Assignee:	Apache Team - Bugzilla Reports <apache-bugs>
Status:	RESOLVED FIXED
Severity:	blocker	CC:	jakub, Mark
Priority:	High
Version:	unspecified
Hardware:	x86
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

Description Claudinei Matos 2005-06-10 08:17:09 UTC

I did installed mod_log_sql (1.97) but it never works since it can't connect to
mysql database and can't write to sql file.
I've tried to upgrade to 1.100 version and now it's working fine, but I have to
update apache (and all apache modules) and that's not what I want.

Reproducible: Always
Steps to Reproduce:
1.emerge mod_log_sql
2.edited /etc/apache2/conf/modules.d/10_mod_log_sql.conf
3./etc/init.d/apache2 start

Actual Results:  
[error] (13)Permission denied: attempted append of local preserve file
'/var/log/apache2/mod_slog_sql_preserve.sql' but failed.
[error] mod_log_sql: child spawned but unable to open database link

Expected Results:  
Insert log to mysql database or write to preserv file.

Portage 2.0.51.19 (default-linux/x86/2005.0, gcc-3.3.5-20050130,
glibc-2.3.4.20041102-r1, 2.6.11-gentoo-r6 i686)
=================================================================
System uname: 2.6.11-gentoo-r6 i686 Intel(R) Pentium(R) 4 CPU 3.20GHz
Gentoo Base System version 1.4.16
Python:              dev-lang/python-2.3.5 [2.3.5 (#1, May  6 2005, 19:09:21)]
dev-lang/python:     2.3.5
sys-apps/sandbox:    [Not Present]
sys-devel/autoconf:  2.59-r6, 2.13
sys-devel/automake:  1.7.9-r1, 1.8.5-r3, 1.5, 1.4_p6, 1.6.3, 1.9.5
sys-devel/binutils:  2.15.92.0.2-r7
sys-devel/libtool:   1.5.16
virtual/os-headers:  2.6.8.1-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CFLAGS="-O2 -march=pentium4 -fomit-frame-pointer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3/share/config
/usr/share/config /var/bind /var/qmail/control"
CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d"
CXXFLAGS="-O2 -march=pentium4 -fomit-frame-pointer"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoaddcvs autoconfig ccache distlocks sandbox sfperms strict"
GENTOO_MIRRORS="http://distfiles.gentoo.org
http://distro.ibiblio.org/pub/Linux/distributions/gentoo"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 alsa apache2 apm arts avi berkdb bitmap-fonts crypt cups emboss encode
foomaticdb fortran gd gdbm gif gnome gpm gtk gtk2 imap imlib jpeg kde ldap
libg++ libwww mad mikmod motif mp3 mpeg mysql ncurses nls oggvorbis opengl oss
pam pdflib perl png postgres python quicktime readline samba sdl snmp spell ssl
svga tcpd tiff truetype truetype-fonts type1-fonts vhosts xml2 xmms xv zlib
userland_GNU kernel_linux elibc_glibc"
Unset:  ASFLAGS, CBUILD, CTARGET, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTDIR_OVERLAY

Comment 1 Jakub Moc (RETIRED) gentoo-dev

2005-10-05 00:43:09 UTC

What's the status here?

Comment 2 Michael Stewart (vericgar) (RETIRED) gentoo-dev

2006-03-05 18:39:30 UTC

The reported noted in thier original report that it works with 1.100 which is for new-style apache. As old-style apache is no longer supported, this bug is obsolete, as it applies to a version of a module we don't support anymore.