View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000158 | Pgpool-II | Bug | public | 2015-12-02 04:27 | 2016-05-06 17:35 |
Reporter | pgdude | Assigned To | Muhammad Usama | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | resolved | Resolution | open | ||
Platform | linux | OS | Redhat | OS Version | 7 |
Product Version | |||||
Target Version | Fixed in Version | ||||
Summary | 0000158: pgpool web console gets pgpool.conf parameters incorrectly | ||||
Description | The format of the pgpool.conf file says: Whitespace may be used. Comments are introduced with "#" anywhere on a line. But if you move comments to the same line as the parameter, the entire line gets captured as that parameter when refreshing node info. in web console postgresql log: user=postgres # Health check user,db=template1 10.11.12.120(42163) FATAL: password authentication failed for user "postgres # Health check user" pgpool.conf file: health_check_user = 'postgres' # Health check user but if I change it to: health_check_user = 'postgres' # Health check user no more errors in postgresql log file | ||||
Steps To Reproduce | put comments on same line as health_check_user in pgpool.conf health_check_user = 'postgres' # Health check user open web console and press the "Node Info." button You will see these errors in postgresql log file: user=postgres # Health check user,db=template1 10.11.12.120(42163) FATAL: password authentication failed for user "postgres # Health check user" | ||||
Additional Information | Interestingly, by default, pgpool.conf has comments on next line after a parameter definition. This default format would never result in the problem I saw in web console. But I was trying to reduce the number of lines in pgpool.conf by starting comment on same line as parameter, and it works when running pgpool in HA mode (watchdog), but not with web console, which must be reading the pgpool.conf file differently, expecting comments on separate lines. | ||||
Tags | No tags attached. | ||||
|
I think this doen't occur now. I fixed this problem of pgpoolAdmin on the day this issue had been submitted. I added trimValue() function in common.php, so that pgpoolAdmin can get the parameter value itself from a line with '#' comment. http://git.postgresql.org/gitweb?p=pgpooladmin.git;a=commitdiff;h=2d73b1f89b489b4064c80f12ea8423ae096c142c |