Vmware Virtual Appliance

This virtual appliance comes pre-configured with our enhanced SQL-Ledger. Follow these instructions to get up and running:


  1. This virtual appliance has been built using FreeBSD 6.4. You do not need to know or install FreeBSD to use it.
  2. Root password: none
  3. IP Address: Login to appliance from console using root (without password) and issue ‘ifconfig’ to find the appliance IP address.
  4. Using your browser visit http://appliance.ip-address/. Here you will find links to sql-ledger, sql-ledger admin and phpPgAdmin.
  5. There is no password for sql-ledger admin screen. (You can set password after login)
  6. Create your datasets using ‘sql-ledger’ postgres user. This user does not require any password.

Detailed Instructions

  1. Download virtual appliance from url in your order confirmation email. On Linux use tar xjf FreeBSD-0.x.tar.bz2 to unpack the archive. On MS Windows, use 7zip.
  2. Download and install vmware player for your operating system.
  3. Open virtual appliance in vmware player.

  4. Login to virtual appliance as ‘root’ and without any password.
  5. Use ‘ifconfig’ to find the appliance IP address.

  6. Using your browser visit http://appliance.ip-address/. You will find links to SQL-Ledger and phpPgAdmin screen on this page.

Upgrading SQL-Ledger/Ledger123

To upgrade sql-ledger/ledger123 installation on your virtual appliance follow these steps:

  1. Login to virtual appliance using ssh, putty or vmware console as root. By default there is no password for root.

  2. cd /usr/local/www/data/ledger123/
    git pull

Network Settings

Virtual appliance is configured to use NAT/DHCP which only allows the host computer to access it through the assigned IP.

If you want to allow others users on the network to access the virtual machine follow these steps (assuming your local network is

  1. Login as root to virtual appliance using console, ssh or putty.
  2. Add following lines at the end of /etc/rc.conf

    ifconfig_lnc0="inet netmask"
    defaultrounter="" # Your network gateway

  3. Change player’s network setting from ‘NAT’ to ‘Bridged’ using ‘Ethernet’ combo box.
  4. Reboot your virtual machine.

You should be able to connect to your virtual appliance using in your browser. If you cannot, visit this page to trouble shoot your problem.