User Tools

Site Tools


howto:setting_up_a_postgresql_database_for_rts2

Differences

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

Link to this comparison view

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.1491386676.txt.gz ยท Last modified: 2017/04/05 00:00 (external edit)