Ask questions about installing and configuring ProcessMaker 3

Moderator: amosbatto

By Stillwater
#789286
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.
User avatar
By amosbatto
#789314
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
By carlosbpm
#824486
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.
User avatar
By amosbatto
#824489
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.
".education" domain not supported

Worked like a charm.. I had no idea where this reg[…]

Wow, Thanks amazing to hear about it. :P I'm real[…]

Many Thanks :lol:

Thanks a lot. I'm not using that charts plugin. An[…]