A question can only have one accepted answer. Are you sure you want to replace the current answer with this one?
You previously marked this answer as accepted. Are you sure you want to unaccept it?
I get this error
Error: ERNOTSUPPORTEDAUTHMODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
I did connected to the database with HeidiSQL and used “ALTER USER ‘user’@'host’ IDENTIFIED WITH 'mysqlnativepassword’ BY 'pw’;”
and it ran the query but my script still gives the error.
Hi @foonkus,
I see you already executed
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
However did you flushed the database privileges?
Enter again into MySQL and run
flush privileges;
That should be enough to get you start!
Regards,
KDSys
here is my code var express = require('express'), http = require('http'), path = require('path'), hash = require('./pass').hash; var moment = require('moment'); var bcrypt = require('bcrypt'); var app = express(); var methodOverride = require('method-override'); var mysql = require('mysql'); connection.connect(function(err){ if(!err) { console.log("Database is connected ... nn"); } else { console.log("Error connecting database ... nn"); } }); /* Middlewares and configurations */ app.configure(function () { app.use(express.bodyParser()); app.use(express.cookieParser('Authentication Tutorial ')); app.use(express.session()); app.use(methodOverride(function(req, res){ if (req.body && typeof req.body == 'object' && '_method' in req.body) { var method = req.body._method; delete req.body._method; return method; } })); app.use(express.static(path.join(__dirname, 'public'))); app.set('views', __dirname + '/views'); app.set('view engine', 'ejs'); }); var connection = mysql.createConnection({ host : 'hostss', user : 'user', password : 'password*', database : 'db' }); app.use(function (req, res, next) { var err = req.session.error, msg = req.session.success; delete req.session.error; delete req.session.success; res.locals.message = ''; if (err) res.locals.message = '<p class="msg error">' + err + '</p>'; if (msg) res.locals.message = '<p class="msg success">' + msg + '</p>'; next(); }); /* Helper Functions */ function user_exits(req, res, next) { var username= req.body.username; connection.query("SELECT * FROM user WHERE username =?",[username],function (error, results, fields) { if (error) { console.log(error); res.send("fail internal error"+"\r\n"); } if (results.length >0) { console.log('User is Already Exists'); res.send("fail user already exists"+"\r\n"); } else { console.log('No user Available oN that name, U can insert it'); next(); } }); } /* Routes */ app.get("/", function (req, res) { res.render("index", { moment: moment }); }); app.get("/signup", function (req, res) { res.render("signup",{ moment: moment }); }); app.post("/signup",user_exits,function (req, res){ bcrypt.hash(req.body.password, 5, function( err, bcryptedPassword) { var users={ "username":req.body.username, "email":req.body.email, "password":bcryptedPassword, } console.log(users); connection.query('INSERT INTO user SET ?',users, function (error, results, fields) { if (error) { console.log("error ocurred",error); res.send({ "code":400, "failed":"error ocurred" }); }else{ console.log('The solution is: ', results); res.send({ "code":200, "success":"user registered sucessfully" }); } }); }); }); app.get("/login", function (req, res) { res.render("login",{ moment: moment }); }); app.post("/login",function (req, res) { var sess = req.session; var username= req.body.username; var password = req.body.password; connection.query('SELECT * FROM user WHERE username = ?',[username], function (error, results, fields) { if (error) { console.log(error); }else{ if(results.length >0){ bcrypt.compare(password, results[0].password, function(err, doesMatch){ if (doesMatch){ req.session.userId = results[0].id; req.session.user = results[0]; console.log(results[0].id); res.redirect('/profile/'+results[0].id); }else{ res.send({ "code":204, "success":"Email and password does not match" }); } }); } else{ console.log("fine"); } } }); }); but when i upload it on digitalocean server the form is not working?? please developer help me to fix that problem...
Hello when i on node bot_manager.js i got this erro :ERROR: Two Factor Code: R857T can somebody help ?
I created a Kubernetes cluster in Digital Ocean. The cluster has one node pool with 3 4GB memory / 2vCPU nodes. I have linked GitLab CI to the cluster following the [GitLab documentation](https://gitlab.com/help/user/project/clusters/index.md#adding-an-existing-kubernetes-cluster) Next I installed Helm Tiller, Ingress, Cert-Manager, and Prometheus using the GitLab user interface. Then I configured my local `kubectl` and Helm, and upgraded the Tiller instance installed by GitLab. Also I had to run the steps in [this forum answer](https://www.digitalocean.com/community/questions/unable-to-deploy-to-digital-ocean-kubernetes-using-gitlab-ci?answer=52484) to get Helm to be able to deploy my application in CI. The result is a succesful deployment. ([CI output](https://gitlab.com/appsemble/appsemble/-/jobs/244772424)) However, as soon as the app makes a database request to the MySQL instance, the MySQL pod just crashes. After several tries, I managed to get the MySQL crash log below. When I forward the port to localhost, I can connect to the database and execute queries. I can also see my database tables have been created. However, when I run the following code from within my application pod, the MySQL pod crashes. ```js const Sequelize = require('sequelize') s = new Sequelize(`mysql://${process.env.DATABASE_USER}:${process.env.DATABASE_PASSWORD}@${process.env.DATABASE_HOST}:3306`) q = s.getQueryInterface() q.showAllTables() ``` I did not have this issue when I was using a Kubernets cluster in Google Cloud. ``` root@review-split-tsco-s44xj5-mysql-846c64646b-58492:/# tail -f /var/log/mysql/error.log 2019-07-03T14:43:13.400989Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-07-03T14:43:13.405608Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2019-07-03T14:43:13.406408Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2019-07-03T14:43:13.406515Z 0 [Note] IPv6 is available. 2019-07-03T14:43:13.406537Z 0 [Note] - '::' resolves to '::'; 2019-07-03T14:43:13.406573Z 0 [Note] Server socket created on IP: '::'. 2019-07-03T14:43:13.406729Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190703 14:43:13 2019-07-03T14:43:13.423675Z 0 [Note] Event Scheduler: Loaded 0 events 2019-07-03T14:43:13.424443Z 0 [Note] mysqld: ready for connections. Version: '5.7.14' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) tail: unrecognized file system type 0x794c7630 for '/var/log/mysql/error.log'. please report this to bug-coreutils@gnu.org. reverting to polling *** buffer overflow detected ***: mysqld terminated ======= Backtrace: ========= /lib/x86_64-linux-gnu/libc.so.6(+0x731af)[0x7f3ded20c1af] /lib/x86_64-linux-gnu/libc.so.6(__fortify_fail+0x37)[0x7f3ded291cf7] /lib/x86_64-linux-gnu/libc.so.6(+0xf6f10)[0x7f3ded28ff10] mysqld(_Z19find_or_create_hostP10PFS_threadPKcj+0x395)[0xea96c5] mysqld(_Z22find_or_create_accountP10PFS_threadPKcjS2_j+0x3d2)[0xef3e72] mysqld(_Z18set_thread_accountP10PFS_thread+0x36)[0xeb1476] mysqld(pfs_set_thread_account_v1+0xa0)[0xe93760] mysqld(_Z16acl_authenticateP3THD19enum_server_command+0xfb2)[0x7b1a52] mysqld[0xc14e6d] mysqld(_Z22thd_prepare_connectionP3THD+0x53)[0xc15f23] mysqld(handle_connection+0x24f)[0xd122ef] mysqld(pfs_spawn_thread+0x1b4)[0xe93094] /lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4)[0x7f3dee7be0a4] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f3ded28187d] ======= Memory map: ======== 00400000-01a34000 r-xp 00000000 fe:01 1967664 /usr/sbin/mysqld 01c34000-01d25000 r--p 01634000 fe:01 1967664 /usr/sbin/mysqld 01d25000-01dd1000 rw-p 01725000 fe:01 1967664 /usr/sbin/mysqld 01dd1000-01e90000 rw-p 00000000 00:00 0 026e0000-03252000 rw-p 00000000 00:00 0 [heap] 7f3da0000000-7f3da0021000 rw-p 00000000 00:00 0 7f3da0021000-7f3da4000000 ---p 00000000 00:00 0 7f3da4000000-7f3da4023000 rw-p 00000000 00:00 0 7f3da4023000-7f3da8000000 ---p 00000000 00:00 0 7f3da8000000-7f3da8021000 rw-p 00000000 00:00 0 7f3da8021000-7f3dac000000 ---p 00000000 00:00 0 7f3dac000000-7f3dac021000 rw-p 00000000 00:00 0 7f3dac021000-7f3db0000000 ---p 00000000 00:00 0 7f3db37ff000-7f3db3800000 ---p 00000000 00:00 0 7f3db3800000-7f3db4000000 rw-p 00000000 00:00 0 7f3db4000000-7f3db4024000 rw-p 00000000 00:00 0 7f3db4024000-7f3db8000000 ---p 00000000 00:00 0 7f3db8000000-7f3db8021000 rw-p 00000000 00:00 0 7f3db8021000-7f3dbc000000 ---p 00000000 00:00 0 7f3dbc000000-7f3dbc024000 rw-p 00000000 00:00 0 7f3dbc024000-7f3dc0000000 ---p 00000000 00:00 0 7f3dc0000000-7f3dc0024000 rw-p 00000000 00:00 0 7f3dc0024000-7f3dc4000000 ---p 00000000 00:00 0 7f3dc4000000-7f3dc4025000 rw-p 00000000 00:00 0 7f3dc4025000-7f3dc8000000 ---p 00000000 00:00 0 7f3dc811b000-7f3dc812f000 r-xp 00000000 fe:01 1836116 /lib/x86_64-linux-gnu/libresolv-2.19.so 7f3dc812f000-7f3dc832e000 ---p 00014000 fe:01 1836116 /lib/x86_64-linux-gnu/libresolv-2.19.so 7f3dc832e000-7f3dc832f000 r--p 00013000 fe:01 1836116 /lib/x86_64-linux-gnu/libresolv-2.19.so 7f3dc832f000-7f3dc8330000 rw-p 00014000 fe:01 1836116 /lib/x86_64-linux-gnu/libresolv-2.19.so 7f3dc8330000-7f3dc8332000 rw-p 00000000 00:00 0 7f3dc8332000-7f3dc8337000 r-xp 00000000 fe:01 1836091 /lib/x86_64-linux-gnu/libnss_dns-2.19.so 7f3dc8337000-7f3dc8536000 ---p 00005000 fe:01 1836091 /lib/x86_64-linux-gnu/libnss_dns-2.19.so 7f3dc8536000-7f3dc8537000 r--p 00004000 fe:01 1836091 /lib/x86_64-linux-gnu/libnss_dns-2.19.so 7f3dc8537000-7f3dc8538000 rw-p 00005000 fe:01 1836091 /lib/x86_64-linux-gnu/libnss_dns-2.19.so 7f3dc8538000-7f3dc87f9000 rw-p 00000000 00:00 0 7f3dc87f9000-7f3dc87fa000 ---p 00000000 00:00 0 7f3dc87fa000-7f3dc8ffa000 rw-p 00000000 00:00 0 7f3dc8ffa000-7f3dc8ffb000 ---p 00000000 00:00 0 7f3dc8ffb000-7f3dc97fb000 rw-p 00000000 00:00 0 7f3dc97fb000-7f3dc97fc000 ---p 00000000 00:00 0 7f3dc97fc000-7f3dc9ffc000 rw-p 00000000 00:00 0 7f3dc9ffc000-7f3dc9ffd000 ---p 00000000 00:00 0 7f3dc9ffd000-7f3dca7fd000 rw-p 00000000 00:00 0 7f3dca7fd000-7f3dca7fe000 ---p 00000000 00:00 0 7f3dca7fe000-7f3dcaffe000 rw-p 00000000 00:00 0 7f3dcaffe000-7f3dcafff000 ---p 00000000 00:00 0 7f3dcafff000-7f3dcb7ff000 rw-p 00000000 00:00 0 7f3dcb7ff000-7f3dcb800000 ---p 00000000 00:00 0 7f3dcb800000-7f3dcc000000 rw-p 00000000 00:00 0 7f3dcc000000-7f3dcc021000 rw-p 00000000 00:00 0 7f3dcc021000-7f3dd0000000 ---p 00000000 00:00 0 7f3dd00b4000-7f3dd04b5000 rw-p 00000000 00:00 0 7f3dd04b5000-7f3dd04b6000 ---p 00000000 00:00 0 7f3dd04b6000-7f3dd0cb6000 rw-p 00000000 00:00 0 7f3dd0cb6000-7f3dd0cb7000 ---p 00000000 00:00 0 7f3dd0cb7000-7f3dd14b7000 rw-p 00000000 00:00 0 7f3dd14b7000-7f3dd14b8000 ---p 00000000 00:00 0 7f3dd14b8000-7f3dd1cb8000 rw-p 00000000 00:00 0 7f3dd1cb8000-7f3dd1cb9000 ---p 00000000 00:00 0 7f3dd1cb9000-7f3dd24b9000 rw-p 00000000 00:00 0 7f3dd24b9000-7f3dd24ba000 ---p 00000000 00:00 0 7f3dd24ba000-7f3dd2ee0000 rw-p 00000000 00:00 0 7f3dd2ee0000-7f3dd2ee1000 ---p 00000000 00:00 0 7f3dd2ee1000-7f3dd36e1000 rw-p 00000000 00:00 0 7f3dd36e1000-7f3dd36e2000 ---p 00000000 00:00 0 7f3dd36e2000-7f3dd3ee2000 rw-p 00000000 00:00 0 7f3dd3ee2000-7f3dd3ee3000 ---p 00000000 00:00 0 7f3dd3ee3000-7f3dd46e3000 rw-p 00000000 00:00 0 7f3dd46e3000-7f3dd46e4000 ---p 00000000 00:00 0 7f3dd46e4000-7f3dd4ee4000 rw-p 00000000 00:00 0 7f3dd4ee4000-7f3dd4ee5000 ---p 00000000 00:00 0 7f3dd4ee5000-7f3dd56e5000 rw-p 00000000 00:00 0 7f3dd56e5000-7f3dd56e6000 ---p 00000000 00:00 0 7f3dd56e6000-7f3dd5ee6000 rw-p 00000000 00:00 0 7f3dd5ee6000-7f3dd5ee7000 ---p 00000000 00:00 0 7f3dd5ee7000-7f3dd66e7000 rw-p 00000000 00:00 0 7f3dd66e7000-7f3dd66e8000 ---p 00000000 00:00 0 7f3dd66e8000-7f3dd6ee8000 rw-p 00000000 00:00 0 7f3dd6ee8000-7f3dd6ee9000 ---p 00000000 00:00 0 7f3dd6ee9000-7f3dd76e9000 rw-p 00000000 00:00 0 7f3dd76e9000-7f3dd76ea000 ---p 00000000 00:00 0 7f3dd76ea000-7f3dd7eea000 rw-p 00000000 00:00 0 7f3dd7eea000-7f3dd7eeb000 ---p 00000000 00:00 0 7f3dd7eeb000-7f3dd87e2000 rw-p 00000000 00:00 0 7f3dd87f2000-7f3dd87fd000 r-xp 00000000 fe:01 1836093 /lib/x86_64-linux-gnu/libnss_files-2.19.so 7f3dd87fd000-7f3dd89fc000 ---p 0000b000 fe:01 1836093 /lib/x86_64-linux-gnu/libnss_files-2.19.so 7f3dd89fc000-7f3dd89fd000 r--p 0000a000 fe:01 1836093 /lib/x86_64-linux-gnu/libnss_files-2.19.so 7f3dd89fd000-7f3dd89fe000 rw-p 0000b000 fe:01 1836093 /lib/x86_64-linux-gnu/libnss_files-2.19.so 7f3dd89fe000-7f3dd89ff000 rw-p 00000000 00:00 0 7f3dd8b7d000-7f3dd8b7e000 rw-p 00000000 00:00 0 7f3dd8b7e000-7f3dd8b7f000 ---p 00000000 00:00 0 7f3dd8b7f000-7f3dd8bbf000 rw-p 00000000 00:00 0 7f3dd8bbf000-7f3dd8bc0000 ---p 00000000 00:00 0 7f3dd8bc0000-7f3de323d000 rw-p 00000000 00:00 0 7f3de323d000-7f3de3242000 rw-s 00000000 00:11 736330 /[aio] (deleted) 7f3de3242000-7f3de3247000 rw-s 00000000 00:11 736329 /[aio] (deleted) 7f3de3247000-7f3de324c000 rw-s 00000000 00:11 736328 /[aio] (deleted) 7f3de324c000-7f3de3251000 rw-s 00000000 00:11 736327 /[aio] (deleted) 7f3de3251000-7f3de3290000 rw-p 00000000 00:00 0 7f3de3290000-7f3de3295000 rw-s 00000000 00:11 736326 /[aio] (deleted) 7f3de3295000-7f3de329a000 rw-s 00000000 00:11 736325 /[aio] (deleted) 7f3de329a000-7f3de329f000 rw-s 00000000 00:11 736324 /[aio] (deleted) 7f3de329f000-7f3de32a4000 rw-s 00000000 00:11 736323 /[aio] (deleted) 7f3de32a4000-7f3de32a9000 rw-s 00000000 00:11 736322 /[aio] (deleted) 7f3de32a9000-7f3de32ae000 rw-s 00000000 00:11 736321 /[aio] (deleted) 7f3de32ae000-7f3de400e000 rw-p 00000000 00:00 0 7f3de400e000-7f3de400f000 ---p 00000000 00:00 0 7f3de400f000-7f3ded199000 rw-p 00000000 00:00 0 7f3ded199000-7f3ded33b000 r-xp 00000000 fe:01 1836048 /lib/x86_64-linux-gnu/libc-2.19.so 7f3ded33b000-7f3ded53a000 ---p 001a2000 fe:01 1836048 /lib/x86_64-linux-gnu/libc-2.19.so 7f3ded53a000-7f3ded53e000 r--p 001a1000 fe:01 1836048 /lib/x86_64-linux-gnu/libc-2.19.so 7f3ded53e000-7f3ded540000 rw-p 001a5000 fe:01 1836048 /lib/x86_64-linux-gnu/libc-2.19.so 7f3ded540000-7f3ded544000 rw-p 00000000 00:00 0 7f3ded544000-7f3ded55a000 r-xp 00000000 fe:01 1836067 /lib/x86_64-linux-gnu/libgcc_s.so.1 7f3ded55a000-7f3ded759000 ---p 00016000 fe:01 1836067 /lib/x86_64-linux-gnu/libgcc_s.so.1 7f3ded759000-7f3ded75a000 rw-p 00015000 fe:01 1836067 /lib/x86_64-linux-gnu/libgcc_s.so.1 7f3ded75a000-7f3ded85a000 r-xp 00000000 fe:01 1836078 /lib/x86_64-linux-gnu/libm-2.19.so 7f3ded85a000-7f3deda59000 ---p 00100000 fe:01 1836078 /lib/x86_64-linux-gnu/libm-2.19.so 7f3deda59000-7f3deda5a000 r--p 000ff000 fe:01 1836078 /lib/x86_64-linux-gnu/libm-2.19.so 7f3deda5a000-7f3deda5b000 rw-p 00100000 fe:01 1836078 /lib/x86_64-linux-gnu/libm-2.19.so 7f3deda5b000-7f3dedb47000 r-xp 00000000 fe:01 1836928 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20 7f3dedb47000-7f3dedd47000 ---p 000ec000 fe:01 1836928 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20 7f3dedd47000-7f3dedd4f000 r--p 000ec000 fe:01 1836928 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20 7f3dedd4f000-7f3dedd51000 rw-p 000f4000 fe:01 1836928 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20 7f3dedd51000-7f3dedd66000 rw-p 00000000 00:00 0 7f3dedd66000-7f3dedd6d000 r-xp 00000000 fe:01 1836118 /lib/x86_64-linux-gnu/librt-2.19.so 7f3dedd6d000-7f3dedf6c000 ---p 00007000 fe:01 1836118 /lib/x86_64-linux-gnu/librt-2.19.so 7f3dedf6c000-7f3dedf6d000 r--p 00006000 fe:01 1836118 /lib/x86_64-linux-gnu/librt-2.19.so 7f3dedf6d000-7f3dedf6e000 rw-p 00007000 fe:01 1836118 /lib/x86_64-linux-gnu/librt-2.19.so 7f3dedf6e000-7f3dedf71000 r-xp 00000000 fe:01 1836061 /lib/x86_64-linux-gnu/libdl-2.19.so 7f3dedf71000-7f3dee170000 ---p 00003000 fe:01 1836061 /lib/x86_64-linux-gnu/libdl-2.19.so 7f3dee170000-7f3dee171000 r--p 00002000 fe:01 1836061 /lib/x86_64-linux-gnu/libdl-2.19.so 7f3dee171000-7f3dee172000 rw-p 00003000 fe:01 1836061 /lib/x86_64-linux-gnu/libdl-2.19.so 7f3dee172000-7f3dee17a000 r-xp 00000000 fe:01 1836056 /lib/x86_64-linux-gnu/libcrypt-2.19.so 7f3dee17a000-7f3dee379000 ---p 00008000 fe:01 1836056 /lib/x86_64-linux-gnu/libcrypt-2.19.so 7f3dee379000-7f3dee37a000 r--p 00007000 fe:01 1836056 /lib/x86_64-linux-gnu/libcrypt-2.19.so 7f3dee37a000-7f3dee37b000 rw-p 00008000 fe:01 1836056 /lib/x86_64-linux-gnu/libcrypt-2.19.so 7f3dee37b000-7f3dee3a9000 rw-p 00000000 00:00 0 7f3dee3a9000-7f3dee3b3000 r-xp 00000000 fe:01 1967662 /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0 7f3dee3b3000-7f3dee5b2000 ---p 0000a000 fe:01 1967662 /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0 7f3dee5b2000-7f3dee5b3000 r--p 00009000 fe:01 1967662 /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0 7f3dee5b3000-7f3dee5b4000 rw-p 0000a000 fe:01 1967662 /usr/lib/x86_64-linux-gnu/libnuma.so.1.0.0 7f3dee5b4000-7f3dee5b5000 r-xp 00000000 fe:01 1967577 /lib/x86_64-linux-gnu/libaio.so.1.0.1 7f3dee5b5000-7f3dee7b4000 ---p 00001000 fe:01 1967577 /lib/x86_64-linux-gnu/libaio.so.1.0.1 7f3dee7b4000-7f3dee7b5000 r--p 00000000 fe:01 1967577 /lib/x86_64-linux-gnu/libaio.so.1.0.1 7f3dee7b5000-7f3dee7b6000 rw-p 00001000 fe:01 1967577 /lib/x86_64-linux-gnu/libaio.so.1.0.1 7f3dee7b6000-7f3dee7ce000 r-xp 00000000 fe:01 1836112 /lib/x86_64-linux-gnu/libpthread-2.19.so 7f3dee7ce000-7f3dee9cd000 ---p 00018000 fe:01 1836112 /lib/x86_64-linux-gnu/libpthread-2.19.so 7f3dee9cd000-7f3dee9ce000 r--p 00017000 fe:01 1836112 /lib/x86_64-linux-gnu/libpthread-2.19.so 7f3dee9ce000-7f3dee9cf000 rw-p 00018000 fe:01 1836112 /lib/x86_64-linux-gnu/libpthread-2.19.so 7f3dee9cf000-7f3dee9d3000 rw-p 00000000 00:00 0 7f3dee9d3000-7f3dee9f3000 r-xp 00000000 fe:01 1836030 /lib/x86_64-linux-gnu/ld-2.19.so 7f3dee9f3000-7f3dee9f5000 rw-s 00000000 00:11 736331 /[aio] (deleted) 7f3dee9f5000-7f3dee9f6000 rw-s 00000000 00:11 736318 /[aio] (deleted) 7f3dee9f6000-7f3deebf1000 rw-p 00000000 00:00 0 7f3deebf1000-7f3deebf3000 rw-p 00000000 00:00 0 7f3deebf3000-7f3deebf4000 r--p 00020000 fe:01 1836030 /lib/x86_64-linux-gnu/ld-2.19.so 7f3deebf4000-7f3deebf5000 rw-p 00021000 fe:01 1836030 /lib/x86_64-linux-gnu/ld-2.19.so 7f3deebf5000-7f3deebf6000 rw-p 00000000 00:00 0 7ffe704fe000-7ffe7051f000 rw-p 00000000 00:00 0 [stack] 7ffe705ab000-7ffe705ae000 r--p 00000000 00:00 0 [vvar] 7ffe705ae000-7ffe705b0000 r-xp 00000000 00:00 0 [vdso] 17:15:29 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=151 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68190 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f3da4007820 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7f3dd8bbde80 thread_stack 0x40000 mysqld(my_print_stacktrace+0x2c)[0xe7a83c] mysqld(handle_fatal_signal+0x459)[0x7a8539] /lib/x86_64-linux-gnu/libpthread.so.0(+0xf8d0)[0x7f3dee7c58d0] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x37)[0x7f3ded1ce067] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7f3ded1cf448] /lib/x86_64-linux-gnu/libc.so.6(+0x731b4)[0x7f3ded20c1b4] /lib/x86_64-linux-gnu/libc.so.6(__fortify_fail+0x37)[0x7f3ded291cf7] /lib/x86_64-linux-gnu/libc.so.6(+0xf6f10)[0x7f3ded28ff10] mysqld(_Z19find_or_create_hostP10PFS_threadPKcj+0x395)[0xea96c5] mysqld(_Z22find_or_create_accountP10PFS_threadPKcjS2_j+0x3d2)[0xef3e72] mysqld(_Z18set_thread_accountP10PFS_thread+0x36)[0xeb1476] mysqld(pfs_set_thread_account_v1+0xa0)[0xe93760] mysqld(_Z16acl_authenticateP3THD19enum_server_command+0xfb2)[0x7b1a52] mysqld[0xc14e6d] mysqld(_Z22thd_prepare_connectionP3THD+0x53)[0xc15f23] mysqld(handle_connection+0x24f)[0xd122ef] mysqld(pfs_spawn_thread+0x1b4)[0xe93094] /lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4)[0x7f3dee7be0a4] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f3ded28187d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): Connection ID (thread ID): 1826 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. command terminated with exit code 137 ```
I have a Node.JS application that is hosted on Ubuntu 16.04. I am using EJS to display queried data from MySQL but I am getting a reference error like this ``` ReferenceError: /home/michaeluy/apps/michaeluy.me/views/index.html:130 128| </div><br/><br/> 129| >> 130| <%=sec%> 131| </div> 132| </div> 133| </body> sec is not defined at eval (eval at compile (/home/michaeluy/apps/michaeluy.me/node_modules/ejs/lib/ejs.js:485:12), <anonymous>:11:23) at returnedFn (/home/michaeluy/apps/michaeluy.me/node_modules/ejs/lib/ejs.js:514:17) at View.exports.renderFile [as engine] (/home/michaeluy/apps/michaeluy.me/node_modules/ejs/lib/ejs.js:358:31) at View.render (/home/michaeluy/apps/michaeluy.me/node_modules/express/lib/view.js:126:8) at tryRender (/home/michaeluy/apps/michaeluy.me/node_modules/express/lib/application.js:639:10) at EventEmitter.render (/home/michaeluy/apps/michaeluy.me/node_modules/express/lib/application.js:591:3) at ServerResponse.render (/home/michaeluy/apps/michaeluy.me/node_modules/express/lib/response.js:961:7) at /home/michaeluy/apps/michaeluy.me/server.js:15:9 at Layer.handle [as handle_request] (/home/michaeluy/apps/michaeluy.me/node_modules/express/lib/router/layer.js:95:5) at next (/home/michaeluy/apps/michaeluy.me/node_modules/express/lib/router/route.js:131:13) ``` and here is the first bit of my server.js file: ``` var http = require('http'); var express = require('express'); var fs = require('fs'); var bodyParser = require('body-parser'); var mysql = require('mysql'); var connection = require('express-myconnection'); var app = express(); app.use('/',express.static(__dirname + '/')); app.use(bodyParser.urlencoded({ extended: false })); app.engine('.html', require('ejs').__express); app.set('view engine','html'); var connection = mysql.createConnection({ host: '127.0.0.1', user: 'root', password: '', database: 'michaeluy' }); app.get('/', function(req, res){ connection.query("SELECT * FROM messages", function(err, rows, fields){ if (err) throw err; res.render('index', { sec: rows[0].name }); }); }); ``` I have tried using console.log at first to see if it is able to query the data correctly and it did but when I set the code on the html file for it to show up on the page itself. It gives back a reference error. Hope someone can help here. Thanks in advance