View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000276pgpoolAdminBugpublic2016-12-29 17:322017-08-29 09:43
Reporteramitkindia Assigned Topengbo  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionopen 
PlatformLinuxOSCentOS 7OS Version7.3.1611
Summary0000276: superuser: unknown (Connection error) in pgpoolAdmin
DescriptionProblem with pgpoolAdmin. Even after login as "postgres" user which is also superuser, I see following after login: superuser: unknown (Connection error)
Steps To ReproduceI see following query returns correct output:
# psql -h 172.21.4.222 -p 5432 -U postgres -W template1 -c "SELECT usesuper FROM pg_user WHERE usename = 'postgres'"
Password for user postgres:
 usesuper
----------
 t
(1 row)

Here 172.21.4.222 is the pgpool IP running on port 5432.

And, my pg_hba.conf has following entries with respect to pgpool:
host all all 172.21.4.222/32 trust
Additional InformationPgPoolAdmin Version : 3.5.1
PgPool Version : 3.5.5
PostgreSQL Version : 9.6.1
TagsNo tags attached.

Activities

amitkindia

2016-12-29 18:18

reporter   ~0001274

Also, under "Backend Info"->"Node Info" other options apart from "Disconnect" and "Promote" are disabled. Attaching the screenshot.
pgpoolAdmin_status.png (141,765 bytes)   
pgpoolAdmin_status.png (141,765 bytes)   

amitkindia

2017-01-12 16:15

reporter   ~0001291

Any updates on this??

pengbo

2017-02-20 10:17

developer   ~0001349

I fixed it. Could you try the attached patch?

pengbo

2017-02-20 10:22

developer  

diff (408 bytes)    


 diff (408 bytes)   
			




	














	

		
		

	
		

	

		

						Issue History		

		

			
							
		

	

	

	

	

	

		
			

				
					Date Modified				
				
					Username				
				
					Field				
				
					Change				
			

		
	
		
				

				
					2016-12-29 17:32				
				
					amitkindia				
				
					New Issue				
				
									
			

				

				
					2016-12-29 18:18				
				
					amitkindia				
				
					File Added: pgpoolAdmin_status.png				
				
									
			

				

				
					2016-12-29 18:18				
				
					amitkindia				
				
					Note Added: 0001274				
				
									
			

				

				
					2017-01-06 09:45				
				
					t-ishii				
				
					Assigned To				
				
					 => pengbo				
			

				

				
					2017-01-06 09:45				
				
					t-ishii				
				
					Status				
				
					new => assigned				
			

				

				
					2017-01-12 16:15				
				
					amitkindia				
				
					Note Added: 0001291				
				
									
			

				

				
					2017-02-20 10:17				
				
					pengbo				
				
					Note Added: 0001349				
				
									
			

				

				
					2017-02-20 10:22				
				
					pengbo				
				
					File Added: diff				
				
									
			

				

				
					2017-08-29 09:43				
				
					pengbo				
				
					Status				
				
					assigned => closed