[Pushpool Web Frontend] Simplecoin v5.0 Opensource PHP/MySQL - NEW RELEASE

[Lolcust]

Hey, just a quick question - are there "noob-friendly" instructions on how to set this baby up, and what are the approximate sys.reqirements (how big a VPS would I need to play around with this baby) ?

No, there are currently no noob-friendly instructions. In fact, I don't recommend anyone trying to setup a public pool without significant development and network knowledge.

For a small pool a 1gb-2core vps might suffice.

I run my install on 4 servers. 1x8core sql, 1x8core pool, 2x2core web & replication

Well, you see, I am contemplating  the creation of a somewhat audacious bitcoin fork, and the way it seems to be coming out, it would be best if it had a pool at "day zero". Thing is, I'm not very rich (otherwise I would have hired a decent coder instead of trying to recall the long foregone days when I tried to learn the mysterious art of making computers do my bidding )

I might convince a close friend to start up a virtualbox vm with 1+ gb RAM on her box in the beginning, but she will likely eventually kill it so she can play Crysis and that other popular shooty thing with more comfort.
Thus, I am looking into possibility of renting a relatively frugal VM for the purpose of my experiment.

[Paul4games]

Simplecoin i have some questions:
1.Am i allowed to mine from different ips(i mean if i'm running 4 rigs i don't want them to get banned because of different ips or so)?
2.If i'm not allowedt o mine form more ips, tell me what's the limit(i mean like 2 ips per worker or 1 ip per worker)?

[simplecoin]

Simplecoin i have some questions:
1.Am i allowed to mine from different ips(i mean if i'm running 4 rigs i don't want them to get banned because of different ips or so)?
2.If i'm not allowedt o mine form more ips, tell me what's the limit(i mean like 2 ips per worker or 1 ip per worker)?

That is based on the pool software you use. My frontend is only for the web. The only IP restriction is one ip logged into the web server at a time, none of this will cause a ban.

[sareea]

Hello,
I am getting these warnings

Code:

] PHP Warning:  Invalid argument supplied for foreach()
in /var/www/includes/stats.php on line 89

and

Code:

] PHP Warning:  Invalid argument supplied for foreach()
in /var/www/stats.php on line 75

[Sat Aug 13 11:47:01 2011] [error] [client 84.228.254.88
] PHP Fatal error:  Call to a member function fetch() on
 a non-object in /var/www/includes/stats.php on line 42,

Some one told me that

Probably this query is not returning a value, so it gives an error.

Code:

$sql = "SELECT count(id) FROM shares WHERE id > $lastwinningshare AND our_result='N'";

Most likely it will go away as soon as it returns something.

( from this article :
https://bitcointalk.org/index.php?topic=36672.0
)

Please help ! It is urgent
thanks !

[simplecoin]

Sorry for the delays. I'm trying to lock-down some things for 4.1.

Also, forum link has changed.

[sareea]

Any updates ?

And can you please provide me a solution for the php fatal error for the that member function ?
I have been stuck for 2 weeks on my pool just because of this .i really thank you for the help

[AnnihilaT]

Sareea,

I really suggest that you dont even bother trying to start a pool simply because if a problem like this gets you stuck for more than two weeks you dont have the technical ability to run a pool.  There will be much larger day to day problems than this one that arise while running a pool.  Its not install and forget software.  You need to be able to program and understand the code because there will be problems and you will need to fix them yourself.  I dont mean to be mean but you are clearly not qualified to run a pool.  Im just being honest and trying to save you alot more pain down the road.

[Keninishna]

ok I almost have your pool up I have one sql issue thats causing the site to fail. I get

Code:

PHP Fatal error:  Call to a member function fetch() on a non-object in /var/www/simplecoin/includes/stats.php on line 276

So I google some and take a look at line 276, I see its under function usersharecount()

Code:

if ($currentSharesR = $currentSharesQ->fetch()) {

Apparently when the fetch fails it returns a false, and its expecting an object so the error causes more errors  
I think my understanding fails at the SQL code above it here:

Code:

$sql = "SELECT count(id) as id FROM shares WHERE id > $lastwinningshare AND username in ('".implode("','",$workers)."')";

I have the database set up properly, it has all the tables, pushpoold is working away I can create a worker (if I comment out the above code) and login and submit shares. Thanks for any help.

edit:
nevermind I found out it was because there was no $lastwinningshare I manually set it to 1 now everything is good (untill i find a block lol)

[sareea]

ok I almost have your pool up I have one sql issue thats causing the site to fail. I get

Code:

PHP Fatal error:  Call to a member function fetch() on a non-object in /var/www/simplecoin/includes/stats.php on line 276

So I google some and take a look at line 276, I see its under function usersharecount()

Code:

if ($currentSharesR = $currentSharesQ->fetch()) {

Apparently when the fetch fails it returns a false, and its expecting an object so the error causes more errors  
I think my understanding fails at the SQL code above it here:

Code:

$sql = "SELECT count(id) as id FROM shares WHERE id > $lastwinningshare AND username in ('".implode("','",$workers)."')";

I have the database set up properly, it has all the tables, pushpoold is working away I can create a worker (if I comment out the above code) and login and submit shares. Thanks for any help.

edit:
nevermind I found out it was because there was no $lastwinningshare I manually set it to 1 now everything is good (untill i find a block lol)

Can you please explain to me how you exactly fixed it ? I am still  a newbie learning the business

Edit : Solved it

[simplecoin]

Version 5 is released 

A lot of bug fixes, especially for new pools!
Even more optimization to sql (especially for multi-million share rounds )
Main cronjob can run every minute with very little impact.
Winning shares are much more easily handled.
Also unconfirmed shares are perfectly accurate.

Tested with lastnpps scoring, will be testing prop soon.

Now to get multi-pool/coin support into the base.

[sareea]

Thanks for the effort.
How can i upgrade from v4 to v5?

[simplecoin]

You'll need to add the new table (unrewarded_shares) and look for other sql changes.

[sareea]

i tested it , it doesn't have the problems v4 had !
Thanks a lot !

I faced few things though :
- Resetting the password with lostpassword didn't work for me, i edited it to be http:// and not https:// as it is in lostpassword.php.
It even ruins the password, even the old password stops working. What should i do ?
I think it is because lostpassword.php uses sha256 encryption and the login.php uses the $salt thing ?

- in accountdetails.php , you added the field ( current password ) to change the password, but even though you put the password it says " you must put your current password" , it doesn't  recognize it .

Thanks a lot simplecoin ! you are awesome !

[mich]

- Resetting the password with lostpassword didn't work for me, i edited it to be http:// and not https:// as it is in lostpassword.php.
It even ruins the password, even the old password stops working. What should i do ?
I think it is because lostpassword.php uses sha256 encryption and the login.php uses the $salt thing ?

lostpassword.php, line 53 must be like:
$result = mysql_query("UPDATE webUsers SET pass='".hash("sha256", $pass.$salt)."', accountFailedAttempts = 0 WHERE  username='$resetUsername' AND emailAuthPin='$resetAuth' ");

[sareea]

- Resetting the password with lostpassword didn't work for me, i edited it to be http:// and not https:// as it is in lostpassword.php.
It even ruins the password, even the old password stops working. What should i do ?
I think it is because lostpassword.php uses sha256 encryption and the login.php uses the $salt thing ?

lostpassword.php, line 53 must be like:
$result = mysql_query("UPDATE webUsers SET pass='".hash("sha256", $pass.$salt)."', accountFailedAttempts = 0 WHERE  username='$resetUsername' AND emailAuthPin='$resetAuth' ");

Yeah it works now thanks .

The only problem left is in changing the password , any idea ? It doesn't recognize that i inserted my current password ...

[sareea]

I tried to do this to fix the changing password problem .

I changed this line
$oldPass = hash("sha256", mysql_real_escape_string($_POST["currentPassword"]));
to
$oldPass = hash("sha256", $oldPass.$salt, mysql_real_escape_string($_POST["currentPassword"]));

But it didn't work.

The update process starts with
if($oldPass == $hashedPass){

I tried to define $hashedPass and fetch the password from the DB to  it .
Still didn't work .

And says
"You must type in the correct current password before you can set a new password. "

Please help

[mich]

I tried to do this to fix the changing password problem .

I changed this line
$oldPass = hash("sha256", mysql_real_escape_string($_POST["currentPassword"]));
to
$oldPass = hash("sha256", $oldPass.$salt, mysql_real_escape_string($_POST["currentPassword"]));

But it didn't work.

The update process starts with
if($oldPass == $hashedPass){

I tried to define $hashedPass and fetch the password from the DB to  it .
Still didn't work .

And says
"You must type in the correct current password before you can set a new password. "

Please help

$oldPass = hash("sha256", mysql_real_escape_string($_POST["currentPassword"]).$salt);

[sareea]

I tried to do this to fix the changing password problem .

I changed this line
$oldPass = hash("sha256", mysql_real_escape_string($_POST["currentPassword"]));
to
$oldPass = hash("sha256", $oldPass.$salt, mysql_real_escape_string($_POST["currentPassword"]));

But it didn't work.

The update process starts with
if($oldPass == $hashedPass){

I tried to define $hashedPass and fetch the password from the DB to  it .
Still didn't work .

And says
"You must type in the correct current password before you can set a new password. "

Please help

$oldPass = hash("sha256", mysql_real_escape_string($_POST["currentPassword"]).$salt);

It works now !! Thanks a lot man

[mich]

Any body know, why MtGox rate don't shows correct about 5 last days? They changed a code?

[Danilo]

Hello everyone,

I set all the parameters of my previous scripts and everything works fine, but I want to move to this one because I prefer this script, but I get the following error:

Fatal error: Uncaught BitcoinClientException:

• : Connect error: Connection refused (111) thrown in on line 0

bitcoind working on port 8332
Workers have a communication with a pushpoold on 8341 and 8344 port.

I entered all that is needed in requiredFunctions.php, and tried different ports but still get that error.

What could be the problem?

Thank you in advance for your reply,