On a solaris system I sometimes try to edit the crontab file with crontab -e and all I get in return is a number (signifying the number of characters by the ed editor I believe). # crontab -e4025^C?The crontab file was not changed. I need to Ctrl-D to exit.To get the ball rolling again: EDITOR=vi;export… Read more »
Posts By: jonny
MySQL: marked as crashed and should be repaired
I was receiving the following error message in a MySQL database. SQL Error: Table ‘./dbname/tablename’ is marked as crashed and should be repaired So first I tried: REPAIR TABLE `tablename`; However the table was still showing as crashed. Next I tried: mysqlcheck -r -u username -p databasename Which took some time as the database is… Read more »
MySQL Structure Backup
To backup / dump only the structure of a MySQL database (without the data) use the following: mysqldump -u root -p –no-data –all-databases > /var/struct_only.sql
Unix Timestamps and MySQL
Unix timestamps (the number of seconds since Jan 1st 1970) can be converted online at:http://www.unixtimestamp.comSome example dates:26 Feb 2006 19:37 114100066826 Feb 2007 19:37 117253662026 Feb 2008 19:37 120407262012 Aug 2007 12:00 1186934400I had cause to prune some old records from MySQL by unix timestamp, which I did with:USE `emaillog`;DELETE FROM `deliveries` WHERE timestamp<1186934400;19 million… Read more »
Plesk SMTP – domain isn’t in my list of allowed rcpthosts
553 sorry, that domain isn't in my list of allowed rcpthosts (#5.7.1)Reading http://forum.swsoft.com/showthread.php?t=8047 I set the email server settings in Plesk as suggested. Then listed the server IP/32 in addition to 127.0.0.1/32 in the white list. Making sure the servers IP and hostname are listed in the /etc/hosts file along with the loopback address
Exchange 2007 Receive Connector SCL Headers
Our Mailhubs set the following Mail header which is interpreted by MS Outlook when filtering messages to the JunkMail folder: X-MS-Exchange-Organization-SCL A score is assigned to this header based on analysis by SpamAssassin so this header will have the same value as X-Spam-Score. The default behavior for Exchange 2007 is to remove any pre-existing X-MS-Exchange… Read more »
Magento Frustrations
Magento seems like a very good e-commerce application and for the most part is pretty intuitive but the following may help for future reference: Supported Payment GatewaysThere is a list of the supported Payment Service Providers on the features page. Back-End AddressThe address for the back-end control panel is http://thedomain.tld/index.php/admin Front-end Horizontal MenuI wanted the… Read more »
Bridge on Linux
A while ago I did a fruitless search for my father for a Bridge card game on Linux but didn't turn up much of interest. However, I recently read in www.LinuxFormat.co.uk (great magazine) about Contract Bridge which costs £15 including CD and postage: http://www.xcontractbridge.com/xbridge.htm
Beginning Powershell
When writing my first powershell script to check free disk space on a dozen exchange servers I picked up a few useful things for future reference. Echoing output to the command lineA script can print/write output to stdout using Write-Host “Hello World” but this command is aliased too, so that echo “Hello World” will also… Read more »
CycloDS Evolution for Nintendo DS
The CycloDS Evo is one of many flash carts for the Nintendo DS / lite. This modification card is used in conjunction with a Micro SD card on which you can store games, music, videos and even a linux distribution. For this I used: a Nintendo DS Lite The CycloDS Evolution purchased from eu.mod-chip.com approx… Read more »
