django is a popular python framework to build web apps and web site development. Here I will demonstrate how we can setup a project to serve with Apache mod_wsgi.
Author Archives: thesysadmin
Calculate MySql database and table size
This is simple, run the below query This will list all the databases and show their size in Mb. Similarly we can get the size of tables in a particular database as
Linux Cheat sheet
Find directory with most inode usage or another method Download Large from Google Drive using command line in Linux Save the below script in a file named gdrivedownloader.sh We will need the file’s ID to download it, e.g if the shared link is https://drive.google.com/file/d/13fgfzfX7sujkwlUu3HCjJNZY0NztwbOK/view?usp=sharing then the ID is 13fgfzfX7sujkwlUu3HCjJNZY0NztwbOK, to download the file simply run […]
RDS Mariadb Grant All permission access denied for user
This is a peculiar error with Mariadb on RDS, this problem does not happen if you select the MySQL or Aurora Engine. If you try to run a GRANT ALL ON query you get an error like
LetsEncrypt SSL Certificate with AWS Route53 DNS using certbot-dns-route53
There are situation when its not possible to setup LetsEncrypt SSL certificates using certbot’s apache or nginx plugin. If your DNS is hosted on AWS Route53, Cloudflare, Google DNS, DigitalOcean we can take advantage of DNS-challenge authorization method to get the SSL certificates from LetsEncrypt.org. Lets see how we can do this if the DNS […]
Media conversion pipeline with AWS Transcoder, Lambda and S3
In a media streaming service, it is not recommended to stream one large media file, this slows down the user experience, also not all media formats are ideal for streaming. In this tutorial we will see the procedure to convert media to a format which is fit for streaming.
AWS RDS You do not have the SUPER Privilege and Binary Logging is Enabled
When importing a mysql database dump to RDS you receive this error “You do not have the SUPER Privilege and Binary Logging is Enabled”. This usually happens when your database has views or triggers defined. Although MySQL/Mariadb/Aurora RDS supports them but they are disabled by default. Lets see how we can enable them.
Installing Munin on Ubuntu 20.04 with MySQL plugin
Munin is a web based tool to monitor system and network statistic. Munin shows this information through Graphs. Let see how we can setup Munin on Ubuntu 20.04, we will start with updating the package repositories and then installing required package for Munin and Apache web server
iptables basic firewall
Netfilter IPTables is Linux kernel implementation of software firewall. Let build a basic minimal firewall. Let start by assuming we have a server where we have a web server listening on port 80 and 443 and SSH on port 22. We want to allow incoming connection to only these ports, traffic to any other port […]
Install Apache Tomcat 9 on CentOS 8
The Apache Tomcat software is an open source implementation of the Java Servlet, JavaServer Pages, Java Expression Language and Java WebSocket technologies. Tomcat requires java to run any Java web application, so the first thing we install is the latest Java JDK.