<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">I’m trying to get x2go server running in a high availability environment, which includes using pgpool for replication etc.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’ve got my /etc/x2go/x2gosql/sql file setup this way:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">backend=postgres<o:p></o:p></p>
<p class="MsoNormal">host=<hostname><o:p></o:p></p>
<p class="MsoNormal">port=9999<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">When I try x2godbadmin –createdb I get a pgpool error I don’t understand:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">DBI connect(‘dbname=x2go_sessions;host=<hostname>;port=9999;sslmode=disable’,’postgres’,…) failed :ERROR: unable to read message kind<o:p></o:p></p>
<p class="MsoNormal">DETAIL: kind does not match between master(53) slot[1] (45) at /sbin/x2godbadmin line 530.<o:p></o:p></p>
<p class="MsoNormal">Backend=postgres at /sbin/x2godbadmin line 530.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">When I connect with pgAdmin I can see that the x2godbuser has been created and the x2go_sessions database has been created.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If I try to connect to the database I get this error<o:p></o:p></p>
<p class="MsoNormal"><img width="399" height="166" style="width:4.1562in;height:1.7291in" id="Picture_x0020_2" src="cid:image001.png@01D454B1.82741FE0" alt="cid:image002.png@01D44F61.9E2EB470"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If I change the port= to 5432 (the default postgresql port) the command works fine.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">So, I guess my first question is, is this sort of setup supported?<o:p></o:p></p>
<p class="MsoNormal">If so, is there any documentation or suggestions?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks in advance.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="600" style="width:6.25in">
<tbody>
<tr>
<td colspan="2" style="border:solid #019ADD 1.0pt;background:#009DDC;padding:3.75pt 3.75pt 3.75pt 3.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><i><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:white">architects of vision and strategy for business intelligence</span></i><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:white"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:96.75pt">
<td width="300" valign="top" style="width:225.0pt;border-top:none;border-left:solid #006699 1.0pt;border-bottom:solid #006699 1.0pt;border-right:none;padding:3.75pt 3.75pt 3.75pt 3.75pt;height:96.75pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">David Barron</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><br>
Senior Consultant<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Zencos Consulting: david.barron@zencos.com<o:p></o:p></span></p>
</td>
<td width="300" valign="top" style="width:225.0pt;border-top:none;border-left:none;border-bottom:solid #006699 1.0pt;border-right:solid #006699 1.0pt;padding:3.75pt 3.75pt 3.75pt 3.75pt;height:96.75pt">
<div align="right">
<table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="padding:0in 0in 0in 0in">
<div align="right">
<table class="MsoNormalTable" border="0" cellspacing="1" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr style="height:45.75pt">
<td colspan="2" style="padding:0in 0in 0in 0in;height:45.75pt">
<p class="MsoNormal" align="right" style="text-align:right"><a href="http://www.zencos.com/" target="_blank"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:blue;text-decoration:none"><img border="0" width="153" height="50" style="width:1.5937in;height:.5208in" id="Picture_x0020_1" src="cid:image002.jpg@01D454B1.82741FE0" alt="www.zencos.com"></span></a><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="52%" style="width:52.0%;padding:0in 0in 0in 0in">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">work:<o:p></o:p></span></p>
</td>
<td width="48%" style="width:48.0%;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">919-480-2761<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">mobile:
<o:p></o:p></span></p>
</td>
<td style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">919-995-2356<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">fax:
<o:p></o:p></span></p>
</td>
<td style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">919-287-2335<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
<tr>
<td colspan="2" style="padding:.75pt .75pt .75pt .75pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-size:7.5pt;font-family:"Arial",sans-serif">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.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>