OpenCart

Most frequently asked questions

1. How to connect to MySQL (Web interface & CLI)

   Web Interface

   
   

   Adminer is a database management web applicarion

   
   

   URL : https://12.34.56.789:12322
   Username: adminer
   Password : 

   
   

   Command line

   
   

   MySQL command line tool log in as root (no password required):

   
   

   $ mysql --user root 
   Welcome to the MySQL monitor. Commands end with ; or \g. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 
   mysql>

2. How to connect to Cloud Application shell (Web interface & CLI)

   Web based command line

   
   

   URL :  https://12.34.56.789:12320/
   User : root

   
   

   SSH

   
   

   Login as root.

   
   

    

   
   

   From Windows you can access your server using a free simple SSH client program called Putty located at our Downloads.

   
   

   From Linux :

   
   

   ssh root@12.34.56.789

   
   

   * Replace 12.34.56.789 with a valid IP or hostname.

   
   

    

   
   

    

   
   

    

3. Hot to connect to System control panel (Webmin)

   System control panel

   
   

   Point your browser to:  https://12.34.56.789:12321/

   
   

   Username : root
   Password : 

   
   

   * Replace 12.34.56.789 with a valid IP or hostname.

   
   

    

4. What is Reverse DNS?

   Reverse DNS (rDNS) is name resolution that looks up an IP addresses to obtain a domain name, performing the opposite function of the DNS server, which turns domain names into IP addresses.

   
   

   Reverse DNS can be used as a spam filter. Typically, spammers use invalid IP addresses, that is, ones that do not match domain names. A reverse DNS program looks up the IP address of an incoming message and, if no valid domain name is found, the server blocks the message. Although reverse DNS is fairly effective for filtering spam, it also often blocks valid emails.

   
   

   Our administrators configure reverse DNS on all of our email servers. If you administrate your own server, you can contact your IP address's provider to configure reverse DNS.

5. Tune MySQL / mariadb database for WooCommerce and WordPress

   WooCommerce can really give mysql or mariadb a pounding.

   
   

   On smaller hosting platforms WooCommerce will grind to a halt.

   
   

   If you have a VPS, here are a few things you can tune, to give you fast database performance. The faster the database goes, the faster WooCommerce goes:

   
   

    

   
   

   InnoDb cache

   
   

   Assuming of course that you’re using innodb (which is a must – see below)

   
   

   innodb_buffer_pool_size=1024M

   
   

   The size should be as large as your wp_postmeta and wp_options tables, or 50% or more of your WooCommerce database. Don’t go above 25% of the RAM in your VPS.

   
   

    

   
   

   Query Cache

   
   

   There are a few articles out there saying disable query cache , but I think it really helps the WordPress wp_options table, which WooCommerce stores most of its data in.

   
   

   query_cache_limit=2M

   
   

   query_cache_size=64M

   
   

   query_cache_type=1

   
   

   If you have a lot more memory in your VPS, try this:

   
   

   query_cache_limit=8M

   
   

   query_cache_size=256M

   
   

   query_cache_type=1

   
   

    

   
   

   Make sure you’re using innodb

   
   

   Innodb is the fastest and most reliable database engine for mysql , mariadb, WordPress and WooCommerce. Here’s how to check.

   
   

   
   
   • Login to PHPMyAdmin
   
   
   • Select the database for your WP site.
   
   
   • Click the SQL tab.
   
   
   • Type this:   show table status
   
   
   • Click GO.
   
   

   
   

   You are looking for engine and you want InnoDB.

   
   

   If it’s myisam you need to fix it. Use this command in PHPMyAdmin (as above). make sure you have a good backup first.

   
   

   
   
   • ALTER TABLE tablename ENGINE = InnoDB
   
   
   • you’ll need to it for each table that was myisam  (replace tablename with each table)
   
   

6. Connecting using PuTTY on Windows workstations

   Configuring PuTTY
   
   

   
   

   
   
   1. In PuTTY, under Session, enter your Host Name
      
      
      
      
      
   
   
   2. Under Connection choose Data
   
   
   3. Enter your username as the Auto-login username
      
      
      
      
   
   
   4. Under SSH, choose 2 from Preferred SSH Protocol Version
   
   
   5. Under SSH -> Auth, you will need to specify where your private key can be found. Remember this is where you saved the private key on your local computer. Click Browse to locate the file on your computer.
      
      
      
      
   
   
   6. Under Sessions, type a name (such as "my site") in the Saved Sessions box and click Save.
   
   

7. Connecting using SSH on Linux or OSX workstations

   Use the ssh command to connect to your instance. Specify your username and the external IP address for the instance that you want to connect to.

   
   

   Download Prive Key from client area and save it to your workstation
   
   For this example, the private key is at ~/.ssh/my-ssh-key.
   
   ssh -i ~/.ssh/my-ssh-key USERNAME@IP_ADDRESS

   
   

   where:

   
   

   
   
   • USERNAME is your username
   
   
   • IP_ADDRESS is the IP for your Cloud Server.
   
   

   
   

   If the connection is successful, you can use the terminal to run commands on your instance.

   
   

   When you are done, use the exit command to disconnect from the instance.

8. How to create a .ppk from private key on Windows

   Using a Public/Private key to authenticate when logging into SSH can provide added convenience or added security. The Public/Private key can be used in place of a password so that no username/password is required to connect to the server via SSH. Instead the unique public and private key provide the secure authentication. The keys may also be generated with a different password from your cpanel password if desired.
   
   

   
   

   Generate a ppk file
   
   

   
   

   
   
   1. Download and open PuTTYgen here.
   
   
   2. Click Load
      
      
      
      
      
   
   
   3. Locate the private SSH key that you have downloaded. Note: You will need choose to display All Files* from the menu to the right of the File Name field. 
   
   
   4. Click the Save private key button to create the ppk file.
      
      
   
   

Still have questions ?

Visit our Knowledgebase →