Pushpool - Tech Support

[Xenland]

I am getting an error "[2011-07-10 18:00:35.988488] mysql sharelog failed at execute".

Any suggestions?

Here's what my table looks like:

Code:

DROP TABLE IF EXISTS `btcserver`.`shares`;
CREATE TABLE  `btcserver`.`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

Post your json file(with out RPC credientials or MYSQL username or password) sounds like an easy fix.

json:

Code:

{
   # 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,
      #proxy is most likely your external ip address if your running a public p...
      # requests to us | "proxy" should be set to your ip address that people w...
      { "port" : 8344, "protocol" : "http-json", "proxy" : "192.168.XXX.XXX" },
      # binary protocol, localhost-only port 8338
      # host is most likely your localhost address
      { "host" : "127.0.0.1", "port" : 8338, "protocol" : "binary" }
   ],

   # database settings
 "database" : {
      "engine" : "mysql",
      "host" : "192.168.XXX.XXX",
      "port" : 3306,
      #database name
      "name" : "XXX",
      #database username
      "username" : "XXX",
      #database password
      "password" : "XXX",
      #enable sharelog | to insert share data or sometimes known as "work"
      "sharelog" : true,
      "stmt.pwdb" : "SELECT password FROM pool_worker WHERE username = ?",
      "stmt.sharelog" : "INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?)"

   },

   #uncoment this when you want to use memcached (Recommended for servers over...
   # cache settings
   #"memcached" : {
   #   "servers" : [
  #   "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/shares.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
   #Bitcoind Protocal settings
   #Host were bitcoind can be found on the network
   "rpc.url" : "http://127.0.0.1:8332/",
   #Username & password to connect to bitcoind
   "rpc.user" : "XXX",
   "rpc.pass" : "XXX",

   # rewrite returned 'target' to difficulty-1?
   "rpc.target.rewrite" : true
}

Make sure you applied the appropriate privileges for the selected Mysql user, and let us know if that solved the problem, if not i think i have another idea

[LivTru]

I am getting an error "[2011-07-10 18:00:35.988488] mysql sharelog failed at execute".

Any suggestions?

Here's what my table looks like:

Code:

DROP TABLE IF EXISTS `btcserver`.`shares`;
CREATE TABLE  `btcserver`.`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

Post your json file(with out RPC credientials or MYSQL username or password) sounds like an easy fix.

json:

Code:

{
   # 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,
      #proxy is most likely your external ip address if your running a public p...
      # requests to us | "proxy" should be set to your ip address that people w...
      { "port" : 8344, "protocol" : "http-json", "proxy" : "192.168.XXX.XXX" },
      # binary protocol, localhost-only port 8338
      # host is most likely your localhost address
      { "host" : "127.0.0.1", "port" : 8338, "protocol" : "binary" }
   ],

   # database settings
 "database" : {
      "engine" : "mysql",
      "host" : "192.168.XXX.XXX",
      "port" : 3306,
      #database name
      "name" : "XXX",
      #database username
      "username" : "XXX",
      #database password
      "password" : "XXX",
      #enable sharelog | to insert share data or sometimes known as "work"
      "sharelog" : true,
      "stmt.pwdb" : "SELECT password FROM pool_worker WHERE username = ?",
      "stmt.sharelog" : "INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?)"

   },

   #uncoment this when you want to use memcached (Recommended for servers over...
   # cache settings
   #"memcached" : {
   #   "servers" : [
  #   "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/shares.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
   #Bitcoind Protocal settings
   #Host were bitcoind can be found on the network
   "rpc.url" : "http://127.0.0.1:8332/",
   #Username & password to connect to bitcoind
   "rpc.user" : "XXX",
   "rpc.pass" : "XXX",

   # rewrite returned 'target' to difficulty-1?
   "rpc.target.rewrite" : true
}

Make sure you applied the appropriate privileges for the selected Mysql user, and let us know if that solved the problem, if not i think i have another idea

I gave the db user account full access. What else are you thinking?

[dikidera]

Unless you are running a VM with mysql in it, or have another computer connected via a router, the host for mysql is localhost. The error comes from this piece of code

Code:

	step = "execute";
	if (mysql_stmt_execute(stmt))
		goto err_out;

Meaning that mysql failed to execute the prepared statement.

[ziomik]

Aummm.... my problem...
btcoind and pushpoold config is ok but :

[ 412.571365] bitcoind[1153] general protection ip:b741e160 sp:b572a60c error:0 in libcrypto++.so.8.0.0[b7122000+3b9000]

Code:

[1310401001.856061] Listening on host :: port 8342
[1310401001.856708] Listening on host :: port 8341
[1310401001.857326] Listening on host :: port 8334
[1310401001.857909] Listening on host 127.0.0.1 port 8338
[1310401001.861818] initialized
[ 412.571365] bitcoind[1153] general protection ip:b741e160 sp:b572a60c error:0 in libcrypto++.so.8.0.0[b7122000+3b9000]
[1310401003.264869] HTTP request failed: Empty reply from server
[1310401006.168083] HTTP request failed: couldn't connect to host
^C[1310401009.017170] shutting down

and bitcoind is kill..

Please help...  

[dikidera]

Well..this is new, but i am going to speculate and...did you set allowip in bitcoin's bitcoin.conf file?
Add a line in the file with

allowip=127.0.0.1 save and restart bitcoin and try again with pushpoold

[ziomik]

Well..this is new, but i am going to speculate and...did you set allowip in bitcoin's bitcoin.conf file?
Add a line in the file with

allowip=127.0.0.1 save and restart bitcoin and try again with pushpoold

problem is not solved yet .. sigh
I installed all the required libraries do not understand ..

[ziomik]

Solution is delete  file in .bitcoin folder

but now another problem.
I read the error 500 that you have to wait for 4 hours, but it does not go ...

Code:

* The requested URL returned error: 500
* Closing connection #0
[2011-07-11 22:27:0.347559] HTTP request failed: The requested URL returned error: 500
JSON protocol request:
{"method": "getwork", "params": [], "id":86}

* About to connect() to 127.0.0.1 port 8331 (#0)
*   Trying 127.0.0.1... * TCP_NODELAY set
* connected
* Connected to 127.0.0.1 (127.0.0.1) port 8331 (#0)
* Server auth using Basic with user 'ziomik2'
> POST / HTTP/1.1
Authorization: Basic emlvbWlrMjo4NzM1OTA=
Host: 127.0.0.1:8331
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 46

* The requested URL returned error: 500
* Closing connection #0
[2011-07-11 22:27:0.844513] HTTP request failed: The requested URL returned error: 500
JSON protocol request:
{"method": "getwork", "params": [], "id":87}

* About to connect() to 127.0.0.1 port 8331 (#0)
*   Trying 127.0.0.1... * TCP_NODELAY set
* connected
* Connected to 127.0.0.1 (127.0.0.1) port 8331 (#0)
* Server auth using Basic with user 'ziomik2'
> POST / HTTP/1.1
Authorization: Basic emlvbWlrMjo4NzM1OTA=
Host: 127.0.0.1:8331
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 46

[LivTru]

I am getting an error "[2011-07-10 18:00:35.988488] mysql sharelog failed at execute".

Any suggestions?

Here's what my table looks like:

Code:

DROP TABLE IF EXISTS `btcserver`.`shares`;
CREATE TABLE  `btcserver`.`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

Post your json file(with out RPC credientials or MYSQL username or password) sounds like an easy fix.

json:

Code:

{
   # 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,
      #proxy is most likely your external ip address if your running a public p...
      # requests to us | "proxy" should be set to your ip address that people w...
      { "port" : 8344, "protocol" : "http-json", "proxy" : "192.168.XXX.XXX" },
      # binary protocol, localhost-only port 8338
      # host is most likely your localhost address
      { "host" : "127.0.0.1", "port" : 8338, "protocol" : "binary" }
   ],

   # database settings
 "database" : {
      "engine" : "mysql",
      "host" : "192.168.XXX.XXX",
      "port" : 3306,
      #database name
      "name" : "XXX",
      #database username
      "username" : "XXX",
      #database password
      "password" : "XXX",
      #enable sharelog | to insert share data or sometimes known as "work"
      "sharelog" : true,
      "stmt.pwdb" : "SELECT password FROM pool_worker WHERE username = ?",
      "stmt.sharelog" : "INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?)"

   },

   #uncoment this when you want to use memcached (Recommended for servers over...
   # cache settings
   #"memcached" : {
   #   "servers" : [
  #   "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/shares.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
   #Bitcoind Protocal settings
   #Host were bitcoind can be found on the network
   "rpc.url" : "http://127.0.0.1:8332/",
   #Username & password to connect to bitcoind
   "rpc.user" : "XXX",
   "rpc.pass" : "XXX",

   # rewrite returned 'target' to difficulty-1?
   "rpc.target.rewrite" : true
}

Make sure you applied the appropriate privileges for the selected Mysql user, and let us know if that solved the problem, if not i think i have another idea

I gave the db user account full access. What else are you thinking?

I am not sure what it was that I changed in the MySQL ini file but things are working now. Or, maybe it was the system reboot?

[TeraPool]

It's always a system reboot

[Wuked]

Just a quick thank you to Xenland for running this thread and helping everyone out.

[Ztjuh]

Hey there,

My miner doesn't seem to get any work..

...@...:~/pushpool$ pushpoold --config=./config.json --debug=2 --stderr --foreground
[2011-07-14 01:25:8.018911] Debug output enabled
[2011-07-14 01:25:8.050485] Listening on host :: port 8342
[2011-07-14 01:25:8.050614] Listening on host :: port 8341
[2011-07-14 01:25:8.050678] Listening on host :: port 8344
[2011-07-14 01:25:8.050740] Listening on host 127.0.0.1 port 8338
[2011-07-14 01:25:8.082694] initialized

Connecting my miner.

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

* About to connect() to 127.0.0.1 port 8333 (#0)
*   Trying 127.0.0.1... * TCP_NODELAY set
* connected
* Connected to 127.0.0.1 (127.0.0.1) port 8333 (#0)
* Server auth using Basic with user 'username'
> POST / HTTP/1.1
Authorization: Basic enRqdWg6dGVzdDEyMw==
Host: 127.0.0.1:8333
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 45

* Empty reply from server
* Connection #0 to host 127.0.0.1 left intact
[2011-07-14 01:27:16.074094] HTTP request failed: Empty reply from server
JSON protocol request:
{"method": "getwork", "params": [], "id":2}

* Connection #0 seems to be dead!
* Closing connection #0
* About to connect() to 127.0.0.1 port 8333 (#0)
*   Trying 127.0.0.1... * TCP_NODELAY set
* connected
* Connected to 127.0.0.1 (127.0.0.1) port 8333 (#0)
* Server auth using Basic with user 'username'
> POST / HTTP/1.1
Authorization: Basic enRqdWg6dGVzdDEyMw==
Host: 127.0.0.1:8333
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 45

This keeps looping since my miner would like some work..

(http://forum.bitcoin.org/index.php?topic=27988.0)

[Vadtec]

I've been reading this thread over the past 45ish mins, but I haven't come across anything to solve my problem. If I missed it, I apologize in advance.

I am running pushpool, and everything is working except for one thing. None of the shares are getting stored in the mysql db. I have checked to make sure everything is setup correctly in the db, the db user has the necessary perms (full access to the database being used), and I am running pushpool in the foreground.

I can see the shares being logged to the log file I gave, but I do not see any entries in the db table. Nor do I see any errors that would indicate there is a problem with the db table. As well, I am running pushpool in gdb, and have it set to break on the line of code that should be calling the code to insert the shares into the db table.

I am using GUI Miner 2011-06-14, running the poclm miner, bitcoin-0.3.24, and pushpool-0.5 (from the git repo).

I have put around 500 shares through pushpool, none of which show up in the db table. I have not seen a single mysql error, or error from pushpool related to mysql. I know pushpool is able to connect to the db, because I do not get errors when I have the miner login to pushpool. I also see the miner getting work like normal.

Does anyone have any info as to what might be causing the shares to get logged to file but not to the mysql db table?

- Vadtec

*Addendum: I fixed it, never mind.

[cuqa]

Hey,

what is the request.log supposed to log actually? I get lots of requests without a username like this one:

Code:

[2011-07-18 02:04:12.14616] ::ffff:xx.xxx.245.188 username1 "/"
[2011-07-18 02:04:12.114522] ::ffff:xx.xxx.226.30 - "/"
[2011-07-18 02:04:12.711918] ::ffff:xx.xxx.159.150 username2 "/"

[Furyan]

Hey,

what is the request.log supposed to log actually? I get lots of requests without a username like this one:

Code:

[2011-07-18 02:04:12.14616] ::ffff:xx.xxx.245.188 username1 "/"
[2011-07-18 02:04:12.114522] ::ffff:xx.xxx.226.30 - "/"
[2011-07-18 02:04:12.711918] ::ffff:xx.xxx.159.150 username2 "/"

That indicates a worker username/password error.  Authentication can't succeed so it just shoves an empty entry in the log.

Make sure the worker username and password are being passed correctly from the miner.

[Viceroy]

Moving this from the newb post section....

I am using Centos 5.6.



I followed the instructions on page 3 of the post:

yum groupinstall "Development Tools" -y
yum install -y openssl-devel.x86_64 mysql-devel.x86_64 \
                   curl-devel.x86_64 \
                   sqlite-devel.x86_64 \
                   postgresql-devel.x86_64 \
                   zlib-devel.x86_64 libevent-devel.x86_64

wget http://www.digip.org/jansson/releases/jansson-2.0.1.tar.gz
tar xfvz jansson-2.0.1.tar.gz; cd jansson-2.0.1/
./configure && make && make install; cd ..

yum install -y libmemcached.x86_64 \
                   libmemcached-devel.x86_64 \
                   libcurl-devel.x86_64

useradd -m pushpool
cd /home/pushpool

wget http://yyz.us/bitcoin/pushpool-0.5.1.tar.gz; tar xfvz pushpool-0.5.1.tar.gz
cd pushpool-0.5.1/;

./configure --prefix=/home/pushpool/ && make
make install
chown pushpool /home/pushpool -R; cd /home/pushpool






And I get this:

db-sqlite.c: In function âsql_openâ:
db-sqlite.c:137: error: âSQLITE_OPEN_READWRITEâ undeclared (first use in this function)
db-sqlite.c:137: error: (Each undeclared identifier is reported only once
db-sqlite.c:137: error: for each function it appears in.)
make[1]: *** [db-sqlite.o] Error 1


These do not work:
install sqlite
install sqlite-devel
use --no-sqlite  in configure



What do I need to do?
* Viceroy scratches head

[Viceroy]

so I get to the next error (HURRAY)

./configure -without-sqlite3 --prefix=/home/pushpool/ && make  

and on to the well known htole error

/home/pushpool/pushpool-0.5.1/msg.c:562: undefined reference to `htole32'

and I modify server.h adding the lines:


/*
 * fix from http://returnederror.com/tag/htole32/
 */

// Compatibility with glibc < 2.9
#if !defined(htole32) && !defined(le32toh)
#  include <byteswap.h>
#  define htole32(x)  (bswap_32(htonl(x)))
#  define le32toh(x)  (ntohl(bswap_32(x)))
#endif

/*
 * end fix from http://returnederror.com/tag/htole32/
 */


and I recompile


./configure --prefix=/home/pushpool/ && make
make install
chown pushpool /home/pushpool -R; cd /home/pushpool


and what do you know....

presto....

I gotz me a pushpoold


YEEEEEFRCKINHAWWWW
* Viceroy does a jig

I got me an error:


./pushpoold: error while loading shared libraries: libjansson.so.4: cannot open shared object file: No such file or directory


hmm... no source for info on this one yet...
* Viceroy heads to google

[Viceroy]

I'll be nice to you! I've been looking for solutions 2 days..
The Jansson Error:
1) First change directories to /usr/local/lib

Code:

cd /usr/local/lib

2) check if the libjansson.so.4 file is there.

Code:

ls

3) if it's in there do the following commands:

Code:

ln -s /usr/local/lib/libjansson.so.4 /usr/lib/libjansson.so.4

4) Make sure you reload the libraries

Code:

ldconfig

Ahhhh,


Thank you.  Would you look at that, a couple of newbies got the job done when the more experienced non-noobs can't seem too.


Thanks Flowz!

[Viceroy]

So I'm almost there...


bitcoin.conf:
http://pastebin.com/GfT0hbvp


bitcoind works fine using
user: test
pw: x
port: 8332


server.json:
http://pastebin.com/2jhCSqgF

./pushpoold -E -F --foreground --debug=2 --stderr --config=server.json

shows:

[2011-07-22 22:02:18.875301] Debug output enabled
[2011-07-22 22:02:18.875663] Forcing local hostname to localhost.localdomain
[2011-07-22 22:02:18.878457] Listening on host :: port 8342
[2011-07-22 22:02:18.878590] Listening on host :: port 8341
[2011-07-22 22:02:18.878652] Listening on host :: port 8344
[2011-07-22 22:02:18.878707] Listening on host 127.0.0.1 port 8338

I DO NOT get an "initialized"

And am unable to connect to any port other than 8332

All ports open in firewall.
Server is local at 192.168.3.52
mysql set up and working
workers installed in table mydatabase.pool_worker

Thoughts?

[Viceroy]

please also see this post:

http://forum.bitcoin.org/index.php?topic=31007.0


Flowz is still stuck in noobiehell

[Xenland]

So I'm almost there...


bitcoin.conf:
http://pastebin.com/GfT0hbvp


bitcoind works fine using
user: test
pw: x
port: 8332


server.json:
http://pastebin.com/2jhCSqgF

./pushpoold -E -F --foreground --debug=2 --stderr --config=server.json

shows:

[2011-07-22 22:02:18.875301] Debug output enabled
[2011-07-22 22:02:18.875663] Forcing local hostname to localhost.localdomain
[2011-07-22 22:02:18.878457] Listening on host :: port 8342
[2011-07-22 22:02:18.878590] Listening on host :: port 8341
[2011-07-22 22:02:18.878652] Listening on host :: port 8344
[2011-07-22 22:02:18.878707] Listening on host 127.0.0.1 port 8338

I DO NOT get an "initialized"

And am unable to connect to any port other than 8332

All ports open in firewall.
Server is local at 192.168.3.52
mysql set up and working
workers installed in table mydatabase.pool_worker

Thoughts?

    "rpc.url" : "http://127.0.0.1:8333/",
        "rpc.user" : "test",
        "rpc.pass" : "x",

Looks like pushpool is connecting to bitcoin protocal port # 8333 instead of the one you supplied in your post which is 8332 please make them match, and let us know your results