[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

[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

[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

[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

[AmmarKamil]

Hi I have The Same Problem But The Page Is Not Found
I mean 127.0.0.1:2052

[mariasbarker]

Hi I have The Same Problem But The Page Is Not Found
I mean 127.0.0.1:2052
https://proessays.org/

Try running this command: "sudo less /var/log/mysql/error.log" for diagnosing the error based on the log’s contents.

[rachelgomez123]

Allowing connections to a remote MySQL server is set up in 3 steps:

Edit MySQL config file
Configure firewall
Connect to remote MySQL server

The process for installing MySQL from a ZIP Archive package is as follows:
Extract the main archive to the desired install directory.
Create an option file.
Choose a MySQL server type.
Initialize MySQL.
Start the MySQL server.
Secure the default user accounts.

Regards,
Rachel Gomez

[petergroft]

Step 1: Edit MySQL Config File.
Step 2: Set up a Firewall to Allow Remote MySQL Connection. Option 1: UFW (Uncomplicated Firewall) Option 2: FirewallD. Option 3: Open Port 3306 with iptables.
Step 3: Connect to Remote MySQL Server.

Regards,
Peter