Dev {Tricks}

You are here: Home / Archives for Server and Hosting / Web Control Panel / aaPanel

by

How to Add Swap Space/file on CentOS 7 and CentOS 8

Before You Begin

check if your CentOS installation already has swap enabled by typing:

swapon –show

Empty output means that your system does not have swap enabled. Otherwise, swap enabled. Note that you may have multiple swap partitions and/or files.

Creating a Swap Partition

Creating a Swap File

 

First, create a file which will be used as swap space 1GB:

fallocate -l 1G /swapfile

If the fallocate utility is not available

sudo dd if=/dev/zero of=/swapfile bs=1024 count=1048576

Ensure that only the root user can read and write the swap file

chmod 600 /swapfile

Next, set up a Linux swap area on the file:

mkswap /swapfile

Run the following command to activate the swap:

swapon /swapfile

Make the change permanent by opening the /etc/fstab file:

vi /etc/fstab

and pasting the following line:

/swapfile swap swap defaults 0 0

Verify that the swap is active

swapon –show

or

free -h

Adjusting the Swappiness Value

Swappiness can have a value between 0 and 100. A low value will make the kernel to try to avoid swapping

cat /proc/sys/vm/swappiness

To set the swappiness value to 10

sysctl vm.swappiness=10

To make this parameter persistent across reboots append the following line to the /etc/sysctl.conf file:

vm.swappiness=10

Removing a Swap File #

Start by deactivating the swap space by typing:

sudo swapoff -v /swapfile

Next, remove the swap file entry /swapfile swap swap defaults 0 0 from the /etc/fstab file.

Finally, delete the actual swapfile file with rm :

sudo rm /swapfile

by

nginx free WAF error while using nginx 1.23 and above | aaPanel

  • nginx: [emerg] “lua_package_path” directive is duplicate in /www/server/panel/vhost/nginx/free_waf.conf:4
    nginx: configuration file /www/server/nginx/conf/nginx.conf test failed

Solution:

Nginx 1.23 and above do not support the Nginx free firewall, it is recommended to use nginx 1.22

 

by

Migrate aaPanel to New Server using One-Click Migration Tools

  • How to migrate aaPanel account(s) from server A to server B
  • aaPanel settings migration.
  • Cloning aapanel accounts
  • Moving from old error aapanel to new aapanel server
  • How To Migrate Data On aaPanel With 3 Steps
  • How Migrate aaPanel using One-Click Migration API version 3.0
  • ERROR After Migration to AAPANEL

Follow the following steps to migrate aaPanel account(s) easily.

On new Server:

  1. Install aaPanel
  2. Set server configuration same as old server
  3. Update aaPanel to latest version
  4. Click API (Panel Setting) and allow API
  5. Reset API to get new api key and enter whitelist IP (ip address of old server)

On old server:

  1. Update aaPanel to latest version
  2. Install “One-Click Migration”
  3. Open “One-Click Migration” and enter required data
    1. Target panel Addr: Panel address. For example, https://103.81.224.71:7800
    2. Target panel API: API from new server
    3. Select website(s) and database(s)
  4. Just follow the steps and choose which website you want to migrate, then wait for the process, then you’re done

 

 

 

 

by

MySQL: Error Code: 1118

  • #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
  • Change limit for “Mysql Row size too large”
  • Row size too large 8126 Changing some columns
  • 1118 Row size too large

The error was: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

  • Solution
  • Login to phpMyAdmin with root previllege
  • Go to Variables
  • Then edit Innodb Strict Mode as follows 
    innodb_strict_mode = 0

 

by

aaPanel Error and Solutions

= InnoDB: Missing FILE_CHECKPOINT at 42251 between the checkpoint 42251 and the end 42347.

Try the following command to remove the file, and then restart mysql to see if there is an error?

cd /www/server/data/
mv ibdata1 /tmp/ibdata1.bak
mv ib_logfile0 /tmp/ib_logfile0.bak
mv ib_logfile1 /tmp/ib_logfile1.bak
/etc/init.d/mysqld restart

Deprecation Notice in ./libraries/classes/Di/ReflectorItem.php#82
Method ReflectionParameter::getClass() is deprecated

you need to uninstall the original phpMyAdmin and then re install it to select version 5.2. Unloading phpMyAdmin will not affect the database data, so it is safe to operate.

 

= Reset mySQL root password

Starting in MariaDB 10.4 onwards, the mysql.user is not a table anymore, thus requiring a new command to reset the password.

mysql -u root -e 'SET PASSWORD FOR `root`@`localhost` = PASSWORD("new_password"); FLUSH PRIVILEGES;'

Change the new_password to your new password.