Unable to restore workspace
Posted: Mon Jan 28, 2019 5:07 am
Hi,
I have done some development with Bitnami PM community version 3.2.1-0 on Window 10. I'm going to migrate the development to Linux also using Bitnami PM community version 3.2.1-0.
The line
lower_case_table_names = 1
is added to my.cnf
The workflow.tar file is located at /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/shared/backups
Then after issuing the command
WIL:/opt/processmaker-3.2.1-0/apps/processmaker/htdocs # /opt/processmaker-3.2.1-0/php/bin/php processmaker workspace-restore -o workflow
The following messages came up.
Restoring from /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/shared/backups/workflow.tar
Found 1 workspaces in backup:
-> workflow.meta
Warning: A workspace from a newer version of ProcessMaker can NOT be restored in an older version of
ProcessMaker. For example, restoring from v.3.0 to v.2.5 will not work. However, it may be possible
to restore a workspace from an older version to an newer version of ProcessMaker, although error
messages may be displayed during the restore process.
> Restoring workflow to workflow
> Workspace workflow already exist, overwriting!
+> Restoring directory 'workflow.files'
> Changing file permissions
> Connecting to system database in 'localhost'
+> Restoring database bitnami_pm to bitnami_pm
> Verify files enterprise old...
Without changes...
<*> Verify took 0.00099515914916992 seconds.
> Verify License Enterprise...
An internal error occurred #1548662496. Please contact your system administrator for more information.
However, I could not find the error message of #1548662496 either from PM or Bitnami website.
I also found the following two lines in my console.
PHP Notice: Undefined property: workspaceTools::$dbGrantUserPassword in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/workflow/engine/classes/class.wsTools.php on line 1786
PHP Notice: Undefined property: workspaceTools::$dbGrantUserPassword in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/workflow/engine/classes/class.wsTools.php on line 1787
When I tried to login the PM with a browser, the following error message came up.
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
Grateful if I can be advised to fix the problem and restore the workspace.
Thousand Thanks.
cheers,
Karl
I have done some development with Bitnami PM community version 3.2.1-0 on Window 10. I'm going to migrate the development to Linux also using Bitnami PM community version 3.2.1-0.
The line
lower_case_table_names = 1
is added to my.cnf
The workflow.tar file is located at /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/shared/backups
Then after issuing the command
WIL:/opt/processmaker-3.2.1-0/apps/processmaker/htdocs # /opt/processmaker-3.2.1-0/php/bin/php processmaker workspace-restore -o workflow
The following messages came up.
Restoring from /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/shared/backups/workflow.tar
Found 1 workspaces in backup:
-> workflow.meta
Warning: A workspace from a newer version of ProcessMaker can NOT be restored in an older version of
ProcessMaker. For example, restoring from v.3.0 to v.2.5 will not work. However, it may be possible
to restore a workspace from an older version to an newer version of ProcessMaker, although error
messages may be displayed during the restore process.
> Restoring workflow to workflow
> Workspace workflow already exist, overwriting!
+> Restoring directory 'workflow.files'
> Changing file permissions
> Connecting to system database in 'localhost'
+> Restoring database bitnami_pm to bitnami_pm
> Verify files enterprise old...
Without changes...
<*> Verify took 0.00099515914916992 seconds.
> Verify License Enterprise...
An internal error occurred #1548662496. Please contact your system administrator for more information.
However, I could not find the error message of #1548662496 either from PM or Bitnami website.
I also found the following two lines in my console.
PHP Notice: Undefined property: workspaceTools::$dbGrantUserPassword in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/workflow/engine/classes/class.wsTools.php on line 1786
PHP Notice: Undefined property: workspaceTools::$dbGrantUserPassword in /opt/processmaker-3.2.1-0/apps/processmaker/htdocs/workflow/engine/classes/class.wsTools.php on line 1787
When I tried to login the PM with a browser, the following error message came up.
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
Grateful if I can be advised to fix the problem and restore the workspace.
Thousand Thanks.
cheers,
Karl