[drmanuel]

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.

[amosbatto]

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?

[drmanuel]

Hi amosbatto,
I forget to say that I use root user to access the database.
Anyway I create another user and now it works.

Thank you amosbatto for your time!
M.

[drmanuel]

Update:
I create another process with same working parameters for connection of the old one, result the same errors occurs.
The old one still working.
Now I don't understand.
Thanks in advance.
M.

[amosbatto]

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.

[drmanuel]

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. (the table is on database!)
I don't think is a problem of grant or dirty data collected during the test cases.

[drmanuel]

UPDATE:
If I try to import a report table created in another process and then do "Do not import the report table", then I'm able to create the desired table!
I create a video to explain the process https://expirebox.com/download/b54a3c72 ... ba5b9.html , it's a workaround solution at this time.
Any idea to solve definitely?

[amosbatto]

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.

[drmanuel]

I dont think so because the database is on the same machine of process maker httpd daemon and wf_workflow database, the issue happen with localhost setting also.

[drmanuel]

Hi amosbatto,
this issue still present on 3.3.4-community. Also I think that this issue cause problems on mobile app.
It generates the error "Bad request: No connection params set for: <db-id of report tables>".
The report table works correctly if I use portal and if I delete it from designer then the mobile app goes.
All works correctly if I set report table on the workflow database but I want to have distinct db for reporting on the same instance where is the workflow database.
Could be a mysql driver problem?

[amosbatto]

Have you tried deleting the Report Table and then creating a new one?
If I import a process from another installation of ProcessMaker, I often have to do that.

If the Report Table is in the same database as the workspace, does it work correctly? (I don't think that using an external database for Report Tables is well tested.)

[drmanuel]

Yes amosbatto, I tried deleting and recreating a lot of times but nothing.
If the Report Table is in wf_workflow database everythings works.

[amosbatto]

drmanuel,
Can you post a link to your bug report on this issue?

[drmanuel]

This is the link of bug report https://bugs.processmaker.com/view.php?id=25449 .