::'''NOTE:''' if statement switches are:<blockquote> ' ''-d''': = directory<br /> 'or ''-f'''= file :or  zcat app.sql.gz |mysql -u$HDA_DB_USERNAME -p$HDA_DB_PASSWORD $HDA_DB_DBNAME : or  filemysql -u$HDA_DB_USERNAME -p$HDA_DB_PASSWORD $HDA_DB_DBNAME </blockquote>app.sql;

<pre style="white-space: pre-wrap; word-break: keep-all;">echo "alter database appdb charset=utf8" | mysql -uappdb u$HDA_DB_USERNAME -pappdbp$HDA_DB_PASSWORD</pre> === Large Database Load ===For restoring large SQL files, include the following lines at the beginning of the file. This will disable key checks that are not necessary when restoring a database dump, speeding up load time: SET @@session.unique_checks = 0; SET @@session.foreign_key_checks = 0; or <pre style="white-space: pre-wrap; word-break: keep-all;">mysql --max_allowed_packet=128M -u$HDA_DB_USERNAME -p$HDA_DB_PASSWORD $HDA_DB_DBNAME < app.sql;</pre> === Backup App Config on Uninstall === echo Backing up config to sharename share; cp -r ../filename /var/hda/files/sharename/filename-$(date +%Y%m%d%H%M%S); chown apache:users /var/hda/files/sharename/filename*;

=== Add Server (Service) Feature Functions ===* Install ScriptFedoraCheck if service is active: cat > installscript.sh << 'EOF' install systemctl is-m 755 appname /etc/init.d/;active service * Enable/sbin/chkconfig appname on; /sbinDisable and start/stop service appname start;: EOF chmod 755 installscript.sh; sudo ./installscript.sh; cd ..; rm systemctl enable --rf elevated;Ubuntu: cat > installscript.sh << 'EOF'now service install systemctl disable -m 755 appname /etc/init.d/; update-rc.d appname defaults; now service appname start; EOF chmod 755 installscript.sh; sudo ./installscript.sh;* Reload system daemon cd ..echo Reloading systemctl daemon; rm systemctl daemon-rf elevatedreload;* Uninstall ScriptFedora: mkdir elevated; cd elevated; cat > uninstallscript.sh << 'EOF' Start/sbinStop/Restart app service appname stop; /sbin/chkconfig echo Starting appname offservice; rm -f /etc/init.d/systemctl start appname; EOF chmod 755 uninstallscript.shservice; sudo ./uninstallscript.shecho Stopping appname service; cd .systemctl stop appname.service; rm -rf elevatedecho Restarting appname service;Ubuntu: mkdir elevatedsystemctl restart appname.service; cd elevated; cat > uninstallscript.sh << * Restart Service if 'EOFactive' if [ `systemctl is-active appname.service appname stop` == "active" ];then update-rcecho Restarting appname.service.d -f appname remove; rm -f /etc/init.d/appname; EOF chmod 755 uninstallscript.sh; sudo systemctl restart appname./uninstallscript.sh;service cd ..;echo Done! rm -rf elevated;fi

:Edit the service, i.e. ''/etc/init.d/adito'' and change the parameters (Run level: 0-6, start priority: 1-99, and stop priority: 1-99).

:Execute the following command as '''root''' user:

<blockquote>:<u>Fedora 19-25 (PHP5)</u><pre><Files *.php> values or flags</Files></pre>:<u>Fedora 27 or greater (PHP7)</u><pre><IfModule mod_php7.c>values or flags</IfModule></pre>:Values and Flags for use with above:<pre>php_value memory_limit 256Mphp_flag short_open_tag on php_flag magic_quotes_gpc Off php_flag magic_quotes_sybase Off php_flag magic_quotes_runtime Off php_flag register_globals Off php_flag session.auto_start Off php_flag suhosin.session.encrypt Off php_value output_buffering Offphp_value upload_max_filesize 20M php_value post_max_size 100M php_value max_execution_time 300 php_value zend.enable_gc off php_value default_charset "UTF-8" php_value iconv.input_encoding "UTF-8" php_value iconv.internal_encoding "UTF-8" php_value iconv.output_encoding "UTF-8" php_value mbstring.internal_encoding UTF-8 php_value mbstring.http_output UTF-8 php_value mbstring.encoding_translation On php_value mbstring.func_overload 6</pre> </Filesblockquote>* Displays PHP Modules Installed php -m* Apache mod_rewrite to allow use of .htaccess for Fedora 19 /21/23/25/27 (replace similar lines above ''</Directory>''):

'''AllowOverride All'''

:or<pre style="white-space: pre-wrap; word-break: keep-all;">HDADOM=$(echo "SELECT value FROM settings WHERE name='domain'" | mysql hda_production -uamahihda -pAmahiHDARulez -s)</pre>

<pre style="white-space: pre-wrap; word-break: keep-all;">HDAIP=$(/sbin/ip -o -4 addr list $HDA_DEVICE | awk '{print $4}' | cut -d/ -f1);</pre>or* HDA Broadcast IP<pre HDAIPstyle="white-space: pre-wrap; word-break: keep-all;">HDA_BIP=`ip addr show |grep -w inet |egrep -v '(127.0.0.1|tun)' |awk '{ print $(/sbin4}'`</pre>* HDA MAC Address HDA_MAC=`ip addr show | grep -o w ether | awk '{ print $2 }'`* HDA Netmask<pre style="white-space: pre-wrap; word-break: keep-4 all;">HDA_NET=`ip addr list $INTFC show |grep -w inet |egrep -v '(127.0.0.1|tun)' | awk '{print $42}' | cut -d"/" -f 2`</ pre>* HDA Subnet<pre style="white-space: pre-wrap; word-break: keep-all;">HDA_SUB=`netstat -r |egrep -f1v '(Kernel|Destination|default|10|docker0)' |awk '{ print $1}'`</pre>

:or<pre style="white-space: pre-wrap; word-break: keep-all;">FUSER=$(echo "SELECT login FROM users WHERE admin=1 ORDER BY id ASC LIMIT 1" | mysql hda_production -uamahihda -pAmahiHDARulez -s)* Arch (32- or 64-bit): ARCH=`getconf LONG_BIT` if [ "$ARCH" = "64" ]; then # 64-bit else # 32-bit fi</pre>

<pre style="white-space: pre-wrap; word-break: keep-all;">FVER=`cat /etc/fedora-release | awk -F'release ' '{print $2}' | sed 's/(Laughlin)//'`;</pre>

:or<pre style="white-space: pre-wrap; word-break: keep-all;"> FVER=`cat /etc/fedora-release | awk -F'release ' '{print $2}' | sed 's/(Verne)//'`;

fi</pre>* Install Ubuntu (DEB) or Fedora (RPM) package

===MiscellaneousSED One-Liners===* Suppress Console OutputUpdate application domain: command &sed -i 's|<nowiki> http:/dev/nullapp</nowiki>|<nowiki>http://app</nowiki>.'"$HDA_DOMAIN"'|' app.sql;* Remove Blank Lines From Fileblank lines from file:

* Delete lines in file: sed '/pattern/d' file* Add lines before pattern:<pre>sed -i '/pattern/i \line1 \line2' file</pre>* Add lines after pattern:<pre>sed -i '/pattern/a \line1 \line2​' file</pre>* Insert line based on text1 (Previous Line):

:with variables

and :without variables

* Redirect to specific URL (change ''url='' to desired path (i.e. <nowiki>http://appname/appdirectory</nowiki>):Change ownership of symbolic link<pre>echo '<!DOCTYPE HTML PUBLIC " chown -h username:users /var/W3C//DTD HTML 4.0 Transitionalhda/files/EN"><html><head>share<title>Your Page Title</title><meta http-equiv="REFRESH" content="0;url=http://www.the-domain-you-want-to-redirect-to.com"></HEAD><BODY>Optional page text here.</BODY></HTML>' > html/index.htmlchown apache:users html/index.html</pre>* Netboot [[Netboot_templateNetboot_Template|App Template]]===

# IfWith the following features:#* File If the file path doesn't start with / it's relative to /var/run/ (i.e. named:named/named.pid -> /var/run/named/named.pid)#* If the PID file path starts with /, then it's used as is#* No If no PID file path specified, then the PID file is assume to be /var/run/<name>.pid#* Does If it does not exist, otherwise the platform will do a <i>pgrep</i> <name>#* Returns If it returns something, it's assumed it will be valid PIDs for that service

See [http://blog.hqcodeshop.fi/archives/93-Handling-varrun-with-systemd.html Handling /var/run with systemd] for details.

ExecStartPre=-/usr/bin/mkdir -p /var/run/dhis