Bitcoin Forum
March 29, 2024, 05:18:17 AM *
News: Latest Bitcoin Core release: 26.0 [Torrent]
 
  Home Help Search Login Register More  
  Show Posts
Pages: « 1 2 3 4 [5] 6 »
81  Bitcoin / Mining support / Ufasoft Miner - Proxy support? on: June 15, 2012, 03:34:18 PM
Hi,
I am trying to get the proxy function of ufasoft to working but I am Huh
I set up CCProxy to test it out on my local machine, and that's working out great.
The miner successfully connects to the proxy (CCProxy says it connected) and when I get back to the miner, it gives me the 403 forbidden error code?
Has anyone expermintated with these functions?

SOLVED!
I'm retarded, I entered in the wrong password, explains the whole forbidden access.
82  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: August 06, 2011, 10:57:37 AM
Thanks Furyan and Flowz !!!
Furyan your explanation helped me thousand times ! thanks . Even though the command didn't help, but i think it ruined the file , or i dunno .
I did this , made a text file in directadmin file manager and named it server.json and moved it to the pool directory, and it reads it ! Wow .
Nice .

I am only afraid of that the file permissions are for admin as seen in the directadmin file manager and not for root ...

Edit : I get this error in my directadmin

Error connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I think my Mysql server is down , once i started pushpoold this what happened . And now it can't connect to the SQL server.
strange ... what should i do ? I try to stop mysqld but it fails ...

Glad to help...

So, it's probably a bad idea to run pushpool as root.  Run pushpool as the same user as the owner of the server.json file.

I'm not sure about that mysql error.  It's supposed to run as the system account so I don't think it's a permissions problem.  It's probably dead but the PID file is still around.

What happens if you do

Code:
service mysqld stop
wait about 30 seconds
Code:
service mysqld start

Do NOT use "service mysqld restart".  Seems to be an odd problem with removal of the locking file.  I've had the same happen on my own server, restart doesn't work, you have to use stop and then start (even though restart does exactly the same thing, it's the timing of how close together the calls are).


Look what it gives :S
Code:
root@server:/tmp# service mysqld stop
Stopping mysqld:                [ FAILED ]
root@server:/tmp# service mysqld start
Starting mysqld:                [ OK ]
root@server:/tmp# ps xa | grep mysqld
23794 ?        S      0:00 sh -c /etc/init.d/mysqld rest
art                           >>/dev/null 2>>/dev/null

23795 ?        S      0:00 /bin/sh /etc/init.d/mysqld re
start
23865 ttyp0    S+     0:00 grep mysqld
root@server:/tmp# cd /var/run/mysql/
-bash: cd: [b]/var/run/mysql/: No such file or directory[/b]
I think something deleted this whole directory ? or is it located somewhere else ?
And when i start mysqld using directadmin it automatically shuts down :S I will google this to ease the pain hh
I don't know what happend but if those directories don't exist then you will probably want to reinstall MySQL..
Code:
# yum search mysql
Give us the output of that file and I'll take a look into it! Btw we need the mysql-dev or mysql-devel install so it should be in there..
83  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: August 05, 2011, 06:28:09 PM
Post your server.json file. The problem is there.
here is it,
http://pastebin.com/aL9Am2Pf
i checked it with
http://jsonformatter.curiousconcept.com/
and it is valid
thanks!

What the piece of C code you posted means, in words, is: "If the newline character is not found in the string, within the length of the line buffer, the line is too long".

My guess is you've got your newlines in the file switched to DOS newlines. VIM won't reveal this because it properly understands both newline formats (although, depending on your flavor, it may warn you about it and give you a chance to fix it. It does this on CentOS, I am not sure about other variants).

Try the following command:

Code:
dos2unix -n server.json serverFixed.json

and then try to use the new serverFixed.json file as your pushpoold config file. Post results.

If you don't have the dos2unix utility, you can install it either via
Code:
apt-get install tofrodos
or
Code:
yum install dos2unix
depending on your Linux OS flavor.
There is a much easier way of doing it..
Code:
# vim server.json
# :set fileformat=unix
# :x!
Done!
84  Bitcoin / Bitcoin Technical Support / Re: pushpool stops working after a while HELP ! on: August 05, 2011, 08:46:39 AM
Hi, please help me.
I will pay you 5BTC for the solution.

pushpool 5.1 stops working after some hours .
When i look atr the terminalscreen i see "too many open files".

pushpoold is still running , but does not accepting any connections.

cat /proc/sys/fs/files-max are 400000. Think thats enough.

The system:

Dedicated Server
Open Suse 11.4 x64
32GB RAM

I want tu run my pool 24/7 without watching the pushpool status all the time.

Try these commands:
Code:
# ulimit -n40000
# cd /etc/security/
# nano limits.conf

This will open a file in Nano. Now, use PAGE DOWN, or the DOWN ARROW until you get to the very bottom of this confusing document. Once there, add the following lines:

Code:
soft nofile 40000
hard nofile 40000

Press CTRL+O (save), and then CTRL+X (exit). Ok, now type:
Code:
# cd /usr/include/bits/
# nano typesizes.h

now start to look for the line: #define __FD_SETSIZE 1024 so change that to #define __FD_SETSIZE 40000

If you don't have nano installed:
Code:
CentOS:
# yum install nano

Others:
# apt-get install nano
85  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 29, 2011, 10:35:38 PM
I'll help Imune out tomorrow but here is a quick overview:
- make sure the mysql credidentials are correct.
- make sure that variable: proxy is the IP of the server running pooshpoold..
- make sure that the bitcoin credisentials match, important notice: make sure that the ports match, I like to use 8262..

I'm 100% sure the problem is at the mysql part!
86  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 28, 2011, 08:41:50 PM
Have you imported the front-end's SQL template/file yet?
87  Other / Beginners & Help / Re: Trust in Merchants on: July 25, 2011, 10:49:11 PM
Proof of the product and proof of the quality of it, I always want to make sure the product I'm buyIng is good.. Customer reviews are important so make sure your support team is there to help and the product fits the needs of the customer...
88  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 24, 2011, 08:37:17 PM
its always safer to go with -daemon

and that is a cool layout... I can't wait till I get Templates features setup. Still optimising tho
Thanks, You should give us a preview too! Cheesy
89  Bitcoin / Bitcoin Technical Support / Re: Pushpoold MySQL Tables & Columns Query! SQL Template on: July 24, 2011, 07:38:19 PM
I corrected them, btw MiningFarm uses 257 instead the 256 you mentioned?
90  Bitcoin / Bitcoin Technical Support / Re: Pushpoold MySQL Tables & Columns Query! SQL Template on: July 24, 2011, 04:22:51 PM
Yeah, sorry, but them fields are a tad bit incorrect. Flowz, before you start handing out 'templates' at least learn how the sizes work.
Mind providing a correcter version of it then?
91  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 24, 2011, 02:51:30 PM
I tested ./bitcoind -server & yesterday and it stopped after the session closed.

http://www.dreamtemplate.com/templates/Dynamic_XHTML_-_3D_CU3ER/detail/6669.html

92  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 24, 2011, 01:42:44 PM
Btw, make sure to run bitcoind as this:
Code:
./bitcoind -server -daemon
-daemon is important, because that keeps the proccess running even if you close the SSH session/client!

Btw an update about the theme, it's not from scratch though:


The php part will be 100% MiningFarms and I will give credit to them Wink
93  Bitcoin / Bitcoin Technical Support / Re: Pushpoold MySQL Tables & Columns Query! SQL Template on: July 23, 2011, 11:25:42 PM
Calm down, world leader,    Roll Eyes



I Modified your create statement to include an ID and a timestamp. 
I thought those might be helpful.



Oh, you mis-understood the feeling I was trying to express with that post.
I was trying to say: 'thanks for pointing that out! But it's not needed for the back-end to work properly.' but I used different words wich might come over more aggresivly and ignorantly!
I apoligize for that.
94  Bitcoin / Bitcoin Technical Support / Re: Pushpoold MySQL Tables & Columns Query! SQL Template on: July 23, 2011, 10:54:46 PM
You forgot some stuff Smiley

Code:
delimiter $$

CREATE TABLE `pool_worker` (
  `ID` int(8) NOT NULL default '100000',
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID_UNIQUE` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1$$

CREATE TABLE `shares` (
  `id` bigint(30) NOT NULL auto_increment,
  `time` int(4) 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(255) NOT NULL,
  `timestamp` timestamp NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1$$

I forgot nothing, this is just to support the back-end of a pool! You posted columns that are needed by the front-end!
95  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 23, 2011, 10:50:21 PM
modificating

You're like sarah palin, you make up words Smiley

It's a cool sounding word, I wish I'd thought it up.


I'm not Sarah Palin! I'm a world leader znd she will never be one.
I actually wanted to write: modifieing/modifying but I don't know how to spell it Tongue
To modify and to modificate, Those 2 are correct right?
Btw, we're going off topic with this so if you face any problem in regards of pushpoold/bitcoin/miningfarm. We're here to help you Smiley
96  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 23, 2011, 10:13:07 PM
yep, it was.  testing.

Thank you Flowz
You're welcome Viceroy, if you need help with the front-end of the pool don't hassle to contact me.
The front-end is pretty easy to setup, but I dislike the lay-out of MiningFarm so I'm modificating that a lot!
97  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 23, 2011, 10:00:59 PM
ahhhhhhhhhhhhhhh    




They are looking for the name of the database, not the table.

so then the tablename 'shares' is hardcoded into pushpool?
I don't know + Not needed for now, aslong as pushpoold can connect to your MySQL server and pick out the database it will say: 'initialized' but if the SQL structure isn't right and you start mining then pushpoold will give you an error.

Too Long; Made no sense: The tables/columns don't have to be correct to get the initialized message!
 Just connecting is enough. We'll fix that later.

MiningFarm provides you the full table and column construction for your pool to work.
98  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 23, 2011, 09:45:17 PM
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?
Code:
   # database settings
   "database" : {
      "engine" : "mysql",

      "host" : "host",

      "port" : 3306,

      #database name
      "name" : "themalwa_pushpool",
      #database username
      "username" : "themalwa_node1",
      #database password
      "password" : "password",
      #enable sharelog | to insert share data or sometimes known
      "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 (?, ?, ?$

   },

Seems like you messed up a bit! you keep those things default, you only change: name,username,password and in my case host. you change the SQL queries but you need to keep them default. If you really really want to use the db name infront of the table then you must do (NOT NEEDED!):
databasename.table
btcWorkers.pool_worker
It's all not necessery but whatever you want!

Fix this:
Code:
  "name" : "`btcWorkers`.`shares`",
Code:
  "name" : "btcWorkers"

Code:
                "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 (?, ?, ?, ?, ?, ?)"

        },
Code:
      "stmt.pwdb":"SELECT password FROM pool_worker WHERE username = ?",
      "stmt.sharelog":"INSERT INTO shares (rem_host, username, our_result, upstream_result, reason, solution) VALUES (?, ?, ?$

   },
99  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 23, 2011, 06:46:31 PM
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
100  Bitcoin / Bitcoin Technical Support / Re: Pushpool - Tech Support on: July 23, 2011, 04:57:51 PM
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.
Pages: « 1 2 3 4 [5] 6 »
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!