Origami_Wiki - User contributions [en]

Septage vendor assignment

2026-02-23T12:45:02Z

WikiAdmiN:

Use following query to diagnose why a booking is not getting assigned

<pre>
SELECT da_id FROM

(SELECT login.da_id,COALESCE(login.da_last_requested_time,'2019/01/01') AS last_requested_time FROM st_septage_booking AS booking

LEFT JOIN capcityview AS cg ON cg.subvcgid = booking.sb_vcg_id

INNER JOIN st_septage_registration AS reg ON reg.sr_vcg_id =cg.mainvcgid AND reg.deleted=0 AND reg.sr_license_status =1 AND reg.sr_corp_vehicle = corpbooking AND ((reg.sr_pumping_type=booking.sb_pumping_type AND booking.sb_pumping_type!=3) OR (booking.sb_pumping_type=3))

LEFT JOIN st_hose_length AS hl ON hl.hl_id = booking.sb_road_distance AND hl.deleted=0

LEFT JOIN st_septage_road_width AS rw ON rw.rw_id = reg.sr_road_width AND rw.deleted=0

LEFT JOIN st_septage_road_width AS booking_rw ON booking_rw.rw_id = booking.sb_road_width AND booking_rw.deleted=0

LEFT JOIN st_septage_driver_auth AS login ON login.da_sr_id = reg.sr_id AND login.deleted=0 AND login.status =1 AND login.da_auto_status =1 --for only logined driver users

WHERE rw.rw_value<=booking_rw.rw_value AND reg.sr_allowself=1 AND reg.sr_pipe_length>=hl.hl_to_length AND login.da_is_login=2 AND booking.sb_id=bookingid AND login.da_current_status=1

AND da_id NOT IN (SELECT va_da_id FROM st_septage_booking_vendor_assignment WHERE deleted=0 AND va_status=1)

ORDER BY login.da_last_requested_time)

AS vendor ORDER BY last_requested_time

LIMIT 1;
</pre>

Septage vendor assignment

2026-02-23T12:42:43Z

WikiAdmiN: Created page with "<pre> SELECT da_id FROM (SELECT login.da_id,COALESCE(login.da_last_requested_time,'2019/01/01') AS last_requested_time FROM st_septage_booking AS booking LEFT JOIN cap..."

<pre>
SELECT da_id FROM

(SELECT login.da_id,COALESCE(login.da_last_requested_time,'2019/01/01') AS last_requested_time FROM st_septage_booking AS booking

LEFT JOIN capcityview AS cg ON cg.subvcgid = booking.sb_vcg_id

INNER JOIN st_septage_registration AS reg ON reg.sr_vcg_id =cg.mainvcgid AND reg.deleted=0 AND reg.sr_license_status =1 AND reg.sr_corp_vehicle = corpbooking AND ((reg.sr_pumping_type=booking.sb_pumping_type AND booking.sb_pumping_type!=3) OR (booking.sb_pumping_type=3))

LEFT JOIN st_hose_length AS hl ON hl.hl_id = booking.sb_road_distance AND hl.deleted=0

LEFT JOIN st_septage_road_width AS rw ON rw.rw_id = reg.sr_road_width AND rw.deleted=0

LEFT JOIN st_septage_road_width AS booking_rw ON booking_rw.rw_id = booking.sb_road_width AND booking_rw.deleted=0

LEFT JOIN st_septage_driver_auth AS login ON login.da_sr_id = reg.sr_id AND login.deleted=0 AND login.status =1 AND login.da_auto_status =1 --for only logined driver users

WHERE rw.rw_value<=booking_rw.rw_value AND reg.sr_allowself=1 AND reg.sr_pipe_length>=hl.hl_to_length AND login.da_is_login=2 AND booking.sb_id=bookingid AND login.da_current_status=1

AND da_id NOT IN (SELECT va_da_id FROM st_septage_booking_vendor_assignment WHERE deleted=0 AND va_status=1)

ORDER BY login.da_last_requested_time)

AS vendor ORDER BY last_requested_time

LIMIT 1;
</pre>

Jenkins Deployment Setup

2026-01-14T14:45:22Z

WikiAdmiN:

==Purpose==

This document describes how to configure Jenkins to deploy a Laravel application to a server using SSH, GitHub, and a Jenkins Pipeline.

==Architecture Overview==
GitHub (Repository)
|
| Webhook
v
Jenkins Pipeline Job
|
| SSH
v
Application Server (deploy user)

==1. Server Preparation==
===1.1 Create Deploy User (Application Server)===

Important: Never deploy using root.
<code>
sudo adduser deploy
sudo usermod -aG www-data deploy
</code>
1.2 Directory Ownership & Permissions
sudo mkdir -p /opt/ksrtc_sandbox
sudo chown -R deploy:www-data /opt/ksrtc_sandbox
sudo chmod -R 775 /opt/ksrtc_sandbox

Laravel required writable directories:

sudo chown -R deploy:www-data storage bootstrap/cache
sudo chmod -R 775 storage bootstrap/cache

1.3 Install Required Software
sudo apt update
sudo apt install -y git unzip

Install Composer:

curl -sS https://getcomposer.org/installer | php
sudo mv composer.phar /usr/local/bin/composer

2. Jenkins Server Preparation
2.1 Verify Jenkins User
ps -ef | grep jenkins

Jenkins runs as:

jenkins

3. SSH Key Setup
3.1 Generate SSH Key for Jenkins
sudo su - jenkins
cd ~/.ssh
ssh-keygen -t rsa -b 4096 -m PEM -f git-ssh-ksrtc-deploy

Generated files:

git-ssh-ksrtc-deploy (private key)
git-ssh-ksrtc-deploy.pub (public key)

3.2 Add Public Key to Application Server
su - deploy
mkdir -p ~/.ssh
nano ~/.ssh/authorized_keys

Paste the contents of:

git-ssh-ksrtc-deploy.pub

Set permissions:

chmod 700 ~/.ssh
chmod 600 ~/.ssh/authorized_keys

3.3 Add Public Key to GitHub

GitHub → Repository Settings → Deploy Keys

Paste git-ssh-ksrtc-deploy.pub

Enable Read access

4. Jenkins Credentials Configuration

Jenkins → Manage Jenkins → Credentials → Global

Create credential:

Kind: SSH Username with private key

ID: git-ssh-ksrtc-deploy

Username: deploy

Private Key: Paste full private key

Save

5. Jenkins Job Creation
5.1 Create Pipeline Job

Jenkins Dashboard → New Item

Name: KSRTC-Ads

Type: Pipeline

Click OK

5.2 Job Configuration
General

Enable Discard old builds (optional)

Disable Concurrent builds

5.3 GitHub Project

Enable GitHub Project and set:

git@github.com:origamitechnologies/ksrtc_bus_ad_platform_laravel.git

5.4 Triggers

Enable:

GitHub hook trigger for GITScm polling

Jenkins Deployment Setup

2026-01-14T14:42:55Z

WikiAdmiN: Created page with "Jenkins Deployment Setup – Step-by-Step Guide Purpose This document describes how to configure Jenkins to deploy a Laravel application to a server using SSH, GitHub, and a..."

Jenkins Deployment Setup – Step-by-Step Guide
Purpose

This document describes how to configure Jenkins to deploy a Laravel application to a server using SSH, GitHub, and a Jenkins Pipeline.

Architecture Overview
GitHub (Repository)
|
| Webhook
v
Jenkins Pipeline Job
|
| SSH
v
Application Server (deploy user)

1. Server Preparation
1.1 Create Deploy User (Application Server)

Important: Never deploy using root.

sudo adduser deploy
sudo usermod -aG www-data deploy

1.2 Directory Ownership & Permissions
sudo mkdir -p /opt/ksrtc_sandbox
sudo chown -R deploy:www-data /opt/ksrtc_sandbox
sudo chmod -R 775 /opt/ksrtc_sandbox

Laravel required writable directories:

sudo chown -R deploy:www-data storage bootstrap/cache
sudo chmod -R 775 storage bootstrap/cache

1.3 Install Required Software
sudo apt update
sudo apt install -y git unzip

Install Composer:

curl -sS https://getcomposer.org/installer | php
sudo mv composer.phar /usr/local/bin/composer

2. Jenkins Server Preparation
2.1 Verify Jenkins User
ps -ef | grep jenkins

Jenkins runs as:

jenkins

3. SSH Key Setup
3.1 Generate SSH Key for Jenkins
sudo su - jenkins
cd ~/.ssh
ssh-keygen -t rsa -b 4096 -m PEM -f git-ssh-ksrtc-deploy

Generated files:

git-ssh-ksrtc-deploy (private key)
git-ssh-ksrtc-deploy.pub (public key)

3.2 Add Public Key to Application Server
su - deploy
mkdir -p ~/.ssh
nano ~/.ssh/authorized_keys

Paste the contents of:

git-ssh-ksrtc-deploy.pub

Set permissions:

chmod 700 ~/.ssh
chmod 600 ~/.ssh/authorized_keys

3.3 Add Public Key to GitHub

GitHub → Repository Settings → Deploy Keys

Paste git-ssh-ksrtc-deploy.pub

Enable Read access

4. Jenkins Credentials Configuration

Jenkins → Manage Jenkins → Credentials → Global

Create credential:

Kind: SSH Username with private key

ID: git-ssh-ksrtc-deploy

Username: deploy

Private Key: Paste full private key

Save

5. Jenkins Job Creation
5.1 Create Pipeline Job

Jenkins Dashboard → New Item

Name: KSRTC-Ads

Type: Pipeline

Click OK

5.2 Job Configuration
General

Enable Discard old builds (optional)

Disable Concurrent builds

5.3 GitHub Project

Enable GitHub Project and set:

git@github.com:origamitechnologies/ksrtc_bus_ad_platform_laravel.git

5.4 Triggers

Enable:

GitHub hook trigger for GITScm polling

Crontab Pointers

2025-10-20T06:50:33Z

WikiAdmiN: Created page with "Step-by-step: Edit apache’s crontab Backup first sudo crontab -u apache -l > ~/apache_cron_backup_$(date +%Y%m%d).txt Open Editor sudo crontab -u apache -e When vi open..."

Step-by-step: Edit apache’s crontab

Backup first
sudo crontab -u apache -l > ~/apache_cron_backup_$(date +%Y%m%d).txt

Open Editor
sudo crontab -u apache -e

When vi opens:

Clear everything:

gg
dG

Paste your fresh cron entries:

Save and exit:

:wq

Confirm:

sudo crontab -u apache -l

Docker Commands

2025-10-05T07:32:54Z

WikiAdmiN:

<code>mvn clean package

docker build -t travansoft/qp-gis-tools:latest .

docker push travansoft/qp-gis-tools:latest

sudo docker compose stop

sudo docker compose pull qp-gis-tools

sudo docker compose up -d
</code>

Docker Commands

2025-10-05T07:32:41Z

WikiAdmiN:

<code>mvn clean package
docker build -t travansoft/qp-gis-tools:latest .
docker push travansoft/qp-gis-tools:latest

sudo docker compose stop
sudo docker compose pull qp-gis-tools
sudo docker compose up -d
</code>

Postgres basics

2021-06-13T07:54:41Z

WikiAdmiN:

Get postgres prompt

su postgres 
psql 
postgres=# 

su postgres 
psql <dbname> 

[edit] List databases 

postgres=# \l 

[edit] List users 

postgres=# \du 

[edit] Dump a database 

su postgres 
pg_dump <dbname> > db.out 

[edit] Import a database 

su postgres 
psql -d <dbname> -f db.out 

[edit] Create role 

createuser -S -D -R <role_name> 

PG RESTORE COMMAND 
------------------ 
pg_restore -h localhost -U origami_dbadmin -d kvvs -W kvvs_20170316_22_00_01.tar 

PG DUMP COMMAND 
------------------- 
pg_dump -Ft -U origami_dbadmin ddugky_misdbnew -x -O -f "/var/www/html/ddugky_mis_2/ddugky_misdb.tar" 

PG DUMP WITHOUT VERSION PROBLEMS (plain format dump file) 
------------------------------------------------------------ 
pg_dump -f ddugky_misdbnew.db -F p -U origami_dbadmin ddugky_misdbnew 
pg_dump -U username dbname > dump.sql 

PG RESTORE WITHOUT VERSION PROBLEMS (plain format dump file) 
------------------------------------------------------------ 
psql -f ddugky_misdbnew.db dd_misdb origami_dbadmin 

== Restoration Command Summary==

sudo -i
su postgres
psql
CREATE DATABASE mykalamasserydb
CREATE USER mykalauser WITH ENCRYPTED PASSWORD 'pass';
GRANT ALL PRIVILEGES ON DATABASE mykalamasserydb TO mykalauser;
\q
gzip -d mykalamassery_06_13_2021.sql.gz
psql -U mykalauser -d mykalamasserydb -f mykalamassery_06_13_2021.sql

[[category:it-support]]

Postgres basics

2021-06-13T07:54:02Z

WikiAdmiN:

Get postgres prompt

su postgres 
psql 
postgres=# 

su postgres 
psql <dbname> 

[edit] List databases 

postgres=# \l 

[edit] List users 

postgres=# \du 

[edit] Dump a database 

su postgres 
pg_dump <dbname> > db.out 

[edit] Import a database 

su postgres 
psql -d <dbname> -f db.out 

[edit] Create role 

createuser -S -D -R <role_name> 

PG RESTORE COMMAND 
------------------ 
pg_restore -h localhost -U origami_dbadmin -d kvvs -W kvvs_20170316_22_00_01.tar 

PG DUMP COMMAND 
------------------- 
pg_dump -Ft -U origami_dbadmin ddugky_misdbnew -x -O -f "/var/www/html/ddugky_mis_2/ddugky_misdb.tar" 

PG DUMP WITHOUT VERSION PROBLEMS (plain format dump file) 
------------------------------------------------------------ 
pg_dump -f ddugky_misdbnew.db -F p -U origami_dbadmin ddugky_misdbnew 
pg_dump -U username dbname > dump.sql 

PG RESTORE WITHOUT VERSION PROBLEMS (plain format dump file) 
------------------------------------------------------------ 
psql -f ddugky_misdbnew.db dd_misdb origami_dbadmin 

== Restoration Command Summary==

sudo -i
su postgres
psql
CREATE DATABASE mykalamasserydb
CREATE USER mykalauser WITH ENCRYPTED PASSWORD 'MyKalaPass';
GRANT ALL PRIVILEGES ON DATABASE mykalamasserydb TO mykalauser;
\q
gzip -d mykalamassery_06_13_2021.sql.gz
psql -U mykalauser -d mykalamasserydb -f mykalamassery_06_13_2021.sql

[[category:it-support]]

Postgres basics

2021-06-13T07:53:02Z

WikiAdmiN:

Get postgres prompt

su postgres 
psql 
postgres=# 

su postgres 
psql <dbname> 

[edit] List databases 

postgres=# \l 

[edit] List users 

postgres=# \du 

[edit] Dump a database 

su postgres 
pg_dump <dbname> > db.out 

[edit] Import a database 

su postgres 
psql -d <dbname> -f db.out 

[edit] Create role 

createuser -S -D -R <role_name> 

PG RESTORE COMMAND 
------------------ 
pg_restore -h localhost -U origami_dbadmin -d kvvs -W kvvs_20170316_22_00_01.tar 

PG DUMP COMMAND 
------------------- 
pg_dump -Ft -U origami_dbadmin ddugky_misdbnew -x -O -f "/var/www/html/ddugky_mis_2/ddugky_misdb.tar" 

PG DUMP WITHOUT VERSION PROBLEMS (plain format dump file) 
------------------------------------------------------------ 
pg_dump -f ddugky_misdbnew.db -F p -U origami_dbadmin ddugky_misdbnew 
pg_dump -U username dbname > dump.sql 

PG RESTORE WITHOUT VERSION PROBLEMS (plain format dump file) 
------------------------------------------------------------ 
psql -f ddugky_misdbnew.db dd_misdb origami_dbadmin 

sudo -i
su postgres
psql
CREATE DATABASE mykalamasserydb
CREATE USER mykalauser WITH ENCRYPTED PASSWORD 'MyKalaPass';
GRANT ALL PRIVILEGES ON DATABASE mykalamasserydb TO mykalauser;
\q
gzip -d mykalamassery_06_13_2021.sql.gz
psql -U mykalauser -d mykalamasserydb -f mykalamassery_06_13_2021.sql

[[category:it-support]]

Rabbit MQ Installation

2021-05-27T06:52:43Z

WikiAdmiN:

For setting up Rabbit MQ on Aamzon Linux 2 run the following commands as root

curl -1sLf 'https://dl.cloudsmith.io/public/rabbitmq/rabbitmq-erlang/setup.rpm.sh' | sudo -E bash
rpm --import https://github.com/rabbitmq/signing-keys/releases/download/2.0/rabbitmq-release-signing-key.asc
rpm --import 'https://dl.cloudsmith.io/public/rabbitmq/rabbitmq-erlang/gpg.E495BB49CC4BBE5B.key'
rpm --import 'https://dl.cloudsmith.io/public/rabbitmq/rabbitmq-server/gpg.9F4587F226208342.key'
sudo yum install rabbitmq-server
chkconfig rabbitmq-server on
service rabbitmq-server start
service rabbitmq-server status

Once setup there may be an issue where by the rabbitmq-server wont start due to domain resolution issue. In that case open /etc/hosts file and an entry for the local domain to 127.0.0.1.
[[Category:it-support]]

Rabbit MQ Installation

2021-05-27T06:51:34Z

WikiAdmiN: Created page with "For setting up Rabbit MQ on Aamzon Linux 2 run the following commands as root curl -1sLf 'https://dl.cloudsmith.io/public/rabbitmq/rabbitmq-erlang/setup.rpm.sh' | sudo -E..."

Ionic Framework

2020-07-03T08:57:52Z

WikiAdmiN: New content from wikipedia

{{Infobox software
| name = Ionic
| logo = ionic-logo-landscape.svg
| logo size = 222px
| developer = Drifty<ref>{{cite web
| url=https://techcrunch.com/2014/03/10/drifty-makers-of-the-ionic-mobile-framework-raise-1-million/
| title=Drifty, Makers Of The Ionic Mobile Framework, Raise $1 Million
| date=10 March 2014
| accessdate=2015-03-14
| author=Sarah Perez}}</ref>
| released = {{Start date and age|2013}}
| latest release version = 5.0.7 <ref>{{cite web |url=https://github.com/ionic-team/ionic/releases/ |title=Ionic releases |url-status=live |accessdate=2020-04-09}}</ref>
| latest release date = {{Start date and age|2020|03|26|df=y}}
| programming language = [[JavaScript]]
| genre = [[Software framework]]
| license = [[MIT License]]
| website = {{URL|https://ionicframework.com/}}
}}
'''Ionic''' is a complete [[open-source software|open-source]] [[Software development kit|SDK]] for hybrid [[mobile app]] development created by Max Lynch, Ben Sperry, and Adam Bradley of Drifty Co. in 2013.<ref>{{cite web|title=Ionic Documentation Overview - License|author=Drifty, Inc|year=2016|url=http://ionicframework.com/docs/overview/#license}}</ref> The original version was released in 2013 and built on top of [[AngularJS]] and [[Apache Cordova]]. However, the latest release was re-built as a set of [[Web Components]], allowing the user to choose any user interface framework, such as [[Angular (web framework)|Angular]], [[React (JavaScript library)|React]] or [[Vue.js]]. It also allows the use of Ionic components with no user interface framework at all.<ref>https://blog.ionicframework.com/introducing-ionic-4-ionic-for-everyone/</ref> Ionic provides tools and services for developing hybrid mobile, desktop, and [[Progressive Web Apps]] based on modern web development technologies and practices, using Web technologies like [[CSS]], [[HTML5]], and [[Sass (stylesheet language)|Sass]]. In particular, mobile apps can be built with these Web technologies and then distributed through native [[app store]]s to be installed on devices by utilizing [[Apache Cordova | Cordova]] or Capacitor.<ref>{{Cite news|url=https://ionicframework.com/docs/intro/concepts/|title=Ionic Framework|last=Drifty|work=Ionic Framework|accessdate=2017-07-16|language=en}}</ref>