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

SimpleAuth MySql

Discussion in 'Plugin Help' started by exepx, Aug 5, 2017.

  1. exepx

    exepx Silverfish

    Messages:
    15
    GitHub:
    exepx
    Whenever i tried using MySql our server always gives us an error.
     
  2. Awzaw

    Awzaw Zombie Pigman Poggit Admin

    Messages:
    726
    GitHub:
    awzaw
    If you post the error that would be helpful. Did you create a user/password for simpleauth and grant the necessary permissions, flush, and fill in the simpleauth config correctly?
     
  3. exepx

    exepx Silverfish

    Messages:
    15
    GitHub:
    exepx
    hey awzaw the error I get is Server thread/CRITICAL Invalid MySQL settings, We are using the hosting providers MySQL database so I am not sure about the permissions, and what do you mean about flush like deleting the whole folder, and yes I have filled the config correctly.
     
  4. Awzaw

    Awzaw Zombie Pigman Poggit Admin

    Messages:
    726
    GitHub:
    awzaw
    Can you connect to mysql on the command line? If so, what are you using for the db address: if 'localhost' try 127.0.0.1 and vice-versa.
     
  5. exepx

    exepx Silverfish

    Messages:
    15
    GitHub:
    exepx
    No, I'm using the database that the server host provided us.
     
  6. Awzaw

    Awzaw Zombie Pigman Poggit Admin

    Messages:
    726
    GitHub:
    awzaw
    Ok, but what is the address ('servername') they give you for the db? Is it on the same server or remote?
     
  7. exepx

    exepx Silverfish

    Messages:
    15
    GitHub:
    exepx
    pretty sure it is in the same server, ive tried it with pureperms and everything went well its just with simpleauth thats not working.
     
  8. Awzaw

    Awzaw Zombie Pigman Poggit Admin

    Messages:
    726
    GitHub:
    awzaw
    You mean to say mysql worked with pureperms but not with simpleauth? Which version of SimpleAuth?
     
  9. exepx

    exepx Silverfish

    Messages:
    15
    GitHub:
    exepx
    The SimpleAuth version that we are currently using is SimpleAuth version 1.7.2-php7.
     
  10. Awzaw

    Awzaw Zombie Pigman Poggit Admin

    Messages:
    726
    GitHub:
    awzaw
    Not sure where you got that from... Try this instead (or an earlier release if you aren't on the latest master builds on API 3.0.0-ALPHA7 ) : https://poggit.pmmp.io/p/SimpleAuth/
     
  11. exepx

    exepx Silverfish

    Messages:
    15
    GitHub:
    exepx
    Does this version work with GenisysPro? or do i need to switch to PMMP?
     
  12. Awzaw

    Awzaw Zombie Pigman Poggit Admin

    Messages:
    726
    GitHub:
    awzaw
    We don't support other versions of PocketMine here or on Poggit, but you should be able to get it to work with an older release of SimpleAuth.
     
    Last edited: Aug 6, 2017
    HimbeersaftLP likes this.
  13. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    GitHub:
    sof3
    If you use Genisys, don't even get on this forum. We do not support spoons at all on this forum.
     
    HimbeersaftLP and EdwardHamHam like this.
  14. Gabriel Gomez

    Gabriel Gomez Spider Jockey

    Messages:
    32
    GitHub:
    ggomez
    While we are at it. Is this the correct way to enter the MySQL settings on SimpleAuth? I put them like below but I am getting the same error this person was getting (Invalid MySQL Settings).

    #For MySQL:
    #dataProviderSettings:
    # host: "*******"
    # port: 3306
    # user: "******"
    # password: "********"
    # database: "SimpleAuth"
    dataProviderSettings: []

    @Awzaw
     
    Last edited: Aug 8, 2017
  15. EdwardHamHam

    EdwardHamHam Skeleton

    Messages:
    962
    GitHub:
    edwardhamham
    Do they match the settings of the database you created?
     
  16. Gabriel Gomez

    Gabriel Gomez Spider Jockey

    Messages:
    32
    GitHub:
    ggomez
    Yes
     
  17. Gabriel Gomez

    Gabriel Gomez Spider Jockey

    Messages:
    32
    GitHub:
    ggomez
    I got MySQL to work for Pure Perms using the same strategy except a different database
     
  18. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    GitHub:
    sof3
    The # sign is the "comment sign". The YAML parser ignores any characters on the line after the # sign. You have to delete them (except the "#For MySQL" line, which is intended for humans to read and should indeed be deleted).
     
    Awzaw likes this.
  19. Gabriel Gomez

    Gabriel Gomez Spider Jockey

    Messages:
    32
    GitHub:
    ggomez
    Thank you! Does it need the ""?
     
  20. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    GitHub:
    sof3
    Not needed, but recommended. Needed if your values are abnormal (e.g. empty text, numeric text, etc.). (But don't add it for the port)
     
    HimbeersaftLP likes this.
  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.