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

[mich]

Share counting and block update isn't working, what is wrong with my minipool ? I've setup cronjobs (of all files in cronjobs folder). Could you please show me a example of crontab -e ?

Yes, I would like to take a look this too. I need correct time interval for each of cronjobs file. When last my block was found frontend shown me balance >1000 except ~23... unknown mistake again

Could you please show yours ? it seems the block & earnings are updating in yours, in mine they aren't.

backupwallet.php - 1 per day
archive.php - every 5 minutes
hashrate.php - 30 minutes
payout.php - 10 minutes
shares.php - 2 minutes
cronjob.php - 3 minutes

[1715437941]

1715437941

[1715437941]

1715437941

[Korvalkov_V]

No, fix by edited requiredFunctions.php (lock - unlock "shares")...
I hope that it was fixed...
Will see on next found block. Good sign - networkBlocks updates by every next block and part of last row in winningshares has been updated automatically.

Can you plz tell us what exactly did you change in lock/unlock functions?

[mich]

No, fix by edited requiredFunctions.php (lock - unlock "shares")...
I hope that it was fixed...
Will see on next found block. Good sign - networkBlocks updates by every next block and part of last row in winningshares has been updated automatically.

Can you plz tell us what exactly did you change in lock/unlock functions?

Actually I didnt understand, I've disabled functions lock/unlock, then run cronjob.php - it was done without errors, then enabled back lock/unlock and script still work correct.

[mich]

I think its up to you. About "any changes" - when you type your own settings logins, passwords, email etc. in php files, it is changing a code or not? 
P.S. If somebody needs my changes - feel free to ask

[simplecoin]

question about the license

any change that id done on the code needs to be make public and under same license true ?

That's the spirit of it. In theory, if anyone asks, the code must be made public if you change any existing files or include the code from existing files.

Although, only I think only 1 site is sharing their code base. BurningToad was kind enough to share his code as well upon request as well.

[shads]

Hi Simplecoin,

Just thought I'd point out to you the new version of poolserver includes the capability to send coinbase donations.  I wrote it so pool ops can donate to any address so that other devs of other open source software that pools use can benefit as well.

It's explained in detail in this post: https://bitcointalk.org/index.php?topic=51226.0

To be able to receive donations you need to put up a page that returns json something like this:
http://poolserverj.org/meta/donations/

But obviously with your own addresses.  Then of course make it known what your donation URL is.  Suggest you fill in the testnets as well.

[cablepair]

looking for some help

Not sure what I am doing wrong, I have setup plenty of pools before, this is my first time using simplecoin as a front end - I am sure it is something stupid that I missed

I have simple coin in the www root of the web server

but the pages arent loading

500 error in IE

firefox just shows a blank page

http://24.14.210.199/

I am racking my brains here, anyone have any ideas what I did wrong?

[simplecoin]

looking for some help

Not sure what I am doing wrong, I have setup plenty of pools before, this is my first time using simplecoin as a front end - I am sure it is something stupid that I missed

I have simple coin in the www root of the web server

but the pages arent loading

500 error in IE

firefox just shows a blank page

http://24.14.210.199/

I am racking my brains here, anyone have any ideas what I did wrong?

I'm not sure, but I'm guessing you either have missing dependencies or a configuration error.

I would turn on site errors and php errors until you have everything up and running. Also check your site logs, they should lead you in the right direction.

[makomk]

It's coming..... the real issue isn't the source, the source is good. The issue is making it usable for the masses. Right now, 90% of the setup is undocumented database tables and fields. I'm working on beefing up the admin panel so that it isn't nearly impossible to manage and install.

Ah, I was curious about that. (Was looking for a merged mining pool frontend to go with an experimental backend I was working on a couple of months ago. There didn't seem to be any open source ones out there.)

[wndrbr3d]

Is this project active?

I just downloaded it the other night and it has some obvious code issues that need to be fixed otherwise pages wouldn't display properly.

From what I can see though, this is the most common baseline people start with for their mining pools?

[simplecoin]

Is this project active?

I just downloaded it the other night and it has some obvious code issues that need to be fixed otherwise pages wouldn't display properly.

From what I can see though, this is the most common baseline people start with for their mining pools?

Yes, it's active. Although the massive change from the current codebase has not yet been uploaded.

The changes would break existing installs and cause all kinds of headaches.

I will release it once I have a better way to upgrade or install a fresh base.

[idev]

Is this still active ?

[Wayno]

there is a potential issue with the deletion of workers which will cause issue to the whole back end of simplecoin

i have done a quick fix

Code:

edit pool_worker mysql
disabled enum('yes','no') NOT NULL DEFAULT 'no'

//Check if username already exists
$usernameExistsQ = mysql_query("SELECT id,username FROM `pool_worker` WHERE `associatedUserId` = ".$userId." AND `username` = '".$inputUser."'");
$usernameExists = mysql_num_rows($usernameExistsQ);
$usernameExists1 = mysql_fetch_object($usernameExistsQ);
$workerId = $usernameExists1->username;


}else if($usernameExists == 1){
mysql_query("UPDATE `pool_worker` SET disabled = 'no' WHERE username = '".$workerId."' AND `associatedUserId` = '".$userId."'")or sqlerr(__FILE__,__LINE__);
returnError = "Reinstated Worker";
}

			//Delete worker OH NOES!
				mysql_query("UPDATE `pool_worker` SET `disabled` = 'yes' WHERE `id` = '".$workerId."' AND `associatedUserId` = '".$userId."'")or sqlerr(__FILE__,__LINE__);
		}

$getWorkers = mysql_query("SELECT `id`, `username`, `password`, active, hashrate, monitor, disabled FROM `pool_worker` WHERE `associatedUserId` = '".$userId."' AND disabled = 'no'");

[cablepair]

there is a potential issue with the deletion of workers which will cause issue to the whole back end of simplecoin

i have done a quick fix

Code:

edit pool_worker mysql
disabled enum('yes','no') NOT NULL DEFAULT 'no'

//Check if username already exists
$usernameExistsQ = mysql_query("SELECT id,username FROM `pool_worker` WHERE `associatedUserId` = ".$userId." AND `username` = '".$inputUser."'");
$usernameExists = mysql_num_rows($usernameExistsQ);
$usernameExists1 = mysql_fetch_object($usernameExistsQ);
$workerId = $usernameExists1->username;


}else if($usernameExists == 1){
mysql_query("UPDATE `pool_worker` SET disabled = 'no' WHERE username = '".$workerId."' AND `associatedUserId` = '".$userId."'")or sqlerr(__FILE__,__LINE__);
returnError = "Reinstated Worker";
}

			//Delete worker OH NOES!
				mysql_query("UPDATE `pool_worker` SET `disabled` = 'yes' WHERE `id` = '".$workerId."' AND `associatedUserId` = '".$userId."'")or sqlerr(__FILE__,__LINE__);
		}

$getWorkers = mysql_query("SELECT `id`, `username`, `password`, active, hashrate, monitor, disabled FROM `pool_worker` WHERE `associatedUserId` = '".$userId."' AND disabled = 'no'");

Thanks for the effort! Are you interested in fixing some of the other bugs that simplecoin has?

It would be really nice if someone updated / fixed this and released it - I love playing with pool software and for whatever reason it seems like no one ever follows through and continues to develop them after they are initially released.

People are too busy I guess....

I know I would certainly donate to a cause such as this though..

[Wayno]

Thanks for the effort! Are you interested in fixing some of the other bugs that simplecoin has?

It would be really nice if someone updated / fixed this and released it - I love playing with pool software and for whatever reason it seems like no one ever follows through and continues to develop them after they are initially released.

People are too busy I guess....

I know I would certainly donate to a cause such as this though..

i still help run a litecoin pool that uses simplecoin backend that is hevily modified for litecoin, it can be changed to btc with a few changes.

if u want it i can give it to u.

[kingkatari]

Damn Wayno how come you never told me you had a backend for a server???


LoL just kidding i have something up and running now tho but no frontend yet

[omegaaf]

You Sir, are my hero. I will be sure to give feedback and ideas.

[gektek]

This being worked on...active at all?

[flound1129]

$winningShareQ seems to be broken in current version of mysql, it's throwing error on the following:

$winningShareQ = mysql_query("SELECT `id`, `username` FROM `shares` where `upstream_result` = 'Y' AND `id` > $lastwinningid");

I can run this qurey fine at the mysql prompt so not sure what exactly the problem is.

When I run cronjob.php I get the following output:

$ php ./cronjob.php
PHP Warning:  mysql_fetch_row() expects parameter 1 to be resource, boolean given in /var/www/multipool.in/includes/block.php on line 6
PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/multipool.in/includes/block.php on line 16
PHP Warning:  mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/www/multipool.in/includes/block.php on line 24
PHP Warning:  mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/multipool.in/includes/block.php on line 54
PHP Warning:  mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/www/multipool.in/includes/block.php on line 59
PHP Notice:  Trying to get property of non-object in /var/www/multipool.in/includes/block.php on line 60
PHP Notice:  Trying to get property of non-object in /var/www/multipool.in/includes/block.php on line 61
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Any help would be appreciated.

[gateway]

Has anyone adopted this to work with Eloipool? I have bitcoind, eloipool up and running, trying simple coin (yes its old and outdated, I just want to see it work on my local test machines)

im seeing these errors in apache when viewing a page

Code:

[Thu Apr 18 13:13:05 2013] [error] [client 172.18.1.240] PHP Warning:  array_key_exists() expects parameter 2 to be array, boolean given in /var/www/includes/stats.php on line 268, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:05 2013] [error] [client 172.18.1.240] PHP Warning:  fopen(/var/www/api/pool/speed): failed to open stream: No such file or directory in /var/www/includes/stats.php on line 83, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:05 2013] [error] [client 172.18.1.240] PHP Warning:  fwrite() expects parameter 1 to be resource, boolean given in /var/www/includes/stats.php on line 84, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:05 2013] [error] [client 172.18.1.240] PHP Warning:  fclose() expects parameter 1 to be resource, boolean given in /var/www/includes/stats.php on line 85, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:05 2013] [error] [client 172.18.1.240] PHP Warning:  Invalid argument supplied for foreach() in /var/www/includes/stats.php on line 110, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:06 2013] [error] [client 172.18.1.240] PHP Warning:  array_key_exists() expects parameter 2 to be array, boolean given in /var/www/includes/stats.php on line 268, referer: http://172.18.251.184/my_stats.php
[Thu Apr 18 13:13:06 2013] [error] [client 172.18.1.240] PHP Warning:  Division by zero in /var/www/includes/header.php on line 98, referer: http://172.18.251.184/my_stats.php

Did I miss something or is this just incompatible?