Topic: pushpool - open source pool software - page 11. (Read 120205 times)

So let me get this straight...

pushpool is simply a backend software that determines how many blocks a certain username has mined and stores that information on a mysql database?

Can you show me an example of what the mysql database structure is you are working with in pushpool? What values is it keeping track of exactly?

#define DEFAULT_STMT_PWDB \
        "SELECT password FROM pool_worker WHERE username = ?"
#define DEFAULT_STMT_SHARELOG \
        "INSERT INTO shares (rem_host, username, our_result, "          \
        "                    upstream_result, reason, solution) "       \
        "VALUES(?,?,?,?,?,?)"

I'm curious as to what you intend for the push binary protocol. It hasn't really gotten much traction though it looks like a fine implementation. Since Phoenix now supports MMP (Multiminer), would you consider patches that added MMP support to Pushpool?

Another question, how can I see the total hash per sec that my pool is doing ?

Generation on bitcoind should be disabled.  That is the slow CPU mining.


bitcoind is your upstream.  pushpool is having trouble communicating with bitcoind.

On bitcoin.conf (where my bitcoind server runs), do I need gen=0 or 1 ?

I guess generate should be 0 on server, right ?

# ./minerd -a sse2_64 -t 20 --url http://my.pushpool.server:8337 --userpass test:test
[2011-05-17 16:58:32] JSON-RPC call failed: {
   "message": "upstream RPC error",
   "code": -2
}

What about this one: http://forum.bitcoin.org/index.php?topic=1458.0

Well, for an example.

What should be there instead of the question mark?

There is only one:  bitcoind, the official bitcoin client.

"SELECT password FROM pool_worker WHERE username = ?"

Any idea what to write here? Lots of stuff and i am still banging my head on the listening part

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

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

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

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

   # database settings
   "database" : {
      "engine" : "sqlite3",
      "name" : "/tmp/data.sqlite",
      "stmt.pwdb" :
        "SELECT password FROM pool_worker WHERE username = ?"

      # ... or ...

      "engine" : "mysql",

      # 'host' defaults to localhost, if not specified
      "host" : "mysql.example.com",

      # 'port' uses proper default port for the DB engine,
      # if not specified
      "port" : 12121,

      "name" : "mydatabasename",
      "username" : "myuser",
      "password" : "mypass",

      "stmt.pwdb" :
        "SELECT password FROM pool_worker WHERE username = ?"

      # ... or ...

      "engine" : "postgresql",

      "host" : "db.example.com",

      "port" : 12121,

      "name" : "mydatabasename",
      "username" : "myuser",
      "password" : "mypass",

      "stmt.pwdb" :
        "SELECT password FROM pool_worker WHERE username = $1"
   },

   # 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
   "rpc.url" : "http://127.0.0.1:8332/",
   "rpc.user" : "myusername",
   "rpc.pass" : "mypassword",

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

So, what bitcoin server is the best to be used with pushpool ?

When users earn btc...where to they come from when they request payout? If it's a wait for 100 blocks confirmation thing or when it's instant.

How does one define the formula where the earned 50btc are split between users?