[Archivesspace_Users_Group] Installation problem: setup-database.sh fails part way

[Chris Fitzpatrick]

Hi,


Looks like you lost connection to your MySQL server during the migration. Are you using a local mysql db or is it a remote one?

b,chris.





Chris Fitzpatrick | Developer, ArchivesSpace
Skype: chrisfitzpat  | Phone: 918.236.6048
http://archivesspace.org/
________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of David Eves <david at bookbindersmuseum.org>
Sent: Tuesday, September 09, 2014 9:24 AM
To: ArchivesSpaceUsersGroup
Subject: [Archivesspace_Users_Group] Installation problem: setup-database.sh fails part way

I'm trying to get a test instance of archivesspace running on a VPS (linode.com<http://linode.com>) running CentOS 6.5, MySql 5.6.20.

I have created an archivesspace database and granted permissions to a mysql user (aspace) as detailed in the README (https://github.com/archivesspace/archivesspace)

When I run scripts/setup-database.sh, the setup fails with the error trace below.

When I check the database, it looks like it is partially created; I've appended the output from 'show tables' in the mysql client below the error trace.

Does anyone have a idea where I should be looking for the solution?


David Eves
<www.bookbindersmuseum.org<http://www.bookbindersmuseum.org>>


===== trace from running setup-database.sh =====
$ ./scripts/setup-database.sh
Loading ArchivesSpace configuration file from path: /opt/archivesspace/./config/config.rb
Loading ArchivesSpace configuration file from path: /opt/archivesspace/./config/config.rb
Running migrations against jdbc:mysql://localhost:3306/archivesspace?user=aspace&password=xxxxxxxxxxxxxxx&useUnicode=true&characterEncoding=UTF-8
Sequel::DatabaseError: Java::ComMysqlJdbcExceptionsJdbc4::CommunicationsException: Communications link failure

The last packet successfully received from the server was 41 milliseconds ago.  The last packet sent successfully to the server was 38 milliseconds ago.
                  raise_error at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/misc.rb:313
                    statement at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:563
                    statement at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:561
                      execute at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:255
                         hold at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/connection_pool/threaded.rb:104
                         hold at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/connection_pool/threaded.rb:93
                  synchronize at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/connecting.rb:240
                      execute at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:254
                  execute_ddl at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:277
            apply_alter_table at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/utils/split_alter_table.rb:32
                         each at org/jruby/RubyArray.java:1613
            apply_alter_table at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/utils/split_alter_table.rb:32
                         each at org/jruby/RubyArray.java:1613
            apply_alter_table at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/utils/split_alter_table.rb:30
  apply_alter_table_generator at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/schema_methods.rb:349
                  alter_table at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/schema_methods.rb:78
                       (root) at file:/opt/archivesspace/lib/common.jar!/db/migrations/001_create_base_schema.rb:438
                instance_eval at org/jruby/RubyBasicObject.java:1536
                        apply at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:94
                          run at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:519
          checked_transaction at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:456
                          run at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:518
                         each at org/jruby/RubyArray.java:1613
                          run at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:514
                          run at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:381
               setup_database at file:/opt/archivesspace/lib/common.jar!/db/db_migrator.rb:184
                       (root) at ../scripts/rb/migrate_db.rb:43
                      connect at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/connecting.rb:80
                      connect at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/core.rb:147
                       (root) at ../scripts/rb/migrate_db.rb:28
$

==== output from mysql client =======


mysql> use  archivesspace;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------------+
| Tables_in_archivesspace |
+-------------------------+
| accession               |
| agent_corporate_entity  |
| agent_family            |
| agent_person            |
| agent_software          |
| archival_object         |
| auth_db                 |
| digital_object          |
| enumeration             |
| enumeration_value       |
| group                   |
| group_permission        |
| group_user              |
| notification            |
| permission              |
| repository              |
| resource                |
| schema_info             |
| session                 |
| user                    |
+-------------------------+
20 rows in set (0.00 sec)

mysql>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20140909/5d2ccc77/attachment.html>