Page 1 of 1

processmaker 3.1 sql file Installation error

Posted: Tue Oct 04, 2016 7:13 am
by 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 :roll:

Re: processmaker 3.1 sql file Installation error

Posted: Tue Oct 04, 2016 6:09 pm
by amosbatto
Did you manually import the users into the USERS table or did you import users from LDAP/Active Directory?

Re: processmaker 3.1 sql file Installation error

Posted: Wed Oct 05, 2016 1:02 pm
by 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.

Re: processmaker 3.1 sql file Installation error

Posted: Thu Oct 06, 2016 7:29 pm
by 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

Re: processmaker 3.1 sql file Installation error

Posted: Fri Oct 07, 2016 2:26 am
by insomniak
Thanks meshesha, it did help. Although VARCHAR(64) is enough.