teamviewer

AKPipPLMhkH89pfFhBJEik083jVsnExMEY3YfW3k1sna3MLgzoEhWQk9lpd7ekMf2lFMBpnitfpU9fG6)EuDhnZ22eiSf1BfW6Wo2P]hKtBn3SYUdZx]BtnVa0CN1ieVJC3i4EmV4cuYcl1OqfdPYnbw)mxJDVMQeQHC3cEQ1XAJp8Gw!

Activation code (Encripted)

0vergrive
5wGzI7D1fUWjD7xdKM8ikrb2p6QJz13]zkMz58uFU5IDxayDswXk1k6qeEOS3xgIEiGvxkBQwp8QyNw21WJS66Ai4vnwwlFdQRgyNC3QQJ5qkVUyjzDjlVTP)vmNMq64EtorXXudKhgPwKYCULGDU)C2bryqNZQrMA!
========================================================================

password

6102358222131
h03301

Userกลาง

OP-สสจ.ศรีสะเกษ วีระวุธ เพ็งชัย(Userกลาง)
530017954491
h00021

ฐานข้อมูลกลาง

CwN1Q0)MYJHCxI29uXqUf8Wt2gv2)Q5PJXWB]]iyj3aPasOBF)]pSZpiCP0m3M1sw]Zhbc]GVjDeBx]JcpouGdgzHElkCt86Z7rpFSblMA!

error

jhcis# sudo sh /var/jhcis/create-pdf.sh


Warning: FPDF::include(font/angsa.php): failed to open stream: No such file or directory in /opt/lampp/lib/php/fpdf.php on line 1145

Warning: FPDF::include(): Failed opening 'font/angsa.php' for inclusion (include_path='.:/opt/lampp/lib/php') in /opt/lampp/lib/php/fpdf.php on line 1145
FPDF error: Could not include font definition fileroot@jhcis-03301:/home/jhcis# sudo sh /var/jhcis/create-pdf.sh

xampp 1.7.1 ubuntu 18.04.6

(In red if use this mySQL for jhcisdb)

sudo su

sudo apt-get install lib32stdc++6

apt-get install libodbc1:i386
wget https://master.dl.sourceforge.net/project/xampp/XAMPP%20Linux/1.7.1/xampp-linux-1.7.1.tar.gz

tar -xf xampp-linux-1.7.1.tar.gz -C /opt

/opt/lampp/lampp start
/opt/lampp/etc/my.cnf

       bind-address = 0.0.0.0
       port = 3333

chmod 644 /opt/lampp/etc/my.cnf
/opt/lampp/bin/mysql
       UPDATE mysql.user SET Password=PASSWORD('123456') WHERE User='root';
       GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '123456';

       GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '';
FLUSH PRIVILEGES;
/opt/lampp/lampp restart
/opt/lampp/bin/mysql --port=3333 -u root -p
opt/lampp/phpmyadmin/config.inc.php
       Password = '123456';

==============================================================

/opt/lampp/phpmyadmin/config.inc.php

        /* Authentication type and info */

//$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['host'] = '127.0.0.1:3333';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = '123456';

$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

mysql-backup-jhcisdb.sh

# !/bin/sh
    sudo mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /var/www/jhcisbackup/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql

cd /var/www/jhcisbackup/
FILE=jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql
if [ -f "$FILE" ]; then
     sudo zip -r jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").zip "$FILE"
fi

cd /var/www/jhcisbackup/
FILE=jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").zip
if [ -f "$FILE" ]; then
     sudo rm -f /var/www/jhcisbackup/jhcisdb-03301.$(date -d "-0 day" "+%Y-%m-%d").sql
     sudo rm -f /var/www/jhcisbackup/jhcisdb-03301.$(date -d "-73 day" "+%Y-%m-%d").zip
     sudo rm -f /var/www/jhcisbackup/jhcisdb-03301.$(date -d "-73 day" "+%Y-%m-%d").zip
fi

crontab

# m h dom mon dow user  command
17 *    * * *   root    cd / && run-parts --report /etc/cron.hourly
25 6    * * *   root    test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
47 6    * * 7   root    test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.weekly )
52 6    1 * *   root    test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.monthly )
0 0-23  * * 0-6 root    /var/jhcis/mysql-backup-jhcisdb.sh >/dev/null 2>&1
0 0-23  * * 0-6 root    /var/jepidem/runjepidem.sh >/dev/null 2>&1
0 17-19 * * 0-6 root    /var/jxp18/runjxp18.sh >/dev/null 2>&1
0 13-14 * * 0-6 root    /var/jautoup/runjauto.sh >/dev/null 2>&
*/5 * * * * root sh /var/jhcis/create-pdf.sh >/dev/null 2>&1
*/5 * * * * root /usr/bin/rsync -a /var/www/html/fpdf17/MyPDF/MyPDF.pdf /home/jhcis/Dropbox/MyPDF.pdf >/dev/null 2>&1
#

jre8

/home/jhcis/Downloads

sudo tar zxvf jre-8u241-linux-x64.tar.gz -C /usr/lib/jvm

sudo update-alternatives --install "/usr/bin/java" "java" "/usr/lib/jvm/jre1.8.0_241/bin/java" 1

sudo update-alternatives --config java

Lamp ubuntu 18.04.3

https://www.ostechnix.com/install-apache-mysql-php-lamp-stack-on-ubuntu-18-04-lts/

เครดิต serverpilot https://serverpilot.io/docs/how-to-disable-strict-mode-in-mysql-5-7/

How to Disable Strict SQL Mode in MySQL 5.7

If your app was written for older versions of MySQL and is not compatible with strict SQL mode in MySQL 5.7, you can disable strict SQL mode. For example, apps such as WHMCS 6 and Craft 2 do not support strict SQL mode.

If you're using WHMCS 7, see our article on customizing MySQL for WHMCS 7.

To disable strict SQL mode, SSH in to your server as root and create a new configuration file using nano or the editor of your choice:

sudo nano /etc/mysql/conf.d/disable_strict_mode.cnf

In the file, enter these two lines:

[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Save the file by pressing CTRL + X, then y, then ENTER to confirm changes.

Finally, restart MySQL with this command:

sudo service mysql restart

This change disables two SQL mode settings, STRICT_TRANS_TABLES and ONLY_FULL_GROUP_BY, that were added in MySQL 5.7 and cause problems for some older applications.

Confirming Strict SQL Mode Is Disabled

You can confirm strict SQL mode is disabled by running this command as root:

sudo mysql -i -BN -e 'SELECT @@sql_mode' | grep -E 'ONLY_FULL_GROUP_BY|STRICT_TRANS_TABLES'

If strict mode is disabled, you won't see any output from that command.

If disabling strict mode causes any problems for you, you can re-enable it by deleting that file and restarting MySQL again.

What Strict SQL Mode Errors Look Like

If your app isn't compatible with strict SQL mode, you'll often see SQL errors such as:

SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of
SELECT list is not in GROUP BY clause and contains nonaggregated column
'yourdbname.tblannouncements.date' which is not functionally dependent on
columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Last updated: October 6, 2016

mysql command prompt

cd\
cd C:\Program Files\JHCIS\MySQL\bin
C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p

mysql> SHOW VARIABLES LIKE "%version%";

mysql> SHOW VARIABLES;