[X2Go-User] X2go server and pgpool

[David Barron]

Yes, I've seen that.  Unfortunately, it doesn't give any suggestion on what to do about it.  Extensive googling doesn't give any better explanation.

I have done some testing.  When I connect to pgpool (port 9999) on one postgres host and create a table, I can go to the other host and connect to pgpool and the table is there.  That is, as far as I know, the expected behavior for pgpool.


-----Original Message-----
From: x2go-user <x2go-user-bounces at lists.x2go.org> On Behalf Of Oleksandr Shneyder
Sent: Friday, September 28, 2018 3:08 AM
To: x2go-user at lists.x2go.org
Subject: Re: [X2Go-User] X2go server and pgpool

Hi David,

it doesn't look like X2Go related issue to me. It seems that you have problems with your DB configuration. Check this:

http://www.pgpool.net/mantisbt/view.php?id=126

best regards,
Alex


Am 25.09.2018 um 15:24 schrieb David Barron:
> I'm trying to get x2go server running in a high availability 
> environment, which includes using pgpool for replication etc.
> 
>  
> 
> I've got my /etc/x2go/x2gosql/sql file setup this way:
> 
>  
> 
> backend=postgres
> 
> host=<hostname>
> 
> port=9999
> 
>  
> 
> When I try x2godbadmin -createdb I get a pgpool error I don't understand:
> 
>  
> 
> DBI
> connect('dbname=x2go_sessions;host=<hostname>;port=9999;sslmode=disabl
> e','postgres',.) failed :ERROR: unable to read message kind
> 
> DETAIL: kind does not match between master(53) slot[1] (45) at 
> /sbin/x2godbadmin line 530.
> 
> Backend=postgres at /sbin/x2godbadmin line 530.
> 
>  
> 
> When I connect with pgAdmin I can see that the x2godbuser has been 
> created and the x2go_sessions database has been created.
> 
>  
> 
> If I try to connect to the database I get this error
> 
> cid:image002.png at 01D44F61.9E2EB470
> 
>  
> 
>  
> 
> If I change the port= to 5432 (the default postgresql port) the 
> command works fine.
> 
>  
> 
> So, I guess my first question is, is this sort of setup supported?
> 
> If so, is there any documentation or suggestions?
> 
>  
> 
> Thanks in advance.
> 
>  
> 
>  
> 
>  
> 
> /architects of vision and strategy for business intelligence/
> 
> *David Barron*
> Senior Consultant
> 
> Zencos Consulting: david.barron at zencos.com
> 
> 	
> 
> www.zencos.com <http://www.zencos.com/>
> 
> work:
> 
> 	
> 
> 919-480-2761
> 
> mobile:
> 
> 	
> 
> 919-995-2356
> 
> fax:
> 
> 	
> 
> 919-287-2335
> 
> The information in this e-mail and any attached files is confidential.
> It is intended solely for the use of the addressee. Any unauthorized 
> disclosure or use is prohibited. If you are not the intended recipient 
> of the message, please notify the sender immediately and do not 
> disclose the contents to any other person, use it for any purpose, or 
> store or copy the information in any medium. The views of the author 
> may not necessarily reflect those of the company.
> 
>  
> 
>  
> 
> 
> 
> _______________________________________________
> x2go-user mailing list
> x2go-user at lists.x2go.org
> https://lists.x2go.org/listinfo/x2go-user
> 


--
-----------------------------------------------------------
Oleksandr Shneyder        | Email: o.shneyder at phoca-gmbh.de
phoca GmbH                | Tel. : 0911 - 14870374 0
Harzstr. 4                | Fax. : 0911 - 14870374 9
D-90491 Nürnberg          | Mobil: 0163 - 49 64 461

Geschäftsführung:
Dipl.-Inf. Oleksandr Shneyder

Amtsgericht München | http://www.phoca-gmbh.de
HRB 196 658         | http://www.x2go.org
USt-IdNr.: DE281977973
-----------------------------------------------------------