esparta · February 13, 2023 14:37 · piotrrojek · Apr 14, 2014 · cristiannsc · Oct 3, 2018
diff --git a/01.meneame.md b/01.meneame.md
diff --git a/bootstrap.sh b/bootstrap.sh
 ## Use the closest mirror
 #sudo sed -i "s/http:\/\/us.archive.ubuntu.com\/ubuntu\//mirror:\/\/mirrors.ubuntu.com\/mirrors.txt/g" /etc/apt/sources.list

 #Proxy aware
 # just set the http_proxy environment variable on your dev machine

 if [ ! -z $1 ]; then
  ## We have a proxy...
  BASH_FILE=/home/vagrant/.bashrc
  proxy=$1
  # First, the bash environment variable
  echo "Configuring proxy: $proxy"
  export http_proxy=$proxy
  export https_proxy=$proxy

  ## Make it permanent (on vagrant's profile)
  echo "export http_proxy=$proxy" >> $BASH_FILE
  echo "export https_proxy=$proxy" >> $BASH_FILE

  ## Config the apt file for the apt-get update
  echo "Acquire::http::proxy \"$proxy\";" >> /etc/apt/apt.conf
  echo "Acquire::https::proxy \"$proxy\";" >> /etc/apt/apt.conf
 fi


 ## Update the ubuntu/debian box

 sudo apt-get update
 sudo apt-get install nginx php5-mcrypt php5-fpm php5-curl \
     php5-mysql -y

 sudo debconf-set-selections <<< \
     'mysql-server-5.5 mysql-server/root_password password rootpass'
 sudo debconf-set-selections <<< \
     'mysql-server-5.5 mysql-server/root_password_again password rootpass'
 sudo apt-get install mysql-server-5.5 python-mysqldb -y

 ## Configuring mysql to be able to access this mysql server from the developer box
 sudo sed -i 's/127.0.0.1/0.0.0.0/g' /etc/mysql/my.cnf
 sudo service mysql restart

 echo "Deploying..."

 echo "Getting minimal nginx configuration file\n"
 wget -O /etc/nginx/sites-available/default \
    https://gist.githubusercontent.com/esparta/9490477/raw/default

 ## Fixing some anoying Bug nginx + VirtualBox
 ## http://wiki.nginx.org/Pitfalls
 ## http://jeremyfelt.com/code/2013/01/08/clear-nginx-cache-in-vagrant/
 sed -i 's/sendfile on;/sendfile off;/g' /etc/nginx/nginx.conf 

 sudo service php5-fpm restart
 sudo service nginx restart

 echo "Configuring mySQL database\n"
 echo "Creating Meneame database\n"
 mysql -u root -p"rootpass" <<-CREATE_DATABASE
  CREATE DATABASE meneame;
  GRANT ALL ON meneame.* TO meneame@localhost IDENTIFIED BY 'meneame';
  GRANT ALL ON meneame.* TO meneame@'%' IDENTIFIED BY 'meneame'
 CREATE_DATABASE

 echo "Creating tables\n"
 mysql -u meneame -p"meneame" meneame < /meneame/sql/meneame.sql
 mysql -u meneame -p"meneame" meneame < /meneame/sql/categories.sql

 echo "Creating initial data"
 mysql -u meneame -p"meneame" meneame <<-INITIAL_DATA
  INSERT INTO subs (name, enabled, parent, server_name, base_url, name_long, visible) 
  	VALUES ('mnm', 1, 0, '', 'localhost:8080', 'Meneame', 1);

  INSERT INTO sub_categories 
  	SELECT LAST_INSERT_ID(), category_id, 1, 1, 1, category_calculated_coef FROM categories;
 INITIAL_DATA

 echo "Configuring Meneame settings\n"
 sed -i  "s/\$globals\['db_password'] = ''/\$globals\['db_password'] = 'meneame'/g" \
    /meneame/www/config.php

 sed -i "s/\$globals\['static_server'] = ''/\$globals\['static_server'] = 'http:\/\/localhost:8080'/g" \
   /meneame/www/config.php

 echo "Meneame - Bootstraping finished"
diff --git a/createdatabase.sql b/createdatabase.sql
 CREATE DATABASE meneame;
 GRANT ALL ON meneame.* TO meneame@localhost IDENTIFIED BY 'meneame';
 GRANT ALL ON meneame.* TO meneame@'%' IDENTIFIED BY 'meneame'

diff --git a/default b/default
 server {
 	#listen   80; ## listen for ipv4; this line is default and implied
 	#listen   [::]:80 default ipv6only=on; ## listen for ipv6

 	root /meneame/www;
 	index index.php index.html index.htm;

 	# Make site accessible from http://localhost/
 	server_name localhost;

 	location / {
                rewrite /v_\d+/(.+)$ /$1 last;
 		try_files $uri $uri/ /index.html;
 	}

 	location /doc/ {
 		alias /usr/share/doc/;
 		autoindex on;
 		allow 127.0.0.1;
 		deny all;
 	}

 	# Only for nginx-naxsi : process denied requests
 	#location /RequestDenied {
 		# For example, return an error code
 		#return 418;
 	#}

         error_page  404 = /ooops.php;

 	#error_page 404 /404.html;

 	# redirect server error pages to the static page /50x.html
 	#
 	#error_page 500 502 503 504 /50x.html;
 	#location = /50x.html {
 	#	root /usr/share/nginx/www;
 	#}

 	# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
 	#
 	location ~ \.php$ {
 		fastcgi_split_path_info ^(.+\.php)(/.+)$;
                fastcgi_intercept_errors on;

 	#	# NOTE: You should have "cgi.fix_pathinfo = 0;" in php.ini
 	#
 	#	# With php5-cgi alone:
 		fastcgi_pass 127.0.0.1:9000;
 	#	# With php5-fpm:
 	#	fastcgi_pass unix:/var/run/php5-fpm.sock;
 		fastcgi_index index.php;
 		include fastcgi_params;
 	}


 }
diff --git a/initialdata.sql b/initialdata.sql
 INSERT INTO subs (name, enabled, parent, server_name, base_url, name_long, visible) 
 	VALUES ('mnm', 1, 0, '', 'localhost:8080', 'Meneame', 1);

 INSERT INTO sub_categories 
 	SELECT LAST_INSERT_ID(), category_id, 1, 1, 1, category_calculated_coef FROM categories;

diff --git a/Vagrantfile b/Vagrantfile
 # -*- mode: ruby -*-
 # vi: set ft=ruby :

 # Vagrantfile API/syntax version. Don't touch unless you know what you're doing!
 VAGRANTFILE_API_VERSION = "2"

 Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|
  # All Vagrant configuration is done here. The most common configuration
  # options are documented and commented below. For a complete reference,
  # please see the online documentation at vagrantup.com.

  # Every Vagrant virtual environment requires a box to build off of.
  config.vm.box = "precise32"
  
  config.vm.provision "shell" do |s|
      s.path = "bootstrap.sh"
      s.args = ENV['http_proxy']
  end

  # Create a forwarded port mapping which allows access to a specific port
  # within the machine from a port on the host machine. In the example below,
  # accessing "localhost:8080" will access port 80 on the guest machine.
  config.vm.network :forwarded_port, guest: 80, host: 8080
  config.vm.network :forwarded_port, guest: 3306, host: 33066

  # Share an additional folder to the guest VM. The first argument is
  # the path on the host to the actual folder. The second argument is
  # the path on the guest to mount the folder. And the optional third
  # argument is a set of non-required options.
  config.vm.synced_folder ".", "/meneame"

 end
	## Use the closest mirror
	#sudo sed -i "s/http:\/\/us.archive.ubuntu.com\/ubuntu\//mirror:\/\/mirrors.ubuntu.com\/mirrors.txt/g" /etc/apt/sources.list

	#Proxy aware
	# just set the http_proxy environment variable on your dev machine

	if [ ! -z $1 ]; then
	## We have a proxy...
	BASH_FILE=/home/vagrant/.bashrc
	proxy=$1
	# First, the bash environment variable
	echo "Configuring proxy: $proxy"
	export http_proxy=$proxy
	export https_proxy=$proxy

	## Make it permanent (on vagrant's profile)
	echo "export http_proxy=$proxy" >> $BASH_FILE
	echo "export https_proxy=$proxy" >> $BASH_FILE

	## Config the apt file for the apt-get update
	echo "Acquire::http::proxy \"$proxy\";" >> /etc/apt/apt.conf
	echo "Acquire::https::proxy \"$proxy\";" >> /etc/apt/apt.conf
	fi


	## Update the ubuntu/debian box

	sudo apt-get update
	sudo apt-get install nginx php5-mcrypt php5-fpm php5-curl \
	php5-mysql -y

	sudo debconf-set-selections <<< \
	'mysql-server-5.5 mysql-server/root_password password rootpass'
	sudo debconf-set-selections <<< \
	'mysql-server-5.5 mysql-server/root_password_again password rootpass'
	sudo apt-get install mysql-server-5.5 python-mysqldb -y

	## Configuring mysql to be able to access this mysql server from the developer box
	sudo sed -i 's/127.0.0.1/0.0.0.0/g' /etc/mysql/my.cnf
	sudo service mysql restart

	echo "Deploying..."

	echo "Getting minimal nginx configuration file\n"
	wget -O /etc/nginx/sites-available/default \
	https://gist.githubusercontent.com/esparta/9490477/raw/default

	## Fixing some anoying Bug nginx + VirtualBox
	## http://wiki.nginx.org/Pitfalls
	## http://jeremyfelt.com/code/2013/01/08/clear-nginx-cache-in-vagrant/
	sed -i 's/sendfile on;/sendfile off;/g' /etc/nginx/nginx.conf

	sudo service php5-fpm restart
	sudo service nginx restart

	echo "Configuring mySQL database\n"
	echo "Creating Meneame database\n"
	mysql -u root -p"rootpass" <<-CREATE_DATABASE
	CREATE DATABASE meneame;
	GRANT ALL ON meneame.* TO meneame@localhost IDENTIFIED BY 'meneame';
	GRANT ALL ON meneame.* TO meneame@'%' IDENTIFIED BY 'meneame'
	CREATE_DATABASE

	echo "Creating tables\n"
	mysql -u meneame -p"meneame" meneame < /meneame/sql/meneame.sql
	mysql -u meneame -p"meneame" meneame < /meneame/sql/categories.sql

	echo "Creating initial data"
	mysql -u meneame -p"meneame" meneame <<-INITIAL_DATA
	INSERT INTO subs (name, enabled, parent, server_name, base_url, name_long, visible)
	VALUES ('mnm', 1, 0, '', 'localhost:8080', 'Meneame', 1);

	INSERT INTO sub_categories
	SELECT LAST_INSERT_ID(), category_id, 1, 1, 1, category_calculated_coef FROM categories;
	INITIAL_DATA

	echo "Configuring Meneame settings\n"
	sed -i "s/\$globals\['db_password'] = ''/\$globals\['db_password'] = 'meneame'/g" \
	/meneame/www/config.php

	sed -i "s/\$globals\['static_server'] = ''/\$globals\['static_server'] = 'http:\/\/localhost:8080'/g" \
	/meneame/www/config.php

	echo "Meneame - Bootstraping finished"
	server {
	#listen 80; ## listen for ipv4; this line is default and implied
	#listen [::]:80 default ipv6only=on; ## listen for ipv6

	root /meneame/www;
	index index.php index.html index.htm;

	# Make site accessible from http://localhost/
	server_name localhost;

	location / {
	rewrite /v_\d+/(.+)$ /$1 last;
	try_files $uri $uri/ /index.html;
	}

	location /doc/ {
	alias /usr/share/doc/;
	autoindex on;
	allow 127.0.0.1;
	deny all;
	}

	# Only for nginx-naxsi : process denied requests
	#location /RequestDenied {
	# For example, return an error code
	#return 418;
	#}

	error_page 404 = /ooops.php;

	#error_page 404 /404.html;

	# redirect server error pages to the static page /50x.html
	#
	#error_page 500 502 503 504 /50x.html;
	#location = /50x.html {
	# root /usr/share/nginx/www;
	#}

	# pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
	#
	location ~ \.php$ {
	fastcgi_split_path_info ^(.+\.php)(/.+)$;
	fastcgi_intercept_errors on;

	# # NOTE: You should have "cgi.fix_pathinfo = 0;" in php.ini
	#
	# # With php5-cgi alone:
	fastcgi_pass 127.0.0.1:9000;
	# # With php5-fpm:
	# fastcgi_pass unix:/var/run/php5-fpm.sock;
	fastcgi_index index.php;
	include fastcgi_params;
	}


	}
	# -- mode: ruby --
	# vi: set ft=ruby :

	# Vagrantfile API/syntax version. Don't touch unless you know what you're doing!
	VAGRANTFILE_API_VERSION = "2"

	Vagrant.configure(VAGRANTFILE_API_VERSION) do \|config\|
	# All Vagrant configuration is done here. The most common configuration
	# options are documented and commented below. For a complete reference,
	# please see the online documentation at vagrantup.com.

	# Every Vagrant virtual environment requires a box to build off of.
	config.vm.box = "precise32"

	config.vm.provision "shell" do \|s\|
	s.path = "bootstrap.sh"
	s.args = ENV['http_proxy']
	end

	# Create a forwarded port mapping which allows access to a specific port
	# within the machine from a port on the host machine. In the example below,
	# accessing "localhost:8080" will access port 80 on the guest machine.
	config.vm.network :forwarded_port, guest: 80, host: 8080
	config.vm.network :forwarded_port, guest: 3306, host: 33066

	# Share an additional folder to the guest VM. The first argument is
	# the path on the host to the actual folder. The second argument is
	# the path on the guest to mount the folder. And the optional third
	# argument is a set of non-required options.
	config.vm.synced_folder ".", "/meneame"

	end