loader

Categories

One click apps (20 Articles)

Tutorials about the VPSie app templates

How To’s (168 Articles)

In this category goes all How To’s related to VPSie

PCS( 5 Articles)

Tutorials about different scenarios configuring VPSie private cloud
Nov 2, 2014

How to create SugarCRM platform on VPSie in minutes

In this tutorial we will show you how to deploy SugarCRM application and finish the installation of SugarCRM after you have deployed the vpsie. First you need to go to vpsie tab and click on the Create New Vpsie button. On the first part you need to select the package with the specs of the package you want to install your application. Select package Once you have selected the package you want to use you need to choose the datacenters the IP settings you want for your vpsie and select the ssh key if you choose to use passwords login. Select DC Next you need to select the Apps tab and in there click on SugarCRM Select appThen complete the hostname and click on Create VPSie button. create vpsie You need to wait until your vpsie will be created. Once the vpsie is done you will be getting an e-mail with the IP addresses and password to access your vpsie. VPSie created Once the vpsie is deployed you will have to log in via ssh or console to your vpsie to get your username and password to be able to access your installation via browser. The information you will be getting will look like this:  
Welcome to your SugarCRM vpsie.

To access your SugarCRM please go to http://

Please log in using the following credentials:

Login: Admin

Pass: 7x8vd8bo

For a step by step tutorial visit: https://vpsie.com/create-sugarcrm-platform-vpsie-minutes
You will need to install 3 modules for php. To do so please run the following commands:
#apt-get -y install php5-imap php5-curl php5-gd
When you run that command line you will be asked if you want the tool to reload the services. It is recommended to accept otherwise you will have to restart them manually. After you logged in via the HTTP choose your language and click next. Read the information provided on the next screen then click Next on the bottom of the page. Read the License Agreement and ones you have read it and accepted it check the checkbox then click Next again. On the next page you have to choose between typical or custom installation. Since this tutorial is for beginners we will move along with Typical installation. After you clicked next make sure that the radio button is checked on the Mysqli option then move to the next page. Set the following : database name: sugarcrm database hostname: localhost database username: SugarCRM database password: 5ug4rCRM  or you can change it by logging in to mysql with the following command:
#mysql -u root
mysql> grant all privileges on sugarcrm.* to 'SugarCRM'@'localhost' identified by 'some new secured password';
mysql> flush privileges;
mysql> quit;
Once you have set all the information on the page choose to install or not the demo data then click Next to move forward to the next page. A popup windows will appear asking you to verify the database credentials. You click “I Accept”. Once that is done you will be asked to set up your administrator username and password. On the next page there will be printed some information about your installation. Please make sure that everything is alright before you click install. Once the installation is done you will be asked to register (this is optional) if you choose to not to then just click next and you will be ready to use your new SugarCRM installation. To disable the http authentication please follow the tutorial on the following post: https://vpsie.com/disable-http-authentication-nginx/ For a one month free trial use this link to create your account
Since we have quite a few VPSie apps which are using mysql database, and we don’t want to force anyone in using a preset password we have left that to your choice. To set up a root password for mysql servers you have to have a running mysql server therefore you have to run the following command:
#service mysqld restart
Now since you are sure that you have successfully restarted the server you can check if your mysql server is actually running by running a netstat on your linux.
#netstat -ntlp
This will show you all the applications which are listening on your server. The output should look something like this:
# netstat -ntlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      960/mysqld      
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      904/nginx       
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      876/sshd        
tcp6       0      0 :::80                   :::*                    LISTEN      904/nginx       
tcp6       0      0 :::22                   :::*                    LISTEN      876/sshd        
Mysql servers are running by default on port 3306 therefore if you see the port 3306 listening you are good to go. Next step is to set the root password so that noone would have passwordless access to your databases. You will be doing that by using the following command:
#mysqladmin -u root password 'some_very_hard_and_complicated_password'
To check that the password was configured you can login to your mysql database:
#mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 5.5.37-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
When prompted for the password use the password which you have configured the previous step. To leave the mysql prompt just type quit or \q. In case you have lost/forgotten your mysql root password you can reset it. For that first you will need to stop the mysql server and start it in safe mode.
#service mysqld stop
#mysqld_safe --skip-grant-tables
You should see the mysql server started and be able to log in without a password into it. Now connect to the mysql database and run the following query to reset your mysql password:
#mysql --user=root mysql
mysql> update user set Password=PASSWORD('new-password') where user='root';
mysql> flush privileges;
mysql> exit;
Kill your running mysql service and start it normally.
#killall -9 mysqld_safe
#service mysqld start
Now your mysql password has been reset and you can safely login to your database with your new password.

You can actually try those MySQL server steps on our platform in few minutes utilizing our PCS (Private Cloud Solution) which allows you to have VPSie(s) on a private network – NAT – Port forward – traffic control for inbound and outbound – multiple gateway IPs which you could use for the load-balancing and failover.