Command to delete files older than x days
find /your_directory -mtime +7 -exec rm -f {} \;
works great for my mysql backup folder.
yum-complete-transaction
After upgrading my box to centos5.3 I started seeing an error
There are unfinished transactions remaining. You might consider running yum-complete-transaction
first to finish them
On trying to run yum-complete-transaction the cmd was unrecognized. . Solution: Install yum-utils, drop down to root environment (su -) and run the cmd yum-complete-transaction, it should run and fix your yum problem
.
Restoring wordpress from database
I messed up the permissions on my box and on restart three quarters of the services would not come up so doing a database backup was out. All my previous DB backups had the plugins still active. So when I tried to restore using them the blog is viewable, but when I try to log in I get a blank page on checking my Apache logs I saw the following error
Cannot use string offset as an array in wp-includes/capabilities.php on line 116
Restored database a couple of times nothing worked, tried upgrading & updating database nothing worked. Finally just installed WP from scratch with blank database. Opened up PhpMyadmin replaced new WP tables with tables from old WP DB backup, skipped table wp_options as it broke the new WP and both user tables as I had already setup the new user data on install, but I guess if you want to keep the old user data you can transfer these too.
Now I just made a backup of wp_options after restoring all the settings e.g blog name etc and turning off all plugins. This way next time all I have to do is just switch this table with the one from a backup whose plugins were still on at backup and am good to go.
Webcalendar send reminders error
After installing web calender and activating the send reminders option, be sure to edit the location of
/usr/bin/php
as on default it tries
/usr/local/bin/php
which is the wrong place. This will cause cron errors.
Remember to move it’s location for security purposes.
Date Edited Auto-Update
I was using dreamweaver to edit my webpages which uses it’s own auto update on save date code<!– #BeginDateformat:Am1 –>May 5, 2005<!– #EndDate –> (Dreamweaver’s Auto-Update-on-Save Date Code). When I switched to bluefish as my main editor the auto update code wouldn’t work. So I looked around and found a php code to get the same thing done. Just place it anywhere you want the date to appear
<?php echo date(‘F j, Y’, filemtime(__FILE__));?>
If you want to store it to a variable you can do
$variable_date = date(‘F j, Y’, filemtime(__FILE__));
You can exchange filemtime with filectime if you want to display the date the file was created.
Imap: Fatal: listen(993) failed: Address alr eady in use
Booted the server the other day and got the message that dovecot can’t start because listen address 993 was already in use.
Any logins to squirrelmail received an error message. To solve this I run the command
lsof -i :993
This will list the application listening on the particular port and you can go ahead and kill it or assign it a different port. Remember to change the port number (993) to whatever port your imap server or whatever program you are troubleshooting is supposed to be listening on.
To start dovecot the command is:
/etc/init.d/dovecot start
copy files with smbclient
I am used to using the linux gui to do most of my stuff, but every now and then you have to drop to cmd line to expediate some tasks. I found this neat app that i haven’t been using called smbclient, it has been saving me a lot of time while copying files to and from my linux box since I started using it.
To log in to a share:
smbclient //IP/share -> you enter password and you are in
To copy local file to share:
put test.odf -> you can add path details if the file is not in your local directory e.g /var/doc/test.odf
To copy file from share:
get test.odf
To find out further uses of this app checkout this link.
Enable wordpress ssl login
If you are using any version => than 2.6 you can force all admin sessions to be over ssl just add the following to your wp-config.php file:
define(’FORCE_SSL_ADMIN’, true);
Ryan Boren does a great job of explaining this and other options you have to secure your connection here.
You might also be interested in the SSL plugin incase your wordpress version does not support this.
Atlanta Linux Fest 2008 Yeah!!!!
Just signed up for the upcoming atlanta linux fest click for details. Cant wait for it to get here and see what other people are doing with their boxes. Plus what the companies are going to be showing off.
Secure squirrelmail with ssl
To secure squirrelmail, edit the following file and edit it to look like below.
vi /etc/httpd/conf.d/squirrelmail.conf
Alias /webmail /usr/share/squirrelmail
<Directory “/usr/share/squirrelmail”>
SSLRequireSSL
Options Indexes MultiViews
AllowOverride None
Order deny,allow
Deny from all
Allow from all
</Directory>
Thats it.
NB: Remember now the only way to access mail is by https://……../webmail not http://……/webmail otherwise you get a nice page saying Forbidden!