<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p><br>
</p>
<p>Hi,</p>
<p><br>
</p>
<p>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?</p>
<p>b,chris. <br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
<div class="BodyFragment"><font size="2">
<div class="PlainText">Chris Fitzpatrick | <font size="2">Developer, ArchivesSpace</font><br>
Skype: chrisfitzpat | Phone: 918.236.6048<br>
http://archivesspace.org/<br>
</div>
</font></div>
</div>
</div>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of David Eves
<david@bookbindersmuseum.org><br>
<b>Sent:</b> Tuesday, September 09, 2014 9:24 AM<br>
<b>To:</b> ArchivesSpaceUsersGroup<br>
<b>Subject:</b> [Archivesspace_Users_Group] Installation problem: setup-database.sh fails part way</font>
<div> </div>
</div>
<div>
<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>
</div>
</div>
</body>
</html>