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

Moderator: amosbatto

#815120
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.
M.
Attachments
Schermata del 2018-07-11 11-51-16.png
Schermata del 2018-07-11 11-51-16.png (66.22 KiB) Viewed 1689 times
Schermata del 2018-07-05 17-35-24.png
Schermata del 2018-07-05 17-35-24.png (107.19 KiB) Viewed 1689 times
#815135
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'@'123.45.56.78' identified by 'p4sSw0rD' with grant option;
mysql> exit;

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

Does that fix it?
#815162
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.
#815166
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.
Attachments
Schermata del 2018-07-13 10-11-01.png
Schermata del 2018-07-13 10-11-01.png (22.23 KiB) Viewed 1281 times
Schermata del 2018-07-13 10-00-37.png
Schermata del 2018-07-13 10-00-37.png (64.02 KiB) Viewed 1281 times

Hi everyone! I am trying to create a link to a ex[…]

Routing Rule

Could you please share a screenshot from your proc[…]

PM ONLY SHOWING SYSTEM

I didn't work on this version of PM but I could su[…]

radio has a data automatic

Make sure you have assigned a variable to the radi[…]