ProcessMaker Forum | BPM Workflow Simplified

Posted: **Tue Feb 21, 2017 7:16 pm**

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.

Posted: **Wed Feb 22, 2017 1:39 pm**

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

Posted: **Fri May 17, 2019 9:10 am**

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.

Posted: **Fri May 17, 2019 11:59 am**

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.

Posted: **Wed Aug 21, 2019 2:56 am**

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

Posted: **Wed Aug 21, 2019 11:24 pm**

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?

Posted: **Wed Aug 21, 2019 11:27 pm**

Hi,

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

Posted: **Tue Sep 24, 2019 5:32 am**

I am also facing this type of issue on my Windows 10. I can't find out the cause but hopefully, Windows store cache may be damaged. This is not working properly so I am looking for the proper solution.

Posted: **Thu Dec 26, 2019 11:43 pm**

Stillwater wrote: ↑Tue Feb 21, 2017 7:16 pm Hi everyone;

I have searched for the specific error the Speed Test Scrabble Word Finder Solitaire 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.

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

Posted: **Sat Sep 12, 2020 6:13 am**

Great Information

Posted: **Wed Nov 04, 2020 5:09 am**

Sometimes you may want to add a remote user to MySQL, you try to connect remotely but your MySQL server returns something like access denied for 'user'@'192.168. 0.10'. The most probable cause for this is that you didn't grant the host or ip address of the user permission to use the server.

Posted: **Wed Aug 25, 2021 7:36 am**

An Advance Youtube To Mp3 Converter To Convert/Download YouTube Videos to MP3 or MP4 Format Easily, Safe & Secure, and in High-Quality Mp3 files for free. [url=https://ytconvertmp3.com/youtube-to-mp3]YouTube To Mp3 Converter - Safe & Fast Youtube to Mp3 • No limit[/url] Best YouTube To Mp3 Converter - Fast, Free, No limit!

How To Convert YouTube To MP3?

Copy The Desire YouTube Video Url You Want To Download.

Paste Youtube Video {Url / Link} In The Box To Get High-Quality Mp3 Audio Files.

Click the "Download" button and wait a few seconds.

Select a video format from the list and click the "Download" button.

ProcessMaker Forum | BPM Workflow Simplified

MySQL COnection Permission Denied

MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied

Re: MySQL COnection Permission Denied