How to remove missed module

1090  admin  
(last edited )

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!

1080  admin  

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

1077  admin  
(last edited )

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/downloads… Read the rest

FormMail script

1074  admin  

Follow the links below:

http://scriptarchive.com/readme/formmail.html

http://scriptarchive.com/download.cgi?s=formmail

You need to upload the formmail script to cgi-bin/ folder and set permissions for formmail.pl to 755. Then change one line in the .pl script:

from: @referers = ('scriptarchive.com','YOUR_IP'); to: @referers = ('yourdomain.com','www.yourdomain.com');

You will need to add the following lines to your contact form:

<input type=hidden name="recipient" value="[email protected]">
… Read the rest

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

1060  admin  
(last edited )

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 fix “PayPal Instant Payment Notification (IPN) messages”

1058  admin  

Your got message with the following text:

###

Please check your server that handles PayPal Instant Payment Notification (IPN) messages. Messages sent to the following URL(s) are not being received:
 

http://yourdomain.com/url


If you do not recognize this URL, you may be using a service provider that is using IPN on your behalf.… Read the rest