Not allowed to connect to Mysql error in docker

From time to time i receive this error while running the official mysql image in docker:

An exception occured in driver: SQLSTATE[HY000] [1130] Host ‘’ is
not allowed to connect to this MySQL server

The reason for this is not quite clear yet but i usually resolve it like described here.
Note that all data stored in the project will be lost!
So this error is quite annyoing but luckily i work on fixtures so i can restore data easily.
These steps let me connect to the mysql container again, at least.

Continue reading “Not allowed to connect to Mysql error in docker”

Symfony and Angular: shared translations

Angular for frontend with symfony delivering the data have become quite a common setup.

When working with this constellation you will sooner or later come across the i18n topic. Most likely you would want to share translations between front- and backend. So that you could keep translations in one single location while using it for frontend templates as well as server-side error messages etc.

One approach would be to store translations in the symfony yml or xml files and deliver those to the frontend via an api endpoint.
Given that front- and backend-code run on the same server, there is an even simpler solution.
Continue reading “Symfony and Angular: shared translations”

Symfony Cache Component with SncRedisBundle

Since version 3.1 there is a Cache component with a PSR-6 implementation integrated in Symfony.
So we do not need to add a 3rd party lib as Doctrine Cache anymore when we need caching these days.

Doctrine Cache does the job but by implementing a standard the Symfony Cache seems to have another advantage besides its delievered anyway. So i checked it out.

Documentation is still a bit sparse and the best resource so far is this blogpost:

I wont go into detail on how you use the Cache but rather how you integrate it with Redis, which is my favourite Cache backend.
Continue reading “Symfony Cache Component with SncRedisBundle”

SilverStripe with php built-in server

Sometimes you just want to check a SilverStripe version, module or theme fast and dont want to setup the whole stack.
Then simply use PHPs built-in webserver to serve your SilverStripe site.

php -S localhost:8000 ./framework/main.php

Now you can call http://localhost:8000 to check your SilverStripe website.

Or, a bit more verbose, use
which is a nice wrapper around this.
Continue reading “SilverStripe with php built-in server”

Twig Extension for Money value object

I just released a twig extension for

The money libary contains a money represention based on the currency’s smallest unit to provide a more accurate handling. See the libary’s readme for more information.

Although the v1.x version of Money brings a Formatter the Twig extension uses its own, which is better suited and more flexible.

Continue reading “Twig Extension for Money value object”

Superleansilexplate Update v3

Some news from the Superleansilexplate:

  • v3 now uses symfony3 components
    Silex 1.3 supports symfony3 so lets use it :)
    Note: as symfony3 doesnt support php5.4 anymore, we dont either!
  • new ConsoleServiceProvider
    the one from knplabs that was used before seems to be unmaintained and wasnt matching the dependencies anymore.
    So i decided to take it over and renew it a bit. Check it out!
  • Docker support
    I started to use Docker as dev enviroment for my projects, so i added dev & prod Docker support.
    For the sake of simplicity it uses a single container with Apache and PHP7.
    If you have Docker and docker-compose on your machine just spin it up with docker-compose up and check on localhost:8088.

Continue reading “Superleansilexplate Update v3”

PHP package generators

For creating PHP packages several best practices has been established, like composer support (ofc) and putting the package on packagist, travis integration, directory organisation, tests, documentation and so on.
For further information i recommend these slides which describe the situation very well.

And as we are all lazy, we like generators that scaffold a basic php package layout and luckily there are several out there.
They all differ a bit, so pick your favorite.
Continue reading “PHP package generators”

RegExpBuilderPHP – PHP Regular Expression Builder

There this really useful tool for JS, called RegExpBuilder.
It enables you to build regular expressions with a nice human-readable & chainable syntax.
(read more about it here and here)

As it’s not that much lines of code, I decided to do a port for PHP – et voila:
Continue reading “RegExpBuilderPHP – PHP Regular Expression Builder”