foscode

ExtJS Treepanel with MySQL data

// December 29th, 2011 // 3 Comments » // Code, Featured

In this tutorial I’ll show you how to build an ExtJS treepanel using data coming from MySQL, while using PHP to create the json array sent to the treepanel. Here’s how:

Continue Reading

How to connect to Microsoft SQL server from Linux via command line

// September 23rd, 2011 // 2 Comments » // Code, Featured

Although 95% of my work is done in Linux and MySQL, there are those unfortunate times I need to manipulate some data on a Microsoft SQL server. I didn’t want to install any apps on my computer that weren’t open source and I didn’t want to use a Micro$uck app through wine either. So after a few searches I came across an open source project called Sqsh. In this tutorial I’ll show you how to install sqsh and access a Microsoft SQL server from the Linux command line.

Continue Reading

Apache Virtual Hosts in Ubuntu in 5 easy steps

// August 19th, 2011 // 11 Comments » // Code

In this tutorial I’ll walk you through setting up 3 Apache virtual hosts running on a single Ubuntu server. An Apache virtual host, as explained by Apache, refers to the practice of running more than one web site (such as www.company1.com and www.company2.com) on a single machine. Virtual hosts can be “IP-based” or “name-based”. By default, Ubuntu already has this capability enabled, so things are much easier to configure these days. Enough with the intro, this is how you do it:

Continue Reading

Installing jasperserver 4.0 with mysql 5.5

// August 19th, 2011 // 3 Comments » // Code

Installing jasperserver on tomcat with mysql5.5 it isn’t as straight forward as one might think (or as their manual implies). I was trying to install the latest version of jasperserver using the war method and found the script fails.
Reason: there are two files with the wrong syntax that need to be edited (this might also affect other versions of mysql and jasperserver). The files mentioned are located in this folder:
jasperreports-server-cp-4.0.0-bin/buildomatic/install_resources/sql/mysql/ and they are called:

js-create.ddl
quartz.ddl

Continue Reading

php ajax/jquery countdown

// August 13th, 2011 // 1 Comment » // Code

I recently came across the need to have a countdown displayed in one of our applications. I was going to be releasing a new version of our app and wanted the users to have an idea of how long it was going to take until the application was up and running. After a few searches I found a plugin that does just what I needed, it is a jquery plugin, very simple to use and to add to any php application in just a matter of minutes.

Continue Reading

Connect to Cisco Nortel Contivity VPN from Ubuntu

// August 7th, 2011 // No Comments » // Code

I finally figured out how to get Ubuntu to connect to a Nortel Contivity VPN. It took quite a while to find the right app and configuration, but after a lot of search, I’ve found a package called vpnc (vpn client for cisco3000 VPN Concentrator). The project homepage is found here and it is supposed to work with:

* Cisco VPN concentrator 3000 Series
* Cisco IOS routers
* Cisco PIX / ASA Zecurity Appliances
* Juniper/Netscreen

Continue Reading

How to create a robotic voice using audacity

// July 2nd, 2011 // No Comments » // Code

In this tutorial I’ll guide you through creating your very own robotic voice. You”ll need to have 1 tool installed, audacity audio editor. If you are running ubuntu, just run from the command line sudo apt-get install audacity, otherwise, head on over to their site and download the latest version and follow the install steps. Once audacity has been installed we can get started.

Continue Reading

Setup Guest OS on a virtual disc image (virtual machine) on Linux

// June 9th, 2011 // No Comments » // Code, Featured

(This tutorial assumes you own a legal copy of the OS you’ll be using to install as the “guest” OS, be it Unix, Winblows or any other Operating System not mentioned here)

In this tutorial I’ll walk you through setting up a virtual machine in Linux using QEMU. According to QEMU site, QEMU is a generic and open source machine emulator and virtualizer. When used as a machine emulator, QEMU can run OSes and programs made for one machine (e.g. an ARM board) on a different machine (e.g. your own PC). By using dynamic translation, it achieves very good performance.

Continue Reading

How to install pianobar on Ubuntu

// May 20th, 2011 // 7 Comments » // Code

In this quick tutorial I’ll show you how to install pianobar on ubuntu. Pianobar is a free/open-source, command line client for pandora. With pianobar you can:

- play and manage (create, add more music, delete, rename, …) your stations
- rate played songs and let pandora explain why they have been selected
- show upcoming songs/song history
- configure keybindings
- last.fm scrobbling support (external application)
- proxy support for listeners outside the USA

Continue Reading

Change ExtJs EditorGridPanel row color after edit

// May 19th, 2011 // 2 Comments » // Code, Featured

By adding an afteredit listener to your editor grid you’ll be able to change the row color on the fly, right after
the cell has been changed so users will be able to tell which records have been changed. I’ve added this instead of the little red tickbox since it is easier for the user to see and it just looks better.
Just in case this would conflict with the little red icon, I also went ahead and removed it with my custom.css file (shown below).

Continue Reading