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. |