Jump to content

SQL Contact Importer - Fails to Connect to MySQL 8.x


Recommended Posts

We are attempting to use the SQL Contact Importer to load the contacts for next service desk we are going live with on the Hornbill platform, but the Hornbill SQL Contact Importer is failing to connect to our source MySQL 8.0 database due to the version of the MySQL due to the version of the go-sql-driver used in the tool.

image.png.0581e848349f6389b34785eaf4b635bd.png

Can the  SQL Contact Importer be updated to use the newer driver please.

Reference
https://www.pixelstech.net/article/1531316568-Fix-this-authentication-plugin-is-not-supported-issue-while-using-Go-to-connect-MySQL-8

Thanks

Martyn

Link to comment
Share on other sites

Hi @Martyn Houghton,

I've added support for MySQL 8 in to the tool, and fixed the created/updated count. I've also removed the skipped counts (as these are reported as errors).

The tool was overdue a little TLC, so I've done some refactoring, improved the output logging, and removed the need to provide a zone where your instance resides too. It's available for download here: https://github.com/hornbill/goDb2HcontactImport/releases/download/1.3.0/goHornbillContactImport_windows_v1_3_0.zip

Let me know how you get on with this.

Cheers,

Steve

  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...