How To: Fix Nick Berlette’s excellent Redirect Plugin for WordPress 2.6 and higher

The static pages (like Store) are working again.  I’ve had to fix the redirect plugin by Nick Berlette.  If you want it to work with your modern WordPress blog (2.6 or higher) you just need to change a tiny bit.
Remove this:

require_once($_SERVER['DOCUMENT_ROOT'] . '/wp-config.php');

Replace with:

$root = dirname(dirname(dirname(dirname(__FILE__))));

if (file_exists($root.'/wp-load.php')) {
    require_once($root.'/wp-load.php');
} else {
    require_once($root.'/wp-config.php');
}

It should work fine now 🙂

Share Button

Free Sybase Power Designer 15 Viewer!

If you ever receive a Sybase Power Designer file (such as the pdm file from Jeff Tallman) but you don’t want to either purchase or install the full blown Power Designer, then I have an answer for you.  It is the Power Designer Viewer from Sybase.

While it is free, you have to fill out a form to get access to the download.  Sybase Sales will likely call you regarding purchasing a full blown version of Power Designer.  If you’re not interested in purchasing it, just tell them – Sybase Sales People are generally very nice folk. 🙂

Share Button

Get your Sybase ASE 15.5 MDA table posters! Straight from Sybase’s Jeff Tallman

I asked Jeff Tallman if I could redistribute his excellent MDA posters for Sybase’s ASE 15.5 database server.  He said yes so …  here they are in both Adobe PDF and Sybase PowerDesigner PDM formats!

Jeff Tallman also provided us with the MDA posters for Sybase 15.0.3 last year.

Share Button

Did you write an article for ISUG’s Technical Journal and either haven’t been paid or refused payment?

International Sybase User Group

For those of you that don’t know, I have written several articles for the ISUG Technical Journal.  I’ve been paid for one and refused payment on the others.  Are there other authors that haven’t been paid for one reason or another?

This is not meant as a dig at ISUG but simply determining if I’m the only one or if there are others.

Share Button

Get it here! Perl DBD::Sybase 1.09 for Active State Perl 5.10 on Windows XP/Vista/7 32bit

Assuming that you installed Sybase OpenClient 15.5 from the 15.5 PC Client:

Install ActiveState Perl from http://www.activestate.com (free) and install DBI if it isn’t already installed.  It should be but you never know…

  1. Start -> ActiveState Perl -> Perl Package Manager
  2. install DBI
  3. exit

Now, the easy part.  Install the DBD::Sybase 1.09 PPM:

  1. download DBD::Sybase 1.09 PPM
  2. extract zip file to temporary directory (e.g. c:\test)
  3. Start -> Run -> cmd.exe (as Administrator if Vista or Windows 7)
  4. cd \test
  5. ppm install DBD-Sybase.ppd
  6. exit

That’s it :)

Sybase
Share Button

How to: Installing VMware ESXi 4 on a 6 year old cheap motherboard

I’ve been trying to get VMware ESXi 4 on my old MSI MS-7388 motherboard for a long time. No matter what I tried, neither the SATA controller on the motherboard or the add on SATA controller would be recognized.

Install VMware ESXi 4.0 on an unsupported motherboard (SATA controller must support AHCI):

  1. make sure the SATA controller(s) is set to AHCI in the computer’s BIOS
  2. download VMware ESXi 4 iso
  3. burn the iso to either a cdrom or a USB thumb drive (512mb minimum) using unetbootin
  4. boot the computer into VMware ESXi
  5. Before you’re prompted to hit Enter to begin, hit ALT-F1 which will get you to a console screen without a prompt
  6. Type “unsupported” followed by Enter
  7. When prompted for a password, just hit Enter
  8. Type “vmkload_mod ahci” followed by Enter.  This will load in the driver for just about any AHCI compliant SATA controller
  9. Hit ALT-F2 to finish the installation

At this point VMware ESXi 4.0 will be installed but it won’t start when you reboot.  This is because VMware won’t load the AHCI driver by default.  So… we will have to tell it to load it automatically.  You will need a Linux Live CD such as Ubuntu.

  1. Boot into Linux
  2. From the desktop you will need to mount the VMware partitions.  In Ubuntu 8.04 and higher, you just need to click on the folders in the drop down menu
  3. Locate oem.tgz on the second VMware partition and overwrite it with this oem.tgz.  It includes a system.map file telling VMware to load the AHCI driver
  4. reboot and boot into VMware ESXi

You should have a fully working VMware ESXi server installed and ready for you to setup virtual machines! 🙂

Share Button

Be warned: International Sybase User Group (ISUG)’s free software for members from Sybase isn’t what you think it is!

Several people have come to me over the past few months regarding the use of the free Sybase software given away as a membership gift by the International Sybase User Group (ISUG)

… plus a package of free Sybase Software valued at over $7000

Unfortunately there is a bit of misunderstanding that Not for Retail software are full versions.

The ISUG will happily entice you to join at the Gold level for the software:

  • New Version! Free Developer Edition of Appeon for PowerBuilder 6.2
  • New Version! Free NFR copy of Sybase PocketBuilder 2.5 (e-shop)
  • New Version! Free NFR copy of WorkSpace Studio 2.1 (e-shop)
  • New Version! Free NFR copy of Sybase DataWindow.NET 2.5 (e-shop)
  • New Version! Free NFR copy of Sybase PowerBuilder Enterprise 11.5 (e-shop)
  • New Version! EAServer 6.2 Developers Edition (e-shop)
  • Free copy of IQ 12.7 Developers Edition (e-shop)
  • ASE 15.0 Evaluation Kit (includes licenses, training materials, etc.)
  • Free Copy of SQL Anywhere Studio for Windows or Linux/UNIX (e-shop)
  • (User Group Presidents Only): Free NFR copy of Sybase PowerDesigner Studio

Let’s take a look at Sybase’s Not for Retail license:

NFR License

Please note that the NFR copies of PowerDesigner, WorkSpace, PowerBuilder, PocketBuilder and DataWindow .NET are for development and personal use, and not for commercial deployment purposes. A copy of the NFR license can be found below. Please note that references to development in the license typically refer to full-scale development. Prototyping (also a form of development) is generally permitted. All questions related to what can and can not be done with the program in question should be directed to your local Sybase sales representative for clarification and not ISUG.

PRODUCT-SPECIFIC LICENSE TERMS

NOT FOR RESALE — DEMONSTRATION VERSION

  1. DEMONSTRATION USE OF PROGRAMS. You may install and use this Program internally in your organization solely for demonstration purposes on a single Machine. You may not use the Program for any development or production purpose, or transfer, assign, sublicense or otherwise convey the Program (or any portion thereof) to another party without Sybase’s prior written consent. You may not copy the Program except that you may either install the Program on your hard disk or make one copy for inactive back-up and archival purposes for your own use.
  2. TERMINATION. You acknowledge and understand that Sybase may terminate this Agreement at any time upon thirty days written notice to you. Upon any termination of this Agreement, you shall cease using the Program and shall destroy all copies of the Program in any form.
  3. WARRANTY DISCLAIMER. This Not for Resale — Demonstration version Program is provided AS IS, without any warranty or support. SYBASE DISCLAIMS ALL WARRANTIES AND CONDITIONS, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION THE IMPLIED WARRANTIES OR CONDITIONS OF MERCHANTABLE QUALITY, NON INFRINGEMENT, AND FITNESS FOR A PARTICULAR PURPOSE.
  4. PRECEDENCE. THE ABOVE TERMS SHALL TAKE PRECEDENCE OVER ANY INCONSISTENT OR CONFLICTING TERMS OF THE ACCOMPANYING SYBASE LICENSE.

Make sense?  Well, for far too many people, it doesn’t.  So let’s just go over what you can and can not do with NFR software:

What you can do:

  • Install and run the software on one and only one computer (your computer)
  • Demonstrate the software
  • Build diagrams, binaries, libraries, etc.

What you can not do:

  • Only you can operate the software
  • Share any diagrams
  • Share binaries or libraries
  • Release any source code generated or even YOUR OWN source code that YOU produce while using the NFR software.  Unfortunately, this also includes taking the source code (or diagrams,etc) and using them with other software outside of a ‘demonstration’.

There isn’t anything distinguishing Not for Retail software from demo software
International Sybase User Group

While ISUG does state that the software is Not for Retail, ISUG stating that the NFR software is valued at over $7,000 is not just a misrepresentation but a bold faced lie bordering on bait and switch.

The purpose of this post is not to direct people away from being ISUG members, you do get a nifty Technical Journal where  article authors are only sometimes paid for their work, but to have people join with their collective eyes open.

Share Button