Just another WordPress site

Day: July 13, 2023

Download MariaDB Server

Download MariaDB Server

MariaDB Server is one of the world’s most popular open source relational databases and is available in the standard repositories of all major Linux distributions. Look for the package mariadb-server using the package manager of your operating system. Alternatively you can use the following resources:

MariaDB Server 11.0 brings many significant improvements to the query optimizer! Try it out and please let us know of your experience. We aim to incorporate all the feedback we receive.
You can read more about the optimizer improvements straight from the main author at Monty Says blog post!

 

MariaDB Server
MariaDB Server Repositories
Connectors
MariaDB Foundation provides packages for MariaDB versions newer than the version provided by the distribution only.

Version 10.6

Here are the commands to run to import the MariaDB repository key on your Ubuntu system:

sudo apt-get install apt-transport-https curl
sudo mkdir -p /etc/apt/keyrings
sudo curl -o /etc/apt/keyrings/mariadb-keyring.pgp 'https://mariadb.org/mariadb_release_signing_key.pgp'

Once the key is imported, copy and paste the following into a file under /etc/apt/sources.list.d (for instance /etc/apt/sources.list.d/mariadb.sources):

# MariaDB 10.6 repository list - created 2023-07-13 06:43 UTC
# https://mariadb.org/download/
X-Repolib-Name: MariaDB
Types: deb
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# URIs: https://deb.mariadb.org/10.6/ubuntu
URIs: https://ftp.heanet.ie/mirrors/mariadb/repo/10.6/ubuntu
Suites: jammy
Components: main main/debug
Signed-By: /etc/apt/keyrings/mariadb-keyring.pgp

You can now install MariaDB 10.6 from the MariaDB repository with:

sudo apt-get update
sudo apt-get install mariadb-server

Debug symbol packages, those that end in a ‘-dbgsym‘ suffix, are harmless to install. They are typically used to resolve stack traces and provide detail of perf recordings. They do not change the running behaviour of MariaDB. If in doubt, omit from installation.

If you need source packages, replace Types: deb with Types: deb deb-src in the /etc/apt/sources.list.d/mariadb.sources file. Then, you can obtain the mariadb source after installing dpkg-dev package, with apt-get source mariadb-server.

If you prefer to use the old “one-line-style” APT format, create the file /etc/apt/sources.list.d/mariadb.list with the following:

# MariaDB 10.6 repository list - created 2023-07-13 06:43 UTC
# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.6/ubuntu jammy main
deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://ftp.heanet.ie/mirrors/mariadb/repo/10.6/ubuntu jammy main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://ftp.heanet.ie/mirrors/mariadb/repo/10.6/ubuntu jammy main

See Installing MariaDB packages for more information

Distribution

CentOS 7

Version 10.6

Here is your custom MariaDB DNF/YUM repository entry for CentOS. Copy and paste it into a file under /etc/yum.repos.d (we suggest naming the file MariaDB.repo or something similar).

# MariaDB 10.6 CentOS repository list - created 2023-07-13 06:44 UTC
# https://mariadb.org/download/
[mariadb]
name = MariaDB
# rpm.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# baseurl = https://rpm.mariadb.org/10.6/centos/$releasever/$basearch
baseurl = https://ftp.heanet.ie/mirrors/mariadb/yum/10.6/centos/$releasever/$basearch
module_hotfixes = 1
# gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB
gpgkey = https://ftp.heanet.ie/mirrors/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck = 1

EPEL repository may be required to satisfy the pv dependency of galera.

After the file is in place, install and start MariaDB with:

sudo yum install MariaDB-server MariaDB-client

If you haven’t already accepted the MariaDB GPG key, you will be prompted to do so during the install. See Installing MariaDB with yum for detailed information. Note the GPG was changed in January 2023 with more secure key. For more details see our blog article New GPG Release Key for RPMs.

Debian 11 (Bullseye)

Version 10.6

Here are the commands to run to import the MariaDB repository key on your Debian system:

sudo apt-get install apt-transport-https curl
sudo mkdir -p /etc/apt/keyrings
sudo curl -o /etc/apt/keyrings/mariadb-keyring.pgp 'https://mariadb.org/mariadb_release_signing_key.pgp'

Once the key is imported, copy and paste the following into a file under /etc/apt/sources.list.d (for instance /etc/apt/sources.list.d/mariadb.sources):

# MariaDB 10.6 repository list - created 2023-07-13 06:49 UTC
# https://mariadb.org/download/
X-Repolib-Name: MariaDB
Types: deb
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# URIs: https://deb.mariadb.org/10.6/debian
URIs: https://ftp.heanet.ie/mirrors/mariadb/repo/10.6/debian
Suites: bullseye
Components: main
Signed-By: /etc/apt/keyrings/mariadb-keyring.pgp

You can now install MariaDB 10.6 from the MariaDB repository with:

sudo apt-get update
sudo apt-get install mariadb-server

Debug symbol packages, those that end in a ‘-dbgsym‘ suffix, are harmless to install. They are typically used to resolve stack traces and provide detail of perf recordings. They do not change the running behaviour of MariaDB. If in doubt, omit from installation.

If you need source packages, replace Types: deb with Types: deb deb-src in the /etc/apt/sources.list.d/mariadb.sources file. Then, you can obtain the mariadb source after installing dpkg-dev package, with apt-get source mariadb-server.

If you prefer to use the old “one-line-style” APT format, create the file /etc/apt/sources.list.d/mariadb.list with the following:

# MariaDB 10.6 repository list - created 2023-07-13 06:49 UTC
# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.6/debian bullseye main
deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://ftp.heanet.ie/mirrors/mariadb/repo/10.6/debian bullseye main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://ftp.he

 

 

Install Imunify360

Install Imunify360

Overview

This guide will show you how to install Imunify360 in Webuzo Control Panel. Imunify360 is the security solution for Linux web servers based on machine learning technology which utilizes a multi-layer approach to provide total protection against any types of malicious attacks or abnormal behavior including distributed brute force attack

Install Imunify360 Plugin

Please run the following command :

wget -N https://files.webuzo.com/plugins/imunify360/imunify360.sh

chmod +x imunify360.sh

./imunify360.sh

If ImunifyAV or ImunifyAV+ is already installed on your server you will be prompted to uninstall ImunifyAV. Type y to continue installing Imunify360.

Activate License

First, unregister your existing (trial) license key:
imunify360-agent unregister

After that, for key-based licenses, run:
imunify360-agent register YOURKEY

For IP-based licenses:
imunify360-agent register IPL

Use the word IPL, not an actual IP address for this command.

Admin Panel Screenshot

imunify360admin

Enduser Panel Screenshot

imunify360icon
imunify360enduser

How to Install Webuzo V3

Install Webuzo V3

Overview

Webuzo is a multi user shared hosting control panel which you can use to offer shared hosting and also offer 100s of applications via Softaculous. Installing Webuzo is very simple. This guide shows you how to install Webuzo on a newly installed Operating System.

NOTE : Webuzo v3 i.e. Multi User is stable however, till we make the v2 version upgrader to v3 we will still be keeping this in the release branch !

Requirements

  • Newly installed OS from the following list :
    – CentOS 7.x / 8.x
    – AlmaLinux 8.x / 9.x
    – Ubuntu LTS 18.04 / 20.04 / 22.04
    – Red Hat Enterprise Linux 7.x / 8.x
    – Scientific Linux 7.x / 8.x
    – Rocky Linux 8.x
    – CloudLinux 8.x / 9.x
  • YUM / apt-get / tar / wget packages installed
  • RAM – Minimum 1 GB (Recommended 2 GB for best performance)
  • Disk Space – Minimum 5 GB (Recommended 10 GB for best performance)
  • Open Ports – 2002, 2003, 2004, 2005, 21, 22, 25, 53, 80, 110,143, 443, 465, 993,995 , 587 and 3306 (It is recommended to keep these ports open on your server)
  • SELinux should be disabled

Note : There should be no PHP, Apache, MySQL installed on the server

Installation

Open a Shell Terminal (e.g. PuTTY) and SSH to your server. Run the following commands:

wget -N https://files.webuzo.com/install.sh chmod 0755 install.sh  ./install.sh // This will install the LAMP Stack, DNS Server and FTP server along with Webuzo

Parameters

Name Description Required
install The list of apps you would like to install
No

Default Apps

The –install parameter is optional and if it is not passed Webuzo will install the following apps by default :
Apache 2.4, MySQL 8.0, PHP 7.3, Pure-FTPd, Bind, Exim, Dovecot, GIT, Web Disk

If you want Webuzo to install default apps please use the following command :

./install.sh

No Apps

If you want Webuzo not to install any apps you can use the following value for install parameter :

./install.sh --install=none

Later you can install apps from Webuzo Admin Panel -> Apps -> Install an App page.

Selected Apps

If you want Webuzo to install selected apps you can pass the app names comma separated to the install parameter. E.g :

./install.sh --install=apache2,mariadb108,bind,exim,dovecot,php81,php80,php74

Below are app names for a few popular apps :

Web Servers

 

  • apache2
  • openlitespeed
  • lsws
  • nginx
  • nodejs
  • nodejs14
  • nodejs16
  • nodejs17
  • nodejs18
  • nodejs19

 

Database Servers

 

  • mysql80
  • mysql57
  • mariadb109
  • mariadb108
  • mariadb107
  • mongodb
  • pgsql
  • sqlite

 

Scripting Languages

 

  • php82
  • php81
  • php80
  • php74
  • php73
  • php72
  • php71
  • perl
  • python2
  • python3

 

Utilities

 

  • exim
  • dovecot
  • bind
  • pureftpd
  • sa (SpamAssasin)
  • jailshell
  • webdisk
  • varnish
  • django
  • passenger

 

Security

 

  • csf
  • clamav
  • cxs
  • ImunifyAV
  • ImunifyAV+
  • Imunify360

 

You can find a list softnames of all available apps here :
https://api.webuzo.com/apps.php?in=json

Use the softname values from the above list.

The installation will begin immediately. It may seem that the installation has stopped, if your network speed is slow, but please let it continue. You will see something like this when the installation is completed :

Install

This will setup the required Web Server and other important configurations. Note : A log file of the installation process will be created – /root/webuzo-install.log

Login to the Admin Panel

To login to the Webuzo Admin Panel, visit the following URL :
https://Your-IP:2005/
OR
http://Your-IP:2004/
The username and password will be the root credentials details of your server.

image

Panel Configuration

After the installation is completed we recommend you check the panel configuration. The Panel configuration is located at the Admin Panel -> Settings -> Panel Config. Please check the options there and correct anything which you feel is not correct as per the server.

Server IP, Hostname and Nameservers

Please enter a valid IP of this server and a hostname which will not be used by any user.
You will need to point your nameserver to the servers IP where you are installing Webuzo. Webuzo will ask you for the Primary Nameserver (e.g. ns1.example.com) and the Secondary Nameserver (e.g. ns2.example.com).
image

Create a user

Now that the Panel is configured we will create endusers / shared hosting users. The Add User wizard is located inside the Admin Panel -> Users -> Add User. Its a simple wizard and you just need to enter the users domain, username, password, email. You can then choose a hosting plan if you have created any or manually assign the resources to the user. You can also automate the process and link your billing systems like WHMCS, Blesta, etc. Following is the screenshot of the Add User wizard.

image
Add User Wizard

You can also create Resellers who can then create their own sub users. Please refer to our documentation for this.

Access the Enduser Panel

The Webuzo Enduser Panel is located at port 2002 and 2003 :
https://Your-IP:2003/
OR
http://Your-IP:2002/

To login to any user from the Admin Panel, simply visit the Users -> List Users Wizard and click on the icon in the Login column.

image

Enduser Panel Screenshot

image