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

[David Eves]

I'm trying to get a test instance of archivesspace running on a VPS (
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>


===== 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/780d5956/attachment.html>