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 revision | ||
howto:setting_up_a_postgresql_database_for_rts2 [2009/12/11 20:12] – wildi | 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 ====== | ====== How to set up a PostgreSQL database for RTS2 ====== | ||
- | | + | |
- | < | + | < |
- | | + | |
- | < | + | < |
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></ |
- | | + | |
- | | + | * Currently if you would like to run RTS2 services like **XML-RPCd** or **EXECUTOR**, |
- | < | + | |
+ | < | ||
+ | </ | ||
+ | * Create RTS2 databases. Please see src/ | ||
+ | < | ||
user@host: | user@host: | ||
user@host: | user@host: | ||
- | </ | + | </xterm2></ |
- | | + | |
- | < | + | < |
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 29: | Line 33: | ||
GROUP ALTERED | GROUP ALTERED | ||
stars=# | stars=# | ||
- | </ | + | </xterm2></ |
- | | + | |
- | < | + | < |
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 45: | 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 54: | 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.1260558735.txt.gz · Last modified: 2009/12/11 00:00 (external edit)