can apache log to MySQL ?
hello :-) is there anybody here doing that ? i.e., piping apache logs directly to MySQL ? also, can anyone suggest to me any app w/c converts and puts apache logs in MySQL tables ? i actually tried apachedb from freshmeat already but i get an "out of memory!" error whenever i try feeding it 10MB apache logs. thanks in advance, chadi
RE: Installing Debian on a RAIDed partition
The more up-to-date infos are: root can be put on raid but /boot must be on a non-raid. Exception is /boot can be on RAID-1 with some patches to lilo which are made by RedHat and I think are in the lilo found in woody. the root-RAID-HOWTO is a bit outdated, or at least was a month ago, when I installed a system on RAID (root as well). Look at raid-HOWTO for up-to-date infos. I installed a system with every filesystem of it on RAID-1 except for /tmp which is not preserved for next boot in any case, and /boot since lilo in debian did not support RAID-1 booting at that time. Use RAID 0.90 (you can convert older version RAID arrays), and raidtools2 package. The raidtools2 package also contains the mentioned RAID-HOWTO. I set everything up as mentioned in it, and it worked without problem. Booting did not work due to other problems (it did not want to boot even the stock install, when RAID was nowhere in sight yet, some problem with SCSI settings I think, since I have the same problem with another SCSI machine. It is using Adaptec 2940 UW). These problems don't have any relation with RAID setup. Just put /boot in the first 1024 cylinder. And of course read the whole HOWTO before you do anything to know what you will be doing, or else you will be into some partition reorganization. Preferably use a spare hard-drive for initial install. The best would be of course to put a RAID0.90-supporting kernel on the boot-disks, so that debian could be installed straight on raid without a problem. The kernel patches for RAID 0.90 can be found at http://people.redhat.com/mingo Regards, Robert Varga On Tue, 9 May 2000, John Gonzalez/netMDC admin wrote: > On Tue, 9 May 2000, Robert H. Clugston wrote: > > >Whatever.. here's the instructions on how to load a raid partition as > >root... > > > >http://www.linux.org/help/ldp/howto/Root-RAID-HOWTO.html > > > > > >Yes. You cannot boot to a raid partition. One, lilo cant read a RAID > >partition, and the 'raid' drivers havent been loaded yet. You will either > >need to have the / or more specifically /boot be on a NON raid partition > >(ie. floppy) or compile special tools to boot raid partitions. Someone has > >developed info on that, but the address escapes me now, search the web and > >it should turn up. > > > >The RAID howto|mini howto should be of assistance. > > Whatever...??? > > What part of my statement does not make sense to you? > > How about: > > "or compile special tools to boot raid partitions. Someone has > developed info on that, but the address escapes me now, search the web > and it should turn up." > > In other words. It's not possible to simply compile in raid support and > setup the device and then boot off of it right out of the box. It takes > work, kernel patches, kernel support, among other things. > > ___ _ __ _ > __ /___ ___ /__ John Gonzalez/Net.Tech > __ __ \ __ \ __/_ __ `__ \/ __ /_ ___/ MDC Computers/netMDC! > _ / / / `__/ /_ / / / / / / /_/ / / /__ (505)437-7600/fax-437-3052 > /_/ /_/\___/\__/ /_/ /_/ /_/\__,_/ \___/ http://www.netmdc.com > [-[system info]---] > 12:10pm up 105 days, 19:07, 6 users, load average: 0.27, 0.48, 0.38 > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED] > >
Re: can apache log to MySQL ?
> is there anybody here doing that ? > i.e., piping apache logs directly to MySQL ? also, can anyone suggest > to me any app w/c converts > and puts apache logs in MySQL tables ? Well, debian's got it all covered: Package: libapache-dbilogger-perl Version: 0.93-1 Priority: optional Section: interpreters Maintainer: Michael Alan Dorman <[EMAIL PROTECTED]> Depends: perl5, libapache-mod-perl, libdbi-perl, libapache-dbi-perl, libtimedate-perl Architecture: all Filename: dists/frozen/main/binary-i386/interpreters/libapache-dbilogger-perl_0.93-1.deb Size: 11588 MD5sum: 5bfe254bb58d8880a14cebe4a81b96d1 Description: Tracks what's being transferred in a DBI database This module tracks what's being transfered by the Apache web server in a SQL database (everything with a DBI/DBD driver). This allows to get statistics (of almost everything) without having to parse the log files (like the Apache::Traffic module, just in a "real" database, and with a lot more logged information). installed-size: 30 btw, why do you choose mysql? it ain't free, it ain't any good try Oracle, Sybase, PostgresSQl, they are ok, and Postgres is free regards, Dariush Pietrzak
Re: can apache log to MySQL ?
> Package: libapache-dbilogger-perl > Version: 0.93-1 > Priority: optional > Section: interpreters > Maintainer: Michael Alan Dorman <[EMAIL PROTECTED]> > Depends: perl5, libapache-mod-perl, libdbi-perl, libapache-dbi-perl, > libtimedate-perl > Architecture: all > Filename: > dists/frozen/main/binary-i386/interpreters/libapache-dbilogger-perl_0.93-1.deb > Size: 11588 > MD5sum: 5bfe254bb58d8880a14cebe4a81b96d1 > Description: Tracks what's being transferred in a DBI database > This module tracks what's being transfered by the Apache web server > in a SQL database (everything with a DBI/DBD driver). This allows to > get statistics (of almost everything) without having to parse the log > files (like the Apache::Traffic module, just in a "real" database, > and with a lot more logged information). > installed-size: 30 > > > btw, why do you choose mysql? it ain't free, it ain't any good > try Oracle, Sybase, PostgresSQl, > they are ok, and Postgres is free > > regards, > Dariush Pietrzak this is great help Dariush, thanks a lot :-) the reason why i chose MySQL is because its the first RDBMS i have ever tried :-) ... i will try PostgreSQL someday. were not considering oracle yet because a small group as ours cant afford it :-) thanks again, chad
Re: can apache log to MySQL ?
On Wed, 10 May 2000, Chad A. Adlawan wrote: > is there anybody here doing that ? i.e., piping apache logs directly to > MySQL ? also, can anyone suggest to me any app w/c converts and puts apache > logs in MySQL tables ? i actually tried apachedb from freshmeat already but > i get an "out of memory!" error whenever i try feeding it 10MB apache logs. iirc there is a module floating somewhere... search harder, you might even have luck. -- [-] there's a devil waiting outside your door
Re: can apache log to MySQL ?
> > is there anybody here doing that ? > > i.e., piping apache logs directly to MySQL ? also, can anyone suggest > > to me any app w/c converts > > and puts apache logs in MySQL tables ? > Well, debian's got it all covered: > > Package: libapache-dbilogger-perl > btw, why do you choose mysql? it ain't free, it ain't any good > try Oracle, Sybase, PostgresSQl, > they are ok, and Postgres is free Also consider InterBase. The new version's source will go open 'til July, is is a competitor of Oracle and Sybase and it's free. www.interbase.com www.interbase2000.org There's a very good Perl module for direct link with InterBase: www.karwin.com/IBPerl Also there you can find information about connection to Interbase with DBI. Damyan Ivanov Get IBPerl from http://ibperl.search.bg/
Re: dns server
Hi Chad, On Tue, 9 May 2000, t s a d i wrote: > i once set up a web/mail virtual hosting box for a friend who owns a small > ISP ... i put webmin 0.71 (i think, that was back feb 1999) in there and its > still perfectly healthy as of now (she never upgraded or applied patches to > it) > ... BTW, i enabled SSL on it, and it can only be accessed on https :-) I think he should really make an upgrade to 0.79. There are much features that adress delegated administration now - you can limit almost any aspect of the system a user can see and edit. This adresses sendmail, users and groups, dns (user jdoe can only administer jdoe.com) and much more. Torsten -- Media Online Internet Services & Marketing GmbH Torsten Krueger [EMAIL PROTECTED] fon: 49-231-5575100fax: 49-231-55751098 Ruhrallee 39 D-44137 Dortmund
raid
Hello, I'd like to configure raid 1 using the frozen 2.2 with a Mylex raid card (acceleraid 150). Do I need the raid-1 kernel module? Also, do I need the raidtools and raidtools2 packages? Thanks in advance. -FRK Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Re: can apache log to MySQL ?
At 11:36 AM 5/10/00 +0200, Dariush Pietrzak wrote: >btw, why do you choose mysql? it ain't free, it ain't any good >try Oracle, Sybase, PostgresSQl, >they are ok, and Postgres is free MySQL is faster and I believe easier. I doubt he would need transactions just to log Web stats. +---+ |-=I T ' S P R I N C I P L E T H A T C O U N T S=- | |=- -=ALAN KEYES FOR PRESIDENT=- -=| | Balanced Budgets Personal Freedoms Morality Lower Tax | |=-- http://www.Keyes2000.com. --=| ++
Re: can apache log to MySQL ?
"Chad A. Adlawan" wrote: >the reason why i chose MySQL is because its the first RDBMS i have ever > tried :-) ... i will try PostgreSQL someday. were not considering oracle > yet because a small group as ours cant afford it :-) > Postgres seems very strong on the backend, but it needs some interface work and a few more modules/routines built around it... I'm still using it, though, and without performance complaint. --d
