Thread: Re: Logging Apache web server log information to Postgre

Re: Logging Apache web server log information to Postgre

From
"Keller, Sid"
Date:
That is the order that I start everything.  The web server and database are
on the same box.  Here are the contents of my pglogd.log

[Wed Feb 20 10:27:18 2002] Resuming normal operation. [0]
[Wed Feb 20 10:27:18 2002] Closed inherited file descriptiors: [3]
[Wed Feb 20 10:27:18 2002] Database connection [pglogd] opened. [0]
[Wed Feb 20 10:27:40 2002] FIFO Named Pipe [/tmp/.f.PGLOGD] opened. [1]
[Wed Feb 20 10:27:40 2002] Overflow file open for reading: [2]
[Wed Feb 20 10:27:40 2002] Overflow file open for writing: [3]
[Wed Feb 20 10:27:40 2002] Overflow file entries found queued: [0]
[Wed Feb 20 10:27:40 2002] FIFO End Of File received. [0]
[Wed Feb 20 10:27:40 2002] Normal Shutdown [0]
[Wed Feb 20 10:27:40 2002] Server State: errno: [9]
[Wed Feb 20 10:27:40 2002] Server State: iHaveEntry: [0]
[Wed Feb 20 10:27:40 2002] Server State: iHaveReadData: [0]
[Wed Feb 20 10:27:40 2002] Server State: iOverflowEntry: [0]
[Wed Feb 20 10:27:40 2002] Server State: iOverFlowQueued: [0]
[Wed Feb 20 10:27:40 2002] Server State: iOverFlowProcessed: [0]
[Wed Feb 20 10:27:40 2002] Server State: iBackendDown: [0]
[Wed Feb 20 10:27:40 2002] Server State: iBackendBusy: [0]

-----Original Message-----
From: Singer Wang [mailto:swang@cs.dal.ca]
Sent: Friday, February 22, 2002 6:17 AM
To: Keller, Sid
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Logging Apache web server log information to
Postgresql


On Thu, Feb 21, 2002 at 02:34:10PM -0600, Keller, Sid wrote:
> I was wondering if anyone has installed the pglogd program.  It is a
program
> that sends Apache web server log information to a Postgresql database.  I
> have successfully compiled it and have the other programs (Apache,
> Postgresql) working correctly.  However, when I start Apache after
starting
> the database and then pglogd, the pglogd daemon dies.  If anyone has this
> setup correctly and is willing to help, I can send you some details about
my
> setup.  Oh, my O/S is OpenBSD 3.0.
>
Hello......

I use it as well for my intranet site... the appropiate start order is..

start postgresql
start pglogd
start apache


--
Singer XJ Wang - swang@cs.dal.ca - ICQ: 201253
-------------------------------------------------------------------------
   "WAR stands for We Are Right!"