Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-6053

Allow use of other MySQL account thant 'qsmaster'

    Details

    • Type: Bug
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Story Points:
      4
    • Team:
      Data Access and Database

      Description

      'qsmaster' value can't be changed in qserv-meta.conf, this must be fixed

      diff --git a/admin/templates/installation/qserv-meta.conf b/admin/templates/installation/qserv-meta.conf
      index 81b6ca9..203ebda 100644
      --- a/admin/templates/installation/qserv-meta.conf
      +++ b/admin/templates/installation/qserv-meta.conf
      @@ -103,7 +103,7 @@ user_monitor = monitor
       password_monitor = CHANGEMETOO
       
       # Used to access Qserv data and metadata (like indexes)
      -user_qserv = qsmaster
      +user_qserv = qservdata
      

      Above change leads to next error in integration tests:

      154 [0x7f1beacf9700] ERROR lsst.qserv.sql.SqlConnection null - connectToDb failed to connect!
      154 [0x7f1beacf9700] ERROR lsst.qserv.sql.SqlConnection null - runQuery failed connectToDb: START TRANSACTION
      2016-05-10 14:55:09,684 - root - CRITICAL - Exception occured: Error from mysql: (-999) Error connecting to mysql with config:[host=127.0.0.1, port=13306, user=qsmaster, password=XXXXXX, db=qservCssData, socket=]
      Traceback (most recent call last):
        File "/home/dev/src/qserv/bin/qserv-data-loader.py", line 274, in <module>
          loader = Loader()
        File "/home/dev/src/qserv/bin/qserv-data-loader.py", line 225, in __init__
          css_inst = css.CssAccess.createFromConfig(config, "")
      CssError: Error from mysql: (-999) Error connecting to mysql with config:[host=127.0.0.1, port=13306, user=qsmaster, password=XXXXXX, db=qservCssData, socket=]
      2016-05-10 14:55:09,810 - lsst.qserv.admin.commons - CRITICAL - Error code returned by command : qserv-data-loader.py -v --config=/qserv/stack/Linux64/qserv_testdata/2016_01-1-g7b10791+7/datasets/case05/data/common.cfg --host=127.0.0.1 --port=5012 --secret=/home/dev/qserv-run/git/etc/wmgr.secret --delete-tables --config=/qserv/stack/Linux64/qserv_testdata/2016_01-1-g7b10791+7/datasets/case05/data/Object.cfg --css-remove --skip-partition --chunks-dir=/home/dev/qserv-run/git/tmp/qservTest_case05/chunks/Object --config=/qserv/stack/Linux64/qserv_testdata/2016_01-1-g7b10791+7/datasets/case05/data/Object.cfg --empty-chunks=/home/dev/qserv-run/git/var/lib/qserv/empty_qservTest_case05_qserv.txt qservTest_case05_qserv Object /qserv/stack/Linux64/qserv_testdata/2016_01-1-g7b10791+7/datasets/case05/data/Object.sql /home/dev/qserv-run/git/tmp/qservTest_case05/chunks/Object/Object.txt 
      ERROR
      

        Attachments

          Issue Links

            Activity

            Hide
            fritzm Fritz Mueller added a comment -

            Address as part of configuration cleanup for Qserv k8s deployment

            Show
            fritzm Fritz Mueller added a comment - Address as part of configuration cleanup for Qserv k8s deployment

              People

              • Assignee:
                Unassigned
                Reporter:
                jammes Fabrice Jammes
                Watchers:
                Andy Salnikov, Fabrice Jammes, Fritz Mueller, Jacek Becla
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Summary Panel