Differences

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

--- howto:setting_up_a_postgresql_database_for_rts2 [2009/11/26 17:09] – created pkubanek
+++ howto:setting_up_a_postgresql_database_for_rts2 [Unknown date] (current) – external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== How to set up a PostgreSQL database for RTS2 ======
-  - Install PostgreSQL server (on Debian something like <xterm2>sudo apt-get install postgresql-server</xterm2>)
+  * Install PostgreSQL server, on Debian something like
-  - Create database user - replace **user** with your username:
+<code><xterm2>sudo apt-get install postgresql-server</xterm2></code>
-<xterm2>
+  * Create database user - replace **user** with your username:
+<code><xterm2>
 user@host:~$ sudo su postgres
 [sudo] password for user:
@@ Line 9: / Line 10: @@
 Shall the new role be a superuser? (y/n) y
 USER CREATED
-</xterm2>
+</xterm2></code>
-  - Currently if you would like to run RTS2 services like **XML-RPCd** or **EXECUTOR**, you will need to add user **root** same way as above
+  * see remark below, if necessary: ALTER USER user WITH PASSWORD 'password';
-  - Create RTS2 databases. Please see src/sql/README, and run (replaces stars in this and bellow if you would like to use other name for the database):
+  * Currently if you would like to run RTS2 services like **XML-RPCd** or **EXECUTOR**, you will need to add user **root** same way as above
-<xterm2>
+  * As user postgres
+<code><xterm2> createdb stars
+</xterm2></code>
+  * Create RTS2 databases. Please see src/sql/README, and run (replaces stars in this and bellow if you would like to use other name for the database):
+<code><xterm2>
 user@host:~$ cd rts2/src/sql
 user@host:~/rts2/src/sql$ ./rts2-builddb stars
-</xterm2>
+</xterm2></code>
-  - Add users to group observers in database stars:
+  * Add users to group observers in database stars:
-<xterm2>
+<code><xterm2>
 user@host:~$ psql stars
 Welcome to psql 8.3.8, the PostgreSQL interactive terminal.
@@ Line 28: / Line 33: @@
 GROUP ALTERED
 stars=#
-</xterm2>
+</xterm2></code>
-  - Check is database is up and running - run rts2-xmlrpcd in interactive mode:
+  * Check is database is up and running - run rts2-xmlrpcd in interactive mode:
-<xterm2>
+<code><xterm2>
 user@host:~$ sudo rts2-xmlrpcd -i
-</xterm2>
+</xterm2></code>
 If it will run and not complain about database, then you setup data properly.
@@ Line 44: / Line 49: @@
 To populate user tables, do:
-<xterm2>
+<code><xterm2>
 user@host:~$ psql stars
 Welcome to psql 8.3.8, the PostgreSQL interactive terminal.
@@ Line 53: / Line 58: @@
  \q to quit
 stars=# insert into users values ('rts2', 'rts2', NULL, 'rts2@example.com', 1);
-</xterm2>
+</xterm2></code>
 Which will create user rts2, with password rts2. 1 is user ID, you of course would like to keep this unique, otherwise psql will complain. You can then user rts2 as login and rts2 as password for XML-RPC access through rts2-xmlrpcd
+Note it is likely the database was different when the previous instruction was written to the version when this next note was added:
+Since the table headers are:
+usr_login | usr_tmp |    usr_email     | usr_id | usr_execute_permission |                                             usr_passwd                                             | allowed_devices
+to add a new user 'rts2' with password 'password' it should be:
+<code> stars=# insert into users values ('rts2', , 'rts2@example.com', 3, f,'password',); </code>
+Also it is apparent passwords should be somehow hashed so this almost works but it doesn't.