#1  
Old 27th November 2007, 17:25
Mosquito Mosquito is offline
Member
 
Join Date: Nov 2006
Posts: 85
Thanks: 5
Thanked 6 Times in 5 Posts
Default Apache Logs to MySQL

I have found a couple different ways to move apache logs to MySQL. I am thinking about doing this for a variety of reasons, but before I move ahead and do this I have a couple questions -

1.) Would ISPConfig work without changes if Apache logs were moved to the database instead of the current log files?
2.) I have a dedicated database server (quiet fast) and several of the tutorials I've looked at set up a failover in case the connection to the DB fails - this way apache doesn't die without the database. Other than worrying about the database not being available, are there other issues I should consider when deciding to move to a database to store these logs?
3.) Has anyone done this, and if so what was your experience?
Reply With Quote
Sponsored Links
  #2  
Old 28th November 2007, 08:53
Ben Ben is offline
Moderator
 
Join Date: Jul 2006
Posts: 1,029
Thanks: 7
Thanked 62 Times in 56 Posts
Default

1.) I guess several things won't work anymore e.g. webalizer etc. and the stats stuff of ispconfig, cause it can not access the files anymore.
Reply With Quote
  #3  
Old 28th November 2007, 16:14
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,722 Times in 2,563 Posts
 
Default

Quote:
Originally Posted by Mosquito
1.) Would ISPConfig work without changes if Apache logs were moved to the database instead of the current log files?
No.

Quote:
Originally Posted by Mosquito
2.) I have a dedicated database server (quiet fast) and several of the tutorials I've looked at set up a failover in case the connection to the DB fails - this way apache doesn't die without the database. Other than worrying about the database not being available, are there other issues I should consider when deciding to move to a database to store these logs?
3.) Has anyone done this, and if so what was your experience?
I haven't tried this, but if you have a high-traffic web site, and each request will be logged to a MySQL database, then your server's load will increase dramatically.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Apache won't start: "Too many files error"? bpmee Server Operation 4 31st July 2007 13:37
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
Problem with the installation of Dokeos (LMS) in ISPConfig jofranco General 4 28th April 2006 00:45
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04
MySQL 5.0 and Apache 2.0.xx Lil'Brudder General 2 11th November 2005 01:08


All times are GMT +2. The time now is 03:55.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.