{"id":19067,"date":"2016-04-27T08:02:33","date_gmt":"2016-04-27T13:02:33","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=19067"},"modified":"2022-06-03T03:43:37","modified_gmt":"2022-06-03T08:43:37","slug":"install-prosper202-with-nginx-mysql-and-php-fpm-on-ubuntu","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/install-prosper202-with-nginx-mysql-and-php-fpm-on-ubuntu\/","title":{"rendered":"Install Prosper202 with Nginx, MySQL and PHP-FPM on Ubuntu"},"content":{"rendered":"
In this tutorial we are going to show you how to install Prosper202. Made by Tracking202, Prosper202 is a self-hosted application that lets you track and optimize all your marketing campaigns. It’s open source and easy to install on a Linux VPS<\/a>. Follow the steps below to install Prosper202 on Ubuntu 14.04<\/strong>.<\/p>\n <\/p>\n The following are the minimum system requirements for Prosper202:<\/p>\n – PHP version 5.4 or greater. Go ahead and connect to your server via SSH<\/a>. The first thing you need to do is to upgrade all your system software to the latest version available: Run the following command:<\/p>\n We are going to use Nginx as a web server in this tutorial. Once the update process is completed you can install Nginx<\/strong> on your Ubuntu VPS<\/a> using the following command:<\/p>\n Start Nginx and enable it on system boot:<\/p>\n The next thing you need to do is to install MySQL 5.6<\/strong> on your server. Use the following command:<\/p>\n Proceed with the MySQL secure installation:<\/p>\n Follow the on-screen messages to configure MySQL:<\/p>\n Start the MySQL service and enable it on system boot:<\/p>\n If you have MySQL server already installed on your server, you can check its version using the following command:<\/p>\n You should see something like the following on your screen:<\/p>\n The next component that needs to be installed is PHP-FPM. Install PHP-FPM<\/strong> using the command below:<\/p>\n Create a directory for Prosper202:<\/p>\n Now, download the latest release of Prosper202 from http:\/\/prosper.tracking202.com\/download and unzip the downloaded file in the ‘\/var\/www\/prosper202\/’ directory on your server. Or, use the following command to download and unzip the Prosper202 installation in the ‘\/var\/www\/prosper202\/’ directory:<\/p>\n Once you do that, change the ownership of the files:<\/p>\n Create an Nginx configuration file for Prosper202:<\/p>\n Enter the following content:<\/p>\n Make sure that you replace yourdomain.com with your actual domain name. Since Prosper202 stores its data into a MySQL database, you need to create a database for it. Log into MySQL as root:<\/p>\n Create a new database for Prosper202, a database user and set up a password using the commands below:<\/p>\n The final step is to open your favorite web browser and enter your domain name into the search bar. You should follow the on-screen instructions to complete the Prosper202 installation.<\/p>\n Of course you don\u2019t have to do any of this if you use one of our Linux VPS hosting <\/a>services, in which case you can simply ask our expert Linux admins to install Prosper202 for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n PS. If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":" In this tutorial we are going to show you how to install Prosper202. Made by Tracking202, Prosper202 is a self-hosted … <\/p>\n
\n– MySQL version 5.6 or greater.
\n– MySQLi extension enabled in PHP<\/p>\n# apt-get update && apt-get -y upgrade<\/pre>\n
# apt-get install nginx<\/pre>\n
# service nginx start\r\n# update-rc.d nginx enable<\/pre>\n
# apt-get install mysql-server-5.6 mysql-client-5.6<\/pre>\n
# mysql_secure_installation<\/pre>\n
Enter current password for root (enter for none):\r\nOK, successfully used password, moving on...\r\n\r\nSet root password? [Y\/n] y\r\nNew password:\r\nRe-enter new password:\r\nPassword updated successfully!\r\nReloading privilege tables..\r\n ... Success!\r\n\r\nRemove anonymous users? [Y\/n] y\r\n ... Success!\r\n\r\nDisallow root login remotely? [Y\/n] y\r\n ... Success!\r\n\r\nRemove test database and access to it? [Y\/n] y\r\n - Dropping test database...\r\nERROR 1008 (HY000) at line 1: Can't drop database 'test'; database doesn't exist\r\n ... Failed! Not critical, keep moving...\r\n - Removing privileges on test database...\r\n ... Success!\r\n\r\nReload privilege tables now? [Y\/n] y\r\n ... Success!<\/pre>\n
# service mysql start\r\n# update-rc.d mysql enable<\/pre>\n
# mysql --version<\/pre>\n
# mysql --version\r\nmysql Ver 14.14 Distrib 5.6.28, for debian-linux-gnu (x86_64) using EditLine wrapper\r\n<\/pre>\n
# apt-get install php5-fpm php5-mysql<\/pre>\n
# mkdir \/var\/www\/prosper202<\/pre>\n
# cd \/var\/www\/prosper202\/ && wget http:\/\/my.tracking202.com\/clickserver\/download\/latest && unzip latest<\/pre>\n
# chown www-data: -R \/var\/www\/prosper202<\/pre>\n
nano \/etc\/nginx\/sites-available\/yourdomain.com<\/pre>\n
server {\r\n #listen 80; ## listen for ipv4; this line is default and implied\r\n #listen [::]:80 default ipv6only=on; ## listen for ipv6\r\n\r\n root \/var\/www\/prosper202;\r\n index index.php index.html;\r\n\r\n # Make site accessible from http:\/\/localhost\/\r\n server_name www.yourdomain.com yourdomain.com;\r\n\r\n location \/ {\r\n # First attempt to serve request as file, then\r\n # as directory, then fall back to index.html\r\n try_files $uri $uri\/ \/index.html;\r\n }\r\n\r\n error_page 404 \/404.html;\r\n\r\n # redirect server error pages to the static page \/50x.html\r\n error_page 500 502 503 504 \/50x.html;\r\n location = \/50x.html {\r\n root \/usr\/share\/nginx\/www;\r\n }\r\n\r\n # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000\r\n location ~ \\.php$ {\r\n fastcgi_split_path_info ^(.+\\.php)(\/.+)$;\r\n # NOTE: You should have \"cgi.fix_pathinfo = 0;\" in php.ini\r\n\r\n # With php5-cgi alone:\r\n # fastcgi_pass 127.0.0.1:9000;\r\n # With php5-fpm:\r\n fastcgi_pass unix:\/var\/run\/php5-fpm.sock;\r\n fastcgi_index index.php;\r\n include fastcgi_params;\r\n }\r\n}<\/pre>\n
\nEnable the configuration and restart the Nginx service:<\/p>\n# ln -s \/etc\/nginx\/sites-available\/yourdomain.com \/etc\/nginx\/sites-enabled\/yourdomain.com\r\n# service nginx restart<\/pre>\n
# mysql -u root -p<\/pre>\n
mysql> CREATE DATABASE prosper202DB;\r\nmysql> GRANT ALL PRIVILEGES ON prosper202DB.* TO 'prosper202'@'localhost' IDENTIFIED BY 'YoUrPaSsWoRd';\r\nmysql> FLUSH PRIVILEGES;\r\nmysql> \\q\r\n<\/pre>\n
\n