Month: October 2008

Commands to shrink the SQL Server transacation log

I recently encountered a database that was 4 MB in size with it’s respective transaction log at 460 MB. The transaction log is used in a recovery model to restore the database to a point in time. I wanted to reduce the size of the transaction log. More importantly, I wasn’t exactly clear as to why a transaction log of…

Read More »

Autorun JBoss on Red Hat Enterprise Linux 5 (RHEL5) Server

You already have JBoss ready and operational. JBoss can be started through a command line or through a shell script that you have created; however, these steps are manual and an automated approach is desired. The goal is to automate JBoss as a service or daemon. There are many, many tutorials that are all over the internet that offer scripts…

Read More »

Create a service for JIRA on CentOS 5 or RHEL 5

Atlassian JIRA is a bug and issue tracker. Atlassian JIRA lets you priorities, assign, track, report and audit your ‘issues,’ whatever they may be — from software bugs and help-desk tickets to project tasks and change requests. After installing JIRA, on a CentOS 5.2 Linux installation, I wanted to automate the starting and stopping of JIRA by creating a service….

Read More »

WordPress Pretty Permalinks on IIS without mod rewrite

Permalinks are the URLs to an individual post, category, page, etc. These links generally take the form of index.php?p=444 (or some number). Pretty Permalinks are the same URLs crafted to make sense to the user. Apache offers this ability, though generally not set by default. IIS through version 6 (Windows 2003) does not offer this. There are ISAPI filters both…

Read More »

WordPress Permalinks will not work in a default XAMMP installation

XAMPP is a free and open source cross-platform web server package, comprised of an Apache HTTP Server, a MySQL database, PHP and Perl programming languages. It is easy to install and setup with little configuration. However, the default installation of XAMPP does not enable the permalinks, though the permalinks structure is customizable to create the .htaccess file. With no permalinks,…

Read More »

Windows Vista Default Folder Template Patch

Based on the contents of a folder, Windows Vista will attempt to select a default view. In more cases than not, Windows Vista selects a view that is inconsistent with the folder content or most likely not the desirable view. An example of this may be a folder of documents and pictures and the default view will be for Music…

Read More »

WordPress – Global Translator Plugin Fix

Global Translator is a free and open source WordPress Plugin which is able to automatically translate your blog into different languages. After activating the Global Translator plugin, it is displayed under the Admin Settings as Global Translator. However, the link is incorrect and will not display. The link selects an absolute path that is incorrect. https://it.megocollector.com/wp-admin/:/…/it/wp-content/plugins/global-translator/options-translator.php The plugin is still…

Read More »

Access Red Hat Enterprise Linux 5 with XManager Remote Control

NetSarnag Computer, Inc. offers a product called XManager 3 that will enable a Windows workstation to access a Linux box. However, there are some configuration changes that need to be made on the Linux box for this application to work. The documentation offered by netSarang Computer, Inc. is far from accurate as it looks outdated. Too many assumptions are made….

Read More »

How to reset forgotten WordPress password

WordPress offers a default password recovery method that is available on the login screen. Under the Username and Password box there is a link to Lost your password?. This password recovery method would recover the user password if the user defines a valid and working email address in the user profile. If the e-mail account is not accessible or unknown…

Read More »

SQL Query to find duplicate rows

I needed a SQL query that would parse through hundreds of thousands of records and list duplicate content. I found a SQL query that would work and made my own modifications to it so that the query may return the desired results. This is one of those things I will not remember so here is the script. source Even though…

Read More »

phpMyVisitSites Open source Analytics

One of my continuing tasks is to search for a free open source web analytic application. There are very few to be found. An application that promises to be very good, is PiWiK. It is still in the very early stages of development and has a lot to be desired. It is, however, the continuing development of it’s predecessor phpMyvisites….

Read More »

CentOS 5.2 Linux install error on VMWare

Before, I continue, I want to preface this with I am a novice with Linux. Having played with Ubuntu versions 6 through 8, I never really could get into this particular distro of Linux as I understand that all root activity must be performed in a terminal windows with a prefix of sudo. I recently downloaded Red Hat Enterprise 5…

Read More »

Setup JBoss on Red Hat Enterprise Linux 5 (RHEL5) Server

A recent task required an installation and setup of a JBoss Application Server on a Linux box. I originally selected the Ubuntu 8.0.4 LTS Server Edition for this task since I have had a little more experience with Ubuntu. I have graduated to Red Hat Enterprise Linux 5.2 (RHEL) and CentOS 5.2. I created A RHEL virtual machine with VMware…

Read More »

Innounp, Inno Setup Unpacker 0.23 (Build: 080824) supports INNO Setup 5.2.3

INNO Setup is a free installer for Windows programs available at JRSoftware. There is no official unpacker – the only method of getting the files out of the self-extracting executable is to run it. An open source utility called innounp.exe is maintained at Sourceforge. Sourceforge has maintained version 0.19 online for over a year, however, 0.20 also exists from Sourceforge,…

Read More »

WordPress LDAP Authentication

I wanted to enable LDAP in an instance of WordPress 2.6.2. To do this was not as simple as I had hoped. I spent a little over an hour trying to implement something that seemed to be self evident. After some research and testing and once all the pieces were identified and correctly configured, I finally got it working. The…

Read More »