FIXED

[bakahf]

Hi, I'm trying to help my friend with his hotel, he is running AtomCMS and Arcturus on an OVH vps.
When trying to connect to the server DB using the information from the config.ini file we get this error
(Only thing we do different is that we use the OVH/VPS IP to connect instead of localhost)
connection refused: getsockopt


I got no clue what to do to fix it, can someone help with that?
Best regards

 

[React]

What database setup are you using? MariaDB? Navicat? ensure that the necessary ports are actually open via your Firewall double check that credentials you have entered are actually correct. Check other error logs for more detailed errors.

 

[React]

Ty for the reply. He says MariaDB or MySQL, he has tried with Dbeaver and heidiSQL.
In terms of the Firewall and ports, that's inside of his OVH settings right?

It'll be on the actual server he is using, he will be able to open/close the necessary ports via the Firewall. For example, if it was a Windows server, he'd go to Firewall > "Create a new inbound rule" > Click inbound rules > select port for rule type > enter a name for the rule e.g EMU and then the port number you wish to open and choose between TCP or UDP (you'll want TCP) if it is anything client-related. You can also use commas to open several ports at one time e.g. "3306, 30000" this would open 3306 and 30000 at the same time, but you won't have the "'s when you enter them on your server environment.

 

[bakahf]

fixed

 

[React]

fixed

Please share your solution, it may help others who might encounter similar or the same issue as you.

 

[bakahf]

Please share your solution, it may help others who might encounter similar or the same issue as you.

Sure!

I had to change the bind address within the mariadb 50-server.cnf file to 0.0.0.0 instead of 127.0.0.1 - Then save and restart MariaDB
After that I had to go into MariaDB using sudo mysql -u root -p and then run this: SELECT user, host FROM mysql.user;
to then change the allowed connection for the root user from localhost to anywhere
GRANT ALL PRIVILEGES ON . TO 'namehere'@'%' IDENTIFIED BY 'passwordhere';
Save using FLUSH PRIVILEGES;


Then restart mariadb again and then it worked