[Archivesspace_Users_Group] AS v.1.3.0 upgrade failure -- setup_database.bat

[Cornelison, Lee]

Problem trying to upgrade v1.1.0  to v1.3.0.

My site uses a remote  MySQL 5.6 instance, on a *shared*  institutional MySQL server.

The database migration steps run by setup_database.bat are failing with that error about the Binary Logging:



Running migrations against jdbc:mysql://mysqldev2.mitre.org:3306/archivesspace?user=archivesspace&password=****************&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true
Sequel::DatabaseError: Java::JavaSql::SQLException: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

  -- AND  trying log_bin_trust_fuction_creators=1  as a connection string parameter ---


Running migrations against jdbc:mysql://mysqldev2.mitre.org:3306/archivesspace?user=archivesspace&password=****************&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&log_bin_trust_function_creators=1
Sequel::DatabaseError: Java::JavaSql::SQLException: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)


According to follow-up research in the MySQL manuals --

   https://dev.mysql.com/doc/refman/5.6/en/stored-programs-logging.html



 One must either have SUPER grants to the entire MySQL installation
 OR
Set global   log_bin_trust_function_creators  for the entire installation:


 set the global log_bin_trust_function_creators system variable to 1. By default, this variable has a value of 0, but you can change it like this:

mysql> SET GLOBAL log_bin_trust_function_creators = 1;

You can also set this variable by using the --log-bin-trust-function-creators=1 option when starting the server.


Since my MySQL db is hosted in a multi-user MySQL install,  the dba's are not willing to make these changes that affect other users' dbs.


Is there a way to defeat the Binary Logging requirements for V1.3.0?   This wasn't needed for the v1.x  installations.


Thanks,

Lee Cornelison
The MITRE Corporation



Referred to earlier thread:

http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2015-July/001898.html










Lee Cornelison
Electronic Records Management Service Architect
 R504 - Electronic Content and Records Services
 The MITRE Corporation<http://www.mitre.org/> | Bedford, MA
 202 Burlington Road, Bedford, MA 01730
 1-781-271-5051 | cornelison at mitre.org<mailto:cornelison at mitre.org>


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