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
Topics about the Beta trials up to Build 3043, the last build by Cumulus's founder Steve Loft. It was by this time way out of Beta but Steve wanted to keep it that way until he made a decision on his and Cumulus's future.
I've stup apache and mysql on my pi made a database
As I've not had a dayfile the dayfile table is empty so far so good (I did not try to current dayfile)
The Monfile table works fine every 10 minutes the values are added ( 10 minutes is my webupfate and console memory Fine Offset)
Now the question
The realtime.txt upload has an optional 'retention' setting, which will cause entries older than the value specified to be deleted from the database after each upload. It should be specified as a MySQL 'interval', e.g. 24 HOUR or 1 DAY or 1 WEEK etc.
I don't know what to fill out here I want 48 hours every 60 seconds... in my old config under Win7 I've a batchfile with retainVal=48 retainUnit=hour can I use this or ??
EDIT furthermore ExportMySQL dayfile at commandline doesn't create a dayfile table..
nitrx wrote:I don't know what to fill out here I want 48 hours every 60 seconds... in my old config under Win7 I've a batchfile with retainVal=48 retainUnit=hour can I use this or ??
The script just combines those two fields, with MX you combine them yourself - so 48 HOUR is what you want.
EDIT furthermore ExportMySQL dayfile at commandline doesn't create a dayfile table..
That's right. As indicated in the the instructions.
nitrx wrote:I don't know what to fill out here I want 48 hours every 60 seconds... in my old config under Win7 I've a batchfile with retainVal=48 retainUnit=hour can I use this or ??
[quotte}The script just combines those two fields, with MX you combine them yourself - so 48 HOUR is what you want.
Great clear to me it works
EDIT furthermore ExportMySQL dayfile at commandline doesn't create a dayfile table..
steve wrote:That's right. As indicated in the the instructions.
Sorry but I can't find this or I misunderstand something
Maybe I am misunderstanding. ExportMySQL doesn't create any tables. You have to create them before you run it, using the MySQL settings GUI in MX (or by some other method, if you wish).
steve wrote:Maybe I am misunderstanding. ExportMySQL doesn't create any tables. You have to create them before you run it, using the MySQL settings GUI in MX (or by some other method, if you wish).
Aha miscommunicating I see , database is made and the tables are availble (made in the GUI) after that I did try the line command without and with sudo but nothing is uploaded also done this while CumulusMX was not running. No errors are diplayed.
I did check that ExportMySQL worked OK under Linux, but I've just had a thought. It assumes that the dayfile.txt fields are separated by the list separator for the current culture. Are you overriding this in MX - i.e, is your dayfile.txt list separator not the same as your regional setting in Linux?
But is your system set up with English settings, or do you run MX with a '-lang' parameter? Does ExportMySQL not output anything at all while it's running? It should print the dates that its processing, even if the upload isn't working.
Cumulus is complete setup in English I don't use an other culture at the command line everything is in English also the dekstopgui, I dont get output in the console after the ExportMSQL command after some time I get the 'normal'output connected from 192.xxx disconnected from 192.xxx as usual
edit I mean my OS also setup in English
I'm baffled then. You shouldn't need to use sudo, assuming you have your file permissions correct. I've just tried again on my Pi with the ExportMySQL from the distribution, and it still works. You should just need to do
mono ExportMySQL.exe dayfile
and after a couple of seconds it should start displaying the dates from dayfile.txt. You are running it from the CumulusMX installation directory, yes?
steve wrote: You shouldn't need to use sudo, assuming you have your file permissions correct. I've just tried again on my Pi with the ExportMySQL from the distribution, and it still works. You should just need to do
mono ExportMySQL.exe dayfile
and after a couple of seconds it should start displaying the dates from dayfile.txt. You are running it from the CumulusMX installation directory, yes?
I have restarded my pi . I'm running from the Cumulus directory (I've named it Cumulus instead CumulusMX I think this should be not an issue) unfortunally the console doesnt give any clues and the data are not uploaded to the database. Hopefully somebody tries his out too otherwise I do a new install or try to import in another way.
steve wrote:Could you replace your ExportMySQL.exe with the one in the attached zipfile, please, and see if it says anything when you run it?
Nothing happens too I tried also to import a Monthfile with mono ExportMySQL /data/April15log.txt this give an error 'Cannot open Assembly 'ExportMySQL' no such file or directory.
The Apr15log.txt is in the data directory I tried the same commands with the .exe extenions behind it. Unfortunally I cant make screenshots with remote connection (anyway dont know how to do this) even copy and post doesn't work.
nitrx wrote:mono ExportMySQL /data/April15log.txt this give an error 'Cannot open Assembly 'ExportMySQL' no such file or directory.
Try:
mono ExportMySQL.exe data/Apr15log.txt
So when you do 'mono ExportMySQL.exe dayfile' with the new version, what exactly happens? Does it just exit back to the command prompt straight away without printing anything?