Pushpool - Tech Support

[smoothie]

I compile and install pushpoold, but after running it exit and doesnot return any information about error or another. Try use -D and -E keys. Logs not creating.
How I can know why pushpoold not work?

In the latest version 0.5 there is a bug in "util.c" that prevents any output on the CLI when running pushpoold.  See here on how to fix it, then recompile - https://github.com/ius/pushpool/commit/85297905ddc150c46664bd9ad77df6f502d64be1 .  It will probably give you an error when you run it now, similar to "JSON parse failed" like mine was doing.

Update:  A couple of hours ago the author jgarzik posted a slightly different fix: https://github.com/jgarzik/pushpool/commit/385e23fa3a149a650dbbeb5bff8d3a84f949e5bf

On page 8 Phorensic pointed out a bug in .5 that was fixed on github.  You might try and download the latest with the fix and recompile and try.  Default port for mysql is 3306.  Which is what the default server.json has it set as.  If you need to change it edit:  the my.cnf file.  You might also want to try webmin on your linux box it has a lot of features especially for those of us less savy on linux.

I downloaded the most recent version of util.c and recompiled with it. This allowed me to actually see output when I run pushpoold (although it exits immediately after starting it). As far as the MySQL port I think I will leave it as the default. I just am puzzled as to why when I run ./pushpoold -E the output is the following and then exits:

Code:

bitcoinminer2@ubuntu:~/POOLINSTALL/pushpool-0.5$ ./pushpoold -E
bitcoinminer2@ubuntu:~/POOLINSTALL/pushpool-0.5$ [2011-06-26 23:15:47.680372] Listening on host :: port 8342
[2011-06-26 23:15:47.680703] Listening on host :: port 8341
[2011-06-26 23:15:47.680835] Listening on host :: port 8344
[2011-06-26 23:15:47.680934] Listening on host 127.0.0.1 port 8338

I'm still not getting what could be the problem. I've also created rules in iptables to allow the ports specified at the top of server.json to be OPEN.

I'm to the point that I'm willing to offer a $100 worth of bitcoin if someone can help me figure this problem out.

Any takers?

[padrino]

I would run it with strace and see what it's up to before it quits. If you like post the output (last 30-40 lines) and I'll see what I can tell you.

[smoothie]

I would run it with strace and see what it's up to before it quits. If you like post the output (last 30-40 lines) and I'll see what I can tell you.

What is strace and where can I get it?

[gigabytecoin]

Can anybody give me a rundown of how exactly an optimal mining pool web front end would work with the mysql databases and information that pushpoolcreates?

For starters... how can I translate a "solution" (that looks like this 00000001823e485a4f458cfad7aa684392fdb0ddeb678...) into the current blockchain's block number we are trying to solve?

Do I have to check to see what is the latest (non-stale) solution that was submit to the pool is and at the same time check ./bitcoind getblockcount simultaneously to correlate a block number or..?

How is this page possible: http://btcmine.com/stats/

[gigabytecoin]

So in other words... pushpool isn't capable of testing through testnet until the difficulty is at least 256, is that correct?

Or in other words... pushpool works flawlessly, just not with testnet?

pushpool makes you work harder for your testnet coins

Patches to implement a full and correct target check are welcome.

I multiplied the number of solved blocks by 256 and roughly came up with the same number of shares found in my pool.

This would be proof that you are telling the truth there, is it not?

So just to get thing's straight... pushpool requires a minimum difficulty of 256 in order to function properly. Is that statement correct?

No need to patch the problem... I am throwing all my mining might at the testnet network in order to bump it over 256 just to make sure

[smoothie]

I would run it with strace and see what it's up to before it quits. If you like post the output (last 30-40 lines) and I'll see what I can tell you.

Okay here is the last 30-40 lines of output of running strace ./pushpoold. Any help debugging will be much appreciated:

Code:

bind(12, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 0
getsockname(12, {sa_family=AF_NETLINK, pid=2665, groups=00000000}, [12]) = 0
sendto(12, "\24\0\0\0\26\0\1\3\210\n\tN\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20
recvmsg(12, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"0\0\0\0\24\0\2\0\210\n\tNi\n\0\0\2\10\200\376\1\0\0\0\10\0\1\0\177\0\0\1"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 108
recvmsg(12, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"@\0\0\0\24\0\2\0\210\n\tNi\n\0\0\n\200\200\376\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 128
recvmsg(12, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"\24\0\0\0\3\0\2\0\210\n\tNi\n\0\0\0\0\0\0\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 20
close(12)                               = 0
socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 12
setsockopt(12, SOL_SOCKET, SO_REUSEADDR, [1], 4) = 0
bind(12, {sa_family=AF_INET, sin_port=htons(8338), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
listen(12, 100)                         = 0
fcntl(12, F_GETFL)                      = 0x2 (flags O_RDWR)
fcntl(12, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
epoll_ctl(3, EPOLL_CTL_ADD, 12, {EPOLLIN, {u32=12, u64=12}}) = 0
write(2, "[2011-06-27 22:56:8.643232] List"..., 66[2011-06-27 22:56:8.643232] Listening on host 127.0.0.1 port 8338
) = 66
socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 13
connect(13, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
close(13)                               = 0
socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 13
connect(13, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
close(13)                               = 0
open("/etc/nsswitch.conf", O_RDONLY)    = 13
fstat(13, {st_mode=S_IFREG|0644, st_size=513, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f728cb6f000
read(13, "# /etc/nsswitch.conf\n#\n# Example"..., 4096) = 513
read(13, "", 4096)                      = 0
close(13)                               = 0
munmap(0x7f728cb6f000, 4096)            = 0
open("/etc/ld.so.cache", O_RDONLY)      = 13
fstat(13, {st_mode=S_IFREG|0644, st_size=58359, ...}) = 0
mmap(NULL, 58359, PROT_READ, MAP_PRIVATE, 13, 0) = 0x7f728cb61000
close(13)                               = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/x86_64-linux-gnu/tls/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/x86_64-linux-gnu/tls/x86_64", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/lib/x86_64-linux-gnu/tls/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/x86_64-linux-gnu/tls", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/lib/x86_64-linux-gnu/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/x86_64-linux-gnu/x86_64", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/lib/x86_64-linux-gnu/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/x86_64-linux-gnu", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/usr/lib/x86_64-linux-gnu/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/tls/x86_64", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/lib/tls/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/tls", 0x7fffc51808f0)        = -1 ENOENT (No such file or directory)
open("/lib/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/x86_64", 0x7fffc51808f0)     = -1 ENOENT (No such file or directory)
open("/lib/libnss_db.so.2", O_RDONLY)   = -1 ENOENT (No such file or directory)
stat("/lib", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/usr/lib/tls/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib/tls/x86_64", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib/tls", 0x7fffc51808f0)    = -1 ENOENT (No such file or directory)
open("/usr/lib/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib/x86_64", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/usr/lib/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib", {st_mode=S_IFDIR|0755, st_size=53248, ...}) = 0
munmap(0x7f728cb61000, 58359)           = 0
open("/etc/ld.so.cache", O_RDONLY)      = 13
fstat(13, {st_mode=S_IFREG|0644, st_size=58359, ...}) = 0
mmap(NULL, 58359, PROT_READ, MAP_PRIVATE, 13, 0) = 0x7f728cb61000
close(13)                               = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/x86_64-linux-gnu/libnss_files.so.2", O_RDONLY) = 13
read(13, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\"\0\0\0\0\0\0"..., 832) = 832
fstat(13, {st_mode=S_IFREG|0644, st_size=51728, ...}) = 0
mmap(NULL, 2148104, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 13, 0) = 0x7f7288332000
mprotect(0x7f728833e000, 2093056, PROT_NONE) = 0
mmap(0x7f728853d000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 13, 0xb000) = 0x7f728853d000
close(13)                               = 0
mprotect(0x7f728853d000, 4096, PROT_READ) = 0
munmap(0x7f728cb61000, 58359)           = 0
open("/etc/services", O_RDONLY|O_CLOEXEC) = 13
fcntl(13, F_GETFD)                      = 0x1 (flags FD_CLOEXEC)
fstat(13, {st_mode=S_IFREG|0644, st_size=19666, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f728cb6f000
read(13, "# Network services, Internet sty"..., 4096) = 4096
read(13, "9/tcp\t\t\t\t# Quick Mail Transfer P"..., 4096) = 4096
read(13, "4/udp\nrmiregistry\t1099/tcp\t\t\t# J"..., 4096) = 4096
close(13)                               = 0
munmap(0x7f728cb6f000, 4096)            = 0
rt_sigaction(SIGPIPE, {SIG_IGN, [PIPE], SA_RESTORER|SA_RESTART, 0x7f728b190d80}, {SIG_IGN, [PIPE], SA_RESTORER|SA_RESTART, 0x7f728b190d80}, 8) = 0
socket(PF_FILE, SOCK_STREAM, 0)         = 13
fcntl(13, F_SETFL, O_RDONLY)            = 0
fcntl(13, F_GETFL)                      = 0x2 (flags O_RDWR)
connect(13, {sa_family=AF_FILE, path="/var/run/mysqld/mysqld.sock"}, 110) = 0
setsockopt(13, SOL_SOCKET, SO_RCVTIMEO, "\2003\341\1\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(13, SOL_SOCKET, SO_SNDTIMEO, "\2003\341\1\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(13, SOL_IP, IP_TOS, [8], 4)  = -1 EOPNOTSUPP (Operation not supported)
setsockopt(13, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
read(13, "=\0\0\0\n5.1.54-1ubuntu4\0%\0\0\0M6f~giY"..., 16384) = 65
stat("/usr/share/mysql/charsets/Index.xml", {st_mode=S_IFREG|0644, st_size=18261, ...}) = 0
open("/usr/share/mysql/charsets/Index.xml", O_RDONLY) = 14
read(14, "<?xml version='1.0' encoding=\"ut"..., 18261) = 18261
close(14)                               = 0
write(13, "I\0\0\1\255\242\0\0\0\0\0@\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 77) = 77
read(13, "N\0\0\2\377\25\4#28000Access denied for u"..., 16384) = 82
shutdown(13, 2 /* send and receive */)  = 0
close(13)                               = 0
unlink("/home/bitcoinminer2/POOLINSTALL/pushpool-0.5/pushpoold.pid") = 0
close(8)                                = 0
exit_group(0) 

[smoothie]

I would run it with strace and see what it's up to before it quits. If you like post the output (last 30-40 lines) and I'll see what I can tell you.

Okay here is the last 30-40 lines of output of running strace ./pushpoold. Any help debugging will be much appreciated:

Code:

bind(12, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 0
getsockname(12, {sa_family=AF_NETLINK, pid=2665, groups=00000000}, [12]) = 0
sendto(12, "\24\0\0\0\26\0\1\3\210\n\tN\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20
recvmsg(12, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"0\0\0\0\24\0\2\0\210\n\tNi\n\0\0\2\10\200\376\1\0\0\0\10\0\1\0\177\0\0\1"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 108
recvmsg(12, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"@\0\0\0\24\0\2\0\210\n\tNi\n\0\0\n\200\200\376\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 128
recvmsg(12, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"\24\0\0\0\3\0\2\0\210\n\tNi\n\0\0\0\0\0\0\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 20
close(12)                               = 0
socket(PF_INET, SOCK_STREAM, IPPROTO_TCP) = 12
setsockopt(12, SOL_SOCKET, SO_REUSEADDR, [1], 4) = 0
bind(12, {sa_family=AF_INET, sin_port=htons(8338), sin_addr=inet_addr("127.0.0.1")}, 16) = 0
listen(12, 100)                         = 0
fcntl(12, F_GETFL)                      = 0x2 (flags O_RDWR)
fcntl(12, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
epoll_ctl(3, EPOLL_CTL_ADD, 12, {EPOLLIN, {u32=12, u64=12}}) = 0
write(2, "[2011-06-27 22:56:8.643232] List"..., 66[2011-06-27 22:56:8.643232] Listening on host 127.0.0.1 port 8338
) = 66
socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 13
connect(13, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
close(13)                               = 0
socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 13
connect(13, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
close(13)                               = 0
open("/etc/nsswitch.conf", O_RDONLY)    = 13
fstat(13, {st_mode=S_IFREG|0644, st_size=513, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f728cb6f000
read(13, "# /etc/nsswitch.conf\n#\n# Example"..., 4096) = 513
read(13, "", 4096)                      = 0
close(13)                               = 0
munmap(0x7f728cb6f000, 4096)            = 0
open("/etc/ld.so.cache", O_RDONLY)      = 13
fstat(13, {st_mode=S_IFREG|0644, st_size=58359, ...}) = 0
mmap(NULL, 58359, PROT_READ, MAP_PRIVATE, 13, 0) = 0x7f728cb61000
close(13)                               = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/x86_64-linux-gnu/tls/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/x86_64-linux-gnu/tls/x86_64", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/lib/x86_64-linux-gnu/tls/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/x86_64-linux-gnu/tls", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/lib/x86_64-linux-gnu/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/x86_64-linux-gnu/x86_64", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/lib/x86_64-linux-gnu/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/x86_64-linux-gnu", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/usr/lib/x86_64-linux-gnu/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/tls/x86_64", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/lib/tls/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/tls", 0x7fffc51808f0)        = -1 ENOENT (No such file or directory)
open("/lib/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/lib/x86_64", 0x7fffc51808f0)     = -1 ENOENT (No such file or directory)
open("/lib/libnss_db.so.2", O_RDONLY)   = -1 ENOENT (No such file or directory)
stat("/lib", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/usr/lib/tls/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib/tls/x86_64", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib/tls", 0x7fffc51808f0)    = -1 ENOENT (No such file or directory)
open("/usr/lib/x86_64/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib/x86_64", 0x7fffc51808f0) = -1 ENOENT (No such file or directory)
open("/usr/lib/libnss_db.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/usr/lib", {st_mode=S_IFDIR|0755, st_size=53248, ...}) = 0
munmap(0x7f728cb61000, 58359)           = 0
open("/etc/ld.so.cache", O_RDONLY)      = 13
fstat(13, {st_mode=S_IFREG|0644, st_size=58359, ...}) = 0
mmap(NULL, 58359, PROT_READ, MAP_PRIVATE, 13, 0) = 0x7f728cb61000
close(13)                               = 0
access("/etc/ld.so.nohwcap", F_OK)      = -1 ENOENT (No such file or directory)
open("/lib/x86_64-linux-gnu/libnss_files.so.2", O_RDONLY) = 13
read(13, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\"\0\0\0\0\0\0"..., 832) = 832
fstat(13, {st_mode=S_IFREG|0644, st_size=51728, ...}) = 0
mmap(NULL, 2148104, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 13, 0) = 0x7f7288332000
mprotect(0x7f728833e000, 2093056, PROT_NONE) = 0
mmap(0x7f728853d000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 13, 0xb000) = 0x7f728853d000
close(13)                               = 0
mprotect(0x7f728853d000, 4096, PROT_READ) = 0
munmap(0x7f728cb61000, 58359)           = 0
open("/etc/services", O_RDONLY|O_CLOEXEC) = 13
fcntl(13, F_GETFD)                      = 0x1 (flags FD_CLOEXEC)
fstat(13, {st_mode=S_IFREG|0644, st_size=19666, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f728cb6f000
read(13, "# Network services, Internet sty"..., 4096) = 4096
read(13, "9/tcp\t\t\t\t# Quick Mail Transfer P"..., 4096) = 4096
read(13, "4/udp\nrmiregistry\t1099/tcp\t\t\t# J"..., 4096) = 4096
close(13)                               = 0
munmap(0x7f728cb6f000, 4096)            = 0
rt_sigaction(SIGPIPE, {SIG_IGN, [PIPE], SA_RESTORER|SA_RESTART, 0x7f728b190d80}, {SIG_IGN, [PIPE], SA_RESTORER|SA_RESTART, 0x7f728b190d80}, 8) = 0
socket(PF_FILE, SOCK_STREAM, 0)         = 13
fcntl(13, F_SETFL, O_RDONLY)            = 0
fcntl(13, F_GETFL)                      = 0x2 (flags O_RDWR)
connect(13, {sa_family=AF_FILE, path="/var/run/mysqld/mysqld.sock"}, 110) = 0
setsockopt(13, SOL_SOCKET, SO_RCVTIMEO, "\2003\341\1\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(13, SOL_SOCKET, SO_SNDTIMEO, "\2003\341\1\0\0\0\0\0\0\0\0\0\0\0\0", 16) = 0
setsockopt(13, SOL_IP, IP_TOS, [8], 4)  = -1 EOPNOTSUPP (Operation not supported)
setsockopt(13, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
read(13, "=\0\0\0\n5.1.54-1ubuntu4\0%\0\0\0M6f~giY"..., 16384) = 65
stat("/usr/share/mysql/charsets/Index.xml", {st_mode=S_IFREG|0644, st_size=18261, ...}) = 0
open("/usr/share/mysql/charsets/Index.xml", O_RDONLY) = 14
read(14, "<?xml version='1.0' encoding=\"ut"..., 18261) = 18261
close(14)                               = 0
write(13, "I\0\0\1\255\242\0\0\0\0\0@\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 77) = 77
read(13, "N\0\0\2\377\25\4#28000Access denied for u"..., 16384) = 82
shutdown(13, 2 /* send and receive */)  = 0
close(13)                               = 0
unlink("/home/bitcoinminer2/POOLINSTALL/pushpool-0.5/pushpoold.pid") = 0
close(8)                                = 0
exit_group(0)  

okay i figured out the problem. It was a username/password issue into my database causing the problem. Now pushpool says it is "initialized" but still I can't connect with my phoenix or poclbm miners.

Any ideas?

Also what is testnet? I must have missed that part of the forum that talks in depth about this. Any help is appreciated.

[frizzl]

My basic understanding is testnet is a test blockchain similar to the main BTC blockchain, gigabytecoin and others are using it to test their software at a much less difficulty allowing you to make checks easier.  From what i gather pushpool isnt quite designed to run on it as the difficulty is so low compared to the main BTC blockchain. 

The default server.json has the statement:

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


So you need a database defined "pushpool" with a table called "pool_worker" with at least "username" and "password" fields with values that your miner will use.  These fields are checked from the above statment, which are your miners username and pw.

Can you telnet to the 8344 port from your other box?

[phorensic]

I would run it with strace and see what it's up to before it quits. If you like post the output (last 30-40 lines) and I'll see what I can tell you.

Okay here is the last 30-40 lines of output of running strace ./pushpoold. Any help debugging will be much appreciated:
<snip>

okay i figured out the problem. It was a username/password issue into my database causing the problem. Now pushpool says it is "initialized" but still I can't connect with my phoenix or poclbm miners.

Any ideas?

Also what is testnet? I must have missed that part of the forum that talks in depth about this. Any help is appreciated.

One of the biggest problems with pushpool right now is lack of verbose debugging output.  "--debug=2 -E -F" is the maximum you can get, IIRC.  But it still might autoquit or just sit there and not tell you why something isn't connecting.

Testnet = https://en.bitcoin.it/wiki/Testnet

[smoothie]

Does this installation work on Cent OS 5?

[gigabytecoin]

Does this installation work on Cent OS 5?

Which installation are you referring to exactly? What release version?

[smoothie]

Does this installation work on Cent OS 5?

Which installation are you referring to exactly? What release version?

Cent OS 5 I believe.

[smoothie]

Has any of you been able to successfully compile namecoind on ubuntu/linux?

This is what I get when running the following command:


make -f makefile.unix USE_UPNP=

Code:

root@enemsi:~/namecoin# make -f makefile.unix USE_UPNP=
g++ -c -O2 -Wno-invalid-offsetof -Wformat -g -D__WXDEBUG__ -DNOPCH -DFOURWAYSSE2 -DUSE_SSL -o obj/nogui/util.o util.cpp
In file included from util.cpp:5:0:
headers.h:43:20: fatal error: db_cxx.h: No such file or directory
compilation terminated.
make: *** [obj/nogui/util.o] Error 1

What is db_cxx.h and where do I get it? I tried looking around and can't seem to find it. Any help is appreciated!

[smoothie]

Anyone get the following error message concerning installing pushpool? I get it multiple times throughout the setup for pushpool:

Code:

Processing triggers for libc-bin ...
ldconfig deferred processing now taking place

[gigabytecoin]

Anyone get the following error message concerning installing pushpool? I get it multiple times throughout the setup for pushpool:

Code:

Processing triggers for libc-bin ...
ldconfig deferred processing now taking place

Nope. Never seen that. And yes, I was able to install pushpool on the latest ubuntu 11.04 server edition.

QUESTION: is /tmp/shares.log and /tmp/request.log entirely necessary? Under what circumstances would one require those files? I assume they would become quite massive in a short amount of time.

I was thinking of simply backing up the shares mysql table every day in case I needed to do a rollback or something perhaps. Can't really imagine why I would ever need to do one of those either, however.

As soon as a block is found you may as well split up all the earnings immedately and EMPTY the MySQL Shares table, no? Or perhaps constantly empty all shares that are over 7 days old..? Or 2 blocks behind?

[jgarzik]

QUESTION: is /tmp/shares.log and /tmp/request.log entirely necessary? Under what circumstances would one require those files? I assume they would become quite massive in a short amount of time.

Send SIGHUP to the process, to re-open the logs (such as after rotation or deletion).

[smoothie]

Why would I get an error message that says invalid database.engine when running ./pushpool -E?

I'm setting up pushpool on a vps ubuntu 11.04 install.

Code:

read(6, "TZif2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\4\0\0\0\4\0\0\0\0"..., 4096) = 2819
lseek(6, -1802, SEEK_CUR)               = 1017
read(6, "TZif2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\5\0\0\0\5\0\0\0\0"..., 4096) = 1802
close(6)                                = 0
munmap(0x7effc605e000, 4096)            = 0
write(2, "[2011-06-30 04:27:6.645422] inva"..., 52[2011-06-30 04:27:6.645422] invalid database.engine
) = 52
exit_group(1)

[dikidera]

Because either the db engine you specified in the server.json file is spelled wrong OR you didn't install the said engine. I.e mysql,sqlite or postgresql

[smoothie]

Because either the db engine you specified in the server.json file is spelled wrong OR you didn't install the said engine. I.e mysql,sqlite or postgresql

Does it matter if I installed mysql server?

I created the tables pool_worker and shares and inserted a test worker username and password. Prior to that I created a database named pushpool. Here is some output to prove that it is installed:

Code:

root@NCM:/home/pushpool-0.5.1# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
root@NCM:/home/pushpool-0.5.1# clear
root@NCM:/home/pushpool-0.5.1# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 49
Server version: 5.1.54-1ubuntu4 (Ubuntu)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use pushpool;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>
mysql>
mysql>
mysql>
mysql> SHOW TABLE STATUS;
+-------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| Name        | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation         | Checksum | Create_options | Comment |
+-------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
| pool_worker | MyISAM |      10 | Dynamic    |    1 |             52 |          52 | 281474976710655 |         2048 |         0 |              2 | 2011-06-29 21:17:37 | 2011-06-29 21:22:58 | NULL       | latin1_swedish_ci |     NULL |                |         |
| shares      | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |              1 | 2011-06-29 21:20:46 | 2011-06-29 21:20:46 | NULL       | latin1_swedish_ci |     NULL |                |         |
+-------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+----------------+---------+
2 rows in set (0.00 sec)

mysql> SELECT * pool_worker;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pool_worker' at line 1
mysql> SELECT * FROM pool_worker;
+----+------------------+------------------------------------+----------+
| id | associatedUserId | username                           | password |
+----+------------------+------------------------------------+----------+
|  1 |                0 | NH2LwYuL585o6sgiikAG42sbmAhGwj8Vsd | pass     |
+----+------------------+------------------------------------+----------+
1 row in set (0.00 sec)

mysql>

[smoothie]

Because either the db engine you specified in the server.json file is spelled wrong OR you didn't install the said engine. I.e mysql,sqlite or postgresql

Also if you take a look in my server.json file you will see I put "mysql" under engine:

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,
      #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" : "208.111.40.205" },

      # 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" : "localhost",

      "port" : 3306,

      #database name
      "name" : "pushpool",
      #database username
      "username" : "root",
      #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" : "/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" : "user",
   "rpc.pass" : "pass",

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