[kleung]

Hi,

I am trying to migrate my PM development from Window Bitnami 3.2.1 to Linux Bitnami 3.2.1.
The Linux distro is OpenSUSE Leap 15.0.
I backup the mySQL of Window with the command
mysqldump -A -u root -p --events > backup.sql
from the Window Bitnami.

I then restore the backup.sql on the Linux Bitnami 3.2.1 with the command
mysql -u root -p < backup.sql
The processes and database definitions could be restored properly. The data in the database could not be restored.
The restored contents could be accessed and worked with different user accounts too.

Serious problem arose when the Linux machine is reboot. After reboot, the following error message came up when
http://localhost/sysworkflow/en/neoclassic/login/login
is accessed, disregarded from different user accounts or root account. (Apache and mySQL are running).

-------------- error message --------------------------
System Exception.
RuntimeException:

[wrapped: connect failed [Native Error: Access denied for user 'bn_processmaker'@'localhost' (using password: YES)] [User Info: bn_processmaker]]

1. At Propel::getConnection()
in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/gulliver/system/class.g.php line 1715
2. At G::sqlEscape()
in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/gulliver/system/class.g.php line 1780
3. At G::replaceDataField()
in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/gulliver/system/class.xmlform.php line 4440
4. At XmlForm_Field_JavaScript->render()
in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/gulliver/system/class.xmlformTemplate.php line 248
5. At xmlformTemplate->getFields()
in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/gulliver/system/class.xmlformTemplate.php line 332
6. At xmlformTemplate->printObject()
in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/gulliver/system/class.form.php line 240
7. At Form->render()
in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/gulliver/system/class.publisher.php line 276
8. At Publisher->RenderContent0()
in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/gulliver/system/class.publisher.php line 84
9. At Publisher->AddContent()
in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/workflow/engine/methods/login/login.php line 197
10. At require_once() in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/workflow/public_html/sysGeneric.php line 1045
11. At include() in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/workflow/public_html/app.php line 61

--------------------- error message end ---------------------------------

Grateful if I can be advise how to fix the problem.
Thousand Thanks.

cheers,
Karl

[amosbatto]

Did you follow these instructions to create your database user with the GRANT command in MySQL?

If so, then post the contents of your shared/sites/{workspace}/db.php file here so I can look at it.

Also, login to MySQL as root and get the contents of your mysql.user table:
mysql -u root -p
mysql> select * from mysql.user;
mysql> exit;

Post the output from the select command here.