Bitcoin Forum
December 05, 2016, 12:39:43 AM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   Home   Help Search Donate Login Register  
Pages: « 1 2 3 4 5 6 7 8 [9] 10 11 12 13 »  All
  Print  
Author Topic: [Pushpool Web Frontend] Simplecoin v5.0 Opensource PHP/MySQL - NEW RELEASE  (Read 54906 times)
simplecoin
Sr. Member
****
Offline Offline

Activity: 406



View Profile WWW
August 04, 2011, 07:58:34 PM
 #161

Siplecoin here is a feature request:
-add an api so that an application could create an new worker when he wants(for example you have 5 computers and you want to create an application that when it's run on that computer it will automatically create an new username+password from that computer+link it to you're account, for example that worker to be linked to my account or so)&retrive them from the server.Or if i'm mining with 2 pcs and using the same username+password is there any problem?or this would work to?

While the idea sounds great, it's also seems like it might add an exploit.

However, you can use the same miner name/pass on multiple workers.

Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1480898383
Hero Member
*
Offline Offline

Posts: 1480898383

View Profile Personal Message (Offline)

Ignore
1480898383
Reply with quote  #2

1480898383
Report to moderator
1480898383
Hero Member
*
Offline Offline

Posts: 1480898383

View Profile Personal Message (Offline)

Ignore
1480898383
Reply with quote  #2

1480898383
Report to moderator
1480898383
Hero Member
*
Offline Offline

Posts: 1480898383

View Profile Personal Message (Offline)

Ignore
1480898383
Reply with quote  #2

1480898383
Report to moderator
Paul4games
Jr. Member
*
Offline Offline

Activity: 46


View Profile
August 04, 2011, 09:35:27 PM
 #162

Siplecoin here is a feature request:
-add an api so that an application could create an new worker when he wants(for example you have 5 computers and you want to create an application that when it's run on that computer it will automatically create an new username+password from that computer+link it to you're account, for example that worker to be linked to my account or so)&retrive them from the server.Or if i'm mining with 2 pcs and using the same username+password is there any problem?or this would work to?

While the idea sounds great, it's also seems like it might add an exploit.

However, you can use the same miner name/pass on multiple workers.
Could you please explain futher what exploit it could add?and i see that you fixed the full path disclousure bugs, good job!
phorensic
Hero Member
*****
Offline Offline

Activity: 630



View Profile
August 04, 2011, 10:32:51 PM
 #163

Button "Lost Password" is there just for anturage? I haven't found any code serves this event...

It's just a relic from mining pool v1.... Looks like it was a stub. I'll get to it in the next version.

Which reminds me....

v3 features not yet in repo:
Memcached support
No more shares_history (what a nightmare that was)
Improved block handling.
Dynamic stats/setting caching (more responsive/less overhead)
Process locking
Drastically improved cronjobs.
Live round stats.
Just to name a few improvements....


Looking forward to seeing how you have tackled this.... im in the midst of dealing with these same issues... especially the whole shares_history nightmare and the associated monster queries.

Good news then.... I just pushed the initial v3 to the expiremental repo. This is no upgrade script, nor a simple upgrade path... yet. You'll need to merge these as appropriate.

As for moving shares history back into shares (AFTER adding new shares fields), I used this sql:
INSERT INTO shares (username, our_result, time, blockNumber, score) SELECT username, our_result, time, blockNumber, score FROM shares_history WHERE shares_history.counted = '0'

Also, I recommend using a separate instance of memcache than pushpool. Don't want your pool cache eaten by web data.

This is interesting.  Can you explain further why you axed shares_history and what shares_counted is for?  Is it just a lighter version of shares_history?  How big does your original shares table get?  I mean, where are your old shares held?  I also noticed shares_counted is MyISAM instead of InnoDB, is that because it's a temporary table?
simplecoin
Sr. Member
****
Offline Offline

Activity: 406



View Profile WWW
August 05, 2011, 04:32:57 AM
 #164

Shares history was essentially an extension of shares, but it required lots of additional joins and unions. It made queries painfully processor intensive when they didn't need to be.

Shares counted is the counted sum of valid/invalid shares per round.

As for MyIsam, that was an oversight, I'll fix that before the code is finalized.

Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
phorensic
Hero Member
*****
Offline Offline

Activity: 630



View Profile
August 05, 2011, 08:13:34 AM
 #165

How does your new setup query faster if "sahres" is larger than two tables - "shares" and "shares_history"...besides indexing.  Xenland and I have discussed and applied indexing to our setups, so I'm curious.
simplecoin
Sr. Member
****
Offline Offline

Activity: 406



View Profile WWW
August 05, 2011, 05:11:22 PM
 #166

shares is only as large as the current round. Why split that data into 2 tables, when you need to join or union them every time?

after the current round confirms I condense the shares into shares_counted to drastically lower the amount of data.

Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
phorensic
Hero Member
*****
Offline Offline

Activity: 630



View Profile
August 07, 2011, 04:37:20 PM
 #167

Hmm, you must have been using shares_history different that I am.  My "shares" is only as large as the current round, old round gets cut and pasted into history.  Never have to do joins or unions.

So you throw away the hash data for shares counted?  I haven't been brave enough to do that on my history.
simplecoin
Sr. Member
****
Offline Offline

Activity: 406



View Profile WWW
August 07, 2011, 06:35:15 PM
 #168

Hmm, you must have been using shares_history different that I am.  My "shares" is only as large as the current round, old round gets cut and pasted into history.  Never have to do joins or unions.

So you throw away the hash data for shares counted?  I haven't been brave enough to do that on my history.

I do, once it the round is paid out it's already been verified. I don't see much historical value in past blocks outside of share counts and block finder.

Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
simplecoin
Sr. Member
****
Offline Offline

Activity: 406



View Profile WWW
August 10, 2011, 12:19:25 AM
 #169

Holy incoming updates!

I may have to deem this release 4.0 because the changes are that drastic!

Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
Paul4games
Jr. Member
*
Offline Offline

Activity: 46


View Profile
August 10, 2011, 09:51:21 AM
 #170

Holy incoming updates!

I may have to deem this release 4.0 because the changes are that drastic!
Looking forward for this update.
sareea
Member
**
Offline Offline

Activity: 76


View Profile
August 10, 2011, 06:18:34 PM
 #171

Hello,
When will you release the new updated version ? And will it have sql injection security ?
I really wanna use simplecoin , and if i install the current one is it upgradable to 4 ? I am looking up to open my pool today or tomorrow .
Please answer me Smiley Thanks !
simplecoin
Sr. Member
****
Offline Offline

Activity: 406



View Profile WWW
August 10, 2011, 06:22:29 PM
 #172

Hello,
When will you release the new updated version ? And will it have sql injection security ?
I really wanna use simplecoin , and if i install the current one is it upgradable to 4 ? I am looking up to open my pool today or tomorrow .
Please answer me Smiley Thanks !

Currently there will not be an easy upgrade path from 2-4. The database changes are drastic.
Version 2 should have sql injection security as should the expirimental branch in the repository.

Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
sareea
Member
**
Offline Offline

Activity: 76


View Profile
August 10, 2011, 06:25:31 PM
 #173

Hello,
When will you release the new updated version ? And will it have sql injection security ?
I really wanna use simplecoin , and if i install the current one is it upgradable to 4 ? I am looking up to open my pool today or tomorrow .
Please answer me Smiley Thanks !

Currently there will not be an easy upgrade path from 2-4. The database changes are drastic.
Version 2 should have sql injection security as should the expirimental branch in the repository.
So what do you suggest ?
I wanna work with simplecoin !! Smiley
simplecoin
Sr. Member
****
Offline Offline

Activity: 406



View Profile WWW
August 10, 2011, 06:44:57 PM
 #174

Hello,
When will you release the new updated version ? And will it have sql injection security ?
I really wanna use simplecoin , and if i install the current one is it upgradable to 4 ? I am looking up to open my pool today or tomorrow .
Please answer me Smiley Thanks !

Currently there will not be an easy upgrade path from 2-4. The database changes are drastic.
Version 2 should have sql injection security as should the expirimental branch in the repository.
So what do you suggest ?
I wanna work with simplecoin !! Smiley

I'm ironing out the last bits now. I'll have v4 in the repository soon enough.

Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
sareea
Member
**
Offline Offline

Activity: 76


View Profile
August 10, 2011, 06:54:44 PM
 #175

Hello,
When will you release the new updated version ? And will it have sql injection security ?
I really wanna use simplecoin , and if i install the current one is it upgradable to 4 ? I am looking up to open my pool today or tomorrow .
Please answer me Smiley Thanks !

Currently there will not be an easy upgrade path from 2-4. The database changes are drastic.
Version 2 should have sql injection security as should the expirimental branch in the repository.
So what do you suggest ?
I wanna work with simplecoin !! Smiley

I'm ironing out the last bits now. I'll have v4 in the repository soon enough.
OOOO ok i will wait man Smiley
mich
Hero Member
*****
Offline Offline

Activity: 728



View Profile
August 11, 2011, 06:18:05 AM
 #176

Just testing new 3rd version, and got this mistakes:

Warning: array_key_exists() expects parameter 2 to be array, boolean given in /var/www/includes/stats.php on line 150

Warning: Division by zero in /var/www/includes/header.php on line 99

PS: It was until pool accept shares from worker.
PPS: When no one worker conected the same mistakes ((((
sareea
Member
**
Offline Offline

Activity: 76


View Profile
August 11, 2011, 05:14:45 PM
 #177

Any updates Simplecoin ? i am very curious about this Smiley
Thanks !
simplecoin
Sr. Member
****
Offline Offline

Activity: 406



View Profile WWW
August 11, 2011, 07:24:40 PM
 #178

Version 4 is now in the master and experimental branches!

There is no clear upgrade path from 2.0-4.0, It would be faster to migrate the shares/user data over manually than to rely on a script that may take hours to run.

Additionally version 4 is not without a few bugs, but overall it is more stable and usable than version 2 or 3.

There is a known issue with the stats, share count doesn't seem to be going up. This doesn't affect payout, just a quirk with the stats page.

Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
sareea
Member
**
Offline Offline

Activity: 76


View Profile
August 11, 2011, 09:12:19 PM
 #179

The other files of the script are not running, all i see is a white screen , all i see is the header and thats it . nothing else .

I am checking what is not installed , i am having everything being running fine .

Please help !
Code:
[Fri Aug 12 16:11:18 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62

[Fri Aug 12 16:11:19 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/register.php

[Fri Aug 12 16:11:21 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/stats.php

PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/gettingstarted.php

[error] [client 58.218.199.22
7] script '/var/www/proxyheader.php' not found or unable
 to stat

[Fri Aug 12 16:10:52 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/register.php

[Fri Aug 12 16:11:13 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/register.php

[Fri Aug 12 16:11:16 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/register.

] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/about.php

[Fri Aug 12 16:10:49 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/about.php

[Fri Aug 12 16:10:51 2011] [error] [client 109.66.112.62
] PHP Warning:  fopen(/var/www/api/pool/speed): failed t
o open stream: No such file or directory in /var/www/inc
ludes/stats.php on line 62, referer: http://78.47.162.16
4/stats.php

What are these ?
sareea
Member
**
Offline Offline

Activity: 76


View Profile
August 12, 2011, 01:28:19 PM
 #180

I checked in this file
https://github.com/simplecoin/simplecoin/blob/master/includes/stats.php

and i think the source of this is here : ( it is true that this file doesn't exist :S )
Code:
setCache("pool_hashrate", $currenthashrate, 300);
try {
$fileName = "/var/www/api/pool/speed";
$fileHandle = fopen($fileName, 'w') or die("can't open file");
fwrite($fileHandle, ($currenthashrate/1000));
fclose($fileHandle);
} catch (Exception $e) {
//echo $e->getMessage();
}

Sorry for the double post
Pages: « 1 2 3 4 5 6 7 8 [9] 10 11 12 13 »  All
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!