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: { # 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 }
|
|
|
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: 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>
|
|
|
I think that I have the mysql development package installed. When I run sudo apt-get install libmysqld-dev I get the following: Reading package lists... Done Building dependency tree Reading state information... Done libmysqld-dev is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 25 not upgraded. I also ran sudo apt-get install mysql-server after initially running the bold set of commands above. Any input? Try sudo apt-get install libmysqlclient-dev Okay here is the output. Seems like it's already installed: root@NCM:/home# sudo apt-get install libmysqlclient-dev Reading package lists... Done Building dependency tree Reading state information... Done libmysqlclient-dev is already the newest version. libmysqlclient-dev set to manually installed. 0 upgraded, 0 newly installed, 0 to remove and 25 not upgraded.
|
|
|
I think that I have the mysql development package installed. When I run sudo apt-get install libmysqld-dev I get the following: Reading package lists... Done Building dependency tree Reading state information... Done libmysqld-dev is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 25 not upgraded. I also ran sudo apt-get install mysql-server after initially running the bold set of commands above. Any input?
|
|
|
FYI I've installed mysql database on to Ubuntu 11.04.
Show us your server.json Here is my server.json file: { # 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 }
do you have the mysql development package installed? I think I do, but how would I be able to determine for sure?
|
|
|
Also here is the version of mysql I am using: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 45 Server version: 5.1.54-1ubuntu4 (Ubuntu)
|
|
|
FYI I've installed mysql database on to Ubuntu 11.04.
Show us your server.json Here is my server.json file: { # 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 }
|
|
|
FYI I've installed mysql database on to Ubuntu 11.04.
|
|
|
Can anyone tell me why I could get an error of invalid database.engine when running ./pushpoold -E? Here is some of the out put when running pushpool with strace. set_tid_address(0x7effc6049a10) = 25470 set_robust_list(0x7effc6049a20, 0x18) = 0 futex(0x7fff81c26a8c, FUTEX_WAKE_PRIVATE, 1) = 0 futex(0x7fff81c26a8c, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, NULL, 7effc6049740) = -1 EAGAIN (Resource temporarily unavailable) rt_sigaction(SIGRTMIN, {0x7effc57b5740, [], SA_RESTORER|SA_SIGINFO, 0x7effc57bfc60}, NULL, 8) = 0 rt_sigaction(SIGRT_1, {0x7effc57b57d0, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x7effc57bfc60}, NULL, 8) = 0 rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0 getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) = 0 brk(0) = 0x1249000 brk(0x126a000) = 0x126a000 clock_gettime(CLOCK_MONOTONIC, {13662, 657617095}) = 0 clock_gettime(CLOCK_MONOTONIC, {13662, 657690975}) = 0 getuid() = 0 geteuid() = 0 getgid() = 0 getegid() = 0 epoll_create(32000) = 3 fcntl(3, F_SETFD, FD_CLOEXEC) = 0 socketpair(PF_FILE, SOCK_STREAM, 0, [4, 5]) = 0 fcntl(4, F_SETFD, FD_CLOEXEC) = 0 fcntl(5, F_SETFD, FD_CLOEXEC) = 0 fcntl(4, F_SETFL, O_RDONLY|O_NONBLOCK) = 0 getuid() = 0 geteuid() = 0 getgid() = 0 getegid() = 0 open("server.json", O_RDONLY) = 6 fstat(6, {st_mode=S_IFREG|0644, st_size=2348, ...}) = 0 fstat(6, {st_mode=S_IFREG|0644, st_size=2348, ...}) = 0 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7effc605e000 read(6, "{\n # network ports\n \"listen\""..., 4096) = 2348 read(6, "", 4096) = 0 close(6) = 0 munmap(0x7effc605e000, 4096) = 0 gettimeofday({1309408026, 645422}, NULL) = 0 open("/etc/localtime", O_RDONLY) = 6 fstat(6, {st_mode=S_IFREG|0644, st_size=2819, ...}) = 0 fstat(6, {st_mode=S_IFREG|0644, st_size=2819, ...}) = 0 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7effc605e000 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) = ?
|
|
|
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. 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)
|
|
|
Anyone get the following error message concerning installing pushpool? I get it multiple times throughout the setup for pushpool: Processing triggers for libc-bin ... ldconfig deferred processing now taking place
|
|
|
I wonder if Namecoins has just uncover a flaw in the Bitcoin system.
Just take a look at what happen with Namecoins now, someone just brought up some serious hash power, taking the dificulty from 3500 all the way up to 55k, then retired back to Bitcoins (i guess). Now Namecoins are on a depresion, pleople stoping mining them, next dificulty is stimated at 16k, but at this rate it will not happen until 07/08/2011.
If you want to crush a crypto currency like this and you have lot of hasing power, i think the best plan is to increase the hashing power up gradually, them retire. Imagine what could happen to Bitcoins if the hasing power goes back to 2 thash/s now...
I suspect that because bitcoin was the first, the hardware and software to mine with GPUs was not available. Since when namecoin came online everything was in place, so I see no flaw here. The network is adjusting for the huge increase in mining that happened a few weeks ago with namecoins. So thus, the difficulty adjusting back down is just a result of it not being worth mining it at the current time. I suspect when bitcoin's next difficulty surpasses 1,800,000 and namecoin readjusts downward, you will see a rush into namecoin mining once again.
|
|
|
Has any of you been able to successfully compile namecoind on ubuntu/linux? I got the code off of bluishcoder.com's website. This is what I get when running the following command: make -f makefile.unix USE_UPNP=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!
|
|
|
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=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!
|
|
|
Does this installation work on Cent OS 5?
Which installation are you referring to exactly? What release version? Cent OS 5 I believe.
|
|
|
Does this installation work on Cent OS 5?
|
|
|
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: 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.
|
|
|
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: 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)
|
|
|
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?
|
|
|
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: 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?
|
|
|
|