Error while running migrations.

[Pranaya Behera]

Hi, I am using sequ...@2.0.0-beta-1 with my...@2.0.0-alpha7, 

But when I try to migrate , it gives me this error.

shafox@archon:/media/drive1/localbox/api$ sequelize -m

Loaded configuration file "config/config.json".

Using environment "development".

You need to install mysql package manually

/usr/lib/node_modules/sequelize/lib/dialects/mysql/connector-manager.js:274

    var connection = mysql.createConnection(connectionConfig);

                           ^

TypeError: Cannot call method 'createConnection' of undefined

    at module.exports.connect (/usr/lib/node_modules/sequelize/lib/dialects/mysql/connector-manager.js:274:28)

    at Object.pool.Pooling.Pool.create (/usr/lib/node_modules/sequelize/lib/dialects/mysql/connector-manager.js:125:19)

    at createResource (/usr/lib/node_modules/sequelize/node_modules/generic-pool/lib/generic-pool.js:258:13)

    at dispense (/usr/lib/node_modules/sequelize/node_modules/generic-pool/lib/generic-pool.js:250:9)

    at Object.me.acquire (/usr/lib/node_modules/sequelize/node_modules/generic-pool/lib/generic-pool.js:316:5)

    at module.exports.enqueue (/usr/lib/node_modules/sequelize/lib/dialects/mysql/connector-manager.js:320:19)

    at module.exports.ConnectorManager.query (/usr/lib/node_modules/sequelize/lib/dialects/mysql/connector-manager.js:164:15)

    at module.exports.Sequelize.query (/usr/lib/node_modules/sequelize/lib/sequelize.js:291:34)

    at null.<anonymous> (/usr/lib/node_modules/sequelize/lib/query-interface.js:832:32)

    at null.<anonymous> (/usr/lib/node_modules/sequelize/lib/emitters/custom-event-emitter.js:25:18)

My migration is :: 

module.exports = {

  up: function(migration, DataTypes, done) {

    // add altering commands here, calling 'done' when finished

    migration.createTable(

      'users',

      {

        first_name: {

          type: DataTypes.String,

          defaultValue: false,

          allowNull: false

        },

        last_name: {

          type: DataTypes.String,

          defaultValue: false,

          allowNull: false

        },

        username: {

          type: DataTypes.String,

          defaultValue: false,

          allowNull: false

        },

        primary_email: {

          type: DataTypes.String,

          defaultValue: false,

          allowNull: false

        },

        secondary_email: DataTypes.String,

        contact_number: DataTypes.INTEGER,

        alternate_number: DataTypes.INTEGER,

        gender: DataTypes.String,

        city: DataTypes.String,

        city_lat: DataTypes.String,

        city_long: DataTypes.String,

        facebook_id: DataTypes.String,

        google_id: DataTypes.String,

        twitter_id: DataTypes.String,

        ref_link: {

          type: DataTypes.String,

          defaultValue: false,

          allowNull: false

        },

        ref_by: DataTypes.String,

        salt: {

          type: DataTypes.String,

          defaultValue: false,

          allowNull: false

        },

        hash: {

          type: DataTypes.String,

          defaultValue: false,

          allowNull: false

        },

        status: {

          type: DataTypes.String,

          defaultValue: false,

          allowNull: false

        },

        last_login: {

          type: DataTypes.DATETIME,

          defaultValue: false,

          allowNull: false

        }

      },

      migration.addIndex(

        'users',

        ['username'],

        {

          indicesType: 'UNIQUE',

          indexName: 'UserName'

        }

      ),

      migration.addIndex(

        'users',

        ['facebook_id'],

        {

          indicesType: 'UNIQUE',

          indexName: 'FacebookId'

        }

      ),

      migration.addIndex(

        'users',

        ['google_id'],

        {

          indicesType: 'UNIQUE',

          indexName: 'GoogleId'

        }

      ),

      migration.addIndex(

        'users',

        ['twitter_id'],

        {

          indicesType: 'UNIQUE',

          indexName: 'TwitterId'

        }

      ),

      migration.addIndex(

        'users',

        ['email'],

        {

          indicesType: 'UNIQUE',

          indexName: 'EmailId'

        }

      )

    )

    done()

  },

  down: function(migration, DataTypes, done) {

    // add reverting commands here, calling 'done' when finished

    done()

  }

}

I have followed sequelize on heroku document to use it in my project. Here is the code https://gist.github.com/shadow-fox/7767338 

[Paulo Pires]

npm install mysql

[Pranaya Behera]

I have installed mysql, npm install mysql wont do any good. 

[Paulo Pires]

this error is directly connected with the mysql module. Are you sure you installed correctly? sudo npm install-g mysql

[Pranaya Behera]

Does it has to be globally ?? 

[Pranaya Behera]

global installation of mysql package solved this error. but now i am getting this error. 

TypeError: Uncaught, unspecified "error" event.

    at TypeError (<anonymous>)

    at EventEmitter.emit (events.js:74:15)

    at Handshake._callback (/usr/lib/node_modules/sequelize/lib/dialects/mysql/connector-manager.js:281:19)

    at Handshake.Sequence.end (/usr/lib/node_modules/mysql/lib/protocol/sequences/Sequence.js:75:24)

    at Handshake.ErrorPacket (/usr/lib/node_modules/mysql/lib/protocol/sequences/Handshake.js:69:8)

    at Protocol._parsePacket (/usr/lib/node_modules/mysql/lib/protocol/Protocol.js:177:24)

    at Parser.write (/usr/lib/node_modules/mysql/lib/protocol/Parser.js:62:12)

    at Protocol.write (/usr/lib/node_modules/mysql/lib/protocol/Protocol.js:37:16)

    at Socket.ondata (stream.js:51:26)

    at Socket.EventEmitter.emit (events.js:117:20)

[Paulo Pires]

see if the module is in node_modules folder of your application. If so, delete it, and reinstall. But I'm sure if you install globally solve it.

[Pranaya Behera]

Paulo:: It solves the mysql requirement issue, but generates another typeerror mentioned above.

[Paulo Pires]

ok, check your configuration file where you put the information for connecting to the database. may be some login information that is wrong.

[Pranaya Behera]

This is my database connection and initialization file https://gist.github.com/shadow-fox/7767338

[Pranaya Behera]

got it. Thanks. Still some issues but will try to debug myself rather than poking you everytime. Thanks Paulo. 

[Paulo Pires]

Change the "password": null, by: "password": "",