[itslenny]

https://url/sysworkspace/en/neoclassic/install/newSite

When I go to the newSite form and enter the new site details, I click on Test, the form processes for a second and then returns to the completed form. There are no messages to create a new site or any errors?

PM 3.1.3 community.

[amosbatto]

Have you changed the root password for MySQL (or whichever MySQL user was used when setting up the database for PM originally)?

If you didn't use the MySQL root user when first installing PM, you might need to give that user extra permissions to create new databases.
See:
http://wiki.processmaker.com/3.0/Proces ... figuration

[itslenny]

Hmm, not sure which user I used to be honest. The ProcessMaker application and MySQL databases have been migrated to different servers multiple times.

Can I check which user the form is trying to authenticate to MySQL with?

[amosbatto]

First of all, login to MySQL by entering this command line to verify that you still remember the root password:

Code: Select all

 mysql -u root -p

If you need to reset the root password, see: http://wiki.processmaker.com/3.0/Proces ... t_Password

Then, you can set that same root password here:
http://wiki.processmaker.com/index.php/ ... ot.22_user

[itslenny]

Setting the password in the case list cache builder fixed the new site generation. However, when I go to the new site I get an error

System Exception.

RuntimeException:
[wrapped: No driver has been registered to handle connection type: ]
At Propel::getConnection()
in /opt/processmaker/gulliver/system/class.g.php line 1707
At G::sqlEscape()
in /opt/processmaker/gulliver/system/class.g.php line 1773
At G::replaceDataField()
in /opt/processmaker/gulliver/system/class.xmlform.php line 4440
At XmlForm_Field_JavaScript->render()
in /opt/processmaker/gulliver/system/class.xmlformTemplate.php line 248
At xmlformTemplate->getFields()
in /opt/processmaker/gulliver/system/class.xmlformTemplate.php line 332
At xmlformTemplate->printObject()
in /opt/processmaker/gulliver/system/class.form.php line 240
At Form->render()
in /opt/processmaker/gulliver/system/class.publisher.php line 276
At Publisher->RenderContent0()
in /opt/processmaker/gulliver/system/class.publisher.php line 84
At Publisher->AddContent()
in /opt/processmaker/workflow/engine/methods/login/login.php line 197
At require_once() in /opt/processmaker/workflow/public_html/sysGeneric.php line 1030
At include() in /opt/processmaker/workflow/public_html/app.php line 61

[itslenny]

resolved by removing special characters from the assigned db password.