Converting MySQL to SQLite

I have begun playing around with SQLite and needed a way to convert a MySQL database into a SQLite database. After trying several different methods the one that I ended up going with was the script documented in this article.

Documenting it here so I can find it later myself.

Disabling iptables Console Messages

I’ve been searching for a solution to this and finally found one, so I’m posting it here just so I won’t have to search for it when I forget it again.

I initially thought the messages were coming from syslog-ng but it turned out that the messages kept coming even with syslog-ng turned off.

As it turns out, the kernel was printing those messages directly to the console. Fortunately, it’s possible to set the minimal level a message must have before it is printed to the console.

# dmesg -n 4

After executing this command, only messages having level “warning” (4) or higher will be printed. All message levels are still logged.

Automatic Sub Domain Creation

For those of you who have wanted to sign up for hosting but didn’t have a domain name to use, you know that we allow you to use a sub domain off our ALURIUM.NET domain name. A fully qualified domain name is required because our Railo integration requires that a fully qualified domain name be use to map the host header to the directory path of the account.

Well, up until now you had to ask us to set this up for you because there was no way to automatically test to see if a sub domain name was available for use. Today we released a module that allows you to test the availability of a subdomain in the order form and use an available sub domain and have it provision automatically.

To use a sub domain simply begin by selecting the hosting plan you wish to use. When adding a domain to the account use the ALURIUM.NET drop down from the TLD list and type in a sub name you would like to use.

subnameselection

After you have made entered the sub domain name you wish to use and selected ALURIUM.NET from the drop down menu, click on the check domain link to see if the name you have selected is available. If the sub domain name is already in use by another client you will see the following message.

taken

Otherwise, if the sub domain name is available, you will see the following message with a button allowing you to add the domain to your hosting account.

available

That is all there is to it. When you submit your order your account will provision automatically and you will have full access to the hosting resources provided by the account level you selected.

FREE Trial Railo Hosting

We just announced and release our Trial accounts. The best thing about them is that they are absolutely free. It is a 60 day account that gives you limited disk space and bandwidth but full access to the Railo Administrator so you can test and play with our Railo hosting offerings. If you decide you like the service you can upgrade to a paid account and all of your setting carry forward to the new account.

Why are we doing this? Well we want to lower or completely eliminate the barrier to entry. We want everyone to be able to test our services without feeling presured to sign a lenghty contract. Besides you wont know how good we are until you try us out.

Enable Directory Listing in Railo running on Resin

Automatically generated directory listings are not what you probably want to have enabled on a production server, but for a development box they do come in handy. If you are running Railo server edition packaged with Resin you may be wondering how to enable Directory Listings on your development box. That is the subject of this post. By default Resin comes pre-configured to enable directory listings, but this setting is missing in the version of Resin server that is packaged with Railo, at list the beta 3.1 version which was available at the time of this writing.

Adding this capability back in is quite simple. You must modify the resin.conf file which is installed in the conf directory of the Railo install directory. I’m on a Mac and I installed Railo in a directory under Applications so my path to the Resin.conf file is /Applications/Railo/conf/resin.conf. Fire up your favorite editor and open up this file. Find the <web-app-default> block and add the following code to it:

  <servlet servlet-name="directory"
           servlet-class="com.caucho.servlets.DirectoryServlet"/>

Now all you have to do is restart Resin and you should now have directory listings enabled.

Alurium Hosting Launched….

Just launched the hosting service. Alurium Hosting is now officially open for business. I know some are wondering why we choose to get into the hosting business in these economic times. We were able to employ automation techniques to reduce all our projected overhead and allow us to enter this cut throat market with some pretty exciting features; Dedicated IP addresses, Railo 3.0 CFML scripting, Tomcat 5.0 JSP scripting, and Ruby on Rails.

If you’d like to kick the tires you can use coupon code “RailoHosting” which will wave the first months fees.

Began development of watch-my-site.com

Began development of the website monitoring service I will be launching in a few weeks. The site will be branded under the URL watch-my-site.com. The site is just starting to get developed and will soon be online in an alpha preview. This is exciting for me for two reason’s, one is just the joy of working on one of my own projects, the second reason is getting to play with new technologies. This site will be built using the symfony framework for PHP.

If there are features you would like to see I would love to hear from you.