
- About JET
- Administration
- Creating an App
- Basic Functions
- Advanced Functions
- Automation Parameters
- Field Value Selection
- Field Value Formatting
- Field Value Manipulation
- Total Count of a Form
- Total Sum of Field
- Minimum Value of Field
- Maximum Value of Field
- Average Value of Field
- Site Level Parameters - Site Name
- Site Level Parameters - Login User
- Site Level Parameters - Login User Email
- Owner Email
- Check Permission Group
- Date Time Addition
- Email Image
- CheckBox Condition
- Usage of Time Fields
- Parent Form Updates
- 3rd Party API
- Other Features
- Known Issues & Solutions
- Linux
- Windows
- FAQ (JET)
10.1.How to setup JET (Linux)
Install Lamp Server
Installing Lamp server will install php web services and mysql onto your linux server. Please type in the following command in your linux console.
$ sudo apt-get install lamp-server^


Note: You may be required to get the latest list of available packages and their versions for your OS first. To do this, run:
$ sudo apt-get update
Resetting mysql password
By default in a fresh installation, mysql root user has a default value for authentication. This may be ‘auth_socket’ or something else.
To ensure that the password will work, it needs to be setup with ‘caching_sha2_password’ authentication.
Below are the steps to do so.
$ sudo mysql -u root
>USE mysql;
>UPDATE user
SET plugin = 'caching_sha2_password', authentication_string = ''
WHERE User = 'root' AND Host = 'localhost';
>FLUSH PRIVILEGES;
>ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password123';
>FLUSH PRIVILEGES;
>Quit
$ sudo mysql_secure_installation
Enable password validation policy → (Choose Yes)
Remove anonymous users → (Choose Yes)
Disallow root login remotely → (Choose Yes)
Remove test database → (Choose Yes)
Reload privileges → (Choose Yes)
$ sudo systemctl restart mysql
Update permissions of the web service folder
Run the commands below to navigate to the /var/www folder and update the permissions of the web service folder:
$ cd /var/www
$ sudo chmod a=rwx html

Symbolic links for data drive
Skip the previous step if you are doing this.
This is meant for if you have a separate Data disk from the OS disk.
$ sudo cp -avr /var/www/html/. /data/application
$ sudo rm -r /var/www/html
$ sudo ln -sfn /data/application /var/www/html
sudo chmod a=rwx /data/application/
Pre-requisites (php 7.4 example)
- Install the Linux zip utility
$ sudo apt-get install unzip
$ sudo systemctl restart apache2
- Install the php zip PHP
$ sudo apt-get install php7.4-zip
$ sudo systemctl restart apache2
- Install the xmlrpc module in PHP
$ apt-get install php7.4-xmlrpc
$ sudo systemctl restart apache2
- Install the xml module in PHP
$ sudo apt-get install php7.4-xml
$ sudo systemctl restart apache2
- Install the curl module in PHP
$ sudo apt-get install php7.4-curl
$ sudo systemctl restart apache2
- Increase the file upload limit in PHP
- Access php.ini on your PHP installation
- Edit the following line with the appropriate value. In this example, I set it as 100M for both.
upload_max_filesize = 100M
post_max_size = 100M
-
- Restart the Apache service
$ sudo systemctl restart apache2
- Increase Memory Limit in PHP
- Access php.ini on your PHP installation
- Edit the following line with the appropriate value based on your server ram allocation.
memory_limit = 500M
-
- Restart the Apache service.
$ sudo systemctl restart apache2
Transfer the installer file into /var/www/html
Run the installer.php file on a web browser in the same network
Enter SQL credentials and Company ID.
Company ID can be retrieved from the email where you are issued when you purchased JET.

Create your default console login

Login to the console with the credentials you created above

After login, you can begin to create your sites and start using JET
