exim permissions error

When I see this:

login as: root
root@64.254.200.10's password:
Last login: Mon Aug 31 15:44:06 2009 from adsl-70-131-140-218.dsl.emhril.sbcglob al.net
[root@ls3 ~]# 2009-08-31 15:45:42 1MiDl0-0001b0-SA Failed to create spool file / var/spool/exim/input//1MiDl0-0001b0-SA-D: Permission denied
[root@ls3 ~]#


I do this (temporarily):
chmod -R 777 /var/spool/exim
because this does not work:
chmod -R 755 /var/spool/exim

Directadmin - MySql move a database and grant user permission

So to move a Mysql database from one server to another all you have to do is copy the database over and then grant the appropriate permissions to the new database on the new server.

In the example below the username is da_admin and password kbjlms1X

the database name is aurorafcs_md
the database user name is also aurorafcs_md
the database user password is gggyro33

To grant the permissions:
2. [root@ns2 conf]# mysql -uda_admin -pkbjlms1X
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6118
Server version: 5.0.37-standard MySQL Community Edition - Standard (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all privileges on aurorafcs_md.* to aurorafcs_md@localhost identified by 'gggyro33';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

Exchange 2003 Information Store Repair

So a client had a Exchange 2003 Information Store corruption issue on a lovely saturday night when I was supposed to be at the movies at the park in the neighborhood with the kids.

Anyway, here is a command to fix it (after you have made backups of the edb and stm files):

ESEUTIL /P "D:\Program Files\Exchsrvr\MDBDATA\priv1.edb" /S"D:\Program Files\Exchsrvr\MDBDATA\priv1.stm" /T"D:\Program Files\Exchsrvr\MDBDATA\tempdb.edb"

Remove 'Welcome to the Frontpage' title in Joomla! 1.5

How to remove 'Welcome to the Frontpage' title in Joomla! 1.5
Navigation
• •
If you install new Joomla! 1.5 on your server, you get the 'Welcome to the Frontpage' title on your Frontpage. Sometimes, it is difficult to find, where you can change this title.

Go to your Joomla! 1.5 Administration site and login. In your administration site go to:

Menus - Main Menu (now you are in: Menu Item Manager: mainmenu).
Click on 'Home' link to edit this link (you are now in: Menu Item: Edit).
Click on Parameters System and change or delete the Page title.
If you change the Page title, changed title will be displayed on your Frontpage as a title.
If you delete the Page title, Menu link will be displayed on your Frontpage as a title (in the present case 'Home' will be displayed as title, because 'Home' is the name of the link to the Frontpage).
If you don't want to display any title, set Show Page Title below Page title parameter to 'No'.
Don't forget to save changes.

Transfer linux pop mail directadmin command

so to transfer email from one DA box to another:
scp -r 64.254.200.10:/etc/virtual/rubesreadymeals.com/* /etc/virtual/rubesreadymeals.com

scp -r 64.254.200.10:/var/spool/virtual/rubesreadymeals.com/* /var/spool/virtual/rubesreadymeals.com

Mysql directories and move info

It is no fun when a linux shared hosting server crashes. You have to move the web files, email, and any mysql databases the users websites are running on, not to mention DNS info. So get some mountain dew and lets get started:

Mysql important directories:
The databases are all here: /var/lib/mysql

Grep for the mysql username and password in:
Joomla - configuration.php
Drupal - settings

Directadmin info is here: /usr/local/directadmin

tar help (zip up a linux dir and all files and subdirs)

use this to zip up linux dirs, files, folders, subdirs, etc.

tar -cvzpffilename.gz {source dir or files wildcard}

Example:
tar -cvzpfpublic_html_backup_08122009_plinkgolf.gz public_html

where:
-f - whatever follows the f is the filename, so public_html_backup_08122009_plinkgolf.gz is the tarball/zip file name in this case.
-v indicates verbose listing of command output.
-c indicates create a new tar ball file.
-z indicates use gzip.
-p indicates preserve all permissions of underlying files/dirs being zipped.
public_html - is the name of the top level folder I am zipping including all its subfolders and files underneath it

Have a nice day!

Oops - almost forgot, to explode/unzip the zip file in the current directory, just type:

tar -xvf nameofzipfile.gz