CKPOOL - Open source pool/proxy/passthrough/redirector/library in c for Linux - page 8.

chillfactr

full member

Activity: 637

Merit: 131

Ok now im stuck, and lost
anyone know what .conf i need to edit? -ck?
Thank you Shocked

ckpool -A -p
[2016-08-31 22:42:16.579] ckproxy stratifier starting
[2016-08-31 22:42:16.579] ckproxy generator starting
[2016-08-31 22:42:16.581] ckproxy connector starting
[2016-08-31 22:42:16.581] ckproxy stratifier ready
[2016-08-31 22:42:16.582] ckproxy connector ready
[2016-08-31 22:42:16.778] Proxy 0:0 solo.ckpool.org:3333 failed to authorise in auth_stratum, got: {"id":42,"error":null,"result":false,"node.method":"auth.result"}
[2016-08-31 22:42:16.778] Failed initial authorise to solo.ckpool.org:3333 with user: !

chillfactr

full member

Activity: 637

Merit: 131

Quote from: -ck on August 31, 2016, 07:43:35 AM

Quote from: chillfactr on August 31, 2016, 02:28:17 AM

I think i got ckproxy setup,
i run ckpool -A -p and i get this. any "help" would be appreciated

-A -p
[2016-08-31 00:23:29.100] ckproxy generator starting
[2016-08-31 00:23:29.100] ckproxy stratifier starting
[2016-08-31 00:23:29.101] ckproxy connector starting
[2016-08-31 00:23:29.104] ckproxy connector ready
[2016-08-31 00:23:29.105] ckproxy stratifier ready
[2016-08-31 00:23:49.335] Failed initial subscribe to solo.ckpool.org:80 !

Huh

There is no stratum server at solo.ckpool.org:80 ... (hint, port)

ah HAH, Thanx -ck

-ck

legendary

Activity: 4088

Merit: 1631

Ruu \o/

Quote from: chillfactr on August 31, 2016, 02:28:17 AM

I think i got ckproxy setup,
i run ckpool -A -p and i get this. any "help" would be appreciated

-A -p
[2016-08-31 00:23:29.100] ckproxy generator starting
[2016-08-31 00:23:29.100] ckproxy stratifier starting
[2016-08-31 00:23:29.101] ckproxy connector starting
[2016-08-31 00:23:29.104] ckproxy connector ready
[2016-08-31 00:23:29.105] ckproxy stratifier ready
[2016-08-31 00:23:49.335] Failed initial subscribe to solo.ckpool.org:80 !

Huh

There is no stratum server at solo.ckpool.org:80 ... (hint, port)

chillfactr

full member

Activity: 637

Merit: 131

I think i got ckproxy setup,
i run ckpool -A -p and i get this. any "help" would be appreciated

-A -p
[2016-08-31 00:23:29.100] ckproxy generator starting
[2016-08-31 00:23:29.100] ckproxy stratifier starting
[2016-08-31 00:23:29.101] ckproxy connector starting
[2016-08-31 00:23:29.104] ckproxy connector ready
[2016-08-31 00:23:29.105] ckproxy stratifier ready
[2016-08-31 00:23:49.335] Failed initial subscribe to solo.ckpool.org:80 !

Huh

SpecialFish

newbie

Activity: 12

Merit: 0

Fixed the php error.

I did notice in uthash.h though...

Quote

Line 426: hashv = 0xfeedbeef;

This amused me.

SpecialFish

newbie

Activity: 12

Merit: 0

Quote from: kano on July 23, 2016, 06:25:56 AM

... as it says, you sent it to ckpool, not ckdb.

Up and working now, I am sure I had tried that but obviously haven't.

Thanks for the help Kano, Really appreciate it.

kano

legendary

Activity: 4466

Merit: 1798

Linux since 1997 RedHat 4

... as it says, you sent it to ckpool, not ckdb.

SpecialFish

newbie

Activity: 12

Merit: 0

Quote from: kano on July 22, 2016, 06:30:17 PM

Quote from: SpecialFish on July 22, 2016, 12:51:36 PM

Quote from: kano on July 22, 2016, 11:22:25 AM

Quote from: SpecialFish on July 22, 2016, 10:43:01 AM

snip

The output of initid.sh is in the socket format that ckdb reads.
It's obviously not SQL.
Send it to ckdb with ckpmsg

We can tell that. What do you make of this

Quote

bitcoinuser@vultr:~/ckpool/sql$ ./initid.sh | ckpmsg -s /opt
[2016-07-23 01:15:16+00] Got message: newid.workerid.idname=workerid idvalue=20160723100000
Opened client path /opt/ckpool/listener successfully on socket 3
[2016-07-23 01:15:16+00] Received response: unknown
[2016-07-23 01:15:16+00] Got message: newid.paymentid.idname=paymentid idvalue=20160723200000
Opened client path /opt/ckpool/listener successfully on socket 3
[2016-07-23 01:15:16+00] Received response: unknown
[2016-07-23 01:15:16+00] Got message: newid.authid.idname=authid idvalue=20160723300000
Opened client path /opt/ckpool/listener successfully on socket 3
[2016-07-23 01:15:16+00] Received response: unknown
[2016-07-23 01:15:16+00] Got message: newid.userid.idname=userid idvalue=20160723400000
Opened client path /opt/ckpool/listener successfully on socket 3
[2016-07-23 01:15:16+00] Received response: unknown
[2016-07-23 01:15:16+00] Got message: newid.markerid.idname=markerid idvalue=20160723500000
Opened client path /opt/ckpool/listener successfully on socket 3
[2016-07-23 01:15:16+00] Received response: unknown
[2016-07-23 01:15:16+00] Got message: newid.paymentaddressid.idname=paymentaddressid idvalue=20160723600000
Opened client path /opt/ckpool/listener successfully on socket 3
[2016-07-23 01:15:16+00] Received response: unknown
[2016-07-23 01:15:16+00] Got message: newid.payoutid.idname=payoutid idvalue=20160723700000
Opened client path /opt/ckpool/listener successfully on socket 3
[2016-07-23 01:15:16+00] Received response: unknown
Failed to get a valid line
bitcoinuser@vultr:~/ckpool/sql$

Where is the response meant to be coming from... ckdb?. There is not much documentation around this part. I would love to get this working as its a solid product.

Thank you for your help btw.

kano

legendary

Activity: 4466

Merit: 1798

Linux since 1997 RedHat 4

Quote from: SpecialFish on July 22, 2016, 12:51:36 PM

Quote from: kano on July 22, 2016, 11:22:25 AM

Quote from: SpecialFish on July 22, 2016, 10:43:01 AM

Hi,

I Have been working on this most of the day, trying different things, ckdb and ckpool are talking. the notifier can find straifier for blockupdates

the only problem I have is when I connect I get an error

nextid(): No matching idname='userid'

I have tried running ./initid.sh before hand but no luck.

I had imported the ckdb.sql database originally, Should there have been another as I notice many sql files, or should there be an order to each one.

Thanks if you can help.

ckdb.sql is always the current version.
It says the version, rather obviously, on the end.

The other ones are for upgrading versions.

CKDB will report if the database is the wrong version and wont start.

nextid() error means you didn't apply initid.sh to the database

Hi Kano,

What is the most appropriate way to apply this to the db (Im kinda new with PostgrSQL) I know MySQL/PHP very well though. so if you need SQL statements im okay with them.
When I try to apply the ID's because there is no data already in the Database it expects an expirydate also as primary key. which the initid.sh does not have.

Thanks for any help.

The output of initid.sh is in the socket format that ckdb reads.
It's obviously not SQL.
Send it to ckdb with ckpmsg

SpecialFish

newbie

Activity: 12

Merit: 0

Quote from: kano on July 22, 2016, 11:22:25 AM

Quote from: SpecialFish on July 22, 2016, 10:43:01 AM

Hi,

I Have been working on this most of the day, trying different things, ckdb and ckpool are talking. the notifier can find straifier for blockupdates

the only problem I have is when I connect I get an error

nextid(): No matching idname='userid'

I have tried running ./initid.sh before hand but no luck.

I had imported the ckdb.sql database originally, Should there have been another as I notice many sql files, or should there be an order to each one.

Thanks if you can help.

ckdb.sql is always the current version.
It says the version, rather obviously, on the end.

The other ones are for upgrading versions.

CKDB will report if the database is the wrong version and wont start.

nextid() error means you didn't apply initid.sh to the database

Hi Kano,

What is the most appropriate way to apply this to the db (Im kinda new with PostgrSQL) I know MySQL/PHP very well though. so if you need SQL statements im okay with them.
When I try to apply the ID's because there is no data already in the Database it expects an expirydate also as primary key. which the initid.sh does not have.

Thanks for any help.

SpecialFish

newbie

Activity: 12

Merit: 0

Quote from: kano on July 22, 2016, 11:22:25 AM

Quote from: SpecialFish on July 22, 2016, 10:43:01 AM

Hi,

I Have been working on this most of the day, trying different things, ckdb and ckpool are talking. the notifier can find straifier for blockupdates

the only problem I have is when I connect I get an error

nextid(): No matching idname='userid'

I have tried running ./initid.sh before hand but no luck.

I had imported the ckdb.sql database originally, Should there have been another as I notice many sql files, or should there be an order to each one.

Thanks if you can help.

ckdb.sql is always the current version.
It says the version, rather obviously, on the end.

The other ones are for upgrading versions.

CKDB will report if the database is the wrong version and wont start.

nextid() error means you didn't apply initid.sh to the database

Right okay, Thanks for the tip, il look into that right away.

kano

legendary

Activity: 4466

Merit: 1798

Linux since 1997 RedHat 4

Quote from: SpecialFish on July 22, 2016, 10:43:01 AM

Hi,

I Have been working on this most of the day, trying different things, ckdb and ckpool are talking. the notifier can find straifier for blockupdates

the only problem I have is when I connect I get an error

nextid(): No matching idname='userid'

I have tried running ./initid.sh before hand but no luck.

I had imported the ckdb.sql database originally, Should there have been another as I notice many sql files, or should there be an order to each one.

Thanks if you can help.

ckdb.sql is always the current version.
It says the version, rather obviously, on the end.

The other ones are for upgrading versions.

CKDB will report if the database is the wrong version and wont start.

nextid() error means you didn't apply initid.sh to the database

SpecialFish

newbie

Activity: 12

Merit: 0

Hi,

I Have been working on this most of the day, trying different things, ckdb and ckpool are talking. the notifier can find straifier for blockupdates

the only problem I have is when I connect I get an error

nextid(): No matching idname='userid'

I have tried running ./initid.sh before hand but no luck.

I had imported the ckdb.sql database originally, Should there have been another as I notice many sql files, or should there be an order to each one.

Thanks if you can help.

kano

legendary

Activity: 4466

Merit: 1798

Linux since 1997 RedHat 4

Read the ckdb_cmd.c code.
If you don't understand the code, and how initid.sh relates to that, then CKDB is too complex for you to use.

bonso

newbie

Activity: 4

Merit: 0

Thanks, but can i eat it?

or how must eat it? ckdb or ckpool?

the output is nice....

when must i exec. it ?

kano

legendary

Activity: 4466

Merit: 1798

Linux since 1997 RedHat 4

initid.sh

bonso

newbie

Activity: 4

Merit: 0

Hello nice code and pool..... hoppe the luck will be back......

but what can i do for nextid() to find a matching id?

nextid(): No matching idname='userid'
cmd_adduser() reg5286.failed.DBE

tables are all created, and the db is raning/connect.....

Invalid username, password or email address - please try again

so thanks for all the fish.....

SaBit

member

Activity: 85

Merit: 10

Thanks, I am running a full node in any case, on my main personal machine,, but this also has all my media, and acts as a media server for my house - and is a Windoze machine (when I initially set it up a few years ago I couldn't get decent Linux support for my raid cards -- and now that there is proper support, with 30tb of media on Raid 6 it is just too terrifying,, -- and too much of a mission to start tinkering.

So I was thinking of taking bitcoind of off my main machine,, and setting up a separate machine just handle all the "bit[Suspicious link removed]dies" including the bitcoinD -- and whatever monitoring software etc

So bandwidth is not SUPER critical , but I would like to do it more efficiently --

How about this little puppy for the job? http://www.amazon.com/dp/B00LGJ9AT6/ref=psdc_11036071_t3_B005KKJPCO

-ck

legendary

Activity: 4088

Merit: 1631

Ruu \o/

Quote from: SaBit on April 09, 2016, 05:51:13 PM

I would like to ad ckpool as a proxy to limit my bandwidth. -- i'm sittin with a lte radio link until i get my fibre

Lets control those packats. What machine specs would you suggest to run ckpool proxy, perhaps ckdlb and of course bitcoind?

Even a low spec machine is more than enough to run ckpool in proxy mode, but bitcoind requires tons of storage and uses a lot more bandwidth than all your mining combined so if you're worried about bandwidth, bitcoind is not the way to go. Some cheap recent laptop will suffice for ckproxy so you can run a recent 64 bit ubuntu or similar and laptops effectively have an inbuilt UPS. You don't want ckdb as that's really meant for a full pool that has different users and isn't really designed to run with a simple proxy. In summary, a cheap netbook will do.

SaBit

member

Activity: 85

Merit: 10

Ok. -- so i have been tinkering around woth bitcoin for a few days

Got my self 1 x 7. ,, and then just added another 2 x 7 a few days layer -- still gettiing thehandle of it. ... Will be adding many miners to mine on kano. ... As an when i get money and time to add them. ...u will see me on kano pool

I would like to ad ckpool as a proxy to limit my bandwidth. -- i'm sittin with a lte radio link until i get my fibre

Lets control those packats. What machine specs would you suggest to run ckpool proxy, perhaps ckdlb and of course bitcoind?

Topic: CKPOOL - Open source pool/proxy/passthrough/redirector/library in c for Linux - page 8. (Read 123941 times)