solved
เพิ่มเติม
Solved
command + space bar
start + space bar
Solved
ctrl + space bar
Ref
shif+command+3
shif+command+4
$ apache2ctl -M
Loaded Modules:
core_module (static)
so_module (static)
watchdog_module (static)
http_module (static)
log_config_module (static)
logio_module (static)
version_module (static)
unixd_module (static)
access_compat_module (shared)
alias_module (shared)
auth_basic_module (shared)
authn_core_module (shared)
authn_file_module (shared)
authz_core_module (shared)
authz_host_module (shared)
authz_user_module (shared)
autoindex_module (shared)
deflate_module (shared)
dir_module (shared)
env_module (shared)
filter_module (shared)
headers_module (shared)
mime_module (shared)
mpm_prefork_module (shared)
negotiation_module (shared)
php7_module (shared)
reqtimeout_module (shared)
rewrite_module (shared)
setenvif_module (shared)
socache_shmcb_module (shared)
ssl_module (shared)
status_module (shared)
userdir_module (shared)
Ref
ENV
$ sudo tail /var/log/apache2/error.log
AH00161: server reached MaxRequestWorkers setting, consider raising the MaxRequestWorkers setting
Solved
$ sudo nano /etc/apache2/sites-available/your_doman.conf
<IfModule mpm_prefork_module>
StartServers 4
MinSpareServers 20
MaxSpareServers 40
MaxRequestWorkers 200
MaxConnectionsPerChild 4500
</IfModule>
<IfModule mpm_prefork_module> StartServers 10 MinSpareServers 10 MaxSpareServers 20 ServerLimit 2000 MaxRequestWorkers 1500 MaxConnectionsPerChild 10000</IfModule>
$ sudo nano /etc/apache2/mods-available/mpm_prefork.conf
$ sudo systemctl restart apache2
$ sudo /etc/init.d/apache2 restart
Ref
$ netstat -tn 2>/dev/null | grep :80 | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -nr | headหรือ$ netstat -plan|grep :80|awk {'print $5'}|cut -d: -f 1|sort|uniq -c|sort -nk 1
$ netstat -tn 2>/dev/null | grep :80 | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -nr | head -n 1
Solved
#!/bin/bash
now=$(date)
url='https://your_site'
### admin line token
token="iFBqHnx34sHla9rAQ7Qxxxxxxxxxxxxxxxxxxxxx"
message="$url >>> non response >>> /etc/init.d/apache2 restart >>> $now"
i=0
j=0
## 0,1,2
until [ $i -gt 2 ]
do
echo i: $i
((i=i+1))
sleep 3s
status=$(curl --head --location --connect-timeout 5 --write-out %{http_code} --silent --output /dev/null ${url})
[[ $status == 500 ]] || [[ $status == 000 ]] && ((j=j+1)) # do start/restart logic
done
echo "J: $j"
if (( $j == 3 ))
then
echo "J == 3"
echo "restart ${url}: $now" >> /path/log_service_freezed.log
curl -X POST -H "Authorization: Bearer $token" -F "message=$message" https://notify-api.line.me/api/notify
/etc/init.d/apache2 restart
else
echo "J != 3"
fi
Ref
TypeError: Connection.__init__() takes 1 positional argument but 5 were given
Solved
connnection = pymysql.connect("localhost", "root", "", "dbname")
connection = pymysql.connect(host='localhost',user='root',password='',database='db_emp',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)
Ref
Solved
$ sudo apt install python3-pymysql
Add
$ sudo apt install python3-pip
Prerequire
$ sudo hostnamectl set-hostname meet.your_domain
$ sudo nano /etc/hosts
x.x.x.x meet.your_domain
$ sudo ufw disable
ติดตั้ง Library ที่จำเป็น
$ sudo apt install apt-transport-https
$ sudo apt install gnupg2
$ sudo apt install openjdk-8-jdk
ติดตั้ง Jitsi Meet
$ curl https://download.jitsi.org/jitsi-key.gpg.key -o jitsi-key.gpg.key
$ sudo gpg --output /usr/share/keyrings/jitsi-key.gpg --dearmor jitsi-key.gpg.key
$ sudo nano /etc/apt/sources.list.d/jitsi-stable.list
deb [signed-by=/usr/share/keyrings/jitsi-key.gpg] https://download.jitsi.org stable/
$ curl https://prosody.im/files/prosody-debian-packages.key -o prosody-debian-packages.key
$ sudo gpg --output /usr/share/keyrings/prosody-keyring.gpg --dearmor prosody-debian-packages.key
$ sudo nano /etc/apt/sources.list.d/prosody.list
deb [signed-by=/usr/share/keyrings/prosody-keyring.gpg] http://packages.prosody.im/debian jammy main
$ rm jitsi-key.gpg.key prosody-debian-packages.key
$ sudo apt update
$ sudo apt install jitsi-meet
https://meet.your_domain
คอนฟิกให้ผู้สร้างห้องต้องใส่ username และ password ก่อน
$ sudo nano /etc/prosody/conf.avail/your_domain.cfg.lau
authentication = "anonymous"
authentication = "internal_plain"
VirtualHost "guest.meet.your_domain"
authentication = "anonymous"
c2s_require_encryption = false
modules_enabled = {
"bosh";
"ping";
"pubsub";
"speakerstats";
"turncredentials";
"conference_duration";
}
$ sudo nano /etc/jitsi/meet/meet.your_domain-config.js
// anonymousdomain: 'guest.example.com',
anonymousdomain: 'guest.meet.your_domain',
$ sudo nano /etc/jitsi/jicofo/sip-communicator.properties
org.jitsi.jicofo.auth.URL=XMPP:meet.your_domain
$ sudo prosodyctl register user meet.your_domain password
$ sudo systemctl restart prosody.service jicofo.service jitsi-videobridge2.service
เพิ่มเติม
/etc/nginx/sites-available/meet.your_domain.conf
/etc/nginx/sites-enabled/
Ref
Solved
/etc/nginx/ssl
$ sudo nano /etc/nginx/sites-available/your_domain
listen 443 ssl;
......
ssl_certificate /etc/nginx/ssl/public_key.pem;
ssl_certificate_key /etc/nginx/ssl/private_key.pem;
$ sudo nginx -t
$ systemctl restart nginx
server {
listen 80;
listen 443 ssl;
server_name your_domain;
ssl_certificate /etc/nginx/ssl/public_key.pem;
ssl_certificate_key /etc/nginx/ssl/private_key.pem;
root /var/www/your_domain;
index index.html index.htm index.php;
location / {
try_files $uri $uri/ =404;
}
location ~ \.php$ {
include snippets/fastcgi-php.conf;
fastcgi_pass unix:/var/run/php/php8.0-fpm.sock;
}
location ~ /\.ht {
deny all;
}
}
Ref
$ sudo nano /etc/php/8.0/fpm/php.ini
$ sudo nano /etc/php/8.0/fpm/pool.d/www.conf
php_admin_value[memory_limit] = 512M
php_admin_value[max_execution_time] = 300
$ sudo systemctl restart nginx
$ sudo systemctl restart php8.0-fpm
Ref
structure + view + trigger
mysqldump --column-statistics=0 --no-data -B -h [host_remote] -u [user_remote] -p[pass_remote] [db_remote] > [file_export.sql]
function + procedure
mysqldump --column-statistics=0 --host=[host_remote] -B --user=[user_remote] --password=[pass_remote] --routines --no-create-info --no-data --no-create-db --skip-opt [db_remote] > [file_export.sql]
data
mysqldump --column-statistics=0 --no-create-info -B -h [host_remote] -u [user_remote] -p[pass_remote] [db_remote] > [file_export.sql]
Add
Ref
NO_AUTO_CREATE_USER
Solved
#!/bin/bash
file_replace="fn_mysql.sql"
search=",NO_AUTO_CREATE_USER"
replace=""
sed -i "s/$search/$replace/" $file_replace
Add
Ref
ERROR 1418 (HY000) at line 434: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
Solved
mysql> SET GLOBAL log_bin_trust_function_creators = 1;
Add
$ sudo nano /etc/nginx/sites-available/your_domain
try_files $uri $uri/ = 404;
try_files $uri $uri/ /index.php?$args;
try_files $uri $uri/ /subfolder/index.php?$arsg;
เพิ่มเติม
location / {try..... /index.php?$args;}location /sub1 {try..... /sub1/index.php?$args;}location /sub2 {try..... /sub2/index.php?$args;}
$ sudo apt install php8.0-fpm php8.0-mysql
$ sudo apt install php8.0-bcmath php8.0-bz2 php8.0-curl php8.0-intl php8.0-mbstring php8.0-mysql php8.0-readline php8.0-xml php8.0-zip php8.0-gd php8.0-gmp
วิธีแรก (ผู้เขียนเลือกวิธีแรก)
$ sudo update-alternatives --config php
วิธีสอง
$ sudo update-alternatives -set php /usr/bin/php8.0
$ sudo php -v
เปลี่ยน คอนฟิกไฟล์ default site หรือ vhost
$ sudo nano /etc/nginx/sites-available/your_domain
fasstcgi_pass unix:/var/run/php/php8.0-fpm.sock;
/etc/init.d/nginx restart
Ref
ENV
Step
$ sudo apt update
install nginx
$ sudo apt install nginx
$ sudo nginx -v
http://server_domain_or_ip
/var/www/html/
install MySQL
$ sudo apt install mysql-server
$ sudo mysql --version
install PHP สำหรับ NGINX
$ sudo apt install php8.1-fpm php-mysql
sudo apt install php8.1-bcmath php8.1-bz2 php8.1-curl php8.1-intl php8.1-mbstring php8.1-mysql php8.1-readline php8.1-xml php8.1-zip php8.1-gd php8.1-gmp
$ nano /var/www/html/info.php
$ sudo nano /etc/nginx/sites-available/default
# Add index.php to the list if you are using PHPindex index.html index.htm index.nginx-debian.html index.php;
location ~ \.php$ {include snippets/fastcgi-php.conf;fastcgi_pass unix:/var/run/php/php8.1-fpm.sock;}location ~ /\.ht {deny all;}
<?php phpinfo(); ?>
http://server_domain_or_ip/info.phpสร้าง virtual host สำหรับ nginx
$ sudo mkdir /var/www/your_domain
$ sudo chown -R $USER:$USER /var/www/your_domain
$ sudo nano /etc/nginx/sites-available/your_domain
$ sudo ln -s /etc/nginx/sites-available/your_domain /etc/nginx/sites-enabled
$ sudo unlink /etc/nginx/sites-enabled/default
$ sudo ln -s /etc/nginx/sites-available/default /etc/nginx/sites-enabled
$ sudo nginx -t
$ sudo /etc/init.d/nginx [reload|restart] หรือ $ sudo systemctl [reload|restart] nginx
/var/www/your_domain
Add
$ sudo add-apt-repository ppa:ondrej/php
$ sudo apt update
Ref
mysqldump -h host -u user -p dbname > dbname.sql
mysqldump: Couldn't execute 'SELECT COLUMN_NAME_ _ _ _ _ Unknown table 'COLUMN_STATISTICS' in information_schema (1109)
mysqldump --column-statistics=0 -h host -u user -p dbname > dbname.sql
Solved
sudo apt install shutter
sudo apt remove --autoremove shutter
Solved
Ref
Solved
$ sudo add-apt-repository ppa:ondrej/php$ sudo apt update
sudo apt install php8.0 php8.0-common php8.0-cli
sudo apt install php8.0-bcmath php8.0-bz2 php8.0-curl php8.0-intl php8.0-mbstring php8.0-mysql php8.0-readline php8.0-xml php8.0-zip php8.0-gd php8.0-gmp
sudo a2enmod php8.0
sudo a2dismod php8.1
sudo update-alternatives --set php /usr/bin/php8.0
sudo /etc/init.d/apache2 restart หรือ $ sudo systemctl restart apache2
Add
sudo php -v
Ref
Solved
SELECT t1.* from table into outfile '/tmp/tb.csv' fields enclosed by '"' terminated by ';' escaped by '"' lines terminated by '\r\n';
เพิ่มเติม
ERROR 1 (HY000): Can't create/write to file
Ref
Solved
> create database mydb;
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Ref:
Solved
$ gedit --encoding=TIS-620 file.txt
*/5 * * * * /home/ramesh/backup.sh
0 */5 * * * /home/ramesh/backup.sh
$ cat every-5-seconds.sh
#!/bin/bashwhile truedo/home/ramesh/backup.shsleep 5done
$ date
$ timedatectl
$ timedatectl list-timezones
$ timedatectl set-timezone Asia/Bangkok
$ timedatectl
ปัญหาที่เจอถ้าเราไม่ดูแลเรื่องนี้
$ sudo timedatectl set-time 15:30:00$ sudo timedatectl set-time 2019-04-25
Ref
Install
$ sudo apt update
$ sudo apt install barrier
Remove
$ sudo apt remove barrier
$ sudo apt remove barrier
Ref
Env
Pattern basic
$ rsync -av -e ssh /src/ user@remote:/path/to/dst
# rsync -av -e ssh user@remote:/path/from/source_folder /local/path/destination_folder
# rsync -av -e ssh /local/path/source_folder user@remote:/path/from/destination_folder
# rsync -av -e "ssh -i /path/private_key" user@remote:/path/from/source_folder /local/path/destination_folder
# rsync -av -e 'ssh -p 2200' user@remote:/path/from/source_folder /local/path/destination_folder
Ref
ติดตั้ง PHP8.1
$ sudo apt update
$ sudo add-apt-repository ppa:ondrej/php
$ sudo apt update
$ sudo apt install php8.1
apache2 apache2-bin apache2-data apache2-utils libapache2-mod-php8.1 libapr1 libaprutil1 libaprutil1-dbd-sqlite3 libaprutil1-ldap php-common php8.1-cli php8.1-common php8.1-opcache php8.1-readline
$ sudo apt install php8.1-bcmath php8.1-bz2 php8.1-curl php8.1-intl php8.1-mbstring php8.1-mysql php8.1-readline php8.1-xml php8.1-zip php8.1-gd php8.1-gmp
ติดตั้ง Apache2
$ sudo apt install apache2 libapache2-mod-php8.1 -y
ติดตั้ง MySQL Server
$ sudo apt install mysql-server
$ sudo mysql_secure_installation
$ sudo mysql
> CREATE USER 'new_user'@'%' IDENTIFIED BY 'new_user_password';
> grant all privileges on *.* to 'new_user_name'@'%' with grant option;
> FLUSH PRIVILEGES;
$ sudo systemctl restart apache2
# echo "<?php phpinfo(); ?>" >> /var/www/html/phpinfo.php
http://ip-host/phpinfo.php
Ref
$ python3 text_file_to_speech.py
Traceback (most recent call last):
File "text_file_to_speech.py", line 18, in <module>
myobj.save("./audios/output.mp3")
File "/usr/lib/python3/dist-packages/gtts/tts.py", line 295, in save
self.write_to_fp(f)
File "/usr/lib/python3/dist-packages/gtts/tts.py", line 251, in write_to_fp
prepared_requests = self._prepare_requests()
File "/usr/lib/python3/dist-packages/gtts/tts.py", line 194, in _prepare_requests
part_tk = self.token.calculate_token(part)
File "/usr/lib/python3/dist-packages/gtts_token/gtts_token.py", line 28, in calculate_token
seed = self._get_token_key()
File "/usr/lib/python3/dist-packages/gtts_token/gtts_token.py", line 59, in _get_token_key
"Unable to find token seed! Did https://translate.google.com change?"
ValueError: Unable to find token seed! Did https://translate.google.com change?
pip3 install gTTS-token --upgradepip3 install gTTS --upgrade
sudo apt install python-pip
sudo apt install python3-pip
Step
Ref
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 33706237 bytes)
Solved 1 อันนี้แก้เป็นรายระบบไป
Solved 2 อันนี้แก้สำหรับรองรับทุกระบบ (แต่ server ต้อง ram เยอะๆ หน่อย)
เพิ่มเติม
Ref