Allow access from an IP address

If you want to give access to your domain only for a single IP address. In such case, create an htaccess file(.htaccess) and add the content given below.


Order Deny,Allow
Deny from all
Allow from <ip address>

Note: replace the <ip address> with the original IP address.

Retrieve Plesk password in windows server

There are two ways by which we can retrieve the Plesk password.


Method 1:
=========
1. Login to server via RDP and take command prompt
2. Execute the following command from the command prompt.

=====
"%plesk_bin%\plesksrvclient" -get
=====

Method 2:
========

1. Login to server via RDP and take command prompt
2. Type %Plesk_bin% to go to Plesk binary.
3. Now type plesksrvclient.exe -get


eg: C:\Program Files\Parallels\Plesk\admin\bin>plesksrvclient.exe -get

Webalizer statistics not getting updated

Issue
=====
Sometimes,  webalizer will  not get updated automatically. Then, we need to update the webalizer manually by using following command.

/usr/local/cpanel/3rdparty/bin/english/webalizer -N 10 -D /home/username/tmp/webalizer/dns_cache.db -R 250 -p -n domain.com -o /home/username/tmp/webalizer /usr/local/apache/domlogs/domain.com

Note: Replace domain.com with original domain name.

Joomla Error: jtablesession::Store Failed DB function failed with error number 145

Error:
=====
Joomla Error – jtablesession::Store Failed DB function failed with error number 145

You can fix this issue by following the steps given below.

1) Login into phpmyadmin.
2) Select the database.
3) Select the table jos_session.
4) Select the option repair.


You can also fix this using MySQL query.

1) mysql> use databasename;  (Replace databasename with original name)

2) mysql> repair table jos_session;

Joomla error: Fatal error: Call to undefined function jimport()

You may sometimes see Joomla error similar to the one given below:

Fatal error: Call to undefined function jimport() in /home/username/public_html/includes/framework.php on line 76

Solution:
========
You can resolve this issue by simply replacing the folder "libraries" from backup(if you have).

Joomla error: send mail failed: could not execute: /usr/sbin/sendmail

Error
======

send mail failed: could not execute: /usr/sbin/sendmail

You will be redirected to the homepage now


Solution
========
Login as Joomla administrator and change the mailer from 'Sendmail' to PHP mail function.

Site->Global Configuration->Mail

Change database engine

You can specify the database engine type you want to use, during table creation using the query :

-------------
CREATE TABLE table_name (a INT, b CHAR (20)) ENGINE=InnoDB;
------------

If the table already exists use the query given below.

----------------
ALTER TABLE 'table_name' Engine=InnoDB charset=utf8 collate=utf8_bin;
----------------