[meshesha]

hi,
I have found a problem during the installation of SQL file.
i am using MySQL server.
in workflow\engine\data\mysql\schema.sql in TABLE `USERS` i found that `USR_PASSWORD` VARCHAR(32) is too short.

i changed it to `USR_PASSWORD` VARCHAR(128) and it fix the problem.

hope it helps

[amosbatto]

Did you manually import the users into the USERS table or did you import users from LDAP/Active Directory?

[meshesha]

During installation I got the following message:
(see attachment image)

i am using MySQL server v.5.6.29,
, IIS 7.5 and PHP version: 5.5.36.

as you see ,
the Username and password that tries to insert to database is the admin usrname and password from the previous installation stage.

[amosbatto]

Yes, you are right. I just tried installing in Ubuntu 16.04 with MySQL 5.7 and I see the same problem. The md5 hash for passwords should only need 32 characters, but something in MySQL 5.6 and later is having trouble. The developers have only tested with MySQL 5.5, so they didn't see it. I have filed a bug report: http://bugs.processmaker.com/view.php?id=21441

[insomniak]

Thanks meshesha, it did help. Although VARCHAR(64) is enough.