Cross-platform Notes

• A description of i386 i486 i586 i686 - The following was lifted from Best of the Newsgroups: compiler optimizing. --- Begin excerpt --- Jim Kroger <--->, In a message on Mon, 26 May 2003 18:55:29 -0400, wrote : JK> Nobody has yet said what i386 and i686 refer to. J...
• Acer Travelmate 8100 series technical specifications - This is a copy of the spec that used to be on Acer’s web site. It’s gone now, but I did find this on their support site: TravelMate 8100 Series Specifications. Operating System Microsoft Windows XP Professional (SP2) Processor and ch...
• Ant - Some potentially useful resources: Subversion revision control system." class="weblink">SvnAnt – An ant task that provide an interface to Subversion revision control system. Conditional Compiling – Article about conditional compiling in A...
• Audio formats - See What’s the difference between WAV, AIFF, AIF, MP3, FLAC, WMA, ALAC, M4A etc …? ISO Raw data. CDDA - Compact Disc Digital Audio CDDA (A.K.A. Red Book standard) defines audio CDs. Its audio format uses LPCM (Linear Pulse Code Modulat...
• Copy a VMware Server virtual machine - In VMware Server, you can only ever have a SINGLE snapshot of a VM. You click the "take snapshot" button and it will overwrite the old one. However, it turns out that you can easily copy VMs. Simply copy the folder to a different location. Open the V...
• Create charts / graphs in OpenOffice oocalc - Aim: Count occurrences of words in a column and create a pie chart from it. The column that you'd like to chart should have a title in its first cell. Select the column. Data -> DataPilot -> Start. Use current selection. Window will pop up t...
• Creating a bibliography in LyX using BibTeX - This article describes how to create a bibliography in LyX 1.4.1 using BibTeX. Add the following preamble to wrap long urls and use the natbib style with numbered citations. Document -> Settings... -> LaTeX Preamble. \usepackage {url} \usep...
• How to create different headers in an OpenOffice / LibreOffice / odt document - Summary: Create a unique page style for each header and add them by adding page breaks. Details follow after a brief rant, because I can’t help it. Rant: I hate Microsoft Office and I hate OpenOffice / LibreOffice just as much. Even thinking abo...
• CSS width on inline vs block level elements - div#test_width_div_243 { border: 1px solid black; width: 20em; } span#test_width_span_243 { border: 1px solid black; width: 20em; } Below is an example of an inline element - the span - and a block level element - the div. Both been styled with CS...
• CUPS client-error-document-format-not-supported - The setup You have a printer connected to a linux box and managed using CUPS. You are accessing the printer from Windows (XP) via IPP using http://[printserver]:631/printers/[printername]. The problem Printing fails from Windows, with the follo...
• Determine which storage type is used by a MySQL table - To determine which storage type (e.g. MyISAM, InnoDB) is being used by a table, use the mysqlshow command: mysqlshow -i -u[username] -p [database] Only use the -u and -p flags if you need to specify a username and enter a password to access the dat...
• Eclipse - Notes about Eclipse v3 and related plugins. Index Exception thrown launching help Eclipse with Subclipse or Subversion Exception thrown launching help | Go to top Try configuring a default browser. Go to Window -> Preferences ->H...
• Facebook photo album privacy - Facebook is a privacy nightmare. Here’s one problem I found regarding the creation of photo albums, which is largely due to their use of language: When creating a photo album (after uploading photos) and editing it (when editing the photos in an...
• Firefox find as you type problem - There is a well known "bug" in firefox, whereby typing on the keyboard will start the "find as you type" (aka "lookahead find") feature and start searching the web page for whatever you typed. I believe firefox enables this option by default. The fir...
• Adobe Flash local storage default settings - Adobe Flash v10 will present the following message when a site wants to store info on your computer: Adobe Flash Player Settings Local Storage s.ytimg.com is requesting permission to store information on your computer. Requested: up to 10 KB Currentl...
• Generate Javadoc - Javadoc pre v1.4. Notes may be applicable to later versions, but untested. Oddities Commands Resources Oddities | Go to top First, some oddities: In your Javadoc comments you must not have a * before an @ (that precedes a Javadoc tag)...
• Gmail ignores dots in username - Gmail doesn’t recognize dots as characters within usernames, you can add or remove the dots from a Gmail address without changing the actual destination address; they’ll all go to your inbox, and only yours. From Receiving someone else&rsq...
• How to add Google Translate as Firefox search keyword - Firefox has a great feature that allows you to right click on a search box (form text field) and select “Add a Keyword for this Search” to associate a keyword with the search via a special bookmark. From then on you can run the search by en...
• Grouping / concatenating / aggregating MySQL fields / column values - Given the test database from MySQL many-to-many join test and the following query: mysql> select posts.*, categories.* from posts_categories join posts on posts_categories.post_id = posts.post_id join categories on posts_categories.category_id = ca...
• High-speed Brute-force Password Cracker for MySQL 3 - I took this program from the Securiteam web site. I believe it was posted on their mailing list by someone known as Secret Squirrel. It will crack passwords that have been hashed using the old MySQL 3 password hashing function. I tried it an it works, ...
• Hotmail notes - Notes about Hotmail. Send from another address Go to ‘Options -> (More Options ->) Sending/receiving e-mail from other accounts’ and ‘Add another account to send mail from’. After verifying the address (by following the...
• How to clean a trackball - The following was lifted from a Customer Reviews Of Microsoft TrackBall Optical Black Mouse. I've tried it and it works. PROBLEM: You've just cleaned the ball and bearings, and now it feels weirdly reluctant to move with your thumb, as though it's de...
• How to close a section in LibreOffice / OpenOffice - You can define sections in a LibreOffice / OpenOffice / odt document to format parts of a document differently, if e.g. you want one part to have multiple columns. Alt-Enter will close a section. Yet again it took an age to figure out - I couldn&rsqu...
• How to print landscape in Open Office oocalc - Open Office version 2.3.1 It's not immediately obvious how to print in landscape mode in Open Office spreadsheet (oocalc). Here's how... Do a page preview. File -> Page Preview. Click the Format Page tab. Click the Page tab. Select landscape o...
• How to save a copy of a file cached by Firefox - Firefox caches files from a web page, presumably saved somewhere in the .mozilla/firefox/[profile]/Cache/ directory under a random name. It is possible to view information about the cached files and save a copy using a more descriptive name. Go to ab...
• How to search events in Lightning calendar - To search events in the Thunderbird (10.0.3) Lightning (1.2.b1) calendar extension: Select the calendar tab. Events and Tasks -> Find Events. They should really add a search button next to the tasks icon (top right) as they have with email.
• HP Officejet J6410 printer - Printer settings Ethernet I needed to set the following printer configuration in order for the printer to work on my network via gentoo (via cups/hplip). They proved fine for a Windows XP box too. IP: Automatic. Link speed: 10-Full. If having probl...
• iTunes notes - Notes about iTunes. Create keyboard shortcuts for rating music in iTunes To create keyboard shortcuts to rate the current song in iTunes (From The MacTipper Blog: Add Keyboard Shortcuts for Rating Songs in iTunes): System Preferences -> Keyboa...
• Jar - To inspect a jar archive use the following command, where file.jar is the jar you want to inspect: jar tf file.jar Listed below is a combination of commands that checks all jar files in the current directory (and all subdirectories) for...
• Java Collections - This page refers to Lists, Sets and Maps in the Java 2 platform. Their class hierarchy relative to the top level interfaces are as follows: The table below was nicked from a JavaWorld.com article called Get started with the Java...
• Latext / Lyx footers - Lyx is basically a graphical editor for latex documents. The notes below have been tested with lyx version 1.5.4. To get a footer on each page of your document, first change the page style to fancy (document -> settings -> page layout -> page style ->...
• Latex / Lyx preamble for document metadata and styling - The Latex (or Lyx, a GUI for Latex) "preamble" can be used to set document metadata, like the title, author and date, and add styling, such as headers/footers. To re-use metadata, create your own variables and reference these wherever you'd l...
• How to create a LibreOffice chart with two axes - In LibreOffice 3.5. Create your chart as normal. I’ll assume you’ve created some kind of line graph. Right-click on the chart and select Edit. Right-click and Insert/Delete Axis. Select a secondary Y axis. Now you’ll have tw...
• MODx - Useful SQL – Useful SQL for use on the MODx database. MODx Links – Useful MODx links. MODx Customisations – Customisations made to the MODx Content Management System for mindspill.net.
• Converting MySQL tables from MyISAM to InnoDB - For MySQL 4.1, to convert the MyISAM tables to InnoDB (for transaction support and more), you have to... Edit the SQL so that the foreign keys are indexed Make sure that any tables containing a referenced column are created before the tables which ...
• MySQL many-to-many join test - MySQL 5.1.56. Setup: create database join_test; connect join_test; create table posts (post_id int not null auto_increment, name varchar(100), primary key (post_id)); create table categories (category_id int not null auto_increment, name varchar(100)...
• MySQL - Index Create new user Backing up Locate configuration files Max allowed packet error MyISAM to InnoDB Check a database for errors and repair tables Create new user | Go to top The following applies to MySQL versions 4 and 5. MySQL 5 has an ad...
• oocalc pie charts - Count occurrences of words in a column and create a pie chart from it The column should have a title in its first cell. Select the column. Data -> DataPilot -> Start. Use current selection. Window will pop up to define the data fields...
• oocalc notes - Notes about oocalc. Source cell range from different sheet Copy the range in sheet 1. Paste Special in sheet 2, selecting the Link option. Show rows hidden by a filter If you apply a filter and it hides a load of cells, select all cells (i.e....
• oowriter variables - To create a variable in oowriter 3.0.0... Normal variables (i.e. single occurrence) A normal variable can be inserted into the document. You double click it to edit its value. Insert -> Field -> Other. Variables tab. Set type to 'Set variable'. ...
• Permanently remove Mozilla Firebird extension - The following was taken from a posting on the Mozillazine forums by laszlo. Posted: Wed 8th Jan 2003 4:23pm How to uninstall an extension Until the uninstall feature for extensions is implemented (bug 170006), use this procedure as...
• PHP - Read file without php error messages – How to read the content of a file in php without showing nasty warning messages if it can't be opened Suppress PHP errors and warnings – How to suppress PHP error and warning messages PHP modulo operat...
• Prevent Apache listing directory contents - Add a file called .htaccess to the directory that contains the following: IndexIgnore * The * is a wildcard that matches all files. E.g. You could use *.jpg to hide only the JPG files (with a .jpg extension). The list of files to ...
• Prevent password prompt when starting Apache's SSL - When OpenSSL is first configured it is normal to encrypt the SSL encryption key. This means that when the SSL is started a password is required so that the key can be decrypted. To prevent this happening you simply store the key unencrypted. Obviously ...
• Problem dropping MySQL user - MySQL 4.1.14. If you can not drop a user because you get the following error: mysql> drop user 'username'@'domain'; ERROR 1268 (HY000): Can't drop one or more of the requested users Revoke all privileges first: mysql> REVOKE ALL PRIVILEGES FROM...
• Problems with hyphens in MySQL. - MySQL does not handle hyphens very well. For example, I created a database called "modx-test" and then tried to delete it, which failed due to a syntax error: mysql> drop database modx-test; ERROR 1064 (42000): You have an error in your SQL syntax; ch...
• Regular Expressions - The following was nicked from Zhou Chen :: Regular Expression, which in turn was nicked from Regular Expressions by Ashley J.S Mills. Regular Expressions Introduction You have probably used regular expressions before, for instance if you ...
• Review of Ruby static CMS / site generators - Requirements Ruby framework. Pages maintained in git. Generated paths_that_are_built/from_the_directory_and/file_names.html. Web page should either not have an extension or should be same as online format used, e.g. html. Support for textile,...
• RSI - Repetitive Strain Injury - Some tips for overcoming RSI. Swap hands and input device Periodically swap input device between your right and left hands. Also, I found that changing the type of input device helped a great deal. Periodically swap between a normal mouse, a finger ...
• Ruby on Rails - How to list rake tasks – How to list the available rake tasks. Generate documentation for all Ruby gems – How to generate documentation for all installed Ruby gems. rake doc:app, rdoc and private methods – How to generate documentatio...
• Ruby - Parsing UK dates If you try to parse a date/time in the form ‘dd/mm/yy hh:mm:ss’ in Ruby 1.8.7, you can get the following: irb(main):005:0> s = '14/02/07 20:54:19' => "14/02/07 20:54:19" irb(main):006:0> Time.parse(s) ArgumentErr...
• Thunderbird notes - Notes about Thunderbird. Remote images By default Thunderbird 8 blocks remote images. You can show these images for a particular email by clicking the ‘show remote content’ button, but beware that there’s no easy way to undo this (y...
• Tomcat - Customised 404 error page Customised 404 error page | Go to top To customise the 404 "page not found" error page that is displayed by Tomcat, simply add the following to the web.xml file below the closing welcome-file-list tag: ...
• How to write a MySQL table to a CSV file - To write the users table to /tmp/users.csv: SELECT * INTO OUTFILE '/tmp/users.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM users Source: Export data to CSV from MySQL

Last modified: 04/06/2007 Tags: (none)