Re: problem getting work mod_log_sql under gentoo with apache2

Max,

On Sun, April 30, 2006 6:20, blue-dragon said:
> Hi,
> here I am again,
> i think now i know whats the error by take a look at the startuperror
> log from apache.
> The error is by trying to load the module;
> i tried two diferent versions witch i found on some internet sites:
> here are the two versions with the errors i become:
>
> LoadModule log_sql_mysql_module         modules/mod_log_sql_mysql.so
>
> Cannot load /usr/lib/apache2/modules/mod_log_sql_mysql.so into server:
> /usr/lib/apache2/modules/mod_log_sql_mysql.so: undefined symbol:
> log_sql_register_driver
>
> LoadModule sql_log_module               libexec/mod_log_sql.so
>
> Cannot load /usr/lib/apache2/libexec/mod_log_sql.so into server:
> /usr/lib/apache2/libexec/mod_log_sql.so: cannot open shared object file:
> No such file or directory

Generally, under Gentoo, you don't want to mess with the LoadModule lines.
 To get the desired effect (loading optional apache modules), you add
"keys" to a variable in /etc/conf.d/apache2.  Did you add "-DLOG_SQL" to
your APACHE2_OPTS variable in the /etc/conf.d/apache2 configuration file?

>
> Can anybody help my?
> I think its an very easy error but i never tried to use a module or
> configure my apache so i dont understand wats going wrong

I have been only skimming this thread, but iirc, you used emerge to
install mod_log_sql.  Is this correct?  If so, and you've modified the
42_mod_log_sql.conf file in /etc/apache2/modules.d, then you'll want to
re-emerge it to get it back.

Also, what ebuild-versions of apache2 and mod_log_sql are you using.  You
can find out by running emerge -vp apache mod_log_sql.  If both are
up-to-date, you'll get a letter 'R' near the beginning of the lines; if
not, you'll see a letter 'U' and the current version, i.e:

Calculating dependencies ...done!
[ebuild   R   ] net-www/apache-2.0.55-r1
[ebuild     U ] net-www/mod_log_sql-1.100 [1.97]

(some details omitted).  This above indicates that I have the latest
apache installed, but the 1.97 version of mod_log_sql, and an update to
version 1.100 is available.  YMMV, but you get the idea.

There was a change to the way apache files are stored on a Gentoo system
at version (I think) 2.0.54, which is unfortunately incompatible with the
latest set of ebuilds, so you should make sure you have the latest apache
merged, as well.  If your "net-www/apache" line from the command above
shows a current version (in square brackets) of < 2.0.54, then please
update apache, and then re-merge mod_log_sql too.  You may have to update
php and other modules you installed, as well, so this could be a
time-consuming job, but it's not too hard to handle.  Of course, questions
about THOSE updates are better handled on the Gentoo forums, IRC and
mailinglists.

One last thing: Have you recently run emerge --sync?  If not, please do so
before proceeding with the above steps.  This will ensure you have all the
latest packages available to you.

Hope this helps.

- Todd


_______________________________________________
Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/

To unsubscribe send an e-mail to 
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org