Bitcoin Forum
March 28, 2017, 01:50:50 PM *
News: Latest stable version of Bitcoin Core: 0.14.0  [Torrent]. (New!)
 
   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 129119 times)
jgarzik
Legendary
*
Offline Offline

Activity: 1470


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

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
1490709050
Hero Member
*
Offline Offline

Posts: 1490709050

View Profile Personal Message (Offline)

Ignore
1490709050
Reply with quote  #2

1490709050
Report to moderator
1490709050
Hero Member
*
Offline Offline

Posts: 1490709050

View Profile Personal Message (Offline)

Ignore
1490709050
Reply with quote  #2

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

Posts: 1490709050

View Profile Personal Message (Offline)

Ignore
1490709050
Reply with quote  #2

1490709050
Report to moderator
1490709050
Hero Member
*
Offline Offline

Posts: 1490709050

View Profile Personal Message (Offline)

Ignore
1490709050
Reply with quote  #2

1490709050
Report to moderator
smoothie
Legendary
*
Offline Offline

Activity: 1946


LEALANA Monero Physical Silver Coins


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

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
 #283

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
 #284

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
 #285

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
 #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

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
 #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.


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
 #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
}

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
 #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

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
 #290

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: 1876


https://blog.comprarebitcoin.info


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

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
---- +++ ----
https://www.comprarebitcoin.info | https://blog.comprarebitcoin.info | https://www.bitcoinitalia.com
dikidera
Full Member
***
Offline Offline

Activity: 126


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

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: 1876


https://blog.comprarebitcoin.info


View Profile WWW
July 11, 2011, 05:07: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

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
---- +++ ----
https://www.comprarebitcoin.info | https://blog.comprarebitcoin.info | https://www.bitcoinitalia.com
ziomik
Legendary
*
Offline Offline

Activity: 1876


https://blog.comprarebitcoin.info


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

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
---- +++ ----
https://www.comprarebitcoin.info | https://blog.comprarebitcoin.info | https://www.bitcoinitalia.com
LivTru
Newbie
*
Offline Offline

Activity: 24


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

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
 #296

It's always a system reboot Wink

Wuked
Member
**
Offline Offline

Activity: 112


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

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
 #298

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
 #299

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
cuqa
Jr. Member
*
Offline Offline

Activity: 40


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

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 "/"
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!