topic Re: Verify the DataBase settings are valid Error in Expedition Discussions

Verify the DataBase settings are valid Error

aalaridRF — Mon, 19 Jul 2021 20:58:40 GMT

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

Re: Verify the DataBase settings are valid Error

lychiang — Mon, 19 Jul 2021 21:27:20 GMT

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

sudo service mysql restart

Re: Verify the DataBase settings are valid Error

aalaridRF — Tue, 20 Jul 2021 16:02:35 GMT

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:

Re: Verify the DataBase settings are valid Error

lychiang — Tue, 20 Jul 2021 16:23:28 GMT

@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.

Re: Verify the DataBase settings are valid Error

aalaridRF — Tue, 20 Jul 2021 17:41:48 GMT

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.

Re: Verify the DataBase settings are valid Error

aalaridRF — Mon, 26 Jul 2021 15:53:40 GMT

Is there anything else I can try? Just updated to the latest beta and still no change.

Re: Verify the DataBase settings are valid Error

azuniga — Mon, 26 Jul 2021 16:36:37 GMT

Hello @aalaridRF

Once you change it to 127.0.0.1 go ahead and hit the save button located at the bottom right of the page. Most likely you may not have done that so it can save the new updated IP address.

Re: Verify the DataBase settings are valid Error

aalaridRF — Mon, 26 Jul 2021 17:46:02 GMT

Thanks for the post. Save was definitely clicked, got the Data Saved popup afterwards but when I change tabs and click back into Settings > M.Learning the IP has reverted to the previous IP. Is there anywhere else I need to change the IP?

Re: Verify the DataBase settings are valid Error

azuniga — Mon, 26 Jul 2021 18:07:51 GMT

Are you reaching expedition with a NAT'd IP address? If so reference the IP address prior to being NAT'd, alter it to the IP address of the expedition server and see if anything changes. That IP address should be located within the CLI "ifconfig | grep inet".

Re: Verify the DataBase settings are valid Error

aalaridRF — Mon, 26 Jul 2021 19:00:32 GMT

IP address isn't NAT'd, it is the same IP I get when I run the ifconfig. I see both the assigned IP and the 127.0.0.1 listed for inet.

Re: Verify the DataBase settings are valid Error

azuniga — Mon, 26 Jul 2021 19:31:10 GMT

Hello @aalaridRF

When you log into your expedition server what IP address does it show at the top?

Re: Verify the DataBase settings are valid Error

LukasB — Wed, 16 Aug 2023 14:37:17 GMT

Hello,

I am on version 1.2.70 and I have same error message:

Your database is listening for incomming connections from only '' (IP:port)
Remediation: Verify you have proper settings for database connections. (see ML gets stuck at "Pending" )

But according to the mysql it is ok.

However, if I try to import config from CISCO, it is freezed on "initializing".

Re: Verify the DataBase settings are valid Error

lychiang — Wed, 16 Aug 2023 15:37:00 GMT

Hi @LukasB Please verify if the agent is up and running, you can go to dashboard and it should show you agent status , if it's down, trying to restart it .

Re: Verify the DataBase settings are valid Error

marianneogorman — Thu, 14 Sep 2023 12:40:21 GMT

anyone figure out how to fix this error?

Re: Verify the DataBase settings are valid Error

dpuigdomenec — Thu, 14 Sep 2023 13:59:35 GMT

Hi @marianneogorman

Try to locate file /etc/mysql/mariadb.conf.d/50-server.cnf and comment line bind-address.Then restart the mysql service.

If the issue persists please send and email to fwmigrate@paloaltonetworks.com

Hope this helps,

David

Re: Verify the DataBase settings are valid Error

marianneogorman — Fri, 15 Sep 2023 17:07:59 GMT

thanks David, i tried this error still there

Re: Verify the DataBase settings are valid Error

dpuigdomenec — Mon, 18 Sep 2023 07:27:54 GMT

Hi @marianneogorman, thanks for reaching out.

We are following your case by email. Please check my last answer for regarding Docker installation and let us know if you have any other issues.
Best regards,
David