<div dir="ltr">I'm trying to get a test instance of archivesspace running on a VPS (<a href="http://linode.com">linode.com</a>) running CentOS 6.5, MySql 5.6.20.<div><br></div><div>I have created an archivesspace database and granted permissions to a mysql user (aspace) as detailed in the README (<a href="https://github.com/archivesspace/archivesspace">https://github.com/archivesspace/archivesspace</a>)</div><div><br></div><div>When I run scripts/setup-database.sh, the setup fails with the error trace below.</div><div><br></div><div>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.</div><div><br></div><div>Does anyone have a idea where I should be looking for the solution? </div><div><br></div><div><div><div dir="ltr"><div><br></div>David Eves<div><<a href="http://www.bookbindersmuseum.org" target="_blank">www.bookbindersmuseum.org</a>></div><div><br></div><div><br></div><div>===== trace from running setup-database.sh =====</div><div><div>$ ./scripts/setup-database.sh</div><div>Loading ArchivesSpace configuration file from path: /opt/archivesspace/./config/config.rb</div><div>Loading ArchivesSpace configuration file from path: /opt/archivesspace/./config/config.rb</div><div>Running migrations against jdbc:mysql://localhost:3306/archivesspace?user=aspace&password=xxxxxxxxxxxxxxx&useUnicode=true&characterEncoding=UTF-8</div><div>Sequel::DatabaseError: Java::ComMysqlJdbcExceptionsJdbc4::CommunicationsException: Communications link failure</div><div><br></div><div>The last packet successfully received from the server was 41 milliseconds ago. The last packet sent successfully to the server was 38 milliseconds ago.</div><div> raise_error at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/misc.rb:313</div><div> statement at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:563</div><div> statement at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:561</div><div> execute at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:255</div><div> hold at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/connection_pool/threaded.rb:104</div><div> hold at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/connection_pool/threaded.rb:93</div><div> synchronize at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/connecting.rb:240</div><div> execute at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:254</div><div> execute_ddl at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/jdbc.rb:277</div><div> apply_alter_table at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/utils/split_alter_table.rb:32</div><div> each at org/jruby/RubyArray.java:1613</div><div> apply_alter_table at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/utils/split_alter_table.rb:32</div><div> each at org/jruby/RubyArray.java:1613</div><div> apply_alter_table at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/adapters/utils/split_alter_table.rb:30</div><div> apply_alter_table_generator at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/schema_methods.rb:349</div><div> alter_table at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/schema_methods.rb:78</div><div> (root) at file:/opt/archivesspace/lib/common.jar!/db/migrations/001_create_base_schema.rb:438</div><div> instance_eval at org/jruby/RubyBasicObject.java:1536</div><div> apply at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:94</div><div> run at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:519</div><div> checked_transaction at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:456</div><div> run at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:518</div><div> each at org/jruby/RubyArray.java:1613</div><div> run at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:514</div><div> run at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/extensions/migration.rb:381</div><div> setup_database at file:/opt/archivesspace/lib/common.jar!/db/db_migrator.rb:184</div><div> (root) at ../scripts/rb/migrate_db.rb:43</div><div> connect at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/database/connecting.rb:80</div><div> connect at /opt/archivesspace/gems/gems/sequel-3.41.0/lib/sequel/core.rb:147</div><div> (root) at ../scripts/rb/migrate_db.rb:28</div><div>$ </div></div><div><br></div><div>==== output from mysql client =======</div><div><br></div><div><br></div><div><div>mysql> use archivesspace;</div><div>Reading table information for completion of table and column names</div><div>You can turn off this feature to get a quicker startup with -A</div><div><br></div><div>Database changed</div><div>mysql> show tables;</div><div>+-------------------------+</div><div>| Tables_in_archivesspace |</div><div>+-------------------------+</div><div>| accession |</div><div>| agent_corporate_entity |</div><div>| agent_family |</div><div>| agent_person |</div><div>| agent_software |</div><div>| archival_object |</div><div>| auth_db |</div><div>| digital_object |</div><div>| enumeration |</div><div>| enumeration_value |</div><div>| group |</div><div>| group_permission |</div><div>| group_user |</div><div>| notification |</div><div>| permission |</div><div>| repository |</div><div>| resource |</div><div>| schema_info |</div><div>| session |</div><div>| user |</div><div>+-------------------------+</div><div>20 rows in set (0.00 sec)</div><div><br></div><div>mysql> </div></div><div><br></div></div></div>
</div></div>