sysadmin

Home / sysadmin

How To Fix MySQL Table mysql.plugin Doesn’t Exist

I recently had an issue on a MySQL Database Server where running apt-get upgrade to upgrade the MySQL package on the server would result in an error about the table 'mysql.plugin' doesn't exist. I believe the issue started on this server after I changed the datadir in my.cnf and I moved the database directory to [...]

By | January 20th, 2017|Categories: System Administration|Tags: , , , , , , , , |0 Comments

How To Harden MongoDB Server

MongoDB is "a document database that provides high performance, high availability, and easy scalability". In this chapter of our InfoSec System Hardening series, we'll walk you through some of the steps you can take to harden your MongoDB database server. You can refer to the MongoDB Server Documentation for more details about the commands and [...]

By | January 17th, 2017|Categories: Security, Server Hardening, System Administration|Tags: , , , , , |0 Comments

How To Harden An NGINX Web Server

The next segment in our InfoSec System Hardening series is how to harden an NGINX Web Server. NGINX is an alternative to the popular Apache Web Server on Linux. In this article, we'll show you some of the basics you'll want to take to secure your NGINX Web Server. To get started, you can follow [...]

By | January 16th, 2017|Categories: Security, Server Hardening, System Administration|Tags: , , , , , |0 Comments

How To Harden A MySQL Server

As with any server, whether it be a web server, file server, database server, etc, hardening is an important step in information security and protecting the data on your systems. This guide will show you some basics when it comes to hardening a MySQL Server. Most of these changes are simple lines to add into [...]

By | January 15th, 2017|Categories: Security, Server Hardening, System Administration|Tags: , , , , , |0 Comments

Easy Upgrade Ubuntu 14.04 to Ubuntu 16.04 on a Server

If you're a Linux Systems Administrator or run an Ubuntu Linux Server for a small website somewhere, now would be a good time to plan an upgrade to Ubuntu 16.04 Xenial Xerus if you're currently running Ubuntu 14.04. You can read the Ubuntu Release Notes to see some of the new features available. Ubuntu has [...]

By | October 26th, 2016|Categories: Linux, System Administration|Tags: , , , , , , |0 Comments

View All CPU Cores in Task Manager (Windows Server 2012 / Windows 10 )

Windows Server 2012 and Windows 10 came with a lot of changes to the task manager and in some cases the default views have been simplified further than power users and administrators would prefer. One example is by default you only see the total processor utilization and don't see all CPU cores. To see all [...]

By | October 21st, 2016|Categories: System Administration, Windows|Tags: , , , , |0 Comments

How To Backup, Restore, and Import Group Policy Objects

As a Systems Administrator, you've probably worked with Group Policy before, especially if you're in a Microsoft Windows environment. Group Policy allows you to push out settings to multiple computers on an Active Directory domain network. If you work with multiple domains, there may be a time where you want to migrate some Group Policy [...]

Find Cisco Serial Numbers With The IOS Command Line

"How do I find a Cisco serial number remotely through the command line?" This is one of those frequently asked questions that I see over and over. So, here's the quick answer: You can find Cisco serial numbers from the IOS command line by using the show inventory command. This is good news for all [...]

How-To Write SQL Server Audit Events To Windows Security Log

There are a few options you have if you want to enable audit logging on Microsoft SQL Server. You can write the logs to a .sqlaudit file, but you cannot open these in a simple text editor like Notepad. You would have to use the SQL Log Viewer. In my case, I needed a way [...]

How to See Which Group Policies are Applied to Your PC and User Account

If you're running a Professional (or higher) version of Windows, then you may have run into the Group Policy Editor before. Basically, it is a hidden control panel that lets you set computer-level or user-level settings. If you're a Systems Administrator, then you can set group policies at your domain level, then push them out [...]

Load More Posts