December 5, 2021

Directadmin increasing mysql limits script

#!/bin/sh #Limits (setting these options to 0 removes the limit) MAX_QUERIES_PER_HOUR=30000 MAX_UPDATES_PER_HOUR=20000 MAX_CONNECTIONS_PER_HOUR=5000 MAX_USER_CONNECTIONS=100 #We get DirectAdmin MySQL root user and password here DA_MYSQL=/usr/local/directadmin/conf/mysql.conf MYSQLUSER=`grep “^user=” ${DA_MYSQL} | cut -d= -f2` MYSQLPASSWORD=`grep “^passwd=” ${DA_MYSQL} | cut -d= -f2` mysql -e “use mysql; UPDATE mysql.user SET max_questions=${MAX_QUERIES_PER_HOUR}, max_updates=${MAX_UPDATES_PER_HOUR}, max_connections=${MAX_CONNECTIONS_PER_HOUR}, max_user_connections=${MAX_USER_CONNECTIONS} WHERE...

Continue reading...

IP Tunnel (GRE) in LXC proxmox Container

After container is created, you need to edit the configuration file to add the /dev/net/tun device. # pct config 123 arch: amd64 hostname: CT123 memory: 512 net0: name=eth0,bridge=vmbr0,firewall=1,hwaddr=FE:75:64:2A:A3:58,ip=dhcp,type=veth ostype: debian rootfs: local-lvm:vm-123-disk-0,size=4G features: nesting=1 swap: 512 unprivileged: 1 # nano /etc/pve/lxc/123.conf Add the following lines at the end (if you’re...

Continue reading...