Re: Apache::DBILogger - developers wanted!
On Mon, Feb 19, 2001 at 03:23:10AM -0800, Ask Bjoern Hansen wrote: > Hi, > > I had a volunteer to help out maintaining Apache::DBILogger (Jens > Kristian Soegaard - thanks!) so I finally got around to put it into > sourceforge instead of just in my own local repository. > > I think that I have found most of the bug reports and patches I've > received and put them into sourceforge's bug and patch systems. > > Anyway, there's a billion interesting things that could be cool to > do with the package that could make it really useful. If you want to > help out, please send a mail to [EMAIL PROTECTED] > > http://dbilogger.sourceforge.net/ > > :-) FYI, I took a quick look at the docs: : LOCKING ISSUES : : MySQL 'read locks' the table when you do a select. On a big table (like : a large httpdlog) this might take a while, where your httpds can't : insert new logentries, which will make them 'hang' until the select is : done. : : One way to work around this is to create another table (f.x. : requests_insert) and get the httpd's to insert to this table. Another useful approach would be to use 'insert DELAYED ...'. And another point worth noting is that 'select SQL_BUFFER_RESULT ...' can be used to get the mysqld to buffer the results on the server ASAP then release the read lock before sending to the (possibly slow) client. Tim.
Apache::DBILogger - developers wanted!
Hi, I had a volunteer to help out maintaining Apache::DBILogger (Jens Kristian Soegaard - thanks!) so I finally got around to put it into sourceforge instead of just in my own local repository. I think that I have found most of the bug reports and patches I've received and put them into sourceforge's bug and patch systems. Anyway, there's a billion interesting things that could be cool to do with the package that could make it really useful. If you want to help out, please send a mail to [EMAIL PROTECTED] http://dbilogger.sourceforge.net/ :-) - ask -- ask bjoern hansen - <http://ask.netcetera.dk/> more than 70M impressions per day, <http://valueclick.com>
Re: SQL log analyzer for Apache::DBILogger
On Tue, 6 Feb 2001, T.J. Mather wrote: > I have a script that reads the logs from the database and dumps it out > to a flat file in the standard format Apache uses when writing > access_log, then I run a program called webalizer on it. I actually > don't use Apache::DBILogger, but the database table is similar to the > table generated by Apache::DBILogger. I'd thought of doing that or modifying webalizer to work off the SQL tables. It seems to me like there's so much more possible with storing summary information in the database that's periodically refreshed and avoiding HTML generation except when the user requests it. I'm going to look at the code Ask recommended today. -- Those who cannot remember the past are doomed to buy Microsoft products.
Apache::DBILogger
I have set this up with our Oracle Database, but I am not getting anything in the database nor am I getting any errors. Everything still seems to log to the log files? If errors are being generated, where would I find them? Any way to trace through and see what is happening? -- C Wayne Huling <[EMAIL PROTECTED]>
Re: SQL log analyzer for Apache::DBILogger
On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote: > Sometime in the next month I need to embark on a log analyzer for the logs > we've been accumulating for many moons via Apache::DBILogger. Has anyone > made any effort to do such a thing already? I've dug around the web for a > while and come up with zilch. I have a script that reads the logs from the database and dumps it out to a flat file in the standard format Apache uses when writing access_log, then I run a program called webalizer on it. I actually don't use Apache::DBILogger, but the database table is similar to the table generated by Apache::DBILogger. _ T.J. Mather http://tjmather.com http://cpan2.org/ New CPAN Search Engine http://www.anidea.com/ Digital Asset Management http://www.theinnkeeper.com/Bed and Breakfast Directory
Re: SQL log analyzer for Apache::DBILogger
On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote: > Sometime in the next month I need to embark on a log analyzer for the logs > we've been accumulating for many moons via Apache::DBILogger. Has anyone > made any effort to do such a thing already? I've dug around the web for a > while and come up with zilch. the code is impressively gross, but check the "bin" directory in the Apache::DBILogger tar file. :) - ask (who has version 0.94 in the works on ~30th month :-/ ) -- ask bjoern hansen - <http://ask.netcetera.dk/>
Re: SQL log analyzer for Apache::DBILogger
On Mon, 5 Feb 2001, G.W. Haywood wrote: > On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote: > > > Sometime in the next month I need to embark on a log analyzer for the logs > > we've been accumulating for many moons via Apache::DBILogger. Has anyone > > made any effort to do such a thing already? I've dug around the web for a > > while and come up with zilch. > > There are certainly such things about, and you might like to have a > look at the thread "How to really bang on a script?" about the end of > October 2000. I found the thread ( http://forum.swarthmore.edu/epigone/modperl/binzhimwah ) and there was the mention of a log-related program called Daquiri. This is also mentioned at http://perl.apache.org/guide/download.html#Daquiri_yet_another_webserver . But none of that seems to have anything to do with log analysis. I'm trying to generate the information to keep the marketing types happy - page hits per day and such. -- Those who cannot remember the past are doomed to buy Microsoft products.
Re: SQL log analyzer for Apache::DBILogger
Hi there, On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote: > Sometime in the next month I need to embark on a log analyzer for the logs > we've been accumulating for many moons via Apache::DBILogger. Has anyone > made any effort to do such a thing already? I've dug around the web for a > while and come up with zilch. There are certainly such things about, and you might like to have a look at the thread "How to really bang on a script?" about the end of October 2000. 73, Ged.
SQL log analyzer for Apache::DBILogger
Sometime in the next month I need to embark on a log analyzer for the logs we've been accumulating for many moons via Apache::DBILogger. Has anyone made any effort to do such a thing already? I've dug around the web for a while and come up with zilch. -- Those who cannot remember the past are doomed to buy Microsoft products.
Problems with Apache::DBILogger 0.93
Hello mod_perl-professionals, I have tried to install the module Apache::DBILogger 0.93. Installation worked fine, after installing DBI and Date::Format, but it does not write anything in the MySQL-DB. I found the following error-msg in the httpd.error_log: DBI->connect failed: Keine Zugriffsberechtigung für Benutzer: 'club@localhost' [MOn Jul 17 22:53:35 2000] [error] Apache::DBILogger could not connect to DBI:mysql:httpdlog I modified the grant table "db" ... DBD::mysql::st execute failed: Unbekanntes Tabellenfeld 'usertrack' in field [Mon Jul 17 22:56:40 2000] [error] Apache::DBILogger had problemds executing query ... This was becaus of an missing field in the SQL-Structur-Dump in the Readme-File of the Tarball, I added the field .. Since then, no further error-messages appear in the logfile, tough nothing is written into the DB. Can anybody help me or give me a hint? SuSE-Linux 6.3, Apache 1.3.9, mod_perl 1.2.2 httpd.conf: PerlModule Apache::DBI DBI Apache::DBILogger PerlLogHandler Apache::DBILogger PerlSetVar DBILogger_data_source DBI:mysql:httpdlog PerlSetVar DBILogger_username club PerlSetVar DBILogger_password * thx Tom www.webmasters.at - Webmasters Internet Club AustriaCommunity für Webmaster und solche, die es noch werden wollen!Infos: [EMAIL PROTECTED] ICQ:14162173
Problems with Apache::DBILogger 0.93
Hello mod_perl-professionals, I have tried to install the module Apache::DBILogger 0.93. Installation worked fine, after installing DBI and Date::Format, but it does not write anything in the MySQL-DB. I found the following error-msg in the httpd.error_log: DBI->connect failed: Keine Zugriffsberechtigung für Benutzer: 'club@localhost' [MOn Jul 17 22:53:35 2000] [error] Apache::DBILogger could not connect to DBI:mysql:httpdlog I modified the grant table "db" ... DBD::mysql::st execute failed: Unbekanntes Tabellenfeld 'usertrack' in field [Mon Jul 17 22:56:40 2000] [error] Apache::DBILogger had problemds executing query ... This was becaus of an missing field in the SQL-Structur-Dump in the Readme-File of the Tarball, I added the field .. Since then, no further error-messages appear in the logfile, tough nothing is written into the DB. Can anybody help me or give me a hint? thx Tom www.webmasters.at - Webmasters Internet Club AustriaCommunity für Webmaster und solche, die es noch werden wollen!Infos: [EMAIL PROTECTED] ICQ:14162173
