Hello, thanks a lot for the sample, it really helped me understanding more of the combination between sequelize, passport and express. I've got it to work using sqlite but not with postgresql.

After a while i found out that the hash consists of 1024 character while the migration file (using hash: Sequelize.STRING) creates a VARCHAR(255) column. After changing this to 1050 (a bit more than 1024 just to be safe) it worked. Apparently it's possible to pass a parameter along for the length of the string (hash: Sequelize.STRING(1050)) but i haven't tried this. I just wanted to write this here so others could read up about it in case they have the same problem.

Thank you,

Ringo

If I change config.json to look something like:

  "development": {
    "username": "user",
    "password": "pass",
    "database": "testdb",
    "host":     "127.0.0.1",
    "dialect":  "mysql"
  },

All attempts to authenticate a user fail, I get a 401 back from all auth requests.

I was writing my own app and experienced this, so cloned this repo to try it out, and saw exactly the same behaviour. Using sqlite works in both my app and this one.

To reproduce:

• clone the repo
• install mysql server and npm install mysql
• follow the instructions in the README to set up the app
• create the database to match the JSON snippet above
• register a user (appears to work fine) and attempt to log in