mersenneforum.org  

Go Back   mersenneforum.org > Great Internet Mersenne Prime Search > Software

Reply
 
Thread Tools
Old 2012-09-16, 14:55   #23
henryzz
Just call me Henry
 
henryzz's Avatar
 
"David"
Sep 2007
Cambridge (GMT)

26·89 Posts
Default

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?
henryzz is offline   Reply With Quote
Old 2012-09-16, 15:08   #24
rogue
 
rogue's Avatar
 
"Mark"
Apr 2003
Between here and the

133408 Posts
Default

Quote:
Originally Posted by henryzz View Post
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?
rogue is offline   Reply With Quote
Old 2012-09-16, 15:20   #25
henryzz
Just call me Henry
 
henryzz's Avatar
 
"David"
Sep 2007
Cambridge (GMT)

26×89 Posts
Default

Quote:
Originally Posted by rogue View Post
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
henryzz is offline   Reply With Quote
Old 2012-09-16, 17:12   #26
rogue
 
rogue's Avatar
 
"Mark"
Apr 2003
Between here and the

25×3×61 Posts
Default

Quote:
Originally Posted by henryzz View Post
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
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).
rogue is offline   Reply With Quote
Old 2012-09-16, 17:33   #27
henryzz
Just call me Henry
 
henryzz's Avatar
 
"David"
Sep 2007
Cambridge (GMT)

10110010000002 Posts
Default

Quote:
Originally Posted by rogue View Post
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
henryzz is offline   Reply With Quote
Old 2012-09-16, 18:39   #28
rogue
 
rogue's Avatar
 
"Mark"
Apr 2003
Between here and the

25×3×61 Posts
Default

Quote:
Originally Posted by henryzz View Post
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.
rogue is offline   Reply With Quote
Old 2012-09-27, 21:28   #29
henryzz
Just call me Henry
 
henryzz's Avatar
 
"David"
Sep 2007
Cambridge (GMT)

26×89 Posts
Default

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.
henryzz is offline   Reply With Quote
Old 2012-09-28, 00:38   #30
rogue
 
rogue's Avatar
 
"Mark"
Apr 2003
Between here and the

25×3×61 Posts
Default

Quote:
Originally Posted by henryzz View Post
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.
rogue is offline   Reply With Quote
Old 2012-09-28, 20:54   #31
henryzz
Just call me Henry
 
henryzz's Avatar
 
"David"
Sep 2007
Cambridge (GMT)

10110010000002 Posts
Default

Quote:
Originally Posted by rogue View Post
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.
henryzz is offline   Reply With Quote
Old 2012-10-08, 16:42   #32
rogue
 
rogue's Avatar
 
"Mark"
Apr 2003
Between here and the

25×3×61 Posts
Default

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
rogue is offline   Reply With Quote
Old 2012-10-21, 19:39   #33
rebirther
 
rebirther's Avatar
 
Sep 2011
Germany

2,423 Posts
Default

Quote:
Originally Posted by rogue View Post
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.
rebirther is offline   Reply With Quote
Reply

Thread Tools


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

All times are UTC. The time now is 04:56.

Fri Aug 14 04:56:15 UTC 2020 up 1 day, 1:31, 1 user, load averages: 0.96, 1.15, 1.27

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.