Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Apache working with MySQL
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
ARC2300
Apprentice
Apprentice


Joined: 30 Mar 2003
Posts: 265

PostPosted: Fri Jun 06, 2003 7:03 pm    Post subject: Apache working with MySQL Reply with quote

Okay. . .I've got a nice little Apache webserver running, and it has a nice large file name access_log.

Now, just out of curiousity, is there any way I can get Apache to use MySQL to put all the access_log stuff into a db so it's easier to read?? I've been searching the forums, but everything regarding MySQL and Apache also includes PHP (which has already been done and works great).

TIA
Back to top
View user's profile Send private message
beandog
Bodhisattva
Bodhisattva


Joined: 04 May 2003
Posts: 2072
Location: /usa/utah

PostPosted: Fri Jun 06, 2003 8:15 pm    Post subject: Reply with quote

Woudlnt it take longer to do an sql update to every single change in the apache logs rather than append it to a huge textfile?
_________________
If it ain't broke, tweak it. dvds | blurays | blog | wiki
Back to top
View user's profile Send private message
ARC2300
Apprentice
Apprentice


Joined: 30 Mar 2003
Posts: 265

PostPosted: Fri Jun 06, 2003 9:48 pm    Post subject: Reply with quote

No clue. That's why I was wondering about something like this.

Doesn't seem to slowdown PHPBB any. :-? And it's not like this is going to be a huge, huge, huge website, either. It's just something for my friends to visit and hang out.
Back to top
View user's profile Send private message
darktux
Veteran
Veteran


Joined: 16 Nov 2002
Posts: 1086
Location: Coimbra, Portugal

PostPosted: Sat Jun 07, 2003 7:59 am    Post subject: Reply with quote

http://modules.apache.org/search?id=339

Quote:

Gives Apache the capability of logging access-log entries to a MySQL database. Perfect for web clusters and for SQL flexibility.

_________________
Lego my ego, and I'll lego your knowledge

www.tuxslare.org - My reborn website :P
Back to top
View user's profile Send private message
slartibartfasz
Veteran
Veteran


Joined: 29 Oct 2002
Posts: 1462
Location: Vienna, Austria

PostPosted: Sat Jun 07, 2003 8:02 am    Post subject: Reply with quote

perhaps mod_log_sql is something for u...

[darktux was faster....]
_________________
To an engineer the glass is neither half full, nor half empty - it is just twice as big as it needs to be.
Back to top
View user's profile Send private message
ARC2300
Apprentice
Apprentice


Joined: 30 Mar 2003
Posts: 265

PostPosted: Sat Jun 07, 2003 2:45 pm    Post subject: Reply with quote

Ah, thank you, thank you.

:D I'm sure I can figure out the rest.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum