[X2Go-User] Postgres configuration for load balancing

[Short, Kermit]

Does anyone out there have any experience with the Postgres backed
Session Broker setup?
-- 
Kermit Short



On Tue, 2014-05-20 at 05:13 +0000, Short, Kermit wrote:
> Greetings,
>    While I haven't been able to compile the x2go client for our IGELs,
> I'm pushing forward with the project using the existing version.  As
> such, I'm trying to create a load balancing cluster, but I'm stuck
> adding users to the postgresql database, and I need to do a sanity
> check.
> 
> Assumption 1:
>    I have to manually create each user in the database for that user to
> have group membership and/or be able to log in and create a session on
> the load balanced server.
> 
> Assumption 2:
>    The x2godbadmin script must be run as root to gain access to the
> root-only file containing the postgres database managment user's
> password.
> 
> If either of those assumptions are incorrect, please advise.
> 
> My problem is that all of our home directories are on root-squashed NFS
> volumes.  As the script is running under root's context, the script is
> unable to create ~/.x2go/sqlpass, which would seemingly prevent the user
> from being able to utilize any member of the load balancing cluster.
> 
> Obviously, if I can simply pass through PAM credentials and LDAP lookups
> without the need for this information to live in a postgresql database,
> none of this is a problem.
> 
> Likewise, if I can run the x2godbadmin script as each individual user,
> while extremely painful, I can write a script to do this.
> 
> Am I way off in the woods on my logic here?
> 
> Thanks!
>