Re: [Archivesspace_Users_Group] MySQL connector question
Neal, Rick wrote on 2020-10-09 11:18:00: > I am continuing to troubleshoot our mysql issue and have a question about the > mysql connector. > > My operating system is RHEL 7. > MySQL version is: mysql-community 5.6.49-2.el7 > > The instructions sent me to: https://dev.mysql.com/downloads/connector/j/ > > I downloaded: mysql-connector-java-8.0.21-1.el7.noarch.rpm > > I did a little searching and found that the mysql-community repo has this one > available: mysql-connector-odbc.x86_64 8.0.21-1.el7 > > My question is that since I installed mysql from a mysql-community repo > should I use the mysql-connector-odbc file from that same repo? Does it > matter which one? You need mysql-connector-java, I believe the one you downloaded should be fine. It should be sufficient t have it somewhere in your CLASSPATH. p ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
Re: [Archivesspace_Users_Group] MySQL connector question
Good morning Peter, Thank you for your help! I checked my CLASSPATH but found it was empty. My java is using /bin/java. Could my issues simply be that the CLASSPATH is empty? Do I want to add java to the CLASSPATH by doing this: export CLASSPATH=/bin/java and then test to see if everything just starts working? [root@aspace lib]# echo $ {CLASSPATH} $ {CLASSPATH} [root@aspace lib]# which java /bin/java Rick -Original Message- From: archivesspace_users_group-boun...@lyralists.lyrasis.org On Behalf Of Peter Heiner Sent: Friday, October 9, 2020 7:32 AM To: Archivesspace Users Group Subject: Re: [Archivesspace_Users_Group] MySQL connector question Neal, Rick wrote on 2020-10-09 11:18:00: > I am continuing to troubleshoot our mysql issue and have a question about the > mysql connector. > > My operating system is RHEL 7. > MySQL version is: mysql-community 5.6.49-2.el7 > > The instructions sent me to: > https://dev.mysql.com/downloads/connector/j/ > > I downloaded: mysql-connector-java-8.0.21-1.el7.noarch.rpm > > I did a little searching and found that the mysql-community repo has this one > available: mysql-connector-odbc.x86_64 8.0.21-1.el7 > > My question is that since I installed mysql from a mysql-community repo > should I use the mysql-connector-odbc file from that same repo? Does it > matter which one? You need mysql-connector-java, I believe the one you downloaded should be fine. It should be sufficient t have it somewhere in your CLASSPATH. p ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
Re: [Archivesspace_Users_Group] MySQL connector question
Neal, Rick wrote on 2020-10-09 11:47:06: > I checked my CLASSPATH but found it was empty. My java is using > /bin/java. Could my issues simply be that the CLASSPATH is empty? Do > I want to add java to the CLASSPATH by doing this: export > CLASSPATH=/bin/java and then test to see if everything just starts > working? I realise capitalising 'classpath' was a mistake. Some Java apps' startup scripts make use of this, others use the java binary's -cp or -classpath flag directly. ArchivesSpace's classpath does not include system directories like /usr/share/java where the mysql-connector-java package puts its files. You need to copy or link the connector found in /usr/share/java/mysql-connector-java-8.0.12.jar to the main archivesspace/lib directory. p ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
Re: [Archivesspace_Users_Group] MySQL connector question
Try using the older connector, https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.49.tar.gz From: archivesspace_users_group-boun...@lyralists.lyrasis.org on behalf of Peter Heiner Sent: Friday, October 9, 2020 8:13 AM To: Archivesspace Users Group Subject: Re: [Archivesspace_Users_Group] MySQL connector question Neal, Rick wrote on 2020-10-09 11:47:06: > I checked my CLASSPATH but found it was empty. My java is using > /bin/java. Could my issues simply be that the CLASSPATH is empty? Do > I want to add java to the CLASSPATH by doing this: export > CLASSPATH=/bin/java and then test to see if everything just starts > working? I realise capitalising 'classpath' was a mistake. Some Java apps' startup scripts make use of this, others use the java binary's -cp or -classpath flag directly. ArchivesSpace's classpath does not include system directories like /usr/share/java where the mysql-connector-java package puts its files. You need to copy or link the connector found in /usr/share/java/mysql-connector-java-8.0.12.jar to the main archivesspace/lib directory. p ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group ___ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group