My experience with NodeJS and MariaDB on Android through Termux

The first thing I did was check the official documentation, Getting Started With the Node.js Connector

I modified my server.js code and tested and first error I encountered was, "Error: (conn=20, no: 1698, SQLState: 28000) Access denied for user 'u0_a270'@'localhost'"

At some point in troubleshooting I also got this error, "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/data/data/com.termux/files/usr/tmp/mysqld.sock'"

Eventually I figured out that the problem was with the mariadb user that was created on install and how no password is required for mysql in Termux. So I just created a new user for my dev work as follows

MariaDB [db1] > CREATE USER 'user1'@localhost IDENTIFIED BY 'password1';

MariaDB [db1] > GRANT ALL PRIVILEGES ON *.* TO 'user1'@localhost IDENTIFIED BY 'password1';

Then my testing nodejs code as follows

const mariadb = require('mariadb');
const pool = mariadb.createPool({
     host: 'localhost',
     user:'user1',
     password: 'password1',
     database: 'db1',
     connectionLimit: 5
});

var http = require('http');

http.createServer(async function (req, res) {
  res.write('Device listing : ');
 
  rows = await queryDB();
 
  rows.forEach(function (row) {
  res.write(row.id + ' ' + row.name + '; '); });
 
  res.end();
}).listen(3000);

async function queryDB() {
  let conn;
  try {
conn = await pool.getConnection();
rows = await conn.query("SELECT * from devices");
  } catch (err) {
throw err;
  } finally {
if (conn) { conn.end(); return rows; }
  }
}

Man I was so happy to see this work after troubleshooting for a few hours. Hopefully this helps someone trying to get started with the same thing.

MariaDB example

Comments

Post a Comment

Popular posts from this blog

Who makes the best cheesecake?

This is a chapter from my fourth book called When hunger yearns It's three in the morning and all through the house is quiet and not a creature is stirring, not even a mouse. I bet a mouse's favorite dessert is cheesecake and so is mine. So it's in the wee hours of the morning and I am thinking about cheesecake and specifically who makes the best cheesecake? I suspect it would be some recipe handed down from generation to generation. Probably someone's grandma from the town where cheesecake originated from. I read that even though we may think that cheesecake originated in New York that it actually goes further back to over four thousand years on the Greek island of Samos. The Greeks there created the earliest known cheesecake. No wonder I think that the cafe in my village that sells Samosas makes the best cheesecake. Is there a connection between Samos in Greece and Samosas? There is not much written about this on the internet but I did find one blog post that tried t...
Read more

Can a single, flickering candle illuminate a vast, ancient library enough to find the book you seek?

This is a chapter from my fourth book called When hunger yearns I asked my friend Gemini to give me 5 random words and form a question with those words. After some back and forth I settled on this question. I have so many questions. How many books are in this library? How long will the candle last? What book am I looking for? Why am I looking for this book? Do I need a ladder to get to the top shelves? Are the books stored in alphabetical order? Am I alone? Is there a librarian? How much time am I allowed in the library? Is there light outside the library? How am I going to read the book after the candle goes out? If there is light outside the library then I could possibly grab books in the dark and carry them outside even when the candle goes out. Am I allowed to create small bonfires with the books I do not want? Would that be worth it? Would the means justify the end? Maybe there are some books with multiple copies and I could create the bonfires with the extra copies. Or maybe crea...
Read more

Book Review - The measure of a man - a spiritual autobiography

It took two days to complete reading this book. My review is really from my notes as I read the book. I read with an open mind and I set out to absorb as much as I could. I love that he acknowledged his wife for her love and support at the beginning of the book. The book had me questioning my own values and virtues. I felt his humility from the get go. I got a sense of calming and authenticity from his words. He had me thinking about how much of our being is influenced by our environment and nurturing during our formative years. He was not afraid to take chances from small and that inner child remains with us through adulthood. He had a good memory. Most of my younger days are a blur to me. Letting go has been a coping mechanism of mines for a long time. Letting go has affected my ability to hold on to memories and feel attachment. I reminded myself of the wanting to be grounded. To be appreciative of where we come from. To be rooted in sensibility and understanding. Racism is horrible...
Read more

My notes from the book "Sick to fit"

My notes from this book. If you are interested in what I noted then give the book a read. Free on Amazon Kindle - https://a.co/2bTlDVF Fun and scientific Life changer Josh's story Eating, moving and thinking right I think my genetics and mental illness and meds makes it much harder to lose weight and get fit Hope is important Free on Amazon app NAQ - naturally attainable quantities Community is important Eating to deal with problems Pragmatism and self-love More than a fitness journey, its a lifestyle journey Avoid burn out One step at a time Don't fall into the perfectionist trap Learn from failure Overconfidence Positive feedback loop Results matter - it is the feedback we have Beware of plateaus Look for results that cannot be measured like happiness and curiosity If when then plan Unconscious vows and character decisions NAQs answer the question, "does this question make sense" The downside of living in our comfort zone Find your community You are what you eat We ...
Read more

Focus on solutions and ways we can help

While surfing the internet this morning I started thinking about problem solving and particularly in Trinidad and Tobago. If I wanted to see a list of all the problems affecting persons in this country where do I go? If I wanted to volunteer solutions to these problems where do I go? There are problems that have existed for years. Seems like everyone knows the solutions. Seems like everyone is an expert. Then there is bureaucracy. Then there are competing interests. Then there is finite resources. I find the older generation is often resistant to change and change is often needed as solutions to problems. The older generation thinks about working hard while the younger generation thinks about working smart. We need to develop a good problem solving culture in this country and I think technology can help. We can develop an open forum platform where persons can share problems and then persons can offer solutions. Problems and solutions can be voted on. The platform can be incentivised to...
Read more