<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
</div>
<p dir="auto" style="margin: 0px 0px 16px; font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); color: rgb(47, 57, 65)">
Could be a MySQL8 issue. That being said, the error might be up father near the top in your log file, I don't see a good error in what you posted.</p>
<p dir="auto" style="margin: 0px 0px 16px; font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); color: rgb(47, 57, 65)">
Read the log from the top down, there will be something that is the first sign of trouble with MySQL, probably within 50 lines or so, that should explain it. </p>
<p dir="auto" style="margin: 0px 0px 16px; font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); color: rgb(47, 57, 65)">
MySQL 8 is a bit different. The GRANTS are a bit different:</p>
<pre dir="ltr" style="padding: 6px 10px; font-family: Consolas, "Liberation Mono", Menlo, "Bitstream Vera Sans Mono", Courier, monospace; font-size: 12.025px; color: rgb(104, 115, 125); border-radius: 3px; display: block; margin: 15px 0px; line-height: 19px; word-break: break-all; overflow-wrap: break-word; background: rgb(248, 249, 249); border: 1px solid rgb(194, 200, 204); outline: 0px"><code style="font-size: 12px; border-radius: 3px; background: none; margin: 0px; outline: 0px; word-break: break-word">CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON db1.* TO 'jeffrey'@'localhost';
</code></pre>
<p dir="auto" style="margin: 0px 0px 16px; font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); color: rgb(47, 57, 65)">
Also, the docs have this note:</p>
<pre dir="ltr" style="padding: 6px 10px; font-family: Consolas, "Liberation Mono", Menlo, "Bitstream Vera Sans Mono", Courier, monospace; font-size: 12.025px; color: rgb(104, 115, 125); border-radius: 3px; display: block; margin: 15px 0px; line-height: 19px; word-break: break-all; overflow-wrap: break-word; background: rgb(248, 249, 249); border: 1px solid rgb(194, 200, 204); outline: 0px"><code style="font-size: 12px; border-radius: 3px; background: none; margin: 0px; outline: 0px; word-break: break-word">NOTE: For MySQL 8. MySQL 8 uses a new method (caching_sha2_password) as the default authentication plugin instead of the old mysql_native_password that MySQL 5.7 and older used. This may require starting a MySQL 8 server with the --default-authentication-plugin=mysql_native_password option. You may also be able to change the auth mechanism on a per user basis by logging into mysql and running ALTER USER 'archivesspace' IDENTIFIED WITH mysql_native_password BY '123456';. Also be sure to have the LATEST MySQL Connector for Java from MySQL in your /lib/ directory for ArchivesSpace.
</code></pre>
<p dir="auto" style="margin: 0px 0px 16px; font-family: system-ui, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", Arial, sans-serif; font-size: 14px; line-height: 20px; outline: 0px; background: rgb(255, 255, 255); color: rgb(47, 57, 65)">
I have been able to run ArchivesSpace on 8, but it does have a couple small issues to work through sometimes.</p>
<div id="Signature">
<div id="divtagdefaultwrapper" dir="ltr" style="color:rgb(0,0,0); background-color:rgb(255,255,255)">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; margin:0px">
<font face="Calibri,Arial,Helvetica,sans-serif" size="3" color="black"><span dir="ltr" style="font-size:12pt; background-color:white"><font size="2"><span style="font-size:11pt"></span></font></span></font></div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Brian Sheppard
<brian.sheppard@wisc.edu><br>
<b>Sent:</b> Thursday, May 2, 2019 3:30 PM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] mysql db connection error</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText"><br>
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.<br>
<br>
AS runs normally when I use the default backend (when AppConfig[:db_url] is commented out). When uncommented,<br>
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.<br>
<br>
The connector is in lib:<br>
archivesspace_2_5_1/lib/mysql-connector-java-8.0.16.jar<br>
<br>
mysql: Ver 8.0.13 for osx10.12 on x86_64 (Homebrew)<br>
java: version "1.8.0_211"<br>
ruby 2.5.1p57 (2018-03-29 revision 63029) [x86_64-darwin16]<br>
jdbc-mysql gem: jdbc-mysql (5.1.42)<br>
<br>
Redacted config.rb line:<br>
AppConfig[:db_url] = "jdbc:mysql://localhost:3306/archivesspace?user=[adminuser]&password=[foo]&useUnicode=true&characterEncoding=UTF-8&useSSL=false"<br>
<br>
TRACE:<br>
Database connection failed from<br>
/archivesspace_2_5_1/gems/gems/sinatra-1.4.7/lib/sinatra/base.rb:1411:in `configure' from<br>
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<br>
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<br>
org/jruby/RubyKernel.java:961:in `require' from<br>
uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:55:in `require' from<br>
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<br>
org/jruby/RubyBasicObject.java:1687:in `instance_eval' from<br>
archivesspace_2_5_1/data/tmp/jetty-0.0.0.0-8089-backend.war-_-any-/webapp/WEB-INF/config.ru:4:in `(root)' from<br>
uri:classloader:/vendor/rack-1.6.8/rack/builder.rb:55:in `<main>' from<br>
launcher/launcher.rb:92:in `start_server' from<br>
launcher/launcher.rb:157:in `main' from<br>
launcher/launcher.rb:261:in `<main>'<br>
<br>
<br>
Thanks.<br>
-Brian<br>
<br>
—————————————————————————————<br>
Brian Sheppard<br>
UW Digital Collections Center<br>
brian.sheppard@wisc.edu<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
Archivesspace_Users_Group@lyralists.lyrasis.org<br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</div>
</span></font></div>
</body>
</html>