Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-4893

Migration User check fails for Azure based postgresql servers

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Affects Version/s: PDB 6.12.0
    • Fix Version/s: None
    • Component/s: PuppetDB
    • Labels:
      None
    • Template:
    • Method Found:
      Needs Assessment
    • QA Risk Assessment:
      Needs Assessment

      Description

      Due to the way the Azure Postgresql server usernames work the migration user check always fails.

      user in config file is of the format "username@hostname" the actual user in postgresql is "username", therefore the jdbc user and the config user will never match.

      clojure.lang.ExceptionInfo: Connected to database as "puppetdb", not migrator "puppetdb@servername" at puppetlabs.puppetdb.cli.services$require_db_connection_as.invokeStatic(services.clj:532)
              at puppetlabs.puppetdb.cli.services$require_db_connection_as.invoke(services.clj:527)
              at puppetlabs.puppetdb.cli.services$init_with_db$fn__37137.invoke(services.clj:577)
              at puppetlabs.puppetdb.cli.services$init_with_db.invokeStatic(services.clj:575)
              at puppetlabs.puppetdb.cli.services$init_with_db.invoke(services.clj:539)
              at puppetlabs.puppetdb.cli.services$start_puppetdb.invokeStatic(services.clj:830)
              at puppetlabs.puppetdb.cli.services$start_puppetdb.invoke(services.clj:791)
              at puppetlabs.puppetdb.cli.services$start_puppetdb_or_shutdown$fn__37359.invoke(services.clj:911)
              at puppetlabs.puppetdb.cli.services$start_puppetdb_or_shutdown.invokeStatic(services.clj:909)
              at puppetlabs.puppetdb.cli.services$start_puppetdb_or_shutdown.invoke(services.clj:904)
              at puppetlabs.puppetdb.cli.services$reify__37475$service_fnk__19248__auto___positional$reify__37486$fn__37489.invoke(services.clj:1016)
              at puppetlabs.puppetdb.utils$call_unless_shutting_down.invokeStatic(utils.clj:461)
              at puppetlabs.puppetdb.utils$call_unless_shutting_down.invoke(utils.clj:458)
              at puppetlabs.puppetdb.cli.services$reify__37475$service_fnk__19248__auto___positional$reify__37486.start(services.clj:1011)
              at puppetlabs.trapperkeeper.services$fn__19085$G__19066__19088.invoke(services.clj:9)
              at puppetlabs.trapperkeeper.services$fn__19085$G__19065__19092.invoke(services.clj:9)
              at puppetlabs.trapperkeeper.internal$fn__19580$run_lifecycle_fn_BANG___19587$fn__19588.invoke(internal.clj:196)
              at puppetlabs.trapperkeeper.internal$fn__19580$run_lifecycle_fn_BANG___19587.invoke(internal.clj:179)
              at puppetlabs.trapperkeeper.internal$fn__19609$run_lifecycle_fns__19614$fn__19615.invoke(internal.clj:229)
              at puppetlabs.trapperkeeper.internal$fn__19609$run_lifecycle_fns__19614.invoke(internal.clj:206)
              at puppetlabs.trapperkeeper.internal$fn__20225$build_app_STAR___20234$fn$reify__20246.start(internal.clj:605)
              at puppetlabs.trapperkeeper.internal$fn__20273$boot_services_for_app_STAR__STAR___20280$fn__20281$fn__20283.invoke(internal.clj:631)
              at puppetlabs.trapperkeeper.internal$fn__20273$boot_services_for_app_STAR__STAR___20280$fn__20281.invoke(internal.clj:629)
              at puppetlabs.trapperkeeper.internal$fn__20273$boot_services_for_app_STAR__STAR___20280.invoke(internal.clj:623)
              at clojure.core$partial$fn__5841.invoke(core.clj:2630)
              at puppetlabs.trapperkeeper.internal$fn__19654$initialize_lifecycle_worker__19665$fn__19666$fn__19816$state_machine__12357__auto____19841$fn__19844.invoke(internal.clj:249)
              at puppetlabs.trapperkeeper.internal$fn__19654$initialize_lifecycle_worker__19665$fn__19666$fn__19816$state_machine__12357__auto____19841.invoke(internal.clj:249)
              at clojure.core.async.impl.ioc_macros$run_state_machine.invokeStatic(ioc_macros.clj:973)
              at clojure.core.async.impl.ioc_macros$run_state_machine.invoke(ioc_macros.clj:972)
              at clojure.core.async.impl.ioc_macros$run_state_machine_wrapped.invokeStatic(ioc_macros.clj:977)
              at clojure.core.async.impl.ioc_macros$run_state_machine_wrapped.invoke(ioc_macros.clj:975)
              at clojure.core.async$ioc_alts_BANG_$fn__12572.invoke(async.clj:384)
              at clojure.core.async$do_alts$fn__12512$fn__12515.invoke(async.clj:253)
              at clojure.core.async.impl.channels.ManyToManyChannel$fn__7176$fn__7177.invoke(channels.clj:95)
              at clojure.lang.AFn.run(AFn.java:22)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
              at java.lang.Thread.run(Thread.java:748) 

       

      Ideally this check should be configurable or ignorable.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jon.law Jonathan Law
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Zendesk Support