[Archivesspace_Users_Group] MySQL issue

[Blake Carver]

> During troubleshooting an issue with Preservica not being able to connect

What's wrong with Preservica? What's the errors from the logs? The answer is here probably.

>I find that while the archivesspace database is in mysql, and there is an archivesspace user with a password
> there are no grants listed for that user to the archivesspace database.

That's only done once, when you set up ArchivesSpace the first time:
https://archivesspace.github.io/tech-docs/provisioning/mysql.html

> The instructions for migrating said to run the setup-database.sh script, nothing about having
>to grant permissions or setting the default character encoding or such.

That's correct, there is no reason to change anything in MySQL for 2.8.

> One thing that I did notice as I looked in the user table in the archivesspace database.
> There is no archivespace user listed when I select all.

That's also correct. The MySQL user/password defined in config.rb are not in the archivesspace database, they are in the mysql database.

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Neal, Rick <rneal at richmond.edu>
Sent: Thursday, October 8, 2020 8:55 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] MySQL issue

Good morning,

I am having an issue after having upgraded our aspace instance on a new server.  I followed the instructions for the database migration and I thought everything was working fine.  During troubleshooting an issue with Preservica not being able to connect I find that while the archivesspace database is in mysql, and there is an archivesspace user with a password,  there are no grants listed for that user to the archivesspace database.  The instructions for migrating said to run the setup-database.sh script, nothing about having to grant permissions or setting the default character encoding or such.

This is what I have done:

I log in to mysql as root with the mysql root password.
I show the databases and see the archivesspace database.
I then run  grant all on archivesspace.* to 'someuser'@'localhost' identified by 'somepassword';
I then FLUSH PRIVILEGES;
I then SHOW GRANTS;

It only lists the grants for the root user.  Nothing about the archivesspace database or user.
Also, again, I did nothing about the encoding when I did the install, just assuming the script handled that.

I tried changing to the archivesspace database and granting again with the same results.

One thing that I did notice as I looked in the user table in the archivesspace database.  There is no archivespace user listed when I select all.  There are the staff accounts so I know the database migration took place.

Thank you for your assistance.

Rick Neal
University of Richmond



_______________________________________________
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group at lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20201008/1d337fa7/attachment.html>