vpslinux

Reseller should be signed up for the VPS Linux US or VPS Linux IN Product.

Installing phpMyAdmin

phpMyAdmin is a free, php and web browser based, open source, administration tool for MySQL. If your web application or website requires MySQL database, it is recommended that you install phpMyAdmin for easier database management.

Note
  • This documentation assumes you've already installed the LAMP stack on your VPS. If you haven't done that yet, refer to the LAMP installation guide.

    Additional Information

    Getting your VPS LAMP ready

  • Ensure that you are connected to the server using an SSH client as a root user.

  • You need not follow this documentation, in case you have installed cPanel or Plesk. phpMyAdmin comes pre-installed with these panels.

To Setup MySQL

Check whether the MySQL service is already running by using the command:

service mysqld status

If the service is currently not running, you can start it using the command:

service mysqld start

To Setup MySQL User

Set the MySQL Server's root password.

Note
  • This is the root user for MySQL Server, and is different from the VPS container's root user.

  • Since this is the first login, the service will not require any password to connect as root.

Use the command:

mysqladmin -u root password <your_new_password>

To Install phpMyAdmin

  1. Before you install phpMyAdmin using yum, you will have to install EPEL or RPMForge repository. This is because phpMyAdmin is not included by default in CentOS repository. In this example, EPEL is used.

    Execute the following commands:

    cd /tmp
    wget https://mirror-fpt-telecom.fpt.net/fedora/epel/6/i386/epel-release-6-8.noarch.rpm
    rpm -ivh epel-release-6-8.noarch.rpm

  2. Proceed with the yum installation of phpMyAdmin using the command:

    yum -y install phpmyadmin

To Configure phpMyAdmin

phpMyAdmin can be accessed only from localhost, by default. To access it from your local system, you will have to change the configuration settings. Edit the file phpMyAdmin.conf, which
can be found under /etc/httpd/conf.d.

vi /etc/httpd/conf.d/phpMyAdmin.conf

Edit the file as below:

  • Comment the Deny directive,

    AND

  • mention your IP Address for Allow from.

Configuring phpMyAdmin

Note

You may customize the access settings as per hostname, IP Address and IP Address range depending on your needs. It is recommeded that you limit its access for security reasons.

To Restart Apache and Start Using phpMyAdmin

Restart the httpd service using the command:

service httpd restart

Now, you can access https://<Your_IP_Address>/phpMyAdmin or https://<Your_Domain_Name>/phpMyAdmin.

Note

You can customize the settings further as deemed necessary.

Additional Information

phpMyAdmin Documentation

Getting your VPS LAMP ready

LAMP stands for Linux (Operating System), Apache HTTP Server, MySQL (Database) and PHP. Of these components, the Operating System and HTTP services come pre-installed with your VPS package. You
need to install MySQL and PHP manually.

Note
  • This documentation assumes that you are connected to the Server using an SSH client as a root user.

  • If you have installed cPanel or Plesk, you need not follow this documentation. Such hosting panels take care of all the services and applications that are part of them. For example, cPanel auto-installs MySQL,
    phpMyAdmin and PHP.

To Install PHP

  1. Start the installation using the command:

    yum install php

  2. Follow the onscreen instructions and reply by typing y, when prompted.

    Installing PHP

    Note

    If you want such prompts to be auto-answered as yes, specify -y in the installation command. For example, yum -y install php.

  3. This completes the installation of PHP.

    Installing PHP

To Install MySQL

Proceed with the installation using the command below. This installs MySQL server along with MySQLi.

yum install mysql-server mysql php-mysql

To Start the Services

For the configuration changes to take effect, the services need to be started/restarted. Start the MySQL service using the command:

service mysqld start

PHP runs on Apache and you would thus need to restart the httpd service using the command:

service httpd restart

To Auto-Start the Services

Its a good practice to setup important services on your Server as Auto-Start. This ensures that such services start automatically every time your VPS is started or rebooted. Run the commands below to auto-start Apache and MySQL services:

chkconfig httpd on
chkconfig mysqld on

You can now run web applications or your website(s) that require the LAMP stack.

Understanding Virtuozzo Power Panel

Virtuozzo (VZPP) or Parallels Power Panel (PPP) is a web based administration panel for your VPS container.

You can access this panel using the below details -

URL: https://<Your_IP_Address>:4643

Username: root

Password: Password for the root user

Manage your VPS Container through Virtuozzo (VZPP) or Parallels Power Panel (PPP)

You can treat your Virtual Server just as any other server, and carry out the following operations through this panel -

Note

It is advisable to use WHM root, if installed and wherever possible, since cPanel's services configurations are different from the default template installation. However, you need PPP for Starting, Stopping, Restarting, and File Manager options.

  • Start / Stop / Restart / Suspend: A container can be managed (start / shut down / restart / suspend) like an ordinary computer using the options on top of the panel.

  • Change Password: This option lets you change your VPS password.

    Note

    The new password is to be used to access the Power Panel, SSH, and WHM root.

  • File Manager: This is the web based file manager for the root user.

  • Resources: This section gives you an overview of resources utilization for CPU, Memory, and Disk. You should make a note of resources nearing their capacity and take necessary action to avoid any interruptions in the service.

  • System Services: This option lets you Start, Restart, Stop and Autostart (starts automatically on container startup) the services such as crond, httpd, iptables, sshd, etc.

  • System Processes: This lists all the running applications/processes in a tabular format with information of PID, CPU%, Mem%, Command, User, etc.

  • Status Changes: All the changes in the status of your container are logged and displayed on this page. Status can be Starting, Restarting, Stopping or Running.

  • Tasks log: This section displays the last 20 operations performed on a container using the PPP in order of the Task name, Status (Completed/Failed) and a detailed report.

  • Firewall: You may use this option in case of any connectivity issues with your container.

Note

Re-Install and Repair options cannot be used through your PPP as they require certain administrative privileges on the server.

VPS - Control Panel Guides

Access your Control Panels

Control Panel Guides

All instructions for using these panels are provided in the respective links below.

Virtuozzo Power Panel (Anchor: virtuozzo)

Note

All instructions for using your Virtuozzo Power Panel are available in the Power Panel Users Guide. See details

WHM (Anchor: whm)

Note

All instructions for using your WHM interface are available in the WHM User Guide. See details

cPanel (Anchor: cpanel)

Note

All instructions for using your cPanel interface are available in the cPanel User Guide. See details

WHMCS (Anchor: whmcs)

Get Reseller Pricing

Description

Use this method to get details of the pricing for the VPS Linux plans for your Sub-Resellers.

Response

Returns a map with the prices of the VPS Linux plans along with the prices of the other products.

The response structure for the VPS Linux product will be:


"productkey":
{
"addons":
{
"addon1-name":price,
"addon2-name":price
},
"plans":
{
"planid":
{
"action":
{
"tenure-in-months":price
},
}
}
}

Example:

Get Customer Pricing

Description

Use this method to get details of the pricing for the VPS Linux plans.

Response

Returns a map with the prices of the VPS Linux plans along with the prices of the other products.

The response structure for the VPS Linux product will be:


"productkey":
{
"addons":
{
"addon1-name":price,
"addon2-name":price
},
"plans":
{
"planid":
{
"action":
{
"tenure-in-months":price
},
}
}
}

Example:

Get Modify/Upgrade Price

Description

Gets the applicable modify/upgrade price for a particular VPS Linux Order.

Parameters

Name Data Type Required / Optional Description
auth-userid Integer Required Authentication Parameter
api-key String Required Authentication Parameter
order-id Integer Required Order ID of the Order for which the details are to be fetched
new-plan-id Integer Required The new plan to which the Order is to be upgraded/downgraded. To fetch the plan details: plan-id etc., use this method.
months Integer Optional The number of months (tenure) in the new plan for which the Order to be placed. Default value is remaining months of the VPS Linux Order.

HTTP Method

GET

Example Test URL Request


Response

Returns the applicable modify/upgrade price for a particular VPS Linux Order.

Example:


{
"upgradecost":0.0,
"modifiedOrderPrice":0.0,
"endtime":"0000000000",
"remainingmonths":0,
"currentOrderPrice":0.0
}

where

  • currentOrderPrice: The current pricing of the Order for remaining months.

  • modifiedOrderPrice: New applicable pricing of the Order as per the new plan.

  • upgradecost: Actual price applicable i.e. modifiedOrderPrice - currentOrderPrice