howto:setting_up_a_postgresql_database_for_rts2
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
howto:setting_up_a_postgresql_database_for_rts2 [2017/04/05 12:04] jtello added <code> tags to make it readable (maybe they should replace <xterm2> tags |
howto:setting_up_a_postgresql_database_for_rts2 [2017/04/05 00:00] (current) |
||
|---|---|---|---|
| Line 61: | Line 61: | ||
| 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 | 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. | ||
howto/setting_up_a_postgresql_database_for_rts2.txt ยท Last modified: 2017/04/05 00:00 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
