X2Go - everywhere@home

If you want to use an already existent PostgreSQL database server in your network, you'll need to allow the x2goserver(s) access to the database server. First of all, you'll need to tell the address of the target server to every x2goserver:

# echo -n „address of postgres server“ > /etc/x2go/sql

Furthermore you'll need to allow “passwordless” authentication via SSH keys. Please don't add a “paraphrase” to the generated key:

# mkdirhier /root/.x2go/ssh/.pg
# ssh-keygen -t das -f /root/.x2go/ssh/.pg/id_dsa

To copy the public part of the key to the PostgreSQL server, you may use the “ssh-copy-id” command to combine transfer and paste command, or you can paste the key after transferring it by yourself:

# cat id_dsa-pub >> ~postgres/.ssh/authorized_keys

You can test the needed connection by entering following command:

# ssh -i /root/.x2go/ssh/.pg/id_dsa postgres@server

You'll also need to run the “x2gocreatebase.sh” script as described before on the database server to create the needed instance.