Page 1 of 1

Cannot create a new workspace on PM : shows pop-up " MYSQ error:"

Posted: Wed Jun 10, 2020 4:51 pm
by pawansaxena
I have installed the PM instances in following manner :
One processmaker instance PM1 : ip1
Second processmaker instance PM2 : ip2

Two separate Mysql servers : master and slave :
mysql_master_server and mysql_slave_server and configured the replication on those.

My requirement is that PM1 and PM2 should be identical ( they should share the same database and shared directory ).
I have initialized both of them with different workflow name and thus i got two different databases on master and slave mysql servers, so replication works fine.


I configured the users on mysql_master_server so as to allow PM instances to access the remote mysql_master_server, that also works.
Now after initialization, i mounted the shared directory of PM1 on some other server ( filesystem mounting ) using sshfs.
After that i removed the shared directory of PM2 and again mounted the shared directory from remote filesystem server.

So now both PM1 and PM2 shares the remote shared directory.
Now if i create some process on PM1 it gets accessed by PM2.
When i try to create a new workspace using :
http://PM1/sysworkflow/en/neoclassic/install/newSite

i get this error :
Screenshot 2020-06-11 at 2.20.00 AM.png
Screenshot 2020-06-11 at 2.20.00 AM.png (31.6 KiB) Viewed 565 times
I checked the error logs of apace, php and mysql everywhere i cannot find any solution.
Any help would be highly appreciated.

Re: Cannot create a new workspace on PM : shows pop-up " MYSQ error:"

Posted: Wed Jun 10, 2020 5:14 pm
by pawansaxena
SOLVED
A simple mistake in granting permission for remote mysql user :
WITH GRANT OPTION

:)