|
Title: Mining Farm - Tech support Post by: Xenland on June 18, 2011, 09:11:56 AM This is the Mining Farm tech support thread where restricted and non-restricted users can discuss, and assist in installing Mining Farm.
*Don't go too off topic into pushpool and bitcoind discussions. Basically be mature, don't take over the thread with off topic conversations(you can start your own) Thanks! :D Official Mining Farm #2 Thread: http://forum.bitcoin.org/index.php?topic=10617.0 Pushpoold Tech Support Thread: http://forum.bitcoin.org/index.php?topic=10321.0 Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 18, 2011, 09:23:13 AM *Reserved Post For Now
Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 19, 2011, 03:51:06 AM How does Mining Farm get shares information from pushpool? Does it check shares.log or MySQL? If MySQL, what should my server.json file look like to populate the shares table?
Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 19, 2011, 04:00:26 AM Mining Farm recieves its shares with mysql . You can enable mysql by setting sharelog to true, then setting up the mysql query to your liking.
Here is a reference from the pushpool tech support thread, Code: {How does Mining Farm get shares information from pushpool? Does it check shares.log or MySQL? If MySQL, what should my server.json file look like to populate the shares table? Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 19, 2011, 04:16:58 AM Like some other people over in that thread I am having trouble getting the shares table to update. In my server.json I have the same line
Quote "stmt.sharelog":"INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?)" I have a couple workers connected to pushpool and everything is humming along. Shares.log is a hive of activity, yet pushpool is not INSERTing into MySQL. Quote mysql> SELECT * FROM shares; Empty set (0.00 sec) Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 19, 2011, 04:21:46 AM Intresting. What results do you get in the pushpool debug window?
Like some other people over in that thread I am having trouble getting the shares table to update. In my server.json I have the same line Quote "stmt.sharelog":"INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?)" I have a couple workers connected to pushpool and everything is humming along. Shares.log is a hive of activity, yet pushpool is not INSERTing into MySQL. Quote mysql> SELECT * FROM shares; Empty set (0.00 sec) Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 19, 2011, 04:25:53 AM Code: @server1:~/pushpool/sbin$ ./pushpoold -D=2 -E -F Edit: Just realized I had the debug flag wrong. Code: @server1:~/pushpool/sbin$ ./pushpoold --debug=2 -E -F Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 19, 2011, 04:58:41 AM What results do you get when apply that query into the mysql directly with simulated data?
Try the follow query(tested) for verification Quote INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (" ", " ", "Y", "", " ", " ") Like some other people over in that thread I am having trouble getting the shares table to update. In my server.json I have the same line Quote "stmt.sharelog":"INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?)" I have a couple workers connected to pushpool and everything is humming along. Shares.log is a hive of activity, yet pushpool is not INSERTing into MySQL. Quote mysql> SELECT * FROM shares; Empty set (0.00 sec) Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 19, 2011, 05:32:21 AM Code: mysql> INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (" ", " ", "Y", " ", " ", " ");Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 19, 2011, 05:40:09 AM Code: mysql> INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (" ", " ", "Y", " ", " ", " ");I see that you have received 2 warnings were they related to this query, and if so what did it the warnings say? Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 19, 2011, 05:59:12 AM Thank you for the support Xen
Code: mysql> SHOW WARNINGS; When I set up my tables I used your example from the Pushpool Tech Support thread Quote CREATE TABLE IF NOT EXISTS `pool_worker` ( `id` int(255) NOT NULL AUTO_INCREMENT, `associatedUserId` int(255) NOT NULL, `username` varchar(50) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0; CREATE TABLE IF NOT EXISTS `shares` ( `id` bigint(30) NOT NULL AUTO_INCREMENT, `time` int(255) NOT NULL, `rem_host` varchar(255) NOT NULL, `username` varchar(120) NOT NULL, `our_result` enum('Y','N') NOT NULL, `upstream_result` enum('Y','N') DEFAULT NULL, `reason` varchar(50) DEFAULT NULL, `solution` varchar(257) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ; Do I have too many columns for pushpool to handle? I notice there are only 6 values in server.json and 8 columns in the sql table. Sorry, still somewhat of a MySQL noob, this stuff is always set up for me beforehand, I usually only support post-install ;) Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 19, 2011, 06:20:03 AM Yeah no problem!
Thank you for the support Xen Code: mysql> SHOW WARNINGS; When I set up my tables I used your example from the Pushpool Tech Support thread Quote CREATE TABLE IF NOT EXISTS `pool_worker` ( `id` int(255) NOT NULL AUTO_INCREMENT, `associatedUserId` int(255) NOT NULL, `username` varchar(50) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0; CREATE TABLE IF NOT EXISTS `shares` ( `id` bigint(30) NOT NULL AUTO_INCREMENT, `time` int(255) NOT NULL, `rem_host` varchar(255) NOT NULL, `username` varchar(120) NOT NULL, `our_result` enum('Y','N') NOT NULL, `upstream_result` enum('Y','N') DEFAULT NULL, `reason` varchar(50) DEFAULT NULL, `solution` varchar(257) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ; Do I have too many columns for pushpool to handle? I notice there are only 6 values in server.json and 8 columns in the sql table. Sorry, still somewhat of a MySQL noob, this stuff is always set up for me beforehand, I usually only support post-install ;) Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 19, 2011, 06:48:40 AM One user "genewitch" said they compiled pushpool from Git repository and it started populating their MySQL shares table. Just did that, no luck.
Title: Re: Mining Farm - Tech support (v4+ only) Post by: fascistmuffin on June 19, 2011, 06:54:15 AM I had a nice post describing what might be going on, then the power went out. So now you get the simple version:
Quote `time` int(255) NOT NULL, Shouldn't be NOT NULL. "Field 'time' doesn't have a default value," means you didn't specify a value for `time` in the insert statement. Since there's no value, and it can't be null (the default value when a column isn't specified in the insert statement) the system gives you this error. Change that column to something like `time` int. Really goofy create table statement tbh, specifying lengths for integers, and using bigint for key columns. Make my former DBA self cringe :P Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 19, 2011, 07:26:04 AM Changed `time` to your suggestion. I can INSERT into shares manually with 0 warnings now. However, pushpool still cannot INSERT. Restarted pushpool and used a new worker.
Title: Re: Mining Farm - Tech support (v4+ only) Post by: fascistmuffin on June 19, 2011, 07:43:10 AM CREATE TABLE IF NOT EXISTS `shares` (
`id` bigint NOT NULL AUTO_INCREMENT, `time` int, `rem_host` varchar(255), `username` varchar(120), `our_result` enum('Y','N'), `upstream_result` enum('Y','N'), `reason` varchar(50), `solution` varchar(257), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ; Try that. I saw above that you said the server.json had 6 values, and the table has 8, so I'm still thinking it's a NOT NULL issue. I changed everything to be not NOT NULL (the one time a double negative is correct! Your move grammar!). I also changed the size specifications for the integers because those just bug me :P. Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 19, 2011, 07:45:47 AM I should mention, I'm running bitcoind on testnet. Does pushpool somehow block inserting into the mysql database shares that have been generated from testnet? Also, just noticed your original topic said don't go into pushpool or bitcoind tech support, sorry!
Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 19, 2011, 07:46:39 AM CREATE TABLE IF NOT EXISTS `shares` ( `id` bigint NOT NULL AUTO_INCREMENT, `time` int, `rem_host` varchar(255), `username` varchar(120), `our_result` enum('Y','N'), `upstream_result` enum('Y','N'), `reason` varchar(50), `solution` varchar(257), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ; Try that. I saw above that you said the server.json had 6 values, and the table has 8, so I'm still thinking it's a NOT NULL issue. I changed everything to be not NOT NULL (the one time a double negative is correct! Your move grammar!). I also changed the size specifications for the integers because those just bug me :P. Thanks for this insight, I was unware that int could be created with out a limit, I shall use this in the next Mining Farm update v4.0.4 Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 19, 2011, 07:47:43 AM I should mention, I'm running bitcoind on testnet. Does pushpool somehow block inserting into the mysql database shares that have been generated from testnet? Also, just noticed your original topic said don't go into pushpool or bitcoind tech support, sorry! Its been a couple of days but I'm pretty sure testnet was working for me when I tried it, I might be wrong tho Title: Re: Mining Farm - Tech support (v4+ only) Post by: fascistmuffin on June 19, 2011, 07:59:48 AM CREATE TABLE IF NOT EXISTS `shares` ( `id` bigint NOT NULL AUTO_INCREMENT, `time` int, `rem_host` varchar(255), `username` varchar(120), `our_result` enum('Y','N'), `upstream_result` enum('Y','N'), `reason` varchar(50), `solution` varchar(257), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ; Try that. I saw above that you said the server.json had 6 values, and the table has 8, so I'm still thinking it's a NOT NULL issue. I changed everything to be not NOT NULL (the one time a double negative is correct! Your move grammar!). I also changed the size specifications for the integers because those just bug me :P. Thanks for this insight, I was unware that int could be created with out a limit, I shall use this in the next Mining Farm update v4.0.4 You might also want to rethink your Enums. You could change them to Char(1) fields, which is 1 byte of space, and you have much more options in case you need to add more values in the future. You wont need to worry about database updates if another value is needed. Also, you could change the bigint to INT UNSIGNED to save on space. Unless you intend on values exceeding 4,294,967,295 , you will be safe using int unsigned, saving you 4 bytes of room for each record. All these changes should not cause any data loss during updates. You might need to make a conversion/update script for changing enums though. Something along the lines of a temporary table with the new structure and a SELECT....., CASE When our_result = 'Y' then 'Y' else 'N', .... FROM .......), then dropping the old table and renaming the temp one. Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 19, 2011, 08:09:23 AM Changed from testnet to real blockchain. Using facistmuffin's table creation template. Still only logging to shares.log and not mysql db.
Here is my server.json with usernames and passwords removed. Also, just changed ports to reflect the standard setup of most pools (that did not introduce new errors). I know server.json is really screwed up when pushpool will not start because of a JSON parse error, but right now that is not the case--it runs fine. Code: @server1:~/pushpool/sbin$ cat server.json Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 19, 2011, 08:20:28 PM Sorry guys. After days of hacking and your excellent help I realized I was *one* line off in my server.json. The line was not included in some of the example configs I found on github.
Quote "sharelog" : true, >:( >:( >:( >:( *bangs head against desk* pushpool needs way more debugging output. I might take up C programming and do another fork on github :P Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 19, 2011, 09:34:21 PM Sorry guys. After days of hacking and your excellent help I realized I was *one* line off in my server.json. The line was not included in some of the example configs I found on github. Quote "sharelog" : true, >:( >:( >:( >:( *bangs head against desk* pushpool needs way more debugging output. I might take up C programming and do another fork on github :P Please do, it would keep the suicide rate down around here, that thing is like Japanese box with Japanese instructions.... oh wait no INSTRUCTIONS!!! ::) Title: Re: Mining Farm - Tech support (v4+ only) Post by: noahFecks on June 19, 2011, 09:48:58 PM Hello,
First of all, thank you for creating a thread in the newbie section for support of Mining Farm I have my pool up and running and had a question about pool fees It is my understanding that the pool's fees are controlled by the front end and not pushpool or the bitcoin daemon. I went looking in blockFound.php in the /req/cronjob/ folder and found the following line Code: $totalReward = 50*$shareRatio; I take it this implies a 'no fee pool' as all 50 BTC are distributed amongst the workers who contributed shares between the last block and the block that was just found. So, i'm assuming that to make a pool with a fee, you would simply adjust the 50 to the amount that is going to be distributed. So if the pool was going to take a fee of 1 BTC of every block found, that value could be adjusted to 49. Can you please confirm? Also, since I was looking at actually having a fee on my pool, but think 1BTC is too high, can i use a value such as 49.99? the statement would then read Code: $totalReward = 49.99*$shareRatio; is my understanding and interpretation of the code in blockFound.php correct? any feedback or advice you could provide will be greatly appreciated and I will be sending some BTC to all who can contribute positive, informative answers, so if you have something worthwhile to contribute, please leave an address so i can send you something for your time. Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 20, 2011, 03:20:24 AM Sorry guys. After days of hacking and your excellent help I realized I was *one* line off in my server.json. The line was not included in some of the example configs I found on github. Quote "sharelog" : true, >:( >:( >:( >:( *bangs head against desk* pushpool needs way more debugging output. I might take up C programming and do another fork on github :P I just noticed this but this could have been fixed if you listened to my first reply were i say put your sharelog to true, lawl Title: Re: Mining Farm - Tech support (v4+ only) Post by: phorensic on June 20, 2011, 06:19:40 AM Hehe, well I assumed it was there because I was using one of the 3 sample server.json's. I used yours at first, then somebody else's and I assumed that line was still in there, as I kept comparing differences. I guess I should stop hacking at 2am every morning!
Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 20, 2011, 08:03:47 AM You would want it to be 49.0 other wise youd get 1 bit cent at 49.99
Id like to also note that i will include tge option again to include the admin fee along with the option to donate a percentage to various non profit organizations, thinking about setting up a red cross donation option that will get sent to a bitcoin address which will be converted to usd to donate along with a letter stating the effort takin in donating the money from all the fees and notify them the cost of fees that could have been profitable donations. Hello, First of all, thank you for creating a thread in the newbie section for support of Mining Farm I have my pool up and running and had a question about pool fees It is my understanding that the pool's fees are controlled by the front end and not pushpool or the bitcoin daemon. I went looking in blockFound.php in the /req/cronjob/ folder and found the following line Code: $totalReward = 50*$shareRatio; I take it this implies a 'no fee pool' as all 50 BTC are distributed amongst the workers who contributed shares between the last block and the block that was just found. So, i'm assuming that to make a pool with a fee, you would simply adjust the 50 to the amount that is going to be distributed. So if the pool was going to take a fee of 1 BTC of every block found, that value could be adjusted to 49. Can you please confirm? Also, since I was looking at actually having a fee on my pool, but think 1BTC is too high, can i use a value such as 49.99? the statement would then read Code: $totalReward = 49.99*$shareRatio; is my understanding and interpretation of the code in blockFound.php correct? any feedback or advice you could provide will be greatly appreciated and I will be sending some BTC to all who can contribute positive, informative answers, so if you have something worthwhile to contribute, please leave an address so i can send you something for your time. Title: Re: Mining Farm - Tech support (v4+ only) Post by: noahFecks on June 20, 2011, 09:19:28 AM i was actually serious about .01 BTC
its small so the workers dont notice it and its going to a good cause. Im starting a local pool to get people in my geographic area more interested in bitcoin, every 6 months, the 'fees' will be cashed out and donated or we will transfer the BTC to BTC friendly charitable organizations. Im really stoaked that people were thinking along the same lines as charity goes, thats really cool people are trying to make the world a better place with BTC ;D Obviously I plan to be up front and honest with my users about 'fees' and where they are going and am looking at including an option to opt out. I just needed to make sure i found the right portion of code to begin working on. Thanks a lot for your help and the quick reply Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on June 20, 2011, 11:05:27 AM I believe you are serious you stated 1btc fee instead of .01btc but its all good ebcuase you stated thats what your goal was.
:D i was actually serious about .01 BTC its small so the workers dont notice it and its going to a good cause. Im starting a local pool to get people in my geographic area more interested in bitcoin, every 6 months, the 'fees' will be cashed out and donated or we will transfer the BTC to BTC friendly charitable organizations. Im really stoaked that people were thinking along the same lines as charity goes, thats really cool people are trying to make the world a better place with BTC ;D Obviously I plan to be up front and honest with my users about 'fees' and where they are going and am looking at including an option to opt out. I just needed to make sure i found the right portion of code to begin working on. Thanks a lot for your help and the quick reply Title: Re: Mining Farm - Tech support (v4+ only) Post by: pero991 on July 06, 2011, 07:29:56 PM hy! I am now testing my pool with testnet and was wondering why are the blog posts disabled. i liked them!
Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on July 06, 2011, 09:25:18 PM hy! I am now testing my pool with testnet and was wondering why are the blog posts disabled. i liked them! haha, alright mate, I'll get the blog posts back in scince everyone liked them so much. Title: Re: Mining Farm - Tech support (v4+ only) Post by: pero991 on July 07, 2011, 10:10:02 AM hy! I am now testing my pool with testnet and was wondering why are the blog posts disabled. i liked them! haha, alright mate, I'll get the blog posts back in scince everyone liked them so much. here is my pool, its still a work in progress but it will be fully functional soon http://46.4.148.165/ Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on July 07, 2011, 11:11:32 AM hy! I am now testing my pool with testnet and was wondering why are the blog posts disabled. i liked them! haha, alright mate, I'll get the blog posts back in scince everyone liked them so much. here is my pool, its still a work in progress but it will be fully functional soon http://46.4.148.165/ :D i like that logo! Most original one ive seen yet. I see yur using the latest version which id like to note that the blog posts will be done sometime today just in case you were wondering about that. Thanks to bitcoinmonkey.com for the brilliant idea of the way they formatted their site. :) Title: Re: Mining Farm - Tech support (v4+ only) Post by: pero991 on July 07, 2011, 01:48:00 PM thanks! yes i like to stay updated, running testnet atm so if anyone wants to help me test, feel free to do so
Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on July 07, 2011, 02:06:26 PM thanks! yes i like to stay updated, running testnet atm so if anyone wants to help me test, feel free to do so Let me know when you want to go "Pubic" and I'll add your website to the main list on miningfarm thread. Title: Re: Mining Farm - Tech support (v4+ only) Post by: ziomik on July 08, 2011, 11:05:58 PM Thank's for you work,
After a long time I was able to go around. I only have a problem: The graphics do not update the statistics. Even if my pool has miners statistics remain at zero. Page Manage Work is present: 0 MHash/s · N/A% efficient What can it be? Thanks again .. Title: Re: Mining Farm - Tech support (v4+ only) Post by: Xenland on July 09, 2011, 05:11:31 AM Thank's for you work, After a long time I was able to go around. I only have a problem: The graphics do not update the statistics. Even if my pool has miners statistics remain at zero. Page Manage Work is present: 0 MHash/s · N/A% efficient What can it be? Thanks again .. Well first I must ask you some mundane questions first before we pin it down to a programming issue, So first off I'll ask if you've set up all your cronjobs correctly this includes statsUpdater.php, along with blockUpdater.php, and blockFound.php Title: Re: Mining Farm - Tech support Post by: ziomik on July 09, 2011, 08:21:41 AM yes, my crojob is:
Quote */2 * * * * /var/www/req/cronjob/statsUpdater.php */10 * * * * /var/www/req/cronjob/blockUpdater.php */12 * * * * /var/www/req/cronjob/blockFound.php manualcron.html work correctly without errors :-[ :-\ /var/log/apache2/error.log Code: [Sat Jul 09 11:00:27 2011] [error] [client xx.xx.xx.xx] PHP Notice: Trying to get property of non-object in /var/www/req/functions.php on line 264 Title: Re: Mining Farm - Tech support Post by: d3c0n808 on July 10, 2011, 06:34:03 PM Anyone else had the issue in php 5.3.6 that the workers have a depreciated error. Basically it will have "> workername box password box on each worker also this issue causes the graph to not update. Wondering if anyone ran into this issue yet or not. I've tried it on two different distributions. Slackware 1337 and Suse 11.4 seems this only affects new kernels. Ive recompiled php 5.2.19 on both machines and it did not fix it so perhaps its a dependency or an old module of some sort that I didn't remove....
Title: Re: Mining Farm - Tech support Post by: Xenland on July 10, 2011, 08:22:17 PM Anyone else had the issue in php 5.3.6 that the workers have a depreciated error. Basically it will have "> workername box password box on each worker also this issue causes the graph to not update. Wondering if anyone ran into this issue yet or not. I've tried it on two different distributions. Slackware 1337 and Suse 11.4 seems this only affects new kernels. Ive recompiled php 5.2.19 on both machines and it did not fix it so perhaps its a dependency or an old module of some sort that I didn't remove.... Thanks for the bug report, I actually ran into this on my Cloud hosted mining server during the install. I'm doing heavy testing using namecoind(for short block find times and quick,clean bug fixes) if you would like to help out test the new and improved Mining Farm you can check out a taste over at http://216.38.17.198/ This server is aimed at finding its first block(ETA 24 hours at this point), I've already rewritten everything, now its the testing part most of that is already done too I just need to see if the reward distrobution works correctly.Thanks for yours and everyone's effort! This is a community project and not just for me so we owe it to us to get this fixed! Lets get this 50% network rate attack problem outta the way by allowing anybody to start their own pool. Title: Re: Mining Farm - Tech support Post by: d3c0n808 on July 11, 2011, 12:33:40 AM Anyone else had the issue in php 5.3.6 that the workers have a depreciated error. Basically it will have "> workername box password box on each worker also this issue causes the graph to not update. Wondering if anyone ran into this issue yet or not. I've tried it on two different distributions. Slackware 1337 and Suse 11.4 seems this only affects new kernels. Ive recompiled php 5.2.19 on both machines and it did not fix it so perhaps its a dependency or an old module of some sort that I didn't remove.... Thanks for the bug report, I actually ran into this on my Cloud hosted mining server during the install. I'm doing heavy testing using namecoind(for short block find times and quick,clean bug fixes) if you would like to help out test the new and improved Mining Farm you can check out a taste over at http://216.38.17.198/ This server is aimed at finding its first block(ETA 24 hours at this point), I've already rewritten everything, now its the testing part most of that is already done too I just need to see if the reward distrobution works correctly.Thanks for yours and everyone's effort! This is a community project and not just for me so we owe it to us to get this fixed! Lets get this 50% network rate attack problem outta the way by allowing anybody to start their own pool. Ok just checking I wasn't sure if this issue was widespread or if I'm just an idiot. Sorry Im not a php programmer so I am unable to fix it myself and push the fix to github but i am more than willing in helping out any way I can Title: Re: Mining Farm - Tech support Post by: Xenland on July 11, 2011, 01:37:57 AM Anyone else had the issue in php 5.3.6 that the workers have a depreciated error. Basically it will have "> workername box password box on each worker also this issue causes the graph to not update. Wondering if anyone ran into this issue yet or not. I've tried it on two different distributions. Slackware 1337 and Suse 11.4 seems this only affects new kernels. Ive recompiled php 5.2.19 on both machines and it did not fix it so perhaps its a dependency or an old module of some sort that I didn't remove.... Thanks for the bug report, I actually ran into this on my Cloud hosted mining server during the install. I'm doing heavy testing using namecoind(for short block find times and quick,clean bug fixes) if you would like to help out test the new and improved Mining Farm you can check out a taste over at http://216.38.17.198/ This server is aimed at finding its first block(ETA 24 hours at this point), I've already rewritten everything, now its the testing part most of that is already done too I just need to see if the reward distrobution works correctly.Thanks for yours and everyone's effort! This is a community project and not just for me so we owe it to us to get this fixed! Lets get this 50% network rate attack problem outta the way by allowing anybody to start their own pool. Ok just checking I wasn't sure if this issue was widespread or if I'm just an idiot. Sorry Im not a php programmer so I am unable to fix it myself and push the fix to github but i am more than willing in helping out any way I can Awesome so my vision of mining farm is already going to use :D Title: Re: Mining Farm - Tech support Post by: d3c0n808 on July 11, 2011, 04:40:51 AM SO I've been mining on your pool for a little while now and I notice on the block statistics page the current block number is 15740
Title: Re: Mining Farm - Tech support Post by: Xenland on July 11, 2011, 04:53:33 AM SO I've been mining on your pool for a little while now and I notice on the block statistics page the current block number is 15740 Correct? what is your point? UPDATE: I've updated the title to Mining Farm - Mining For Namecoins just to clear up and confusion Title: Re: Mining Farm - Tech support Post by: d3c0n808 on July 11, 2011, 05:04:50 AM SO I've been mining on your pool for a little while now and I notice on the block statistics page the current block number is 15740 Correct? what is your point? UPDATE: I've updated the title to Mining Farm - Mining For Namecoins just to clear up and confusion Ah thats why I was wondering didn't know it was for namecoins sorry i just thought it was on the bitcoin blockchain Title: Re: Mining Farm - Tech support Post by: Xenland on July 11, 2011, 05:51:25 AM SO I've been mining on your pool for a little while now and I notice on the block statistics page the current block number is 15740 Correct? what is your point? UPDATE: I've updated the title to Mining Farm - Mining For Namecoins just to clear up and confusion Ah thats why I was wondering didn't know it was for namecoins sorry i just thought it was on the bitcoin blockchain No problems, honest mistake :) Title: Re: Mining Farm - Tech support Post by: ziomik on July 14, 2011, 04:26:04 PM Slogan is gone and does not work and error To update slogan: Code: http://www.btcfarm.us/adminPanel.php? Code: Unknown column 'enableRequiredEmail' in 'field list' Thanks Xenland for your works !! ;) Problem is importing database: Code: mysql -u root -p database < miningfarm_database ??? ??? Title: Re: Mining Farm - Tech support Post by: Xenland on July 14, 2011, 05:42:38 PM I'm fixing the admin panel as we speak :)
As far as the database, I will speak with you on skype :) Title: Re: Mining Farm - Tech support Post by: TTB on July 17, 2011, 08:54:33 AM I installed the MiningFarm on a local testserver, and after some minor probs it seems to be doing pretty fine.
So at first: thanks Xenland for that great work. But here comes the problem: There seems to be a problem with the Cookie on my page, and i cant figure it out. So here is what my apache2 log shows right after opening the page and logging in: Code:
First line is where $rawCookie = $_COOKIE[$cookieName]; is in the index.php and i think the following errors are based on that. I hope this is enough information for a solution, will be prroviding more if neccessary, just tell. I would appreciate some help by getting rid of this error :) Thanks! Title: Re: Mining Farm - Tech support Post by: Xenland on July 17, 2011, 08:15:41 PM I installed the MiningFarm on a local testserver, and after some minor probs it seems to be doing pretty fine. So at first: thanks Xenland for that great work. But here comes the problem: There seems to be a problem with the Cookie on my page, and i cant figure it out. So here is what my apache2 log shows right after opening the page and logging in: Code:
Those errors are they're for developers you need to set your error_reporting to Production value settings(you can find this in your php.ini file) if memory serves it should be like this Quote error_reporting = E_ALL & ~E_NOTICE As for cookies make sure you don't have any anti-virus software blocking cookies and be sure to search up on how to enable cookies on your browser What are your server specifications(VPS, Dedicated, Shared Hosting, Cloud, etc, etc)? First line is where $rawCookie = $_COOKIE[$cookieName]; is in the index.php and i think the following errors are based on that. I hope this is enough information for a solution, will be prroviding more if neccessary, just tell. I would appreciate some help by getting rid of this error :) Thanks! Title: Re: Mining Farm - Tech support Post by: TTB on July 19, 2011, 08:02:13 AM Hi Xenland,
thx for the answer, i checked on that: php.ini: correct statements cookies: allowed (also when a friend of mine connected the output was the same) edit: No anti virus preventing cookies after installing the newest version of yours (cd8c45f) the output still looks like this: Code: [Tue Jul 19 09:34:36 2011] [error] [client 192.168.1.8] PHP Notice: Undefined index: miningfarm#2 in /var/www/index.php on line 18 Am I right all the undefined indexes are cookie-based? And do these errors affect the correct output of the page? I have it running on a ubuntu (newest version) in a virtual machine on vm workstation. Additional points: - cant see that added blog editor (where is it supposed to be?). Blog entries directly in DB are shown correctly on mainpage - payout threshhold does always show 0.5, but changed values are correctly inserted into DB, cant find the reason for that behavior ($getCredientals->threshhold seems to be empty, but dont know why) - theres a bug in worker page. if u update the shown worker name user.worker it will change to user.user.worker. i solved it by deleting the user show. (obv would be better if in the save to DB statement the "user." would be removed before saving, but my programming skills aren't as good to do that on the fly) - By using new Database table structure in updates (i.e. "coinType") it would be nice if the sql dump file would also be updated, just to prevent long searching for occurring errors based on missing fields - Am I right that the bitcoin / namecoin chosing option only affects the donations? As an idea i suggest to have all "BTC" statements on the pages as variables based on that choice one made (so i.e. automatic "BTC" or "NMC" account balance) Thanks in advance for your help. Edit 2: found out the posted errors ONLY occur when im logged in as admin. with a non admin user account no error messages except that "undefined index: miningfarm"..." occur. Title: Re: Mining Farm - Tech support Post by: sergio on July 26, 2011, 11:13:51 AM Hi Everyone, I have just set up a mining server based on xenland's version 5.1.4.
The server is http://www.bitcoinmoneda.com, it is in beta state since I just got it up and running. I have a few questions, are there any known bugs that I should be aware of such on version 5.1.4, since no blocks have been found, the server it is not fully tested. When browsing the site I get some apache error logs in regards to the database, such as Undefined index when php tries to access the database, however it seems to work, however it generates lots of apache error logs. The other error I found was when loading the database on line 301 in miningfarm_database.sql -- Dumping data for table `stats_topSharers` -- '7', 0); Had no clue where the '7', 0); belongs so I put it in the line above commented out, if you know what line should be on the file please let me know. The other problem is that chart for bitcoin value in fiat it is not working on my site, if someone could tell me where to look for the configuration or troubleshooting for that chart. I think everything else is probably working, so if you would like to join the pool, that would be fantastic it will help test out the site, given the current difficulty level of finding a block, the more miners that join the better. If you know of any known bugs please let me know, so that I can apply the fixes to the mining server. Xenland, good job on the bitcoin mining server software. Thanks. Title: Re: Mining Farm - Tech support Post by: sergio on July 26, 2011, 11:32:24 AM Question in regard to mining server v5.1.4
Under account details, and then under Identity details, where it says: JSON Mining & Worker Data Righ below there is a very large string of characters that looks like a bitcoin address but it is not. What is it? Is it some sort of key ? something that is private ? Is that something that needs to be changed? Thanks, Title: Re: Mining Farm - Tech support Post by: Xenland on July 26, 2011, 10:02:51 PM Question in regard to mining server v5.1.4 Under account details, and then under Identity details, where it says: JSON Mining & Worker Data Righ below there is a very large string of characters that looks like a bitcoin address but it is not. What is it? Is it some sort of key ? something that is private ? Is that something that needs to be changed? Thanks, Yeah that key is just for reference if anybody decides to integrate APIs with mining farm software they can take that key and paste it into a Mining Pool watch websites Title: Re: Mining Farm - Tech support Post by: Xenland on July 26, 2011, 10:05:08 PM Hi Everyone, I have just set up a mining server based on xenland's version 5.1.4. The server is http://www.bitcoinmoneda.com, it is in beta state since I just got it up and running. I have a few questions, are there any known bugs that I should be aware of such on version 5.1.4, since no blocks have been found, the server it is not fully tested. When browsing the site I get some apache error logs in regards to the database, such as Undefined index when php tries to access the database, however it seems to work, however it generates lots of apache error logs. The other error I found was when loading the database on line 301 in miningfarm_database.sql -- Dumping data for table `stats_topSharers` -- '7', 0); Had no clue where the '7', 0); belongs so I put it in the line above commented out, if you know what line should be on the file please let me know. The other problem is that chart for bitcoin value in fiat it is not working on my site, if someone could tell me where to look for the configuration or troubleshooting for that chart. I think everything else is probably working, so if you would like to join the pool, that would be fantastic it will help test out the site, given the current difficulty level of finding a block, the more miners that join the better. If you know of any known bugs please let me know, so that I can apply the fixes to the mining server. Xenland, good job on the bitcoin mining server software. Thanks. Sorry about the MySql file error, I thought i fixed it with the latest update. Sounds like you got it working fine. The apache log errors are due to becuase you must set your PHP.ini file to Production Value error settings instead of the development. Title: Re: Mining Farm - Tech support Post by: sareea on August 10, 2011, 12:23:36 PM Hello,
My M/hashes of the pool and the online workers are not being updated and shown . What should i do ? my cronjobs are set correctly , the statsupdater.php every 2 minutes. And my worker is giving 300 M/Hashes/s And there is no activateaccount.php file . |