when sending multiple requests to server from multiple devices at same time causes following error:
error: Sending 500 ("Server Error") response: { Error: OperationalError [AdapterError]: Unexpected error from database adapter: sendNativeQuery failed ("queryFailed"). The database returned an error when attempting to execute the native query. Additional data:
{ error: TypeError: Cannot read properties of undefined (reading 'on') at E:\DPMS-backend\node_modules\mssql\lib\tedious\request.js:428:20 at E:\DPMS-backend\node_modules\mssql\lib\base\connection-pool.js:100:41 at processTicksAndRejections (node:internal/process/task_queues:96:5) at runNextTicks (node:internal/process/task_queues:65:3) at processImmediate (node:internal/timers:437:9), meta: undefined } at getReports (E:\DPMS-backend\api\controllers\SyncController.ts:186:42) at processTicksAndRejections (node:internal/process/task_queues:96:5) at async Object.push [as sync/push] (E:\DPMS-backend\api\controllers\SyncController.ts:689:21) { cause: Error [AdapterError]: Unexpected error from database adapter: sendNativeQuery failed ("queryFailed"). The database returned an error when attempting to execute the native query. Additional data:
{
error: TypeError: Cannot read properties of undefined (reading 'on')
at E:\DPMS-backend\node_modules\mssql\lib\tedious\request.js:428:20
at E:\DPMS-backend\node_modules\mssql\lib\base\connection-pool.js:100:41
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at runNextTicks (node:internal/process/task_queues:65:3)
at processImmediate (node:internal/timers:437:9),
meta: undefined
}
at getReports (E:\DPMS-backend\api\controllers\SyncController.ts:186:42)
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at async Object.push [as sync/push] (E:\DPMS-backend\api\controllers\SyncController.ts:689:21) {
adapterMethodName: 'find',
modelIdentity: 'monitoring',
raw: [Error]
},
isOperational: true,
adapterMethodName: 'find',
modelIdentity: 'monitoring',
raw: Exception: sendNativeQuery failed ("queryFailed"). The database returned an error when attempting to execute the native query.
Additional data:
{
error: TypeError: Cannot read properties of undefined (reading 'on')
at E:\DPMS-backend\node_modules\mssql\lib\tedious\request.js:428:20
at E:\DPMS-backend\node_modules\mssql\lib\base\connection-pool.js:100:41
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at runNextTicks (node:internal/process/task_queues:65:3)
at processImmediate (node:internal/timers:437:9),
meta: undefined
}
at Object.connectAndQuery (E:\DPMS-backend\node_modules\sails-mssql\lib\adapter.js:619:69)
at async Object.find (E:\DPMS-backend\node_modules\sails-mssql\lib\adapter.js:647:23) {
code: 'queryFailed',
exit: 'queryFailed',
traceRef: {},
raw: [Object]
}
I can successfully get the parameters from AWS, but it's an async call and I cannot for the life of me figure out how to set the connection string with the response since there's no await available in config file.
Example:
```// Load the AWS SDK for Node.js
var AWS = require('aws-sdk');
var ssm = new AWS.SSM({region: 'us-east-1'});
var options = {
Name: '/test/test', / required /
WithDecryption: false
};
var parameterPromise = ssm.getParameter(options).promise();
parameterPromise.then(function(data, err) {
if (err) console.log(err, err.stack); // an error occurred
else console.log(data); // successful response
});
```
How can I use this response in the module.exports for the database config?
Hey Sails.js family. Sailsconf 2022 is some days away and I'm inviting you all to all the talks and I will be sharing a secret project(s) I have been working on at Sailsconf that will be quite interesting to a lot of folks I am assuming.
Hey all, if you want to chat about Sailsconf 2022 or ask questions on the event/sails please kindly join the Sailscasts discord.
I recently upgraded mongodb server to 4.4 but now that I am checking the mongodb node driver version used in sails-mongo (3.5.x), which does not support mongodb server after 4.2 as per mongodb node driver their compatibilty. what options do I have here to continue using sails?
https://youtu.be/i4aYlf292aE
I am thrown an authentication error
suggesting that I need to update my SQL updator
the projects starts just fine and connection with db is established easily
https://twitter.com/sails_conf/status/1539374821104132102?s=20&t=H6QOUr0C3r10eJYIHBDRmA
https://youtu.be/OME5lQUJ4q4
https://youtu.be/4rPnX5EUm7E
Hey all. It's the last day of Sailsconf. Tune in to some amazing talks
We integrate vmware clarity ui framework, and rewrite it to TypeScript, now it stable.
Now it's very easy to make an admin panel with Sails.
1 reply
apiKey: function(){
res = this.res;
req = this.req;
console.log("InitializingapiKey(API Key Middleware)")
console.log("Checking response for API Key...");
//app.use('*',)
return function(req,res,next){
console.log('Received HTTP request:'+req.method+' '+req.path );
if(req.headers['apiKey']!==API_KEY || req.headers['apiKey'] !== '' ){
res.status.status(401).send("UNAUTHORIZED ACCESS!")
}
else{
res.send(200)
}}
+1 (570) 801-0862
I can't seem to find an answer to this:
I'm using the sails-mysql adapter to connect to my database and I'd like to add a custom method to the waterline ORM that listens for incoming DB queries and calls a callback function when it receives, but if I access the native mysql driver to write the method I can't access the existing DB connection configured in datastores.js and have to create a new one, is there a way to do this but by using the existing connection (as if I were using leaseConnection())?
1 reply
Hello, I've been investigating how to expose the Blueprint actions by adding entries in the routes.js. However I'm having a tough time running tests on the destroy and remove actions.
The destroy action just hangs and the remove action complains that:
Error: Missing required route option, `req.options.alias`my routes.js config is:
'GET /api/v1/student/:id' : { action: 'student/findOne' },
'GET /api/v1/student' : { action: 'student/find' },
// destroying a student is difficult as it has associations!?
// is this why it hangs?
'DELETE /api/v1/student/:id' : {action: 'student/destroy'},
'POST /api/v1/student' : { action: 'student/create'},
'PATCH /api/v1/student/:id' : {action: 'student/update'},
// The actions seems to want an alias/?
'DELETE /api/v1/student/:id/:association/:fk' : { action: 'student/remove'}and the tests run:
baseurl = '/api/v1/student';
canDeleteStudent = async function (username) {
var agent = await loginAs(username);
await agent
.delete(baseurl + '/1')
.expect(200);
};
...
canRemoveAssociations = async function (username) {
var agent = await loginAs(username);
await agent
.delete(baseurl + '/1/stuUser/1')
.expect(200)
.then(res => {
console.log(res.body)
});
};Anyone got any idea what the problems could be? stuUser is defined as;
stuUser: {
model: 'user',
description: 'The user record relating to this student'
}
ok: 0,
errmsg: 'Unsupported OP_QUERY command: drop. The client driver may require an upgrade. For more details see https://dochub.mongodb.org/core/legacy-opcode-removal',
code: 352,
codeName: 'UnsupportedOpQueryCommand'
}
Hey, i am using sails js as a framework and I just can not get sessions to work, im using connect-pg-admin, Iv tried every way to connect, pool, conObject and conString but every time it says Failed to prune sessions: relation “session” does not exist.
I have tested the connection by connecting and selecting the table names, and the session table is there. heres an example of the code im using.
const pgPool = new Pool({
connectionString: ‘<connectionString>’,
ssl: {
sslmode: ‘require’,
}
});
...
...
session: {
adapter: ‘connect-pg-simple’,
store: new pgSession({
pool: pgPool,
tableName: ‘session’
}),
secret: ‘shhhhhhh’,
cookie: {
secure: true,
maxAge: 24 * 60 * 60 * 1000, // 24 hours
},
resave: true,
saveUninitialized: true
}any help would be great. Thanks,
1 reply
Hi, I'm having an issue with how data is returned by Waterline.
Let's say I have a Posts table and at some endpoints, I need to populate Posts.user but in other endpoints I don't. My front-end now has two possible Post formats: {text: 'the post text', user: 'theuserid1234'} or {text:'the post text', user: {id: 'theuserid1234', name:'John', ...etc}}
So .user might be an id or it might be an object. And when the front-end looks for the id in cached data, it must look in both Post.user and Post.user.id. Is there a place in Sails where I could intercept responses and instead of returning {user:'theuserid1234'} return {user: {id: 'theuserid1234'}}
So that way, the front-end is always looking for the id in post.user.id?
