opsec | warren

Installing Fedora via HTTP or FTP — by opsec — last modified Jan 30, 2009 02:41 PM

This howto will show you how to install Fedora 7 using the rescue cd iso image and the kernel.org official mirror. Please read this howto completely before asking for help in #fedora on freenode. If you do need help please be prepared with the requested information so that others can help you more easily.

Installing & Configuring MySQL Server — by opsec — last modified Feb 23, 2010 08:55 PM

This Howto will show you how to install MySQL 5.x, start the service, make sure the server starts on reboot, login via terminal, change the root database admin password, change the name of the root user, add a new user with specific privileges to a specific database, add a new DBA, add a new database, remove all anonymous logins, remove all non-root users, added file security steps, disable remote access (via port 3306), purge the scrollback history, and finally the installation of the gui tool mysql-administrator.

Common Useful MySQL Commands — by opsec — last modified Nov 02, 2009 01:29 PM

These are examples of some common MySQL commands and syntax that may be helpful in programming, scripting or normal administration of MySQL databases.

Installing Sun Java browser plugin — by opsec — last modified Oct 30, 2008 10:34 PM

This howto will show you how to painlessly install the Sun Java broswer plugin. You should be aware of several potential risks before you start. 1. Fedora uses gcj which is a free version of Java, but it is not Java. There are potential mix-match problems that can arise when compiling some applictions on development machines. 2. If your system is slow you may run into problems as Sun Java tends to be CPU and RAM intensive. 3. If you're running an x86_64 system and compiling 32bit applications without the proper chrooted environment it will most likely not work. The main purpose for this howto is only for a browser solution. If you need more in-depth instructions please see the howto here by Scott Glaser or the IcedTea howto by jmahowald. That said let's get started.

MySQL Database Replication — by opsec — last modified Jun 13, 2008 04:01 PM

This Howto will show you how to setup MySQL database replication in case of hardware failure. This is not a permanent backup solution because if the DELETE command was given accidentally, it would also be replicated to the slave. This howto assumes you will not be making mistakes or giving DBA access to people who are not trustworthy. When finished, you'll have 2 identical MySQL databases on 2 different computers. This process can be adjusted to include multiple databases as well so you can backup all of your MySQL databases. Let's begin...

Denyhosts - A howto — by opsec — last modified Jun 05, 2008 02:34 PM

This howto will show you how to install and configure Denyhosts on your server or desktop system to help further prevent unwanted attacks or access to your systems.

Sudo - An advanced howto — by opsec — last modified Jun 10, 2008 03:05 PM

This howto is an advanced outline the sudoers file and how it can be manipulated to your needs.

Additional HDD via Terminal — by opsec — last modified Jun 13, 2008 05:32 PM

This is a simple howto designed to show you the basics of adding a new hard disk to an existing system using fdisk and mkfs.

Customizing the Grub system bootloader — by opsec — last modified Jun 16, 2008 08:00 PM

This howto will describe how you can change the background image/color, make a new background/splash image from your existing image, rename the menu, reorder the position of menu items, add extra boot arguments to the kernel, change the default menu item, change the default timeout before the system loads the default menu item, add another operating system to the menu.

Common BASH Commands — by opsec — last modified Oct 07, 2008 11:45 PM

If you choose to use Linux, you will inevitably need to use the terminal or command line console. Some common popular shells are: bash, csh and tsch among several others. Unix-like system users are already familiar with the terminal. For Windows users, it is similar to DS-DOS, only much more powerful. The real power and appeal in Unix and Linux is not only in in the general free and open nature of the software and ideas (FOSS) but also in the efficient use of the command line. With the command line you have the flexibility to interact directly with the kernel (the core of the system) as well as a host of other useful features. You are open to thousands of different options, commands and tools that, in the end, provide a highly stable, highly configurable and very highly functional operating environment. Most commands and some configuration (.conf) files also have "man pages" or "manual pages" which allow you to read about the verbose options and descriptions available. To access man pages type: man <command> at the terminal to read about the command, use q to exit the dialog. Below is a list of *some* common useful commands available at the bash (bourne again shell) terminal prompt:

Restrict user account to scp, sftp, rsync only with Fedora — by opsec — last modified Nov 02, 2009 01:14 PM

This howto will show you how to restrict any account to cvs, scp, sftp and rsync only.

SELinux Common Commands & Troubleshooting — by opsec — last modified Nov 02, 2009 01:19 PM

Common SELinux troubleshooting techniques, commands and syntax.