admin – Nikolay Nikolov blog

Fast Setup Virtual Machine and Symfony

sudo dpkg --configure -a

sudo apt-get install mysql-server

apt-cache pkgnames | grep php7.3

	php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
	php -r "if (hash_file('sha384', 'composer-setup.php') === 'a5c698ffe4b8e849a443b120cd5ba38043260d5c4023dbf93e1558871f1f07f58274fc6f4c93bcfd858c6bd0775cd8d1') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"
	php composer-setup.php
	php -r "unlink('composer-setup.php');"

sudo mv composer.phar /usr/local/bin/composer

# run this if you are building a traditional web application

composer create-project symfony/skeleton ./

OR
# run this if you are building a microservice, console application or API

composer create-project symfony/website-skeleton ./

Current folder should be empty!!!

Continue reading “Fast Setup Virtual Machine and Symfony”

RabbitMQ Work Queue with Symfony

Add to .env

	RABBITMQ_HOST=localhost
	RABBITMQ_PORT=5672
	RABBITMQ_USERNAME=test
	RABBITMQ_PASSWORD=test
	RABBITMQ_QUEUE_NAME=task_queue

Add to services.yaml

	App\Command\WorkerCommand:
	arguments: ['%env(RABBITMQ_HOST)%', '%env(RABBITMQ_PORT)%', '%env(RABBITMQ_USERNAME)%', '%env(RABBITMQ_PASSWORD)%', '%env(RABBITMQ_QUEUE_NAME)%']

	App\Command\PublisherCommand:
	arguments: ['%env(RABBITMQ_HOST)%', '%env(RABBITMQ_PORT)%', '%env(RABBITMQ_USERNAME)%', '%env(RABBITMQ_PASSWORD)%', '%env(RABBITMQ_QUEUE_NAME)%']

Continue reading “RabbitMQ Work Queue with Symfony”

Setting up RabbitMQ

First, we need to use composer to install RabbitMQ Server and the PHP package for interfacing with RabbitMQ.

	composer require php-amqplib/php-amqplib

	sudo apt-key adv --keyserver "hkps.pool.sks-keyservers.net" --recv-keys "0x6B73A36E6026DFCA"
	wget -O - "https://github.com/rabbitmq/signing-keys/releases/download/2.0/rabbitmq-release-signing-key.asc" \| sudo apt-key add -
	sudo apt-get install apt-transport-https
	sudo apt-get update -y
	sudo apt-get install -y erlang
	sudo apt-get update
	sudo apt-cache policy
	sudo apt-get install -y rabbitmq-server

Create user for rabbitMQ and set permissions
only root can create user

	sudo su root
	rabbitmqctl add_user test test
	rabbitmqctl set_user_tags test administrator
	rabbitmqctl set_permissions -p / test "." "." ".*"

You can now reach RabbitMQ interface at http://localhost:15672

MongoDB first steps

Simple commands you should know!

Continue reading “MongoDB first steps”

Array to XML in Symfony

Simple example how to convert Array to XML:

	public function toXML() {
	$array = [
	'fields' => [
	'field' => [
	'@name' => 'name',
	'@test' => 'test',
	'#' => 12345
	]
	]
	];

	$xmlEncoder = new XmlEncoder();

	$response = new Response();
	$response->setContent($xmlEncoder->encode($array, 'xml'));
	$response->headers->set('Content-Type', 'xml');
	return $response;
	}

Change cache directory in Symfony

This task is really simple. You can achieve it from Kernel.php, getCacheDir method:

	public function getCacheDir()
	{
	// return $this->getProjectDir().'/var/cache/'.$this->environment; //Any location on your server
	return '/dev/shm/'.$this->environment; //This will cache in RAM
	}

Problem with NULL values you should remember

When trying to execute SELECT OR UPDATE query for rows different than a specific value, we should be aware to insert additional statement for null values too.

For Example:

	UPDATE account_event
	SET account_event.assigned_to_id = 2
	WHERE account_event.status != 1

With this query your goal is to update all rows where account_event.status is different from 1. But if status have null value it wont be updated!
In MySQL all null elements are skipped from comparison and will never be Selected or Updated.

When you have a null fields you should always add additional statement for null like this:

	UPDATE account_event
	SET account_event.assigned_to_id = 2
	WHERE account_event.status != 1
	OR account_event.status IS NULL

Vagrant – setup LAMP container

Install Vagrant and VirtualBox.

Go to https://app.vagrantup.com/boxes
and choose vagrant box that suits you best.
After that you need to create vagrant file by typing in console:

vagrant init ubuntu/xenial64

– ubuntu/xenial64 – stands for the name of the box you selected

Continue reading “Vagrant – setup LAMP container”

	apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 9DA31620334BD75D9DCB49F368818C72E52529D4
	echo "deb [ arch=amd64,arm64 ] https://repo.mongodb.org/apt/ubuntu xenial/mongodb-org/4.0 multiverse$
	apt-get update
	apt-get install -y mongodb-org
	sudo systemctl enable mongod
	sudo systemctl start mongod

Author: admin