bug report FMF network server installation on MySQL.

7 views
Skip to first unread message

Médecine Libre

unread,
May 13, 2013, 3:30:52 PM5/13/13
to freeme...@googlegroups.com
Hello!

On FMF 0.8.2 Ubuntu 12.04:

Database installation goes pretty smooth, on an external server, through
an SSH connection with port forwarding (Nice security practice for
remote work (house calls, at home): FMF thinks the database is on
127.0.0.1:6603 but it's on another server on 3306,).

I used "Assistant de création d'utilisateurs" once without any problem
and created my first user.

Then, when I click again on "Assitant de création d'utilisateurs", the
same user creation resumé appears. Annuler causes a warning about
possible loss of information, Terminer tells about an error. I had to bo
back to the beginning of the process by clicking multiple times on
Précédent to get to the first dialog, then had a warning about the user
being already used, then changed everything and succeeded in creating
another user, but i couldn't add a password during this process. And in
the end i checked with "Gestionnaire des utilisateurs" and the user was
not created. It doesn't appear in the Gestionnaire. But the login is
said to be taken anyway.

So the "assistant" can only be used once until we fix this bug.

After checking, the user I thought was created during the first attempt,
is nowhere to be seen... but the second one was created! Big mess!!!

Other problem: i changed fmf_admin password before running FMF and when
i tried to connect, the new password was said to be incorrect, the
default password fmf_admin was ok and allowed me to login. A flush
privileges problem? I quit FMF, restarted it, and i could login with the
default fmf_admin password once again.

Third attempt at changin the fmf_admin password was still unsucessful,
despite no warning or error message, and using copy and paste (so the
password was the same twice, for sure). The default password is retained.

Any idea?

That's all.

Everything else works. Virtual data is created. New data can be added to
patient files....

Thank you.

Jérôme Pinguet
www.medecinelibre.com

Eric Maeker

unread,
May 13, 2013, 3:43:19 PM5/13/13
to freeme...@googlegroups.com
Yes, create an issue
Terms to use
UserCreator -> the 'Assistant'
UserManager -> the 'Gestionnaire'

And give me time, I'm hardly debugging the padtools plugin.
Eric
PGP.sig

Médecine Libre

unread,
May 13, 2013, 4:16:55 PM5/13/13
to freeme...@googlegroups.com
Le 13/05/2013 21:43, Eric Maeker a �crit :
> Le 13 mai 2013 � 21:30, M�decine Libre a �crit :
>
>> Hello!
>>
>> On FMF 0.8.2 Ubuntu 12.04:
>>
>> Database installation goes pretty smooth, on an external server, through
>> an SSH connection with port forwarding (Nice security practice for
>> remote work (house calls, at home): FMF thinks the database is on
>> 127.0.0.1:6603 but it's on another server on 3306,).
>>
>> I used "Assistant de cr�ation d'utilisateurs" once without any problem
>> and created my first user.
>>
>> Then, when I click again on "Assitant de cr�ation d'utilisateurs", the
>> same user creation resumďż˝ appears. Annuler causes a warning about
>> possible loss of information, Terminer tells about an error. I had to bo
>> back to the beginning of the process by clicking multiple times on
>> Pr�c�dent to get to the first dialog, then had a warning about the user
>> being already used, then changed everything and succeeded in creating
>> another user, but i couldn't add a password during this process. And in
>> the end i checked with "Gestionnaire des utilisateurs" and the user was
>> not created. It doesn't appear in the Gestionnaire. But the login is
>> said to be taken anyway.
>>
>> So the "assistant" can only be used once until we fix this bug.
>>
>> After checking, the user I thought was created during the first attempt,
>> is nowhere to be seen... but the second one was created! Big mess!!!
>>
>> Other problem: i changed fmf_admin password before running FMF and when
>> i tried to connect, the new password was said to be incorrect, the
>> default password fmf_admin was ok and allowed me to login. A flush
>> privileges problem? I quit FMF, restarted it, and i could login with the
>> default fmf_admin password once again.
>>
>> Third attempt at changin the fmf_admin password was still unsucessful,
>> despite no warning or error message, and using copy and paste (so the
>> password was the same twice, for sure). The default password is retained.
>>
>> Any idea?
> Yes, create an issue
> Terms to use
> UserCreator -> the 'Assistant'
> UserManager -> the 'Gestionnaire'
>
> And give me time, I'm hardly debugging the padtools plugin.
> Eric

Ok.

Thank you Eric.

I notice there are 7 entries in database USERS and 11 entries in
database LK_USER. Maybe the login is created before completion of the
whole process and then if it fails, the id is still there and becomes
unavailable? I could create other users since, but not with the same
login as the failed attempts.

I also notice that there are 11 separate databases created for FMF. If
anyone wants to replicate them (master slave, for redundancy or backup
purpose) it won't be an easy task.

Why not have only one database? :-) Or is my setup faulty? I had created
an empty database called fmf before installation, thinking i had to
create one myself, as with most web php mysql software...

J�r�me Pinguet

Eric Maeker

unread,
May 14, 2013, 4:49:55 AM5/14/13
to freeme...@googlegroups.com

Le 13 mai 2013 à 22:16, Médecine Libre a écrit :

> Le 13/05/2013 21:43, Eric Maeker a écrit :
>> Le 13 mai 2013 à 21:30, Médecine Libre a écrit :
>>
>>> Hello!
>>>
>>> On FMF 0.8.2 Ubuntu 12.04:
>>>
>>> Database installation goes pretty smooth, on an external server, through
>>> an SSH connection with port forwarding (Nice security practice for
>>> remote work (house calls, at home): FMF thinks the database is on
>>> 127.0.0.1:6603 but it's on another server on 3306,).
>>>
>>> I used "Assistant de création d'utilisateurs" once without any problem
>>> and created my first user.
>>>
>>> Then, when I click again on "Assitant de création d'utilisateurs", the
>>> same user creation resumé appears. Annuler causes a warning about
>>> possible loss of information, Terminer tells about an error. I had to bo
>>> back to the beginning of the process by clicking multiple times on
>>> Précédent to get to the first dialog, then had a warning about the user
May be the creation/removal iteration caused this bug. I need to make some tests!

> Maybe the login is created before completion of the
> whole process and then if it fails, the id is still there and becomes
> unavailable? I could create other users since, but not with the same
> login as the failed attempts.
>
> I also notice that there are 11 separate databases created for FMF. If
> anyone wants to replicate them (master slave, for redundancy or backup
> purpose) it won't be an easy task.

Ah yes. FreeMedForms manages multiple databases:
- patient
- clinical episode
- pmhx
- agenda
- users
- ...

> Why not have only one database? :-) Or is my setup faulty?

I didn't want to mix all these database into a big one, because the code would have been a lot harder to write with the plugin implementation.

> I had created an empty database called fmf before installation, thinking i had to
> create one myself, as with most web php mysql software...

Ah FMF is more efficient than this. It manages the server, the FreeMedForms root user and all the FMF users without any requirement but having a MySQL server and a MySQL root user. One click -> one full application! ;)

I'm very interested with your MySQL tests, I can manage a debug compilation for your tests if you want a refresher build.

Eric, freemedforms.com

PGP.sig
Reply all
Reply to author
Forward
0 new messages