SELECT eggs (*) AS ingredients
FROM Refrigerator
GROUP BY NO.dozen
INSERT INTO my_fryingpan (eggs1, butter1)
UPDATE my_table SET toast = ‘lightly browned’
INSERT hole INTO toast
MERGE eggs INTO toast
USING ( SELECT Eggs, Toast)
CREATE Breakfast eggy_toast
DELETE FROM my_table
WHERE plate = ‘N’

***Warning – Geek Post Ahead.***

In the interest of being difficult, cheap, and looking for adventure we are choosing to run IIS and Tomcat (or for that matter other web servers) on the same physical box. This is a piece of cake if you want to use multiple ports. We feel that is a clumsy solution and sought an alternative. We are using port 80 for both IIS and tomcat by assigning multiple IP addresses to the box and configuring each web server to only listen to one IP address.

1.Assign multiple IP addresses to NIC and create DNS entries
http://www.windowsnetworking.com/articles_tutorials/multiipa.html
2. Disable IIS Connection Pooling
cd c:\inetpub\adminscripts
cscript adsutil.vbs set w3svc/disablesocketpooling true
http://techrepublic.com.com/5100-10879_11-5841376.html
3.Set IIS to listen to specific IP address
IIS Administrator.
Right Click on Website
Click Properties
Website Tab
Specify desired IP address
4. Restart IIS
5. Configure Tomcat to listen to a specific IP address
Edit conf/server.xml
Add/change the address attribute of the connector to <connector … address=”123.45.67.89″ …>

If you have multiple sites running on IIS, even if they are stopped, you need to change their IP assignments to only your desired IP. This tripped us up for a while.

Enjoy!

***Warning Geek Post ahead. Primarily intended for Google and the other poor souls who are going through the (cough) I just went through!***

I need to have SSL for both IIS and Tomcat on the same physical server but running on different ports. Two techs at Thawte said it couldn’t be done without purchasing a separate certificate. I disagreed. Google and random shots in the dark got it working.

How to:

Export Cert from IIS as a .pfx file

Add the Certificate Snap-in

1. On the computer containing the certificate you want, select Start, then Run, and then type mmc to open the Microsoft Management Console.
2. On the Console menu, click Add/Remove Snap-in…
3. Click Add button. This will open the Add Standalone Snap-in box.
4. Select Certificates from the list and then click Add.
5. Select Computer account and then click Next.
6. Select Local computer and click Finished.
7.Click Close on the Add Standalone Snap-in box.
8.Click OK on the Add/Remove Snap-in box.

Export the certificate from IIS 5

1. Under the Tree tab in the Microsoft Management Console expand Certificates.
2. Select the Personal folder and then the certificate you want to export.
3. On the Action menu select All Tasks>Export…
4. Click Next.
5. Select Yes, export the private key and click Next.
6. Select Personal Information Exchange – PKCS #12 (.PFX) and then click Next.
7. Enter the password you used when you created the certificate and click Next. This will create a .pfx file.

Point Tomcat to the new Cert

1. Open %TOMCAT_HOME/conf/server.xml in XML or text editor
2. Uncomment the SSL Connector is not already.
3. Add the folloing attributes:
keystoreFile=”c:\PATH TO CERT.pfx” keystorePass=”PASSWORD HERE”
keystoreType=”PKCS12″

Restart Tomcat. Point browser to https://localhost:8443. If it doesn’t load look in the log files to identify the problem.

This solution is simple. I don’t know why it isn’t better documented. Most of the resources I found had me using OpenSSL to convert the cert to .p12 or .pem files. I couldn’t get those working. I started working backwards and just tried using the .pfx file and it worked. Make note the type attribute is keystoreType. One piece of documentation called it something else. That didn’t help my situation. This works with Tomcat 5.5.9. I don’t know about other versions.

Just installed the latest version of MySQL(4.1.12) and got this error: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client when trying ot connect from phpMyAdmin.

I did some hunting(google) and found the solution. The 4.1 line of MySQL uses a new password hashing algorithm. PHP hasn’t started supporting it yet. The solution is to set the password using the old method. Thankfully this is really simple.

1. Login as root to mysql at the command prompt (in windows XP sp2 select from menu start->programs->mysql->mysql command line)
2. create new account for example ‘zoooz:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost;
3. set password in old format:
mysql> SET PASSWORD FOR root@localhost = OLD_PASSWORD(’mypass’);
4. Change the my.ini file to create password using the old method by default
#Use old password encryption method (needed for 4.0 and older clients).
old_passwords

In the interest of full disclosure I found the solution over here and here.

I just got back from a confernece out in Baltimore. We are planning on rolling out uPortal in the fall. It ia a pretty cool Open Source portal developed by higher ed for higher ed.

Here are some pictures of the 220 some people at the conference:

I forgot my camera so all I got were some pics from my new camera phone. -)