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:39] 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 for md5 authentication for users from x2goserver | + | |
+ | * configure PostgreSQL server for md5 authentication for users from X2Go Server | ||
< | < | ||
Line 21: | Line 20: | ||
</ | </ | ||
- | __Example:__ | + | **Example:** |
< | < | ||
Line 30: | Line 29: | ||
You must create a database user which can create databases and users for | You must create a database user which can create databases and users for | ||
- | X2go database administration. You can also use the '' | + | X2Go database administration. You can also use the '' |
job. | job. | ||
Line 61: | Line 60: | ||
</ | </ | ||
- | __Database | + | ===== Database |
< | < | ||
Line 82: | Line 82: | ||
</ | </ | ||
- | Database administration using ''/ | + | ===== Database administration using ''/ |
< | < | ||
$ / | $ / | ||
- | X2Go SQL admin interface. Use it to create | + | X2Go SQL admin interface. Use it to create |
- | remove users or groups in x2go database | + | remove users or groups in X2Go session |
Usage: | Usage: | ||
x2godbadmin --createdb | x2godbadmin --createdb | ||
Line 95: | Line 97: | ||
</ | </ | ||
- | __Create | + | ==== Create |
< | < | ||
Line 101: | Line 104: | ||
</ | </ | ||
- | __Create | + | ==== Create |
< | < | ||
Line 111: | Line 115: | ||
</ | </ | ||
- | After that step users can create | + | After that step users of the posix group '' |
- | + | ||
- | ====== 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. | + | |