Ziptie with MySQL or PostgreSQL

Introduction
It is possible to replace derby database, ziptie’s original database, with MySQL or PostgreSQL. For me derby is enough to handle ziptie. Small resource, based on java and sql standard, easy backup (just copy the directory) and of course integrated with ziptie from beginning.But if you already have MySQL or PostgreSQL, it is good idea to integrate it to the existing database.

Quick Howto
Here are some steps to be done i can collect for you:

  1. MySQL as Ziptie Database
    • The supported version is 5.1+
    • Locate the dbutil.pl file, in my windows default installation it is in “C:\Program Files\ZipTie Server
    • Initialize Ziptie’s Database using “dbutil.pl –db=mysql reset
    • If you run dbutil.pl without paramater, it will print all available parameters/options
    • It is possible to use MySQL database in different server/ip address
    • It is possible to use non ‘root‘ user but we need to run the database and tables creation manually. If you open dbutil.pl, you will find this option is possible.
    • If you use different server or user or database name, don’t forget to change “osgi-config/bitronix-jta/btm-config.mysql.properties” file and “osgi-config/quartz/quartz.mysql.properties” file.

Read the rest of this entry »

JFFNMS Open Source Network Monitoring System

Description

JFFNMS stands for Just For Fun Network Monitoring System. Yes it will make network administrator has fun time with their network :). JFFNMS is developed by Javier Szyszlican. What it makes a special NMS software is a lot of feature for fault management and performance management.

Here is the feature i can highlight from JFFNMS website:

  • Multi platform
    It is Network Monitoring Software for Windows, Linux, Unix, possibly Mac OS
  • Auto Discovery
    You don’t need to specify host or interfaces one by one to monitor as it uses SNMP
  • Syslog Logging
  • TACACS+ for Authenticating and Accounting
  • Modular and Extensible
  • Configurable Event Type and Severity Level
  • Integration with other software, like smoke ping, nmap, fping, ntp, msyslog, syslogd
  • Web GUI
  • Map/Sub Map
  • Reporting, from traffic, utiliation, error, round trip and a lot more
  • Support a lot of MIBs by Cisco, Livingstone, Windows, HP Insight, IIS etc
  • Secure Monitoring using HTTPS and or SSH

Quick Howto Read the rest of this entry »

Wireshark - Open Source Protocol Analyzer

Description

Started in 1998 by Gerald Combs, this protocol analyzer was named Ethereal. At 2006 the name changed to Wireshark. Follow this link to now why Gerald Combs changed Ethereal to Wireshark.

After 10 years of development, by network expert all around the world, and still continuing, it is the de facto protocol analyzer now, with almost 1000 protocols supported. IP based protocol, cellular protocol - GTP, BSSAP - and many others.

Here is the features supported by Wireshark:

  • Deep inspection of hundreds of protocols, with more being added all the time
  • Live capture and off line analysis
  • Standard three-pane packet browser
  • Multi-platform: Runs on Windows, Linux, Mac OS X, Solaris, FreeBSD, NetBSD, and many others
  • Captured network data can be browsed via a GUI, or via the TTY-mode TShark utility
  • The most powerful display filters in the industry
  • Rich VoIP analysis

Read the rest of this entry »