Hi Cornelius
I try to use this resolver to store remote device account to do OTP authentication when ssh login.
device account is pi;
table is :
mysql> select * from sshlist;
+----+----------+-----------+--------------+-------+--------+------------+-----------+----------------+
| ID | username | password | email | phone | mobile | first_name | last_name | description |
+----+----------+-----------+--------------+-------+--------+------------+-----------+----------------+
| 1 | pi | raspberry | pi@localhost | 0000 | 0000 | pi | pi | ssh login user |
+----+----------+-----------+--------------+-------+--------+------------+-----------+----------------+
1 row in set (0.00 sec)
---------------------------------------------------------------
mapping table :
{ "userid" : "ID", "username": "username", "password" : "password", "email" : "email", "phone" : "phone", "mobile" : "mobile", "givenname" : "first_name", "surname" : "last_name", "description" : "description"}
---------------------------------------------------------------
When I check user preview, I cannot see the id value. Is it correct?
Please see the attached screenshot.
And another password problem I already resolved. It seems need to use sha to hash password and I can login web successfully.
I use web to change password.
mysql> select * from sshlist;
+----+----------+---------------------------------------------------------------------------+--------------+-------+--------+------------+-----------+----------------+
| ID | username | password | email | phone | mobile | first_name | last_name | description |
+----+----------+---------------------------------------------------------------------------+--------------+-------+--------+------------+-----------+----------------+
| 1 | pi | {SSHA256}fQ+s953SEpuuJg9eRqKR8xY9ZoNp2OhquulMJ2Bo4eIWoHvc1f8hM3vl/9fQKpyN | pi@localhost | 0000 | 0000 | pi | pi | ssh login user |
+----+----------+---------------------------------------------------------------------------+--------------+-------+--------+------------+-----------+----------------+
1 row in set (0.00 sec)
I still cannot add new user by web because I cannot set ID value in the content.
It will show below error message.
This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: Instance <MappedSshlist at 0x7f3e1dd6dfd0> has a NULL identity key.
Harvey