Tuesday, January 30, 2018

[google-cloud-sql-discuss] Re: Access Denied from VB forums but able to connect from CLI

Well, after long hours of troubleshooting. I came to realize that it was SELinux creating the problem.
Here is how I was able to fix the issue.

# setsebool -P httpd_can_network_connect 1  # setsebool -P httpd_can_network_connect_db 1

On Tuesday, January 30, 2018 at 11:14:48 AM UTC-5, Sergio Rodriguez wrote:
Hey everyone, I have an issue and I need some guidance.
I created a new Google Cloud MySQL instance and assigned trusted networks and users. I also created a new VM instance and gave it "Allow full access to all Cloud APIs"

When I log in the VM's terminal, I am able to run #mysql -h "Google Cloud Mysql IP" -u root -p without problems.However, 
when I configure a web application such as vbulletin with the same username and password. The MySQL instance gives an access denied error.
2018-01-30T15:33:13.950478Z 804 [Note] Access denied for user 'root'@'xx.xx.xx.xx' (using password: YES) 
 
What could be causing this issues?

Thanks for the help,
Sergio 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/33afe7ff-1afe-4b3b-9f54-cd79c3f9778c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment