Re: mod_log_sql help confgiuring on debian etch

"Chris" <[email protected]> Sat, 27 Oct 2007 12:38:14 -0600
Newsgroups	gmane.comp.apache.mod-log-sql
Message-ID	<[email protected]>
This is a multi-part message in MIME format.

--===============1686844187==
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_000E_01C81896.3E334E90"

This is a multi-part message in MIME format.

------=_NextPart_000_000E_01C81896.3E334E90
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Here is what I have on httpd.conf now where apachelog is the user, password
is the password and apachelogs in the database.  I have flushed the db and
turned on LogSQLCreateTables.  When I reload the config my browser simply
sits on connecting when I point it at my domain.

 

LogSQLLoginInfo mysql://apachelog:password@localhost/apachelogs

LogSQLSocketFile /var/run/mysqld/mysqld.sock

LogSQLCreateTables On

LogSQLMassVirtualHosting Off

LogSQLMachineID kernel

LogSQLPreserveFile /var/tmp/sql-preserve

 

I have the following parameters in my vhost file
/etc/apache2/sites-enabled/000-default

 

        LogSQLTransferLogTable access_mp3crib.com

        LogSQLScoreDomain mp3crib.com

 

For the LogSQLPreserveFile I ran this command mysql - root -p mydbname <
/var/tmp/sql-preserve to ensure it is in a writable directory and the file
is writable.  Not exactly sure if the parameters in the vhost file are
correct.  My web server still functions properly if I comment out the
LogSQLLoginInfo and LogSQLPreserveFile params in httpd.conf file and yes I
did verify the password is correct for the mysql user.  I was hoping this
was going to be easy, but I should've known otherwise when I turned to Sid
for the package.

 

-----Original Message-----
From: mod_log_sql-bounces-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org
[mailto:mod_log_sql-bounces-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org] On Behalf Of Peter
Sent: Saturday, October 27, 2007 11:43 AM
To: General mod_log_sql discussion
Subject: Re: [Mod_log_sql] mod_log_sql help confgiuring on debian etch

 

Hi

 

It took me awhile to get it running on Etch.

 

You need to have log_sql and log_sql_mysql loaded. I created a user to

access my db with create rights so the tables would be created. This

seems to work better then creating the tables yourself. At least the

fields will be correct you can turn off LogSQLCreateTables later. You

also need to make sure you have mod_log_sql-preserve in a writable

directory. Check there for errors.

 

Your http.conf is blank be default. I added:

 

LogSQLLoginInfo mysql://loguser:username@localhost/apachelogs

LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock

LogSQLCreateTables On

LogSQLMassVirtualHosting Off

LogSQLMachineID web

 

 

In vhost setup I used:

 

      LogSQLTransferLogTable access_vhost_name_com

      LogSQLScoreDomain vhost_name.com

 

Good luck :) 

 

On Sat, 2007-27-10 at 11:11 -0600, Chris wrote:

> I'm trying to setup mod_log_sql to log my apache access log entries in

> a mysql 5 database. I have installed mod_log_sql version 1.100 from

> sid using aptitude install libapache2-mod-log-sql. 

> 

> I then created the tables using a SQL file created by the developer of

> the package to create them for me. The documentation, unfortunately,

> it is not debian centric and is asking me to put things in my

> httpd.conf file such as:

> 

>  

> 

> Example: Use the MySQL database called "apachelogs" running on

> "dbmachine.foo.com". Use username "loguser" and password "l0gg3r" to

> authenticate to the database. Permit the module create tables for us. 

> 

> LogSQLLoginInfo dbmachine.foo.com loguser l0gg3r 

> 

> LogSQLDatabase apachelogs 

> 

> LogSQLCreateTables on 

> 

> If your database resides on localhost instead of another host, specify

> the MySQL server's socket file as follows: 

> 

> LogSQLSocketFile /your/path/to/mysql.sock 

> 

> If your database is listening on a port other than 3306, specify the

> correct TCP port as follows: 

> 

> LogSQLTCPPort 1234

> 

>  

> 

> There is no area to do this in httpd.conf really, in fact it is a

> blank file since I am on apache2. Do I just add these directives in

> myself? Please advise, I am using the documentation located here:

>
http://www.outoforder.cc/projects/apache/mod_log_sql/docs/node4.html#SECTION
00042000000000000000

> and my server is Etch based running MySQL 5 Apache 2 and yes, I did

> install the mod_log_sql from the unstable repo sid. Also I did verify

> the modules is in /etc/mods-enabled/ and did restart apache, but I

> guess I still need to configure the module so it knows where to insert

> records. I am a developer, not a sys admin, sorry, but thanks for your

> help in advance.  I tried just adding the parameters to httpd.conf and

> restarting apache, it restarts with no errors, but I get timeouts when

> attempting to access my page.

> 

> 

> _______________________________________________

> 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

 

_______________________________________________

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


------=_NextPart_000_000E_01C81896.3E334E90
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:10.0pt;
	font-family:"Courier New";}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 77.95pt 1.0in 77.95pt;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Here is what I have on httpd.conf now where apachelog is the =
user,
password is the password and apachelogs in the database.&nbsp; I have =
flushed
the db and turned on LogSQLCreateTables.&nbsp; When I reload the config =
my
browser simply sits on connecting when I point it at my =
domain.<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLLoginInfo =
mysql://apachelog:password@localhost/apachelogs<o:p></o:p></span></font><=
/p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLSocketFile =
/var/run/mysqld/mysqld.sock<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLCreateTables On<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLMassVirtualHosting Off<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLMachineID kernel<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLPreserveFile =
/var/tmp/sql-preserve<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>I have the following parameters in my vhost file
/etc/apache2/sites-enabled/000-default<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
LogSQLTransferLogTable
access_mp3crib.com<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LogSQLScoreDomain
mp3crib.com<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>For the LogSQLPreserveFile I ran this command mysql&nbsp;- =
root&nbsp;-p&nbsp;mydbname&nbsp;&lt;&nbsp;/var/tmp/sql-preserve
to ensure it is in a writable directory and the file is writable.&nbsp; =
Not
exactly sure if the parameters in the vhost file are correct.&nbsp; My =
web server
still functions properly if I comment out the LogSQLLoginInfo and =
LogSQLPreserveFile
params in httpd.conf file and yes I did verify the password is correct =
for the
mysql user.&nbsp; I was hoping this was going to be easy, but I =
should&#8217;ve
known otherwise when I turned to Sid for the =
package.<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-----Original Message-----<br>
From: mod_log_sql-bounces-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org =
[mailto:mod_log_sql-bounces-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org]
On Behalf Of Peter<br>
Sent: Saturday, October 27, 2007 11:43 AM<br>
To: General mod_log_sql discussion<br>
Subject: Re: [Mod_log_sql] mod_log_sql help confgiuring on debian =
etch</span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Hi<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>It took me awhile to get it running on =
Etch.<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>You need to have log_sql and log_sql_mysql loaded. I created a =
user to<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>access my db with create rights so the tables would be created. =
This<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>seems to work better then creating the tables yourself. At least =
the<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>fields will be correct you can turn off LogSQLCreateTables =
later. You<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>also need to make sure you have mod_log_sql-preserve in a =
writable<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>directory. Check there for errors.<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Your http.conf is blank be default. I =
added:<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLLoginInfo =
mysql://loguser:username@localhost/apachelogs<o:p></o:p></span></font></p=
>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLDBParam socketfile =
/var/run/mysqld/mysqld.sock<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLCreateTables On<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLMassVirtualHosting Off<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>LogSQLMachineID web<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>In vhost setup I used:<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LogSQLTransferLogTable
access_vhost_name_com<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LogSQLScoreDomain =
vhost_name.com<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Good luck :) <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>On Sat, 2007-27-10 at 11:11 -0600, Chris =
wrote:<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; I'm trying to setup mod_log_sql to log my apache access log
entries in<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; a mysql 5 database. I have installed mod_log_sql version =
1.100
from<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; sid using aptitude install libapache2-mod-log-sql. =
<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; I then created the tables using a SQL file created by the
developer of<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; the package to create them for me. The documentation,
unfortunately,<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; it is not debian centric and is asking me to put things in =
my<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; httpd.conf file such as:<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt;&nbsp; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; Example: Use the MySQL database called =
&quot;apachelogs&quot;
running on<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; &quot;dbmachine.foo.com&quot;. Use username =
&quot;loguser&quot;
and password &quot;l0gg3r&quot; to<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; authenticate to the database. Permit the module create =
tables for
us. <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; LogSQLLoginInfo dbmachine.foo.com loguser l0gg3r =
<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; LogSQLDatabase apachelogs <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; LogSQLCreateTables on <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; If your database resides on localhost instead of another =
host,
specify<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; the MySQL server's socket file as follows: =
<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; LogSQLSocketFile /your/path/to/mysql.sock =
<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; If your database is listening on a port other than 3306, =
specify
the<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; correct TCP port as follows: <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; LogSQLTCPPort 1234<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt;&nbsp; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; There is no area to do this in httpd.conf really, in fact =
it is a<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; blank file since I am on apache2. Do I just add these =
directives
in<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; myself? Please advise, I am using the documentation located =
here:<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt;
http://www.outoforder.cc/projects/apache/mod_log_sql/docs/node4.html#SECT=
ION00042000000000000000<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; and my server is Etch based running MySQL 5 Apache 2 and =
yes, I
did<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; install the mod_log_sql from the unstable repo sid. Also I =
did
verify<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; the modules is in /etc/mods-enabled/ and did restart =
apache, but I<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; guess I still need to configure the module so it knows =
where to
insert<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; records. I am a developer, not a sys admin, sorry, but =
thanks for
your<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; help in advance.&nbsp; I tried just adding the parameters =
to
httpd.conf and<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; restarting apache, it restarts with no errors, but I get =
timeouts
when<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; attempting to access my page.<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; =
_______________________________________________<o:p></o:p></span></font><=
/p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; Download the latest version at
http://www.outoforder.cc/projects/apache/mod_log_sql/<o:p></o:p></span></=
font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; To unsubscribe send an e-mail to =
<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>&gt; =
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org<o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>_______________________________________________<o:p></o:p></span>=
</font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Download the latest version at
http://www.outoforder.cc/projects/apache/mod_log_sql/<o:p></o:p></span></=
font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>To unsubscribe send an e-mail to <o:p></o:p></span></font></p>

<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org<o:p></o:p></span></fo=
nt></p>

</div>

</body>

</html>

------=_NextPart_000_000E_01C81896.3E334E90--


--===============1686844187==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
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

--===============1686844187==--