<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Verdana" size="3"><span style="font-size:12pt;">
<div>Problem trying to upgrade v1.1.0 to v1.3.0. </div>
<div> </div>
<div>My site uses a remote MySQL 5.6 instance, on a *<b>shared</b>* institutional MySQL server.</div>
<div> </div>
<div>The database migration steps run by setup_database.bat are failing with that error about the Binary Logging:</div>
<div> </div>
<div> </div>
<div> </div>
<div style="margin-top:2pt;margin-bottom:2pt;"><font face="Segoe UI" size="4"><span style="font-size:14pt;">Running migrations against jdbc:mysql://mysqldev2.mitre.org:3306/archivesspace?user=archivesspace&password=****************&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true</span></font></div>
<div style="margin-top:2pt;margin-bottom:2pt;"><font face="Segoe UI" size="4"><span style="font-size:14pt;">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) </span></font></div>
<div> </div>
<div> -- AND trying log_bin_trust_fuction_creators=1 as a connection string parameter ---</div>
<div> </div>
<div> </div>
<div style="margin-top:2pt;margin-bottom:2pt;"><font face="Segoe UI" size="4"><span style="font-size:14pt;">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</span></font></div>
<div style="margin-top:2pt;margin-bottom:2pt;"><font face="Segoe UI" size="4"><span style="font-size:14pt;">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) </span></font></div>
<div> </div>
<div> </div>
<div>According to follow-up research in the MySQL manuals -- </div>
<div> </div>
<div> <a href="https://dev.mysql.com/doc/refman/5.6/en/stored-programs-logging.html"><font color="#9D454F"><u>https://dev.mysql.com/doc/refman/5.6/en/stored-programs-logging.html</u></font></a> </div>
<div> </div>
<div> </div>
<div> </div>
<div> One must either have SUPER grants to the entire MySQL installation</div>
<div> OR</div>
<div>Set global log_bin_trust_function_creators for the entire installation: </div>
<div> </div>
<div> </div>
<div style="margin-top:2pt;margin-bottom:2pt;"><font face="Segoe UI" size="4"><span style="font-size:14pt;"> 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:</span></font></div>
<div style="margin-top:2pt;margin-bottom:2pt;"> </div>
<div style="margin-top:2pt;margin-bottom:2pt;"><font face="Segoe UI" size="4"><span style="font-size:14pt;">mysql> SET GLOBAL log_bin_trust_function_creators = 1;</span></font></div>
<div style="margin-top:2pt;margin-bottom:2pt;"><font face="Segoe UI" size="4"><span style="font-size:14pt;"> </span></font></div>
<div style="margin-top:2pt;margin-bottom:2pt;"><font face="Segoe UI" size="4"><span style="font-size:14pt;">You can also set this variable by using the --log-bin-trust-function-creators=1 option when starting the server. </span></font></div>
<div> </div>
<div> </div>
<div>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.</div>
<div> </div>
<div> </div>
<div>Is there a way to defeat the Binary Logging requirements for V1.3.0? This wasn’t needed for the v1.x installations.</div>
<div> </div>
<div> </div>
<div>Thanks,</div>
<div> </div>
<div>Lee Cornelison</div>
<div>The MITRE Corporation</div>
<div> </div>
<div> </div>
<div> </div>
<div>Referred to earlier thread:</div>
<div> </div>
<div><a href="http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2015-July/001898.html">http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/2015-July/001898.html</a> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div><font color="#003399"> </font></div>
<div><font color="#003399"> </font></div>
<div><font color="#003399"> </font></div>
<div><font color="#003399"> </font></div>
<div><font color="#003399"> </font></div>
<div><font color="#003399"> </font></div>
<div><font size="2" color="#003399"><span style="font-size:10pt;"><b>Lee Cornelison</b></span></font></div>
<div><font size="2" color="#003399"><span style="font-size:10pt;">Electronic Records Management Service Architect</span></font></div>
<div><font size="2" color="#003399"><span style="font-size:10pt;"> R504 – Electronic Content and Records Services</span></font></div>
<div><font size="2" color="#003399"><span style="font-size:10pt;"> <a href="http://www.mitre.org/"><u>The MITRE Corporation</u></a> | Bedford, MA</span></font></div>
<div><font size="2" color="#003399"><span style="font-size:10pt;"> 202 Burlington Road, Bedford, MA 01730</span></font></div>
<div><font size="2" color="#003399"><span style="font-size:10pt;"> 1-781-271-5051 | <a href="mailto:cornelison@mitre.org"><u>cornelison@mitre.org</u></a></span></font></div>
<div> </div>
<div> </div>
</span></font>
</body>
</html>