NPLB LLRnet server discussion

[em99010pepe]

Tnerual kindly sent me a new modem. I'll only change it when I upgrade the server to a quad-core, maybe next week or so.

Thank you very much.

Carlos

[kar_bon]

Originally Posted by ET_

I know you use some automation script. Any db? Just curious...

Luigi

i use an awk script to put one result (from the LLRnet server one result contains 3 text-lines with user, date/time and result) in a file with one line per result and all needed data. after that i load them into Ex*el with some vb-scripts to summarize the data or make the graph. that's it. this update i need an hour or so, includes updating the html-pages!

[ET_]

Originally Posted by kar_bon

i use an awk script to put one result (from the LLRnet server one result contains 3 text-lines with user, date/time and result) in a file with one line per result and all needed data. after that i load them into Ex*el with some vb-scripts to summarize the data or make the graph. that's it. this update i need an hour or so, includes updating the html-pages!

I see... I used to update this way Fermatsearch site.
Now I decided to use MySQL and PHP, it's WAAAAAY faster to update

Chapeau to your will and dedition!

Luigi

[em99010pepe]

Originally Posted by ET_

Now I decided to use MySQL and PHP, it's WAAAAAY faster to update

Teach us....

[ET_]

Originally Posted by em99010pepe

Teach us....

Well... the hard thing is designing the needed tables. I use the following schema.

USERS
	id	bigint(20)	not null	key	unique	 
	user	varchar(30)	not null			
	country	varchar(25)	 			
 	stats	decimal(10,3)	 			
	n_divisori_propri	smallint				
 	n_divisori_programma	smallint	 			
						
TASK_DONE	
       from_N	integer	not null	 	 	 
	to_N	integer	not null			
	from_k	bigint(20)	not null			
	to_k	bigint(20)	not null			
	user	varchar(30)	not null			
	stats	decimal(10,3)	not null			
	id	bigint(20)	not null	key	unique	
	type	varchar(10)	not null			
						
TASK_RUNNING
	from_N	integer	not null	 	 	 
	to_N	integer	not null			
	from_k	bigint(20)	not null			
	to_k	bigint(20)	not null			
	user	varchar(30)	not null			
	date	varchar(10)	not null			
	status	varchar(25)	not null			
	id	bigint(20)	not null	key	unique

Obviously you need to choose the fields as you need...

Then install MySQL on the server (or check MySQL and PHP services from your ISP). If you use a local installation of MySQL, you can preload all the tables, export the file in CSV format, and import it onto the ISP database.

Once your tables are loaded, create some PHP pages: they are like HTML, but with some script in them that allow SQL queries from the database.

Put the variables you get from the queries into PHP variables and print them out as HTML tables. You swear a week to get all the fields centered, and finally forget all the burden of counting and summing and substituting.

The key is the script that inserts your results into the tables, and you can do it locally, reloading the tables via import on the server each time you modify it. All the accounting, HTML and recalculation of positions is done by PHP embedded into HTML.

We can work a template together if you like it.

Luigi

[kar_bon]

sounds good.
i know, www.rieselprime.org provide php too, but my php-knowledge is far away from setting up a database with sql-statements (i know sql quite good).
all the data shown in the summary-pages on that hompage should be stored in such DB so maintaining is heavenly easy. (by now i do this with awk scripts too).

would be nice to work on such things! after the 24h race???

[ET_]

Originally Posted by kar_bon

sounds good.
i know, www.rieselprime.org provide php too, but my php-knowledge is far away from setting up a database with sql-statements (i know sql quite good).
all the data shown in the summary-pages on that hompage should be stored in such DB so maintaining is heavenly easy. (by now i do this with awk scripts too).

would be nice to work on such things! after the 24h race???

AWK is my black beast

I learnt PHP doing jobs like this, and now maintain both Billion Digits Project and FermatSearch in zero time. It's not hard to learn, one just has to keep in mind three or four items.

We can arrange some discussion after the race, agreed.

Luigi

[em99010pepe]

Originally Posted by ET_

We can arrange some discussion after the race, agreed.

Luigi

We appreciate. BTW, my offer still stands, I just need more free time to learn ecmserver settings. Last time I played with it I couldn't run it because a few files were missing, probably the work files .

Carlos

[em99010pepe]

Top 5000 candidates are already in the server. It will take a day or two to clean the lower ranges. Let the real fun begin!

[gd_barnes]

Originally Posted by em99010pepe

Top 5000 candidates are already in the server. It will take a day or two to clean the lower ranges. Let the real fun begin!

ROCK ON!!

I'll delete the 320-333.2 files from the 1st post in that thread. It looks like I better add some more files to drive 1. I'll do that on Monday or Tuesday.

From here on, I'll just leave it to you and Karsten to make sure all k / n pairs get tested that are reserved by the LLRnet server. If needed, I can assist in verifying.


Gary

[em99010pepe]

Thanks Gary. I'm going to try to set up a second server for NPLB on my work machine...
Meanwhile, all results from LLRnet are daily published on this page.