Dev-mysql-maint error occurred during the installation of VHCS Control panel

Error message:

Can’t connect on ‘DBI:mysql:;localhost’ :Access denied for user ‘debian-sys-maint’@'localhost’ (using password: YES)

The issue occurring due to the absence of grant privilege (to the user dev-mysql-maint) on the databases.

You obtain details of "dev-mysql-maint" from /etc/mysql/debian.cnf.

One example is mentioned below:

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = 0nQp8g7pmupSbcpg
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
user = debian-sys-maint
password = 0nQp8g7pmupSbcpg
socket = /var/run/mysqld/mysqld.sock
basedir = /usr

You need to grant the privileges to dev-mysql-maint, according to the above information.

grant all privileges to *.* on 'dev-mysql-maint'@'localhost' identified by '0nQp8g7pmupSbcpg' with grant option;

Note: Modify the password according to the information in /etc/mysql/debian.cnf.

File manager login issue with VHCS control panel

Check the /etc/proftpd/modules.conf file and make sure that following LoadModule is mentioned in it.

LoadModule mod_sql.c

Modify the /etc/proftpd/proftpd.conf with the following details:

UseIPv6 off

Also include the following section in /etc/proftpd/proftpd.conf.


SQLBackend mysql
Include /etc/proftpd.conf


You need to disable (comment out) PostgresSQL Module in /etc/proftpd/modules.conf.

LoadModule mod_sql_postgres.c

Restart the proftpd.

KeySize error occurred during the installation of VHCS control panel

Add the following entry in 1887th line of /var/lib/dpkg/info/vhcs.postinst.

keysize => 32,

You need to enter this value before "key => " part.

After this modification run the script:

/var/www/vhcs2/engine/vhcs2-rqst-mngr

You will get another error message saying:

 If specified by -literal_key, then the key length must be equal to the chosen cipher’s key length of 56 bytes at /var/www/vhcs2/engine//vhcs2_common_code.pl line 1443 Compilation failed in require at ./var/www/vhcs2/engine/vhcs2-rqst-mngr line 33. 

You need to add an entry in 1441-th line of /var/www/vhcs2/engine/vhcs2_common_code.pl to fix this issue

modify following code:

my $cipher = Crypt::CBC -> new(
{
‘key’ => $main::db_pass_key,
‘cipher’ => ‘Blowfish’,
‘iv’ => $main::db_pass_iv,
‘regenerate_key’ => 0,
‘padding’ => ’space’,
‘prepend_iv’ => 0
}
);

to

my $cipher = Crypt::CBC -> new(
{
‘keysize’ => 32,
‘key’ => $main::db_pass_key,
‘cipher’ => ‘Blowfish’,
‘iv’ => $main::db_pass_iv,
‘regenerate_key’ => 0,
‘padding’ => ’space’,
‘prepend_iv’ => 0
}
);

This will fix the issue.