Bitcoin Forum
December 06, 2016, 06:09:57 PM *
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 »  All
  Print  
Author Topic: pushpool - open source pool software  (Read 114761 times)
nzbtc
Jr. Member
*
Offline Offline

Activity: 40


View Profile
May 26, 2011, 10:06:55 AM
 #81

Ive had ago at installing this in ubuntu 10.04 on my vps. Can't get it to install libmemcached.

Would be very nice with a decent install guide! (I would write one if I got it install and working..)
Or can anyone elaborate on how they managed to install it?

13EXX23oQX7CA1qLrM2EDemnYNZDdmngsS
1481047797
Hero Member
*
Offline Offline

Posts: 1481047797

View Profile Personal Message (Offline)

Ignore
1481047797
Reply with quote  #2

1481047797
Report to moderator
1481047797
Hero Member
*
Offline Offline

Posts: 1481047797

View Profile Personal Message (Offline)

Ignore
1481047797
Reply with quote  #2

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

Activity: 980


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


View Profile
May 26, 2011, 04:02:31 PM
 #82

After 18hours of attempting to get pushpool working ive ran into just about everyproblem. Ill be writing an install guide right after i finish the front end interface for pushpool.

Any one know why when i enable sharelog:true, that it would send the shares as questions marks.

Heres mysql query: "stmt.sharelog":"INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?)"
nzbtc
Jr. Member
*
Offline Offline

Activity: 40


View Profile
May 26, 2011, 06:36:09 PM
 #83

After 18hours of attempting to get pushpool working ive ran into just about everyproblem. Ill be writing an install guide right after i finish the front end interface for pushpool.

Any one know why when i enable sharelog:true, that it would send the shares as questions marks.

Heres mysql query: "stmt.sharelog":"INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?, ?, ?, ?)"


Perfection! Can't wait!

13EXX23oQX7CA1qLrM2EDemnYNZDdmngsS
redshark1802
Jr. Member
*
Offline Offline

Activity: 44


View Profile
May 26, 2011, 08:46:05 PM
 #84

Hello,


i get the following error when running ./configure:"
./configure: line 5431: syntax error near unexpected token `,'
./configure: line 5431: `LIBCURL_CHECK_CONFIG(, 7.10.1, ,'
"

I have libcurl installed but I'm stuck for about 3hrs now -.-.
please could someone help me.



If the post above is something worth to you, please consider donating Wink.
1HYek9jXvbMDYyYwN7rxy9i3oDWgCYhATx
oVPN
Jr. Member
*
Offline Offline

Activity: 56


View Profile WWW
May 26, 2011, 08:53:38 PM
 #85

....
I have libcurl installed but I'm stuck for about 3hrs now -.-.
please could someone help me.

whats your OS?

oVPN.to Anonymous Services
xf2_org
Member
**
Offline Offline

Activity: 70


View Profile
May 26, 2011, 08:54:45 PM
 #86

i get the following error when running ./configure:"
./configure: line 5431: syntax error near unexpected token `,'
./configure: line 5431: `LIBCURL_CHECK_CONFIG(, 7.10.1, ,'
"

You built the configure script incorrectly.

Do not use the git repo, that's for experts.  Download and run the tarball (see first post).

redshark1802
Jr. Member
*
Offline Offline

Activity: 44


View Profile
May 26, 2011, 09:01:52 PM
 #87

It actually was the tarball dude.
I have solved it. I reinstalled all libcurl stuff and installed i via source.

If the post above is something worth to you, please consider donating Wink.
1HYek9jXvbMDYyYwN7rxy9i3oDWgCYhATx
dds
Newbie
*
Offline Offline

Activity: 7



View Profile
June 01, 2011, 06:10:37 AM
 #88

Could anyone tell how to configure pushpool long-polling with poclbm miner?
Looks like it doesn't work. Miner reports "long poll exception" and "invalid or stale" shares from time to time.
I have "longpoll.disable" : false in pushpool config.
Xenland
Legendary
*
Offline Offline

Activity: 980


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


View Profile
June 01, 2011, 07:05:42 AM
 #89

Could anyone tell how to configure pushpool long-polling with poclbm miner?
Looks like it doesn't work. Miner reports "long poll exception" and "invalid or stale" shares from time to time.
I have "longpoll.disable" : false in pushpool config.

Well in my experience I'm using poclbm and i rarely get invalid and i think i got long pool exception
dds
Newbie
*
Offline Offline

Activity: 7



View Profile
June 01, 2011, 09:03:22 AM
 #90

Well in my experience I'm using poclbm and i rarely get invalid and i think i got long pool exception
What exactly rarely mean?  Smiley
I have about 4% of stale shares in my pushpool DB.
btw, how many MH/s do you have on your pushpool instance?
Xenland
Legendary
*
Offline Offline

Activity: 980


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


View Profile
June 01, 2011, 09:50:06 AM
 #91

Well in my experience I'm using poclbm and i rarely get invalid and i think i got long pool exception
What exactly rarely mean?  Smiley
I have about 4% of stale shares in my pushpool DB.
btw, how many MH/s do you have on your pushpool instance?

Rarly as in probubly around 1 in 100 shares, 4% dosent sound bad or alarming but maybe your packets are being dropped by a firewall. I get about the same MH/s as i do with other pools which is 85-90 range.
davout
Legendary
*
Offline Offline

Activity: 1358


1davout


View Profile WWW
June 01, 2011, 01:17:59 PM
 #92

Could anyone tell how to configure pushpool long-polling with poclbm miner?
Looks like it doesn't work. Miner reports "long poll exception" and "invalid or stale" shares from time to time.
I have "longpoll.disable" : false in pushpool config.
From my understanding you'd need to active blkmon so it monitors new blocks.
It should then send SIGUSR1 to the pushpoold to notify it

Xenland
Legendary
*
Offline Offline

Activity: 980


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


View Profile
June 02, 2011, 12:22:03 AM
 #93

Could anyone tell how to configure pushpool long-polling with poclbm miner?
Looks like it doesn't work. Miner reports "long poll exception" and "invalid or stale" shares from time to time.
I have "longpoll.disable" : false in pushpool config.
From my understanding you'd need to active blkmon so it monitors new blocks.
It should then send SIGUSR1 to the pushpoold to notify it

Dude, Is that what that does? I could never get it started.... but Im having a bit of an issue geting pushpoold started on my VPS it reports that its listening on 127.0.0.1 but it shuts down immediately right after it reports this any solutions?
davout
Legendary
*
Offline Offline

Activity: 1358


1davout


View Profile WWW
June 02, 2011, 06:27:54 AM
 #94

Could anyone tell how to configure pushpool long-polling with poclbm miner?
Looks like it doesn't work. Miner reports "long poll exception" and "invalid or stale" shares from time to time.
I have "longpoll.disable" : false in pushpool config.
From my understanding you'd need to active blkmon so it monitors new blocks.
It should then send SIGUSR1 to the pushpoold to notify it

Dude, Is that what that does? I could never get it started.... but Im having a bit of an issue geting pushpoold started on my VPS it reports that its listening on 127.0.0.1 but it shuts down immediately right after it reports this any solutions?
Yes, you need it only for long polling tho

turlando
Newbie
*
Offline Offline

Activity: 11



View Profile
June 02, 2011, 09:23:54 AM
 #95

Hello,
I'm a newbie here and this is my first post.

I'm trying to set up a pushpool server using PostgreSQL as SQL server but I have some troubles: I compiled the daemon, I modified the configuration file in order to use postgresql and I adapted the mysql query that I found here for pgsql, but when I try to connect to the server, the daemon prints out this error:
Code:
[1307005729.968275] pg_pwdb_lookup query failed: ERROR:  syntax error at end of input
LINE 1: SELECT password FROM pool_worker WHERE username = ?

In PostgreSQL the object of the WHERE clause have to be in quotes, as you can see:
Code:
pushpool=# SELECT password FROM pool_worker WHERE username = test;
ERROR:  column "test" does not exist
LINE 1: SELECT password FROM pool_worker WHERE username = test;
                                                          ^
pushpool=# SELECT password FROM pool_worker WHERE username = 'test';
             password            
----------------------------------
      /* password in md5 */
(1 row)

So I modified the configuration file to:
Code:
"stmt.pwdb" : "SELECT password FROM pool_worker WHERE username = '?'",
but I get:
Code:
[1307006155.225905] pg_pwdb_lookup query failed: ERROR:  bind message supplies 1 parameters, but prepared statement "" requires 0

I'm doing wrong something or is a bug?

Sorry for my very bad English.
Tancredi.

«The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at or repair.» --Douglas Adams about ZFS
kjj
Legendary
*
Offline Offline

Activity: 1302



View Profile
June 02, 2011, 10:40:05 AM
 #96

The syntax is different.  Try this (lifted straight out of db-postgresql.c):

Code:
"SELECT password FROM pool_worker WHERE username = $1"

p2pcoin: a USB/CD/PXE p2pool miner - 1N8ZXx2cuMzqBYSK72X4DAy1UdDbZQNPLf - todo
I routinely ignore posters with paid advertising in their sigs.  You should too.
Jine
Sr. Member
****
Offline Offline

Activity: 405


View Profile
June 02, 2011, 10:59:27 AM
 #97

Take a loot at my fork of pushpoold.
Which includes a much better configuration file, with examples.

(For postgres to)

https://github.com/jine/pushpool

Previous founder of Bit LC Inc. | I've always loved the idea of bitcoin.
turlando
Newbie
*
Offline Offline

Activity: 11



View Profile
June 02, 2011, 01:48:28 PM
 #98

Right, I compiled jine-pushpool; it connects to the PostgreSQL server, but now I get these errors:
on the client ↓
Code:
% ./minerd --url http://192.168.1.99:8337/ --user test --pass test
[2011-06-02 14:35:18] HTTP request failed: The requested URL returned error: 403
[2011-06-02 14:35:18] json_rpc_call failed, retry after 30 seconds
on the server ↓
Code:
% ./pushpoold -E -D 2 --config=config.json
[1307021446.964664] Debug output enabled
[1307021446.977801] Listening on host :: port 8336
[1307021446.978053] Listening on host :: port 8337
[1307021446.978140] Listening on host 127.0.0.1 port 8338
[1307021447.003793] initialized
[1307021594.453532] client host ::ffff:192.168.1.210 port 45973 connected
[1307021594.453781] client ::ffff:192.168.1.210 ended

This is the configuration file:
Code:
% cat config.json
{
# network ports
"listen" : [
# binary protocol (default), port 8336
{ "port" : 8336 },

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

# HTTP JSON-RPC protocol, port 8339,
# with trusted proxy appserver.example.com forwarding
# requests to us
#
# comment out if not using multiple servers
#{ "port" : 8337, "protocol" : "http-json",
#  "proxy" : "appserver.example.com" },

# binary protocol, localhost-only port 8338
{ "host" : "127.0.0.1", "port" : 8338, "protocol" : "binary" }
],

# database settings
"database" : {

##
# select one database engine and remove the other ones.
##

# "engine" : "sqlite3",
# "name" : "/tmp/data.sqlite",

# set to true to enable logging of shares to db
# "sharelog" : true,

# edit queries to match your database structure if necessary
# "stmt.pwdb" :
#  "SELECT password FROM pool_worker WHERE username = ?",

        #        "stmt.sharelog" :
        #          "INSERT INTO shares (time, rem_host, username, our_result, upstream_result, reason, solution) VALUES (?,?,?,?,?,?,?)"

# ... or ...

# "engine" : "mysql",

# 'host' defaults to localhost, if not specified
# "host" : "mysql.example.com",

# 'port' uses proper default port for the DB engine,
# if not specified
# "port" : 3306,

# "name" : "mydatabasename",
# "username" : "myuser",
# "password" : "mypass",

# set to true to enable logging of shares to db
# "sharelog" : true,

# edit queries to match your database structure if necessary
# "stmt.pwdb" :
#  "SELECT password FROM pool_worker WHERE username = ?",

        #       "stmt.sharelog" :
        #          "INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?,?,?,?,?,?)"


# ... or ...

"engine" : "postgresql",

"host" : "127.0.0.1",

"port" : 5432,

"name" : "dbname",
"username" : "dbusername",
"password" : "dbpassword",

# set to true to enable logging of shares to db
"sharelog" : true,

# edit queries to match your database structure if necessary
"stmt.pwdb" :
 "SELECT password FROM pool_worker WHERE username = $1",

                "stmt.sharelog" :
                  "INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES ($1, $2, $3, $4, $5, decode($6, 'hex'))"

},

# cache settings
# comment out to disable memcache - NOT RECOMMENDED
"memcached" : {
"servers" : [
{ "host" : "127.0.0.1", "port" : 11211 }
]
},

"pid" : "/tmp/pushpoold.pid",

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

# logfiles for requests and shares
"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 to bitcoind upstream server (same as bitcoin.conf if using original client)
"rpc.url" : "http://127.0.0.1:8332/",
"rpc.user" : "username",
"rpc.pass" : "password",

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

«The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at or repair.» --Douglas Adams about ZFS
Jine
Sr. Member
****
Offline Offline

Activity: 405


View Profile
June 02, 2011, 02:15:37 PM
 #99

Have you changed the dbname/dbuser/dbpass vars in your own config?
And also, is your table actually named pool_worker and has at least to fields - username & password?

Aka. check your config, that it actually can read those tables & try again.

My version isn't any diffrent from the original, only better config & commenting.

Previous founder of Bit LC Inc. | I've always loved the idea of bitcoin.
turlando
Newbie
*
Offline Offline

Activity: 11



View Profile
June 02, 2011, 02:22:07 PM
 #100

Have you changed the dbname/dbuser/dbpass vars in your own config?
Obviously.

And also, is your table actually named pool_worker and has at least to fields - username & password?
Yes.

The password have to be in plain text, isn't it?
Would you like a database dump?

P.S.: Thanks for the support Smiley

«The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at or repair.» --Douglas Adams about ZFS
Pages: « 1 2 3 4 [5] 6 7 8 9 10 11 12 »  All
  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!