Post
Topic
Board Bitcoin Technical Support
Re: Pushpool - Tech Support
by
Xenland
on 19/06/2011, 21:36:04 UTC
Make sure your mysql database has those credntials for login and that you can infact query the database with the queries inthe json file

Folks

I am trying to set up a bitcoind + pushpoold running on an Amazon EC2. No problems on bitcoind side, but I really don't know what's happening on the pushpoold side. Compilation was smooth, but I can't manage to run it.

My config file:

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

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

      # HTTP JSON-RPC protocol, port 8344,
      #proxy is most likely your external ip address if your running a public pool | Public pools WON'T have the following ip addresses: (10.0.0.1, 127.0.0.1, 192.168.1.100, or 192.168.254.254,etc,etc)
      # requests to us | "proxy" should be set to your ip address that people will connect through
      { "port" : 8344, "protocol" : "http-json",
        "proxy" : "127.0.0.1" },

      # 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" : "localhost",

      "port" : 3306,

      #database name
      "name" : "pushpool",
      #database username
      "username" : "mysqlusername",
      #database password
      "password" : "mysqlpass",
      #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 1.5gb of ram)
   # 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/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" : "user",
   "rpc.pass" : "mypassword",

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

I'm trying to run pushpoold with this command:

Code:
# pushpoold -c /usr/local/etc/pushpool.json --debug=2 -F -E
[2011-06-19 15:49:1.684078] Debug output enabled
[2011-06-19 15:49:1.684530] Forcing local hostname to localhost.localdomain
[2011-06-19 15:49:1.698690] Listening on host :: port 8342
[2011-06-19 15:49:1.698765] Listening on host :: port 8347
[2011-06-19 15:49:1.698819] Listening on host :: port 8344
[2011-06-19 15:49:1.698870] Listening on host 127.0.0.1 port 8338

Pushpoold simply quits. No messages, no further notice. This is pushpoold-0.5. I have tried a number of different branches as well as from the latest Github official sources. Same results.

Any help is much much appreciated.

Thanks in advance.