Re: [X2Go-User] X2go server and pgpool

2018-09-28 Thread 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 ) 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  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=
> 
> port=
> 
>  
> 
> When I try x2godbadmin -createdb I get a pgpool error I don't understand:
> 
>  
> 
> DBI
> connect('dbname=x2go_sessions;host=;port=;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.bar...@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.shney...@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
---

___
x2go-user mailing list
x2go-user@lists.x2go.org
https://lists.x2go.org/listinfo/x2go-user

Re: [X2Go-User] X2go server and pgpool

2018-09-28 Thread Oleksandr Shneyder 
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=
> 
> port=
> 
>  
> 
> When I try x2godbadmin –createdb I get a pgpool error I don’t understand:
> 
>  
> 
> DBI
> connect(‘dbname=x2go_sessions;host=;port=;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.bar...@zencos.com
> 
>   
> 
> 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.shney...@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
---



signature.asc
Description: OpenPGP digital signature
___
x2go-user mailing list
x2go-user@lists.x2go.org
https://lists.x2go.org/listinfo/x2go-user

[X2Go-User] X2go server and pgpool

2018-09-25 Thread 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=
port=

When I try x2godbadmin -createdb I get a pgpool error I don't understand:

DBI 
connect('dbname=x2go_sessions;host=;port=;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.bar...@zencos.com

[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