Bugzilla 4 Installation on Ubuntu Linux Server 12.04

As the lead software engineer for a small software house, I often have to execute sysadmin tasks. One of them was to set up a bug-issue tracker in order to improve software quality and of course make the lives of the team members easier.

The one-and-only bug-issue tracker out there in my not-so-humble opinion is Bugzilla. It’s simplistic and straight to the point as well as developer friendly and open-source. So the task was narrowed down to

“Installing Bugzilla 4 on an Ubuntu Linux Server 12.04”

It may sound as a simple task, but the procedure contains some common pitfalls that are quite frustrating especially for a non sysadmin.

Continue reading Bugzilla 4 Installation on Ubuntu Linux Server 12.04

bash scripting

I am not a scripting expert, I have to admit that. I am not a sysadmin either. But I think that every developer has to possess wider knowledge about the tools and the platforms he uses.

At least for me, some basic – intermediate knowledge makes me more productive, has saved the day in the past and also makes my life easier.

For example, the power of Linux is that you can write scripts and schedule them with Cron to do a lot of things that is considered to be “dull-programming-stuff”. Let’s start with backups.

Or scheduling automatic backups for things that matter and are also more tricky to perform than simple file backups.

Or also monitoring website up-times and logging the results.

Continue reading bash scripting

Thoughts on Parallelization

One of these days, as I was revisiting my early high school memories from notebooks, books, love-letters etc, I stumbled upon this simple but also tricky problem:

“One pump can fill up a tank with petrol in 25 minutes.

 Another tank can fill up the same tank with petrol in 15 minutes.

 If we combine both pumps together, how much time is needed for the tank to be filled?”

You can try solving it on your own, before scrolling to the answer. Don’t spoil it so quickly!

Continue reading Thoughts on Parallelization

Connect WEKA to MySQL

I am attending a Data Mining class here in London and hopefully I am quite interested in the field and I like it a lot.

Since I started my own research on the topic too, and I have tons of commercial data in the databases I administer for playing around, I found a very nice, free and open source tool (Can it get any better?) for the job, WEKA.
(Waikato Environment for Knowledge Analysis)

It is developed at the University of Waikato, New Zealand. Weka is free software available under the GNU General Public License.

One of the nice things of the software is that it uses JDBC (Java Database Connectivity), so you can connect to any database that supplies you with a JDBC driver. Also there is a JDBC to ODBC bridge driver, in order to connect to ODBC supported databases. So to sum things up, you can connect to almost every decent database management system.

Anyway, in theory it works really well, but there is a grey zone on how to practically connect to a database when using WEKA.

Continue reading Connect WEKA to MySQL

Oracle Database

I have been using Oracle DB as a client, sending basic queries and doing basic DB work with the Oracle Application Express Web Interface.

This week, I installed and configured Oracle Enterprise Edition 12g on a Windows 2008 server cloud machine as well as Oracle Application Express 10g locally on my laptop.

Continue reading Oracle Database

University Firewalls and Proxies – FIXED

Yeap, I now have fully functional sensor-free internet and it wasn’t such a complicated procedure in the end.

The only thing I needed was a linux webserver that I could track its IP Address, (using a dynDNS service or a static IP), squid proxy server software running on the webserver, a SSH reliable client (I use PUTTY) if you are running on Windows. If on Linux, you’re in luck, SSH client functionality comes out-of-the-box.

How did I do it? Implemented, not academic? Keep reading.

Continue reading University Firewalls and Proxies – FIXED

University Firewalls and Proxies

I really have a problem with my University Internet Connection. It is very fast and reliable etc…

BUT

I think the whole university intranet firewall isn’t properly configured. Many times, while I am working, I simply cannot access websites that use SSL (the https thing). Not even Google search.

Continue reading University Firewalls and Proxies

re-switched from Windows to Linux

Now that I live in England and I only have my laptop computer at the moment, I decided to re-switch from Windows 7 to Linux.

Yeah, it’s a re-switch, as I have done it in the past, but I had enough headaches trying to tweak and hack around to make all of my devices just compatible.

Continue reading re-switched from Windows to Linux