Azure Web App Day/Time issue

Hello all,

We have been through an issue pertaining to the time zone setting of our web application which run on Azure App Service. After a couple of trial, we set the time zone to the value shown below.

It worked for our web application which is supposed use GMT+3, Turkish Standard Daytime 🙂 It seems there are several values to get the result(GMT +3) that you may give it a try.

http://www.louischarlesgagnon.com/post/azure-app-service-set-timezone-for-your-web-application

Wish you all the best, regards.

Azure – Web App DNS issue

Hello there!

I have been driving a project which most of the components are run on Azure as PaaS and others as IaaS. Due to a service dependency, we built a point to site vpn to connect our Apps to our Azure VNet, and a site to site vpn to connect our VM‘s to to our on-premise. So our Apps are able to communicate to our on-premise through the tunnels. Lastly, we defined a custom DNS server ip address which points to one of our dns servers that run  on our on-premise.

https://docs.microsoft.com/en-us/azure/app-service-web/web-sites-integrate-with-vnet

vnetint-howitworks

The custom dns setting inherits  the VM’s inside the VNet. But not for the App.

At this point, we ran into a problem.Although the custom dns server ip address was set and displayed in VNet integration blade, it didn’t effect our App!  After a short dialog with Azure Support we were provided a solution 🙂

vnet

As you can see above , we added a variable settings  under the Application Settings of our web app. The value, of course, points to our on-premise dns server. The support guy that helped us gave us a promise to update the documentation 🙂

Cheers,

Wish you great week:)

AWS micro instances & mysqld deadlock

Hello all,

If you’re running mysql daemon on an AWS micro instance type AMI like me, you must already have undergone mysqld deadlocks day by day. I guess,   to move local mysql db to AWS RDS is the best solution in order to avoid this circumstance.

Creating a swap space is one of the solutions but you may have a limited storage on micro instances.Another solution would be to restart mysqld when it stops by cron jobs 🙂

crontab-syntax

Here is my bash script:

[ec2-user@ip-xyz-xyz-xyz-xyz filestores]$ more mybashscript
#!/bin/bash
if [[ ! “$(/sbin/service mysqld status)” =~ “start/running” ]]
then
/sbin/service mysqld start
fi

Don’t forget to give required permission for your bash file.

chmod +x /home/ec2-user/filestores/mybashscript 

And here is crontab (root crontab file!)You can access root crontab file by typing sudo crontab -e command

*/1 * * * * /home/ec2-user/filestores/mybashscript  –> Bash will run in every 1 minute.

That’s all, just give it a try. You can find different bash script on the Internet.

Wish you good and prosperity

Have a nice day.

 

 

 

inLearning

Hello ,

LinkedIN’s new service , inLearning, has been available with one month trial period.

https://www.linkedin.com/learning/

I reviewed several trainings , you can definitely find something useful for you 🙂 Give it a try!

screen-shot-2016-10-29-at-16-37-52

Regards.

Azure Cool Blob Storage

Please scroll down for [EN]

Artan depolama alanı ihtiyacına karşı depolama maliyetini optimize etmek için bulut tabanlı depolama servisleri avantajlıdır. Azure blob storage servisine yakın zamanda eklenen cool & hot özelliği ile, sıkça erişilen veriniz ile sıkça erişilmeyen verinizi ayırarak depolama maliyetinizi daha da optimize edebilirsiniz. Azure üzerinde storage account’u oluştururken belirlediğiniz Cool niteliğindeki verinizin maliyeti oldukça düşük oluyor.

Ör: Gigabyte/Ay maliyeti 0.01 USD ‘dir.

Daha detaylı göz atmak isterseniz aşağıdaki tabloyu inceleyebilirsiniz*

Continue reading “Azure Cool Blob Storage”

JackDB – Direct SQL access

Greetings!

While I was evaluating an AWS Redshift lab on qwikLABS, the lab directed me to connect to Redshift cluster by using JackDB which is a hosted service that can be used as a secure client software to connect to cluster in order to run queries . Thus, you are able to query your database by using a 3rd party client software.

If you are seeking a service like JackDB, all of the plans come with 14-days free trial.

Before adding a data source to JackDB dashboard, make sure that you have already configured the AWS security group which allows the incoming connection that is initiated from JackDB IP’s.

In addition to this, you can undoubtedly use it to connect to Azure SQL service as well. I have added a data source which is hosted on Azure SQL.

Continue reading “JackDB – Direct SQL access”

Linux – Sudoers

Dear readers,

In this post, I am going to cover the sudoers in CentOS7. You all probably know that su means super user or substitute user and sudo means “do as su(per user)” 🙂

If you login to the system as root user, you are allowed to run all of the commands. I will try to perform several tasks as normal user for you to review the results.

Screen Shot 2016-05-24 at 18.53.49

Let’s try to run command by using sudo then.

Continue reading “Linux – Sudoers”

Linux – Granting permissions

Hello all,

In this blog, I am going to review file and folder permissions which are assigned to user , group and other objects.The very fundamental parameters that are needed to be considered when assigning permissions are User,Group,Others,Read,Write,Execute. In shortly, we can use ugo for user,group,others and rwx for read,write and execute. The table shown below is sufficient to express permissions in octal mode.

Continue reading “Linux – Granting permissions”