Before you begin!

Please make sure that you have added the x2go repository to your package management system. The required steps are described here: adding the x2go repository (debian)! You'll further need to have some experience with x2goprint and maybe x2goserver.

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:

# mkdir /root/.x2go/ssh/.pg
# ssh-keygen -t dsa -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 (make sure file permissions for SSH key authentication are set correctly):

# mkdir -p ~postgres/.ssh/
# cat id_dsa-pub >> ~postgres/.ssh/authorized_keys
# chown -Rf postgres:postgres ~postgres/.ssh
# chmod -Rf go-rwx ~postgres/.ssh

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.