Pages:
Author

Topic: Pushpool - Tech Support - page 2. (Read 135232 times)

newbie
Activity: 52
Merit: 0
May 05, 2013, 02:45:12 PM
If that file is not being generated one reason call be that the option doesnt exist or the name is wrong, that would be the usual.

For how long have you been running the pool? I supposse that your client is full synchronized so the problem is not that its still downloading the data hehe (happened to me Tongue)

Btw in bitcoind the option for the pid file is -pid as well in pushpool, you sure you have the right option?

Well fixed the .pid file... still no shares in table shares in mysql database.

Problem is Pushpool is not generating shares... but only... how to fix  :@

whats the uptime of the pool? I mean, how long have pushpool being running? it could take some time to get a share (like in p2pool) and probably as right now you are doing the same as solo mining could be that the hash rate is not enough and your are getting a long poll before actually sending any share

Im currently testing with 4000 KH/Sec... no a single share given for 30 min.

Im running pushpool myself right now checking the sql logs and also dont see any shares on my minner but quite some long polls (running bitcoind), I would recommend to let it run for 24h or more, if you are not in a hurry of course, to see if it shows something, crypto coins are not usually something you can test in a few hours while solo hehe
newbie
Activity: 56
Merit: 0
May 05, 2013, 02:39:24 PM
If that file is not being generated one reason call be that the option doesnt exist or the name is wrong, that would be the usual.

For how long have you been running the pool? I supposse that your client is full synchronized so the problem is not that its still downloading the data hehe (happened to me Tongue)

Btw in bitcoind the option for the pid file is -pid as well in pushpool, you sure you have the right option?

Well fixed the .pid file... still no shares in table shares in mysql database.

Problem is Pushpool is not generating shares... but only... how to fix  :@

whats the uptime of the pool? I mean, how long have pushpool being running? it could take some time to get a share (like in p2pool) and probably as right now you are doing the same as solo mining could be that the hash rate is not enough and your are getting a long poll before actually sending any share

Im currently testing with 4000 KH/Sec... no a single share given for 30 min.
newbie
Activity: 52
Merit: 0
May 05, 2013, 02:11:24 PM
If that file is not being generated one reason call be that the option doesnt exist or the name is wrong, that would be the usual.

For how long have you been running the pool? I supposse that your client is full synchronized so the problem is not that its still downloading the data hehe (happened to me Tongue)

Btw in bitcoind the option for the pid file is -pid as well in pushpool, you sure you have the right option?

Well fixed the .pid file... still no shares in table shares in mysql database.

Problem is Pushpool is not generating shares... but only... how to fix  :@

whats the uptime of the pool? I mean, how long have pushpool being running? it could take some time to get a share (like in p2pool) and probably as right now you are doing the same as solo mining could be that the hash rate is not enough and your are getting a long poll before actually sending any share
newbie
Activity: 56
Merit: 0
May 05, 2013, 01:59:50 PM
If that file is not being generated one reason call be that the option doesnt exist or the name is wrong, that would be the usual.

For how long have you been running the pool? I supposse that your client is full synchronized so the problem is not that its still downloading the data hehe (happened to me Tongue)

Btw in bitcoind the option for the pid file is -pid as well in pushpool, you sure you have the right option?

Well fixed the .pid file... still no shares in table shares in mysql database.

Problem is Pushpool is not generating shares... but only... how to fix  :@
newbie
Activity: 52
Merit: 0
May 05, 2013, 01:46:37 PM
If that file is not being generated one reason call be that the option doesnt exist or the name is wrong, that would be the usual.

For how long have you been running the pool? I supposse that your client is full synchronized so the problem is not that its still downloading the data hehe (happened to me Tongue)

Btw in bitcoind the option for the pid file is -pid as well in pushpool, you sure you have the right option?
newbie
Activity: 56
Merit: 0
May 05, 2013, 01:23:16 PM


Did you check this guide?

https://bitcointalksearch.org/topic/m.1867412

also if not shares are appearing in the minner then its not getting any :S did you try connecting the miner directly to the client as in solo and see if it receives shares? Im not sure how feathercoin works with the shares so Im a little bit at lost over there.

When you directly connect to the bitcoind // litecoind // feathercoind you will only get a share when a blocks is found... As far as I know... I should be able to get shares when pushpool give it to the miner...

The thing is, i actually did check, double check en triple check all config files Smiley

Could it have anything todo with the pushpool.pid file not being generated?

http://img713.imageshack.us/img713/630/reapernoshares.png
newbie
Activity: 52
Merit: 0
May 05, 2013, 01:19:55 PM
Did you check this guide?

https://bitcointalksearch.org/topic/m.1867412

also if not shares are appearing in the minner then its not getting any :S did you try connecting the miner directly to the client as in solo and see if it receives shares? Im not sure how feathercoin works with the shares so Im a little bit at lost over there.
newbie
Activity: 56
Merit: 0
May 05, 2013, 01:16:21 PM
try removing this line:

Code:
"rpc.target.bits" : 32

Looks like that config is specific for bitcoins, should be 18 for ltc but not sure, I read about just removing it, could be preventing the pool from getting shares, btw, did you connect with a miner? does the miner receive shares?



My guess is that pushpool is not actually getting shares so thats why is not logging them Smiley more of a problem with the call I would go for a problem of getting nothing to log hehe

Also one miner is connected with 1100 Kh/Sec.. no shares are giving... 0:0 shares
newbie
Activity: 56
Merit: 0
May 05, 2013, 01:14:09 PM
try removing this line:

Code:
"rpc.target.bits" : 32

Looks like that config is specific for bitcoins, should be 18 for ltc but not sure, I read about just removing it, could be preventing the pool from getting shares, btw, did you connect with a miner? does the miner receive shares?



My guess is that pushpool is not actually getting shares so thats why is not logging them Smiley more of a problem with the call I would go for a problem of getting nothing to log hehe

Debug window shows share:

Quote
{
   "error": null,
   "result": {
      "target": "00000000000000000000000000000000000000000000000000a2170200000000",
      "midstate": "de93d5a64ac4c6ca5afae157a76c8bf295ad57ccbe5dd7af2f06e7a06ea214ac",
      "data": "000000014fb7d1e3eac4df9038891d48e375b3082913d0777035caa9c58738a8888683abbf082eb 3983120587b2e77b6836672f8849b9b7bbdc4ba6471ae1c9b1cfae8f951857b201c0217a2000000 0000000080000000000000000000000000000000000000000000000000000000000000000000000 0000000000080020000",
      "hash1": "0000000000000000000000000000000000000000000000000000000000000000000000800000000 0000000000000000000000000000000000000000000010000",
      "algorithm": "scrypt:1024,1,1"
   },
   "id": 5
}

This i a Feathercoin pool... My LTC pool runs with rpc.target.bits : 20 just fine...

I though that it could be feathercoin related, then I also installed litecoin on the server waited for blocks to sync, and had the same issue... Then I reinstalled everything still same issue Smiley



newbie
Activity: 52
Merit: 0
May 05, 2013, 01:06:36 PM
try removing this line:

Code:
"rpc.target.bits" : 32

Looks like that config is specific for bitcoins, should be 18 for ltc but not sure, I read about just removing it, could be preventing the pool from getting shares, btw, did you connect with a miner? does the miner receive shares?



My guess is that pushpool is not actually getting shares so thats why is not logging them Smiley more of a problem with the call I would go for a problem of getting nothing to log hehe
newbie
Activity: 52
Merit: 0
May 05, 2013, 01:05:35 PM
try removing this line:

Code:
"rpc.target.bits" : 32

Looks like that config is specific for bitcoins, should be 18 for ltc but not sure, I read about just removing it, could be preventing the pool from getting shares, btw, did you connect with a miner? does the miner receive shares?

newbie
Activity: 56
Merit: 0
May 05, 2013, 01:02:22 PM
quite strange, the problem i faced and fixed with the commit was similar but I was seeing the insert on the sql logs, let me do a little bit of research and I will be back in a few minutes.

Sure few questions:
Did you start your LTC of Feathercoin daemon with -pollpidfile=/tmp/pushpoold.pid ?

My feathercoin.conf
Quote
server=1
daemon=1
rpcallowip=127.0.0.1
rpcport=9667
rpcuser=admin
rpcpass=****

I dont think it will be at the side of the feathercoind...

strange thing is that when I edit the "stmt.pwdb" : to an INSERT query, there are rows written into the database... But those are bullshit ofcourse Smiley

newbie
Activity: 52
Merit: 0
May 05, 2013, 12:55:12 PM
quite strange, the problem i faced and fixed with the commit was similar but I was seeing the insert on the sql logs, let me do a little bit of research and I will be back in a few minutes.
newbie
Activity: 56
Merit: 0
May 05, 2013, 12:46:13 PM
Try this:

Code:
"stmt.sharelog" : "INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?); COMMIT;"

Same results:

My ./pushpoold -E -F --debug=2 gives back shares... Only they are not writting into the database...

When I tail my mysql query logs, i see the select query for worker authentification but not the insert query...

Quote
JSON protocol request:
{"method": "getwork", "params": [], "id":5}

* Re-using existing connection! (#0) with host 127.0.0.1
* Connected to 127.0.0.1 (127.0.0.1) port 9667 (#0)
* Server auth using Basic with user 'admin'
> POST / HTTP/1.1
Authorization: Basic YWRtaW46amFqZWthbGVtb2VkZXJrdXQwMDEyNA==
Host: 127.0.0.1:9667
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 45

< HTTP/1.1 200 OK
< Date: Sat, 04 May 2013 21:18:26 +0000
< Connection: keep-alive
< Content-Length: 622
< Content-Type: application/json
< Server: feathercoin-json-rpc/v0.6.3.0-g3aaa7ba-beta
<
* Connection #0 to host 127.0.0.1 left intact
JSON protocol response:
{
   "error": null,
   "result": {
      "target": "00000000000000000000000000000000000000000000000000a2170200000000",
      "midstate": "de93d5a64ac4c6ca5afae157a76c8bf295ad57ccbe5dd7af2f06e7a06ea214ac",
      "data": "000000014fb7d1e3eac4df9038891d48e375b3082913d0777035caa9c58738a8888683abbf082eb 3983120587b2e77b6836672f8849b9b7bbdc4ba6471ae1c9b1cfae8f951857b201c0217a2000000 0000000080000000000000000000000000000000000000000000000000000000000000000000000 0000000000080020000",
      "hash1": "0000000000000000000000000000000000000000000000000000000000000000000000800000000 0000000000000000000000000000000000000000000010000",
      "algorithm": "scrypt:1024,1,1"
   },
   "id": 5
}

Also, mysql database user has INSERT access...

It seems "stmt.sharelog" is not being executed by pushpool. I have removed the extra "sharelog" : true, as that was a test... but fact that the select query is executed and the INSERT is not im puzzled.. Also I reinstalled the entire server already same results...

newbie
Activity: 52
Merit: 0
May 05, 2013, 12:41:46 PM
Try this:

Code:
"stmt.sharelog" : "INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?); COMMIT;"
newbie
Activity: 56
Merit: 0
May 05, 2013, 12:38:22 PM
Not sure about the file logs but the DB problem can be fixed with a commit after the insert as I already explained before Smiley

I still have an empty shares table...

Quote
{
        # network ports
        "listen" : [
                # binary protocol (default), port 8342
                { "port" : 8342 },

                # HTTP JSON-RPC protocol, port 8341
                { "port" : 8341, "protocol" : "http-json" },

                # HTTP JSON-RPC protocol, port 8344,
                # with trusted proxy appserver.example.com forwarding
                # requests to us
                { "port" : 8332, "protocol" : "http-json",
                  "proxy" : "127.0.0.1" },

                # binary protocol, localhost-only port 8338
                { "host" : "127.0.0.1", "port" : 8338, "protocol" : "binary" }
        ],

"sharelog" : true,

        # database settings
        "database" : {
                "engine" : "mysql",
                "host" : "localhost",
                "port" : 3306,
                "name" : "pool_user",
                "username" : "pool_user",
                "password" : "",
                "stmt.pwdb" : "SELECT `password` FROM `pool_worker` WHERE `username` = ?",
                "sharelog" : true,
                "stmt.sharelog" : "INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?) COMMIT"

        },

        # cache settings
        "memcached" : {
                "servers" : [
                        { "host" : "127.0.0.1", "port" : 11211 }
                ]
        },

        "pid" : "/tmp/pushpoold.pid",

        # overrides local hostname detection
        "forcehost" : "localhost.localdomain",

        "log.requests" : "/tmp/request.log",
        "log.shares" : "/tmp/sharessss.log",

        # the server assumes longpolling (w/ SIGUSR1 called for each blk)
        "longpoll.disable" : false,

        # length of time to cache username/password credentials, in seconds
        "auth.cred_cache.expire" : 75,

        # RPC settings | Notice how this ISN'T port number 8332 this is becuase the same port number should not becuase inconjunction with the JSON RPC port other wise you'll get 500 errors
        "rpc.url" : "http://127.0.0.1:9667/",
        "rpc.user" : "admin",
        "rpc.pass" : "----",

        # rewrite returned 'target' to difficulty-1?
        # "rpc.target.rewrite" : true
        "rpc.target.bits" : 32
}
newbie
Activity: 52
Merit: 0
May 05, 2013, 12:29:09 PM
Not sure about the file logs but the DB problem can be fixed with a commit after the insert as I already explained before Smiley
newbie
Activity: 56
Merit: 0
May 05, 2013, 09:07:09 AM
What could be the issue when PushPool can check worker user/pass from DB but does not write shares to DB or to /tmp/shares.log?

Pushpool successfully executes this query:
Quote
"stmt.pwdb" : "SELECT `password` FROM `pool_worker` WHERE `username` = ?",

Pushpool is not excuting this query:
Quote
"stmt.sharelog" : "INSERT INTO  `pool_user`.`shares` (`rem_host` ,`username` ,`our_result` ,`upstream_result` ,`reason` ,`solution`)VALUES (?, ?, ?, ?, ?, ?)"

Also /tmp/shares.log empty!

Quote
* Re-using existing connection! (#0) with host 127.0.0.1
* Connected to 127.0.0.1 (127.0.0.1) port 9667 (#0)
* Server auth using Basic with user 'rpcadmin'
> POST / HTTP/1.1
Authorization: Basic cnBjYWRtaW46amFqZWthbGVtb2VkZXJrdXQwMDEyNA==
Host: 127.0.0.1:9667
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 46

< HTTP/1.1 200 OK
< Date: Sun, 05 May 2013 14:22:55 +0000
< Connection: keep-alive
< Content-Length: 623
< Content-Type: application/json
< Server: feathercoin-json-rpc/v0.6.3.0-g3aaa7ba-beta
<
* Connection #0 to host 127.0.0.1 left intact
JSON protocol response:
{
   "error": null,
   "result": {
      "target": "00000000000000000000000000000000000000000000000000a2170200000000",
      "midstate": "f61c3632c6db16f6710e0ca8bd5ba3fd9c6dc9686ccab7a6717478999886984c",
      "data": "0000000172f0f7848d177618847be8d91bd724a745d762f5887d38395abc083204a2d53aa807b7c 266f0f167313daab9ebd6c284df30d0b24148a3a5a244a1e86e7c7ef351866b3c1c0217a2000000 0000000080000000000000000000000000000000000000000000000000000000000000000000000 0000000000080020000",
      "hash1": "0000000000000000000000000000000000000000000000000000000000000000000000800000000 0000000000000000000000000000000000000000000010000",
      "algorithm": "scrypt:1024,1,1"
   },
   "id": 22
}


Im lost Smiley

newbie
Activity: 56
Merit: 0
May 04, 2013, 09:42:30 PM
Hello miners...
Having an issue with pushpool and FeatherCoin...

Running Debian all packages and requirements installed.
Pushpool checks worker login from Mysql DB correctly but does not write share to the Database or to the shares.log file in /tmp/

I do not get any errors when starting pushpoold with -E -F --debug=2

Already reinstalled the server same issue :@

When I setup a LTC pool with pushpool no issues ...
newbie
Activity: 52
Merit: 0
May 03, 2013, 01:03:39 PM
Same problem as with the insert in networkBlocks, add a COMMIT call to the SQL server after the insert, it should work then.
Pages:
Jump to: