Pushpool - Tech Support

[ziomik]

Get the parameters to log in and see what I can do

[cablepair]

thank you, let me know when your logged in
and If you get it working ill send you 5 btc

pushpool is located in /home/pushpool/

and bitcoin is in /usr/bin/

[cablepair]

if you dont think you can get it let me know someone else wants to try

[Viceroy]

imune,


take the time and get it working.   the MOST likely problem is
you are not listening on the right ports.

what does
netstat -p -l

give?


5 btc, damn you must be rich

[cablepair]

lol
definitely not rich my friend

I just want this thing working
if I have to spend a couple days worth of mining to get my pool up It will be well worth it
me and a couple local guys are going solo

[Viceroy]

go read my 9 million posts on pages 16 and 17.  your answer is in there.

[cablepair]

hey talk to me in here ive reached my limit of 10 personal messsages per hour

[cablepair]

btw: i did what you asked, the port should be opened, do you think you can fix it?

[cablepair]

tom@BitCoinMinersUnion:~$ netstat -p -l
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 *:ftp                   *:*                     LISTEN      -
tcp        0      0 *:ssh                   *:*                     LISTEN      -
tcp        0      0 localhost:mysql         *:*                     LISTEN      -
tcp        0      0 *:8331                  *:*                     LISTEN      11192/bitcoind
tcp        0      0 localhost:11211         *:*                     LISTEN      -
tcp        0      0 *:8333                  *:*                     LISTEN      11192/bitcoind
tcp6       0      0 [::]:www                [::]:*                  LISTEN      -
tcp6       0      0 [::]:ssh                [::]:*                  LISTEN      -
udp        0      0 *:43540                 *:*                                 -
udp        0      0 localhost:11211         *:*                                 -
udp        0      0 *:mdns                  *:*                                 -
udp        0      0 *:bootpc                *:*                                 -
udp6       0      0 [::]:mdns               [::]:*                              -
udp6       0      0 [::]:36403              [::]:*                              -
Active UNIX domain sockets (only servers)
Proto RefCnt Flags       Type       State         I-Node   PID/Program name    Path
unix  2      [ ACC ]     STREAM     LISTENING     10446    -                   /tmp/.X11-unix/X0
unix  2      [ ACC ]     STREAM     LISTENING     11581    -                   /tmp/orbit-gdm/linc-48a-0-75a7939611aa4
unix  2      [ ACC ]     STREAM     LISTENING     11543    -                   /tmp/.ICE-unix/1108
unix  2      [ ACC ]     STREAM     LISTENING     8689     -                   /tmp/orbit-gdm/linc-460-0-7e2e892b4ae76
unix  2      [ ACC ]     STREAM     LISTENING     10474    -                   /tmp/orbit-gdm/linc-454-0-58493e4550dfa
unix  2      [ ACC ]     STREAM     LISTENING     7584     -                   /tmp/orbit-gdm/linc-473-0-71859c927021c
unix  2      [ ACC ]     STREAM     LISTENING     10520    -                   /tmp/orbit-gdm/linc-48e-0-72a0cdc02f1d2
unix  2      [ ACC ]     STREAM     LISTENING     7624     -                   /tmp/orbit-gdm/linc-48f-0-15a2bf4e2f247
unix  2      [ ACC ]     STREAM     LISTENING     9521     -                   /tmp/.esd-106/socket
unix  2      [ ACC ]     STREAM     LISTENING     9523     -                   /var/lib/gdm/.pulse/a14213dd1454bdde0d7b944d0000000c-runtime/native
unix  2      [ ACC ]     STREAM     LISTENING     7652     -                   /tmp/orbit-gdm/linc-4a6-0-1e86a9e9746b9
unix  2      [ ACC ]     STREAM     LISTENING     16400    -                   /tmp/orbit-gdm/linc-1567-0-51bf39313bf23
unix  2      [ ACC ]     STREAM     LISTENING     8483     -                   /var/run/avahi-daemon/socket
unix  2      [ ACC ]     STREAM     LISTENING     6693     -                   /var/run/dbus/system_bus_socket
unix  2      [ ACC ]     STREAM     LISTENING     5627     -                   @/com/ubuntu/upstart
unix  2      [ ACC ]     STREAM     LISTENING     10445    -                   @/tmp/.X11-unix/X0
unix  2      [ ACC ]     STREAM     LISTENING     12391    -                   /var/run/acpid.socket
unix  2      [ ACC ]     STREAM     LISTENING     11542    -                   @/tmp/.ICE-unix/1108
unix  2      [ ACC ]     STREAM     LISTENING     11541    -                   @/tmp/dbus-6NDRfNd1SK
unix  2      [ ACC ]     STREAM     LISTENING     9380     -                   /var/run/mysqld/mysqld.sock
unix  2      [ ACC ]     STREAM     LISTENING     11536    -                   @/tmp/gdm-greeter-RwEmdSLi
unix  2      [ ACC ]     STREAM     LISTENING     8669     -                   @/tmp/gdm-session-DlfhPbPN

[cablepair]

Scanning ports on 67.249.133.162

67.249.133.162 is responding on port 8341 ().

[cablepair]

ziomik: please post on here with status report my friend ! - hows it going in there?

[ziomik]

it's all settled, but the port is not responding. The problem is not on the server, but somewhere else. That's all I can do ..

[cablepair]

Damn r u sure? I can swap out the router but it's going to take some time, I'll let you know if your right bbiab

[ziomik]

Damn r u sure? I can swap out the router but it's going to take some time, I'll let you know if your right bbiab

Yes, but now it's too late for me. Are 2.30 am and I have to sleep ...
If you can not even send me a pm tomorrow to see if we can ...

[Viceroy]

did you get the "initialized" statement?

[dikidera]

The initialized statement doesnt appear cause it can't connect to mysql me thinks.

Also, ziomk, blkmond does exactly what the name says, it doesnt prevent loss of shares. It monitors for new blocks on the network and alerts pushpool which sends the Long Poll signal to the miners.

Here is the piece of code from pushpool

Code:

	if (!srv.db_ops->open())
		goto err_out_listen;

	applog(LOG_INFO, "initialized");

As you can see it tries to open a connection to the mysql database but it can't so it exits.

[Flowz]

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!

[sareea]

I am a total newbie to Ubuntu,
but i could reach the install of the push pool on the server , and get the ./configure to work .
Now the hard part is to put the configure the server.json file . I have a big experience with other scripts like phpbb and vbulletin and joomla , is it the same way ? I make a SQL Database and a user, allocate all the privileges, then i enter the right credentials to the Database information in the raw server.json file, and what about the port of the DB ?  .
Do i need to edit the other ips ? i mean the 127.0.0.1 ? And what address to use to put in the miners ?

Thanks a lot !
Please help

[cablepair]

after you configured pushpool compiler did you compile it? 'make' 'make install'

i was able to compile pushpool entirely from reading the howto at the begining of the thread.
and the key to getting the db to work is to import the correct .sql file so it sets up the tables it needs.

Pushpol and your front end will share the same database.

the port of the db that is in the server.json should be default for mysql
i did not have to change it for mine

I am not an expert but I believe you should leave it 127.0.0.1

you will send your miners to the local IP of the pushpool server unless it is coming from outside the net work then you will need to configure your router to send all traffic on the mining port to the local port of your pushpool server.

[sareea]

Thanks for your help .
Yes i did
make;
make install;
and it worked .
Thanks !

Edit : where to edit the .sql file ? in the server.json file ? And can i make the DB using cpanel or any other panel ? easier than the manual commands ...