Moodle 3.3 with MySQL SSL Connection in the Azure Cloud

Update: Microsoft Azure Database for MySQL: Use PHP (not) to Connect and Query Data article has now some new updates.

Microsoft listened to my words, so I have found a documentation how to connect to Azure Database for MySQL with PHP via SSL connection. This can be found here:
https://docs.microsoft.com/en-us/azure/mysql/howto-configure-ssl

Of course this is not a complete solution because it did not work for me. So here is my solution.

LimeSurvey – Create an Multi-language Array with Comments for Every Sub-question

This day challenge was to install limesurvey and copy an existing survey built with EUSurvey. One of the question was an array with comments  for every sub-question in the last column. LimeSurvey does not offer a built in question for that you need to tweak the array question to work. So here is my solution.

My First PowerShell to Redirect HTTP to HTTPS on the Azure Application Gateway

After I was able to have HTTPS with a self-signed certificate on Application Gateway it was the time to redirect all HTTP communication to HTTPS. For that Microsoft offers only a PowerShell solution, you are not able to do that on the Portal. So in my life it was the first time I had to […]

How to Set Proxy in an Ubuntu Terminal?

Yes, because companies like to use proxy but I needed to access the Internet from my Ubuntu running on a VirtualBox. Just a few steps and access can be established: Edit the /etc/environment file with your favorite editor Add the following lines http_proxy=”http://myproxy.server.com:8080/” https_proxy=”http://myproxy.server.com:8080/” ftp_proxy=”http://myproxy.server.com:8080/” no_proxy=”localhost,127.0.0.1,localaddress,.localdomain.com” HTTP_PROXY=”http://myproxy.server.com:8080/” HTTPS_PROXY=”http://myproxy.server.com:8080/” FTP_PROXY=”http://myproxy.server.com:8080/” NO_PROXY=”localhost,127.0.0.1,localaddress,.localdomain.com” Logout and login again. Apt does […]

Create a database and an user with SQL Server Authentication

Again dear Microsoft, why do you harden our life when you could make it easier? Yesterday I was able to install Access Database Engine to connect the .ASP application to its database. But because getting An unhandled win32 exception occurred in w3wp.exe all the times, I thought it is time to change to MS SQL […]

Microsoft Azure Database for MySQL: Use PHP (not) to Connect and Query Data

Back on the road of blogging again. So our client who is a big European organization has Microsoft Azure Cloud services and having consultant company for support. Since we would like to run Moodle we need PHP + MySQL.  We got an Ubuntu app server. Funny isn’t is to run Linux machines in the Microsoft […]