Macro Rant

I have become of the opinion that Sun Microsystems is an AWESOME company with AWESOME products. So what’s the problem? CONVOLUTION!

They have a ton of technologies, a ton of software, and a ton of great products with a ton of really creative names. This gets confusing! Making your way through their marketing talk up on each of their products/technologies and actually figuring out what they are, what they do, and how they work is a chore to say the least. I am of the belief that they are limiting their customer base because of this.

Quick example. A few weeks ago I finally decided to look into GlassFish. Sure there’s plenty of information for people who are already very familiar with Sun offerings and Java. However I am a PHP/MySQL kind of guy. I haven’t programmed in Java since my sophomore year of college! I want to know how to use GlassFish to help me achieve my goals without reading through 100 pages of white papers and sifting through marketing balony. Eventually I got the gist of it but I was very dedicated to sifting through the information and reading documentation. Most developers in my position would have said, “Screw it. I’ll stay with what I have.”, several days ago.

The same can be said for many of Sun’s products. Which is a tragedy because after reviewing a lot of their products I can see that they have a ton to offer the IT world.

Wake up SUN! Show the world what you have!

rdylina Uncategorized glass fish, glassfish, java, products, sun, sun microsystems

Well I was reviewing the table partitioning feature in the now GA MySQL 5.1 and to my dismay you may neither have a foreign key in a partitioned table nor can you have a foreign key in another table that refers to a key in a partitioned table. How lame is that! Good lord! One of the essential features of a relational database is that it be RELATIONAL. So now we’re left out in the cold if we want MySQL to enforce referential integrity with it’s existing provisions and use table partitioning at the same time.

I have already ran a scenario in my head to work around this problem. It’s should be as simple as setting up triggers to enforce database relations that should be either added, removed, or denied based on the relationship. Definitely NOT the preferred way to do this but another way to accomplish the same, without handling it in the application logic, escapes me at the moment.

rdylina Uncategorized MySQL 5.1 relational database foreign key table partitioning

I came across a stumbling block the other day that I thought I would share, since the information is not readily available via a Google search.

Problem:

1. You have a 64-bit linux operating system (CentOS 5.2 x86_64 in my case)
2. You’d like to use XAMPP (which currently doesn’t have a 64-bit compiled version)

If you don’t have the right fix applied or the right libraries (32-bit) installed XAMPP will fail to start

[root@localhost lampp]# /opt/lampp/lampp start
XAMPP is currently only availably as 32 bit application. Please use a 32 bit compatibility library for your system.

The solution here is two part, some people in Ubuntu have had success just installing the 386 compatibility library with apt-get and the script is reportedly functioning as intended, aka starting up the various daemons.

However some of us, aka CentOS5.2, even when the compatibility libraries are installed

yum install glibc*

or

`sudo apt-get install ia32-libs`

if you’re in Ubuntu per Tim

it will still report that it can’t run on a 64-bit operating system.  Well this is just plain false. The built-in check in the lampp script is not sufficient to establish whether or not the 32-bit daemons will function or not. My solution? Well, being very sure that all the necessary dependencies are present, I just commented out the check.

nano /opt/lampp/lampp # I use nano, but you can use the editor of your choice

and we’re off and running.

[root@localhost lampp]# uname -a
Linux localhost.localdomain 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 11:57:43 EST 2008 x86_64 x86_64 x86_64 GNU/Linux
[root@localhost lampp]# lampp start
Starting XAMPP for Linux 1.7…
XAMPP: Starting Apache with SSL (and PHP5)…
XMAPP: Starting MySQL…
XAMPP: Starting ProFTPD…
XAMPP for Linux started.
[root@localhost lampp]#

rdylina Linux, Unix 32bit, 64bit, centos, linux, ubuntu, xampp