AW: mysql resolver user problem

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 Datum: 04.07.16 11:01 (GMT+01:00) An: privacyidea 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?

Please read the blog post about getting help

For professional services and consultancy regarding two factor authentication please visit

In an enterprise environment you should get a SERVICE LEVEL AGREEMENT which suites your needs for SECURITY, AVAILABILITY and LIABILITY:

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

To post to this group, send email to

Visit this group at

To view this discussion on the web visit

For more options, visit