Ask questions about installing and configuring ProcessMaker 3

Moderator: amosbatto

By PornesianParapio
#822214
Hi all.

Can anyone enlighten me how to connect the database? I already tried to configure it so many times but the result is unsuccessful.

This is the message I've got

Thank you
Attachments
Untitled.png
Add description
Untitled.png (27.26 KiB) Viewed 770 times
Last edited by PornesianParapio on Fri Dec 28, 2018 3:13 am, edited 1 time in total.
User avatar
By amosbatto
#822231
First verify that the username and password in MySQL are correct from the command line of your ProcessMaker server. Open a terminal (and go to the directory where Mysql is installed if using Windows) and enter the following command:
mysql -h ADDRESS -u USER -pPASSWORD DATABASE

Replace the parts in italics. For example:
mysql -h 127.0.0.1 -u jdoe [email protected] my_database

If you aren't able to login, then you might have a priveleges problem. Login as your "root" user in mysql and then use the GRANT command to set the password for the user and set that the user can login on the machine 127.0.0.1:
grant all on DATABASE.* to 'USER'@'ADDRESS' identified by 'PASSWORD' with grant option;

Replace the parts in italics. For example:
grant all on my_database.* to 'jdoe'@'127.0.0.1' identified by '[email protected]' with grant option;

If it still doesn't work, then verify that you don't have a firewall that is blocking port 3306. It is a good idea to turn off any firewall when testing. You can use netstat -tln in Linux or netstat -tn in Windows to verify if your server is using port 3306 and MySQL is listening.

Here is what I see on my Linux machine:
Code: Select all
# netstat -tln
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State      
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN     
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN 
You can check your my.cnf file for the port being used by MySQL.

Hi guys, Im using process maker 3.3.6-1 community […]

We are using the SAML plugin (see screenshot). Do[…]

Hi, I'm having some issues with the Android app. I[…]

$(aRows[i-1]).find("input[type=checkbox]&quo[…]