User can't login after changing password

Everything about our Electronic Medical Record FreeMedForms: ask questions, post reviews, add comments.
Toutes vos questions/commentaires/retours d'expérience avec notre gestionnaire de dossier patient FreeMedForms EMR.
Post Reply
fpconsult.be
Posts: 3
Joined: 04 April 2015, 07:51
Location: Belgique
Contact:

User can't login after changing password

Post by fpconsult.be » 05 April 2015, 21:01

Hello

Problem reporting assistant from inside the application (FMF 0.9.6) was not working so I use this way...

Can you check here below issue and tell if already known or if it could come from my installation/configuration?

Thanks

Philippe

Issue?
When modifying password of a user in "User manager", the user can no more login!
Why?
It seems that only the password in fmf_users is modified. So password of the MySQL user is not modified by the application
As password of mysql user is also used ==> Impossible to login

Some details about installation:
Network version, with MySQL database, installed on a remote server
Operating System?
Client = Windows 7
Server = Debian 7.6.0

Precise version of FreeMedForms = 0.9.6

Troubleshooting details
-----------------------
==>"Before"
GRANT CREATE USER ON *.* TO 'admin_user01'@'%' IDENTIFIED BY PASSWORD '*60A6691B5512E2763FCED5CFE72C9C1DC17C1719' WITH GRANT OPTION;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `%fmf\_%`.* TO 'admin_user01'@'%' WITH GRANT OPTION;
GRANT USAGE ON *.* TO 'admin_user01'@'localhost' IDENTIFIED BY PASSWORD '*60A6691B5512E2763FCED5CFE72C9C1DC17C1719';

(Exported with PHPMYADMIN)
User Created via FMF GUI)

in fmf_users > Table USERS
password = bKbfaQjqNGIolMTthjBY43CDdYU=
user_uuid =f1ad504169804cde98524d61db2591f0

==>"After" (after changing user's password with FMF GUI)

in fmf_users > Table USERS
password = bKbfaQjqNGIolMTthjBY43CDdYU=
user_uuid = W6ph5Mm5Pz8GgiULbPgzG37mj9g=

OK GOOD

in MYSQL
GRANT CREATE USER ON *.* TO 'admin_user01'@'%' IDENTIFIED BY PASSWORD '*60A6691B5512E2763FCED5CFE72C9C1DC17C1719' WITH GRANT OPTION;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `%fmf\_%`.* TO 'admin_user01'@'%' WITH GRANT OPTION;
GRANT USAGE ON *.* TO 'admin_user01'@'localhost' IDENTIFIED BY PASSWORD '*60A6691B5512E2763FCED5CFE72C9C1DC17C1719';

So password of MYSQL USER not modified!!

When trying to connect with gui ==> error
150405 19:45:10 337 Connect admin_user01@192.168.0.121 on
337 Connect Access denied for user 'admin_user01'@'192.168.0.121' (using password: YES)

If assigning previous password to user ==> Ok user can login


If assigning password to MySQL USER matching the one in fmf_users ==> OK user can login
SET PASSWORD FOR 'admin_user01'@'%' = PASSWORD( '********' )

Conclusion
==========
When modifying the password of a user in the GUI, only the password in fmf_users is modified.
As password of mysql user is also used ==> Impossible to login

User avatar
eric
Administrateur
Posts: 116
Joined: 28 September 2013, 11:27
Contact:

Re: User can't login after changing password

Post by eric » 11 April 2015, 09:39

Ok this is already reported see issue #47. I'm committing a patch right now.

User avatar
eric
Administrateur
Posts: 116
Joined: 28 September 2013, 11:27
Contact:

Re: User can't login after changing password

Post by eric » 11 April 2015, 09:49

fpconsult.be wrote:Problem reporting assistant from inside the application (FMF 0.9.6) was not working so I use this way...
This feature is perfectly working on Debian Wheezy & Ubuntu. You must have defined a desktop with a preferred mail agent.

Post Reply