Page 1 of 1

Installation to remote MySQL

Posted: Wed Feb 20, 2013 4:55 pm
by talbech
Hi all,

Having issues using the installer to a remote MySQL server. Trying to connect even with 'root' fails with:
Code: Select all
Connection Error: unable to connect to MySQL using provided credentials.
Connection from command line to the MySQL server as root works fine.
Code: Select all
mysql -u root -p --host [hostname]
Any suggestions?

Thanks in advance,
Thomas

Re: Installation to remote MySQL

Posted: Mon Feb 25, 2013 11:56 am
by mjaenvar
Hi Talbech,


to try to connect to a remote mysql server you have to edit the db.php and you can find it in the next path:

/opt/processmaker/shared/sites/workflow
<?php
// Processmaker configuration
define ('DB_ADAPTER', 'mysql' );
define ('DB_HOST', 'your_ip_address of your mysql server' );
define ('DB_NAME', 'wf_workflow' );
define ('DB_USER', 'root' );
define ('DB_PASS', 'the root password of root of mysql' );
define ('DB_RBAC_HOST', 'your_ip_address of your mysql server' );
define ('DB_RBAC_NAME', 'rb_workflow' );
define ('DB_RBAC_USER', 'root' );
define ('DB_RBAC_PASS', 'the root password of root of mysql' );
define ('DB_REPORT_HOST', 'your_ip_address of your mysql server' );
define ('DB_REPORT_NAME', 'rp_workflow' );
define ('DB_REPORT_USER', 'root' );
define ('DB_REPORT_PASS', 'the root password of root of mysql' );
?>

and change:

your_ip_address of your mysql server
the root password of root of mysql

Tell me if that works for you

Best Regards
Max

Re: Installation to remote MySQL

Posted: Tue Mar 12, 2013 1:10 pm
by talbech
Thanks for your reply. You assume that I have already installed ProcessMaker and therefore can modify the db.php, correct?
I have actually not even gotten that far, since the installation process seems to support remote MySQL instance, but it just doesn't work. Having a local MySQL is an option, but we do have a fairly large MySQL cluster available, which would be nice to utilize.

Guess I could install a MySQL on the PM host during the install and then remove it once the remote MySQL host is configured. Is this this approach you would recommend?

Seems rather strange that the installation process support remote MySQL, but it isn't working. I cannot be the only one with this problem.

Thanks in advance

Re: Installation to remote MySQL

Posted: Tue Mar 12, 2013 4:25 pm
by mjaenvar
Hello talbech,

Yes I assumed that you already have installed ProcessMaker and you wanted to migrate the database to another server.


you can configure the database in the installation of ProcessMaker:

http://wiki.processmaker.com/index.php/ ... tion_Setup

here in the setup you can edit the database in host you put the name or ip of your database server.
in username the root or an user with root privileges in Mysql.
password: the password of that user.

if the setup doesn't work then install mysql in the same server of ProcessMaker and when is already set then change the data of db.php with the other database server information, that is my recommendation


Tell me if that works for you

Max

Re: Installation to remote MySQL

Posted: Sun Oct 04, 2020 7:21 am
by AmmarKamil
Hi I have The Same Problem But The Page Is Not Found
I mean 127.0.0.1:2052