Why I get access not allowed after changing password on PHPmyAdmin?

Standard

Sometimes when you change password for a account, it will say that mySQL pasword was changed (but it is either left the old one or added wrong one) so when you login to cPanel and start PhpMyAdmin you will get access not allowed error.

Workaround:
go to section MYSQL in whm and change passwords for users in that database once again. :)

How to redirect your site using a .htaccess file

Standard

As a configuration file, .htaccess is very powerful. Even the slightest syntax error (like a missing space) can result in your content not displaying correctly or at all.

Since .htaccess is a hidden system file, please make sure your FTP client is configured to show hidden files. This is usually an option in the program’s preferences/options.

1. Create an empty text file using a text editor such as notepad, and save it as htaccess.txt.

2. Edit the contents of the file. Check the following examples:

301 (Permanent) Redirect: Point an entire site to a different URL on a permanent basis. This is the most common type of redirect and is useful in most situations.

# This allows you to redirect your entire website to any other domain
Redirect 301 / http://mirhoseini.com/

302 (Temporary) Redirect: Point an entire site to a different temporary URL. This is useful for SEO purposes when you have a temporary landing page and plan to switch back to your main landing page at a later date:

# This allows you to redirect your entire website to any other domain
Redirect 302 / http://mirhoseini.com/

Redirect index.html to a specific subfolder:

# This allows you to redirect index.html to a specific subfolder
Redirect /index.html http://mirhoseini.com/newdirectory/

Redirect az old file to a new file path:

# Redirect old file path to new file path
Redirect /olddirectory/oldfile.html http://mirhoseini.com/newdirectory/newfile.html

Redirect to a specific index page:

# Provide Specific Index Page (Set the default handler)
DirectoryIndex index.html

3. Upload this file and re-name it to .htaccess.

Changing whole server WHM charset from iso-8859-1 to utf-8

Standard

In httpd.conf add (or change if it’s already there):

AddDefaultCharset utf-8

or

Add this to your .htaccess:

IndexOptions +Charset=UTF-8

You can make changes to the /usr/local/lib/php.ini file via:
“WHM Home » Service Configuration » PHP Configuration Editor”

Adjusting the “default_charset” value via this option will update the php.ini file accordingly.
Remember to restart Apache after making the change to ensure it takes effect.

What cause 500 Internal Server Error?

Standard

A 500 Internal Server Error can be caused by many things, including but not limited to invalid permissions, invalid ownership, bad lines in your php.ini or .htaccess file, invalid requests in the script, and others not mentioned here. Typically this is not a problem with the server itself, and can be most often resolved by modifying something in your site’s configuration. Please check the Error Logs in cPanel for specific information.

What are A, AAAA, MX, CNAME, SRV and TXT (SPF) records?

Standard

A record is the most common type of DNS resource record. It tells a DNS server what IP address to map a host name to. With an A record, you can set www.yourname.com to point a specific IP address.

AAAA is the IPv6 version of an A record. IPv6 addresses are normally written as eight groups of four hexadecimal digits, where each group is separated by a colon.

MX a mail exchanger is a server setup to accept mail for your domain name and either holds it for delivering to your users or passes it to another mail server. To receive internet mail, your mail server should be SMTP compliant and run on port 25. For UNIX variants, two popular servers are qmail and sendmail. The MX record tells other mail servers where mail for your domain should go. The record should point to an A record. MX records have what are called “Preference Settings.” Preference settings tell other mail servers which server to try to deliver mail to first. The MX record with the lowest preference setting is the first server that is tried. When the primary server is not available, mail deliveries will go to the next lowest preference MX record. Higher preference mail servers should be set up to forward received mail to the lowest preference MX record.

CNAME record is a domain alias, and points a host name to another host name. Our interface automatically chooses whether a record is a CNAME or an A record based on the type of data you supply. If you type in an IP, it’s an A record. If you type in another host name (www.cnn.com), the record is set as a CNAME.

SRV refers to service record. It is a category of data in the Internet Domain Name System specifying information on available services. It is defined in RFC 2782. SRV records must point to the canonical name of the host. Aliases or CNAMEs cannot be used as valid targets.

SPF (Sender Policy Framework) is an e-mail authentication system that verifies that the message came from an authorized mail server. SPF is designed to detect messages from spammers and phishers who falsify the sender’s IP address in the e-mail header. SPF is an extension to the SMTP mail protocol.

The DNS system identifies the IP address of a receiving mail server with a line of text in the DNS database known as an MX record. DNS also supports a “reverse MX” record, which identifies the sending mail server and is used by SPF. When an e-mail message is received, the mail server checks the SPF record in the DNS to see if it matches the actual IP address of the message. If it does, the e-mail is considered valid.

How to create SSH Proxy Tunnel with PuTTY

Standard

Configuring PuTTY

  1. Fire up the client and enter the hostname and port
  2. Type in a title under Saved Sessions and press Save
  3. On the left side, go to Connection->SSH->Tunnels
  4. In Source Port enter 8080 (this can be configured to be whatever you want, just remember it)
  5. Choose the Dynamic radio button under Destination
  6. Press Add, you should then see D8080 in the box above
  7. Go back to Session on the left side and then press Save to save the changes

SOCKS Proxy

To utilize the tunnel to its full benefit, you need to set up a SOCKS proxy in your browser. Will describe how to use the Proxifier. It works for all Windows applications.

  1. Download Proxifier.
  2. Go to the Profile -> Proxy Servers
  3. Click Add…
  4. Enter localhost in the Address box
  5. Enter 8080 in the Port box
  6. Check SOCKS Proxy and make sure the SOCKS v5 radio is checked
  7. Press Ok to save

enjoy it… ;)

How to restore a cPanel Full backup from another server

Standard

If you don’t have a complete cPanle backup and have the Home Directory contents only, then I suggest you the following step,
1) Create New Account in WHM
2) Upload the Home Dir backup file (ZIP or TAR or GZ) to the corresponding accounts home path
3) Login into SSH, browse to the corresponding account’s home path and extract it using the tar command (only if the file is too big) else if the backup file is small you can extract it within the cPanel’s file manager itself.

If you can get Complete cPanel Backup File:
1) In the source cPanel goto Backups Section > Generate a Full Backup. Make the full backup file to be uploaded into some other site’s public path
2) Now SSH into your VPS’s root path
3) Create a directory called home2 in the root path and browse inside it
4) Now get the complete backup file using wget command
5) Once the file is downloaded, you can now login into the WHM as root and in the Left sidebar choose Complete Restore/cpmove restore
6) It will scans and displays the file you uploaded into the home2 folder
7) Now enter the cPanel’s username ( can be found in the file itself ) and click restore.