I wanted to get my entire server running on open source today. So i have Ubuntu, Apache2, Php, MySql, Apache-Tomcat, and OpenBlueDragon however i was running on Sun's JVM obviously this is not open source. Switching over was relatively painless.

Grabbed the latest openjdk from the ubuntu repository:

sudo apt-get install openjdk-6-jre

Made sure it was installed:

sudo update-java-alternatives -l

Switched ubuntu to use the openjdk instead of sun's:

update-java-alternatives -s java-6-openjdk

Then checked the version i was running:

java -version

Everything looked good, i restarted tomcat and went to my blog (running BlogCFC) and received this ugly error: "Probable fatal error:No fonts found"

This seemed strange, but then like a bone-head i forgot to change my $JAVA_HOME variables to point to the openjdk instead of sun.

Which meant editing my .bashrc file:

sudo nano ~/.bashrc

and changing this:

export JAVA_HOME=/usr/lib/jvm/java-6-sun 

to this:

export JAVA_HOME=/usr/lib/jvm/java-6-openjdk

and finally (incase i ever have to restart the server), change the init.d tomcat script:

sudo nano /etc/init.d/tomcat

to have the same JAVA_HOME:

export JAVA_HOME=/usr/lib/jvm/java-6-openjdk

Restarted tomcat and imagine that, BlogCFC loaded up without the font error.

Lesson learned, change your java virtual machine, change your JAVA_HOME pointers...duh!

except for a few bone-head errors

This could seriously be the greatest programming "forum" to come along in a long time.

The best way i've read it described so far is "Unemployed PHD Deathmatch!" , which is not completely true, but the idea being you get quality answers from a lot of really smart people in their field. And ifs all organically community driven, so that has sometimes a mob or "deathmatch" mentality. In the end i think i has the potential to keep the content solid, helpful, programming information.

stackoverflow.com

I just had one headache after another trying to get this setup. The basics were simple. I got VMWare fusion installed. Installed Windows Server 2003 Enterprise. Added the IIS service. Sat through the insanely long updating process for service pack 2 through the windows update. Installed SQL Server 2005 Enterprise. Mounted all my databases. Successfully connected through the Management Studio. Okay now its up and running and i'm thinking this is great!

Well not exacally, it seems everything i try to connect to the VMWare machine from my host computer ends in something like this:

Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

Well this is not good to say the least!

I googled around a bit and found a couple of quality posts

codeproject and of course microsoft.

I followed both to the "t" but to no avail. I checked the tcp listening port through the client services manager and it swore up and down it was listening on port 1433. I even tried assigning an alias forcing to listen to port 1433 but once again to no avail.

Finally here another microsoft support page i found this little nugget of goodness:

Open a local connection and create a new query with the following:

Use master
Go
Xp_readerrorlog

About halfway down the results listing it says its listening on port 1138! What! i didn't argue, and i pointed my host machine to 1138 and finally success.

It seems odd that everything else would indicate port 1433 as it is the default for EVERY CLIENT.

Triple booting the MacBook has vastly improved since Tiger. I literally brought home a new mac book, installed a 320 Gig harddrive, maxed out the ram (4gigs) and installed Leopard, used bootcamp to install XP and added a partition to the main Leopard partition while it was booted and installed Ubuntu.

Simple and painless... all is well with the cosmos.

This post is pretty straightforward the only thing i did different was to install XP instead of Vista (for reasons i hope are obvious!).

Configuring Ubuntu Hardy Heron on the macbook took a few tweeks, but they are outlined well here.

Today after much headache trying to install Microsoft Project Server 2003 with SQL Server 2005 i sit victorious... though not without the lumps to prove my struggle.

Sadly it seems that Microsoft does not write their SQL Server code with backwards compatibility in mind.

While Project Server 2003 is performing the long and tedious task of building your Project Database it suddenly grinds to a screeching halt with the following:

"Error 25624. Failed to execute SQL String" and "Installation ended prematurely"

It appears will building out the Tables they are adding indexing omitting the "with" expression. This was allowed in 2000 but since 2005 of course they have changed their syntax!

So you, or i as i was had two options one:

Edit the .sql file used to build out the database, add the "with" expressions add noted here. Or two:

Create my project Database by hand using the SQL Management Studio and change the compatibility to SQL 2000 and run the manual DB builder as noted here

I tried both and seem to prefer the latter of the two, but i think both would work just fine.

I ran into other headaches dealing with the SQL Server Logins for the Project Server, but I think those were merely conflicts with previous installation attempts (i had quite a few!!)

And now all is well with the cosmos....