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 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 service mysqld stop wait about 30 seconds 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 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.. # 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
|
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: 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 apt-get install tofrodos or yum install dos2unix depending on your Linux OS flavor. There is a much easier way of doing it.. # 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: # 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: soft nofile 40000 hard nofile 40000 Press CTRL+O (save), and then CTRL+X (exit). Ok, now type: # 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: 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!
|
|
|
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...
|
|
|
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: ./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
|
|
|
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, 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 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 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 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
|
|
|
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? # 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: "name" : "`btcWorkers`.`shares`", "name" : "btcWorkers" "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 (?, ?, ?, ?, ?, ?)"
},
"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
|
Hmm 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 2. I don't know what you mean.. In what file? 3. 8344 4. 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.
|
|
|
|