Differences

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

--- howto:setting_up_a_postgresql_database_for_rts2 [2017/04/05 12:04] – added <code> tags to make it readable (maybe they should replace <xterm2> tags jtello
+++ howto:setting_up_a_postgresql_database_for_rts2 [Unknown date] (current) – external edit (Unknown date) 127.0.0.1
@@ 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
+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.