<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
All,<br>
<br>
I am trying to duplicate our Archivesspace production app in a local
Vagrant box.<br>
<br>
I am getting an "unable to connect to backend" error when it boots.<br>
<br>
I've checked to make sure the database is indeed present.<br>
<br>
I've checked permissions for the "archivesspace" user to the
"archivesspace" DB:<br>
<br>
<blockquote>
<blockquote>MariaDB [archivesspace]> SHOW GRANTS for
archivesspace@localhost;<br>
+----------------------------------------------------------------------------------------------------------------------+<br>
| Grants for
archivesspace@localhost
|<br>
+----------------------------------------------------------------------------------------------------------------------+<br>
| GRANT USAGE ON *.* TO `archivesspace`@`localhost` IDENTIFIED
BY PASSWORD '*2C2611CEB83E695935FB2CA67F9EE3D56514F1CC' |<br>
| GRANT ALL PRIVILEGES ON `archivesspace`.* TO
`archivesspace`@`localhost` WITH GRANT
OPTION |<br>
+----------------------------------------------------------------------------------------------------------------------+<br>
2 rows in set (0.000 sec)<br>
<br>
MariaDB [archivesspace]><br>
</blockquote>
</blockquote>
<br>
Then I do same for 127.0.0.1:<br>
<br>
<blockquote>
<blockquote>MariaDB [archivesspace]> SHOW GRANTS for
<a class="moz-txt-link-abbreviated" href="mailto:archivesspace@127.0.0.1">archivesspace@127.0.0.1</a>;<br>
+----------------------------------------------------------------------------------------------------------------------+<br>
| Grants for
<a class="moz-txt-link-abbreviated" href="mailto:archivesspace@127.0.0.1">archivesspace@127.0.0.1</a>
|<br>
+----------------------------------------------------------------------------------------------------------------------+<br>
| GRANT USAGE ON *.* TO `archivesspace`@`127.0.0.1` IDENTIFIED
BY PASSWORD '*2C2611CEB83E695935FB2CA67F9EE3D56514F1CC' |<br>
| GRANT ALL PRIVILEGES ON `archivesspace`.* TO
`archivesspace`@`127.0.0.1` WITH GRANT
OPTION |<br>
+----------------------------------------------------------------------------------------------------------------------+<br>
2 rows in set (0.000 sec)<br>
<br>
MariaDB [archivesspace]> <br>
</blockquote>
</blockquote>
<br>
I AM able to restore into the "archivesspace" database with:<br>
<br>
<blockquote>
<blockquote>sudo mysql -u archivesspace -pREDACTED archivesspace
< /vagrant/archivesspace_CURRENT.sql<br>
</blockquote>
</blockquote>
<br>
The connect string in my config.rb file:<br>
<br>
<blockquote>
<blockquote>AppConfig[:db_url] =
"jdbc:mysql://localhost:3306/archivesspace?user=archivesspace&password=REDACTED&useUnicode=true&characterEncoding=UTF-8"<br>
</blockquote>
</blockquote>
<br>
And yet I get the "unable to connect to backend" error. No fair!<br>
<br>
Advice in previous posts down through the years suggested this was a
permissions problem, or running MySQL on something other than
localhost/127.0.0.1, but I think what I've done above rules this
out.<br>
<br>
Are there other reasons why I might be getting the "unable to
connect to backend" error?<br>
<br>
Advice appreciated!<br>
<br>
Mark<br>
<br>
PS: I don't think this is relevant to the connection issue, but here
are the permissions I've set on the file system:<br>
<br>
<blockquote>
<blockquote>vagrant@vagrant:/usr/share/archivesspace$ ls -la<br>
total 84<br>
drwxr-xr-x 16 archivesspace archivesspace 4096 Jun 11 18:59 .<br>
drwxr-xr-x 122 root root 4096 Jun 11 18:59 ..<br>
-rwxr-xr-x 1 archivesspace archivesspace 813 Jun 11 18:54
archivesspace.bat<br>
-rwxr-xr-x 1 archivesspace archivesspace 5364 Jun 11 18:53
archivesspace.sh<br>
drwxr-xr-x 4 archivesspace archivesspace 4096 Jun 11 18:53
clustering<br>
drwxr-xr-x 2 archivesspace archivesspace 4096 Jun 11 21:05
config<br>
-rwxr-xr-x 1 archivesspace archivesspace 665 Jun 11 18:53
COPYING<br>
drwxr-xr-x 9 archivesspace archivesspace 4096 Jun 11 18:59
data<br>
drwxr-xr-x 14 archivesspace archivesspace 4096 Jun 11 18:54
docs<br>
drwxr-xr-x 9 archivesspace archivesspace 4096 Jun 11 18:54
gems<br>
drwxr-xr-x 8 archivesspace archivesspace 4096 Jun 11 18:54
launcher<br>
drwxr-xr-x 2 archivesspace archivesspace 4096 Jun 11 18:59 lib<br>
drwxr-xr-x 4 archivesspace archivesspace 4096 Jun 11 18:53
locales<br>
drwxr-xr-x 2 archivesspace archivesspace 4096 Jun 11 18:59
logs<br>
drwxr-xr-x 22 archivesspace archivesspace 4096 Jun 11 18:54
plugins<br>
-rwxr-xr-x 1 archivesspace archivesspace 2326 Jun 11 18:53
README.md<br>
drwxr-xr-x 12 archivesspace archivesspace 4096 Jun 11 18:53
reports<br>
drwxr-xr-x 3 archivesspace archivesspace 4096 Jun 11 18:54
scripts<br>
drwxr-xr-x 3 archivesspace archivesspace 4096 Jun 11 18:54
stylesheets<br>
drwxr-xr-x 2 archivesspace archivesspace 4096 Jun 11 18:54
wars<br>
vagrant@vagrant:/usr/share/archivesspace$ <br>
</blockquote>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Mark Cyzyk, M.A., M.L.S.
Library Applications Group
The Sheridan Libraries
The Johns Hopkins University
<a class="moz-txt-link-abbreviated" href="mailto:mcyzyk@jhu.edu">mcyzyk@jhu.edu</a>
Verba volant, scripta manent.
</pre>
</body>
</html>