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

[Keninishna]

Does anyone know where simplecoin writes to the unconfirmed_rewards table in the database? I see a function that reads from it but where does it write to it?
edit: found it in rewards

mysql_query("INSERT INTO unconfirmed_rewards (userId, blockNumber, amount, shares) VALUES ($userid, $blockNumber, '$totalReward', $uncountedShares)");

[1714124013]

1714124013

[1714124013]

1714124013

[1714124013]

1714124013

[1714124013]

1714124013

[simplecoin]

Sorry I've been AWOL from this thread, but between developing the new version and my best friends marriage things have been hectic.

The new version is so close to stable. The current slowdown is the creation of a dynamic long-polling proxy to use with the new frontend.

[simplecoin]

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,

You should have port 8332 set then. Also, make sure the calling machine has access in the bitcoin.conf file as well as the firewall.

[mich]

Got a problem. Pool has found 2 blocks, I can see in wallet about 100 btc, but pool stat does not show founded blocks
Need your urgent help!!!
Table "winning_shares" is empty.
Table "networkBlocks" is empty.

Simplecoin v.5
Mysql 5.1.54

cronjob.php returns "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"

[simplecoin]

Got a problem. Pool has found 2 blocks, I can see in wallet about 100 btc, but pool stat does not show founded blocks
Need your urgent help!!!
Table "winning_shares" is empty.
Table "networkBlocks" is empty.

Simplecoin v.5
Mysql 5.1.54

cronjob.php returns "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"

Ok, what line number is the error coming from (there are LOTS of sql calls from many classes in cronjob) ?

V5 was fairly solid out of the box, so hopefully this is a simple fix.

[mich]

/cronjobs/cronjob.php

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /var/www/mpool/includes/block.php on line 6 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/mpool/includes/block.php on line 16 Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/www/mpool/includes/block.php on line 24 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/mpool/includes/block.php on line 54 Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/www/mpool/includes/block.php on line 59 Notice: Trying to get property of non-object in /var/www/mpool/includes/block.php on line 60 Notice: Trying to get property of non-object in /var/www/mpool/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

My table networkBlocks is empty. Which script does update it? And can I get somewhere dump of this table?

[simplecoin]

networkBlocks is updated by cronjob.php

try putting a networkBlock of 1 in the table, that should force it to start updating.

I'm currently running a wholly new version of the source (working the kinks out now, especially merged-mining), so I'm referencing the git repo for answers.

[mich]

What can I do now for make visible founded two blocks in stat and for paying out to users? I can see that shares in table shares, I see who found it, but which moves I have to do for correct stats and distribution of mined amount?

[mich]

networkBlocks is updated by cronjob.php

try putting a networkBlock of 1 in the table, that should force it to start updating.

I'm currently running a wholly new version of the source (working the kinks out now, especially merged-mining), so I'm referencing the git repo for answers.

I did but updating not started 

[simplecoin]

networkBlocks is updated by cronjob.php

try putting a networkBlock of 1 in the table, that should force it to start updating.

I'm currently running a wholly new version of the source (working the kinks out now, especially merged-mining), so I'm referencing the git repo for answers.

I did but updating not started 

Still the same error?

[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.

[simplecoin]

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.

That's good news! The next version has better locking, but it takes a lot more database work to get it off the ground.

I'm going to need to build a serious manual or an install interface at this rate.

[mich]

I think you have to make name of pool as variable in some settings file and use it in files who send notifications and etc.

[simplecoin]

I think you have to make name of pool as variable in some settings file and use it in files who send notifications and etc.

Thanks, I'll try to get that in the next version.

[Keninishna]

merged mining source code plz 

[worldinacoin]

I am hoping to run it on Centos 6, will there be any issues?  Or is it more suited for Debian based distros only?

[simplecoin]

merged mining source code plz 

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.

I am hoping to run it on Centos 6, will there be any issues?  Or is it more suited for Debian based distros only?

I'm not sure. In theory it should run on any PHP/Mysql setup. I personally use ubuntu with mysql 5.5, but I've heard of others even using windows.

[Coinbuck @ BTCLot]

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 ?

[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

[Coinbuck @ BTCLot]

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.