[Archivesspace_Users_Group] MySQL issue

[Neal, Rick]

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@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Re: [Archivesspace_Users_Group] spreadsheet imports in 2.8v SUI

[Christine Di Bella]

Hello Anna,

The team was talking about this yesterday. We’re expecting to put out a release 
with the improvements to the spreadsheet importer in early November.

Christine

From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Anna 
Robinson-Sweet
Sent: Wednesday, October 7, 2020 5:11 PM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] spreadsheet imports in 2.8v SUI

Hi Christine,

Following up on your exchange with Wendy regarding the improved spreadsheet 
importer. Do you know when we can expect the next version of ArchivesSpace will 
be released?

Thanks,
Anna

On Thu, Oct 1, 2020 at 9:45 AM Christine Di Bella 
mailto:christine.dibe...@lyrasis.org>> wrote:
Hi Wendy,

That’s great to hear. The improved importer will be in the next version of 
ArchivesSpace.

I understand that Bobbi Fox, the original developer of this functionality, has 
been in touch with you. She confirmed that what you’re trying to do is not 
supported. Now that the importer is in ArchivesSpace, new feature requests 
would be evaluated through our regular development prioritization process. You 
can file a feature request by following the instructions at 
https://archivesspace.atlassian.net/wiki/spaces/ADC/pages/19202060/How+to+Request+a+New+Feature.

Christine

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Wendy Scheir
Sent: Wednesday, September 30, 2020 3:28 PM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] spreadsheet imports in 2.8v SUI

Hi Christine,

Thank you for your reply. Yes! I was able to successfully import both 
spreadsheets in the sandbox! No error messages. Is there a patch that we can 
apply to our instance to make this work for us?

This does, however, lead me to another question. We are hoping to use the File 
version URI field to enter an internal file path (not an actual link), and I 
thought that if I used column BL on the import spreadsheet (column K on the DO 
spreadsheet) that the file path would populate the URI field--alas, it doesn't. 
But I don't see another field on the spreadsheet where one can place the 
non-linking file path to have it populate the URI field. Is there one that I'm 
just not interpreting properly?

Many thanks,
Wendy



WENDY SCHEIR
DIRECTOR

[https://docs.google.com/uc?export=download&id=16Nic6T4ZK1k1BhLOUToez7KP5Tzv8f9o&revid=0B4enrSUaFYtfdnV0R3E3bEkvek9LUVdsbkRIVUNJaXh1MU9VPQ]

66 5TH AVENUE, NEW YORK, NY 10011
sche...@newschool.edu

T 212.229.5942 x2888

Explore the Archives | Digital 
Collections from the Archives | 
New School Histories | 
@tnsarchives


On Wed, Sep 30, 2020 at 2:43 PM Christine Di Bella 
mailto:christine.dibe...@lyrasis.org>> wrote:
Hi Wendy,

Can you try importing your file into a dummy record on our test server: 
http://test.archivesspace.org/staff/? (username admin, password admin)

We’ve been working on a number of changes to the importer based on feedback 
since 2.8.0. The pretty_inspect message usually means there’s a data error that 
should be caught by the logging process that shows up post-import. Some errors 
were not accounted for in the version in 2.8.0 so you get that message instead 
of the error, but should be there. The digital objects issue is not familiar to 
me, but I’m wondering if that may be different there too.

You’ll start the import the same way you usually would on the test server, but 
it will move the process over to a background job so that it can run more 
quickly and the log is more easily downloadable afterwards. If you need any 
more guidance on that, please let me know.

Christine

Christine Di Bella
ArchivesSpace Program Manager
christine.dibe...@lyrasis.org
800.999.8558 x2905
678-235-2905


[ASpaceOrgHomeMedium]



From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Wendy Scheir
Sent: Wednesday, September 30, 2020 2:14 PM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] spreadsheet imports in 2.8v SUI

Hi,

In addition to the DO import spreadsheet error that I indicated in my recent 
email re: duplicate field codes, another error message I'm receiving in trying 
to import the DOs is: "{"error":"undefined method `pretty_inspect' for #"}"

I'd be grateful for any insight you can provide on these issues.

Many thanks,
Wendy

On Wed, Sep 30, 2020 at 1:28 PM Wendy

Re: [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-boun...@lyralists.lyrasis.org 
 on behalf of Neal, 
Rick 
Sent: Thursday, October 8, 2020 8:55 AM
To: Archivesspace Users Group 
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@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

[Archivesspace_Users_Group] Take a break with ArchivesSpace on Fridays

[Jessica Crouch]

Dear ArchivesSpace Users,



We’ll be hosting another casual open call via zoom at 12pm ET tomorrow. With no 
set agenda or presentation for these calls, this forum is an opportunity to 
connect, chat and recharge. Use this as a time to get help or talk about 
ArchivesSpace (or anything else) in an informal setting or just have a beverage 
with other ArchivesSpace users during this stressful time.



As a reminder, Take a Break with ArchivesSpace is going on hiatus after our 
October 30th call. We may revive the breaks in some form in the future, but 
until then we look forward to seeing you at the remaining calls. Thanks to 
everyone who has joined us at our standing Friday break calls since we started 
them in March. Whether you came to one call or 20, it’s been great getting to 
know so many of you better and sharing ArchivesSpace and non-ArchivesSpace 
thoughts.


We hope to see you all tomorrow.

When: Fridays
Time: 12:00 p.m. – 1:00 p.m. ET (9:00 a.m. – 10:00 a.m. PT)
Where: Zoom

Join the call via the information below:


Join Zoom Meeting

https://lyrasis.zoom.us/j/281962467



Meeting ID: 281 962 467



One tap mobile

+19292056099,,281962467# US (New York)

+13126266799,,281962467# US (Chicago)



Dial by your location

+1 929 205 6099 US (New York)

+1 312 626 6799 US (Chicago)

+1 301 715 8592 US

+1 346 248 7799 US (Houston)

+1 669 900 6833 US (San Jose)

+1 253 215 8782 US

888 475 4499 US Toll-free

877 853 5257 US Toll-free

Meeting ID: 281 962 467

Find your local number: https://lyrasis.zoom.us/u/awkFNWPxh

We seek to provide a welcoming, fun, and safe community experience for everyone 
and adhere to Code4Lib’s CodeofConduct4Lib. The full text of the code of 
conduct is available at: http://bit.ly/coc4lib.

Jessica Dowd Crouch
Community Engagement Coordinator for ArchivesSpace
jessica.cro...@lyrasis.org
[page1image482511520]

___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group