using_a_centralized_postgresql_db_with_x2goserver_debian
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
using_a_centralized_postgresql_db_with_x2goserver_debian [2010/07/01 11:08] sunweaver |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Installation ====== | ||
| - | :!: **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. | ||
| - | ==== Using an existent database server on the network ==== | ||
| - | |||
| - | 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“ > / | ||
| - | </ | ||
| - | |||
| - | Furthermore you'll need to allow “passwordless” authentication via SSH keys. Please don't add a “paraphrase” to the generated key: | ||
| - | |||
| - | < | ||
| - | # mkdirhier / | ||
| - | # ssh-keygen -t dsa -f / | ||
| - | </ | ||
| - | |||
| - | 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/ | ||
| - | # cat id_dsa-pub >> ~postgres/ | ||
| - | # chown -Rf postgres: | ||
| - | # chmod -Rf go-rwx ~postgres/ | ||
| - | </ | ||
| - | |||
| - | You can test the needed connection by entering following command: | ||
| - | |||
| - | < | ||
| - | # ssh -i / | ||
| - | </ | ||
| - | |||
| - | You'll also need to run the “x2gocreatebase.sh” script as described before on the database server to create the needed instance. | ||
using_a_centralized_postgresql_db_with_x2goserver_debian.1277982525.txt.gz · Last modified: 2013/03/08 13:31 (external edit)
Imprint & Legal Disclaimer -
Data Protection & Privacy Statement
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3