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

[Martyn Houghton]

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.

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

[James Ainsworth]

Hi @Martyn Houghton

Thanks for your post.  The development team are having a look.  We will let you know as soon as we have an update for you.

Regards,

James

[Steve G]

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

[Martyn Houghton]

@Steve G

Thanks for the your efforts on this.

Cheers

Martyn