MySQL Databases interface to show MySQL as offline, Updating MariaDB to v10.2.35 or v10.3.26

WebhostUk

Upgrading MariaDB to v10.2.35 or v10.3.26 causes the cPanel UI to not read the grants properly, which leads to cause select sites to be inaccessible and the MySQL Database page within the cPanel interface returns the following error.

More important to note that MariaDB should still be running, the cPanel error log should populate the string the UI is having issues reading:

[2020-11-05 07:37:27 +0000] warn [cpmysql] Error (Invalid grant string: SET DEFAULT ROLE 0 FOR '$user'@'$host'
) while parsing grant: SET DEFAULT ROLE 0 FOR '$user'@'$host' at /usr/local/cpanel/Cpanel/Mysql.pm line 956, <STDIN> line 1.
        Cpanel::Mysql::__ANON__(__CPANEL_HIDDEN__...) called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 118

cPanel has opened an internal case for their development team to investigate this further.

For reference, the case number is CPANEL-34745.

Follow this article to receive an email notification when a solution is published in the product. 

Before proceeding with these changes, we encourage you to backup your database in the event a restore is required.

To backup the MySQL database directory, the following command can be executed as root:

mysqldump mysql > /backup/mysql.sql

Once backup is complete, you can proceed with altering that database column order.

The following command performs the appropriate alterations for the database:

mysql -e "ALTER TABLE mysql.user MODIFY IF EXISTS password_last_changed timestamp DEFAULT CURRENT_TIMESTAMP NULL AFTER max_statement_time, MODIFY IF EXISTS password_lifetime smallint unsigned DEFAULT NULL AFTER password_last_changed, MODIFY IF EXISTS account_locked enum('N', 'Y') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL after password_lifetime;"

Apply the change by restarting the MariaDB service:

/scripts/restartsrv_mysql

They should go into effect immediately. 

yum versionlock clear

Then run upcp to have the MariaDB packages updated:

/scripts/upcp

Inode

What is an inode.

An inode is a data structure used to represent a filesystem object, which can be one of various things including a file or a directory. Each file has a single inode, even though they can have different names.

In other words, the number of inodes equals the total number of files and directories on your hosting plan. To ensure optimal performances, we limit the number of inodes upto 250 000 on most of the hosting plan.

Where can I see how many inodes I use.

To check how many inodes are used, log in to your cPanel. In the left sidebar, click on the Statistics icon. Under Disk Space, you will find Files Usage. This equals to your inode usage.

Steps to reduce inode usage.

There are several ways to reduce inode usage.

Delete useless files, old backups and websites

In your cPanel with the File Manager or through a FTP client, you can easily sort and delete files and directories that are not necessary. These can be scripts not in use, old development websites, unused image files…

Remove cache files

Some applications (such as Joomla, Drupal or WordPress for instance) generate a number of cache files used to improve performances. Verifying how big these cache files are and deleting them once in a while is a good practice. You should be able to remove cache files easily directly in the app.

Archive old emails

Every email on your hosting plan adds up to the total number of inodes. It is a good practice to archive older emails or to transfer them to your computer to limit their size on the server.

Also, it is necessary to check the catchall email address that can accumulates thousands of emails and therefore inodes.

Verify where error messages from scripts and CRON tasks go

If your CRON tasks generate error messages, they can be stored (and take a lot of room) on your server. It is important to check where the error messages go in order to reduce inode usage

How to enable Cloudflare with Railgun

A tutorial that will guide you about how to enable CloudFlare with Railgun for your website.

Cloudflare is a CDN that allows to enhance your website performance, speed and latency with the help of their distributed network across the globe!

Cloudflare offers a premium feature called as Railgun which helps improving the website load times, especially for dynamic websites such as WordPress devloped websites, Drupal, Joomla etc.

Railgun ensures that the connection between your origin server and the Cloudflare network is as fast as possible. It is a premium plugin from Cloudflare which is available as a paid feature. However, we at WebHostUK, being an exclusive Cloudflare partner, offer Railgun for free for websites hosted on our server.

Below tutorial will explain you how to enable Cloudflare with Railgun on our servers.


  • Once your order is processed and your account is enabled, you will gain cpanel access to your account, where Cloudflare tool is available under “Software” section as visible in below screenshot:

  • Click on Cloudflare and it will then redirect you to Cloudflare setup wizard

  • You can use any of your existing Cloudflare account or create a new one. If you already have an account with Cloudflare, then please make sure that the domain (for which you are intending to add Railgun) is not existing in your Cloudflare account. If it is so, kindly delete it from your Cloudflare.com portal login.

  • To integrate Cloudflare, you have two options:

i. Partial setup also known as CNAME setup of website with Cloudflare : In this setup, your domain will use our nameservers and the CNAME of “www” prefix of your domain will be resolving to Cloudflare alias domain name.

Pro’s of CNAME Cloudflare setup : DNS zones are configured on our server which means, you do not need to do any manual DNS changes for your domain or its MX records or subdomains. These DNS records are automatically configured in DNS zones on our servers.

Con’s of CNAME Cloudflare setup : Since only “www” prefix is configured with Cloudflare alias hostname, Cloudflare with Railgun for the respective website will only work if domain is accessed with www prefix. If the website is not accessed with www prefix, Railgun will not work. So you will have to force redirect your website to its www prefix using rules in .htaccess


ii. CloudFlare DNS Managed setup or full setup : In Cloudflare DNS managed setup, your domain will use Cloudflare nameservers which means all host records including “A”, “MX”, “NS”, “SPF”, “DKIM” etc are all hosted on Cloudflare servers. Cloudflare will control DNS for your domain and we no longer have any DNS control for your websites or its subdomains.

Pro’s of Cloudflare DNS managed setup: Cloudflare with Railgun will work for domain with or without “www” prefix. This eliminates the need of any such redirect of website from non-www url to www url

Con’s of Cloudflare DNS managed setup: Since Cloudflare will manage your DNS, you will need to manually add MX, SPF or DKIM records in Cloudflare DNS portal. Whenever you create any subdomain, its entry will also need to be manually added in Cloudflare DNS portal.


  • Once you have enabled Cloudflare for your domain using any of “cname or cloudflare dns managed setup” as explained above, you will now need to request for enabling Railgun for your domain. In order to request enabling “Railgun” for your domain, you will need to submit a request at : https://www.webhostuk.co.uk/railgun-request.php

Your submitted request will raise a support ticket under your account, and our 24/7 support team will then enable Railgun for your requested domain and update you via your support ticket.

How to check if Cloudflare with Railgun is working for your website?

To check if cloudflare with Railgun is working properly for your website, you need to take help of an extension plugin which is available for Google Chrome Browsesr : https://chrome.google.com/webstore/detail/claire/fgbpcgddpmjmamlibbaobboigaijnmkl

Cloudflare if sucessfully enabled for your website and when accessed in Chrome, will show “red” dot as seen in below image

A List of SMTP and IMAP Server

Default Ports:Server:Authentication:Port:
SMTP Server (Outgoing Messages)Non-EncryptedAUTH25 (or 587)
 Secure (TLS)StartTLS587
 Secure (SSL)SSL465
IMAP Server (Incoming Messages)Non-EncryptedAUTH143
 Secure (TLS)StartTLS143
 Secure (SSL)SSL993


Googlemail – GmailServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.gmail.comSSL465
 smtp.gmail.comStartTLS587
IMAP Server (Incoming Messages)

Please make sure, that IMAP access is enabled in the account settings.
Login to your account and enable IMAP.
You also need to enable “less secure apps” (third party apps) in the Gmail settings:
https://support.google.com/accounts/answer/6010255?hl=en
See also: How to enable IMAP/POP3/SMTP for Gmail account
imap.gmail.comSSL993

Outlook.comServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp-mail.outlook.comStartTLS587
IMAP Server (Incoming Messages)imap-mail.outlook.comSSL993
Office365.comServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.office365.comStartTLS587
IMAP Server (Incoming Messages)outlook.office365.comSSL993
 Note: If the above settings are not working for your account, then login into the outlook web app, go to the “Settings” > “Options” > “Account” > “My Account” > “Settings for POP and IMAP Access”.
Yahoo MailServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.mail.yahoo.comSSL465
IMAP Server (Incoming Messages)imap.mail.yahoo.comSSL993
Yahoo Mail PlusServer:Authentication:Port:
SMTP Server (Outgoing Messages)plus.smtp.mail.yahoo.comSSL465
IMAP Server (Incoming Messages)plus.imap.mail.yahoo.comSSL993
Yahoo Mail UKServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.mail.yahoo.co.ukSSL465
IMAP Server (Incoming Messages)imap.mail.yahoo.co.ukSSL993
Yahoo Mail DeutschlandServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.mail.yahoo.comSSL465
IMAP Server (Incoming Messages)imap.mail.yahoo.comSSL993
Yahoo Mail AU/NZServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.mail.yahoo.auSSL465
IMAP Server (Incoming Messages)imap.mail.yahoo.auSSL993
AOL.comServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.aol.comStartTLS587
IMAP Server (Incoming Messages)imap.aol.comSSL993
AT&TServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.att.yahoo.comSSL465
IMAP Server (Incoming Messages)imap.att.yahoo.comSSL993
NTL @ntlworld.comServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.ntlworld.comSSL465
IMAP Server (Incoming Messages)imap.ntlworld.comSSL993
BT ConnectServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.btconnect.com 25
IMAP Server (Incoming Messages)imap4.btconnect.com 143
O2 DeutschlandServer:Authentication:Port:
SMTP Server (Outgoing Messages)mail.o2online.de 25
IMAP Server (Incoming Messages)imap.o2online.de 143
T-Online DeutschlandServer:Authentication:Port:
SMTP Server (Outgoing Messages)securesmtp.t-online.deStartTLS587
IMAP Server (Incoming Messages)secureimap.t-online.deSSL993
1&1 (1and1)Server:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.1and1.comStartTLS587
IMAP Server (Incoming Messages)imap.1and1.comSSL993
1&1 DeutschlandServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.1und1.deStartTLS587
IMAP Server (Incoming Messages)imap.1und1.deSSL993
VerizonServer:Authentication:Port:
SMTP Server (Outgoing Messages)outgoing.verizon.net 587
IMAP Server (Incoming Messages)incoming.verizon.net 143
zoho MailServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.zoho.comSSL465
IMAP Server (Incoming Messages)imap.zoho.comSSL993
Mail.comServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.mail.comStartTLS587
IMAP Server (Incoming Messages)imap.mail.comSSL993
GMX.comServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.gmx.comSSL465
IMAP Server (Incoming Messages)imap.gmx.comSSL993
Net@ddress by USA.NETServer:Authentication:Port:
SMTP Server (Outgoing Messages)smtp.postoffice.netSSL465
IMAP Server (Incoming Messages)imap.postoffice.netSSL993
+ Add ProviderServer:Authentication:Port:
SMTP Server (Outgoing Messages)Contact us to add your provider  
IMAP Server (Incoming Messages)  

How to Check if Railgun is Running on Website

When a request is handled by Railgun, Cloudflare inserts a header with diagnostic information to track how the protocol is doing. If you want to see these headers, you’ll need to use a browser that supports examining header information.

View Railgun header in browser

Google Chrome: View > Developer > Developer Tools menu. You can also install Cloudflare’s Claire extension.

Safari: Develop > Show Web Inspector menu

Firefox: Install Firebug

Microsoft Internet Explorer: You can use a tool like Fiddler

When you are looking for the header information, you should be seeing Cloudflare headers like the following in the response:

cf-railgun:   e95b1c46e0 0.02 0.037872 0030 9878

cf-ray:   478149ad1570291

The CF-Railgun header has up to five codes separated by a space. In order, these codes and their corresponding values from the example of cf-railgun: e95b1c46e0 0.02 0.037872 0030 9878 listed above are:

  • Railgun Request ID: e95b1c46e0 (internal process number that allows us to track what connection handled a request )
  • Compression Ratio: 0.02 (the size of the response after Railgun’s delta compression expressed as a percentage)
  • Origin Processing Time: 0.037872 (that Railgun waits for the origin web server to generate the page)
  • Railgun Flags: 0030 (how a request was processed)
  • Version Number: 9878 (indicates the version of the Railgun Listener software on the origin server’s network)

How to order UK reseller hosting with free WHMCS and Private Nameservers

Our tutorial that will help you to start your own web hosting business with our UK reseller hosting plan.

Reseller Hosting Guide to help you order UK reseller web hosting from our website https://www.webhostuk.co.uk/reseller-hosting.html

WebHostUK offers white-labelled reseller hosting with free Private Nameservers, free WHMCS billing system (on selected plans), free ENOM reseller account and much more, with one of the best 24/7 support available via live chat and ticket helpdesk!

How to order reseller hosting with free WHMCS and private nameserves?

Our guide will help you start your own web hosting business in less than 10 minutes.

Reseller Hosting Setup Guide will help you with:
1) Choose and order a domain name for your web hosting business
2) Select your reseller hosting plan with us
3) Setup white-labelled private nameservers to represent your web hosting brand
4) Login to reseller WHM and setup your Web Hosting packages
5) Create your first customer under your reseller account.

If you need any more assistance while ordering our reseller hosting plans, please feel free to visit our website at https://www.webhostuk.co.uk and initiate a live chat with one of our 24/7 support engineer!

How to configure email in Outlook on Windows 10?

Our tutorial that will help you to configure email in your Outlook email client on a Microsoft Windows 10 machine

Tutorial to configure email in Outlook on Windows 10 computer.

You will first need an active account with us. Please visit https://www.webhostuk.co.uk/web-hosting.html to signup with one of our web hosting plans.

You can now login to your client portal at https://secure.webhost.uk.net

Go to Services to manage your web hosting product with us. It will allow you to create email account in your cPanel.

As an example if your domain name is webhost-uk.net (this is just an example for reference purpose, please replace it with your valid domain name) then your email client configuration details will be:

Incoming POP3 Server : mail.webhost-uk.net
Incoming POP3 Secure port: 995
Incoming POP3 non-ssl port: 110

Incoming IMAP Server : mail.webhost-uk.net
Incoming IMAP Secure port: 993
Incoming IMAP non-ssl port: 143

Incoming SMTP Server : mail.webhost-uk.net
Incoming SMTP Secure port: 465
Incoming SMTP non-ssl port: 25 or 587

Enter your full email address as your username and its respective password that you configured in cPanel.

That’s all!! and you should be good to send and receive email from your Outlook on your Windows 10 computer!

For any further help, please do not hesitate to initiate a livechat with our 24/7 support from our website https://www.webhostuk.co.uk

Fix CPU Overload / Abuse Issues ?

Most common things you need to follow will be:

1. Adding cloudflare for your domains which will protect your domains from Unwanted Traffic/Attack/Bot Access 

2. Add robots.txt to understand Search engines to crawl your sites.There are lot of Crawl bots which will give unwanted traffic to your websites which will also cause Overloading on servers like (EP hits)

So create an robots.txt file under your public_html and place the below code : 

User-Agent: *
Disallow: /User-Agent: Googlebot
Allow: /

If you want to add any other search engines to crawl your site you can add it in the above code 

Follow the Above steps for all your domains which is an recommended thing !

For WordPress Users kindly change the File permission of 2 files under your WordPress root wp-cron.php and xmlrpc.php to Permission 000

You can change it from your cPanel > Filemanager As these 2 files will cause overloading on servers by giving unwanted traffic 

Add Heart Beat Plugin to control the admin-ajax.php Once installed WP Admin > Settings > Heartbeat Control > Disable the heartbeat for All 3 Options and click save

Add loginizer which will protect your sites from WP Login attacks (These attacks on most common your websites will be facing daily) So its best way to change your  WP Admin portal URL (VERY RECOMMENDED)

Keep your WP Core,Plugins,Themes Up to date

Remove any Un-used themes or plugins

Don’t use Jetpack Plugin as it will Eat the Resource

How to order a Domain name and UK web hosting for your website?

You can now order your preferred domain name for your website along with UK web hosting services, to get your website published in just a few minutes.

Below tutorial will guide you to select your domain name and order web hosting services at WebHostUK Limited

To get started, please visit our website at https://www.webhostuk.co.uk

Select the desired type of hosting such as :

Cloud Hosting: https://www.webhostuk.co.uk/web-hosting.html or

WordPress Hosting: https://www.webhostuk.co.uk/wordpress-hosting.html or

Reseller Hosting : https://www.webhostuk.co.uk/reseller-hosting.html or

Managed VPS server : https://www.webhostuk.co.uk/vps-hosting.html or

Managed Dedicated Server: https://www.webhostuk.co.uk/dedicated-hosting.html and many more.

Today, we will order a shared hosting plan ..

Lets order Linux Standard Cloud Plan which costs £14.99 per year + VAT

To get started please visit https://www.webhostuk.co.uk/web-hosting.html

Click on “Order Now” button below “Linux Standard Cloud” plan

Choose your domain option:

1) To register a new domain, select “Register a new domain” 2) To transfer your existing domain from your old registrar over to us, select option “Transfer your domain from another registrar ” 3) To keep your domain with your old registrar and use our nameservers, select “I will use my existing domain and update my nameservers “.

Let’s choose to register a new domain. So select option 1 and enter your desired domain name. You can also select your desired TLD (such as .co.uk or .com etc) from the dropdown menu. Click “Check” and the wizard will search for domain availability. If it is available, it will show a “Congratulations” message..

Click on “Continue” Select your preferred billing term for web hosting, such as Annual, Biennial or Triennial. You can also choose from several addons that you can select along with web hosting. Click on “Continue” to proceed to next step.

You will be asked to configure your domain details. Enter your valid details and click on “Continue”

This is the final screen which says “Review & Checkout”. Here you can see the web hosting product billing duration that you selected earlier. Below you will see your domain name. By default it will be registered for 1 year. However, you can increase your domain registration to longer duration such as to 2 / 3 years.

Click on “Checkout” Enter your valid details such as Name, Address, and select mode of payment to finalize your order.

Voila … Thats it..!! Your order will now get processed on successful completion of our automated fraud check system. You will then receive all login details for your order which will help you to login to your client portal and cPanel. If at any stage you need any help, you are most welcome to visit our website at https://www.webhostuk.co.uk and initiate a live chat with our 24/7 live chat support person!

MySql offline error in cPanel

We have recently noticed, Mysql error poping up in cPanel when trying to access “Mysql Databases” tool.

The error mentions about “The MySQL server is currently offline” and also about mysql privileges warning such as “Error encountered while fetching data: There is no such grant defined for user ‘xxxx’ on host ‘localhost’ DBDISKUSED yyyyy 1909382 DISKUSED 1909382 DB zzzzzz DBUSER USER xxxxxx

We are aware about the error which is due to changes in grants in MariaDB 10.3.23. cPanel team is working on the above error and they also have updates posted at:

https://forums.cpanel.net/threads/cpanel-32712-updating-to-mariadb-10-3-23-on-cpanel-breaks-the-mysql-databases-interface.672141/

and

https://support.cpanel.net/hc/en-us/articles/360048322953-Updating-to-MariaDB-10-3-23-on-cPanel-breaks-the-MySQL-Databases-interface?flash_digest=4100901b496de2407784adbd2eb57f18034d42f9

Please note that while the interface indicates it is down it is only the interface the server is still running.

We do not have any ETA as this is a bug with cPanel and as per their update, they are working actively to resolve the error. We will post more updates when we have one.