Questions and discussion about using ProcessMaker: user interface, running cases & functionality

Moderator: amosbatto

Hi folks,
when I try to create a report table, on an external mysql database, I get the following error:
Code: Select all
Exception: [wrapped: No driver has been registered to handle connection type: ]
If I select the workflow database I don't have any issue.
Thanks in advance.
Schermata del 2018-07-11 11-51-16.png
Schermata del 2018-07-11 11-51-16.png (66.22 KiB) Viewed 1669 times
Schermata del 2018-07-05 17-35-24.png
Schermata del 2018-07-05 17-35-24.png (107.19 KiB) Viewed 1669 times
I just tried creating a report in an external MySQL database using PM 3.2.1 Community and I didn't have a problem.
It might be that your MySQL user doesn't have permissions to connect from a remote domain or to create tables in the external database.

In your external MySQL database do this:
mysql -u root -p
mysql> grant all on *.* to 'USER'@'' identified by 'p4sSw0rD' with grant option;
mysql> exit;

Change USER to the name of your user, to the domain name or IP address of you ProcessMaker server, and p4sSw0rD to the password for your user.

Does that fix it?
That is weird. Issue the GRANT command again in MySQL. Then check the user permissions:
SELECT * from mysql.users;

Then, if you see the error again when creating the Report Table, see if the user permissions have changed.
I checked the user permission before and after the creation of a report table, result the permission doesn't change.
Another weird thing, I edit a working table and I get the attached error. :shock: (the table is on database!)
I don't think is a problem of grant or dirty data collected during the test cases.
Schermata del 2018-07-13 10-11-01.png
Schermata del 2018-07-13 10-11-01.png (22.23 KiB) Viewed 1261 times
Schermata del 2018-07-13 10-00-37.png
Schermata del 2018-07-13 10-00-37.png (64.02 KiB) Viewed 1261 times
Disable grid using JavaScript

Hi, I tried to disable the grid with JavaScript. […]


I used your example as a base to fixup my flow and[…]

There is a third parameter in the sendMessage() fu[…]