[pgpool-general: 1872] Re: pgpoolAdmin not displaying Node info

[Tony Neff]

rebuilding the templates_c directory got rid of the date related php errors, but I still can't get any Node info to display. 

I don't see any errors in the apache logs when clicking the Node button or loading Node status page. But I do see errors from the log button and the pgpool.conf settings page. 

On the status page, when I click on a log button I get the following error in the apache error_log

[Wed Jul 03 21:50:57 2013] [error] [client ::1] PHP Notice:  Undefined offset: 2 in /var/www/html/pgpoolAdmin-3.2.2/templates_c/2b624f64ab281dde67267c952c79a7a8c8b3c980.file.innerLog.tpl.php on line 64, referer: http://localhost/pgpoolAdmin-3.2.2/status.php

When I load the pgpool.conf settings page I get this error (in the watchdog section):

[Wed Jul 03 22:06:56 2013] [error] [client ::1] PHP Notice:  Undefined index: other_pgpool_hostname in /var/www/html/pgpoolAdmin-3.2.2/templates_c/7242e7c17a716778f84e7d5bb66ce9945282dda5.file.pgconfig.tpl.php on line 1584, referer: http://localhost/pgpoolAdmin-3.2.2/config.php



On Jul 2, 2013, at 6:24 PM, Nozomi Anzai wrote:

> Hi,
> 
>> I've been setting up a test for streaming replication failover:
>> 
>> I have pgpool, a primary database and a secondary database each running on separate servers
>> 
>> pgpool 3.2.2
>> postgres 9.2.1
>> CentOS 6.3
>> php 5.3.3
>> 
>> Streaming replication is working. 
>> 
>> But, I've had some trouble getting pgpoolAdmin to work.
>> 
>> first there was a problem related to an unset timezone (a php 5.1 issue?). After setting the timezone i my php.ini file I started getting this error:
>> 
>> [Tue Jul 02 16:47:02 2013] [error] [client ::1] PHP Notice:  Undefined offset: 2 in /var/www/html/admin-tool/templates_c/2b624f64ab281dde67267c952c79a7a8c8b3c980.file.innerLog.tpl.php on line 64, referer: http://localhost/admin-tool/status.php
>> 
>> As a temporary work around, I removed the date function from the footer copywrite notice
> 
> PgpoolAdmin uses the template libraries "Smarty", and Smarty saids this log
> message. Smarty compiles PHP sctipts and HTML templates and makes static
> pages into templates_c directory.
> I think changing timezone makes these pages invalid. To resolve this, you
> should remove templates_c/*, and Smarty will make new compiled pages with
> new timezone configuration.
> 
> 
>> pcp_node_info is working from the command line:
>> 
>> $  ./pcp_node_info 0 localhost 9898 postgres pgpoolAdmin 0
>> 10.0.204.51 5432 2 0.500000
>> $ ./pcp_node_info 0 localhost 9898 postgres pgpoolAdmin 1
>> 10.0.204.52 5432 2 0.500000
>> 
>> but I can't seem to get any node info or status through pgpoolAdmin. I checked the FAQ, but I do not have any errors in the apache error log.
>> I also have no problem connecting from my pgpool server to template1 on both database servers.
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> Videx, Inc. | 1105 NE Circle Blvd. | Corvallis, OR 97330 | (541) 738-5500
>> This email is intended only for the addressee(s) and may include material that is privileged, confidential, and protected from disclosure.  No contract is intended.  ©2013 Videx, Inc.
>> 
> 
> 
> -- 
> Nozomi Anzai
> SRA OSS, Inc. Japan
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general



Videx, Inc. | 1105 NE Circle Blvd. | Corvallis, OR 97330 | (541) 738-5500
This email is intended only for the addressee(s) and may include material that is privileged, confidential, and protected from disclosure.  No contract is intended.  ©2013 Videx, Inc.