BluePrint not authenticating logins, Latest MySQL installed about blueprint

[josephspurrier]

What OS are you on?

[josephspurrier]

I just tested with MySQL 5.7.13 x64 on Windows 10 and it worked fine. I used HeidiSQL to apply the SQL from database/migration/20160630_020000_a.up.sql and the authentication piece works. Are you accessing via http://localhost?

8.1 Pro I believe. I will check on 10 ent then.
I think I was using 127.0.0.1 IP - I will have to go back and check now. (may be a week I'm out on vacay)

yes 127.0.0.1 - Also I notice that a fresh install of Mysql doesnt accept the a.up script, due to default values being null for deleted_at and other timestamps. I had to zero those out to get the script to run so I wonder if that could be a part of of the problem?

[josephspurrier]

Ah, interesting. It looks like MySQL < 5.6.6 sets timestamp as NOT NULL by default. I updated the 'up' script to explicitly set them to accept NULL. Can you try now?

8f55ee3

[josephspurrier]

And that's fine about vacation, no rush! Happy 4th!

[josephspurrier]

I just tested with the latest versions of MySQL 5.6 and 5.7 (on Ubuntu and the Linux AMI).
The latest instructions are here: https://github.com/blue-jay/blueprint/wiki

[josephspurrier]

@Zenthunder Have you been able to test the script?

[josephspurrier]

Closing. Please reopen if you're still having an issue.