Page 2 of 4
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 7:19 am
by Nossie
Code: Select all
2024-09-10 08:14:04.940 Information Diary constructor: starting
2024-09-10 08:14:04.952 Error Exception Unknown : The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception.
2024-09-10 08:14:04.954 Error Data (cont): Microsoft.Data.Sqlite
2024-09-10 08:14:04.982 Error Data: at Microsoft.Data.Sqlite.SqliteConnection..ctor(String connectionString)
at CumulusUtils.Diary.GetDiaryDatabase() in C:\Users\hansr\Documents\GitHub\CutilsFramework\CUtilsNET8\Diary.cs:line 99
at CumulusUtils.Diary..ctor(CuSupport s) in C:\Users\hansr\Documents\GitHub\CutilsFramework\CUtilsNET8\Diary.cs:line 61
at CumulusUtils.CUtils.RealMainAsync(String[] args) in C:\Users\hansr\Documents\GitHub\CutilsFramework\CUtilsNET8\Main.cs:line 609
at CumulusUtils.CUtils.Main(String[] args) in C:\Users\hansr\Documents\GitHub\CutilsFramework\CUtilsNET8\Main.cs:line 343
2024-09-10 08:14:04.984 Error Exiting - check log file
hmmmm - nope I don't have a user account called hansr......
I've just uploaded the whole folder - I was messing about with a few of them there are some lsb errors too related to the sqlite, something to do with your bin stuff?
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 10:30 am
by HansR
Hmmm... Back home tonight, i'll come back to this.
Does anybody else have an issue here?
@nossie: do you have a diary.db at all?
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 3:32 pm
by Nossie
working quite late - will check when I can -thanks
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 4:34 pm
by PaulMy
Hi Hans,
Does anybody else have an issue here?
@nossie: do you have a diary.db at all?
Everything seems ok here. The only thing in my diary.db is my snow reporting, which I have not updated since end of March.
Not sure if this is helpful, from utilslog at the midnight "website" run
Code: Select all
2024-09-10 00:00:06.355 Information Diary constructor: starting
2024-09-10 00:00:06.713 Information Diary constructor: stop
2024-09-10 00:00:06.713 Generating Diary - Starting
2024-09-10 00:00:06.714 Information End Generating Diary
Code: Select all
2024-09-10 00:00:54.770 Information UploadFile: Starting utils/diary.txt => diary.txt
2024-09-10 00:00:54.770 Information Upload File values: URL: 198.12.220.99
2024-09-10 00:00:54.770 Information Upload File values: CMX Dir: public_html/cumulusmxwll
2024-09-10 00:00:54.770 Information Upload File values: UtilsDir:
2024-09-10 00:00:54.770 Information Upload File values: remotefile: diary.txt
2024-09-10 00:00:54.770 Information Upload File values: requestname: public_html/cumulusmxwll/diary.txt
2024-09-10 00:00:55.436 Information FTP/FTPS UploadFile: Done
Enjoy,
Paul
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 5:29 pm
by weatherbee
It seems to be working well for me. I use the diary.db for snow only.
It can be seen at
https://www.shermanctweather.org/cmv4/index.html
Tom
EDIT: I fixed web address.
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 6:20 pm
by HansR
Thanks @Paul and @Tom
@Tom: your link does not lead to anything
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 7:22 pm
by Nossie
HansR wrote: ↑Tue 10 Sep 2024 10:30 am
@nossie: do you have a diary.db at all?
Hi Hans,
Can confirm I don't use the diary feature - don't have that file on the website.
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 7:43 pm
by HansR
Mmm... I think CMX should Create that file no matter what at initialisation. It is part of the data even if empty.
Try editing the diary and save without adding data.
@Mark (@anybody) : how can the file be added later?
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 7:53 pm
by Nossie
sorry hans misunderstanding - it exists in the data folder locally
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 8:03 pm
by HansR
Mmm... Which permissions does it have (unix bitwise).
Could you post it please?
Re: v7.2.0 b1
Posted: Tue 10 Sep 2024 8:50 pm
by Nossie
-rw-r--r-- 1 pi pi 12288 Sep 10 20:47 diary.db
Re: v7.2.0 b1
Posted: Wed 11 Sep 2024 6:01 am
by HansR
Thanks.
The diary itself is OK and it has the correct permissions.
Are you aware - I am thinking of Docker implications - that there are new libraries in the distribution notably the SQLite libs and the runtimes. Do they need to be registered somewhere? It is very unclear to me how a path from my distribution can get into the database path where the code only says:
Code: Select all
new( $"DataSource=data/diary.db; Mode=ReadOnly;" )
so it is relative to your path. I am lost
EDIT: Oh wait the path is only in the error messages. Still: it has a problem with the path so you need to check the path of
diary.db in the data directory.
Re: v7.2.0 b1
Posted: Wed 11 Sep 2024 7:22 am
by Nossie
What I was wondering is - it using the right distribution?
I'm questioning 2 things -- should hansr still be a location in your code once compiled and why is it showing a windows path? is that mono related?
I run Debian on arm, with an ubuntu container running dotnet.
Re: v7.2.0 b1
Posted: Wed 11 Sep 2024 10:38 am
by mcrossley
Nossie wrote: ↑Wed 11 Sep 2024 7:22 am
I'm questioning 2 things -- should hansr still be a location in your code once compiled and why is it showing a windows path? is that mono related?
It is debug information showing the source file and line number where the error occurred. The source file is on Hans' computer and so shows the path on his computer when the program was compiled, this is normal.
Re: v7.2.0 b1
Posted: Wed 11 Sep 2024 12:09 pm
by HansR
Thanks @Mark.
@Ian: I would say you have to revisit the installation with the delivered libraries as nobody else has your problem. So it seems to have to do with the docker installation.