### Setup Websockify User and Environment

Source: https://hostbill.atlassian.net/wiki/spaces/DOCS/pages/602734593/upCloud

Creates a dedicated system user for Websockify, clones the repository, installs the package, and configures the necessary directory permissions for token storage.

```bash
adduser websockify
cd /home/websockify
git clone https://github.com/novnc/websockify.git
cd /home/websockify/websockify
python setup.py install --force
mkdir {$path}
chmod 0777 {$path}
chown -R websockify: /home/websockify
```

--------------------------------

### Download and Run PowerDNS Installation Script

Source: https://hostbill.atlassian.net/wiki/spaces/DOCS/pages/492106/www.atlassian.com

This sequence of commands first downloads the PowerDNS installation script from a specified URL using 'wget' and then executes the script using 'bash'. This script automates the installation process of PowerDNS.

```bash
wget http://install.hostbillapp.com/powerdns/install.sh
bash install.sh
```

--------------------------------

### Configure NASK Queue Daemon Commands

Source: https://hostbill.atlassian.net/wiki/spaces/DOCS/pages/714964993/NASK

Provides the necessary commands to manage the NASK queue daemon, including starting, stopping, and restarting the service. Requires Python to be installed and the commands to be added to the system's service manager.

```bash
start: _**{path to python}**_****_**{path to the NASK module}**_ /deamon/nask.py start
stop: _**{path to python}**_****_**{path to the NASK module}**_ /deamon/nask.py stop
restart: _**{path to python}**_****_**{path to the NASK module}**_ /deamon/nask.py restart
```

--------------------------------

### DHCP Configuration - Dedicated Files Example (Bash)

Source: https://hostbill.atlassian.net/wiki/spaces/DOCS/pages/246906881/Configuring%2BISC-DHCP%2Bfor%2BIPAM

This example demonstrates how to set up DHCP configuration using dedicated files. The generated configuration is saved to a specified file (e.g., /etc/dhcp/ipam.conf) and must be included in the main DHCP configuration file.

```bash
subnet 192.168.100.0 netmask 255.255.255.0 {
  range 192.168.100.50 192.168.100.150;
}

#generated by IPAM
include "/etc/dhcp/ipam.conf";

(...)
```

--------------------------------

### CentOS 7 NASK Queue Daemon Service Configuration

Source: https://hostbill.atlassian.net/wiki/spaces/DOCS/pages/714964993/NASK

Example configuration for setting up the NASK queue daemon as a service on CentOS 7 using systemd. This defines the commands for starting, stopping, and reloading the service, ensuring it remains active after restarts.

```bash
ExecStart=/usr/bin/python /home/hostbill/public_html/includes/modules/Domain/nask/deamon/nask.py start ExecStop=/usr/bin/python /home/hostbill/public_html/includes/modules/Domain/nask/deamon/nask.py stop ExecReload=/usr/bin/python /home/hostbill/public_html/includes/modules/Domain/nask/deamon/nask.py restart RemainAfterExit=yes
```

--------------------------------

### Upgrade PHP and Configure FPM

Source: https://hostbill.atlassian.net/wiki/spaces/DOCS/pages/3014230017/Upgrade%2BPHP%2B7.4%2Bto%2B8.1%2Bon%2BCentos%2B8

This command sequence removes the existing PHP installation, resets the PHP module stream, installs PHP 8.1 with Remi repository, installs essential PHP extensions and FPM, downloads and installs the ionCube loader for PHP 8.1, and copies over previous FPM configurations.

```bash
systemctl stop php-fpm
cp /etc/php-fpm.conf /root/ 
cp /etc/php-fpm.d/www.conf /root/  
yum remove php-fpm php-cli php-*
dnf module reset php
dnf -y module install php:remi-8.1
dnf -y install php-fpm php-cli php-json php-sodium php-xml php-bcmath php-gd php-imap php-snmp php-soap php-xml php-process php-mbstring php-pdo php-mysqlnd php-ldap    php-pecl-memcached   
cd /root/ 
wget http://downloads3.ioncube.com/loader_downloads/ioncube_loaders_lin_x86-64.zip -O /root/ioncube.zip
unzip -o ioncube.zip
cp /root/ioncube/ioncube_loader_lin_8.1.so /usr/lib64/php/modules/
chmod +x /usr/lib64/php/modules/ioncube_loader_lin_8.1.so
echo "zend_extension=ioncube_loader_lin_8.1.so" > /etc/php.d/10-ioncube.ini  
cp -f /root/php-fpm.conf /etc/php-fpm.conf
cp -f /root/www.conf /etc/php-fpm.d/www.conf  
systemctl start php-fpm
systemctl enable php-fpm 
```

--------------------------------

### MySQL Command Line Connection and Execution

Source: https://hostbill.atlassian.net/wiki/spaces/DOCS/pages/3508568065/Migration%2Bfrom%2BHexonet%2Bto%2BCentralNic%2BReseller%2Bmodule

This demonstrates how to connect to a MySQL database via the command line and execute SQL queries. It includes commands to log in to MySQL, select the target database, and then run the provided migration SQL query. Replace '{$database_name}' with your actual database name.

```bash
mysql;
use {$database_name};
-- Then execute the SQL query provided in the migration section.
```