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