Error creating new database

Submitted by Yuri on Tue, 09/11/2021 - 09:57

Implementation discussion

Setting up a new server to migrate OV and am trying to get to creating an empty database. Coming from 1.9.3, I ran "toolbox configure" which seemed to run ok. but then got this error message trying to create empty database.

http://sunshinevet.com.au/images/missing_driver.jpg

System: Win10 pro 64-bit, 32GB RAM, MySQL 5.5, Tomcat 9, Java 8.b261

Assistance please.

Yuri.

Re: Error creating new database

Submitted by tanderson on Tue, 09/11/2021 - 10:11.

The default configuration for OpenVPMS 2.3 expects MySQL Connector/J 8.x.

This is compatible with MySQL 5.5 and up.

You can download the jar from here and copy to the <OPENVPMS_HOME>/lib directory.

Re: Error creating new database

Submitted by Yuri on Thu, 11/11/2021 - 09:37.

Ah, that explains it.

My fault (as usual) - I'd downloaded v2.2 and read its requirements. Then replaced an SSD over past couple days, started reloading Win10 Pro and requirements, saw v2.3 ("oh good, I'll grab that") and didn't read its updated requirements.

Thank you.

Yuri.

EDIT: Perhaps not my fault: I followed steps at this link but https://openvpms.org/documentation/csh/2.3/topics/installing-openvpms/new-installation#MySQLconnector still has required MySQL connector listed as mysql-connector-java-5.1.<x>.zip.

Re: Error creating new database

Submitted by tanderson on Fri, 12/11/2021 - 15:11.

Thanks - should be fixed now.

Re: Error creating new database

Submitted by Yuri on Fri, 12/11/2021 - 15:12.

Before submitting this message I restored a system image back to a prisitine W10pro machine and carefully and cleanly installed every step checking every step. I installed the connector jb8.1.x in TC9/lib and openvpms/lib and now have this error message.

https://sunshinevet.com.au/images/poolableconnectionfactory.jpg

Yuri.