<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">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi Lee,</p>
<p><br>
</p>
<p>Yes, the reports features added some stored procedures that have to be installed. Is it possible for you to run the migration as a different user than the user that you normally use to run the application?</p>
<p><br>
</p>
<p>b,chris. <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>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Cornelison,
Lee <cornelison@mitre.org><br>
<b>Sent:</b> Friday, September 11, 2015 10:55 PM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Cc:</b> Cornelison, Lee<br>
<b>Subject:</b> [Archivesspace_Users_Group] AS v.1.3.0 upgrade failure -- setup_database.bat</font>
<div> </div>
</div>
<div><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 color="#003399" size="2"><span style="font-size:10pt"><b>Lee Cornelison</b></span></font></div>
<div><font color="#003399" size="2"><span style="font-size:10pt">Electronic Records Management Service Architect</span></font></div>
<div><font color="#003399" size="2"><span style="font-size:10pt">R504 – Electronic Content and Records Services</span></font></div>
<div><font color="#003399" size="2"><span style="font-size:10pt"><a href="http://www.mitre.org/"><u>The MITRE Corporation</u></a> | Bedford, MA</span></font></div>
<div><font color="#003399" size="2"><span style="font-size:10pt">202 Burlington Road, Bedford, MA 01730</span></font></div>
<div><font color="#003399" size="2"><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></div>
</div>
</div>
</body>
</html>