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

Status update

From: "Andreas Grabmller" <webmaster(at)letzplay(dot)de>
To: pgsql-www(at)postgresql(dot)org
Subject: Status update
Date: 2003-08-30 13:21:58
Message-ID: 20030830132158.18062.qmail@osiris.gamecrashnet.de (view raw or flat)
Thread:
Lists: pgsql-www
Hi,

I think the new multilingual website system is working now (well, the technical side works, I have not added all pages and files yet). You can find it on http://wwwdevel2.postgresql.org

It would be good to get some comments / suggestions on the code now... you can find it at /home/www.postgresql.com/andreas/public_html or view it on the web at http://svn.gamecrashnet.de/repos/pgsql_org/

Some comments on how the system works:

Every request goes through some RewriteRules in the .htaccess file. If the files exists in the cache directory, this one is delivered (for performance reasons). If the is for a file in the /admin, /layout or the /files directory, nothing happens. Every other request gets redirected to the script /system/handler.php (or /system/handleform.php which handles every dynamic request) where the pages get built and delivered dynamically.

There is a script in the /tools directory called "rebuildcache" written in PHP, this can rebuild parts or or the whole cache directory. just call it without arguments to get the help. The cache directory contains all static pages and elements, so this can be used to mirror the whole website (all dynamic contents get linked to postgresql.org statically).

Is there a problem with this? Or is something missing?

Mit freundlichen Grüßen
Andreas Grabmüller

--
LetzPlay.de
| Freemail:       http://www.letzplay.de/mail
| Forenhosting: http://www.letzplay.de/foren
>From pgsql-www-owner(at)postgresql(dot)org  Sat Aug 30 11:36:10 2003
X-Original-To: pgsql-www-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id CEFA8D1B8C5
	for <pgsql-www-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Sat, 30 Aug 2003 14:36:08 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
 by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024)
 with ESMTP id 36338-06
 for <pgsql-www-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
 Sat, 30 Aug 2003 11:35:59 -0300 (ADT)
Received: from www.postgresql.com (unknown [64.117.225.209])
	by svr1.postgresql.org (Postfix) with ESMTP id BF9F5D1B9BE
	for <pgsql-www(at)postgresql(dot)org>; Sat, 30 Aug 2003 11:35:52 -0300 (ADT)
Received: from emo.org.tr (unknown [195.142.105.9])
	by www.postgresql.com (Postfix) with ESMTP id DE69DCF836D
	for <pgsql-www(at)postgresql(dot)org>; Sat, 30 Aug 2003 05:05:52 -0300 (ADT)
Received: from localhost (emo.org.tr [127.0.0.1])
	by emo.org.tr (8.11.6/8.11.6) with ESMTP id h7U84L128418;
	Sat, 30 Aug 2003 11:04:22 +0300
Date: Sat, 30 Aug 2003 11:04:21 +0300 (EEST)
From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
X-X-Sender: devrim2(at)emo(dot)org(dot)tr
To: PostgreSQL WWW Mailing List <pgsql-www(at)postgresql(dot)org>
Cc: Marc Fournier <scrappy(at)hub(dot)org>
Subject: Error accessing portal database on jupiter
Message-ID: <Pine(dot)LNX(dot)4(dot)44(dot)0308301101550(dot)28154-100000(at)emo(dot)org(dot)tr>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/35
X-Sequence-Number: 2460


Hi,

I think we have a problem while accessing database servers on jupiter. I 
think this occured after the redirection of postgresql.com to pgsql.com:

-bash-2.05b$ psql 186_portal -h db.svr2.postgresql.org -U portal
psql: FATAL 1:  No pg_hba.conf entry for host 64.117.225.209, user portal, 
database 186_portal

And here is the output from admin interface:

Warning: pg_pconnect(): Unable to connect to PostgreSQL server: could not 
connect to server: Operation timed out Is the server running on host 
jupiter.hub.org and accepting TCP/IP connections on port 5432? . in 
...

Could some please fix it?

Regards,
-- 
Devrim GUNDUZ
devrim(at)gunduz(dot)org				devrim(dot)gunduz(at)linux(dot)org(dot)tr 
			http://www.tdmsoft.com
			http://www.gunduz.org


Responses

pgsql-www by date

Next:From: Justin CliftDate: 2003-08-30 15:48:43
Subject: Re: Status update
Previous:From: Marc G. FournierDate: 2003-08-30 08:36:33
Subject: Re: Error accessing portal database on jupiter

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