Status update

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