The Update Blog

ltd · 2010-12-15, 12:14

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)

ltd · 2010-12-15, 12:31

Exports created.
Now copying the files.

ltd · 2010-12-15, 13:18

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 · 2010-12-15, 14:53

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 · 2010-12-15, 15:38

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.

ltd · 2010-12-15, 18:24

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 · 2010-12-15, 19:12

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.

mdettweiler · 2010-12-15, 19:18

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.

ltd · 2010-12-15, 19:36

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.

mdettweiler · 2010-12-15, 19:44

Quote:

Originally Posted by ltd

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.

ltd · 2010-12-15, 19:49

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.

2010-12-15, 12:14	#1
ltd Apr 2003 2²·193 Posts	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

2010-12-15, 15:38	#5
ltd Apr 2003 2²×193 Posts	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

2010-12-15, 19:18	#8
mdettweiler A Sunny Moo Aug 2007 USA (GMT-5) 3·2,083 Posts	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

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

2010-12-15, 12:31	#2
ltd Apr 2003 304₁₆ Posts	Exports created. Now copying the files.

2010-12-15, 13:18	#3
ltd Apr 2003 2²×193 Posts	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.

2010-12-15, 14:53	#4
ltd Apr 2003 2²·193 Posts	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.

2010-12-15, 18:24	#6
ltd Apr 2003 304₁₆ Posts	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.

2010-12-15, 19:12	#7
ltd Apr 2003 2²·193 Posts	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.

2010-12-15, 19:36	#9
ltd Apr 2003 2²·193 Posts	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.

2010-12-15, 19:49	#11
ltd Apr 2003 304₁₆ Posts	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.