v7.2.0 b1

[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?

[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?

[Nossie]

working quite late - will check when I can -thanks

[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

https://www.komokaweather.com/cumulusmxwll/index.html

Enjoy,
Paul

[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.

[HansR]

Thanks @Paul and @Tom

@Tom: your link does not lead to anything

[Nossie]

@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.

[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?

[Nossie]

sorry hans misunderstanding - it exists in the data folder locally

[HansR]

Mmm... Which permissions does it have (unix bitwise).
Could you post it please?

[Nossie]

-rw-r--r-- 1 pi pi 12288 Sep 10 20:47 diary.db

[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.

[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.

[mcrossley]

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.

[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.