docker: Error response from daemon: driver failed programming external connectivity on endpoint elastic_burnell (bbb96e9369be6119024bb5ccfc223fdf92b2a06ecc70c88e1f0397e389a608f5): Error starting userland proxy: listen tcp 0.0.0.0:80: bind: address already in use.

https://theoephraim.github.io/node-google-spreadsheet/#/guides/migration-guide

I have Docker on my Synology and installed this container but can't access it. Tried using the Synology IP with the port 4545 locally.

Hi,
I new to node.js and express.
I had successfully run the service and able to use basic.html and get authorise to Unifi guest access.

may I know which section authorise.js I should place :

// Insert data into database table
let post = {name: 'joe', mobile: '81234567', email: '[email protected]'};
let sql = 'INSERT INTO free_wifi SET ?';
let query = db.query(sql, post, (err, result) => {
if (err) throw err;
console.log(result);
res.send('1 row data added...');
});

I am trying to save the name, mobile and email in form to mysql.

I am able to test connect to mysql successful:

const mysql = require('mysql')

// Create MySQL Connection
const db = mysql.createConnection({
host: "10.0.0.1",
user: "dbuser",
password: "dbpassword",
database: "dbname"
});

// Connect MySQL
db.connect((err) => {
if (err){
throw err;
}
console.log("Database Connected!");
});

Thank you.

Hi @woodjme

I am researching a solution to authorize our users through their Office365 login.

Did you consider, or maybe already make tests to integrate this type of functionality?

Here's the Microsoft Tutorial on how to authorize through O365. https://learn.microsoft.com/en-us/entra/identity-platform/tutorial-v2-nodejs-webapp-msal

I would be willing to work on a Pull Request for this, but only if it's something that you would consider merging.

Hi Jamie,

As discussed I'm working on a project in which it is required that users fill a form containing fields like Name, Email, Phone, ID, etc before they are allowed to use WiFi. This information will then be saved into an online database (like Google Sheets or SQL) after validation of fields filled by a user.

Also, another common feature required by users is to be able to change the background of portal page or add their company's logo to it.

Could you please consider adding these features to this project? They are very commonly required and would help many people.