Automatic publishing of results

Message boards : Code and Servers : Automatic publishing of results
Message board moderation

To post messages, you must log in.

AuthorMessage
Tomáš Brada
Project administrator
Volunteer developer
Avatar

Send message
Joined: 3 Feb 19
Posts: 634
Credit: 445,023
RAC: 12
Message 3401 - Posted: 1 Jul 2019, 9:59:35 UTC

What to export:

  • plain all ODLS directly from the database in N58 format
  • incremental SQL dump of the result database (tot_segment, tot_result, tot_odlk, tot_result_odlk)
  • incremental ODLS in n58 format
  • status of segments, maximum CF, CF density


I am thinking about granting public read-only access to the mysql database holding the results. But there are security problems and few people discouraged me from this.
Third, it would be cool to have some nice stats and progress visible on the web-page.
Last, I want to add symmetry, rule and degree info of odls to the database.

ID: 3401 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 3402 - Posted: 1 Jul 2019, 18:18:04 UTC
Last modified: 2 Jul 2019, 2:17:40 UTC

I see that the problem "automatic publishing of results" is very difficult for you.

Please solve a simpler problem - exporting current results for me.

For example, as it is done here
https://boinc.tbrada.eu/forum_thread.php?id=3023&postid=3358#3358
ID: 3402 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Tomáš Brada
Project administrator
Volunteer developer
Avatar

Send message
Joined: 3 Feb 19
Posts: 634
Credit: 445,023
RAC: 12
Message 3403 - Posted: 2 Jul 2019, 11:45:09 UTC - in response to Message 3402.  

It is not difficult. It is easier than getting the validator/asimilator/wugenerator running. But I was not working on it, I had other tasks to do.
Now, i set up automatic exporting. There is a file: https://boinc.tbrada.eu/download/tot_odlk_plain.txt
This file is updated every 12 hours, starting from now, with all the ODLS in the project database. Nothing more, nothing less.
Do you want to protect this file with password?
ID: 3403 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 3404 - Posted: 2 Jul 2019, 12:08:40 UTC - in response to Message 3403.  
Last modified: 2 Jul 2019, 12:10:13 UTC

Do you want to protect this file with password?

These are the results of your project
©2019 Tomáš Brada

The question of protecting your results is up to you.
If you do not want to open the current results, make a password for this file, which let me know.

I hope that you will maintain the project database and publish it monthly.

Unfortunately, everything is very difficult with the database in ODLK and ODLK1 projects.
By the way, in the ODLK project the current results are open, and in the ODLK1 project they are password protected.
ID: 3404 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Tomáš Brada
Project administrator
Volunteer developer
Avatar

Send message
Joined: 3 Feb 19
Posts: 634
Credit: 445,023
RAC: 12
Message 3405 - Posted: 2 Jul 2019, 12:22:05 UTC
Last modified: 2 Jul 2019, 12:27:20 UTC

I added a copyright note in the export file. Note that the export file mentioned here is just a temporary solution.
ID: 3405 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 3407 - Posted: 2 Jul 2019, 13:00:31 UTC - in response to Message 3405.  

Note that the export file mentioned here is just a temporary solution.

That's enough for me.
ID: 3407 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 3478 - Posted: 22 Jul 2019, 3:22:03 UTC
Last modified: 22 Jul 2019, 3:30:43 UTC

Tomáš Brada
When do you plan to publish the processed results?

The project works the second month.
Found about 500.000 CFs ODLS.

PS. After publishing the processed results the
https://boinc.tbrada.eu/download/tot_odlk_plain.txt file needs to be replaced.
ID: 3478 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 3494 - Posted: 2 Aug 2019, 2:21:14 UTC - in response to Message 3478.  

Tomáš Brada
When do you plan to publish the processed results?

The project works the second month.
Found about 500.000 CFs ODLS.

PS. After publishing the processed results the
https://boinc.tbrada.eu/download/tot_odlk_plain.txt file needs to be replaced.

I would like to receive an answer.
ID: 3494 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Tomáš Brada
Project administrator
Volunteer developer
Avatar

Send message
Joined: 3 Feb 19
Posts: 634
Credit: 445,023
RAC: 12
Message 3522 - Posted: 17 Aug 2019, 12:05:38 UTC

Indeed, postprocessing is not working (not implemented yet). But the automated export works.
Moreover, I would like to bring to attention the full result database export here:
https://boinc.tbrada.eu/download/tot_odlk_dump.sql.gz.
ID: 3522 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Tomáš Brada
Project administrator
Volunteer developer
Avatar

Send message
Joined: 3 Feb 19
Posts: 634
Credit: 445,023
RAC: 12
Message 3623 - Posted: 23 Sep 2019, 7:35:34 UTC

remoinder for myself to finally do this
ID: 3623 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Tomáš Brada
Project administrator
Volunteer developer
Avatar

Send message
Joined: 3 Feb 19
Posts: 634
Credit: 445,023
RAC: 12
Message 3762 - Posted: 5 Nov 2019, 15:21:35 UTC

I renamed the tot_odlk_plain.txt to tot_odlk_p201911.txt and the new file tot_odlk_plain.txt will now contain only odlk after internal id 526126. The SQL dump (tot_odlk_dump.sql.gz) remains as it is and it is now 88MiB)
Sha1 checksum: 742081447242fccc1267ee29a9f628d20f65954b download/tot_odlk_p201911.txt
Natalia, please have a look.
ID: 3762 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 3764 - Posted: 5 Nov 2019, 15:44:29 UTC - in response to Message 3762.  

I renamed the tot_odlk_plain.txt to tot_odlk_p201911.txt and the new file tot_odlk_plain.txt will now contain only odlk after internal id 526126. The SQL dump (tot_odlk_dump.sql.gz) remains as it is and it is now 88MiB)
Sha1 checksum: 742081447242fccc1267ee29a9f628d20f65954b download/tot_odlk_p201911.txt
Natalia, please have a look.

I downloaded the results from tot_odlk_plain.txt this morning, I had 521823 CF.
Now I downloaded the results from the renamed file, in this file I also see 521823 CF.
It is right?

Please do the automatic processing of the results.
Take a look at the ODLK1 project!
The project has been working for only two years, and ice00 can no longer cope with the database.

We agreed that the results of the experiment will be published monthly.
4.5 months have passed, there is no database.
ID: 3764 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 4196 - Posted: 16 Jul 2020, 3:37:36 UTC

Dear Tomáš Brada!

Where can I see the new results from the PADLS TOTAL rule 51 subproject?
I downloaded the results from the link
https://boinc.tbrada.eu/download/tot_odlk_plain.txt

I see
# Copyright Tomas Brada. Contact tomasbrod@azet.sk before use.
1AnnpTimbS3P3qTrDCuePMc2x
1AR9msBJBMs2Sui6MDKwh8TFb
1AS39Sq5CDNh8fdYMS4eRkcvE
1ASGDSkwVEZoxYkZ9LCL9gG2u
1ASHJYfedMi12bfyk1CSEj9eD
1B39BAdHu1ieo1XcUDHtYCSnu
1B3tnwrqP8yUyvvum2SwkQKpt
1B5BduXTsH3dMs28oEoVJtfWK
1baqsdQCzE6Pk9tqHMGwHwCHp

. . . . . . . .

ZzZy9rNu2SaPY9KjPH6JkXknM
ZzZypf9tWHqmFb9DX5zKZ3Acf
ZZzyYBAThQSDFeHZYWbzwbTPh
ZzZzGP9E1Gvmytrh774D88ufY
ZzZzGWFPCFw992jDCPSehubed
ZzZzJQ6cnKmSkoaEu5GAQqvRu
ZzZzpNUbNMcvMi4MT4yJ538tJ
ZZZzrYjE35NzUoJi32A8iF9LK
ZzZzvpiRcQXwtcLAQ5AE7PTTp
ZZZzXV1wT949r5uyfCx7SEopr

I saw the same results on June 15, 2020.
Where can I see the following results???

I think that the results of the project should be available to everyone.
ID: 4196 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 4275 - Posted: 6 Sep 2020, 7:17:35 UTC - in response to Message 4196.  

Dear Tomáš Brada!

Where can I see the new results from the PADLS TOTAL rule 51 subproject?

I would like to receive an answer!

If project results are not publicly available, maybe you can send me the results?
As the author of the project, do I have the right to see the results?
ID: 4275 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 4279 - Posted: 7 Sep 2020, 14:32:51 UTC
Last modified: 7 Sep 2020, 14:39:52 UTC

I downloaded DB from the link
https://boinc.tbrada.eu/download/tot_odlk_dump.sql.gz
I see in the file



What should I do about it? :(
How do I extract the database from the file - only codes of squares?

I've downloaded and installed MySQL, but I don't know how to use it.
ID: 4279 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 4281 - Posted: 13 Sep 2020, 5:11:03 UTC

Tomáš Brada
please see this post and the following
https://boinc.progger.info/odlk/forum_thread.php?id=104&postid=6367

I would like to receive an explanation.
ID: 4281 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Tomáš Brada
Project administrator
Volunteer developer
Avatar

Send message
Joined: 3 Feb 19
Posts: 634
Credit: 445,023
RAC: 12
Message 4282 - Posted: 14 Sep 2020, 12:44:55 UTC - in response to Message 4281.  

Tomáš Brada
please see this post and the following
https://boinc.progger.info/odlk/forum_thread.php?id=104&postid=6367
I would like to receive an explanation.

I do not have any more solutions than those in file https://boinc.tbrada.eu/download/tot_odlk_plain.txt and the archive file.
ID: 4282 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Tomáš Brada
Project administrator
Volunteer developer
Avatar

Send message
Joined: 3 Feb 19
Posts: 634
Credit: 445,023
RAC: 12
Message 4283 - Posted: 14 Sep 2020, 12:50:08 UTC

New archive files
I renamed the tot_odlk_plain.txt to tot_odlk_p202009.txt and the new file tot_odlk_plain.txt will now contain only odlk after internal id 910053. Previous archive file remains tot_odlk_p201911.txt.
Sha1: 742081447242fccc1267ee29a9f628d20f65954b tot_odlk_p201911.txt
Sha1: f37ba72d8e46debe211bf3612ef911715d2d652e tot_odlk_p202009.txt
ID: 4283 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 4286 - Posted: 14 Sep 2020, 18:37:18 UTC
Last modified: 14 Sep 2020, 18:38:06 UTC

I saw the same results on June 15, 2020.
Where can I see the following results???


I do not have any more solutions than those in file https://boinc.tbrada.eu/download/tot_odlk_plain.txt and the archive file.


So, after June 15, 2020 no solutions have been found in the project.

What is the reason?
ID: 4286 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote
Natalia Makarova
Project scientist
Avatar

Send message
Joined: 8 Feb 19
Posts: 356
Credit: 0
RAC: 0
Message 4287 - Posted: 14 Sep 2020, 18:47:32 UTC

22 tot5-m 6904 491 10 274 498


https://boinc.tbrada.eu/server_status.php

What is 10 in the "Received" column???
Are these solutions?

I am constantly watching the project.
Often there are some numbers in the "Received" column.
Is this not a solutions?
ID: 4287 · Rating: 0 · rate: Rate + / Rate - Report as offensive     Reply Quote

Message boards : Code and Servers : Automatic publishing of results

©2021 Tomáš Brada