ExportMySQL.exe Not Loading Data to Remote MySQL Database

[glen.day]

Hi,

I am running the latest version of CumulusMX on Ubuntu 20.04.3 LTS, I also have a dedicated MySQL server of whch is utilies by CumulusMX. Everything appears to be functioning.

That said I have noticed when I run 'cd CumulusMX && sudo mono ExportMySQL.exe dayfile' I receive a message 'Can't connect to MySQL server on '###.###.###.###' (10061): Authentication failed.' - The funny thing is that I know for a fact that CumulusMX is able to write to the database as there is data being entered in to it. It just doesn't allow the export.

Any ideas why this is happening? Does the ExportMySQL.exe only work when the MySQL database is hosted locally?

Glen

[mcrossley]

ExportMySQL does connect to remote databases OK - I do that when testing it.

The executable needs to be in the main CMX folder, and your path needs to there too as it reads the server address, username/password, and database name from Cumulus.ini - but it looks like you are doing that.

You need to be running the latest version of ExportMySQL - v1.4.0.

I'm not sure what else to suggest really. It will use the same username as CMX which rules out the usual issue of that user not have remote access rights in MySQL.
The code for connecting to MySQL is the same.

[sfws]

ExportMySQL does connect to remote databases OK - I do that when testing it.

The executable needs to be in the main CMX folder, and your path needs to there too as it reads the server address, username/password, and database name from Cumulus.ini - but it looks like you are doing that.

You need to be running the latest version of ExportMySQL - v1.4.0.

Mark actually means the ExportToMySql.exe utility that he wrote - see https://cumuluswiki.org/a/Software#ExportToMySQL sub-section in Wiki for 1.4.0 download.

The utility "ExportMySQL.exe" (without the "To") was something written by Steve Loft for his MX beta that is not compatible with the recent MX releases.

[glen.day]

Yeah a bit weird.

I am definitely using the latest version - v1.4.0. As mentioned, I can see CumulusMX updating the MySQL tables (when running normally). I even went to the extreme and deleted the tables and created from the webpage, this worked fine - so I know the connection is correct/working.

I also initiated a connection via MySQL client from the CumulusMX machine to the MySQL machine and was able to connect. It's just the Export exe!

Anyway if there isn't anything else you can suggest I'll just have to continue with what I have.

[glen.day]

ExportMySQL does connect to remote databases OK - I do that when testing it.

The executable needs to be in the main CMX folder, and your path needs to there too as it reads the server address, username/password, and database name from Cumulus.ini - but it looks like you are doing that.

You need to be running the latest version of ExportMySQL - v1.4.0.

Mark actually means the ExportToMySql.exe utility that he wrote - see https://cumuluswiki.org/a/Software#ExportToMySQL sub-section in Wiki for 1.4.0 download.

The utility "ExportMySQL.exe" (without the "To") was something written by Steve Loft for his MX beta that is not compatible with the recent MX releases.

Oh really, let me check.

[glen.day]

Hmm maybe your right? Maybe that ExportMySQL.exe is a old component, maybe I left it in my directory for years?

I checked the package and there is no ExportMySQL file.

So that brings me to ask, do we have this functionality in the new version? How can I export all my data to MySQL?

[glen.day]

Nevermind a link was provided, I'll have a look now.

[glen.day]

Thanks all, ended up being an old version of the Export.exe.

[mcrossley]

Mark actually means the ExportToMySql.exe utility that he wrote

Ah, yes, good distinction.