HI SCOTT:

I downloaded the PachydermInstaller-2.1beta3.jar and installed it on my Windows 2003 server. The software works great. The problem I had with creating multiple users has been solved. I can now create users and log in with their IDs to my heart’s content.

I had a couple of initial issues getting the login screen to work properly that were related to MySQL. The web server would not display the login page at all initially. It displayed a 404 error. This is because the table names in MySQL are case-sensitive. The table creation SQL scripts that are provided in the .jar create lowercase table names. However, the Pachyderm software expects uppercase table names for all tables except metadata2 and invitation. Modifying the install SQL scripts to create the correct case table names would give users a smoother installation experience.

Finally, I had two issues that were due to my setup of MySQL and my mail server. The login ID used for root access must be defined as a super user and have rights to the pachyderm database table before running the installer. The second issue was that my mail server on my Windows 2003 server had to have authentication set to anonymous instead of windows login because there are no credentials coming from Pachyderm for login.

I successfully created three presentations under different accounts and was able to publish them. I discovered that using the same account ID from multiple machines can cause errors if both try to publish around the same time. So I created multiple generic user IDs for our Special Collections folks and we are going to have them play with this version.

I currently have all the software set up on development machines for testing. MySQL is running on a separate Solaris x86 server, in its own zfs zone, from the web server and Pachyderm. The installation gui set this up without any problems. Good Job!

Thanks again to you and your team for all of the hard work in making this version of Pachyderm a reality.