Export the DB Schema ONLY

To dump the database SCHEMA only, without dumping any actual data :

mysqldump --no-data --tables -u YOUR_USER_NAME -p DATABASE_YOU_WANT_SCRIPTED >> FILENAME.sql

Actual example:

mysqldump --no-data --tables -u larry -p contacts >> contacts.sql

If you want the data to be exported, omit the ”–no-data” portion.

Reset MYSQL root password

Simple steps to reset the mysql root password if you have forgotten it.

1. Stop the mysqld daemon process.

2. Start the mysqld daemon process with the '–skip-grant-tables' option.

3. Start the mysql client with the -u root option.

4. Execute the following:

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';

5. Execute the following:

FLUSH PRIVILEGES;

Parallels Helm cannot reseller can no longer delete customer account

Suddenly one of my resellers stopped being able to delete a customer account and was getting the following error

Unable to perform the requested action as this Login has insufficient permissions

The rest of the resellers on the server however were able to delete accounts without problem. After several hours of searching and contacting parallels support the resolution was simple

The problem is insufficient account permissions for the reseller.

What I did was going to Home > Account Settings > Customer Account Roles, selecting the 'Reseller' role (the only available),

selecting 'Specify Permission' instead of 'Pre-defined Roles' in its configuration page and adding the 'Delete Account Profile' from 'Available Permissions' to 'Selected Permissions'.

Then I saved the changes I made and successfully deleted again...

Install squirrelmail to Parallels Helm 4.1 as an application package (APS)

I recently needed to be able to offer squirrelmail 1.4 to customers using Parallels Helm 4.1

I downloaded the latest version of squirrelmail and bundled it up so that it can be added as a package in the control panel.

The config file is based on the original sample config file provided in the parallels sample application package. GUID created using this tool.

Please note

The way the config is setup it will create the following two directories which are above the web root of the domain (this is recommended by the squirrelmail documentation).

private/squirrelmail/data
private/squirrelmail/attach

Once installed your clients will be able to access this package through their Helm control panel at

Home > My Domains > yourdomain.com > Application Packs

Enjoy!

ps: as usual no waranties made and no liabilities accepted. Any questions let me know!

Download the application package for Helm

How To Reinstall Horde

To reinstall Horde, preserving the existing database, you can use the following:

/usr/local/cpanel/bin/update-horde --force

Turn off bandwidth monitoring

Go to WHM >> Service Configuration >> Service Manager.
Look for ‘cPBandwd’. Make sure that the check box besides that is unchecked.
Save the settings and that should be it !

How to repair Grub loader

GNU GRUB (“GRUB” for short) is a boot loader package from the GNU Project. GRUB is the reference implementation of the Multiboot Specification, which allows a user to have several different operating systems on their computer at once, and to choose which one to run when the computer starts. GRUB can be used to select from different kernel images available on a particular operating system’s partitions, as well as to pass boot-time parameters to such kernels.

Every once in a while windows may have the inclination to overwrite your bootloader with its own. This will make accessing your system impossible.
Well, there is a solution to override the 512 Kb of your drive that represent the MBR.
In the fact you can follow these steps to repair your GRUB loader:
Boot your PC with a Live CD in the drive, after run fdisk to display list of your partitions system.

$ sudo /sbin/fdisk -l

Disk /dev/sda: 250.0 GB, 250059350016 bytes
255 heads, 63 sectors/track, 30401 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk identifier: 0xa588e9cb

Device Boot Start End Blocks Id System
/dev/sda1 * 1 30071 241545276 83 Linux
/dev/sda2 30072 30401 2650725 5 Extended
/dev/sda5 30072 30401 2650693+ 82 Linux swap / Solaris

In that fdisk example, the root linux partition reside in /dev/sda1
Create a directory /mnt/root and mount the linux partition.

$ sudo mkdir /mnt/root
$ sudo mount /dev/sda1 /mnt/root

Change the root “/” directory to our old root directory the /mnt/root
$ sudo chroot /mnt/root /bin/bash

Execute the grub command
$ sudo grub –config-file=/boot/grub/menbu.lst

GNU GRUB version 0.97 (640K lower / 3072K upper memory)

[ Minimal BASH-like line editing is supported. For
the first word, TAB lists possible command
completions. Anywhere else TAB lists the possible
completions of a device/filename. ]

Now we need to tell grub where are the grub files:
If you don’t know where they are, type:
grub> find /boot/grub/stage1
(hd0,0)

Now type the following, replacing hd0 with the physical drive linux is installed
grub> root (hd0,0)

Remember that for grub (hd0,0) means hda (primary controller master), first partition.
Let’s install the grub on hd0
grub> setup (hd0,0)
grub> quit

$ sudo reboot
Now you can reboot safely, with your linux system. --Ali