In Azure I found I had to update the mariadb user table to add a wild card host to root (not sure why it isnt working for its own installation of that record)
Creating a user with all hosts didnt fix the issue mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'redacted_password'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; Sometimes I also have to run the scripts inside mariadb container https://jira.onap.org/browse/PORTAL-399?jql=project%20%3D%20PORTAL%20AND%20text%20~%20mariadb [bdfreeman1421]Brian Freeman<https://jira.onap.org/secure/ViewProfile.jspa?name=bdfreeman1421> added a comment - 06/Nov/18 3:13 PM I think I got it running in Azure: 1) manually added the root user without host and 2) ran the scripts by hand in the docker-entrypoint-initdb.d directory 3) adjust liveness period to more like 60 seconds across the board Portal came up but the applications were not enabled so it didnt work cleanly From: [email protected] <[email protected]> On Behalf Of Syed Atif Husain Sent: Wednesday, January 02, 2019 4:32 AM To: [email protected] Cc: Taranjit Singh <[email protected]> Subject: [onap-discuss] [portal] [oom] Casablanca -- Unable to access Maria DB from within the portal-db container Hi, We are installing Casablanca release on Azure using OOM ( Rancher). portal-db-config fails to start. Its infinitely stuck in initializing. On debugging found that Maria DB cannot be accessed from within the container Getting following error #mysql -u root -pAa123456 ERROR 1130 (HY000): Host '10.42.X.Y' is not allowed to connect to this MariaDB server However, able to run successfully kubectl n onap exec -it dev-portal-portal-db-b8db58679-q9pjq - mysql -D mysql -h localhost -e 'select * from user' Also opened a ticket https://jira.onap.org/browse/PORTAL-498?filter=-2<https://urldefense.proofpoint.com/v2/url?u=https-3A__jira.onap.org_browse_PORTAL-2D498-3Ffilter-3D-2D2&d=DwMFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=e3d1ehx3DI5AoMgDmi2Fzw&m=zrm6ZWeEYP8QG_p8OFQawzqtnrYtwvT93qQP1rqNODM&s=MmzzrVMTw4V8rZqwYtCeBOdlNoMWZHyHmeZ5rtLkI2A&e=> for the same. Kindly advise, if you have faced similar issue. Thanks. Regards, Atif -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#14749): https://lists.onap.org/g/onap-discuss/message/14749 Mute This Topic: https://lists.onap.org/mt/28912636/21656 Group Owner: [email protected] Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
