[X2Go-User] X2go server and pgpool

Discussion:

David Barron

2018-09-25 13:24:09 UTC

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:***@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: ***@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.

Oleksandr Shneyder

2018-09-28 07:08:10 UTC

Permalink

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

Im trying to get x2go server running in a high availability
environment, which includes using pgpool for replication etc.

backend=postgres
host=<hostname>
port=9999

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

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
www.zencos.com <http://www.zencos.com/>
919-480-2761
919-995-2356
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
https://lists.x2go.org/listinfo/x2go-user

--
-----------------------------------------------------------
Oleksandr Shneyder | Email: ***@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

2018-09-28 19:09:26 UTC

Permalink

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-***@lists.x2go.org> On Behalf Of Oleksandr Shneyder
Sent: Friday, September 28, 2018 3:08 AM
To: x2go-***@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

Post by David Barron
I'm trying to get x2go server running in a high availability
environment, which includes using pgpool for replication etc.

backend=postgres
host=<hostname>
port=9999

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

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
www.zencos.com <http://www.zencos.com/>
919-480-2761
919-995-2356
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
https://lists.x2go.org/listinfo/x2go-user