Fixed, these were all mistakes by the cause of typos. I used my DNS (the VPS) instead of the IP. I also used my domain as remote host of the MySQL server instead of the IP! So don't use domain or DNS's like:
(
www.urdomain.com or
www.urdns.no-ip.org) to point to the servers, only use IP's.
A tip to all: make sure you check everything is correct, servers match, username of bitcoin and mysql match, passwords match with the correct usernames!
Whenever I start up pushpool( # ./pushpoold -E -F )
I get the following output:
# ./pushpoold -E -F
Listening on host :: port 8342
Listening on host :: port 8347
Listening on host :: port 8344
Listening on host 127.0.0.1 port 8338
#
As you can see, it doesn't say 'initialized' or anything and it stops the server.
My remote server:My MySQL tables: My MySQL columns: My server.json
{
# 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,
#p
# r
{ "port" : 8344, "protocol" : "http-json",
"proxy" : "78.47.80.74" },
# 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" : "myremotehost",
"port" : 3306,
#database name
"name" : "correctdatabasename",
#database username
"username" : "correctusername",
#database password
"password" : "correctpassword",
#enable sharelog | to insert share data or sometimes known
"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
# 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" : "correctusername",
"rpc.pass" : "correctpassword",
# rewrite returned 'target' to difficulty-1?
"rpc.target.rewrite" : true
}
Edit one: Ok it seemt that my server.json host was wrong, I fixed it.
Edit two: The passwords of server.json and bitcoin.conf didn't matched, I fixed it.
Edit three: Okay, these were all mistakes by the cause of typos. I used my DNS (the VPS) instead of the IP. I also used my domain as remote host of the MySQL server instead of the IP!