Dev {Tricks}

You are here: Home / Archives for Server and Hosting

by

How to Install cPanel/WHM on Ubuntu 20.04

  • How to Install cPanel/WHM on Ubuntu 20.04
  • How to Install cPanel/WHM on Ubuntu 20.04
  • System Requirements for Ubuntu | cPanel & WHM
  • How to install WHM & CPanel on Ubuntu 20.04 LTS Linux

Step 1

Login as root user to SSH of freshly installed Ubuntu 20.04

Step 2

Disable firewall, while installing cpanel & whm on linux ubuntu system

iptables-save > ~/firewall.rules
systemctl stop firewalld.service
systemctl disable firewalld.service

Step 3

Update Ubuntu System Packages

apt update
apt upgrade

Step 5

Set your hostname for example my.hostname.com

set hostname my.hostname.com
edit hostname

vi /etc/hosts
vi /etc/hostname

Reboot the server.

Step 6

Create a shell session of Linux Screen utility. It helps to remain active even after the network disruption.

screen

If the screen is not installed, install it.

apt install screen

Step 7 – Install Cpanel/WHM

cd /home && curl -o latest -L https://securedownloads.cpanel.net/latest && sh latest

Step 5 – Login to WHM Web interface

https://SERVER_IP:2087

Use your root login credentials.

That’s All!

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

How to change the SSH port | WHM

How to change the SSH port

  • Log in to the server with root user
  • Open /etc/ssh/sshd_config. 
    vi /etc/ssh/sshd_config
  • Edit the port line. Change the default port 22 to your choice, for example 1234. 
    port 1234
  • Restart SSHD 
    /scripts/restartsrv_sshd
  • Test SSH while specifying the new port 
    ssh USER@HOSTNAME -p1234
  • Please use your USER and HOSTNAME and the new port
  • If unsuccessful, add the new SSH port to your firewalls and then retest.
  • If the SSH test on the new port is successful then you can reboot and log in to the server with new port.

 

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.

 

by

How To Create a New User and Grant Permissions in MySQL

Access MariaDB Server

mysql -u root -p

Create new database

CREATE DATABASE bdhostidb;

Check whether the database created

SHOW DATABASES;




GRANT ALL PRIVILEGES ON 'sqI_bdhositit_co'.* TO 'sqI_bdhositit_co'@localhost;