mersenneforum.org PRPNet 5.4.3 Released
 Register FAQ Search Today's Posts Mark Forums Read

 2012-09-16, 14:55 #23 henryzz Just call me Henry     "David" Sep 2007 Cambridge (GMT/BST) 10110110111112 Posts I am having trouble getting my new server to start. I installed mysql and the odbc connector. I created the database and ran the script on it. Whatever I do I can't get the server to connect to the database. Is there a way I can work out at which point it is failing to connect so I can sort it?
2012-09-16, 15:08   #24
rogue

"Mark"
Apr 2003
Between here and the

6,277 Posts

Quote:
 Originally Posted by henryzz I am having trouble getting my new server to start. I installed mysql and the odbc connector. I created the database and ran the script on it. Whatever I do I can't get the server to connect to the database. Is there a way I can work out at which point it is failing to connect so I can sort it?
Set debuglevel=1 in the server. It is most likely an issue with your database.ini file. What OS is this on?

2012-09-16, 15:20   #25
henryzz
Just call me Henry

"David"
Sep 2007
Cambridge (GMT/BST)

585510 Posts

Quote:
 Originally Posted by rogue Set debuglevel=1 in the server. It is most likely an issue with your database.ini file. What OS is this on?
It is windows 7 64-bit. The database.ini is the same as it was when it worked on my old windows installation except that I changed the database name from prpnet5 to prpnet.
Code:
[2012-09-16 16:49:51 GDT] 2: ODBC Connection via a driver: <Driver={MySQL ODBC 5.1 Driver};Server=localhost;Port=3306;Database=prpnet;User=root;UID=root;Password=nopw;PWD=nopw;Option=3;>
[2012-09-16 16:49:51 GDT] Connect to database failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, native code=0

Last fiddled with by henryzz on 2012-09-16 at 15:52 Reason: adding debug log

2012-09-16, 17:12   #26
rogue

"Mark"
Apr 2003
Between here and the

11000100001012 Posts

Quote:
 Originally Posted by henryzz It is windows 7 64-bit. The database.ini is the same as it was when it worked on my old windows installation except that I changed the database name from prpnet5 to prpnet. Code: [2012-09-16 16:49:51 GDT] 2: ODBC Connection via a driver: [2012-09-16 16:49:51 GDT] Connect to database failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, native code=0
Is the driver name correct? Maybe you have a different driver version of MySQL. The name should match the ODBC driver name you see in ODBC administrator. Also, make sure that you are using the 32-bit driver, not the 64-bit driver as the server is a 32-bit app (unless you rebuild it).

2012-09-16, 17:33   #27
henryzz
Just call me Henry

"David"
Sep 2007
Cambridge (GMT/BST)

5·1,171 Posts

Quote:
 Originally Posted by rogue Is the driver name correct? Maybe you have a different driver version of MySQL. The name should match the ODBC driver name you see in ODBC administrator. Also, make sure that you are using the 32-bit driver, not the 64-bit driver as the server is a 32-bit app (unless you rebuild it).
I am using the 64-bit driver. Can I suggest adding that to the readme.txt for future versions?

edit: installing the 32-bit driver solved it

Last fiddled with by henryzz on 2012-09-16 at 17:41

2012-09-16, 18:39   #28
rogue

"Mark"
Apr 2003
Between here and the

6,277 Posts

Quote:
 Originally Posted by henryzz I am using the 64-bit driver. Can I suggest adding that to the readme.txt for future versions? edit: installing the 32-bit driver solved it
Certainly. When I originally released the Windows builds most people were still on 32-bit Windows. I think that has changed, which is a good thing as Window 7 is far superior to any previous version of Windows. Now if M\$ could only rid themselves of the registry.

 2012-09-27, 21:28 #29 henryzz Just call me Henry     "David" Sep 2007 Cambridge (GMT/BST) 133378 Posts Discovered a slightly odd bug/feature today. I loaded a lot of fast work(280k candidates) into a riesel/sierp server. While I was loading the work clients were able to get candidates and return primes. The problem is that while it was still loading candidates(sorted by n) it continued testing a k after finding a prime(once all candidates were loaded the riesel/sierp code came into play). On several occassions it found a second prime for a k before the candidates finished loading. Both primes were put in the logs which is fine. However the larger of the 2 primes would be in the smallest prime column(on the webpage stats) rather than the smaller one. Next time I will shut down the clients. This couldn't be done for something like a CRUS public server though. In addition to this I have a feature request: Could there be a way(quite possible started by the prpadmin) to make the server output all the ks with no prime? Currently I put 200 ks into prpnet and get ~40 out. Unless I used lots of regex's and command line trickery I would have to manually make a list of the remaining ks.
2012-09-28, 00:38   #30
rogue

"Mark"
Apr 2003
Between here and the

188516 Posts

Quote:
 Originally Posted by henryzz Discovered a slightly odd bug/feature today. I loaded a lot of fast work(280k candidates) into a riesel/sierp server. While I was loading the work clients were able to get candidates and return primes. The problem is that while it was still loading candidates(sorted by n) it continued testing a k after finding a prime(once all candidates were loaded the riesel/sierp code came into play). On several occassions it found a second prime for a k before the candidates finished loading. Both primes were put in the logs which is fine. However the larger of the 2 primes would be in the smallest prime column(on the webpage stats) rather than the smaller one. Next time I will shut down the clients. This couldn't be done for something like a CRUS public server though. In addition to this I have a feature request: Could there be a way(quite possible started by the prpadmin) to make the server output all the ks with no prime? Currently I put 200 ks into prpnet and get ~40 out. Unless I used lots of regex's and command line trickery I would have to manually make a list of the remaining ks.
I could fix the first issue you mention, but it would hurt performance when loading the server.

You can get that data via mysql by looking at the CandidateGroupStats table.

2012-09-28, 20:54   #31
henryzz
Just call me Henry

"David"
Sep 2007
Cambridge (GMT/BST)

5×1,171 Posts

Quote:
 Originally Posted by rogue I could fix the first issue you mention, but it would hurt performance when loading the server. You can get that data via mysql by looking at the CandidateGroupStats table.
I will investigate this once my machine with a server on it has internet after the 10th.

 2012-10-08, 16:42 #32 rogue     "Mark" Apr 2003 Between here and the 6,277 Posts I've posted PRPNet 5.1.0. It has the following changes from 5.0.9: prpserver: Fixed debug message. prpclient: Allow only one instance of a client to run at a time from the directory. You can d/l 5.1.0 from here. Last fiddled with by rogue on 2012-10-08 at 16:42
2012-10-21, 19:39   #33
rebirther

Sep 2011
Germany

24·173 Posts

Quote:
 Originally Posted by rogue I've posted PRPNet 5.1.0. It has the following changes from 5.0.9: prpserver: Fixed debug message. prpclient: Allow only one instance of a client to run at a time from the directory. You can d/l 5.1.0 from here.
From the last change I have seen. The client doesnt starting if:

main dir
|_dir core1
|_dir core2
|_dir core3
|_dir core4

Only one client starting. The fix should be active if 2x the same client starting from any of the sub directories not main.

 Similar Threads Thread Thread Starter Forum Replies Last Post ltd Prime Sierpinski Project 86 2012-06-06 02:30 rogue Software 84 2011-11-16 21:20 Joe O Sierpinski/Riesel Base 5 1 2010-10-22 20:11 rogue Conjectures 'R Us 220 2010-10-12 20:48 rogue Conjectures 'R Us 250 2009-12-27 21:29

All times are UTC. The time now is 17:43.

Tue Apr 13 17:43:05 UTC 2021 up 5 days, 12:23, 1 user, load averages: 4.74, 4.77, 4.76