Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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!"

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group