Leveraging passport.js and direct SQL queries for authentication purposes

Currently tackling a project with an issue that needs resolving. I am looking to integrate user login logic utilizing the Passport API, but struggling to grasp its functionality, especially when implementing it using plain SQL queries. While scouring through various tutorials on how this can be accomplished, most only showcase ORMs, which is not the route I wish to take. After investing hours of coding effort that ultimately led to failure and deletion, I refrain from providing any code below. My website is built using MySQL and Express as frameworks. If you have any insights or advanced suggestions on how I can achieve my goal, I would greatly appreciate your input. Thank you in advance!

mysqlnode.jsexpressauthentication

Answer №1

Understanding Passport can be overwhelming at times, I acknowledge that! It seems like you are interested in using the "local" login strategy rather than opting for Google or GitHub Single Sign On. Additionally, you prefer to utilize "Sessions" (cookies) instead of JWT.

To achieve this, the initial step involves configuring passport with your express app. This includes initializing passport and setting up a session store (such as MySQL or Redis).

Next, you need to establish your "strategy," which in this scenario is the local strategy.

Below is an example along with code demonstrating how to implement this. While I've consolidated it into one code snippet, feel free to split it across multiple files if needed.

Code Snippet for Reference:

https://gist.github.com/BlueHatbRit/5d07d3f98d41d536a776b74fcb843174

Provided here for long-term accessibility:

const express = require('express');
...
... // Rest of the code contains detailed setup and implementation instructions for utilizing Passport with the local strategy.
...

Please note: The code has not been executed. Although all the necessary code is included, there might be syntax errors present, and custom SQL queries will be required to match your specific database structure.

Similar questions

If you have not found the answer to your question or you are interested in this topic, then look at other similar questions below or use the search

Unexpected Token E encountered in the Twitter stream.on function

I'm currently in the process of setting up a search button on my web application that will pull all Twitter tweets related to the search input using the streaming API. Below is my client-side code: <form class="navbar-form navbar-left" role="sear ...

javascriptajaxnode.jsexpresstwitter-streaming-api

Could someone assist me in resolving the issue I am experiencing with the installation of isolated-vm?

Encountering an error while trying to install the npm package isolated VM on Debian 11. The log isn't providing much help... npm ERR! code 1 npm ERR! path /home/screeps/screeps-server/node_modules/isolated-vm npm ERR! command failed ... Unable to acc ...

node.jslinuxnpmdebiannpm-install

Over the course of time, the performance of the Laravel importer routine gradually decreases

I have a process that retrieves data from a web service and saves it in my database. This data consists of over 20,000 items. In order to save them into the database, I need to gather some information first before storing them. Therefore, I have a foreach ...

phpmysqllaravel

Generate a customizable URL for my search bar

I have developed a single HTML page with full AJAX functionality, displaying all content including form submits, main page, form results, and more through various DOM manipulations. The issue I am currently encountering is related to a search box where use ...

javascripturlnode.jsexpress

Disconnection between client and server communications

Can communication between two entities be established in this scenario? For example, if a server receives a file upload and determines it is incorrect, can it send an event to the client? The client would then catch the event and manipulate the DOM to dis ...

javascriptnode.jsexpress

Generating views for individual models in a backbone collection

Currently, I am developing a small backbone.js application that simulates a library where CRUD operations can be performed. The core components of this application are the book model and the library collection (which stores books). var Book = Backbone.Mod ...

javascriptnode.jsweb-applicationsbackbone.js

Error Encountered when Installing NPM and Using Authy API in NodeJS

After successfully setting up Authy on my Nodejs app, I encountered a sudden issue with error messages popping up from within the plugin. It seems like there might be a problem with the copy module, even though running npm install copy and npm update copy ...

node.jsnpmauthy

The free version of Neo4j and Linkurious for the community

Is it possible to integrate linkurious.js community edition with Neo4j? I have heard about the sigma-parser-cypher plugin. As a beginner in both Neo4j and Linkurious, your patience is appreciated. Can both Linkurious JS and Neo4j be run on the same machi ...

node.jsneo4jlinkurious

Addressing the unresolved problem with mongoose through an axios post: A step-by-step guide

Currently, I am tackling an individual project that involves transferring data from a redux form to an express server via an axios call. Although I have successfully sent the client data to the server using body-parser, I am encountering difficulties with ...

reactjsexpressmongooseaxios

Looking for a way to update template variables in copy using grunt?

I am currently utilizing load-grunt-config along with grunt-contrib-copy. My objective is to have the copy task replace certain template tags using the 'process' option. I understand that replacing template tags is feasible based on the grunt-co ...

javascriptnode.jsgruntjslodash

Steps to configure the npm registry exclusively for a particular project

Currently, I am utilizing a private npm registry for one of my npm packages, while also referring to a couple of other packages from the default npm registry. The method I am currently employing involves setting the registry globally using the following co ...

node.jsnpmnpm-install

Error encountered in pre-middleware hooks when querying Mongoose model with findById due to foreign model reference

Within this scenario, I have two distinct models: Protocol and Comment. Each model incorporates a middleware ('pre' or 'remove') that triggers the other model. The issue arises when attempting to call the Comment middleware in Comment.j ...

node.jsmongodbmongoosemongoose-schemamongoose-models

"Exploring the blend of VueJS, ExpressJS, and MySQL in architectural design - A deep dive into

What is the architectural structure of my Vue.js + Express.js + MySQL application? I am tasked with detailing the design of my app for a project, but I'm uncertain about what to name or classify it as. Vue.js (Frontend) Primarily focuses on managin ...

mysqlnode.jsvue.jsexpressarchitecture

On which server is Opa's backend platform hosted?

Curious about the backend platform Opa is utilizing to communicate with browsers. My hunch is leaning towards Node.js. ...

node.jsopa

Can't seem to res.send using Express framework

Hello, I'm encountering an issue when trying to send a response using Express. I've seen suggestions in other questions that changing the variables err and res may resolve this problem, but it hasn't worked for me. router.post('/checkP ...

javascriptnode.jsexpress

MaxListenersExceededWarning occurs when using node with websockets and multiple event listeners

i've got an application that relies on a websocket connection to transmit data to the front-end after a page has loaded. Through express's locals variable, i pass the websocket server to the router. This is how the socket is set up: //certifica ...

node.jswebsocketevent-listener

Having trouble getting the Random Function to function correctly in Discord.js

I'm working on a piece of code that generates a random value to select two different values from two separate arrays. Every time I run it, however, the result seems to be the same and not truly random. I'm not sure where I went wrong with this. I ...

javascriptnode.jsnumbersdiscorddiscord.js

Is the auto-import feature in the new VSCODE 1.18 compatible with nodelibs installed via npm?

Testing out the latest auto-import feature using a JS file in a basic project. After npm installing mongoose and saving an empty JS file for editing, I anticipate that typing const Schema = mongoose. will trigger an intellisense menu with mongoose nodelib ...

javascriptnode.jsvisual-studio-codeauto-import

The express-handlebars module is having trouble parsing HTML within the main layout file in an Express.js application

Hello, I am facing an issue with handlebars as it is not reading the HTML in my file. Here is a screenshot highlighting the problem along with the provided code. The folder structure is as follows: views layouts main-layout.hbs home.hbs https://i ...

htmlnode.jsexpresshandlebars.jsexpress-handlebars

I recently updated my node to version 0.8 and encountered a new issue with the sys/util functionality

After upgrading from node v0.6.12 to 0.80, I encountered the following error message - I have removed the sys module from the import but am still facing this issue. Any advice or suggestions would be greatly appreciated. Also, it's worth noting that I ...

node.js