mersenneforum.org  

Go Back   mersenneforum.org > Prime Search Projects > Prime Sierpinski Project

Reply
 
Thread Tools
Old 2010-12-15, 12:14   #1
ltd
 
ltd's Avatar
 
Apr 2003

22·193 Posts
Lightbulb The Update Blog

To keep everybody informed here a report about the progress.

At the moment a full backup of the old system is running and I am bringing down the different servers.

Next steps after the backup:
1. Make an export of all the DBs
2. Store these export on 2 locations.
3. Test import of the export file. ( Has been done before. this time only to check the integrity of the export)

Last fiddled with by ltd on 2010-12-15 at 12:33
ltd is offline   Reply With Quote
Old 2010-12-15, 12:31   #2
ltd
 
ltd's Avatar
 
Apr 2003

11000001002 Posts
Lightbulb

Exports created.
Now copying the files.
ltd is offline   Reply With Quote
Old 2010-12-15, 13:18   #3
ltd
 
ltd's Avatar
 
Apr 2003

30416 Posts
Default

Data stored on my home machine and also an additional external drive.
Next step was the import to one of my local machines to check the integrity of the export files.
I have decided to check the major DBs only. These are the primesierpinski and SR5 masterdata files.
The linux MySQL 4 exports imported without any problems into my Windows MySQL 5 home test DB.

Next step. Install a new OS on the server.
ltd is offline   Reply With Quote
Old 2010-12-15, 14:53   #4
ltd
 
ltd's Avatar
 
Apr 2003

30416 Posts
Default

After a first install with the wrong template now on the correct linux version.
Import of the DBs nearly finished. (Final parts of SR5 master data in progress)

Next step install prpnet server.
ltd is offline   Reply With Quote
Old 2010-12-15, 15:38   #5
ltd
 
ltd's Avatar
 
Apr 2003

22·193 Posts
Default

After installing some libs the old prpntserver 2.7.x can at least be started.
But when I try to compile the 4.0.3 server I get a compiler error stating that I am missing sql.h, sqlext.h and sqltypes.h. I will have to contact Rogue. Hope he can tell me which package I forgot to install.

Last fiddled with by ltd on 2010-12-15 at 15:41
ltd is offline   Reply With Quote
Old 2010-12-15, 18:24   #6
ltd
 
ltd's Avatar
 
Apr 2003

22×193 Posts
Default

The PRPnetserver 2.7 for PSP are online again. (ports 7100 and 7101)
The web pages for PSP and SR5 at least show the old data again.

Open points PRPnet 4.0.3. I get it to compile and to start but no really to work so far. More investigation is needed from my side. By the way many thanks to Rogue. He did send a first reaction to my request within 5 minutes.

For the old llrnet server it looks very bad. So far I did not even find the missing lib. So no way to install something to get it to run again.

Now I will start to look into the stats update.
ltd is offline   Reply With Quote
Old 2010-12-15, 19:12   #7
ltd
 
ltd's Avatar
 
Apr 2003

22·193 Posts
Default

PSP stats look quite good. Only the csvstats have an error at the moment. A select that worked with MySQL 4 now troughs an error.

If the transfer scripts from the PRPnet servers back into the DB really work
has to wait for the first returned result. At least there is no error thrown so far.

P.S. While writing this I have found the reason for the error in the csvstats.
Will be solved within an hour.
ltd is offline   Reply With Quote
Old 2010-12-15, 19:18   #8
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

11000011000012 Posts
Default

Lars, if you need a precompiled Linux PRPnet server binary, I have one for 4.0.2 (which is the same as the latest 4.0.4 on the server, since the only changes since then were in the client) which we're using at NPLB. The binary is for 64-bit Linux. I had to tweak a few things to get it to compile initially, so I suspect you're running into the same errors I did.

If you're interested, just drop me a line at [email]max@noprimeleftbehind.net[/email] and I'll get the binary to you right away.


Edit: whoops, never mind, just re-read your post and realized you were able to get it to compile after all.

Edit 2: I do have a Linux LLRnet binary if you could use that.

Last fiddled with by mdettweiler on 2010-12-15 at 19:20
mdettweiler is offline   Reply With Quote
Old 2010-12-15, 19:36   #9
ltd
 
ltd's Avatar
 
Apr 2003

22·193 Posts
Default

About the llrnet server. The problem is that i have to find a libmysqlclient.so for my debian distribution as my executable requeres that lib.
ltd is offline   Reply With Quote
Old 2010-12-15, 19:44   #10
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

624110 Posts
Default

Quote:
Originally Posted by ltd View Post
About the llrnet server. The problem is that i have to find a libmysqlclient.so for my debian distribution as my executable requeres that lib.
Will this do? https://www.wetransfer.com/dl.php?co...c3337ca23cc75c

It's from Ubuntu 9.04 64-bit; since Ubuntu is a derivative of Debian it should be close enough.
mdettweiler is offline   Reply With Quote
Old 2010-12-15, 19:49   #11
ltd
 
ltd's Avatar
 
Apr 2003

22·193 Posts
Default

For whatever reason I installed a 32Bit OS. (Don't ask me why. I have no good answer) But thanks for looking this up. When I have the stats and the PRPnet 4.0.3 running I will have a closer look to find that lib.
ltd is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Whatever Joey does blog jvang jvang 107 2019-04-05 08:21
My daily (srly?) work blog MisterBitcoin MisterBitcoin 10 2018-03-30 19:35
No update possible Max Information & Answers 5 2009-01-20 18:12
Puzzle Blog grandpascorpion Puzzles 0 2008-07-07 22:53
Project Tools & Blog Xyzzy Lounge 6 2007-09-05 16:27

All times are UTC. The time now is 02:51.

Thu Oct 29 02:51:34 UTC 2020 up 49 days, 2 mins, 1 user, load averages: 1.43, 1.56, 1.59

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.