[X2Go-User] Postgres configuration for load balancing

Short, Kermit k_short at lanl.gov
Tue May 20 07:13:31 CEST 2014


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!

-- 
Kermit Short


More information about the x2go-user mailing list