mod_log_sql help confgiuring on debian etch
"Chris" <[email protected]> Sat, 27 Oct 2007 11:11:52 -0600
| Newsgroups | gmane.comp.apache.mod-log-sql |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
--===============0385015037==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0004_01C8188A.2D24A970"
This is a multi-part message in MIME format.
------=_NextPart_000_0004_01C8188A.2D24A970
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
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.
------=_NextPart_000_0004_01C8188A.2D24A970
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=3D"Content-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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><span class=3Dpostbody><font size=3D3 face=3D"Times =
New Roman"><span
style=3D'font-size:12.0pt'>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. =
</span></font></span><br>
<br>
<span class=3Dpostbody>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:<o:p></o:p></span></p>
<p class=3DMsoNormal><span class=3Dpostbody><font size=3D3 face=3D"Times =
New Roman"><span
style=3D'font-size:12.0pt'><o:p> </o:p></span></font></span></p>
<p class=3DMsoNormal><i><font size=3D3 face=3D"Times New Roman"><span
style=3D'font-size:12.0pt;font-style:italic'>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. <br>
<br>
LogSQLLoginInfo dbmachine.foo.com loguser l0gg3r <br>
<br>
LogSQLDatabase apachelogs <br>
<br>
LogSQLCreateTables on <br>
<br>
If your database resides on localhost instead of another host, specify =
the
MySQL server's socket file as follows: <br>
<br>
LogSQLSocketFile /your/path/to/mysql.sock <br>
<br>
If your database is listening on a port other than 3306, specify the =
correct
TCP port as follows: <br>
<br>
LogSQLTCPPort 1234<o:p></o:p></span></font></i></p>
<p class=3DMsoNormal><i><font size=3D3 face=3D"Times New Roman"><span
style=3D'font-size:12.0pt;font-style:italic'><o:p> </o:p></span></fo=
nt></i></p>
<p class=3DMsoNormal><span class=3Dpostbody><font size=3D3 face=3D"Times =
New Roman"><span
style=3D'font-size:12.0pt'>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: <a
href=3D"http://www.outoforder.cc/projects/apache/mod_log_sql/docs/node4.h=
tml#SECTION00042000000000000000"
target=3D"_blank">http://www.outoforder.cc/projects/apache/mod_log_sql/do=
cs/node4.html#SECTION00042000000000000000</a>
</span></font></span><br>
<span class=3Dpostbody>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.</span><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p=
>
</div>
</body>
</html>
------=_NextPart_000_0004_01C8188A.2D24A970--
--===============0385015037==
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
--===============0385015037==--