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 1456 times
Schermata del 2018-07-05 17-35-24.png
Schermata del 2018-07-05 17-35-24.png (107.19 KiB) Viewed 1456 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 1048 times
Schermata del 2018-07-13 10-00-37.png
Schermata del 2018-07-13 10-00-37.png (64.02 KiB) Viewed 1048 times
#815181
Please file a bug report about it at http://bugs.processmaker.com
The only thing that I can think of is that you might have a slow connection to the database and the connection might be timing out, but I don't know were in the code the timeout is set.

【Q/微信729926040】如以删除请点网页快照,专业办理德国/法国/英国/加拿大各大学高端精仿文[…]

【Q/微信729926040】如以删除请点网页快照,专业办理德国/法国/英国/加拿大各大学高端精仿文[…]

【Q/微信729926040】如以删除请点网页快照,专业办理德国/法国/英国/加拿大各大学高端精仿文[…]

【Q/微信729926040】如以删除请点网页快照,专业办理德国/法国/英国/加拿大各大学高端精仿文[…]