Uploaded image for project: 'Service Orchestrator'
  1. Service Orchestrator
  2. SO-3002

Cannot connect to mariadb (so catalogdb). Password incorrect.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a Bug
    • Icon: Medium Medium
    • Guilin Release
    • Frankfurt Release

      Hello.

      After Frankfurt release installation we need to create our cloud resources in a MULTICLOUD mode.

      According to the latest document https://docs.onap.org/en/frankfurt/guides/onap-operator/cloud_site/openstack/index.html we should create a new row directly in catalogdb database through mysql. I entered the mariadb container,but then I tried to login to the database using the default credentials: so_admin/so_Admin123 got the error:

      ERROR 1045 (28000): Access denied for user 'so_admin'@'localhost' (using password: YES)

      Tried to login with root account:

      sh-4.2$ mysql --user=root --password=Aa123456
      ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

       

      sh-4.2$ mysql --user=root --password=Aa123456 --host portal-db was success
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 5578
      Server version: 10.4.13-MariaDB-1:10.4.13+maria~bionic mariadb.org binary distribution

      Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [(none)]>

      But cannot get any user. 

      MariaDB [(none)]> use mysql;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A

      Database changed
      MariaDB [mysql]> select * from user;
      ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist

       

      Is it possible,that so_admin password was autogenerated during installation using the master password? As I know in Frankfurt release all passwords generating during installation now.

      Can we use any API for cloud site create in SO data model? Or it possible just directly through database?

       

      The database pods in a good condition.

      onap-mariadb-galera-0 1/1 Running 0 7h54m
      onap-mariadb-galera-1 1/1 Running 0 7h52m
      onap-mariadb-galera-2 1/1 Running 1 7h50m

       

      The SO db config job was done.

      onap-so-mariadb-config-job-9vcxf 0/1 Completed 0 7h45m

       

       

       

       

       

            avpetr23 avpetr23
            avpetr23 avpetr23
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: