node:10212[DEP0123]DeprecationWarning:Setting the TLS ServerName to an IPaddress is not permitted by RFC 6066.This will be ignored in a future version

Question

Below is my nodejs code to connect to a mssql database and query data

const sql = require('mssql')
export class GetJDBCCasedata {
  async fetchData(wellid, wellboreid, designid) {
    var result
     console.log("In fetchdata")
const sqlConfig = {
  user: 'root',
  password:'root',
  database: 'student',
  server: '12.11.234.12',
 /* pool: {
    max: 10,
    min: 0,
    idleTimeoutMillis: 30000
  },*/
  options: {
    encrypt: true,
    trustServerCertificate: true,
  }
}
console.log("CONFIG FOR SERVER "+JSON.stringify(sqlConfig))
 try {
  console.log("Connecting to database")
  result=await sql.connect(sqlConfig)
  console.log("Connected to database")
 } catch (err) {
  result=err
  console.log("ERROR OCCURRED "+err)
 }
return result
  }
}

The code runs fine and I get the message as "Connected to database". However I get a message as "(node:10212) [DEP0123] DeprecationWarning: Setting the TLS ServerName to an IP address is not permitted by RFC 6066. This will be ignored in a future version." What can I do to get rid of it?

user_9182528 · Answer

I solved same issue by encrypt:false.

options: {
encrypt: false,
trustServerCertificate: true,
}

user_468903 · Answer

I found that if I use the value received from SELECT @@SERVERNAME and I link that up to the IP of the server via the windows hosts file it works and drops the warning.

user_452928 · Answer

In case you have an extra local box e.g. a virtual machine. A simple way of mapping an ip to a domain name (for the above op's type of usage) is through your hosts file.

Reference Jarmund - it was his solution: https://superuser.com/questions/1113845/how-to-give-a-domain-name-to-a-local-ip

Also reference: https://en.wikipedia.org/wiki/Hosts_(file)#Location_in_the_file_system to find where your hosts file is for your system.

node:10212[DEP0123]DeprecationWarning:Setting the TLS ServerName to an IPaddress is not permitted by RFC 6066.This will be ignored in a future version

3 Answers