Bitcoin Forum
December 09, 2016, 04:01:32 AM *
News: Latest stable version of Bitcoin Core: 0.13.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [16] 17 18 19 20 21 22 23 24 25 26 27 28 29 30 »
  Print  
Author Topic: Pushpool - Tech Support  (Read 126778 times)
cuqa
Jr. Member
*
Offline Offline

Activity: 40


View Profile
July 18, 2011, 12:36:56 PM
 #301

Hey,

what is the request.log supposed to log actually? I get lots of requests without a username like this one:

Code:
[2011-07-18 02:04:12.14616] ::ffff:xx.xxx.245.188 username1 "/"
[2011-07-18 02:04:12.114522] ::ffff:xx.xxx.226.30 - "/"
[2011-07-18 02:04:12.711918] ::ffff:xx.xxx.159.150 username2 "/"
1481256092
Hero Member
*
Offline Offline

Posts: 1481256092

View Profile Personal Message (Offline)

Ignore
1481256092
Reply with quote  #2

1481256092
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
Furyan
Full Member
***
Offline Offline

Activity: 175



View Profile
July 18, 2011, 02:37:55 PM
 #302

Hey,

what is the request.log supposed to log actually? I get lots of requests without a username like this one:

Code:
[2011-07-18 02:04:12.14616] ::ffff:xx.xxx.245.188 username1 "/"
[2011-07-18 02:04:12.114522] ::ffff:xx.xxx.226.30 - "/"
[2011-07-18 02:04:12.711918] ::ffff:xx.xxx.159.150 username2 "/"

That indicates a worker username/password error.  Authentication can't succeed so it just shoves an empty entry in the log.

Make sure the worker username and password are being passed correctly from the miner.
Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 22, 2011, 09:50:24 PM
 #303

Moving this from the newb post section....

I am using Centos 5.6.



I followed the instructions on page 3 of the post:

yum groupinstall "Development Tools" -y
yum install -y openssl-devel.x86_64 mysql-devel.x86_64 \
                   curl-devel.x86_64 \
                   sqlite-devel.x86_64 \
                   postgresql-devel.x86_64 \
                   zlib-devel.x86_64 libevent-devel.x86_64

wget http://www.digip.org/jansson/releases/jansson-2.0.1.tar.gz
tar xfvz jansson-2.0.1.tar.gz; cd jansson-2.0.1/
./configure && make && make install; cd ..

yum install -y libmemcached.x86_64 \
                   libmemcached-devel.x86_64 \
                   libcurl-devel.x86_64

useradd -m pushpool
cd /home/pushpool

wget http://yyz.us/bitcoin/pushpool-0.5.1.tar.gz; tar xfvz pushpool-0.5.1.tar.gz
cd pushpool-0.5.1/;

./configure --prefix=/home/pushpool/ && make
make install
chown pushpool /home/pushpool -R; cd /home/pushpool






And I get this:

db-sqlite.c: In function âsql_openâ:
db-sqlite.c:137: error: âSQLITE_OPEN_READWRITEâ undeclared (first use in this function)
db-sqlite.c:137: error: (Each undeclared identifier is reported only once
db-sqlite.c:137: error: for each function it appears in.)
make[1]: *** [db-sqlite.o] Error 1


These do not work:
install sqlite
install sqlite-devel
use --no-sqlite  in configure



What do I need to do?
* Viceroy scratches head
Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 22, 2011, 09:50:46 PM
 #304

so I get to the next error (HURRAY)

./configure -without-sqlite3 --prefix=/home/pushpool/ && make  

and on to the well known htole error

/home/pushpool/pushpool-0.5.1/msg.c:562: undefined reference to `htole32'

and I modify server.h adding the lines:


/*
 * fix from http://returnederror.com/tag/htole32/
 */

// Compatibility with glibc < 2.9
#if !defined(htole32) && !defined(le32toh)
#  include <byteswap.h>
#  define htole32(x)  (bswap_32(htonl(x)))
#  define le32toh(x)  (ntohl(bswap_32(x)))
#endif

/*
 * end fix from http://returnederror.com/tag/htole32/
 */


and I recompile


./configure --prefix=/home/pushpool/ && make
make install
chown pushpool /home/pushpool -R; cd /home/pushpool


and what do you know....

presto....

I gotz me a pushpoold


YEEEEEFRCKINHAWWWW
* Viceroy does a jig

I got me an error:


./pushpoold: error while loading shared libraries: libjansson.so.4: cannot open shared object file: No such file or directory


hmm... no source for info on this one yet...
* Viceroy heads to google
Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 22, 2011, 09:51:34 PM
 #305

I'll be nice to you! I've been looking for solutions 2 days..
The Jansson Error:
1) First change directories to /usr/local/lib
Code:
cd /usr/local/lib
2) check if the libjansson.so.4 file is there.
Code:
ls
3) if it's in there do the following commands:
Code:
ln -s /usr/local/lib/libjansson.so.4 /usr/lib/libjansson.so.4
4) Make sure you reload the libraries
Code:
ldconfig

Ahhhh,


Thank you.  Would you look at that, a couple of newbies got the job done when the more experienced non-noobs can't seem too.


Thanks Flowz!
Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 22, 2011, 09:54:19 PM
 #306

So I'm almost there...


bitcoin.conf:
http://pastebin.com/GfT0hbvp


bitcoind works fine using
user: test
pw: x
port: 8332


server.json:
http://pastebin.com/2jhCSqgF

./pushpoold -E -F --foreground --debug=2 --stderr --config=server.json

shows:

[2011-07-22 22:02:18.875301] Debug output enabled
[2011-07-22 22:02:18.875663] Forcing local hostname to localhost.localdomain
[2011-07-22 22:02:18.878457] Listening on host :: port 8342
[2011-07-22 22:02:18.878590] Listening on host :: port 8341
[2011-07-22 22:02:18.878652] Listening on host :: port 8344
[2011-07-22 22:02:18.878707] Listening on host 127.0.0.1 port 8338

I DO NOT get an "initialized"

And am unable to connect to any port other than 8332

All ports open in firewall.
Server is local at 192.168.3.52
mysql set up and working
workers installed in table mydatabase.pool_worker

Thoughts?


Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 22, 2011, 10:22:45 PM
 #307

please also see this post:

http://forum.bitcoin.org/index.php?topic=31007.0


Flowz is still stuck in noobiehell
Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
July 22, 2011, 11:10:15 PM
 #308

So I'm almost there...


bitcoin.conf:
http://pastebin.com/GfT0hbvp


bitcoind works fine using
user: test
pw: x
port: 8332


server.json:
http://pastebin.com/2jhCSqgF

./pushpoold -E -F --foreground --debug=2 --stderr --config=server.json

shows:

[2011-07-22 22:02:18.875301] Debug output enabled
[2011-07-22 22:02:18.875663] Forcing local hostname to localhost.localdomain
[2011-07-22 22:02:18.878457] Listening on host :: port 8342
[2011-07-22 22:02:18.878590] Listening on host :: port 8341
[2011-07-22 22:02:18.878652] Listening on host :: port 8344
[2011-07-22 22:02:18.878707] Listening on host 127.0.0.1 port 8338

I DO NOT get an "initialized"

And am unable to connect to any port other than 8332

All ports open in firewall.
Server is local at 192.168.3.52
mysql set up and working
workers installed in table mydatabase.pool_worker

Thoughts?





Quote
    "rpc.url" : "http://127.0.0.1:8333/",
        "rpc.user" : "test",
        "rpc.pass" : "x",

Looks like pushpool is connecting to bitcoin protocal port # 8333 instead of the one you supplied in your post which is 8332 please make them match, and let us know your results
Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 22, 2011, 11:13:54 PM
 #309

doesn't seem to make any difference.  

i still don't see any 'initialized'

nor can I mine on any of the ports (8333,8338,8341,8342,8344)
Xenland
Legendary
*
Offline Offline

Activity: 980


I'm not just any shaman, I'm a Sha256man


View Profile
July 23, 2011, 12:10:12 AM
 #310

doesn't seem to make any difference.  

i still don't see any 'initialized'

nor can I mine on any of the ports (8333,8338,8341,8342,8344)


I see, This might sound dumb but for some reason the bitcoin.conf file that you have I believe comes with the bitcoin download, that NEVER works for me i just do a simple 4 line config.
Make sure all files have the correct read permissions. This includes any log files that pushpoold uses in the /tmp/ folder, aswell as the bitcoin.config and server.json files.

Example Simple bitcoin.conf
Code:
rpcuser=someusername
rpcpassword=somereallylongrandompassword
rpcallowip=127.0.0.1
rpcport=8362

Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 23, 2011, 12:44:56 AM
 #311

it makes sense to test with a simpler config file.

simpler config file still not getting the 'initialized' statement
still unable to mine with pushpoold
able to mine just fine with bitcoind on 8332 with rpc user and pw


your notes are confusing you say not to use 8332 in the config file:

Quote
# RPC settings | Notice how this ISN'T port number 8332 this is becuase the same port number should not becuase inconjunction with the JSON RPC port other wise you'll get 500 errors

 but then, two posts back, you said I *should* use 8332.


my current bitcoin.conf:

rpcuser=test
rpcpassword=x
rpcallowip=*
rpcport=8332


what port is my miner supposed to mine on when it attaches to pushpool?

Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 23, 2011, 02:46:59 PM
 #312

ok, new day, let's start again.



bitcoind:
seems to be working as expected.
can connect and start mining@   192.168.2.52:8332

bitcoin.conf file is ultra simple:
rpcuser=test
rpcpassword=x
rpcallowip=*
rpcport=8332
server=1

so I must put that user name and machine ip addy in my server.json file.

server.json:

        "rpc.url" : "http://192.168.2.52:8332/",
        "rpc.user" : "test",
        "rpc.pass" : "x",

yep it's in there.

running....
./pushpoold -E -F --debug=2

output:
[2011-07-23 14:46:28.854801] Debug output enabled
[2011-07-23 14:46:28.855140] Forcing local hostname to localhost.localdomain
[2011-07-23 14:46:28.858717] Listening on host :: port 8342
[2011-07-23 14:46:28.858843] Listening on host :: port 8341
[2011-07-23 14:46:28.858913] Listening on host :: port 8344
[2011-07-23 14:46:28.858958] Listening on host 127.0.0.1 port 8338


damnit, no initialized.


doesn't seem there is anything actually listening, other than bitcoin:

netstat -p -l | grep bit
tcp        0      0 *:8332                      *:*                         LISTEN      3333/bitcoind
tcp        0      0 *:8333                      *:*                         LISTEN      3333/bitcoind

netstat -p -l | grep push
(no output)

netstat -p -l | grep pool
(no output)


in /tmp we have:
/tmp/request.log 
/tmp/shares.log

both 0 length

no pid file in temp directory

no activity in mysqld.log

tail -4 /var/log/mysqld.log
110722 18:03:37  mysqld started
110722 18:03:38  InnoDB: Started; log sequence number 0 43665
110722 18:03:38 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

(mysql been up 14 hours)
Flowz
Member
**
Offline Offline

Activity: 114


Bitcoin = Money for the people, by the people.


View Profile
July 23, 2011, 04:13:35 PM
 #313

ok, new day, let's start again.



bitcoind:
seems to be working as expected.
can connect and start mining@   192.168.2.52:8332

bitcoin.conf file is ultra simple:
rpcuser=test
rpcpassword=x
rpcallowip=*
rpcport=8332
server=1

so I must put that user name and machine ip addy in my server.json file.

server.json:

        "rpc.url" : "http://192.168.2.52:8332/",
        "rpc.user" : "test",
        "rpc.pass" : "x",

yep it's in there.

running....
./pushpoold -E -F --debug=2

output:
[2011-07-23 14:46:28.854801] Debug output enabled
[2011-07-23 14:46:28.855140] Forcing local hostname to localhost.localdomain
[2011-07-23 14:46:28.858717] Listening on host :: port 8342
[2011-07-23 14:46:28.858843] Listening on host :: port 8341
[2011-07-23 14:46:28.858913] Listening on host :: port 8344
[2011-07-23 14:46:28.858958] Listening on host 127.0.0.1 port 8338


damnit, no initialized.


doesn't seem there is anything actually listening, other than bitcoin:

netstat -p -l | grep bit
tcp        0      0 *:8332                      *:*                         LISTEN      3333/bitcoind
tcp        0      0 *:8333                      *:*                         LISTEN      3333/bitcoind

netstat -p -l | grep push
(no output)

netstat -p -l | grep pool
(no output)


in /tmp we have:
/tmp/request.log 
/tmp/shares.log

both 0 length

no pid file in temp directory

no activity in mysqld.log

tail -4 /var/log/mysqld.log
110722 18:03:37  mysqld started
110722 18:03:38  InnoDB: Started; log sequence number 0 43665
110722 18:03:38 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

(mysql been up 14 hours)

Try doing the following..
First of all, use more 127.0.0.1 since it's all running on the same machine. Second of all use a other port for bitcoind. 8362 for example Wink
server.json:
Code:
        "rpc.url" : "http://127.0.0.1:8362/",
        "rpc.user" : "test",
        "rpc.pass" : "x",
bitcoind is running on the same machine as pushpoold is running, 192.168.2 could work too but 127.0.0.1 is fine!

bitcoin.conf:
Code:
rpcuser=test
rpcpassword=x
rpcallowip=127.0.0.1
rpcport=8362

Only the server needs to acces the wallet, so leave that localhost/127.0.0.1.

 
Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 23, 2011, 04:43:39 PM
 #314

no difference.

still no "initialized"
and not able to mine

what port should I be able to mine on from pushpoold?

doesn't this all put out text output?
can't I just telnet to these ports and read the stream?
(I don't seem able to telnet to these ports).


Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 23, 2011, 04:46:39 PM
 #315

Only the server needs to acces the wallet, so leave that localhost/127.0.0.1.

What wallet?  this was compiled without the wallet flag or keystore.

Flowz
Member
**
Offline Offline

Activity: 114


Bitcoin = Money for the people, by the people.


View Profile
July 23, 2011, 04:56:36 PM
 #316

no difference.

still no "initialized"
and not able to mine

what port should I be able to mine on from pushpoold?

doesn't this all put out text output?
can't I just telnet to these ports and read the stream?
(I don't seem able to telnet to these ports).
Hmm Sad Maybe re-check the MySQL settings?
Ofcourse telnet won't work. pushpoold isn't running.
Flowz
Member
**
Offline Offline

Activity: 114


Bitcoin = Money for the people, by the people.


View Profile
July 23, 2011, 04:57:51 PM
 #317

Only the server needs to acces the wallet, so leave that localhost/127.0.0.1.

What wallet?  this was compiled without the wallet flag or keystore.


Sorry! I ment that it was the only one who needs to acces bitcoind.
Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 23, 2011, 06:05:47 PM
 #318

Quote
Hmm Sad Maybe re-check the MySQL settings?
Ofcourse telnet won't work. pushpoold isn't running.


yea, I changed is a little, still no "initialized"

how are you calling your database name?

I don't see an option to name the database, just the table... so I'm assuming I should use:
                "name" : "`btcWorkers`.`shares`",

Where btcWorkers is the "database" and shares is the "table".

what port are you mining on?

what do you see with
netstat -p -l

Flowz
Member
**
Offline Offline

Activity: 114


Bitcoin = Money for the people, by the people.


View Profile
July 23, 2011, 06:46:31 PM
 #319

Quote
Hmm Sad Maybe re-check the MySQL settings?
Ofcourse telnet won't work. pushpoold isn't running.


yea, I changed is a little, still no "initialized"

how are you calling your database name?

I don't see an option to name the database, just the table... so I'm assuming I should use:
                "name" : "`btcWorkers`.`shares`",

Where btcWorkers is the "database" and shares is the "table".

what port are you mining on?

what do you see with
netstat -p -l

1. I'm using a remote host, mine is called: themalwa_pushpool. My advantage: I got phpMyAdmin then Wink

2. I don't know what you mean.. In what file?

3. 8344

4.
Code:

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name
tcp        0      0 *:6665                      *:*                         LISTEN      5954/ircd
tcp        0      0 *:mysql                     *:*                         LISTEN      27772/mysqld
tcp        0      0 *:8362                      *:*                         LISTEN      13611/bitcoind
tcp        0      0 *:6666                      *:*                         LISTEN      5954/ircd
tcp        0      0 *:ircd                      *:*                         LISTEN      5954/ircd
tcp        0      0 *:6668                      *:*                         LISTEN      5954/ircd
tcp        0      0 *:8333                      *:*                         LISTEN      13611/bitcoind
tcp        0      0 *:6669                      *:*                         LISTEN      5954/ircd
tcp        0      0 localhost.localdomain:8338  *:*                         LISTEN      25659/pushpoold
tcp        0      0 localhost.localdomain:smtp  *:*                         LISTEN      11483/sendmail: acc
tcp        0      0 *:http                      *:*                         LISTEN      3880/httpd
tcp        0      0 *:8342                      *:*                         LISTEN      25659/pushpoold
tcp        0      0 *:ssh                       *:*                         LISTEN      11337/sshd
tcp        0      0 *:8344                      *:*                         LISTEN      25659/pushpoold
tcp        0      0 *:8347                      *:*                         LISTEN      25659/pushpoold
raw        0      0 *:icmp                      *:*                         7           -
Active UNIX domain sockets (only servers)
Proto RefCnt Flags       Type       State         I-Node PID/Program name    Path
unix  2      [ ACC ]     STREAM     LISTENING     381087114 9509/brcm_iscsiuio  @ISCSID_UIP_ABSTRACT_NAMESPACE
unix  2      [ ACC ]     STREAM     LISTENING     381087587 11648/saslauthd     /var/run/saslauthd/mux
unix  2      [ ACC ]     STREAM     LISTENING     393123351 27772/mysqld        /var/lib/mysql/mysql.sock
Viceroy
Hero Member
*****
Offline Offline

Activity: 616


View Profile
July 23, 2011, 09:04:42 PM
 #320

hmmm.
* Viceroy scratches head


I like seeing those listeners in your netstat.  They definitely don't appear in mine.

The line I pulled was in server.json

        # database settings
        "database" : {
                "engine" : "mysql",
                "host" : "localhost",
                "port" : 3306,
                "name" : "`btcWorkers`.`shares`",
                "username" : "remoteusername",
                "password" : "remoteuserpasswd",
                "sharelog" : true,
                "stmt.pwdb":"SELECT `password` FROM `btcWorkers`.`pool_worker` WHERE username = ?",
                "stmt.sharelog":"INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?)"

        },

what does your working "name" line look like?
what about the "stmt.pwdb", is it like mine?

Anyone know if there is another variable to set database name?  or is this format correct?


Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 [16] 17 18 19 20 21 22 23 24 25 26 27 28 29 30 »
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!