moopless / stratum-mining-litecoin

This fork is no longer maintained. Please use https://github.com/ahmedbodi/stratum-mining
Other
38 stars 35 forks source link

There is no shares table, Have you imported the schema? #71

Open sunggeorge opened 10 years ago

sunggeorge commented 10 years ago

Maybe a newbie question.

I get captioned message when I run: twistd -ny launcher.tac

I tried creating the database in config.py first but still get this msg.

I don't know if there should be any thing done to mysql.

Hope someone can help me. Thanks! screenhunter_26 dec 10 23 52

TheSerapher commented 10 years ago

If you are using MPOS, import that SQL supplied.

SpeedMiners commented 10 years ago

Hi Serapher - Imported the MPOS SQL and I am getting that error too - Am happy for you to log into my server if you want to check it out, let me know!

SpeedMiners commented 10 years ago

Here is the code that's causing the problem

self.execute( """ SELECT COUNT(*) FROM INFORMATION_SCHEMA.STATISTICS WHERE table_schema = %(schema)s AND table_name = 'shares' """, { "schema": getattr(settings, 'DB_MYSQL_DBNAME') } )

    data = self.dbc.fetchone()

    if data[0] <= 0:
       raise Exception("There is no shares table. Have you imported the sch

However, I do have the database that it is mentioning I do not..

mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mpos | | mysql | | performance_schema | | test | +--------------------+ 5 rows in set (0.01 sec)

Have I installed it incorrectly do you think?

TheSerapher commented 10 years ago

Point Stratum to the right database with proper credentials.

I don't supply customer support. It's an easy thing to setup if you know what to do.

Cheers, Sebastian

On 15.12.2013, at 04:56, SpeedMiners notifications@github.com wrote:

Hi Serapher - Imported the MPOS SQL and I am getting that error too - Am happy for you to log into my server if you want to check it out, let me know!

— Reply to this email directly or view it on GitHub.

SpeedMiners commented 10 years ago

Completely understand - I will dig a little deeper and see what I can find - Thanks for your help, Sebastian :)

I appreciate your work on this project!

SpeedMiners commented 10 years ago

Just to let you guys know I fixed this - My database was empty! Check your database and ensure you've imported all the MPOS tables :)