Pushpool - Tech Support

[grue]

A few requirements were missing from the original post try this:

sudo aptitude install libmemcached-dev

then try ./configure

again

aptitude?
apt-get right?

[redshark1802]

yep, sudo apt-get

[grue]

yep, sudo apt-get

ok, i installed it, but

checking for memcached... no
configure: error: "could not find memcached binary"
pool@pool-virtual-machine:~/libmemcached-0.50$ make
make: *** No targets specified and no makefile found.  Stop.

and just to confirm it's installed:

pool@pool-virtual-machine:~/libmemcached-0.50$ sudo apt-get install libmemcached-dev
Reading package lists... Done
Building dependency tree       
Reading state information... Done
libmemcached-dev is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

[redshark1802]

try apt-get install memcached

regards, redshark1802

[grue]

try apt-get install memcached

regards, redshark1802

Thank you very much, i think i got everything installed, but ./pushpoold doesn't do anything. it just exits immediately

[redshark1802]

use ./pushpoold -E -c server.json

regards, redshark1802

[grue]

pool@pool-virtual-machine:~/pushpool/sbin$ ./pushpoold -E -c server.json
pool@pool-virtual-machine:~/pushpool/sbin$
still fails (there is server.json)

[frizzl]

Usually a database permission error stops it

[cuqa]

I gotta say thanks for this amazingly detailed tutorial.

I had only 1 issue setting up the server with Long Polling in the end, since ./blkmond didnt want to start with error msg: crypto.hash missing or something like that.

solved with:
apt-get install python-dev
python setup.py build
python setup.py install

[gigabytecoin]

How can I tell if pushpoold is running?

I have setup bitcoind and downloaded the full blockchain on ubuntu 11.04 within the ec2 cloud.

I installed pushpool 0.5 and edited the server.json file to talk to a remote mysql database.

I have enabled pushpoold for execution by chmod +x pushpoold.

Whenever I enter ./pushpoold I get no response. No errors. No nothing.

I have not setup the MySQL Databases yet. Is that entirely necessary?

Even with ./pushpoold -E and ./pushpoold --config=/home/ubuntu/pushpool/sbin/server.json --debug=2 -E -F I see nothing.

After I entered make install I received the following:

Code:

make[1]: Entering directory `/home/ubuntu/pushpool-0.5'
test -z "/home/ubuntu/pushpool/sbin" || /bin/mkdir -p "/home/ubuntu/pushpool/sbin" /usr/bin/install -c pushpoold '/home/ubuntu/pushpool/sbin'
test -z "/home/ubuntu/pushpool/sbin" || /bin/mkdir -p "/home/ubuntu/pushpool/sbin" /usr/bin/install -c blkmond '/home/ubuntu/pushpool/sbin'
make[1]: Nothing to be done for `install-data-am'.
make[1]: Leaving directory `/home/ubuntu/pushpool-0.5'

Soooo, did it work?

[phorensic]

To all who might not have ready my previous comments.  Pushpool has a bug that does not display output on the command line.  This is a bug in the current "released" version.  Please patch your pushpool based on github commits.  This will probably show you the error the next time you run it.  Most of my errors were do to an invalid format of server.json.  It is really easy to screw up the format of that file.

[gigabytecoin]

To all who might not have ready my previous comments.  Pushpool has a bug that does not display output on the command line.  This is a bug in the current "released" version.  Please patch your pushpool based on github commits.  This will probably show you the error the next time you run it.  Most of my errors were do to an invalid format of server.json.  It is really easy to screw up the format of that file.

Thanks for that. I will try an older version.

What exactly is the difference between 0.4 and 0.5 anyways? Is it that significant?

So could it be that pushpoold is in fact running and simply not giving any output yet?

Perhaps if I setup the mysql databases and start mining on testnet I will see some results?

And in the default server.json file shown above, it shows:

Code:

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

Which is it? 8341 or 8347? Or does it even matter?

[Xenland]

Anything as far as setting ports in the top portion of the json file probubly dosne't matter as long as there above 1025

To all who might not have ready my previous comments.  Pushpool has a bug that does not display output on the command line.  This is a bug in the current "released" version.  Please patch your pushpool based on github commits.  This will probably show you the error the next time you run it.  Most of my errors were do to an invalid format of server.json.  It is really easy to screw up the format of that file.

Thanks for that. I will try an older version.

What exactly is the difference between 0.4 and 0.5 anyways? Is it that significant?

So could it be that pushpoold is in fact running and simply not giving any output yet?

Perhaps if I setup the mysql databases and start mining on testnet I will see some results?

And in the default server.json file shown above, it shows:

Code:

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

Which is it? 8341 or 8347? Or does it even matter?

[phorensic]

Even if you have CLI output fixed it won't show much unless you have blkmond running and it gets signals for long polling.  You should at least see it define the ports it is listening on.  Actually --debug=2 shows every getwork on the CLI I think.  The difference between 0.4 and 0.5 is major, but you still need to patch 0.5.  Not sure why jgarzik hasn't released another version yet.

[d3c0n808]

After I run pushpool for maybe 8 hours or so I end up getting and error and having to restart pushpool daemon. The error I get is [warn] accept_socket: bad accept: Too many open files  anyone else had anything like that?  And if so what was your fix?

[gigabytecoin]

Even if you have CLI output fixed it won't show much unless you have blkmond running and it gets signals for long polling.  You should at least see it define the ports it is listening on.  Actually --debug=2 shows every getwork on the CLI I think.  The difference between 0.4 and 0.5 is major, but you still need to patch 0.5.  Not sure why jgarzik hasn't released another version yet.

Anyone care to explain "but you still need to patch 0.5" in slightly greater detail? I am using ubuntu 11.04.

Or do you know where I can still download 0.4? It doesn't seem to be accessible from it's original url: http://yyz.us/bitcoin/pushpool-0.4.tar.gz
Found this http://yyz.us/bitcoin/pushpool-0.4.1.tar.gz so will this build give me some more information on errors or do I still need to "patch" 0.5?
0.4.1 does indeed give the error codes! And it seems as though it "works" as well. I can see it running at least.

Also I managed to get blkmond running it looks like, but it's spitting out a lot of text, within seconds of running, is this normal?

Code:

send msg_version(nVersion=312 nServices=1 nTime=Sat Jun 25 19:31:34 2011 addrTo=CAddress(nServices=1 ip=127.0.0.1 port=8333) addrFrom=CAddress(nServices=1 ip=0.0.0.0 port=0) nNonce=0xF12DF2FFA513F8B0 strSubVer=.4 nStartingHeight=-1)
connecting
connected
recv msg_version(nVersion=32300 nServices=1 nTime=Sat Jun 25 19:31:33 2011 addrTo=CAddress(nServices=1 ip=127.0.0.1 port=57098) addrFrom=CAddress(nServices=1 ip=50.19.120.151 port=8333) nNonce=0xE4B198358B30CDB8 strSubVer= nStartingHeight=133254)
send msg_verack()
recv msg_verack()
recv msg_inv(inv=[CInv(type=TX hash=128ddb9cd0a91d0ff8ae7c82a939e33a85fecf64921eb1f1da12fd95c0744d91), CInv(type=TX hash=661d5b0bcd848c5192200e9e168ef2ba4cb6a853cf0d739ea34b56918ae6b80a)])
send msg_getdata(inv=[CInv(type=TX hash=128ddb9cd0a91d0ff8ae7c82a939e33a85fecf64921eb1f1da12fd95c0744d91), CInv(type=TX hash=661d5b0bcd848c5192200e9e168ef2ba4cb6a853cf0d739ea34b56918ae6b80a)])
recv msg_tx(tx=CTransaction(nVersion=1 vin=[CTxIn(prevout=COutPoint(hash=ac3c035302175657ec217542e5e14059d80f0319cc35080b754cc19b34370c03 n=0) scriptSig=48304502210085a4ecfd5e7d6ee1e7e3a4bb9dee8d47e4fcc62847cd4190f39473c9767e21d102204306275da9e5231b7ff7ccd7938b22e92982619981847d378b7ed0d0ddddef8c01410451600042d30a814b77a310d97ea7b0d1c925960cc5742ea3425cf83079e02be646ec09d7d36e0971bcbd5aa404625383d6590fb074715a68314d7cb37bbf866a nSequence=4294967295)] vout=[CTxOut(nValue=74.20398086 scriptPubKey=76a914b0ade54a014c0347c9d2ddbe59aabf47eb3cc18988ac), CTxOut(nValue=0.02000000 scriptPubKey=76a914f165ad82179ed54c3ebe7045e8c1060a80ceb5b388ac)] nLockTime=0))
recv msg_tx(tx=CTransaction(nVersion=1 vin=[CTxIn(prevout=COutPoint(hash=34d866bb14b9f6c8430d07c69c6d58dc4094c4cfe03c5432ce1a04e898f18bd1 n=0) scriptSig=48304502204ade19afdafe46da772fdf21fec9a1a5bfedd315b9c80687f7b429d86453831a022100c8bc1dfa301e59e85c1f700ea7aee63f92118c71672c62e58cd00be7ac687feb01410423d18a67bf1a550630e203fdd065909852048f1718d0c779e39c911e7339d2bb0cbe2db8c62dcde60db4e95bcc83fcac118323ca09ba3f178cda44c5e9fbc12d nSequence=4294967295)] vout=[CTxOut(nValue=86.32000000 scriptPubKey=76a9143402d6f30d0ed1fbe2f22c98cf6d173f2a47009d88ac), CTxOut(nValue=0.06000000 scriptPubKey=76a914cd86a101225db084e1b478ae9d33a7c518f3312588ac)] nLockTime=0))
recv msg_inv(inv=[CInv(type=TX hash=4fbf7d3ebaa98977aa528c8d7c84180dadd6e9fa414753666ea1e69e17279833), CInv(type=TX hash=7bdae316ccb85b1e7ad255e2bda6c1298ff090812ed71b850f38db356227689d)])
send msg_getdata(inv=[CInv(type=TX hash=4fbf7d3ebaa98977aa528c8d7c84180dadd6e9fa414753666ea1e69e17279833), CInv(type=TX hash=7bdae316ccb85b1e7ad255e2bda6c1298ff090812ed71b850f38db356227689d)])
recv msg_tx(tx=CTransaction(nVersion=1 vin=[CTxIn(prevout=COutPoint(hash=64459ab7e23142f49333fc33645f7ca5d677a09d1f29022ec97c52ddfdeecdc4 n=1) scriptSig=4730440220102f9d1a66b6d745d7daef41145535d766e0cc0bdb79c2bd2b0ac3e3523b6d2d02201c1e9e4b88eeac384275df92d73a19407fa262024a111f0546cfb7ca1e071478014104cdacc5c4036437dd0b129c2e663b075cab7308dfbe7908cba837f22dd13be47e1c36556ffaa8452660598b63b16a53723782b08fbca04d8408fe302a381e1e7f nSequence=4294967295)] vout=[CTxOut(nValue=27.10000000 scriptPubKey=76a91465e231681c84b9c5180bfbb5b5f513848e17bc2888ac), CTxOut(nValue=0.10000000 scriptPubKey=76a91477b521de341f0af6c2767a1b0d17fbf32b69bf1a88ac)] nLockTime=0))
recv msg_tx(tx=CTransaction(nVersion=1 vin=[CTxIn(prevout=COutPoint(hash=1eb5cc1be15d773f4b7240401bca4b81a771b4fc25b8b6e5164fe7cc8c35a8ae n=1) scriptSig=493046022100ff6717bdfaf684c7f5995f2d0f5381e469e923e3222e1641911127062a62f324022100854387f35800def39f97e27b1a81b972430aa3842a2f3f4b4c84d96b435de98e0141046e55318272238806551e466602977a8b7e61f2f92d2693d735621f4e7d53cb8736406871f453c0d951b87fc74ab6d64be90e9ef774f35f0d134b5f4432d4b1b4 nSequence=4294967295), CTxIn(prevout=COutPoint(hash=ff743b34220bc7d87af427c841102183fc7894e80ecd30a00f830b05107a100d n=1) scriptSig=49304602210080721beba03b70d9e64523ccebce99628c41900d136d961375785d6495a93782022100828bbc1b83dd16d8dadde784a2528d2c6c824e11090f9a50ae8f6f8be259dd7f014104193f4fc0b04676f0a1ba17310bcc857221fb98772bf47a813ed69510e6814069ac02f2cdb212e3507227a8b8992886d320798fd98fe6ef11091e17ab996ca28f nSequence=4294967295)] vout=[CTxOut(nValue=0.03430000 scriptPubKey=76a9148fa56800972d9f3753d60fcee86469e7ca84103a88ac), CTxOut(nValue=0.26520000 scriptPubKey=76a914d7b1268e881a1bff07f2c8f84da01d8310bcd14c88ac)] nLockTime=0))
recv msg_inv(inv=[CInv(type=TX hash=e1812c1374ad6c0ab879bbbfc7bd400c3eb994b3b2988ebdbfd21cf5e9aee436)])
send msg_getdata(inv=[CInv(type=TX hash=e1812c1374ad6c0ab879bbbfc7bd400c3eb994b3b2988ebdbfd21cf5e9aee436)])
recv msg_tx(tx=CTransaction(nVersion=1 vin=[CTxIn(prevout=COutPoint(hash=c61052c210d5fb75c36e3b245b7d0f0c8d7cc19be8d6c3b2e3fa5def22840b64 n=1) scriptSig=48304502204622dee23fa1a916c82c47d8df7a8c8ba9a794ae216330161ad02175a4226d2c022100e01f817c6c924c95a1235276d0dd3220cca0dba23155414201b092600adbb3090141049693bdc3c44e50e7a2fde8c4e1ebc03258ab172b65e691065e9ae6784f0500230aed9c59b4b2dbf7b85a0903116e73ea544d0c761cac3ff3911a1c33336d635a nSequence=4294967295)] vout=[CTxOut(nValue=27.19000000 scriptPubKey=76a914c2b9f5f22be5e28b5a503562a7be971c6bf8265488ac), CTxOut(nValue=0.10000000 scriptPubKey=76a91477b521de341f0af6c2767a1b0d17fbf32b69bf1a88ac)] nLockTime=0))
recv msg_inv(inv=[CInv(type=TX hash=7586d330d1f0629666fd941e13be02ed78593a77f0afaf552d06197c5f994446)])
send msg_getdata(inv=[CInv(type=TX hash=7586d330d1f0629666fd941e13be02ed78593a77f0afaf552d06197c5f994446)])
recv msg_tx(tx=CTransaction(nVersion=1 vin=[CTxIn(prevout=COutPoint(hash=b3b885da4cc7f3e8c5c8d88cd377ff9b224070ce14235d724d2d8d0565751857 n=0) scriptSig=47304402206fe32beb8619450910f3d4fc2d2e194670a5d3c2354b8e65aa0bb0b111023fe802206f1cc3bb30feb8e2e6b54007960f186a31f999166c07d51faae5fbfaa694b6fb01410495e612928574c025367d80f785144a2cd9c4240e90cf882960502c69972d4af9aede1d0b18328aa7cb0cc664147ebe139284735759789408dbf1b2bcc6eca4a4 nSequence=4294967295)] vout=[CTxOut(nValue=105.06716859 scriptPubKey=76a9148bf5402b09aa5a4d444905fea0cc77a2c8b4894688ac), CTxOut(nValue=0.04000000 scriptPubKey=76a91422785e09c441c8ad79a122f2fa8eb79b4700a32988ac)] nLockTime=0))
recv msg_inv(inv=[CInv(type=TX hash=49d47113c081a04aa83602b19152632c2e8af5b7449455f22229a5caac723797)])
send msg_getdata(inv=[CInv(type=TX hash=49d47113c081a04aa83602b19152632c2e8af5b7449455f22229a5caac723797)])
recv msg_tx(tx=CTransaction(nVersion=1 vin=[CTxIn(prevout=COutPoint(hash=960ea3350c7058cf555f771881330fafa1c21e4091b921190b428a60d5c1b336 n=1) scriptSig=49304602210098f5558ba95bfafb1877978480c9a89f2e5fb4e2aa116aba482ad3c10c5d73da022100c32c4023a2afc3e860e38a547af8597a888977d5b68a50e5d9641d3c99fec09801410427a281233c220cb3628c87c6412bdd7632cd57e8acb3fa6062ec09c93035924f841d2772c51ed677e45e617a597012331224519b29d484fa2fb41c51e26a4da2 nSequence=4294967295)] vout=[CTxOut(nValue=27.20000000 scriptPubKey=76a91451ebe18fdfeb5e2aa4b7b7b53cfd1316442ccce688ac), CTxOut(nValue=0.10000000 scriptPubKey=76a91477b521de341f0af6c2767a1b0d17fbf32b69bf1a88ac)] nLockTime=0))

Edit: Ok I have everything running now! Thanks guys Now you can message me for help too (hopefully!)

[Xenland]

If reccomend poke pull push i hear its very intuitive, and easy to start

[smoothie]

Below is all of my code and commands that I run but I can't seem to understand how to connect my phoenix miner to my server that is running pushpoold. The output that I get from my phoenix miner is Problems connecting to RPC. Am I supposed to connect with the port that is in bitcoin.conf (that wouldn't make sense in setting up a pool though).

Server.json

Code:

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

      # HTTP JSON-RPC protocol, port 8341
      { "port" : 8341, "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" : "192.168.1.11" },

      # binary protocol, localhost-only port 8339
      # 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" : "mysqladmin",
      #database password
      "password" : "xxxxxxxx",
      #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" : "/home/bitcoinminer2/POOLINSTALL/pushpool-0.5/pushpoold.pid",

   # overrides local hostname detection
   "forcehost" : "localhost.localdomain",

   "log.requests" : "/home/bitcoinminer2/POOLINSTALL/pushpool-0.5/request.log",
   "log.shares" : "/home/bitcoinminer2/POOLINSTALL/pushpool-0.5/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:9098/",
   #Username & password to connect to bitcoind
   "rpc.user" : "user",
   "rpc.pass" : "pass",

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

bitcoind.conf

Code:

rpcuser=user
rpcpassword=pass
rpcport=9098
server=1
gen=0
rpcallowip=*

commands

Code:

memcached -u bitcoinminer2
./bitcoind -server -daemon
./pushpoold -E

Output

Code:

bitcoinminer2@ubuntu:~/POOLINSTALL/pushpool-0.5$
[2011-06-25 14:35:43.004276] Listening on host :: port 8342
[2011-06-25 14:35:43.004627] Listening on host :: port 8341
[2011-06-25 14:35:43.004749] Listening on host :: port 8344
[2011-06-25 14:35:43.004859] Listening on host 127.0.0.1 port 8338

Phoenix settings

Code:

start /DC:\Phoenix phoenix.exe -u http://NH2LwYuL585o6sgiikAG42sbmAhGwj8Vsd:pass@192.168.1.11:8338/;askrate=10 -k poclbm VECTORS BFI_INT AGGRESSION=11 WORKSIZE=128 DEVICE=0 FASTLOOP=false

Mysql Commands

Code:

sudo /etc/init.d/mysql start
mysql -u root -p
use pushpool

Mysql Output

Code:

mysql> SELECT * FROM pool_worker;
+----+------------------+------------------------------------+----------+
| id | associatedUserId | username                           | password |
+----+------------------+------------------------------------+----------+
|  1 |                0 | NH2LwYuL585o6sgiikAG42sbmAhGwj8Vsd | pass     |
+----+------------------+------------------------------------+----------+
1 row in set (0.01 sec)

mysql> SELECT * FROM shares;
Empty set (0.00 sec)

mysql> 

[gigabytecoin]

Below is all of my code and commands that I run but I can't seem to understand how to connect my phoenix miner to my server that is running pushpoold. The output that I get from my phoenix miner is Problems connecting to RPC. Am I supposed to connect with the port that is in bitcoin.conf (that wouldn't make sense in setting up a pool though).

Server.json

Code:

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

      # HTTP JSON-RPC protocol, port 8341
      { "port" : 8341, "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" : "192.168.1.11" },

      # binary protocol, localhost-only port 8339
      # 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" : "mysqladmin",
      #database password
      "password" : "xxxxxxxx",
      #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" : "/home/bitcoinminer2/POOLINSTALL/pushpool-0.5/pushpoold.pid",

   # overrides local hostname detection
   "forcehost" : "localhost.localdomain",

   "log.requests" : "/home/bitcoinminer2/POOLINSTALL/pushpool-0.5/request.log",
   "log.shares" : "/home/bitcoinminer2/POOLINSTALL/pushpool-0.5/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:9098/",
   #Username & password to connect to bitcoind
   "rpc.user" : "user",
   "rpc.pass" : "pass",

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

bitcoind.conf

Code:

rpcuser=user
rpcpassword=pass
rpcport=9098
server=1
gen=0
rpcallowip=*

commands

Code:

memcached -u bitcoinminer2
./bitcoind -server -daemon
./pushpoold -E

Output

Code:

bitcoinminer2@ubuntu:~/POOLINSTALL/pushpool-0.5$
[2011-06-25 14:35:43.004276] Listening on host :: port 8342
[2011-06-25 14:35:43.004627] Listening on host :: port 8341
[2011-06-25 14:35:43.004749] Listening on host :: port 8344
[2011-06-25 14:35:43.004859] Listening on host 127.0.0.1 port 8338

Phoenix settings

Code:

start /DC:\Phoenix phoenix.exe -u http://NH2LwYuL585o6sgiikAG42sbmAhGwj8Vsd:pass@192.168.1.11:8338/;askrate=10 -k poclbm VECTORS BFI_INT AGGRESSION=11 WORKSIZE=128 DEVICE=0 FASTLOOP=false

Mysql Commands

Code:

sudo /etc/init.d/mysql start
mysql -u root -p
use pushpool

Mysql Output

Code:

mysql> SELECT * FROM pool_worker;
+----+------------------+------------------------------------+----------+
| id | associatedUserId | username                           | password |
+----+------------------+------------------------------------+----------+
|  1 |                0 | NH2LwYuL585o6sgiikAG42sbmAhGwj8Vsd | pass     |
+----+------------------+------------------------------------+----------+
1 row in set (0.01 sec)

mysql> SELECT * FROM shares;
Empty set (0.00 sec)

mysql> 

Has bitcoind downloaded all of the blockchain yet? ./bitcoind getblockcount (should be around 133,297 right now)

Is bitcoind running? ps aux | grep bitcoind

Have you opened up the ports on your machine so that you can access port 8341 from the external miner?

[gigabytecoin]

Am I correct in believing that a "Y" value inside the upstream_result MySQL column denotes the exact username, ip address and solution which was just solved?

In other words, a Y means I found a block?