Symptoms
If an SRV record is present in the zone, the DNS zone is not updated due to this error:
Error: Incorrect DNS record values were specified.
Read More
How to resolve the error ‘Table ‘mysql.servers’ doesn’t exist”
After plesk upgrade or with newly installed plesk , if you are not able to set the passwords for the
new database users or not able to do any kind of activity with the database users and mysql error log shows
[ERROR] Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist
Then here are steps which could be referred:
How to setup HAProxy on CentOS 7
Step 1 – Configure the /etc/hosts files
Log in to the load balancer server and edit the /etc/hosts file.
ssh loadbalancer@192.168.1.102
sudo su
DNS page in Plesk shows an exception: Table::select() failed
Symptoms
- Unable to manage domain or a customer (suspend/resume/remove, etc.);
- Unable to manage hosting settings;
- Unable to access DNS Settings menu:
Error: DNSZone::Table::select() failed: no such row in the table - Plesk domains are added in HSPcomplete, but the DNS zones are not created in the HSPcomplete name servers automatically.
How to change the homepage using .htaccess
When a URL specifying only a directory is requested …
eg.: http://www.domain.com/directory/
Initially, Apache looks for file names by default (in the order they appear):
index.html
index.htm
home.html
Read More
Install PostgreSQL Database Server CentOS 7
To use PostgreSQL as your database. Install it with the following command:
[root@mattermost ~] yum -y install postgresql-server postgresql-contrib
After installation we have to init the database.
[root@mattermost ~] postgresql-setup initdb
Initializing database … OK
Plesk – How to Set up a Secondary DNS Server
First, zone transfer for the secondary DNS server should be allowed in Plesk. To do it list secondary DNS server’s IP in NS records for all zones on Plesk server or add it to Access Control List (ACL). ACL is managed under Server > DNS Settings > Common ACL.
For non-Plesk secondary DNS servers:
- Create all DNS zones on the secondary DNS server in
/etc/named.conf(this file location may differ depending on OS) withslavetype. For example:zone “example.com” { type slave; file “example.com.zone”; masters { 192.168.0.1; }; }
Install MariaDB on CentOS 6
Step 1. Setting up the MariaDB Repository
You should ensure that the available packages are up to date. For that, simply run the following command in terminal:
yum -y update
Now, add the MariaDB CentOS repository.
Create a new MariaDB repository file /etc/yum.repos.d/mariadb.repo with nano:
nano /etc/yum.repos.d/MariaDB.repo
How to show your apache status
You can also check and monitor Apache server’s current status on the web page without using log files. Modify httpd.conf file and add the following code into it:
ExtendedStatus On
<Location /server-status>
SetHandler server-status
Deny from all
Order deny,allow
Allow from localhost 192.168,1,56
Allow from .anotherdomain.com
</Location>
Cannot Add a new Domain
A DNS record for the domain you are trying to add already exists in the Plesk database, so a new domain with the same name cannot be added.
Resolution
Try finding a record with a similar name in the DNS settings of the existing domains.
If it is difficult to find this manually:
