Bolt is a sophisticated, lightweight and simple CMS built with PHP. This tutorial shows the installation of Bolt CMS in FreeBSD 12 with Nginx web server, MySQL database server and Let's Encrypt SSL certificate.
10 Older Entries »
Somebody asked me how to expand a prior example with the static variables so
that it took arguments at the command line for the variables.
This example uses Python 3 new features in the
There’s a small trick converting the
date data types. Here’s a quick example
that shows you how to convert the argument list into individual
date data type variables:
#!/usr/bin/python3 # include standard modules import sys from datetime import datetime # Capture argument list. fullCmdArguments = sys.argv # Assignable variables. beginDate = "" endDate = "" # Assign argument list to variable. argumentList = fullCmdArguments[1:] # Enumerate through the argument list where beginDate precedes endDate as strings. try: for i, s in enumerate(argumentList): if (i == …[Read more]
In this short blog post, we will check how to use linux-fincore to check which files are in the in-memory Linux page cache. To have an introductory read about the Linux page cache check here and here.
In summary, whenever you read from or write to a file (unless you are using Direct_IO to bypass the functionality), the result is cached in memory, so that subsequent requests can be served from it, instead of the orders of magnitude-slower disk subsystem (it can also be used to cache writes, before flushing them to disk). This is done as far as there is memory that is not being used by any process; whenever there is a shortage of otherwise free memory, the kernel will choose to first evict the page cache …[Read more]
There was an option during the Fedora 30 Workstation installation
to add the Apache Web Server, but you need to set it to start
automatically. Unfortunately, there was no option to install PHP,
which I thought odd because of how many web developers learn the
trade first on PHP with a LAMP (Linux, Apache, MySQL,
Perl/PHP/Python) stack. You see how to fix that shortcoming in
this post and how to install and test PHP,
pdo to support MySQL 8.
Before you do that make sure you install MySQL 8. You can find my prior blog post on that here.
You set Apache to start automatically, on the next boot of the operating system, with the following command:
chkconfig httpd on
It creates a symbolic link:
Created symlink /etc/systemd/system/multi-user.target.wants/httpd.service → …[Read more]
Matomo (formerly Piwik) is a free and open-source web analytics application developed by a team of international developers, that runs on a PHP/MySQL webserver. This tutorial will show you how to install Matomo on a FreeBSD 12.0 system using Nginx as the webserver and we will secure the website with a Let's Encrypt SSL certificate.
errno: 24 - Too many open files
You might see this error inside MySQL's error log file or during mysql_upgrade operation.
Can't open file: ‘./db/table.frm' (errno: 24 - Too many open files)
To solve this issue, you will need to change the open files limit at system and db service level.
--> To check and change this limit at the system level, we use ulimit client tool to set it dynamically.
* Check current system open file limit.
root@test:~# ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling …
Thumb rule to choose Percona-Server ssl Linux-Generic package
Here below are my thumb rules to choose which ssl linux-generic package, you should download for your system.
Like here we can see if we need to download Percona-Server Linux-Generic package then We can see here we have couple of packages available with different ssl(100/101/102) versions.
Here you should choose below package based on your operating system.
Debian prior to 9 and Ubuntu prior to 14.04 versions --> ssl100 CentOS 6 and CentOS 7 --> ssl101 …
Create CentOS VM using Vagrant
1. Download and install the latest Oracle VM VirtualBox.
Like (For Mac OS X)
2. Download and install the latest Vagrant.
Like (For Mac OS X) …
In Generic binary Installation method, we are extracting compressed tar files of MySQL and later we can do customization for MySQL setup as per our requirement. Like having different data directory, log directory etc.
MySQL Generic Binaries can be used to install MySQL on Unix/Linux platforms.
MySQL Installation has a dependency on the libaio library. Make sure that is there on a server before mysql install.
Create a mysql user and group, which we will use as a service account for the mysql server.
shell> groupadd mysql
shell> useradd -r -g mysql -s /bin/false mysql
Extract MySQL binaries TAR to mysql base directory for example in /mysql dir
Create require directories and set appropriate permissions.
shell> cd mysql
I am a Junior DBA at Mydbops. This is my first blog professionally, I would like to brief my encounter with Log-rotate in first few weeks of my work, Hope it will help other beginners as well. This Blog will cover the following sections.
Introduction to Log-rotate
Solutions (Fix for the above issues)
How to configure the Log-rotate
Operation of Log-rotate
Files responsible for the Log_rotate utility.
1.0. Introduction to Log-rotate:
Log-rotate is a utility and …
10 Older Entries »