28/02/2008

iloog-8.02 is out!

A new version of iloog (iloog-8.02) is finally ready after 4 months since our last release (iloog-7.10). This new version does not bring tons of new features but it’s much more polished and robust than the previous one and has quite a few bugs squashed.

Some of the changes include:

  • Patched 2.6.22 kernel against the recent local root exploit
  • QT4 support! QT programmers will certainly like this new addition
  • Removed some bloated programs and replaced them with some lighter ones (eg graveman instead of K3B)
  • Added another IDE, glade!
  • Added Pascal compiler (gpc)
  • Support for new revision control software like git and mercurial
  • Added support for via and sis graphics drivers in Xorg
  • Some iloog tools got a dialog interface
  • Added some programs by greek developers like: indywiki, jIPFire, pluto, pysmssend and QGRUBEditor
  • New Tango icons for the desktop
  • Some minor changes to Fluxbox’s menu and theme

Of course there are also the usual updates to all the included programs to their most recent stable versions plus the addition of more than 50 new packages.
We’ve also written down some crude information on iloog’s wiki about the process of “installing” iloog to a hard disk. The process is _NOT_ automatic and whoever tries it must be very careful before executing anything. Read more at the wiki: Install iloog

I would like to thank comzeradd, Fuzz and Ulv and all the other people who helped to test iloog-8.02. A special thanks goes again to cyberarch.gr for all their help with graphics (they prepared the new iloog website too!) 🙂

Some screenshots:
iloog-8.02 console

iloog-8.02 desktop

iloog-8.02 qtiplot

You can find more screenshots of iloog-8.02 at ILUG’s flickr gallery: iloog-8.02 at flickr

Download links at iloog’s site: www.ilug.gr/iloog/

A slightly modified version of iloog-8.02 is also included in the greek LinuxFormat’s DVD on Issue 20 (March-April 2008) which will be out on 04 March 2008. Go and buy it!

* Filed by kargig at 21:55 under Gentoo,Linux
* 2 Comments | 6,634 views

17/02/2008

SIP Express router, mysql and utf8

Description:
There’s a small problem when using SIP Express Router (net-misc/ser on Gentoo) with mysql support and your mysql server uses utf8 as a default character set (gentoo’s latest versions use utf8 by default).

The problem:
One of ser’s scripts (ser_mysql.sh) can’t handle utf8 tables.
# ser_mysql.sh create
MySql password for root:
Domain (realm) for the default user 'admin': foobar
creating database ser ...
ERROR 1071 (42000) at line 100: Specified key was too long; max key length is 1000 bytes

Solution 1 (remove utf8):
Change the character set to latin1.
The specified error can easily be “fixed” by editing /usr/sbin/ser_mysql.sh. Inside that script you will find a line like this (line 38):
TABLE_TYPE="TYPE=MyISAM"

replace it with:

TABLE_TYPE="TYPE=MyISAM,DEFAULT CHARACTER SET latin1"

The result:
# ser_mysql.sh create
MySql password for root:
Domain (realm) for the default user 'admin': foobar
creating database ser ...

Solution 2 (reduce some column sizes):
The following solution makes the script run but I have not personally tested if ser STILL works ok after the changes. Feel free to experiment and comment back on this:
# sed -i 's|domain varchar(128|domain varchar(100|g' /usr/sbin/ser_mysql.sh
# sed -i 's|contact varchar(255|contact varchar(128|g' /usr/sbin/ser_mysql.sh

* Filed by kargig at 22:32 under Gentoo,Linux,VoIP
* 1 Comment | 6,281 views