A Nodejs Express Website on IBM i

This repo contains a NodeJS Express website that runs on IBM i. It shows full database maintenance features of a table/physical file on the IBM i. The application will show a signon screen that must be provided prior to the employee table maintenance features being enabled.

Pre-reqs

This application requires Node.js on IBM i at least version 8

Install Instructions

These commands need to be run in a QSHELL or (preferably) SSH session on your IBM i. If using QSH, you must first set the QIBM_MULTI_THREADED environment variable to Y before starting your QSH session.

ADDENVVAR ENVVAR(QIBM_MULTI_THREADED) VALUE(Y) REPLACE(*YES)

If you do not, commands may fail with qsh: 001-0078 Process ended by signal 5..

Clone the repository

Issue the following command to clone the repo

git clone https://github.com/AndyYouens/NodeExpress-IBMi.git

Move into the new directory

cd NodeExpress-IBMi

Install all dependancies

npm install

Generate SSL Certificates

Need to swap over to certs directory & generate SSL certs

pushd certs
openssl genrsa -out privatekey.pem 2048
openssl req -new -key privatekey.pem -out certrequest.csr
openssl x509 -req -in certrequest.csr -signkey privatekey.pem -out certificate.pem -days 730
popd

Generate Schema & Tables

To create the schema & tables, then, populate with sample data, run the following command

system "RUNSQLSTM SRCSTMF('public/sql/employee.sql')"

Start application

The application will run, by default, on port 3333. If you want to use a different port, run the following command before the application is started.

export PORT=9090

then run

npm start

or to run in debug mode

npm run debug

Point your browser to the application

Point your browser to https://your_ibmi:3333

Ignore any browser security issues that appear.

Then hopefully, you will see the application running on the IBM i & you can maintain the table within it.

🧑‍🏫 Still Training

We are still providing IBM i training in these strange times. Get in contact here.

If you have any questions or comments, we will be happy to help you.

📹 Our IBM i Training Videos

While you are here, why not visit our training videos, which can be found here.

✔️ YouTube Videos

• Our YouTube channel can be found here.
• Subscribe to our YouTube channel to get the latest news & updates on our Training videos at this link.

Authors

FormaServe Systems Ltd - All work - FormaServe

License

• MIT license
• © 1990 - 2021 FormaServe Systems Ltd

Acknowledgments

Andy Youens - FormaServe Systems Ltd

🚩 Connect with us

• LinkedIn: https://linkedin.com/in/andyyouens
• Twitter: https://twitter.com/AndyYouens
• Twitter: https://twitter.com/FormaServe
• Website: https://learning.formaserve.co.uk
• Website: https://www.formaserve.co.uk

☕Support

 

 

Copyright

© 1990 - 2022 FormaServe Systems Ltd

Open Source on IBM i - Oh Yea

😉