1. The forums will be archived and moved to a read only mode in about 2 weeks (mid march).

Solved Issue Setting up SimpleAuth with MySQL

Discussion in 'Plugin Help' started by HiggsInc, Apr 24, 2018.

  1. HiggsInc

    HiggsInc Silverfish

    Messages:
    15
    I've got a local instance of MySQL installed and running on windows 10 with server running PocketMine-MP 1.7dev-941 for Minecraft: PE [REDACTED] (protocol version 3.0.0-ALPHA12).

    I've tried to setup SimpleAuth with the following details:
    #For MySQL:
    #dataProviderSettings:
    # host: "127.0.0.1"
    # port: 3306
    # user: "user"
    # password: "password"
    # database: "databaseName"
    dataProviderSettings:
    host: "127.0.0.1"
    port: 3306
    user: "usertest"
    password: "password"
    database: "mcpedb"

    I'm still receiving an error - [Server thread/CRITICAL]: [SimpleAuth] Invalid MySQL settings. Version on SimpleAuth is v2.1.2-6 by poggit-orphanage

    Could someone please point out where the problem might be?
     
  2. HBIDamian

    HBIDamian HBIDamian Staff Member

    Messages:
    365
    GitHub:
    HBIDamian
    Did you make a database?
    Did you make a table in the database?
     
  3. HiggsInc

    HiggsInc Silverfish

    Messages:
    15
    Only the database. I figured the plugin would populate the db with its own data
     
    Last edited: Apr 24, 2018
  4. HBIDamian

    HBIDamian HBIDamian Staff Member

    Messages:
    365
    GitHub:
    HBIDamian
    Do you have a database on your system? 127.0.0.1 being the device you are on.

    If so, is it connected to port 3306?

    If not, then where is this database?
     
  5. HiggsInc

    HiggsInc Silverfish

    Messages:
    15
    Yes the database is based on the same machine. Port is open. I've done a wordpress install with the same credentials and that has worked...
     
  6. HiggsInc

    HiggsInc Silverfish

    Messages:
    15
    I would definitely have agreed with you on that, however when I did try that I experienced the following error:

    [Server thread/CRITICAL]: Error: "Class 'mysqli' not found" (EXCEPTION) in "SimpleAuth-master/src/SimpleAuth/provider/MySQLDataProvider" at line 50
    [Server thread/CRITICAL]: ErrorException: "Undefined property: SimpleAuth\SimpleAuth::$provider" (EXCEPTION) in "SimpleAuth-master/src/SimpleAuth/SimpleAuth" at line 499
     

    Attached Files:

  7. HiggsInc

    HiggsInc Silverfish

    Messages:
    15
    Thanks mate, that was the fault
     
  8. HBIDamian

    HBIDamian HBIDamian Staff Member

    Messages:
    365
    GitHub:
    HBIDamian
    Just a little note for next time you ask for help:
    If there is a error on console, show that on your first post too, otherwise people go around like headless chickens
     
  9. Daniktheboss

    Daniktheboss Baby Zombie

    Messages:
    144
    GitHub:
    daniktheboss
    This should not matter...
     
  10. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    GitHub:
    sof3
    Of course it does matter... YAML is an indent-sensitive language.
     
    EdwardHamHam likes this.
  11. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    GitHub:
    sof3
  12. Daniktheboss

    Daniktheboss Baby Zombie

    Messages:
    144
    GitHub:
    daniktheboss
    My bad, i never knew.
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.