Saturday Aug 09, 2008

Playing with Eventum on OpenSolaris, part 1

Eventum is a nice issue tracker from the folks at MySQL which you can set up on OpenSolaris in a matter of minutes.

I attended some classes for Sun SEs last week which covered dtrace, web stack, and other fun stuff.  I thought at the time how useful these tricks would have been at a former job where our team was using Eventum.  I wanted to automate the creation of issues for some recurring work, but didn't want to spend the time to wade through the Eventum source code to see what needed to be added to the database.  I'll try again with some new dtrace skills, but first I need a working Eventum testbed.

(Preamble: I started with a fresh install of the OpenSolaris 2008.05 iso image on my iMac using VirtualBox.)

Eventum needs an AMP stack for its run-time environment. These six commands will add AMP to a shiny new OpenSolaris 2008.05 installation:

  
  pfexec pkg refresh 
  pfexec pkg install amp 
  pfexec svccfg import /var/svc/manifest/network/http-apache22.xml 
  pfexec svcadm enable network/http:apache22 
  pfexec svccfg import /var/svc/manifest/application/database/mysql.xml
  pfexec svcadm enable application/database/mysql 
  

Next, add a new MySQL user for Eventum to use:

    
  pfexec /usr/mysql/bin/mysql –u root 
  mysql> GRANT ALL PRIVILEGES ON \*.\* TO 'eventum'@'localhost' 
       IDENTIFIED BY 'your-eventum-db-password' WITH GRANT OPTION; 
  mysql><CTRL>-d 
  

Next, download and install Eventum. Point your browser to http://dev.mysql.com/downloads/other/eventum/ and download the latest level (currently eventum-2.1.1) to your Desktop. Unpack it under the directory tree served by Apache:

    
  cd /var/apache2/2.2/htdocs/ 
  pfexec gtar -xzf ~/Desktop/eventum-2.1.1.tar.gz 
  pfexec mv eventum-2.2.1 eventum
  

Point your browser to http://127.0.0.1/eventum/ and fill out a form to finish the Eventum installation. Here are the changes you need to make on the installation form:

Field Value
MySQL Server Hostname localhost
MySQL Database eventum
Create Database checkbox checked
MySQL Username eventum
MySQL Password your-eventum-db-password
Sender your-user-id@localhost
Hostname localhost
Port 25

Press the Start Installation button.

On the success page, note the initial administrator Email address and Password to use to log in.

Now hide Eventum's setup directory to finish installation:

 pfexec chmod 0700 /var/apache2/2.2/htdocs/eventum/setup/
 

Next we'll disable the initial administrator user id and add a new one.  Point your browser to http://127.0.0.1/eventum/ again, log in with the initial administrator user/pass, follow the Administration link at the top, then follow the Manage Users link and add yourself as an administrator. Next, disable the special default admin user/pass by checking the box next to “Admin User” , setting the status drop-down to Inactive, and pressing the “Update Status” button. Logout, then confirm you can log in with your new id but not with the default admin id. Add user ids for the other folks on your team and you're ready to go.

References:

  1. http://dlc.sun.com/osol/docs/content/OSDEV/gentextid-207.html
  2. http://eventum.mysql.org/
About

Jeff Trawick

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today