using_a_centralized_postgresql_db_with_x2goserver_debian
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
using_a_centralized_postgresql_db_with_x2goserver_debian [2010/06/06 07:49] h1 created |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ==== 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 das -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: | ||
| - | |||
| - | < | ||
| - | # cat id_dsa-pub >> ~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.1275810599.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