Author Archives: LinuxTech

The system could not create the user “triltch” because it conflicts with an unmanaged MySQL database user and an unmanaged PostgreSQL database user

While creating a new account in server was getting below error

The issue was due to mysql user already being present in server

This ok? yes
Checking input data……Done
Validating system setup……Done
…Done
Validating IP……Done
Validating Username……Done
Validating Contact Email……Done
Checking for database conflicts…(XID vh9sa4) The system could not create the user “tritch” because it conflicts with an unmanaged MySQL database user and an unmanaged PostgreSQL database user.

Steps to fix this issue

Go to PHPmyadmin

Select database Mysql

Go to Option search
Select all tables inside in option Inside tables

In option Words or values to search for (wildcard: “%”): put up name of mysql user which is conflicting >>

Delete all the tables you get in search tables and issue should be resolved

You can also refer in below URL

Solution: cPanel error “cannot create account because it conflicts with an unmanaged MySQL database user”

SMTP AUTH is required for message submission on port 587

The ‘SMTP AUTH’ error usually happens when users try to send mails without properly authenticating their mail account in email clients such as Outlook or Thunderbird.

What causes the error ‘SMTP AUTH is required for message submission on port 587’ in cPanel/WHM servers

With the latest cPanel/WHM update, email accounts that were working fine till now, may find their mails getting undelivered, showing this error message in the Exim log:

2018-01-17 05:57:40 H=(cruxserver12.com) [174.136.14.87]:63927 F=<zimphost@gmail.com> rejected RCPT <technical424@gmail.com>: SMTP AUTH is required for message submission on port 587
2018-01-17 05:58:09 H=(cruxserver12.com) [174.136.14.87]:63932 F=<zimphost@gmail.com> rejected RCPT <technical424@gmail.com>: SMTP AUTH is required for message submission on port 587

This has happened due to a latest security feature implemented in cPanel/WHM – ‘SMTP AUTH’ requires SSL by default.

To combat spamming in servers and to provide secure email transmission, email clients that try to send mails without using secure transmission will be denied mail delivery through the server.

The option that determines this is ‘Require clients to connect with SSL or issue the STARTTLS command before they are allowed to authenticate with the server’, which is set to ‘On’ by default, in WHM -> Exim Configuration Editor.

Setting it to Off will fix this issue 🙂

Your system has run out of available ip addresses, or you do not have permission to use any more ip addresses WHMCS

While activating a new account I could see an error

“Your system has run out of available ip addresses, or you do not have permission to use any more ip addresses”

The issue was due to the server running out of spare dedicated IP address

The issue can be resolved in 2 ways

1) Adding additional IP address in server

2) By editing file /var/cpanel/packages/abckhosting which is a package file which is assigned to customers.

SSH to server in question on which account is activated and edit the package file as mentioned

vi /var/cpanel/packages/abckhosting

The parameter IP=y needs to be changed to IP=n to get account activated without adding new IP address.

BWLIMIT=unlimited
CGI=y
CPMOD=paper_lantern
DIGESTAUTH=n
FEATURELIST=default
HASSHELL=n
IP=n
LANG=en
MAXADDON=5
MAXFTP=5
MAXLST=unlimited
MAXPARK=5
MAXPOP=unlimited
MAXSQL=10
MAXSUB=5
MAX_DEFER_FAIL_PERCENTAGE=unlimited
MAX_EMAIL_PER_HOUR=unlimited
QUOTA=100000
_PACKAGE_EXTENSIONS=

This did help in creating new account without adding additional IP address

How to fix invalid cPanel license error when the IP is in fact licensed

Was getting below error on cpanel server even when cpanel license was assigned for main server IP address

root@server4 [/etc/sysconfig/network-scripts]# /usr/local/cpanel/cpkeyclt
Updating cPanel license…Done. Update Failed!
Error message:
The cPanel license server said that there was no license for your IP address.
For more information visit: http://www.cpanel.net/lic.html

The exact message was: Abort, Retry, Fail?

Building global cache for cpanel…Done

The issue was due to wrong entries in /etc/hosts file

went ahead and set the correct hostname and IP in /etc/hots file and refreshed cpanel license

root@server4 [/etc/sysconfig/network-scripts]# /usr/local/cpanel/cpkeyclt
Updating cPanel license…Done. Update succeeded.
Building global cache for cpanel…Done
root@server4 [/etc/sysconfig/network-scripts]#

Ffmpeg on Centos 7 and Centos 6

Below steps are for Centos 7

yum -y install epel-release

rpm –import http://li.nux.ro/download/nux/RPM-GPG-KEY-nux.ro

rpm -Uvh http://li.nux.ro/download/nux/dextop/el7/x86_64/nux-dextop-release0-5.el7.nux.noarch.rpm

yum -y install ffmpeg ffmpeg-devel

Below steps are for Centos 6

yum -y install epel-release

rpm –import http://li.nux.ro/download/nux/RPM-GPG-KEY-nux.ro

wget https://li.nux.ro/download/nux/dextop/el6/x86_64/nux-dextop-release-0-1.el6.nux.noarch.rpm

rpm ivh nux-dextop-release-0-1.el6.nux.noarch.rpm

yum -y install ffmpeg ffmpeg-devel

now we need to install ffmpeg-php to get it working using PHP

yum -y install git
git clone https://github.com/tony2001/ffmpeg-php.git

cd ffmpeg-php

/usr/local/cpanel/3rdparty/php/56/bin/phpize

/opt/cpanel/ea-php56/root/usr/bin/phpize

./configure –with-php-config=/opt/cpanel/ea-php56/root/usr/bin/php-config

If you want to install on PHP 7 use

/opt/cpanel/ea-php7/root/usr/bin/phpize

[Usually before easyapache 4 only phpize would work] now as there are multiple version of PHP there is need to phpize from above path.

The path would changes based on php version

if you are using PHP 7 path will be /opt/cpanel/ea-php70/root/usr/bin/phpize and

/opt/cpanel/ea-php70/root/usr/bin/php-config

You can find path using find command

[root@server ffmpeg-php]# find / -iname phpize
/opt/cpanel/ea-php55/root/usr/bin/phpize

/opt/cpanel/ea-php56/root/usr/bin/phpize

/opt/cpanel/ea-php70/root/usr/bin/phpize

Do not use path ./usr/local/cpanel/3rdparty/bin/phpize

Before compiling ffmpegphp

need to make sure all need files are in /usr/include

When you install ffmpeg and ffmpeg-devel files get stored in /usr/include/ffmpeg however ffmpeg while compiling looks for files in /usr/include/ so need to copy files to /usr/include using below command

scp -r /usr/include/ffmpeg/* /usr/include/

Now you can go ahead and compile

./configure –with-php-config=/opt/cpanel/ea-php56/root/usr/bin/php-config

Note [Path /opt/cpanel/ea-php56/root/usr/bin/php-config will changed on which version you are installing ffmpeg]

[root@server ffmpeg-php]# find / -iname php-config

/opt/cpanel/ea-php55/root/usr/bin/php-config
/opt/cpanel/ea-php56/root/usr/bin/php-config
/opt/cpanel/ea-php70/root/usr/bin/php-config

now before making make and make install few things need to be modified.

mv /usr/include/libavutil/time.h /usr/include/libavutil/time.h_

now go ahead with make and make install

now again need to rename the above file

mv /usr/include/libavutil/time.h_ /usr/include/libavutil/time.h

ffmpeg modules will be installed in below path

root@server ffmpeg-php]# ls -al /opt/cpanel/ea-php56/root/usr/lib64/php/modules/
total 2712
drwxr-xr-x 2 root root 4096 Dec 7 07:07 .
drwxr-xr-x 4 root root 4096 Feb 22 2017 ..
-rwxr-xr-x 1 root root 32608 Feb 22 2017 bcmath.so
-rwxr-xr-x 1 root root 33792 Feb 22 2017 calendar.so
-rwxr-xr-x 1 root root 15584 Feb 22 2017 ctype.so
-rwxr-xr-x 1 root root 86928 Feb 22 2017 curl.so
-rwxr-xr-x 1 root root 180728 Feb 22 2017 dom.so
-rwxr-xr-x 1 root root 281640 Dec 7 07:07 ffmpeg.so
-rwxr-xr-x 1 root root 57792 Feb 22 2017 ftp.so

Now go ahead and add extension=ffmpeg.so to php.ini for the PHP version you need and restart apache

Disk sdd contains bios raid metadata

While trying to install OS on one of the servers, Was getting error

“Disk sdd contains bios raid metadata”

The issue was the drive present has RAID data as earlier it was used to create RAID in some other server.

So process was to delete all RAID data in it and get ready for the new OS install

[root@localhost ~]# dmraid -r
/dev/sdb: ddf1, “.ddf1_disks”, GROUP, ok, 1951170560 sectors, data@ 0

[root@localhost ~]# mdadm –zero-superblock /dev/sdb
mdadm: Couldn’t open /dev/sdb for write – not zeroing

[root@localhost ~]# dmraid -r
/dev/sdb: ddf1, “.ddf1_disks”, GROUP, ok, 1951170560 sectors, data@ 0

[root@localhost ~]# dd if=/dev/zero of=/dev/sdb bs=512 seek=1951170560
dd: writing `/dev/sdb’: No space left on device
2354609+0 records in
2354608+0 records out
1205559296 bytes (1.2 GB) copied, 16.0356 s, 75.2 MB/s

[root@localhost ~]# dmraid -r
no raid disks

Reboot Server

Once online can format the drive using mkfs

[root@localhost ~]# mkfs.ext4 /dev/sdb
mke2fs 1.41.12 (17-May-2010)
/dev/sdb is entire device, not just one partition!
Proceed anyway? (y,n) y
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=0 blocks
61054976 inodes, 244190646 blocks
12209532 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
7453 block groups
32768 blocks per group, 32768 fragments per group
8192 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000, 7962624, 11239424, 20480000, 23887872, 71663616, 78675968,
102400000, 214990848

Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 31 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.

Now I am able to install OS on it without any problem on it 🙂

Secure Connection Failed while accessing IPMI

Secure Connection Failed

An error occurred during a connection to 216.1x.1xx.xxx. You have received an invalid certificate. Please contact the server administrator or email correspondent and give them the following information: Your certificate contains the same serial number as another certificate issued by the certificate authority. Please get a new certificate containing a unique serial number. Error code: SEC_ERROR_REUSED_ISSUER_AND_SERIAL

The page you are trying to view cannot be shown because the authenticity of the received data could not be verified.
Please contact the website owners to inform them of this problem.

Firefox stores certificates separately from the Operating System. Sometimes the certificate store can become corrupt and won’t let you delete certificates. To solve this, you’ll have to reset it manually.

Go to Start > Run

Type %appdata% and click Ok.
Result: A folder should open up.

Now go to Mozilla, then Firefox, then Profiles, and choose your profile folder (it probably is named a random string of letters, often followed by .default).

Delete the file called “cert8.db”.

This should fix the issue .

IPAddress is already an active IP

While trying to change main IP of server was facing issue

Where was getting message IPAddress is already an active IP

On checking around found the below solution which worked

Make sure that the IP address you’re trying to add has been removed from these files:

/etc/hosts /etc/ips /etc/mail_reverse_dns

If you happen to also be trying to add back the IP that was previous the primary IP address, you will also need to update this file:

/var/cpanel/mainip

Now could add the IP address back in server

error reading information on service virtualizor: No such file or directory

While installing Virtualizor on one of the servers which had linux Centos 7 was getting error

[root@ny7 ~]# ./install.sh email=xxx@gmail.com kernel=kvm

———————————————–
Welcome to Softaculous Virtualizor Installer
———————————————–

An existing installation of Virtualizor has been detected !
If you continue to install Virtualizor, the existing installation
and all its Data will be lost
Do you want to continue installing ? [y/N]y
1) Installing Libraries and Dependencies
2) Installing PHP, MySQL and Web Server
3) Downloading and Installing Virtualizor
error reading information on service virtualizor: No such file or directory

Warning: include_once(_universal.php): failed to open stream: No such file or directory in /usr/local/virtualizor/install.php on line 1368

Warning: include_once(): Failed opening ‘_universal.php’ for inclusion (include_path=’.:’) in /usr/local/virtualizor/install.php on line 1368

Notice: Undefined index: path in /usr/local/virtualizor/install.php on line 1373

Warning: include_once(/globals.php): failed to open stream: No such file or directory in /usr/local/virtualizor/install.php on line 1373

Warning: include_once(): Failed opening ‘/globals.php’ for inclusion (include_path=’.:’) in /usr/local/virtualizor/install.php on line 1373

Notice: Undefined index: mainfiles in /usr/local/virtualizor/install.php on line 1376

Warning: include_once(/functions.php): failed to open stream: No such file or directory in /usr/local/virtualizor/install.php on line 1376

Warning: include_once(): Failed opening ‘/functions.php’ for inclusion (include_path=’.:’) in /usr/local/virtualizor/install.php on line 1376
– Configuring Virtualizor

Fatal error: Call to undefined function generateRandStr() in /usr/local/virtualizor/install.php on line 1388

ERROR :
There was an error while installing Virtualizor
Please check /root/virtualizor.log for errors
Exiting Installer
[root@ny7 ~]#

The issue was due to wrong time zone in server

I went ahead and setup NTP and synced time to fix the issue

[root@ny7 ~]# yum install ntp
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: mirrors.lga7.us.voxel.net
* extras: mirror.atlanticmetro.net
* updates: mirrors.lga7.us.voxel.net
Softaculous | 2.9 kB 00:00
Softaculous-extra | 2.9 kB 00:00
base | 3.7 kB 00:00
extras | 3.4 kB 00:00
updates | 3.4 kB 00:00
Resolving Dependencies
–> Running transaction check
—> Package ntp.x86_64 0:4.2.6p5-10.el6.centos.2 will be installed
–> Processing Dependency: ntpdate = 4.2.6p5-10.el6.centos.2 for package: ntp-4.2.6p5-10.el6.centos.2.x86_64
–> Running transaction check
—> Package ntpdate.x86_64 0:4.2.6p5-10.el6.centos.2 will be installed
–> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================================================================================
Package Arch Version Repository Size
============================================================================================================================================================================================================
Installing:
ntp x86_64 4.2.6p5-10.el6.centos.2 base 599 k
Installing for dependencies:
ntpdate x86_64 4.2.6p5-10.el6.centos.2 base 78 k

Transaction Summary
============================================================================================================================================================================================================
Install 2 Package(s)

Total download size: 678 k
Installed size: 1.8 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): ntp-4.2.6p5-10.el6.centos.2.x86_64.rpm | 599 kB 00:00
(2/2): ntpdate-4.2.6p5-10.el6.centos.2.x86_64.rpm | 78 kB 00:00
————————————————————————————————————————————————————————————————————
Total 2.9 MB/s | 678 kB 00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : ntpdate-4.2.6p5-10.el6.centos.2.x86_64 1/2
Installing : ntp-4.2.6p5-10.el6.centos.2.x86_64 2/2
Verifying : ntp-4.2.6p5-10.el6.centos.2.x86_64 1/2
Verifying : ntpdate-4.2.6p5-10.el6.centos.2.x86_64 2/2

Installed:
ntp.x86_64 0:4.2.6p5-10.el6.centos.2

Dependency Installed:
ntpdate.x86_64 0:4.2.6p5-10.el6.centos.2

Complete!
[root@ny7 ~]# service ntpd start
Starting ntpd: [ OK ]
[root@ny7 ~]# chkconfig ntpd on
[root@ny7 ~]# rm -rf /etc/localtime
[root@ny7 ~]# ln -s /usr/share/zoneinfo/America/Chicago /etc/localtime
[root@ny7 ~]# ntpdate pool.ntp.org
19 Sep 11:27:27 ntpdate[2345]: the NTP socket is in use, exiting
[root@ny7 ~]#
[root@ny7 ~]#
[root@ny7 ~]# date
Tue Sep 19 11:27:30 CDT 2017

Disable WordPress plugins from PHPmyadmin

You can easily disable all WordPress plugins directly from your database. This is useful when you have problems with your WordPress installation, such as not being able to log in to the admin Dashboard, or having blank pages on the website.

If you don’t know which is the database used by your WordPress website, you can check the DB_NAME variable in the WordPress configuration file – wp-config.php. This file is usually located in the document root directory of your application and can be opened via the File Manager in cPanel.

To disable all plugins, go to phpMyAdmin in cPanel and select your WordPress database from the menu on the left.

Browse the table wp_options and find the option active_plugins. Click the pencil icon to edit the table. Its content will vary, depending on what plugins you have enabled. For example, if you have the Akismet and Hello Dolly plugins enabled, the code there will be:

1	a:2:{i:0;s:19:“akismet/akismet.php”;i:1;s:9:“hello.php”;}

To disable all plugins, simply delete the code and click the Go button to save the change.

Please note that this table may have a different prefix instead of wp_. You will see the correct prefix of the database once you access the phpMyAdmin tool and select the the WordPress database.

Disabling the plugins in this way will not delete them from your WordPress application. They will simply be deactivated. You can easily activate them from your WordPress admin area at any time.