SQL

How To Install PHPMyAdmin on Fedora 9

phpMyAdmin is an opensource tool written in PHP intended to handle the administration of MySQL database and table over the web. Currently, phpmyadmin can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is being distributed in more than 50(…)

Checklist for SQL mail configuration

You must have a mail client (such as Microsoft Outlook) installed on the computer that runs SQL Server. Use the Corporate or Workgroup option for Microsoft Outlook 2000 (Microsoft Outlook 2002 does not have the Corporate or Workgroup option). To select the option, on the Tools menu, click Options, and then double-click the Mail Services(…)

How to Setup ConfigMgr 2007 on Windows Server 2008

Installing ConfigMgr 2007 onto a Windows Server 2008 based server can be a challenge. Having recently been through the process for my own lab environment I thought I’d share the process in the hope that it will save you some time when you need to create this configuration. Before you begin you will need to(…)

28 Steps on how to harden your Linux server

If you run your own Linux server here are some tips on server hardening, liberally stolen from the CFS security GUI script for cPanel/WHM, that I have become only too familiar with since yesterday: On your firewall (you do have one don’t you?) check the incoming MySQL port and if 3306 is open, close it.(…)

The 10 unknown features about PHP

Here’s a short list of cool features that might have slipped under your radar as well: Use ip2long() and long2ip() to store IP addresses as integers instead of strings in a database. This will reduce the storage space by almost a factor of four (15 bytes for char(15) vs. 4 bytes for the integer), make(…)

How to Secure Memcached

Memcached is a high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load. Memcached is a great piece of software that was designed with performance in mind. Still, memcached has little (or should I say none?) security features built-in. If we run(…)

How To Install phpBB Forum in 5 Steps

Introduction to phpBB phpBB is a stable, open-source, bulletin board script available as a free download from phpbb.com [2]. It allows you to set up an unlimited number of forums and categories. Users, moderators and user groups with varying permissions can be created. In short, it provides everything you’d expect of a bulletin board service.(…)

How to use the EventCombMT utility to search event logs for account lockouts

EventCombMT is a multithreaded tool that you can use to search the event logs of several different computers for specific events, all from one central location. You can configure EventCombMT to search the event logs in a very detailed fashion. The following are some of the search parameters that you can specify: • Individual event(…)

How to Enable or Disable WordPress Comments on all posts in one step

1. First you need to log into your phpMyAdmin control applet 2. Now locate and select your WordPress database on the left from the database dropdown list 3. Now select the SQL tab from the navigation tabs at the top 4. Within the Run SQL Query box add the following code and click go: UPDATE(…)

How to Defend against CSS and SQL Injection attacks

The last step of securing the server is implementing the logging of the GET and POST payloads, and implementing protection against Cross-Site-Scripting and SQL Injection attacks. In order to perform that, we will use the mod_security module, which we enable by adding the following line into httpd.conf: AddModule mod_security.c To enable logging of the GET(…)

How to Install and Configure Zmanda Recovery and Back up Manager (ZRM)

Download :: The community edition (open source ) can be downloaded at http://www.zmanda.com/download-zrm.php Select the latest version. The latest version available at this point is Release 2.0. Download the server and client software [required for backup form remote server] based on the platform. For RHEL 4 enterprise edition download server RPM MySQL-zrm-2.0-1.noarch.rpm April 07 2008(…)