7
votes
Accepted
Not authorized on test to execute command
Turns out that I was missing a /authDBName in my connection string. It should be this:
mongodb://myUser:[email protected]:27017,SG-staging-43334.servers.mongodirector.com:...
- 221
4
votes
Accepted
Mongo Preventing access to dangerous command
That is referring to the legacy mongo shell which was deprecated in MongoDB v5.0 and has been replaced by mongosh. There is no DB in the mongosh shell.
If you are using an older version of MongoDB and ...
- 156
3
votes
Is it really possible to use SQL injection to change a database, or is this a scam?
Let's look at this carefully:
... gaining access to the database through an SQL inject ...
... the only systems vulnerable to this would be the worst ones, configured by somebody who has never used ...
- 9,478
1
vote
Accepted
Best way for processing over 150 million rows MySql
Big Updates (and Deletes) are problematic.
Plan A: Avoid the big update. If value1 should always be 'somevalue' when idRo2 = 1, then don't store it in the table; store it elsewhere and use a JOIN. ...
- 79.4k
1
vote
How to get applied stored procedure for inserted row in mysql php query
CREATE PROCEDURE has no IF NOT EXISTS.
You have to drop it and create it a new
Also php and mysqli don't add DELIMITER to the CREATe PROCEDURE, so you have to do it yourself.
So the code must loook ...
- 8,668
1
vote
Trouble connecting to local MongoDB server through app.js
As per the log, it's clear the nodejs app is getting 'undefined' as the value of MONGO_URI from process.env
Print the value of MONGO_URI before mongoose connect and check it might be undefined.
...
- 146
1
vote
Migrating timezone timestamps
You can do only one thing
var mystring = "2020-03-22T20:38:48.347Z";
mystring = mystring.replace(/Z/, '');
mystring = mystring.replace(/T/, ' ');
console.log(mystring);
2020-03-22 20:38:48.347
see ...
- 8,668
Only top scored, non community-wiki answers of a minimum length are eligible