This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
wiki:advanced:multi-node:x2goserver-pgsql [2011/11/12 15:18] sunweaver |
wiki:advanced:multi-node:x2goserver-pgsql [2013/03/12 20:37] sunweaver |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== | + | ====== |
- | < | + | **Note: |
- | Changes since x2goserver | + | If you have one standalone X2Go server then please use the SQLite database backend (which is the default after installation of the '' |
- | The '' | + | With X2Go Server v3.0.99.0 the whole session database backend code had been fully rewritten due to a serious security issue that had been brought up by Morty, Reinhard and Arw. Sind then, the '' |
- | SQLite database (installation default) nor the PostgreSQL database. Since v3.0.99.x | + | SQLite database (installation default) nor the PostgreSQL database. Since v3.0.99.x PostgreSQL views and rules are used to restrict users from modifying or accessing data of other users. |
- | PostgreSQL views and rules are used to restrict users from modifying or accessing | + | |
- | data of other users. | + | |
- | For accessing the X2go/PostgreSQL database Perl DBI has been used in x2goserver. | + | For accessing the X2Go/PostgreSQL database |
+ | |||
+ | ===== Preparations ===== | ||
- | __Preparations: | ||
* configure PostgreSQL server to enable TCP connections from your X2go server host | * configure PostgreSQL server to enable TCP connections from your X2go server host | ||
Line 21: | Line 20: | ||
</ | </ | ||
- | __Example:__ | + | **Example:** |
< | < | ||
Line 61: | Line 60: | ||
</ | </ | ||
- | __Database | + | ===== Database |
< | < | ||
Line 82: | Line 82: | ||
</ | </ | ||
- | Database administration using ''/ | + | ===== Database administration using ''/ |
< | < | ||
Line 95: | Line 96: | ||
</ | </ | ||
- | __Create | + | ==== Create |
< | < | ||
Line 101: | Line 103: | ||
</ | </ | ||
- | __Create | + | ==== Create |
< | < | ||
Line 112: | Line 115: | ||
After that step users can create x2go sessions. | After that step users can create x2go sessions. | ||
- | |||
- | ====== Installation (for x2goserver < 3.0.99.x - old code, please upgrade your x2goserver) ====== | ||
- | :!: **Before you begin!** -> Note that you are using old and insecure code... Please upgrade to a current version of x2goserver. | ||