Uploaded image for project: 'Holmes'
  1. Holmes
  2. HOLMES-463

Database instantiation failed due to holmesdb password with single quote

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Medium Medium
    • Istanbul Release
    • Honolulu Release
    • None
    • None
    • Holmes Sprint 59

      Hi fu.guangrong
      If holmesdb password contains special char as single quote ex: Fonp2'GiluPifq which failed to instantiate database. The following logs are shown

      Initializing the holmes rule management database...
      GRANT ALL PRIVILEGES ON APLUS_RULE TO holmes;
      dbname=holmes
      user=holmes
      password=Fonp2'GiluPifq
      port=5432
      host=holmes-postgres-primary
      You are now connected to database "postgres" as user "holmes".
      psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql:19: ERROR:  permission denied to create database
      psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql:57: ERROR:  unrecognized role option "gilupifq"
      LINE 1: CREATE ROLE holmes with PASSWORD 'Fonp2'GiluPifq' LOGIN;
                                                      ^
      ERROR:  relation "aplus_rule" does not exist
      LINE 1: select * from aplus_rule;
                            ^
      sql_result=1
      Failed to initialize the database!
      

       Could you please take a look?

       

            guangrongfu guangrongfu
            vm00344885 vm00344885
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: