#!/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 user!=’da_admin’ AND user!=’root’ AND user!=’da_roundcube’…
Month: December 2021
IP Failover enable
nano /etc/rc.local #!/bin/bash ifconfig ens3:0 188.165.x.x/32 exit 0 save chmod +x /etc/rc.local Don’t forget to edit your correct network interface (ens3)
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 using PVE < 7.0, change...
ping: socket: Operation not permitted
fix setcap cap_net_raw+p /bin/ping
Allow all SQL modes
nano /etc/my.cnf add sql_mode= save.