search

deliciousbrains / sqlbuddy

phpMyAdmin alternative with a focus on usability
http://sqlbuddy.com
MIT License
188 stars 54 forks source link

Authentication #32

Closed gilbitron closed 4 years ago

gilbitron commented 8 years ago

Resolves #22

My attempt at routing authentication to use actual database users. Currently utilises Basic Authentication but this could be replaced by an actual web interface at a later date.

JRGould commented 7 years ago

I feel like kind of a dummy here: I'm not sure how I'm supposed to log in via the basic auth - tried my DB credentials, but that's not working and I can't find anywhere that we would be specifying credentials otherwise?

gilbitron commented 7 years ago

@JRGould If you create a .env file with APP_DEBUG=true in it, what does the response return when basic auth fails?

JRGould commented 7 years ago

@gilbitron I just get a 401 with data Invalid Credentials.

I tried to trace it through with XDebug and it seems like the methods in DatabaseAuthUserProvider never even get executed because it can't seem to find the credentials I typed into the basic auth modal.

Happy to do a quick screen share on Monday if you want to look into this more.

gilbitron commented 7 years ago

@JRGould Strange. I can't think of why this wouldn't work, and it works fine for me. Might need to arrange a screen share at some point unless some else can get it working.

JRGould commented 7 years ago

Just spent some time trying to figure this out again in a new environment, I set it up in a Local container, but get the same thing. ¯\(ツ)/¯

gilbitron commented 7 years ago

@JRGould I just set it up fresh on my new MBP and it works fine 😆 You definitely have MySQL running locally and not on a VM? What browser are you using?

JRGould commented 4 years ago

@gilbitron mind closing this issue? It haunts my mentions... 👻

gilbitron commented 4 years ago

@JRGould Sure no problem 👍