# SQL Node on Edge **URL:** \ **Category:** Help\ **Tags:** edge\ **Created:** [August 4, 2020, 8:42pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176 "2020-08-04T20:42:27Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Lars\_Andersson](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\ **Post date:** [August 4, 2020, 8:42pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176/1 "2020-08-04T20:42:28Z")
Should I be able to use server type MySql for a MariaDB? ---
**Author:** ![Brandon\_Cannaday](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/brandon_cannaday/32/14_2.png) [@Brandon\_Cannaday](https://forums.losant.com/u/Brandon_Cannaday)\ **Post date:** [August 4, 2020, 8:47pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176/2 "2020-08-04T20:47:34Z")
We have not explicitly tested MariaDB. The client API is advertised as compatible with MySQL, so in theory it may work. This is something you’ll have to test yourself. ---
**Author:** ![Lars\_Andersson](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\ **Post date:** [August 5, 2020, 2:31pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176/5 "2020-08-05T14:31:27Z")
OK, I switched to MySQL instead. Now I get the error: **SQLNodeError** ER\_NOT\_SUPPORTED\_AUTH\_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client ---
**Author:** ![Brandon\_Cannaday](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/brandon_cannaday/32/14_2.png) [@Brandon\_Cannaday](https://forums.losant.com/u/Brandon_Cannaday)\ **Post date:** [August 5, 2020, 3:36pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176/7 "2020-08-05T15:36:06Z")
Can you please provide the authentication mechanism that your MySQL database is currently configured with? ---
**Author:** ![Lars\_Andersson](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\ **Post date:** [August 5, 2020, 3:50pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176/8 "2020-08-05T15:50:08Z")
I figured it out, I had to switch back to Standard authentication for the username I used, to get it working. Any info on how I should do it if I wanted to use SSL/TLS ? ---
**Author:** ![Brandon\_Cannaday](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/brandon_cannaday/32/14_2.png) [@Brandon\_Cannaday](https://forums.losant.com/u/Brandon_Cannaday)\ **Post date:** [August 5, 2020, 3:57pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176/9 "2020-08-05T15:57:58Z")
I would expect checking the TLS/SSL checkbox and then providing a username and password is all that would be required. Is that what you did to receive the previous error message? ---
**Author:** ![Lars\_Andersson](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\ **Post date:** [August 5, 2020, 4:01pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176/10 "2020-08-05T16:01:19Z")
No, I wasn’t sure how to do it. The user I was using was setup for secure password authentication on the Mysql server side. ---
**Author:** ![Brandon\_Cannaday](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/brandon_cannaday/32/14_2.png) [@Brandon\_Cannaday](https://forums.losant.com/u/Brandon_Cannaday)\ **Post date:** [August 5, 2020, 4:05pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176/11 "2020-08-05T16:05:03Z")
I believe using secure password authentication on the server side, then checking the TLS/SSL box in node configuration is the required combo to get a secure connection. ---
**Author:** ![Lars\_Andersson](https://avatars.discourse-cdn.com/v4/letter/l/f05b48/32.png) [@Lars\_Andersson](https://forums.losant.com/u/Lars_Andersson)\ **Post date:** [August 5, 2020, 4:12pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176/12 "2020-08-05T16:12:10Z")
If that’s the case, how should I configure the “additional configuration method” box? Or is that optional? ---
**Author:** ![Brandon\_Cannaday](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/brandon_cannaday/32/14_2.png) [@Brandon\_Cannaday](https://forums.losant.com/u/Brandon_Cannaday)\ **Post date:** [August 5, 2020, 4:41pm UTC](https://forums.losant.com/t/sql-node-on-edge/3176/13 "2020-08-05T16:41:12Z")
Those options are based on this: > **[mysqljs/mysql](https://github.com/mysqljs/mysql#ssl-options)** > > A pure node.js JavaScript Client implementing the MySQL protocol. - mysqljs/mysql Properly setting up SSL for you MySQL server and obtaining your CA certificate is a bit beyond the level of support we can provide. The quickest option during development, however, is to pass `{ rejectUnauthorized: false }` through those options. ![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/1/1099a7edbb50aa13170c69c0a5ac6776b08e1e26.png) In production, you will eventually want to pass another parameter, `ca`, which is the contents of your CA certificate.