[rohitambre]

Hi everyone,

I want to create multiple workspaces in my Processmaker I followed this https://wiki.processmaker.com/3.1/Workspaces .
but when I click on test, it keeps on loading and after 1 minute it gives following error

mysql-php-PM.png (8.35 KiB) Viewed 8828 times

It was throwing this error after exactly 1min so I increased mysql_timeout to 240s but still it is throwing this error.

I read this question on forum viewtopic.php?t=709062 but didn't help.

[amosbatto]

Are you using a Bitnami installation?
If so, then you need to follow these instructions:
https://www.pmusers.com/index.php/Creat ... tallations
(Of course, it is strongly recommended that you switch to a manual installation if you are using ProcessMaker in production.)

[rohitambre]

No, I'm using manual installation in CentOS.
PM version: 3.0.1.8-community-RE-1.8

[tomolimo]

No, I'm using manual installation in CentOS.
PM version: 3.0.1.8-community-RE-1.8

Hello rohitambre,
Are you really still using this old version of ProcessMaker?
Don't you plan to switch to 3.3.0-community-RE-1.4?
Thank you,
regards,
Tomolimo

[rohitambre]

Hi Tomolimo,
Actually this instance is already in use and I can't upgrade this instance at this moment but we need multiple workspaces

[tomolimo]

Ok,
Then, did you ensure that:
1. This requested php module is installed?
2. Mysql strict mode is off?

By the way, which version of mysql are you using?

[amosbatto]

If you didn't understand Tomolino's instructions, in the command line, do this:
php -m

Do you see "mysql" in the list?

See: https://wiki.processmaker.com/3.0/Chang ... trict_Mode

[rohitambre]

Yes, I have mysql php module and I also tried after setting sql_mode="" it is showing same error.

php version : 5.6.40
Mysql Server version: 5.7.22 MySQL Community Server

[tomolimo]

Hello rohitambre,

Don't you have any errors in the PHP error log?
Thank you,
Regards,
Tomolimo

[rohitambre]

Hi,
I have enabled php error logs from php.ini

error_log_page.png (10.79 KiB) Viewed 8783 times

But my error file is not getting generated at given location

[tomolimo]

Hello rohitambre,

Where did you get this screen copy?
Is it in the Admin part of your PM server like shown below?
or somewhere else?
Thank you,
Regards,
Tomolimo

[amosbatto]

You can also edit your env.ini file and add the line:
debug = 1
This will show you some types of errors in the ProcessMaker interface.

[rohitambre]

Hi tomolimo and amosbatto,
the screenshot shared in last comment is from processmaker admin menu only.

and tried setting

Code: Select all

debug = 1

in env.ini but it is not showing any error on screen or in php log file.

But I tried creating workspace on my other server where it got created successfully.

so one of the difference that I noticed is here my mysql is running on custom port and on the other sever it is running on default port i.e. 3306 is that causing a problem?
because this viewtopic.php?t=709062 forum question also had the same problem but I tried his solution it didn't work.

[amosbatto]

rohitambre,
Under Admin > Case List Cache Builder, did you include the port number in the "Host" field like "localhost:3307"? When you clicked on "Setup Password", did it accept the new configuration?

[rohitambre]

It shows Completed message but workspace creation still giving the same error.

[amosbatto]

Are you able to login from the command line?
mysql -u root -P 3307 -p