[Archivesspace_Users_Group] mysql db connection error

[Brian Sheppard]

I'm having a problem connecting to a localhost mysql backend and, despite having perused a number of related threads, can't get it to work. I'd appreciate any insight.

AS runs normally when I use the default backend (when AppConfig[:db_url] is commented out). When uncommented,
I get a db connection error, though I can connect to the db via the mysql command-line using the same credentials specified in config.rb. The user has all privileges on the archivesspace db. Also, I see nothing in my mysql_error.log beyond startup comments.

The connector is in lib:
archivesspace_2_5_1/lib/mysql-connector-java-8.0.16.jar

mysql:  Ver 8.0.13 for osx10.12 on x86_64 (Homebrew)
java: version "1.8.0_211"
ruby 2.5.1p57 (2018-03-29 revision 63029) [x86_64-darwin16]
jdbc-mysql gem: jdbc-mysql (5.1.42)

Redacted config.rb line:
AppConfig[:db_url] = "jdbc:mysql://localhost:3306/archivesspace?user=[adminuser]&password=[foo]&useUnicode=true&characterEncoding=UTF-8&useSSL=false"

TRACE:
Database connection failed from
/archivesspace_2_5_1/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1411:in `configure' from
archivesspace_2_5_1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:78:in `<class:ArchivesSpaceService>' from
rchivesspace_2_5_1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/app/main.rb:38:in `<main>' from
 org/jruby/RubyKernel.java:961:in `require' from
 uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:55:in `require' from
 archivesspace_2_5_1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:1:in `block in (root)' from
 org/jruby/RubyBasicObject.java:1687:in `instance_eval' from
 archivesspace_2_5_1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:4:in `(root)' from
 uri:classloader:/vendor/rack-1.6.8/rack/builder.rb:55:in `<main>' from
 launcher/launcher.rb:92:in `start_server' from
 launcher/launcher.rb:157:in `main' from
 launcher/launcher.rb:261:in `<main>'


Thanks.
-Brian

—————————————————————————————
Brian Sheppard
UW Digital Collections Center
brian.sheppard at wisc.edu