pushpool is not setting mysql pool_worker "active" and hashrate. pushpool is working, because it accepts the login i gave it and throws client errors if i use anything else.
Pushpool is also not updated the "shares" table with any data, it says it's an empty set.
mysql> select * from sc.pool_worker;
+----+------------------+-------------+----------+--------+----------+
| id | associatedUserId | username | password | active | hashrate |
+----+------------------+-------------+----------+--------+----------+
| 1 | 1 | genewitch.1 | x | 0 | 0 |
+----+------------------+-------------+----------+--------+----------+
1 row in set (0.00 sec)
mysql> select * from sc.shares;
Empty set (0.00 sec)
Do i need to write the logic to set these, or should pushpoold be doing this itself? Please advise! :-D
edit: /tmp/shares.log is full of stuff:
[2011-06-12 00:30:9.000529] ::ffff:76.91.146.36 genewitch.1 Y - - 000000011023d492df81b494de90f30e854e953d1e72515dad22dd21000013a800000000633913820a277592654e47a21fe21701c20f542b45b0c2c345cea70e66c5ba204df4088e1a1d932f5e7ff9ff000000800000000000000000000000000000000000000000000000000000000000000000000000000000000080020000
[2011-06-12 00:30:12.190757] ::ffff:76.91.146.36 genewitch.1 Y - - 000000011023d492df81b494de90f30e854e953d1e72515dad22dd21000013a800000000633913820a277592654e47a21fe21701c20f542b45b0c2c345cea70e66c5ba204df408911a1d932f073e1230000000800000000000000000000000000000000000000000000000000000000000000000000000000000000080020000
So obviously something is going wrong somewhere in the database calls. I'd like to know if i screwed something up or if there's something i can help patch. I know it is a weekend, though, so i'll just grin and bear it for now.
edit: my miner has been running ~300MH/s for hours now, and has submitted nearly a thousand shares (and they were accepted) - but this isn't reflected anywhere in the database. Is this a privilege setting or something?
I have exactly the same problem in above post!
Please tell me what is wrong?
Thanks
Actually it resolved itself, bitcoind had to run for about 20 minutes before it finally stopped giving upstream RPC errors and connection lost in the client.
Jun 11 05:02:55 ip-10-124-17-59 pushpoold[18787]: tcp socket: Address family not supported by protocol
How did you resolved this error?
Stopped using gentoo and switched to ubuntu. It has something to do with ipv6, although on gentoo i changed USE="-ipv6 ipv4" and did emerge -DN @world and it did not fix it.
edit to ^: It's a gentoo issue 90% and the code in pushpool 10% because of the way that it gets a socket. I am not a C programmer. I cannot patch this while ensuring it works for everyone.
Thanks to the developers for making something like this that is free and works
at all. I couldn't have done it, that's for sure.