Surf 11 » Surf 11

A series of blog entries from the MySQL Performance Blog on keeping MySQL available in an Amazon EC2 Cloud

Link: High availability MySQL on Amazon EC2

A good list of resources and tutorials for learning about HTML5

Link: HTML5 Resource and Tutorial List

A Free Web Based tool to record screencasts, post to twitter or YouTube and record up to 5 min

Link: Screenr - Create screencasts and screen recordings the easy way

Examples on using the JavaScript database in Safari from Apple.

Link: Safari Client-Side Storage and Offline Applications Programming Guide: Using the JavaScript Database

If you are running into this problem after installing a ColdFusion 8.0.1 Cumulative Hotfix 4:

java.lang.NoClassDefFoundError: coldfusion/runtime/QueryTableWrapper at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389) at java.lang.Class.getConstructor0(Class.java:2699) at java.lang.Class.newInstance0(Class.java:326) at java.lang.Class.newInstance(Class.java:308) at coldfusion.sql.QueryTable.getShallowCopy(QueryTable.java:2784) at coldfusion.tagext.QueryLoop.setQuery(QueryLoop.java:62)

Make sure you have updated the cfmx_bootstrap.jar file as stated in the hotfix .

You should also make sure that you have deleted any compiled class files after performing such an update.

Link: User Experience Coding How-To's for Safari on iPhone

Instructions for creating a .properties file to automate the ColdFusion install process.

Link: Install ColdFusion Silently

Link: How to run IE on your Mac with VirtualBox

If you are running a Mac Apple includes a version of Apache for you. In modern versions of Mac OSX (Leopard, Snow Leopard) you will be running Apache 2.2 (as of this writing). You can find the httpd.conf file in:

/etc/apache2/httpd.conf

In prior versions of Mac OSX you might be running Apache 2.0, and your httpd.conf file may be located here:

/etc/httpd/httpd.conf

Here's how to restart Apache (httpd) web server on a Mac, open terminal and run the following:

sudo /usr/sbin/apacheclt restart

If you don't like using terminal, you can also restart apache on Mac by doing the following:

1. System Preferences
2. Sharing
3. Uncheck Web Sharing (this is the Apache Service) to turn if off, then check it again to start it up.

Lists vulnerabilities in web apps (and other apps as well)

Link: milw0rm - exploits : vulnerabilities

Link: MetaLab: We make interfaces

Link: Hack My CF - Check your ColdFusion Server for Security Vulnerabilities

Link: How to Restrict the Use of Certain Cryptographic Algorithms and Protocols in Schannel.dll

Simple tool for taking a java thread dump.

Link: AdaptJ Stacktrace

An Icon Set designed for iPhone Apps

Link: Great icons for great iPhone applications

You can use Maatkit to prove replication is working correctly, fix corrupted data, automate repetitive tasks, speed up your servers, and much, much more.

Link: Maatkit: A toolkit that provides advanced functionality for MySQL

Have you ever wanted to open up a new Finder window from the mac shell / command line via terminal. Turns out it is pretty easy to do using mac's open command.

To open up the current terminal directory in a new Finder window just run:

open .

To open your home directory in finder run this:

open ~

Your documents:

open ~/Documents

As you might have guessed you can type in any directory and it will open that up. You can also type in a file name and it will open it up using the default application.

Ever get this error with ColdFusion?

Error casting an object of type coldfusion.compiler.ASTsimpleVariableReference to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed.

java.lang.ClassCastException: coldfusion.compiler.ASTsimpleVariableReference
	at coldfusion.compiler.StmtAssembler.createCFloopIndexVariable(StmtAssembler.java:2020)
	at coldfusion.compiler.StmtAssembler.cfloopList(StmtAssembler.java:1838)
	at coldfusion.compiler.StmtAssembler.cfloop(StmtAssembler.java:1687)
	at coldfusion.compiler.StmtAssembler.assembleStatement(StmtAssembler.java:284)
	at coldfusion.compiler.TemplateAssembler.assembleStatement(TemplateAssembler.java:238)
	at coldfusion.compiler.StmtAssembler.block(StmtAssembler.java:201)
	at coldfusion.compiler.TemplateAssembler.assemblePage(TemplateAssembler.java:200)
	at coldfusion.compiler.TemplateAssembler.assemble(TemplateAssembler.java:77)
	at coldfusion.compiler.NeoTranslator.translateJava(NeoTranslator.java:316)
	at coldfusion.compiler.NeoTranslator.translateJava(NeoTranslator.java:119)
	at coldfusion.runtime.TemplateClassLoader$1.fetch(TemplateClassLoader.java:310)
	at coldfusion.util.LruCache.get(LruCache.java:180)
	at coldfusion.runtime.TemplateClassLoader$TemplateCache.fetchSerial(TemplateClassLoader.java:254)
	at coldfusion.util.AbstractCache.fetch(AbstractCache.java:58)
	at coldfusion.util.SoftCache.get(SoftCache.java:81)
	at coldfusion.runtime.TemplateClassLoader.findClass(TemplateClassLoader.java:476)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:79)
	at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:175)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

It is caused when you put a variable with pound signs where it is expecting a variable name. For example this code with throw this exception:

<cfloop list="#list#" item="#item#"></cfloop>

The #item# should just be item

If you try running this command to add a new column on Microsoft SQLServer:

ALTER TABLE ADD COLUMN column_name int

You will get an error message:

Incorrect syntax near the keyword 'COLUMN'.

That's because SQL Server Doesn't like ADD COLUMN it prefers you just say ADD instead:

ALTER TABLE ADD column_name int