Page 1 of 1

MySQL COnection Permission Denied

Posted: Tue Feb 21, 2017 7:16 pm
by Stillwater
Hi everyone;

I have searched for the specific error the installation wizard is throwing (Connection Error: Permission Denied(13) here and come up dry.

So, in troubleshooting so far I have:

Reset the root password (and cleaned out other root accounts so that only localhost and 127.0.0.1 remain.
Enabled remote login for MySQL and logged in successfully with the root MySQL account
Connected to the local client from the command line using the -h switch to connect to 127.0.0.1

Everything is set up according to the instructions on the ProcessMaker site. (even found a few typos in that process LOL)

I am stumped. MySQL is accepting connections to local users but the install wizard won't connect.

Re: MySQL COnection Permission Denied

Posted: Wed Feb 22, 2017 1:39 pm
by amosbatto
ProcessMaker and MySQL are located on the same machine?
If so, login to MySQL as the root user and issue these commands:
mysql> grant all on *.* to 'root'@'localhost' identified by 'PASSWORD' with grant option;
mysql> grant all on *.* to 'root'@'127.0.0.1' identified by 'PASSWORD' with grant option;
Change PASSWORD to your root password.

If that doesn't work then change to your domain or IP ADDRESS. For example, if your domain is acme.com, then use:
mysql> grant all on *.* to 'root'@'acme.com' identified by 'PASSWORD' with grant option;

Second thing to check is whether MySQL is up and running. If using Linux:
service mysql status
or
service mysqld status

Check if your server is listening on port 3306 (standard MySQL port):
Code: Select all
$  netstat -an | grep 3306
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN
Go to another machine in your network and use nmap to check whether port 3306 is visible on your PM server. If not, you probably have set up a firewall blocking it.
Code: Select all
$ nmap -p 3306 www.processmaker.com

Starting Nmap 6.47 ( http://nmap.org ) at 2017-02-22 13:43 BOT
Nmap scan report for www.processmaker.com (104.20.71.114)
Host is up (0.00082s latency).
Other addresses for www.processmaker.com (not scanned): 104.20.70.114
PORT     STATE    SERVICE
3306/tcp filtered mysql

Nmap done: 1 IP address (1 host up) scanned in 8.25 seconds

Re: MySQL COnection Permission Denied

Posted: Fri May 17, 2019 9:10 am
by carlosbpm
Hello ,

I'm facing this same issue after applying the suggested commands in mysql.

Getting this message at the installation interface: "Connection Error: Permission denied (13) "

Thanks in advance for your assistance.

Re: MySQL COnection Permission Denied

Posted: Fri May 17, 2019 11:59 am
by amosbatto
carlosbpm wrote: Fri May 17, 2019 9:10 am I'm facing this same issue after applying the suggested commands in mysql.

Getting this message at the installation interface: "Connection Error: Permission denied (13) "
Operating system? Version of PM? Manual install or Bitnami install? Upgrade or new install?

Post the contents of your shared/sites/workflow/db.php file.

Re: MySQL COnection Permission Denied

Posted: Wed Aug 21, 2019 2:56 am
by livier
Hi,

I'm facing the same error and when I run :
Code: Select all
# netstat -an | grep 3306
tcp6       0      0 :::3306                 :::*                    LISTEN   
Processmaker and mysql are located on the same machine.
How can I fixe it please ?


I'm using centos 7 and ProcessMaker 3.3.10
I'm new with linux
Thanks in advance

Re: MySQL COnection Permission Denied

Posted: Wed Aug 21, 2019 11:24 pm
by amosbatto
livier,
Open the shared/sites/workflow/db.php file in your ProcessMaker installation. Then use the settings in that file to try to login to MySQL from the command line.

For example if your db.php file looks like this:
Code: Select all
<?php
// Processmaker configuration
  define ('DB_ADAPTER',     'mysql' );
  define ('DB_HOST',        'localhost' );
  define ('DB_NAME',        'wf_workflow' );
  define ('DB_USER',        'wf_5d2f8e59d4207' );
  define ('DB_PASS',        'gG5-cZ1_4V3bRnp' );
  define ('DB_RBAC_HOST',   'localhost' );
  define ('DB_RBAC_NAME',   'wf_workflow' );
  define ('DB_RBAC_USER',   'wf_5d2f8e59d4207' );
  define ('DB_RBAC_PASS',   'gG5-cZ1_4V3bRnp' );
  define ('DB_REPORT_HOST', 'localhost' );
  define ('DB_REPORT_NAME', 'wf_workflow' );
  define ('DB_REPORT_USER', 'wf_5d2f8e59d4207' );
  define ('DB_REPORT_PASS', 'gG5-cZ1_4V3bRnp' );
Then, in a terminal on your ProcessMaker server, enter this command:
mysql -u wf_5d2f8e59d4207 -h localhost -D wf_workflow -pgG5-cZ1_4V3bRnp
(change the parts in blue to match your configuration)

Can you login to MySQL using the configuration in your db.php file?

Re: MySQL COnection Permission Denied

Posted: Wed Aug 21, 2019 11:27 pm
by livier
Hi,

Thank you very much for your answer.
I have solved my problem by setting off SELINUX