Verify the DataBase settings are valid Error

[aalaridRF]

Hello, I'm on version1.1.103 of Expedition and I am unable to remediate this error: "Your database is listening for incomming connections from only '127.0.0.1:3306' (IP:port)
Remediation: Verify you have proper settings for database connections. (see ML gets stuck at "Pending" )'

When I select their recommended remediation instructions and try to follow the steps, /etc/mysql/my.cnf file doesn't have the field for bind-address at all and I checked all the other db files and couldn't find it either. How can I go about getting this resolved? What is supposed to be set?

Thanks

[lychiang]

Hi @aalaridRF Try restart the mysql service by issuing below commands:

sudo service mysql restart

[aalaridRF]

I tried a restart and a full stop/start of mysql and still no difference. Here's what shows up in the my.cnf through vi:

[lychiang]

@aalaridRF  Please try to change the IP address to 127.0.0.1 and click on save.  when you navigate to other tab and come back , it should show the expedition real IP in the field instead of the 127.0.0.1. 

 

[aalaridRF]

Changed to the loopback address, saved, and then switched tabs. Came back and it changed back to the real IP that it was before. Still shows the same error on the Dashboard after rescanning. Tried opening the my.cnf again and now I get this screen: 

Even tried restarting the mysql service again.