Bitcoin Forum
December 05, 2016, 10:45:11 AM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   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 126697 times)
Xenland
Legendary
*
Offline Offline

Activity: 980


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


View Profile
July 08, 2011, 12:09:27 PM
 #281

If you are not doing anything with the .log files from mining farm and it has been used by a few pools now in actual production, I would assume that pushpool deals with them directly otherwise people's servers would probably be getting overloaded with them by now, or soon.

But why then would jgarzik mention how to "re-open the logs (such as after rotation or deletion)." if pushpool dealt with them directly?!

You must rotate/trim the logs yourself.

The logrotate package can help you with that.



To gigabytecoin, Miningfarm dosn't use log files becuase of the extra steps it would take to parse them. It does a series of checks and balances

Thanks jgarzik for that insight full info btw
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
jgarzik
Legendary
*
Offline Offline

Activity: 1470


View Profile
July 08, 2011, 11:33:40 PM
 #282

I would consider this a bug. pushpoold should already know the target difficulty, so why can't it do a correct check? Also, doing a proper check would reduce the network activity between pushpoold and bitcoind slightly (it would submit less false Proof of Works to bitcoind).

Patches welcome...


Jeff Garzik, bitcoin core dev team and BitPay engineer; opinions are my own, not my employer.
Donations / tip jar: 1BrufViLKnSWtuWGkryPsKsxonV2NQ7Tcj
smoothie
Legendary
*
Offline Offline

Activity: 1834


LEALANA Monero Physical Silver Coins


View Profile
July 10, 2011, 04:13:22 AM
 #283

When compiling pushpool on ubuntu 11 I get a database.engine error message and then it quits compilation.

I have tried multiple database setups and I still get the same error. Any help please?

Thanks

███████████████████████████████████████

            ,╓p@@███████@╗╖,           
        ,p████████████████████N,       
      d█████████████████████████b     
    d██████████████████████████████æ   
  ,████²█████████████████████████████, 
 ,█████  ╙████████████████████╨  █████y
 ██████    `████████████████`    ██████
║██████       Ñ███████████`      ███████
███████         ╩██████Ñ         ███████
███████    ▐▄     ²██╩     a▌    ███████
╢██████    ▐▓█▄          ▄█▓▌    ███████
 ██████    ▐▓▓▓▓▌,     ▄█▓▓▓▌    ██████─
           ▐▓▓▓▓▓▓█,,▄▓▓▓▓▓▓▌          
           ▐▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▌          
    ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓─  
     ²▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓╩    
        ▀▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▀       
           ²▀▀▓▓▓▓▓▓▓▓▓▓▓▓▀▀`          
                   ²²²                 
███████████████████████████████████████

. ★☆ WWW.LEALANA.COM        My PGP fingerprint is A764D833.        SMOOTHIE'S HEALTH AND FITNESS JOURNAL          History of Monero development Visualization ★☆ .
LEALANA  PHYSICAL MONERO COINS 999 FINE SILVER.
 
d3c0n808
Member
**
Offline Offline

Activity: 113

Not Goxed


View Profile
July 10, 2011, 06:20:12 AM
 #284

you need to install i believe its called mysql dev....   then reconfigure.  If you dont have the mysql dev package it wont work

60 GH/s BFL Single SC - Pre-Order Yours Today!
`````` Only $1299.99 - butterflylabs.com ``````
Xenland
Legendary
*
Offline Offline

Activity: 980


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


View Profile
July 10, 2011, 08:32:29 AM
 #285

When compiling pushpool on ubuntu 11 I get a database.engine error message and then it quits compilation.

I have tried multiple database setups and I still get the same error. Any help please?

Thanks


Read the most recent updated Pushpoold tutorial for 5.1 over at the original post it describes how to install MySql package
LivTru
Newbie
*
Offline Offline

Activity: 24


View Profile
July 10, 2011, 06:03:08 PM
 #286

I am getting an error "[2011-07-10 18:00:35.988488] mysql sharelog failed at execute".

Any suggestions?

Here's what my table looks like:

Code:
DROP TABLE IF EXISTS `btcserver`.`shares`;
CREATE TABLE  `btcserver`.`shares` (
  `id` bigint(30) NOT NULL AUTO_INCREMENT,
  `time` int(255) NOT NULL,
  `rem_host` varchar(255) NOT NULL,
  `username` varchar(120) NOT NULL,
  `our_result` enum('Y','N') NOT NULL,
  `upstream_result` enum('Y','N') DEFAULT NULL,
  `reason` varchar(50) DEFAULT NULL,
  `solution` varchar(257) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
Xenland
Legendary
*
Offline Offline

Activity: 980


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


View Profile
July 11, 2011, 02:30:30 AM
 #287

I am getting an error "[2011-07-10 18:00:35.988488] mysql sharelog failed at execute".

Any suggestions?

Here's what my table looks like:

Code:
DROP TABLE IF EXISTS `btcserver`.`shares`;
CREATE TABLE  `btcserver`.`shares` (
  `id` bigint(30) NOT NULL AUTO_INCREMENT,
  `time` int(255) NOT NULL,
  `rem_host` varchar(255) NOT NULL,
  `username` varchar(120) NOT NULL,
  `our_result` enum('Y','N') NOT NULL,
  `upstream_result` enum('Y','N') DEFAULT NULL,
  `reason` varchar(50) DEFAULT NULL,
  `solution` varchar(257) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Post your json file(with out RPC credientials or MYSQL username or password) sounds like an easy fix.
LivTru
Newbie
*
Offline Offline

Activity: 24


View Profile
July 11, 2011, 05:16:11 AM
 #288

I am getting an error "[2011-07-10 18:00:35.988488] mysql sharelog failed at execute".

Any suggestions?

Here's what my table looks like:

Code:
DROP TABLE IF EXISTS `btcserver`.`shares`;
CREATE TABLE  `btcserver`.`shares` (
  `id` bigint(30) NOT NULL AUTO_INCREMENT,
  `time` int(255) NOT NULL,
  `rem_host` varchar(255) NOT NULL,
  `username` varchar(120) NOT NULL,
  `our_result` enum('Y','N') NOT NULL,
  `upstream_result` enum('Y','N') DEFAULT NULL,
  `reason` varchar(50) DEFAULT NULL,
  `solution` varchar(257) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Post your json file(with out RPC credientials or MYSQL username or password) sounds like an easy fix.


json:


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

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

      # HTTP JSON-RPC protocol, port 8344,
      #proxy is most likely your external ip address if your running a public p...
      # requests to us | "proxy" should be set to your ip address that people w...
      { "port" : 8344, "protocol" : "http-json", "proxy" : "192.168.XXX.XXX" },
      # 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" : "192.168.XXX.XXX",
      "port" : 3306,
      #database name
      "name" : "XXX",
      #database username
      "username" : "XXX",
      #database password
      "password" : "XXX",
      #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...
   # cache settings
   #"memcached" : {
   #   "servers" : [
  #   "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" : "XXX",
   "rpc.pass" : "XXX",

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


Xenland
Legendary
*
Offline Offline

Activity: 980


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


View Profile
July 11, 2011, 05:53:58 AM
 #289

I am getting an error "[2011-07-10 18:00:35.988488] mysql sharelog failed at execute".

Any suggestions?

Here's what my table looks like:

Code:
DROP TABLE IF EXISTS `btcserver`.`shares`;
CREATE TABLE  `btcserver`.`shares` (
  `id` bigint(30) NOT NULL AUTO_INCREMENT,
  `time` int(255) NOT NULL,
  `rem_host` varchar(255) NOT NULL,
  `username` varchar(120) NOT NULL,
  `our_result` enum('Y','N') NOT NULL,
  `upstream_result` enum('Y','N') DEFAULT NULL,
  `reason` varchar(50) DEFAULT NULL,
  `solution` varchar(257) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Post your json file(with out RPC credientials or MYSQL username or password) sounds like an easy fix.


json:


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

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

      # HTTP JSON-RPC protocol, port 8344,
      #proxy is most likely your external ip address if your running a public p...
      # requests to us | "proxy" should be set to your ip address that people w...
      { "port" : 8344, "protocol" : "http-json", "proxy" : "192.168.XXX.XXX" },
      # 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" : "192.168.XXX.XXX",
      "port" : 3306,
      #database name
      "name" : "XXX",
      #database username
      "username" : "XXX",
      #database password
      "password" : "XXX",
      #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...
   # cache settings
   #"memcached" : {
   #   "servers" : [
  #   "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" : "XXX",
   "rpc.pass" : "XXX",

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

Make sure you applied the appropriate privileges for the selected Mysql user, and let us know if that solved the problem, if not i think i have another idea
LivTru
Newbie
*
Offline Offline

Activity: 24


View Profile
July 11, 2011, 06:08:14 AM
 #290

I am getting an error "[2011-07-10 18:00:35.988488] mysql sharelog failed at execute".

Any suggestions?

Here's what my table looks like:

Code:
DROP TABLE IF EXISTS `btcserver`.`shares`;
CREATE TABLE  `btcserver`.`shares` (
  `id` bigint(30) NOT NULL AUTO_INCREMENT,
  `time` int(255) NOT NULL,
  `rem_host` varchar(255) NOT NULL,
  `username` varchar(120) NOT NULL,
  `our_result` enum('Y','N') NOT NULL,
  `upstream_result` enum('Y','N') DEFAULT NULL,
  `reason` varchar(50) DEFAULT NULL,
  `solution` varchar(257) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Post your json file(with out RPC credientials or MYSQL username or password) sounds like an easy fix.


json:


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

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

      # HTTP JSON-RPC protocol, port 8344,
      #proxy is most likely your external ip address if your running a public p...
      # requests to us | "proxy" should be set to your ip address that people w...
      { "port" : 8344, "protocol" : "http-json", "proxy" : "192.168.XXX.XXX" },
      # 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" : "192.168.XXX.XXX",
      "port" : 3306,
      #database name
      "name" : "XXX",
      #database username
      "username" : "XXX",
      #database password
      "password" : "XXX",
      #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...
   # cache settings
   #"memcached" : {
   #   "servers" : [
  #   "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" : "XXX",
   "rpc.pass" : "XXX",

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

Make sure you applied the appropriate privileges for the selected Mysql user, and let us know if that solved the problem, if not i think i have another idea

I gave the db user account full access. What else are you thinking?


dikidera
Full Member
***
Offline Offline

Activity: 126


View Profile
July 11, 2011, 02:43:14 PM
 #291

Unless you are running a VM with mysql in it, or have another computer connected via a router, the host for mysql is localhost. The error comes from this piece of code

Code:
step = "execute";
if (mysql_stmt_execute(stmt))
goto err_out;
Meaning that mysql failed to execute the prepared statement.
ziomik
Legendary
*
Offline Offline

Activity: 1806


http://www.bitcoinmarket.net


View Profile WWW
July 11, 2011, 04:19:19 PM
 #292

Aummm.... my problem...
btcoind and pushpoold config is ok but :

[ 412.571365] bitcoind[1153] general protection ip:b741e160 sp:b572a60c error:0 in libcrypto++.so.8.0.0[b7122000+3b9000]


Code:
[1310401001.856061] Listening on host :: port 8342
[1310401001.856708] Listening on host :: port 8341
[1310401001.857326] Listening on host :: port 8334
[1310401001.857909] Listening on host 127.0.0.1 port 8338
[1310401001.861818] initialized
[ 412.571365] bitcoind[1153] general protection ip:b741e160 sp:b572a60c error:0 in libcrypto++.so.8.0.0[b7122000+3b9000]
[1310401003.264869] HTTP request failed: Empty reply from server
[1310401006.168083] HTTP request failed: couldn't connect to host
^C[1310401009.017170] shutting down

and bitcoind is kill..

Please help...  Undecided Cry

"Se domani senti due massaie che parlano di bitcoin tra di loro dal macellaio, forse e' il momento di vendere.. se pero' le sentirai fra 10 anni forse staranno solo pagando il conto" GBianchi
---- +++ ----
http://www.bitcoinmarket.net
dikidera
Full Member
***
Offline Offline

Activity: 126


View Profile
July 11, 2011, 04:32:40 PM
 #293

Well..this is new, but i am going to speculate and...did you set allowip in bitcoin's bitcoin.conf file?
Add a line in the file with

allowip=127.0.0.1 save and restart bitcoin and try again with pushpoold
ziomik
Legendary
*
Offline Offline

Activity: 1806


http://www.bitcoinmarket.net


View Profile WWW
July 11, 2011, 05:07:40 PM
 #294

Well..this is new, but i am going to speculate and...did you set allowip in bitcoin's bitcoin.conf file?
Add a line in the file with

allowip=127.0.0.1 save and restart bitcoin and try again with pushpoold

problem is not solved yet .. sigh
I installed all the required libraries do not understand ..

"Se domani senti due massaie che parlano di bitcoin tra di loro dal macellaio, forse e' il momento di vendere.. se pero' le sentirai fra 10 anni forse staranno solo pagando il conto" GBianchi
---- +++ ----
http://www.bitcoinmarket.net
ziomik
Legendary
*
Offline Offline

Activity: 1806


http://www.bitcoinmarket.net


View Profile WWW
July 11, 2011, 10:27:21 PM
 #295

Solution is delete  file in .bitcoin folder

but now another problem.
I read the error 500 that you have to wait for 4 hours, but it does not go ...

Code:
* The requested URL returned error: 500
* Closing connection #0
[2011-07-11 22:27:0.347559] HTTP request failed: The requested URL returned error: 500
JSON protocol request:
{"method": "getwork", "params": [], "id":86}

* About to connect() to 127.0.0.1 port 8331 (#0)
*   Trying 127.0.0.1... * TCP_NODELAY set
* connected
* Connected to 127.0.0.1 (127.0.0.1) port 8331 (#0)
* Server auth using Basic with user 'ziomik2'
> POST / HTTP/1.1
Authorization: Basic emlvbWlrMjo4NzM1OTA=
Host: 127.0.0.1:8331
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 46

* The requested URL returned error: 500
* Closing connection #0
[2011-07-11 22:27:0.844513] HTTP request failed: The requested URL returned error: 500
JSON protocol request:
{"method": "getwork", "params": [], "id":87}

* About to connect() to 127.0.0.1 port 8331 (#0)
*   Trying 127.0.0.1... * TCP_NODELAY set
* connected
* Connected to 127.0.0.1 (127.0.0.1) port 8331 (#0)
* Server auth using Basic with user 'ziomik2'
> POST / HTTP/1.1
Authorization: Basic emlvbWlrMjo4NzM1OTA=
Host: 127.0.0.1:8331
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 46

"Se domani senti due massaie che parlano di bitcoin tra di loro dal macellaio, forse e' il momento di vendere.. se pero' le sentirai fra 10 anni forse staranno solo pagando il conto" GBianchi
---- +++ ----
http://www.bitcoinmarket.net
LivTru
Newbie
*
Offline Offline

Activity: 24


View Profile
July 11, 2011, 11:02:15 PM
 #296

I am getting an error "[2011-07-10 18:00:35.988488] mysql sharelog failed at execute".

Any suggestions?

Here's what my table looks like:

Code:
DROP TABLE IF EXISTS `btcserver`.`shares`;
CREATE TABLE  `btcserver`.`shares` (
  `id` bigint(30) NOT NULL AUTO_INCREMENT,
  `time` int(255) NOT NULL,
  `rem_host` varchar(255) NOT NULL,
  `username` varchar(120) NOT NULL,
  `our_result` enum('Y','N') NOT NULL,
  `upstream_result` enum('Y','N') DEFAULT NULL,
  `reason` varchar(50) DEFAULT NULL,
  `solution` varchar(257) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Post your json file(with out RPC credientials or MYSQL username or password) sounds like an easy fix.


json:


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

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

      # HTTP JSON-RPC protocol, port 8344,
      #proxy is most likely your external ip address if your running a public p...
      # requests to us | "proxy" should be set to your ip address that people w...
      { "port" : 8344, "protocol" : "http-json", "proxy" : "192.168.XXX.XXX" },
      # 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" : "192.168.XXX.XXX",
      "port" : 3306,
      #database name
      "name" : "XXX",
      #database username
      "username" : "XXX",
      #database password
      "password" : "XXX",
      #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...
   # cache settings
   #"memcached" : {
   #   "servers" : [
  #   "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" : "XXX",
   "rpc.pass" : "XXX",

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

Make sure you applied the appropriate privileges for the selected Mysql user, and let us know if that solved the problem, if not i think i have another idea

I gave the db user account full access. What else are you thinking?


I am not sure what it was that I changed in the MySQL ini file but things are working now. Or, maybe it was the system reboot? Smiley
TeraPool
Jr. Member
*
Offline Offline

Activity: 42


View Profile
July 12, 2011, 11:39:03 PM
 #297

It's always a system reboot Wink

Wuked
Member
**
Offline Offline

Activity: 112


View Profile WWW
July 13, 2011, 10:53:35 PM
 #298

Just a quick thank you to Xenland for running this thread and helping everyone out.

Ztjuh
Newbie
*
Offline Offline

Activity: 10


View Profile
July 14, 2011, 12:28:43 PM
 #299

Hey there,

My miner doesn't seem to get any work..

Quote
...@...:~/pushpool$ pushpoold --config=./config.json --debug=2 --stderr --foreground
[2011-07-14 01:25:8.018911] Debug output enabled
[2011-07-14 01:25:8.050485] Listening on host :: port 8342
[2011-07-14 01:25:8.050614] Listening on host :: port 8341
[2011-07-14 01:25:8.050678] Listening on host :: port 8344
[2011-07-14 01:25:8.050740] Listening on host 127.0.0.1 port 8338
[2011-07-14 01:25:8.082694] initialized

Connecting my miner.

Quote
JSON protocol request:
{"method": "getwork", "params": [], "id":1}

* About to connect() to 127.0.0.1 port 8333 (#0)
*   Trying 127.0.0.1... * TCP_NODELAY set
* connected
* Connected to 127.0.0.1 (127.0.0.1) port 8333 (#0)
* Server auth using Basic with user 'username'
> POST / HTTP/1.1
Authorization: Basic enRqdWg6dGVzdDEyMw==
Host: 127.0.0.1:8333
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 45

* Empty reply from server
* Connection #0 to host 127.0.0.1 left intact
[2011-07-14 01:27:16.074094] HTTP request failed: Empty reply from server
JSON protocol request:
{"method": "getwork", "params": [], "id":2}

* Connection #0 seems to be dead!
* Closing connection #0
* About to connect() to 127.0.0.1 port 8333 (#0)
*   Trying 127.0.0.1... * TCP_NODELAY set
* connected
* Connected to 127.0.0.1 (127.0.0.1) port 8333 (#0)
* Server auth using Basic with user 'username'
> POST / HTTP/1.1
Authorization: Basic enRqdWg6dGVzdDEyMw==
Host: 127.0.0.1:8333
Accept: */*
Accept-Encoding: deflate, gzip
Content-type: application/json
Content-Length: 45



This keeps looping since my miner would like some work..

(http://forum.bitcoin.org/index.php?topic=27988.0)
Vadtec
Newbie
*
Offline Offline

Activity: 15


View Profile
July 14, 2011, 11:18:42 PM
 #300

I've been reading this thread over the past 45ish mins, but I haven't come across anything to solve my problem. If I missed it, I apologize in advance.

I am running pushpool, and everything is working except for one thing. None of the shares are getting stored in the mysql db. I have checked to make sure everything is setup correctly in the db, the db user has the necessary perms (full access to the database being used), and I am running pushpool in the foreground.

I can see the shares being logged to the log file I gave, but I do not see any entries in the db table. Nor do I see any errors that would indicate there is a problem with the db table. As well, I am running pushpool in gdb, and have it set to break on the line of code that should be calling the code to insert the shares into the db table.

I am using GUI Miner 2011-06-14, running the poclm miner, bitcoin-0.3.24, and pushpool-0.5 (from the git repo).

I have put around 500 shares through pushpool, none of which show up in the db table. I have not seen a single mysql error, or error from pushpool related to mysql. I know pushpool is able to connect to the db, because I do not get errors when I have the miner login to pushpool. I also see the miner getting work like normal.

Does anyone have any info as to what might be causing the shares to get logged to file but not to the mysql db table?

- Vadtec

*Addendum: I fixed it, never mind.

Find my post useful? Send me a few bitcent @ 1NFBQg4fMpZoP2UEE2CnSyFDdNVy5fSrqc
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!