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

[hurricandave]

This might fit the req's. A bit more expensive though.

http://kck.st/1QUiv54

[kano]

This might fit the req's. A bit more expensive though.

http://kck.st/1QUiv54

Well since that web site seems to think that Windows10 is part of their hardware, then nope waste of time - needs to be linux.

[hurricandave]

This might fit the req's. A bit more expensive though.

http://kck.st/1QUiv54

- waste of time - needs to be linux.

That may become a bit blurred in the future, -Ubuntu Bash on Windoze w/Linux CMD prompt, sprinkle in a lil'bit Azure for sum extra confusion

[kano]

This might fit the req's. A bit more expensive though.

http://kck.st/1QUiv54

- waste of time - needs to be linux.

That may become a bit blurred in the future, -Ubuntu Bash on Windoze w/Linux CMD prompt, sprinkle in a lil'bit Azure for sum extra confusion

No, it needs to be a full linux 64bit distribution.

CKPool/CKDB is linux centric code so we don't have to deal with reducing the performance, or lots of random if/but/maybe sections of code doing different things due to OSes not supporting certain linux library functions.

[WBF1]

A hardkernel odroid c2 will probably fit the bill. it is a 64bit arm platform for 40$ USD that can run native 64 bit arch linux (or ubuntu or debian or whatever you like). Better performance than rpi3 but no built in wireless protocols. huge plus is it can use an emmc chip for storage instead of/in addition to micro sdxc. i have my system root on a 8gb emmc module and extra 128gb storage on sdxc class 10 uhs-1.

I actually use mine as a desktop right now, but i see no reason it won't work just fine for your needs.

the only downside is a lack of hardware accelerated drivers for Xorg, but they should be coming sometime in April.

http://odroid.com/dokuwiki/doku.php?id=en:odroid-c2

http://www.hardkernel.com/main/products/prdt_info.php?g_code=G145457216438

[SaBit]

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?

[-ck]

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]

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

[bonso]

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

[kano]

initid.sh

[bonso]

Thanks, but can i eat it?

or how must eat it? ckdb or ckpool?

the output is nice....

when must i exec. it ?

[kano]

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.

[SpecialFish]

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]

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]

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.

[SpecialFish]

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.

[kano]

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]

snip

snip

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

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]

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

[SpecialFish]

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