User Tools

Site Tools


wiki:advanced:multi-node:x2goserver-pgsql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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:
-====== Installation: X2go Server with PostgreSQL database backend ======+====== X2Go Server with PostgreSQL database backend ======
  
-<note>This wiki page explains how you can configure X2Go with PostgreSQL as database backend. However, this is only recommended for sites that run more than one X2go server (X2go server clusters). If you have one standalone X2Go server then please use the SQLite database backend (which is the default after installing of the ''x2goserver'' package).</note>+**Note:** This wiki page explains how you can configure X2Go with PostgreSQL as database backend. However, this is only recommended for sites that run more than one X2Go Server (X2Go multi-node farms). 
  
-Changes since x2goserver v3.0.99.x:+If you have one standalone X2Go server then please use the SQLite database backend (which is the default after installation of the ''x2goserver'' package).
  
-The ''sudo'' command is no longer required by ''x2goserver'' to neither contact 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 ''sudo'' command is no longer required by ''x2goserver'' to neither contact 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 X2Go Server uses the Perl DBI package. 
 + 
 +===== 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:
 </code> </code>
  
-__Example:__+**Example:**
  
 <code> <code>
Line 61: Line 60:
 </code> </code>
  
-__Database configuration in file /etc/x2go/x2gosql/sql:__+===== Database configuration in file /etc/x2go/x2gosql/sql ===== 
  
 <code> <code>
Line 82: Line 82:
 </code> </code>
  
-Database administration using ''/usr/lib/x2go/script/x2godbadmin'' (on X2go server).+===== Database administration using ''/usr/lib/x2go/script/x2godbadmin'' (on X2Go Server===== 
  
 <code> <code>
Line 95: Line 96:
 </code> </code>
  
-__Create database (evoke on X2go server):__+==== Create database (evoke on X2go server) ==== 
  
 <code> <code>
Line 101: Line 103:
 </code> </code>
  
-__Create database users:__+==== Create database users ==== 
  
 <code> <code>
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. 
  
  
wiki/advanced/multi-node/x2goserver-pgsql.txt · Last modified: 2016/03/29 19:40 by stefanbaur