Pushpool newbie and thanks for creating this hope you add to it..
I was unsable to see where the mysql data base tables are for setting up the db.. the only thing I have is the pool worker which has user and pass.. in the github section I didnt see any .sql files or missed anything about table creation..
next issue.. I have bitcoind running, and have pushpull running as far as I can tell, Im connecting cgminer to my pool via
cgminer -o 172.18.251.190:8337 -u abc -p 123 (this is whats in the push pull db)
In the pushpull log im seeing:
> POST / HTTP/1.1
Authorization: Basic xxxxxxxxxxxxxxxxx
Host: 127.0.0.1:8332
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 46
* HTTP 1.0, assume close after body
< HTTP/1.0 401 Authorization Required
< Date: Thu, 02 May 2013 21:31:16 +0000
< Server: bitcoin-json-rpc/v0.8.1.0-g34d62a8-beta
* Authentication problem. Ignoring this.
< WWW-Authenticate: Basic realm="jsonrpc"
< Content-Type: text/html
< Content-Length: 296
* The requested URL returned error: 401
* Closing connection #0
my server.json is
{
# 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" : "mysql",
# 'host' defaults to localhost, if not specified
"host" : "localhost",
# 'port' uses proper default port for the DB engine,
# if not specified
"port" : 3306,
"name" : "pushpool",
"username" : "root",
"password" : "12345678",
"stmt.pwdb" :
"SELECT password FROM pool_worker WHERE username = ?"
},
# 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" : "mybitcoinduser",
"rpc.pass" : "mybitcoindpass",
# rewrite returned 'target' to difficulty-1?
"rpc.target.rewrite" : true,
# allow clients to update the ntime field of their work
btc config is
server=1
daemon=1
rpcallowip=*
rpcuser=mybitcoinduser
rpcpassword=mybitcoindpass
any thoughts? :?