Bitcoin Forum

Other => Beginners & Help => Topic started by: Flowz on July 22, 2011, 07:36:52 PM



Title: [FIXED!] I need some help with pushpoold! [fails to start up]
Post by: Flowz on July 22, 2011, 07:36:52 PM
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:
Code:
# ./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:
http://screensnapr.com/e/oOVjtc.png

My MySQL tables:
http://screensnapr.com/e/MAqkEY.png

My MySQL columns:
http://screensnapr.com/e/9WOvr3.png
http://screensnapr.com/e/VBtFYL.png

My server.json
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,
      #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!





Title: Re: I need some help with pushpoold! [fails to start up]
Post by: Flowz on July 22, 2011, 08:35:44 PM
Updated the thread with more info!


Title: Re: I need some help with pushpoold! [fails to start up]
Post by: Viceroy on July 22, 2011, 10:50:46 PM
i'm not getting a pid in my /tmp. 

presume the same?



Title: Re: I need some help with pushpoold! [fails to start up]
Post by: Flowz on July 22, 2011, 11:29:25 PM
I'm not getting any pid file in:
Code:
/usr/tmp
I hope that's the directory you are referring to!


Title: Re: I need some help with pushpoold! [fails to start up]
Post by: Viceroy on July 22, 2011, 11:36:02 PM
yep, same.  no pid file.
but I see two other files there...

shares.log
request.log


both empty



Title: Re: I need some help with pushpoold! [fails to start up]
Post by: Flowz on July 23, 2011, 12:01:05 AM
I don't even see those files in there! :O


Title: Re: I need some help with pushpoold! [fails to start up]
Post by: Viceroy on July 23, 2011, 12:59:56 AM
can you write to /tmp?


touch /tmp/viceroywashere.txt
ls /tmp

am I there?



Title: Re: I need some help with pushpoold! [fails to start up]
Post by: Flowz on July 23, 2011, 08:41:15 AM
can you write to /tmp?


touch /tmp/viceroywashere.txt
ls /tmp

am I there?


Yes I can write to tmp, btw I did found out that there was a problem with the remote server! I fixed it afterwards and I'm still getting the same error.


Title: Re: I need some help with pushpoold! [fails to start up]
Post by: JoelKatz on July 23, 2011, 09:13:59 AM
It is failing to open the database for some reason. It could be an incorrect setting, it could be a firewall. You may wish to add some debug output to the my_open function in the db-mysql.c file, recompile, and test again.


Title: Re: I need some help with pushpoold! [fails to start up]
Post by: Flowz on July 23, 2011, 09:37:57 AM
It is failing to open the database for some reason. It could be an incorrect setting, it could be a firewall. You may wish to add some debug output to the my_open function in the db-mysql.c file, recompile, and test again.
I'll try running the database on localhost since I'm not sure if .
I don't know how I'm going to create a database/user/pass/tables & columns but I'll try.


Title: Re: I need some help with pushpoold! [fails to start up]
Post by: Flowz on July 23, 2011, 09:44:19 AM
IT'S FIXED! Oh, I feel like a retard right now!

So the fucking moron that I am, I used my DNS's as remote host. so I switched them to IP's and it worked!