All Questions
11,926
questions
0
votes
0
answers
18
views
How to connect my local Node server with remote MYSQL db, via SSH and using sequelize
Im using Datagrip to manage the DB and all work just fine, i made the SSH connection then the DB connection and work perfect. im trying to do the same with my NODE server.
I got a virtual machine ...
0
votes
0
answers
28
views
MySQL Master Slave substitution problem in Node.js
I'm trying to configure master slave in nodejs web. I want to connect to the slave server when the master one is collapsed. I tried to stop the master and it really connected to the slave. However, ...
0
votes
0
answers
48
views
Nodejs Connection With MySQL database Error: read ECONNRESET
Hi friends
I have a hostinger MySQL live server and I have a react native cli project with the backend is Nodejs with MySQL. Problem is when i connect Nodejs with localhost MySQL then its properly ...
0
votes
1
answer
59
views
Encoding problem UTF-8 in docker backend image
i try to create mysql and nodejs express image
when i run mysql and backend container and open my frontend
english text can display but if data is thai text when i use mysql2 to fetch thai text
the ...
0
votes
0
answers
13
views
import 'exported' sql file into mysql database using node.js
I had one sql file which i want to import in my new database using node.js.
I have tried multiple ways but no progress
This error i receive when i try readFile approach
Error executing SQL file: ...
0
votes
0
answers
70
views
Integrating MySQL Database via VPN in Next.js App on Vercel
I need to work on a project where I have to access and query a local database from a Next.js app deployed on Vercel. However, the local server hosting the database is configured with a VPN, and after ...
0
votes
1
answer
31
views
Stringified JSON data won't INSERT into mySQL(verified json format)
I'm not able to insert a JSON string into a mySQL table.
CREATE TABLE registered (
id int NOT NULL AUTO_INCREMENT,
name nvarchar(128) NOT NULL,
panels JSON NOT NULL,
PRIMARY KEY (id)
);...
0
votes
0
answers
11
views
Possible error: sequelize multiple nested includes?
I am using a simple mysql database for tracking miles driven and time logged for work. I have a table of Users; a table of Weeks (each Week linked to a User); a table of Days (each Day linked to a ...
0
votes
3
answers
105
views
javascript MySQL - using Promise-await-async constructs, can't get code to wait for query completion
I've tried multiple versions of example code but can never seem to get something that guarantees completion of the query set before other code commences. I was under the impression that 'await' makes ...
0
votes
0
answers
46
views
"Access denied for user 'myuser'@'<my-ip>' (using password: YES)"
I'm trying to create a lambda function that should connect with my Amazon RDS database (MySql Community engine). I configured the auth with IAM. I linked the function and the DB:
I created the user ...
0
votes
0
answers
20
views
In my nodejs project where I use prisma orm, I sometimes get too many connections error in mysql, this error goes away when the ip is changed
as I wrote in the title, I am using prisma orm in my nodejs (nestjs) project. Sometimes I get the too many connections error. This error keeps happening, but when I change the IP, this error gets ...
1
vote
2
answers
92
views
Fetch API Skipping .then() Block After POST Request in Node.js: JSON Response Not Processed
I'm using the fetch API in my JavaScript code to make a POST request to a specific endpoint. However, I'm encountering an issue where the fetch call seems to skip the .then() block entirely and goes ...
-1
votes
1
answer
311
views
Connecting nodejs app to a mysql database using docker and docker-compose [duplicate]
I'm trying to connect my node.js app with a mysql database
This is my dockerfile
FROM node:latest
WORKDIR /app
COPY . /app
RUN npm update
RUN npm install
RUN npm rebuild bcrypt
ENV SERVER_PORT ...
0
votes
0
answers
24
views
Sequelize Many to Many relation with an unique field
I have role and permission model. They have a many to many relation, but permission model´s primary key is composed by two fields, also, permission model has id field that is just unique and not a key....
0
votes
0
answers
67
views
Get numeric values of Decimal data types defined in schema
I've defined the following Prisma schema:
model aikon_articulo {
aik_ar_codigo String @db.VarChar(24) @id
aik_ar_descri String? @db.VarChar(200)
aik_ar_memo ...