Re: Logging Apache web server log information to Postgre

From: "Keller, Sid" <apsek(at)techmail(dot)admin(dot)ttu(dot)edu>
To: 'Singer Wang' <swang(at)cs(dot)dal(dot)ca>, "Keller, Sid" <apsek(at)techmail(dot)admin(dot)ttu(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Logging Apache web server log information to Postgre
Date: 2002-02-22 13:53:18
Message-ID: EB14F3BB8D31184D902B2B6209A1F8721B3503@arion
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)cs(dot)dal(dot)ca]
Sent: Friday, February 22, 2002 6:17 AM
To: Keller, Sid
Cc: pgsql-novice(at)postgresql(dot)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(at)cs(dot)dal(dot)ca - ICQ: 201253
-------------------------------------------------------------------------
"WAR stands for We Are Right!"

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-02-22 17:15:23 Re: Nu-B\psql:Command Recall,Repeat?
Previous Message Singer Wang 2002-02-22 12:17:19 Re: Logging Apache web server log information to Postgresql