Welcome to the Cumulus Support forum.

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Cumulus MX V4 beta test release 4.0.0 (build 4017) - 17 March 2024

Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014 (a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

Exporttomysql after build 3190

From build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
BrunswickWeather
Posts: 76
Joined: Fri 11 Mar 2011 2:04 am
Weather Station: Ecowitt GW1103
Operating System: windows 11 Pro/Raspberry pi 4
Location: Brunswick Australia

Exporttomysql after build 3190

Post by BrunswickWeather »

After build 3190 Exportomysql fails as per attachments.
Using latest exe as per wiki.
You do not have the required permissions to view the files attached to this post.
User avatar
HansR
Posts: 5871
Joined: Sat 20 Oct 2012 6:53 am
Weather Station: GW1100 (WS80/WH40)
Operating System: Raspberry OS/Bullseye
Location: Wagenborgen (NL)
Contact:

Re: Exporttomysql after build 3190

Post by HansR »

The assembly definition does not match the library present.
Did you copy all files from the distribution during the upgrade?

Or, aha..., Mark must create a new executable against the new libraries!
Hans

https://meteo-wagenborgen.nl
CMX build 4017+ ● RPi 3B+ ● Raspbian Linux 6.1.21-v7+ armv7l ● dotnet 8.0.3
User avatar
mcrossley
Posts: 12690
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Exporttomysql after build 3190

Post by mcrossley »

Yes, I'll need to relink it against the new libraries, doh! ....
User avatar
mcrossley
Posts: 12690
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Exporttomysql after build 3190

Post by mcrossley »

Done, v1.5.0 is available.
BrunswickWeather
Posts: 76
Joined: Fri 11 Mar 2011 2:04 am
Weather Station: Ecowitt GW1103
Operating System: windows 11 Pro/Raspberry pi 4
Location: Brunswick Australia

Re: Exporttomysql after build 3190

Post by BrunswickWeather »

The new version does not seem to work on Build 3190.
The previous version works on a previous version of Cumulus MX 3184
Both on the the same PC run about 2 minutes apart
You do not have the required permissions to view the files attached to this post.
sfws
Posts: 1183
Joined: Fri 27 Jul 2012 11:29 am
Weather Station: Chas O, Maplin N96FY, N25FR
Operating System: rPi 3B+ with Buster (full)

Re: Exporttomysql after build 3190

Post by sfws »

BrunswickWeather wrote: Mon 20 Jun 2022 11:34 pm The new version does not seem to work on Build 3190.
ExportToMySQL.exe release 1.5 does not flag any such error for me, but I accept differences exist between your test and mine :
- I ran it with MONO 6.12.0.182 on Raspberry Pi OS (not .NET on Microsoft Windows)
- I tested it with a monthly file (not dayfile)
- I downloaded directly from Git Hub page (not via Cumulus Wiki Software page)
Last edited by sfws on Tue 21 Jun 2022 6:05 am, edited 1 time in total.
User avatar
HansR
Posts: 5871
Joined: Sat 20 Oct 2012 6:53 am
Weather Station: GW1100 (WS80/WH40)
Operating System: Raspberry OS/Bullseye
Location: Wagenborgen (NL)
Contact:

Re: Exporttomysql after build 3190

Post by HansR »

Obviously you now have the wrong system.memory dll installed for the 1.5 run.
So for the 1.5 run against the 3190 CMX, did you have a complete new directory structure or did you just copy the CMX and Exporttomysql exe files?

Copy again and make sure you copy all dll files in the distribution.

(Or Mark made a link error but that seems more unlikely)
Hans

https://meteo-wagenborgen.nl
CMX build 4017+ ● RPi 3B+ ● Raspbian Linux 6.1.21-v7+ armv7l ● dotnet 8.0.3
User avatar
mcrossley
Posts: 12690
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Exporttomysql after build 3190

Post by mcrossley »

Argh! It was me - I checked the versions against my latest build (3191) rather than 3190.

So, I'll create a v1.4.1 release for 3190, and put that up as well as 1.5.0 as the 3191 release will be soon - I need to fix that Ecowitt station settings page error.
User avatar
mcrossley
Posts: 12690
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Exporttomysql after build 3190

Post by mcrossley »

OK, version 1.4.1 is available from the Wiki - but not on on Github, yet.
BrunswickWeather
Posts: 76
Joined: Fri 11 Mar 2011 2:04 am
Weather Station: Ecowitt GW1103
Operating System: windows 11 Pro/Raspberry pi 4
Location: Brunswick Australia

Re: Exporttomysql after build 3190

Post by BrunswickWeather »

Should version 1.4.1 work with build 3196?

C:\CumulusMX>exporttomysql dayfile
Parameter: dayfile
Error encountered opening MySQL connection
Could not load file or assembly 'System.Memory, Version=4.0.1.1, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Cumulus MX 3196 loads data to the database.
You do not have the required permissions to view the files attached to this post.
User avatar
mcrossley
Posts: 12690
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: Exporttomysql after build 3190

Post by mcrossley »

Ah, no it will not. I forgot to go back and re-release version 1.5.0.

Version 1.6.0 will soon be released to accompany CMX 3.20.0 - can you wait until then?
BrunswickWeather
Posts: 76
Joined: Fri 11 Mar 2011 2:04 am
Weather Station: Ecowitt GW1103
Operating System: windows 11 Pro/Raspberry pi 4
Location: Brunswick Australia

Re: Exporttomysql after build 3196

Post by BrunswickWeather »

Thanks Mark
Next release OK
Reinstalled Maria DB as MySQL stopped due to a "unexpected error".
I know there are ways to repair the error but the quickest for me is to delete and start again as I only use the three tables from Cumulus MX. I use the database into Excel for history from the last 12 years of Cumulus recording.
Post Reply