How to play a midi file via html file

You need to use Javascript plugin

http://www.midijs.net

Include the library and specify to file you wish to play

<script src='http://www.midijs.net/lib/midi.js'></script>
<script>MIDIjs.play('/home/username/file.midi');</script>

Done

Source: https://stackoverflow.com/questions/5662293/how-to-play-a-midi-file-in-html… Read the rest

How to remove missed module

Probably you got error/warning The following module is missing from the file system, No such folder/file

To get list of installed modules

drush pm-list

Drupal 7 using Drush:

drush sql-query "DELETE from system where name = 'old_module1' AND type = 'module';"

Once done clear cache:

drush cc all

Drupal 8 using Drush:

drush sql-query "DELETE FROM key_value WHERE collection='system.schema'
Read the rest

How to fix RoundCube’s error: DATABASE ERROR: CONNECTION FAILED!

Mysql server and InnoDB engine must to be running!

Check mysql connection:

cat /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php |grep mysql:
$config['db_dsnw'] = 'mysql://roundcube:lasMubMX08D3HKtr@unix(/var/lib/mysql/mysql.sock)/roundcube';
mysql -u roundcube -p
show tables;

All tables should be in place:

+---------------------+
| Tables_in_roundcube |
+---------------------+
| cache               |
| cache_index         |
| cache_messages      |
| cache_shared        |
| cache_thread        |
| contactgroupmembers |
| contactgroups       |
| contacts            |
| cp_schema_version   |
| dictionary          |
| identities          |
| searches            |
| session             |
| system              |
| users               |
+---------------------+
15 rows in set (0.00 sec)

Cpanel keeps roundcube backups here:

/var/cpanel/roundcube

Go ahead and drop broken database

mysqladmin drop roundcube

Rebuild roundcube using the following two commands:

rpm -e --nodeps cpanel-roundcubemail

/usr/local/cpanel/scripts/check_cpanel_rpms --fix

Database roundcube should be recreated automatically.
Read the rest

How to install ClamAV (clamscan) via command line

Install EPEL repos:

yum install epel-release -y

Install ClamAV packages:

yum install clamav -y

Update ClamAV’s signatures:

/usr/bin/freshclam

Or

Downloading stable version from https://www.clamav.net/downloads

cd /usr/local/src
wget https://www.clamav.net/downloads/production/clamav-0.103.3.tar.gz
tar -xvf clamav-0.103.3.tar.gz
cd clamav-0.103.3
./configure --sysconfdir=/var/lib/clamav --exec_prefix=/usr/
make && make install

Check for binary file:

which clamscan

Source: https://www.clamav.net/downloadsRead the rest

How to show a real multisite WordPress super admin users via MySQL command line

For multisite WordPress version run the following commands:

mysql
use database_name;
SELECT * FROM wp_sitemeta where meta_key='site_admins';

This will also allow you to know which users can access plugins for management… Read the rest

How to enable Inline HTML display in Horde

cPanel’s Horde has “Inline HTML” is disabled by default

The error you probably got:

##
This message part contains HTML data, but inline HTML display is disabled.
View HTML data in new window.
Convert HTML data to plain text and view in new window.
Read the rest

How to update server’s time

I did it on OpenVZ server and it works like a charm

rm -fv /etc/localtime
ln -s /usr/share/zoneinfo/GMT /etc/localtime
or
ln -s /usr/share/zoneinfo/CST6CDT /etc/localtime

Note the sym link may not work, so just copy file physically

Set date and sync it on hardware

date 081209312016
hwclock --systohc

The syntax is `date MMDDhhmmYYYY`.… Read the rest