sorry, I haven't finished describing the second problem, early monday problem.... I inserted the problem description "inline".
-------- Original-Nachricht -------- Betreff: [Pgpool-general] problem with pg_connect and pid_file_name Datum: Mon, 09 Mar 2009 09:14:36 +0100 Von: Gerd König <[email protected]> An: [email protected] Hello, starting a new week with problems isn't that fine ;-) , but I got stuck at this point and wanted to ask for help.... Wwhile playing with pgpool I ran into a problem (obviously) at calling "@pg_connect"-function. If I click "Node status" in the menu there's only "please wait..." displayed in the innerHtml and nothing happens. If I comment the line "$conn = @pg_connect($conStr);" in common.php and print the connectionstring I can see that the parameters are fine. To validate it, I put this connectionstring in a test script like the following one, and it worked, called at the same server pgpool is running at..!?!?!=> <?php $connection = @pg_connect("host=dbhost01 port=5432 dbname=template1 user=postgres") or die ("error connecting to PostgreSQL --> " . pg_last_error($conn)); $result = pg_exec("SELECT * FROM pg_stat_activity "); $arr = pg_fetch_all_columns($result, 1); var_dump($arr); pg_close($connection); ?> There's no error in the apache errorlog and no entry in the postgresql.log. Where can I have a look at what's going on, is it possible to enable some debug output..?!?! -------------------------------------------------------- The second, a little bit mysterious, thing is: In pgpool.log I got the message " Undefined index: pid_file_name in /srv/www/htdocs/pgpoolAdmin/common.php on line 274 " The function "DoesPgpoolPidExist()" tries to read the parameter "pid_file_name" from the file "_PGPOOL2_CONFIG_FILE", which is set to "define('_PGPOOL2_CONFIG_FILE', '/opt/pgpoolII/etc/pgpool.conf');" But in pgpool.conf there's no entry called "pid_file_name"....?!??!? .....I'm working with pgpool 2.1 and pgpoolAdmin2.1Beta, yes, probably I should update to latest 2.2, but I think these are basic functions independant from pgpool version. thanks in advance...GERD... _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general -- /===============================\ | Gerd König | - Infrastruktur - | | TRANSPOREON GmbH | Pfarrer-Weiss-Weg 12 | DE - 89077 Ulm | | | Tel: +49 [0]731 16906 16 | Fax: +49 [0]731 16906 99 | Web: www.transporeon.com | \===============================/ Bleiben Sie auf dem Laufenden. Jetzt den Transporeon Newsletter abonnieren! http://www.transporeon.com/unternehmen_newsletter.shtml TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056 Geschäftsf.: Axel Busch, Peter Förster, Roland Hötzl, Marc-Oliver Simon _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
