[pgpool-general: 1872] Re: pgpoolAdmin not displaying Node info
tonyn at videx.com
Thu Jul 4 06:47:56 JST 2013
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:
>> 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
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.
More information about the pgpool-general