Have you ever wondered why the new Microsoft 2007 Word file type (.docx) can not be downloaded directly from your Apache server? Well, the answer is because it doesn’t recognize what kind of application type it is, therefore it can’t send the correct header information to your browser. Fortunately, the fix for this is rather simple with Apache. Just add these application types for MS Word to your server’s httpd configuration (httpd.conf or apache2.conf) and files will start downloading like magic.
# New Application Types for MS Word.
addtype application/onenote … Continue reading New Application Types for MS Word
This SugarCRM backup scheme (tested on v5.2) was developed with help from several online tutorials. The concept is to generate daily and weekly file backups of the SugarCRM file structure, excluding the upload directory which contained too many email attachments (mostly spam) at the time. These shell scripts assume your SugarCRM install is located at /var/www/html, make the necessary changes to the paths. Also, remember to setup the actual CRON for these shell scripts.
SugarCRM Backup
Place two files into directory /usr/local/bin
#!/bin/bash
# crmfbweekly:
# consists of three lines: one to find the modified files, and then two to tar and gzip them
find … Continue reading SugarCRM Backup Scheme
“Robocopy to the rescue?”
Recently I’ve been dabbling into the world of System Administration. As most people already know, this is a rather large world of next to useless information that only System Administrators can truly admire. For the rest of us, it’s a major pain in the you know what. System Administration by itself, serves no true purpose other than to support others. Yet, it has to be done.
Backup systems are one of these pains in the you know where. I did some research for the company I am working for and came to the conclusion that there is no great … Continue reading XCopy and Robocopy Backup to the rescue?
A little while ago I inherited an old Plesk server at my workplace. Of course, nobody knew the root password. So, I had to call the hosting company who housed our dedicated server and get the root password for the box. Unfortunately, nobody knew what the MySQL root password was either. Luckily I discovered there is a way to reset this password.
Following are the steps to reset the Mysql password in Plesk:
1) Login to the Server and load MySQL with the ‘skip-grant-tables’ in /etc/my.cnf like below. Your file will most likely look different.
[mysqld]
default-character-set=latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable=max_connections=500
skip-grant-tables
2) Log on … Continue reading Reset the MySQL root password.
