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=disable','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@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@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.
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=disable’,’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@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@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@lists.x2go.org https://lists.x2go.org/listinfo/x2go-user
--
Oleksandr Shneyder | Email: o.shneyder@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
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@lists.x2go.org> On Behalf Of Oleksandr Shneyder Sent: Friday, September 28, 2018 3:08 AM To: x2go-user@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@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@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@lists.x2go.org https://lists.x2go.org/listinfo/x2go-user
--
Oleksandr Shneyder | Email: o.shneyder@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
-
David Barron -
Oleksandr Shneyder