Custome Database Issue

[sravya]

I am new to the auth0, trying to connect to the custom database using MYSQL I used the script which is generated by auth0 and changed the credentials in it and when am trying to connect it is showing connect ETIMEDOUT and i did enabled the import users to auth0 ,can anyone help me on this

[npatel]

Did you whitelist your MYSQL to be accessible from auth0 IPs?

Heads up! If you are trying to access a service behind a firewall, make sure to open the right ports and allow inbound connections from these IP addresses: 35.167.74.121,35.166.202.113,35.160.3.103,54.183.64.135,54.67.77.38,54.67.15.170,54.183.204.205

[sravya]

Thanks for responding. No, but I am trying to whitelist now this is what I have and I am still getting timed out.

[jerdog]

Have you verified that on your MySQL database side you have whitelisted our IPs along with opened the right ports?

[sravya]

so you are talking about the ports where MYSQL is running?, I have one port open right now that is 3306 I am using XAMPP and phpmyadmin .

[sravya]

this is my script and i whitelisted the ipaddress.

function getByEmail(email, callback) {
  const mysql = require('mysql');

  const connection = mysql.createConnection({
    host: '********',
    user: 'root',
    password: '*******',
    database: 'icsocial'
  });

  connection.connect();

  const query = 'SELECT id, email FROM users WHERE email = ?';

  connection.query(query, [ email ], function(err, results) {
    if (err || results.length === 0) return callback(err || null);

    const user = results[0];
    callback(null, {
      user_id: user.id.toString(),
      email: user.email
    });
  });
}

[James.Morrison]

Hey there @sravya,

You can explicitly declare your port in the Auth0 database scripts by passing an additional port attribute to the mysql constructor as shown below.

mysql({
  host     : '111.222.3.4',
  user     : 'user',
  password : 'pass',
  database : 'mydb',
  port: 3306
});

When you get a moment can you try this and let us know if it helps with the ETIMEDOUT error? Thanks!

[sravya]

Hi @James.Morrison thank you for responding. I tried that, it gave me the same error

[James.Morrison]

I see you have a open support ticket that you are currently working with our support team to get to the bottom of this. To concentrate efforts i’ll have our support team take point on this front.

For historically thread context sake I will link the standard custom database documentation below and once a resolution from the ticket has been surfaced I will share that as well. Please let me know if you have any additional questions. Thanks!

Create Custom Database Connections

Auth0 IP Addresses for Allow Lists

[sravya]

ok thank you so much