Error creating new database

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.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Error creating new database

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

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

Thanks - should be fixed now.

Re: Error creating new database

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.

Re: Error creating new database

You need to supply the MySQL administrator's user name and password in order to create the database.

Syndicate content