mersenneforum.org  

Go Back   mersenneforum.org > Prime Search Projects > Conjectures 'R Us

Reply
 
Thread Tools
Old 2010-01-02, 18:43   #1
rogue
 
rogue's Avatar
 
"Mark"
Apr 2003
Between here and the

2·13·227 Posts
Default PRPNet 3.0.0 Released

I have finally released PRPNet 3.0.0.

This is a beta release. I can only do so much testing of the various ways in which people will use it. Clients do not need to update, but I recommend that if you are using a pre-2.4 client that you upgrade. I intend to remove support for 2.3 prior releases of the client in a future release.

Note that this is a significant release on the server side. I think that about 80% of the server code was rewritten to support MySQL and multi-threading. I have done a lot of testing on Windows and OS X. Those features appear to be working.

As for minor clean-up, I suggest using the new prpserver.ini file. Many options have been removed from the old ini file.

Upgrading is relatively simple. d/l and install MySQL (http://www.mysql.com). Create a new database, connect to it with the mysql tool then run the create_tables.sql script. Use the -u option with the prpserver executable to import the prpserver.candidates and userstats.ini files into the database. After you have verified the correctness of the database, restart the server with no command line options. The server will connect to the database directly through the driver, so a DSN is not required (or supported for that matter, although that could change). Modify the mysql.ini file in the server directly to point to your database. BTW, I also recommend that the mysql root user has a password. Although the PRPNet server has code to allow that password to be blank (the mysql default), it has not been tested.

I recommend upgrading slowing (one server every day) so that any bugs that crop up can be quickly addressed. Once bugs have been ironed out, I will open up to requests for new features.

I also fixed the SMTP issue, although I forgot mention it in the release notes.

Finally, the server_stats page looks completely different. It has a lot more data than it used to have. I am very open to splitting that page into two because it currently looks really cluttered.

You can d/l it from http://home.roadrunner.com/~mrodenki...pnet_3.0.0.zip
rogue is online now   Reply With Quote
Old 2010-01-02, 19:25   #2
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

3·2,083 Posts
Default

Nice work! I don't have much experience with MySQL but I imagine I should be able to get it set up for PRPnet with a little Googling. I'll try it on my personal server first and then, if that works well, upgrade the public ones gradually as you suggest.

BTW, is there an procedure inverse to the -u option that lets the server write its database content out to plain text files? That would be quite handy when moving a server from one machine to another (which we'll need to do in the near future with all our NPLB servers).

Last fiddled with by mdettweiler on 2010-01-02 at 19:25
mdettweiler is offline   Reply With Quote
Old 2010-01-02, 19:52   #3
rogue
 
rogue's Avatar
 
"Mark"
Apr 2003
Between here and the

2×13×227 Posts
Default

Quote:
Originally Posted by mdettweiler View Post
Nice work! I don't have much experience with MySQL but I imagine I should be able to get it set up for PRPnet with a little Googling. I'll try it on my personal server first and then, if that works well, upgrade the public ones gradually as you suggest.

BTW, is there an procedure inverse to the -u option that lets the server write its database content out to plain text files? That would be quite handy when moving a server from one machine to another (which we'll need to do in the near future with all our NPLB servers).
MySQL has the ability to export/import databases. Here is one page that shows the command: http://www.clockwatchers.com/mysql_dump.html
rogue is online now   Reply With Quote
Old 2010-01-02, 20:11   #4
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

3×2,083 Posts
Default

Quote:
Originally Posted by rogue View Post
MySQL has the ability to export/import databases. Here is one page that shows the command: http://www.clockwatchers.com/mysql_dump.html
Thanks, that looks like it will do the trick nicely.
mdettweiler is offline   Reply With Quote
Old 2010-01-03, 00:43   #5
Lennart
 
Lennart's Avatar
 
"Lennart"
Jun 2007

25·5·7 Posts
Default

I am now loading a big file into DB using -u

But i cant get it to load with prpadmin.

This is on Win. have not started on Linux yet.



Lennart
Lennart is offline   Reply With Quote
Old 2010-01-03, 00:43   #6
MyDogBuster
 
MyDogBuster's Avatar
 
May 2008
Wilmington, DE

B2416 Posts
Default

Followed all the instructions. I can see the database thru the MYSQL tool and even see the structure of the tables. When I start the prpserver, I get this.

[2010-01-03 00:31:22 GMT] ODBC Connection String: <Driver={MySQL ODBC 5.1 Driver};Server=localhost;Port=3306;Database=C:\ProgramData\MySQL\MySQL Server 5.1\data\prpnet;User=root;Password=buster;Option=3;>
[2010-01-03 00:31:22 GMT] Connect to database failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, native code=0

The database in Windows is actually a folder. I'm pointing to the folder. Is that correct?

MySql.ini looks like this:

driver=MySQL ODBC 5.1 Driver
server=localhost
port=3306
database=C:\ProgramData\MySQL\MySQL Server 5.1\data\prpnet
user=root
password=buster

Last fiddled with by MyDogBuster on 2010-01-03 at 00:45
MyDogBuster is offline   Reply With Quote
Old 2010-01-03, 00:59   #7
mdettweiler
A Sunny Moo
 
mdettweiler's Avatar
 
Aug 2007
USA (GMT-5)

3×2,083 Posts
Default

Quote:
Originally Posted by MyDogBuster View Post
Followed all the instructions. I can see the database thru the MYSQL tool and even see the structure of the tables. When I start the prpserver, I get this.

[2010-01-03 00:31:22 GMT] ODBC Connection String: <Driver={MySQL ODBC 5.1 Driver};Server=localhost;Port=3306;Database=C:\ProgramData\MySQL\MySQL Server 5.1\data\prpnet;User=root;Password=buster;Option=3;>
[2010-01-03 00:31:22 GMT] Connect to database failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, native code=0

The database in Windows is actually a folder. I'm pointing to the folder. Is that correct?

MySql.ini looks like this:

driver=MySQL ODBC 5.1 Driver
server=localhost
port=3306
database=C:\ProgramData\MySQL\MySQL Server 5.1\data\prpnet
user=root
password=buster
Not knowing much about MySQL, on a hunch I'd suggest that you set database= to "prpnet" instead of the full path.
mdettweiler is offline   Reply With Quote
Old 2010-01-03, 01:10   #8
MyDogBuster
 
MyDogBuster's Avatar
 
May 2008
Wilmington, DE

285210 Posts
Default

Quote:
Not knowing much about MySQL, on a hunch I'd suggest that you set database= to "prpnet" instead of the full path.
Tried that also before. No luck. Everything seems to center around not finding the MySQL database. I can't load it or start it up. But I can see it from the MySql tool.

Last fiddled with by MyDogBuster on 2010-01-03 at 01:11
MyDogBuster is offline   Reply With Quote
Old 2010-01-03, 01:17   #9
Lennart
 
Lennart's Avatar
 
"Lennart"
Jun 2007

112010 Posts
Default

Quote:
Originally Posted by MyDogBuster View Post
Tried that also before. No luck. Everything seems to center around not finding the MySQL database. I can't load it or start it up. But I can see it from the MySql tool.
Do you have the ODBC driver installed ?

Lennart
Lennart is offline   Reply With Quote
Old 2010-01-03, 01:46   #10
MyDogBuster
 
MyDogBuster's Avatar
 
May 2008
Wilmington, DE

22·23·31 Posts
Default

Thanks Lennart, that did the trick. The only problem I have left is to populate the DB. The PRPAdmin password I have been using doesn't work. How do I reset it?

BTW, besides installing an OBDC driver, I had to change the database name in the MYSQL.ini file to just prpnet, so Max was right.
MyDogBuster is offline   Reply With Quote
Old 2010-01-03, 02:10   #11
Lennart
 
Lennart's Avatar
 
"Lennart"
Jun 2007

112010 Posts
Default

Quote:
Originally Posted by MyDogBuster View Post
Thanks Lennart, that did the trick. The only problem I have left is to populate the DB. The PRPAdmin password I have been using doesn't work. How do I reset it?
You change the password in prpserver.ini

Code:
//   7 - Twin (k*b^n+/-1)                                       
//   8 - Generalized Fermat Number (GFN)                        
servertype=3                                                    
                                                                
// The password is required if using the prpadmin tool          
adminpassword=password          <<<<<<<<<<<<<<<<<< Here !!!                          
                                                                
// This is required if the e-mail server requires SMTP authentic
// the password to the aforementioned e-mail account.           
emailpassword=
Lennart

Last fiddled with by Lennart on 2010-01-03 at 02:11
Lennart is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
PRPNet 5.4.3 Released rogue Software 163 2020-07-11 14:51
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 released! rogue Conjectures 'R Us 250 2009-12-27 21:29

All times are UTC. The time now is 01:52.

Tue Sep 22 01:52:49 UTC 2020 up 11 days, 23:03, 0 users, load averages: 1.76, 1.52, 1.53

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.