howto:setting_up_a_postgresql_database_for_rts2
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
howto:setting_up_a_postgresql_database_for_rts2 [2011/12/08 13:50] – [How to set up a PostgreSQL database for RTS2] wildi | howto:setting_up_a_postgresql_database_for_rts2 [2017/04/05 12:18] – [Setting up RTS2 users] jtello | ||
---|---|---|---|
Line 2: | Line 2: | ||
* Install PostgreSQL server, on Debian something like | * Install PostgreSQL server, on Debian something like | ||
- | < | + | < |
* Create database user - replace **user** with your username: | * Create database user - replace **user** with your username: | ||
- | < | + | < |
user@host: | user@host: | ||
[sudo] password for user: | [sudo] password for user: | ||
Line 10: | Line 10: | ||
Shall the new role be a superuser? (y/n) y | Shall the new role be a superuser? (y/n) y | ||
USER CREATED | USER CREATED | ||
- | </ | + | </xterm2></ |
- | * if necessary: ALTER USER user WITH PASSWORD ' | + | * see remark below, |
* Currently if you would like to run RTS2 services like **XML-RPCd** or **EXECUTOR**, | * Currently if you would like to run RTS2 services like **XML-RPCd** or **EXECUTOR**, | ||
* As user postgres | * As user postgres | ||
- | < | + | < |
- | </ | + | </xterm2></ |
* Create RTS2 databases. Please see src/ | * Create RTS2 databases. Please see src/ | ||
- | < | + | < |
user@host: | user@host: | ||
user@host: | user@host: | ||
- | </ | + | </xterm2></ |
* Add users to group observers in database stars: | * Add users to group observers in database stars: | ||
- | < | + | < |
user@host: | user@host: | ||
Welcome to psql 8.3.8, the PostgreSQL interactive terminal. | Welcome to psql 8.3.8, the PostgreSQL interactive terminal. | ||
Line 33: | Line 33: | ||
GROUP ALTERED | GROUP ALTERED | ||
stars=# | stars=# | ||
- | </ | + | </xterm2></ |
* 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: | ||
- | < | + | < |
user@host: | user@host: | ||
- | </ | + | </xterm2></ |
If it will run and not complain about database, then you setup data properly. | If it will run and not complain about database, then you setup data properly. | ||
Line 49: | Line 49: | ||
To populate user tables, do: | To populate user tables, do: | ||
- | < | + | < |
user@host: | user@host: | ||
Welcome to psql 8.3.8, the PostgreSQL interactive terminal. | Welcome to psql 8.3.8, the PostgreSQL interactive terminal. | ||
Line 58: | Line 58: | ||
\q to quit | \q to quit | ||
stars=# insert into users values (' | stars=# insert into users values (' | ||
- | </ | + | </xterm2></ |
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 | 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 | ||
+ | to add a new user ' | ||
+ | < | ||
+ | |||
+ | Also it is apparent passwords should be somehow hashed so this almost works but it doesn' |
howto/setting_up_a_postgresql_database_for_rts2.txt · Last modified: 2017/04/05 00:00 (external edit)