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
wiki:advanced:multi-node:x2goserver-pgsql [2013/09/23 19:20]
sunweaver
wiki:advanced:multi-node:x2goserver-pgsql [2016/03/29 19:40] (current)
stefanbaur [X2Go Server with PostgreSQL database backend]
Line 1: Line 1:
 ====== 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 multi-node farms). +**Note:** This wiki page explains how you can configure X2Go with PostgreSQL as database backend. However, for small setups, this is unneccessary. If you have one standalone X2Go server and only a small number of users, then you can use the SQLite database backend (which is the default after installation of the ''x2goserver'' package). The PostgreSQL backend is recommended for sites that run more than one X2Go Server (X2Go multi-node farms) and/or a large number of users
  
-If you have one standalone X2Go server then please use the SQLite database backend (which is the default after installation of the ''x2goserver'' package). 
  
 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 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
Line 119: Line 118:
 ===== Database Structure and Troubleshooting ===== ===== Database Structure and Troubleshooting =====
  
-In case it becomes necessary to edit the X2Go session database on the PostgreSQL server by handconnect to the DB with this command:+In hopefully rare cases it may become necessary to fix the X2Go session database via standard PostgreSQL tools (e.g. ''psql''). This should not happen and please please please report the issue [[wiki:bugs|as a bug against the x2goserver]] X2Go component. Howeverif you are in the unlucky situation of having to fix up the session DB, then the below lines may render useful to you.
  
 ==== Connect to the database ==== ==== Connect to the database ====
 +
 +In case it becomes necessary to edit the X2Go session database on the PostgreSQL server by hand, connect to the DB with this command:
  
 <code> <code>
wiki/advanced/multi-node/x2goserver-pgsql.1379964015.txt.gz ยท Last modified: 2013/09/23 19:20 by sunweaver