fredag aug 15, 2008

No Rest For The Wicked

The wicked fast open source code browser OpenGrok has been updated like crazy lately. First of all the team of Trond, Jorgen, and Knut has set up a Hudson at the famous Norbye site, and fixed a lot of bugs and style for OpenGrok. Myself have made some contribution by adding the ability to run OpenGrok as a JMX agent, and also a TrayIcon based client to connect to it, and by the way adding some bugs as well ;)

To start using the JMX agent, you currently have to check out the source code, but hopefully it will be available soon in the 0.7 release.

Here is a short howto...first you have to set up opengrok and create a configuration file, then start the agent:

java -cp opengrok.jar org.opensolaris.opengrok.management.OGAgent
The agent will now start running indexing, by default every 2 mins. By starting the system tray client as well:
java -cp opengrok.jar org.opensolaris.opengrok.management.client.OpengrokTrayApp
An OG icon will show up in your system tray, where it will mainly be black when everything is ok, red if you are not connected to the agent, and yellow if the opengrok source repository has been updated. Right click to change settings if needed to connect, and if yellow click notifications to see what files have been updated in the indexing of opengrok.

This is just a first implemented task for the client-agent app, we hope to add more features shortly

mandag jun 16, 2008

Delivering The Goods

Mysql Connector/J (5.1.5, JDBC Driver) is delivered to the OpenSolaris source as part of the Webstack project, and should show up in build 92. The JDBC driver will be located at

/usr/mysql/connectors/jdbc/5.1
So check out OpenSolaris at build 92 ;)

tirsdag jun 10, 2008

Rock Hard, Ride Free

Got back from a looong holiday yesterday, which ended with a very good concert with Judas Priest. Here you can watch a video from the concert. As they are one of my musical favorites from ...eh ... 25 years ago, it was great to see them still rocking :)

tirsdag mai 06, 2008

Cluster One

Check out the new OpenSolaris page and download the new OpenSolaris binary distribution.

You can easily download the integrated MySQL packages by using the Package Manager GUI or simply

pkg install SUNWmysql5

As part of the MySQL packages the MySQL Cluster (NDB) storage engine and management binaries are included. You can use the general documentation available at MySQL.comfor setting up a Cluster . Then you should be ready for high availability MySQL.

mandag apr 28, 2008

Easy Living

New version (10.4.1) of JavaDB is out. Added features are asynchronous replication, table functions and JMX monitoring of the DB instance. Performance enhancements and some additional features, check it out here

tirsdag mar 25, 2008

When I'm Sixty Four

64 bit MySQL (5.0) is now integrated into OpenSolaris. It will be available in build 87. 64 bit should work with 32 bit generated data-files and vice versa, although MySQL recommends you to do a full dump and reload, at least in production. To enable the 64 bit server in SMF do:

% svcadm disable mysql:version_50
% svccfg                                               
svc:> select mysql:version_50
svc:/application/database/mysql:version_50> setprop mysql/enable_64bit=true
svc:/application/database/mysql:version_50> quit
% svcadm refresh mysql:version_50
% svcadm enable mysql:version_50
Also check out the latest Netbeans 6.1 beta with integrated MySQL support.

fredag feb 15, 2008

Let's Get It Up

Some tips around MySQL and SMF on OpenSolaris. You can enable the MySQL server by starting it through svcadm

% svcadm enable mysql
Although for current builds since the integration on build 79, you need to do this manual stuff first:
% su -
% cd /var
% mkdir mysql
% /usr/sbin/groupadd mysql
% /usr/sbin/useradd -g mysql -d /var/mysql mysql
% chown mysql:mysql mysql

So if your MySQL service is going into maintenance:
% svcs | grep mysql
maintenance    11:03:45 svc:/application/database/mysql:version_50
You could find out more what happened by doing:
% svcs -x
svc:/application/database/mysql:version_50 (MySQL RDBMS)
 State: maintenance since February 15, 2008  2:25:49 PM CET
Reason: Restarting too quickly.
   See: http://sun.com/msg/SMF-8000-L5
   See: MySQL 5.0.45(1)
   See: http://dev.mysql.com/docs
   See: /var/svc/log/application-database-mysql:version_50.log
Impact: This service is not running.
This will lead you to the above log-file, where you could get some useful information.

Another tip is that you can change where your datafiles should be, by doing:

% svcadm disable mysql:version_50
% svccfg                                               
svc:> select mysql:version_50
svc:/application/database/mysql:version_50> setprop mysql/data=/export/home/tmp/mysql/data
svc:/application/database/mysql:version_50> quit
% svcadm refresh mysql:version_50
% svcadm enable mysql:version_50
Remember that the directory specified need to be owned by mysql user and group!

Also you can read more about the MySQL integration and SMF at Ritu's blog

mandag feb 11, 2008

Have A Drink On Me

Today I have been at a student day at the Trondheim university, NTNU called ITDagen. The Sun place draw a lot of attention, mostly because we were giving away coffee, but also we were lucky to demo the cool Sun SPOTs.

We also gave away the new Solaris Developer Express 01/08 DVD and a lot of them was really interested. This release also includes the Webstack, so hopefully we can get some users there :)

A lot of students had a lot of interest in Sun technologies, and specially we tried to convince them to use NetBeans instead of certain other products they were using..

mandag feb 04, 2008

Get It Hot

PostgreSQL version 8.3 has been released today. You can find the Solaris bits here. Among new features is the Heap Only Tuple (HOT), which should give substantial throughput improvements.

søndag feb 03, 2008

The Sign

Time to present more bands featuring friends. Watt is also a rock'n'roll band based in Trondheim. Their first album Those Days came last year, and we are hoping for new stuff this year.

onsdag jan 30, 2008

The Thing That Should Not Be

All things come to an end, and so do old software. By removing the older version of the EOL version 4.0 of MySQL from OpenSolaris, we encourage users to go on to 5.0. From build 79 MySQL 5.0 is now integrated into OpenSolaris. Btw, MySQL 4.0 will not go away unless the ARC case is accepted of course.

søndag jan 27, 2008

Dirty Looks

My friends at The Boogiemen Inc has released a CD single called Dirty Looks. The band is inspired by everything from old blues to the 70s hard rock scene. Go check out the Dirty Looks video at YouTube.

fredag jan 25, 2008

Escape

Using SecurityManager with Java and Socket's is not always as easy as it first seems. You would think that when creating a DatagramChannel and operating on that (ie send and receive), you will get the SecurityException if you don't have the right permissions. But no, you have in fact to an explicit check for the permissions you need like this:

     SecurityManager security = System.getSecurityManager();
     if (security != null) {
         security.checkXXX(argument,  . . . );
     }
 

And it is the calling Thread that should be checked before doing a DatagramChannel.receive call as this call will hang forever if it doesn't have the right permissions.

torsdag jan 24, 2008

Hit The Lights

Hi, I work in the Database Technology Group at Sun Microsystems, and I am located in Trondheim, Norway. I'm currently working with HADB. I'm also doing some work on the OpenSolaris Webstack project with integrating MySQL into OpenSolaris.