[Archivesspace_Users_Group] Can't get ArchivesSpace (ASpace) connected to my SQL5.52 and 5.6

[Mang Sun]

We noticed that error as well and ever tried with BINLOG_FORMAT =MIXED 
but MySQL can't even get started. What I didn't mention in  the first 
place, I don't have any problem migrating the SAME MySQL dump and ASpace 
binaries to my own personal sandbox where same Redhat 7,  MySQL v5.5.52 
and openjDK 1.8.0_65 are present whereas the virtual box is prepared our 
by Campus IT. Agreed, this seems to not be a problem about ArchivesSpace 
per se but more related to "compatibility" between ASpace (v2.2.1) and 
MySQL.  Thank you.


Mang

On 4/16/2020 12:01 PM, blake.carver at lyrasis.org wrote:
> I don't think that's really an ArchivesSpace problem, it's a MySQL 
> error that's probably unrelated to your ArchivesSpace set up. If you 
> ask your favorite search engine about that error, there are solutions. 
> Here's one:
> https://dba.stackexchange.com/questions/58459/mysql-error-impossible-to-write-to-binary-log
>
> "impossible to write to binary log since BINLOG_FORMAT = STATEMENT and 
> at least one table uses a storage engine limited to row-based logging. 
> InnoDB is limited to row-logging when transaction isolation level is 
> READ COMMITTED or READ UNCOMMITTED."
> ------------------------------------------------------------------------
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org 
> <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of 
> Mang Sun <ms20 at rice.edu>
> *Sent:* Thursday, April 16, 2020 12:53 PM
> *To:* archivesspace_users_group at lyralists.lyrasis.org 
> <archivesspace_users_group at lyralists.lyrasis.org>
> *Subject:* [Archivesspace_Users_Group] Can't get ArchivesSpace 
> (ASpace) connected to my SQL5.52 and 5.6
>
> We are trying to move our ASpace to a new virtual box where only MySQL 
> v5.5.52 and 5.6 are available from our current physical box where 
> MySQL v.5.1.37 is running. However we keep seeing the following errors 
> (excerpted) related to login authentication with both versions. MySQL 
> user name/passwd I can confirm is right. Java version is openjdk 
> 1.8.0_242. mysql-connector-java-5.1.34.jar is used. Our current ASpace 
> in production  uses MySQL v5.1.37 and JAVA 1.7.x. Any suggestions?
>
> D, [2020-04-16T11:18:03.151130 #4864] DEBUG -- : Thread-2252: 
> Responded with [403, {"Content-Type"=>"application/json", 
> "Cache-Control"=>"private, must-revalidate, max-age=0", 
> "Content-Length"=>"25"}, ["{\"error\":\"Login failed\"}\n"]]... in 144ms
> E, [2020-04-16T11:18:07.179648 #4864] ERROR -- : Thread-2014: Error 
> communicating with authentication source DBAuth: 
> Java::JavaSql::SQLException: Cannot execute statement: impossible to 
> write to binary log since BINLOG_FORMAT = STATEMENT and at least one 
> table uses a storage engine limited to row-based logging. InnoDB is 
> limited to row-logging when transaction isolation level is READ 
> COMMITTED or READ UNCOMMITTED.
> E, [2020-04-16T11:18:07.180038 #4864] ERROR -- :
> com.mysql.jdbc.SQLError.createSQLException(com/mysql/jdbc/SQLError.java:996)
> com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3887)
> com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3823)
> D, [2020-04-16T11:18:07.181186 #4864] DEBUG -- : Thread-2014: 
> Responded with [403, {"Content-Type"=>"application/json", 
> "Cache-Control"=>"private, must-revalidate, max-age=0", 
> "Content-Length"=>"25"}, ["{\"error\":\"Login failed\"}\n"]]... in 124ms
> #<RuntimeError: Authentication to backend failed: {"error":"Login failed"}
> E, [2020-04-16T11:18:12.313302 #4864] ERROR -- : Thread-2014: Error 
> communicating with authentication source DBAuth: 
> Java::JavaSql::SQLException: Cannot execute statement: impossible to 
> write to binary log since BINLOG_FORMAT = STATEMENT and at least one 
> table uses a storage engine limited to row-based logging. InnoDB is 
> limited to row-logging when transaction isolation level is READ 
> COMMITTED or READ UNCOMMITTED.
> E, [2020-04-16T11:18:12.313746 #4864] ERROR -- :
> com.mysql.jdbc.SQLError.createSQLException(com/mysql/jdbc/SQLError.java:996)
> com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3887)
> com.mysql.jdbc.MysqlIO.checkErrorPacket(com/mysql/jdbc/MysqlIO.java:3823)
> D, [2020-04-16T11:18:12.314931 #4864] DEBUG -- : Thread-2014: 
> Responded with [403, {"Content-Type"=>"application/json", 
> "Cache-Control"=>"private, must-revalidate, max-age=0", 
> "Content-Length"=>"25"}, ["{\"error\":\"Login failed\"}\n"]]... in 124ms
> #<RuntimeError: Authentication to backend failed: {"error":"Login failed"}
>
> Thank you.
>
> Mang Sun
>
> Rice U.
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20200416/1d43b69c/attachment.html>