The docker-config repo has a gug in the 01-CREATE sql script (and a couple others).
DROP USER is failing I think Try to run the script inside the mariadb container and you should see the problem Delete the DROP USER lines in the scripts and then run them in order 01, 02, 03 .. Then do kubectl delete on the non-mariadb so containers https://jira.onap.org/browse/SO-1674 is tracking this pesky issue. Brian From: [email protected] <[email protected]> On Behalf Of subhash kumar singh Sent: Tuesday, March 26, 2019 1:23 AM To: bharath thiruveedula <[email protected]>; [email protected]; [email protected] Cc: Seshu m <[email protected]> Subject: Re: [onap-discuss] [SO] : error in creating local enviroment using deploy.sh Hello Bharath and Marcus, I tried as per your suggestion, but still catalog-db-adapter is not up for me. It exits with same error "Access denied for user `${DB_ADMIN_USERNAME}" , and I see this should be override by override.yml (user should be used cataloguser as specified in override.yml). I can see the cataloguser in db as well. Could you please check in your local setup if you use cataloguser or any different configuration in override.yml. -- Regards, Subhash Kumar Singh From: bharath thiruveedula [mailto:[email protected]] Sent: Tuesday, March 26, 2019 2:14 AM To: Subhash Kumar Singh; [email protected]<mailto:[email protected]>; [email protected]<mailto:[email protected]> Cc: Seshu m Subject: Re: [onap-discuss] [SO] : error in creating local enviroment using deploy.sh Hi Subash, I faced this issue. Better to launch mariadb container alone first and wait till you login to mariadb prompt. Check all the dbs got created. In my case, it wasn't. So I manually ran all the sh files in https://git.onap.org/so/docker-config/tree/volumes/mariadb/docker-entrypoint-initdb.d<https://urldefense.proofpoint.com/v2/url?u=https-3A__git.onap.org_so_docker-2Dconfig_tree_volumes_mariadb_docker-2Dentrypoint-2Dinitdb.d&d=DwMFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=e3d1ehx3DI5AoMgDmi2Fzw&m=0UiWhc3wYXkQfiEegajpy6eBAyeIemdoyUnLO23ApcI&s=H6ZpOKdVib78DsEXK5JHsxKlbVDLPRacRhVwwZX6xTw&e=> And then run "docker-compose up -d catalog-db-adapter", "docker-compose up -d request-db-adapter" and so on. Best Regards Bharath T ________________________________ From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Marcus G K Williams <[email protected]<mailto:[email protected]>> Sent: Monday, March 25, 2019 11:34 PM To: [email protected]<mailto:[email protected]>; [email protected]<mailto:[email protected]> Cc: Seshu m Subject: Re: [onap-discuss] [SO] : error in creating local enviroment using deploy.sh It looks like you need to define ${DB_ADMIN_USERNAME} in the environment. I can't remember what this is by default but you could probably find it in overrides.yml for SO. Thanks, Marcus Williams IRC, Twitter, etc. @ mgkwill Intel Corp. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of subhash kumar singh Sent: Monday, March 25, 2019 7:44 AM To: [email protected]<mailto:[email protected]> Cc: Seshu m <[email protected]<mailto:[email protected]>> Subject: [onap-discuss] [SO] : error in creating local enviroment using deploy.sh Hello team, I am trying to create local SO environment[1] (master branch), but I see that catalogs-db-adapter exits with following exception: Caused by: java.sql.SQLException: Access denied for user '${DB_ADMIN_USERNAME}'@'172.23.0.3' (using password: YES) Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding' at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:854) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:777) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:451) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1109) ... 38 common frames omitted Could someone please let me know if there are some changes need to be done. [1] https://github.com/onap/so/blob/master/docs/developer_info/Working_with_SO_Docker.rst<https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_onap_so_blob_master_docs_developer-5Finfo_Working-5Fwith-5FSO-5FDocker.rst&d=DwMFAg&c=LFYZ-o9_HUMeMTSQicvjIg&r=e3d1ehx3DI5AoMgDmi2Fzw&m=0UiWhc3wYXkQfiEegajpy6eBAyeIemdoyUnLO23ApcI&s=cYYI_O_wjqmOos1L9ob6REV_LxWUN0W4FcfTIOcXVoE&e=> -- Regards, Subhash Kumar Singh FNOSS, ONAP Huawei Technologies India Pvt. Ltd. Survey No. 37, Next to EPIP Area, Kundalahalli, Whitefield Bengaluru-560066, Karnataka Tel: + 91-80-49160700 Ext 70992 II Mob: 8050101106 Email: [email protected]<mailto:[email protected]> [cid:[email protected]] ________________________________ This e-mail and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#16329): https://lists.onap.org/g/onap-discuss/message/16329 Mute This Topic: https://lists.onap.org/mt/30751239/21656 Group Owner: [email protected] Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
