As you are calling this table ssh user, what are you trying to achieve?
How does your resolver an mapping look like?
Kind regards Cornelius
Cornelius Kölbel +49 151 2960 1417
NetKnights GmbHHttp://NetKnights. It
+49 561 3166 797-------- Ursprüngliche Nachricht --------Von: Harvey Chang harvey30438@gmail.com Datum: 04.07.16 11:01 (GMT+01:00) An: privacyidea privacyidea@googlegroups.com Betreff: [privacyidea] mysql resolver user problem
Dear all
I try to use mysql database to be a new resolver and suffer from some problems.below is my setting.
create database sshgrant all privileges for sshuser on sshcreate table sshlist which contains userid char(20),username char(20), phone char(20), mobile char(20), email char(20), givenname char(20),surname char(20), password char(20), PRIMARY KEY (userid))add one user pi in the table.insert info sshlist(userid, username, password) values(‘00000001’, ‘pi’, ‘12345678’);
open privacyidea web, and setup user resolver and realm.I can see one user in user profile, but I cannot see user id in id column.I cannot change password and create new account in web.web login with the user also failed.
Is there any problem I should take care?
Harvey
–
Please read the blog post about getting help
https://www.privacyidea.org/getting-help/.
For professional services and consultancy regarding two factor authentication please visit
https://netknights.it/en/leistungen/one-time-services/
In an enterprise environment you should get a SERVICE LEVEL AGREEMENT which suites your needs for SECURITY, AVAILABILITY and LIABILITY:
https://netknights.it/en/leistungen/service-level-agreements/
You received this message because you are subscribed to the Google Groups “privacyidea” group.
To unsubscribe from this group and stop receiving emails from it, send an email to privacyidea+unsubscribe@googlegroups.com.
To post to this group, send email to privacyidea@googlegroups.com.
Visit this group at https://groups.google.com/group/privacyidea.
To view this discussion on the web visit https://groups.google.com/d/msgid/privacyidea/e7a2a50c-94a2-488a-a3b4-846467478de6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.