simplecoin (OP)
|
|
July 18, 2011, 07:39:15 PM |
|
acunetix has a thorough security package.
|
Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
|
|
|
mich
Legendary
Offline
Activity: 3304
Merit: 1034
#1 VIP Crypto Casino
|
|
July 19, 2011, 09:56:47 AM Last edit: July 19, 2011, 12:47:00 PM by mich |
|
"Past shares" and "Past invalid" takes values after finding block only? In table "Top 30 Lifetime Shares" column "Shares" is 0. It is correct, in case of Round shares already much more then 0? Update Main Page Settings does not work in Admin Panel
|
|
|
|
simplecoin (OP)
|
|
July 19, 2011, 03:36:57 PM |
|
"Past shares" and "Past invalid" takes values after finding block only? In table "Top 30 Lifetime Shares" column "Shares" is 0. It is correct, in case of Round shares already much more then 0? Update Main Page Settings does not work in Admin Panel Yes, past is relative to shares before current round. This avoids a nasty amount of sql overhead. I'll have Admin Panel working again shortly.
|
Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
|
|
|
mich
Legendary
Offline
Activity: 3304
Merit: 1034
#1 VIP Crypto Casino
|
|
July 19, 2011, 05:23:31 PM |
|
Yes, past is relative to shares before current round. This avoids a nasty amount of sql overhead. I'll have Admin Panel working again shortly. [/quote]
I've change default value "NULL" in table 'webUsers' col's 'share_count' and 'stale_share_count' to 0 - now table shows current shares
|
|
|
|
simplecoin (OP)
|
|
July 19, 2011, 05:44:42 PM |
|
Yes, past is relative to shares before current round. This avoids a nasty amount of sql overhead. I'll have Admin Panel working again shortly.
I've change default value "NULL" in table 'webUsers' col's 'share_count' and 'stale_share_count' to 0 - now table shows current shares [/quote] Good to know. I had solved shares before this was implemented, so it never came up.
|
Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
|
|
|
mich
Legendary
Offline
Activity: 3304
Merit: 1034
#1 VIP Crypto Casino
|
|
July 21, 2011, 04:57:55 PM |
|
Button "Lost Password" is there just for anturage? I haven't found any code serves this event...
|
|
|
|
simplecoin (OP)
|
|
July 21, 2011, 05:38:08 PM |
|
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....
|
Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
|
|
|
AnnihilaT
|
|
July 22, 2011, 08:53:48 AM |
|
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.
|
|
|
|
simplecoin (OP)
|
|
July 22, 2011, 04:32:51 PM |
|
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.
|
Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
|
|
|
oseido
Newbie
Offline
Activity: 24
Merit: 0
|
|
July 26, 2011, 12:33:38 PM |
|
Hi to all. We are very impressive about Simplecoin Pushpool Web Frontend. We have start an italian minig pool with this amazing opensource software, and we are in testig. We are also meditating to enable ssl support, but because certificate was self-signed (we have a L.A.M.P system redyrected on dyndns.org) we are finding a way for make certificate not affected about the orrible browser ssl self-signed warning. We hope tath people can test the server. Tnx a lot for simplecoin again!! oseido Chemtrail Italia Cooperative Bitcoin Mining Pool http://chemtrail.dyndns.org:8080/Mining Port = 8332
|
|
|
|
simplecoin (OP)
|
|
July 26, 2011, 03:06:45 PM |
|
Added a forum for discussion and support since I'm often afk in irc. Feel free to give your fellow admins help and share your solutions.
|
Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
|
|
|
simplecoin (OP)
|
|
July 27, 2011, 09:00:33 PM |
|
More updates to v3 pushed to repo.
|
Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
|
|
|
simplecoin (OP)
|
|
July 28, 2011, 09:49:28 PM |
|
Just added capability to offload heavy stats to replicated server (less stress on your pool sql server).
|
Donations: 1VjGJHPtLodwCFBDWsHJMdEhqRcRKdBQk
|
|
|
Paul4games
Newbie
Offline
Activity: 46
Merit: 0
|
|
August 04, 2011, 02:12:34 PM |
|
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?
|
|
|
|
simplecoin (OP)
|
|
August 04, 2011, 07:58:34 PM |
|
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
|
|
|
Paul4games
Newbie
Offline
Activity: 46
Merit: 0
|
|
August 04, 2011, 09:35:27 PM |
|
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
|
|
August 04, 2011, 10:32:51 PM |
|
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 (OP)
|
|
August 05, 2011, 04:32:57 AM |
|
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
|
|
August 05, 2011, 08:13:34 AM |
|
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 (OP)
|
|
August 05, 2011, 05:11:22 PM |
|
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
|
|
|
|