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

Database instantiation failed due to holmesdb password with single quote

    XMLWordPrintable

Details

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

    Description

      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?

       

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              GuangrongFu Guangrong Fu
              vm00344885 Venkata Molluru
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: