The following are my notes on a few sql queries used to convert the schema of a few Drupal tables to wordpress: Resources http://socialcmsbuzz.com/convert-import-a-drupal-6-based-website-to-wordpress-v27-20052009/

Patch files are available for updating Drupal which makes it much easier than the old method of unarchiving .tgz files. Make sure to test this on a clone of your Drupal core files and your database. Login to the Drupal install being upgraded as an admin. This is important because you will need to verify the update after you apply the patch. CD to the webroot on hbfweb17 and create an archive of the core Drupal files:

A recent service call with Remedy for a hotifx resulted in a complete overhaul of how miditer is installed. Midtier Reinstall Remove all instances of the current install: Download and extract the latest midtier. Find and extract the .war file: Remove the .war file and copy this directory into /opt: We now need to reconfigure tomcat to let it know where we moved miditer by creating an app definition (context) xml file:

Replacing TinyMCE with CKEditor and CKFinder. TinyMCEis a popular WYSIWYG editor I used by default on a few sites. However, it’s file/image uploader is very buggy and didn’t work well. CKEditor is more actively developed and has a comparable file/image uploader. CKEditor Install There is a dedicated Drupal module for the CKEditor. However, the recommended method is to use the WYSIWYG module. CKFinder Install Unfortunately, CKFinder integration with CKEditor is not an easy process.

Due to the simple nature of the Mambo DB schema, the migration was pretty straightforward. Here’s the sql used for the conversion which was modified from this post:

Installing the .war file using tomcat. Install tomcat Use yum to install the following packages: Enable the startup service: Configure tomcat We need to set some env variables so tomcat knows where the midtier libs are. Normally, this file is named catalina.sh. But, the rpm package installs it here: /usr/bin/dtomcat5. Add the following after the comments: Install the war file There’s various ways to install a war file. The easiest method is to copy it to the webappstomcat directory.

AD and apache don’t play too well. Make sure you have the following modules installed: mod_ldap mod_authz_ldap The following will allow you to authenticate all members of the Web Group: AuthBasicProvider ldap AuthType Basic Order Allow,Deny Allow From All AuthName “Use your Active Directory account to login” AuthLDAPURL “ldap://xxx.xxx.edu:3268/CN=Users,DC=xxx,DC=edu?sAMAccountName?sub?(objectClass=*)” AuthLDAPBindDN xxx@xxx.edu AuthLDAPBindPassword “xxx” AuthLDAPGroupAttributeIsDN On require ldap-group CN=Engineering - Web Group,CN=Users,DC=xxx,DC=edu </Location> If you would like to authenticate all valid gemini users, replace <kbd>require ldap-group</kbd> with require valid-user.

8 point releases behind, I’ve finally recompiled and installed php on a system running Solaris 10. Modify php.ini

Using the command line ldap tools to browse Active Directory. These were written when protyping a Mac OS X Dashboard Widget that was a Gemini address book. I ditched it in place of querying a webservice on www.gemini.edu. Find all users with a surname that starts with k Find all users by displayname kalawe

How to enable SSL for the system apache2 on Solaris 10. This will not work if you have modified the SVC file. Resource http://74.125.155.132/search?q=cache:vcHg72M9FN4J:www.chenqi.org/blog/archives/2005/07/howto_enable_ap.html+solaris+svc+startssl&cd=2&hl=en&ct=clnk&gl=us&client=safari

Tips on how to deal with certificates created by our Windows certificate server. Our certificate server issues certificates in DER a binary format. However, it’s common for unix software to deal with certificates in PEM a base-64 version of DER. PEM certs are great if you want to copy and past a certificate in a web form, etc. The following are conversions using OpenSSL:

Setting up SSL support for Tomcat, using Apache as a proxy server. Tomcat Configuration /usr/local/tomcat/conf/server.xmlneeds to be modified so Tomcat is aware that it will be proxied over SSH. The last lines were added: Apache Configuration A new virtual host was configured for SSL: