MySQL - tables and colums

[alpha330]

i have problem with my db coiniumserv connected and initialized with mysql but when miners want to connects pool get stratum athounthication error on server side it says no pool_worker table on db i create pool worker but another error on username and pass column coiniumserv it must be create table and colums automaticaly or not?? what version do i use for mysql server on windows? i use 8+

[wargo32]

Use tables from MPOS.

[regtable]

i had this issue so i tried using the default from mpos and i cannot authenticate error is given key 19278 was not present. any ideas? https://github.com/MPOS/php-mpos/blob/master/sql/000_base_structure.sql

[thorapps]

I used that sql as base structure, however seems that some tables are missing .... I got the following error:

An exception occured while getting pending blocks: Table 'CoiniumServ.Block' doesn't exist

Where is the complete DB structure?

Thanks!!

[wargo32]

Because of inconsistencies between table structure offered by migration system and what is really referenced during sql queries. Difference is between "block" and blocks". Maybe renaming table in database would help or if you can - in code.

[thorapps]

ok, is this project still usable? I got too many errors... I think I'll chnage to another ,more mantained, pool software...

[ahmedbodi]

PM me on discord if youre looking for a pool software. username: ahmedbodi

[regtable]

Up to date? I’m dm you regtable.

On Tue, 25 Jun 2024 at 11:45, ahmedbodi @.***> wrote:

PM me on discord if youre looking for a pool software. username: ahmedbodi

— Reply to this email directly, view it on GitHub https://github.com/bonesoul/CoiniumServ/issues/1084#issuecomment-2188580398, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB2BKF7XNFXRIDMIOGL6CDTZJFC2ZAVCNFSM4ID5OM72U5DIOJSWCZC7NNSXTN2JONZXKZKDN5WW2ZLOOQ5TEMJYHA2TQMBTHE4A . You are receiving this because you commented.Message ID: @.***>