April 16, 2003 David A. Del Col spent 10 years as a systems engineer in broadcasting electronics and 9 years in IT doing helpdesk support, client/server implementations, and configuration management. He currently works for a major insurance company in Canada. He is a devoted OS/2 user since version 1.3, and now uses eComstation V1.03. If you have a comment about the content of this article, please feel free to vent in the OS/2 eZine discussion forums. There is also a Printer Friendly version of this page. |
|
Application Servers for eComstation and OS/2
I thought I would share my exploration into Application Servers for OS/2 and
eComstation.
| |||
Requirements
With these, I've narrowed my choices to Communigate Pro, Caravan and Apache 2. I could select any of the three technologies, however, I had to make a decision, do I want to learn yet another scripting language or do I want to be up and running? OK, I can tolerate a some minor scripting language variations, however I want to be up and running. All three are supported on IBM OS/2 and eComstation plus Linux and Windows. In our current situation, we are fortunate that these vendors have presented these offerings and should thank the developers for their hard work. Open standards made the web what it is today, CGI and other scripting interfaces can be useful, Caravan offers a Plug In method to allow you to run an external program, so as a result, I can interface with REXX to run X10 Automation for OS/2 from Lone Peak Automation. If I have Rexx, then I can use PERL, PHP and other scripting to access or push data, permitting access to MySQL, Postgres SQL and other databases if need be, however I am finding that the internal database is fast enough for my needs. This all opens the door to a considerable base of existing free Perl and PHP code for site development. ODBC access is the gateway of my daily life at my place of work. ODBC can be slow, however with it, I can plug in from any office application and manipulate my data. Postgres SQL provides ODBC access right out of the ZIPFile, Caravan and MySQL and other databases will require exporting data or additional client software as in Oracle NET client and ODBC. Caravan's integrated database is web driven for setup and configuration. Coding samples are clear and workable. MySQL and Postgres SQL have numerous PHP code snippets available and complete web sites such as PHPNuke/PHPWebSite that use MySQL or Postgres SQL as the back end. All three deliver to varying degrees the ability to send messages and they all require additional configuration or modules. PHP mail needs sendmail active and configured on the server if using any canned PHP scripts, in the Linux world this is provided in most default installations. For those developing a black box solution or embedded system, Caravan and all the others could meet your needs depending on scale and expense. The network pipe, hardware, CPU, RAM, and disk will be major factors to consider. CommuniGate Pro has IMAPI support which is unique, however, this is not in my scope of requirements. PrerequisitesMake sure you are running OS/2 Warp 4, Warp Server for e-business, eComstation, or eComServer and OS/2 TCP version 4.1 or better.CaravanInstallation and setup is easy.
Type in the default id and password, change the password, then start developing your tables and pages. CommuniGate ProDownload the CGatePro-OS2-Intel.zip package and install the CommuniGate Pro package.
Proceed with Initial Configuration. Apache 2 for OS/2Download and Unzip the following. Read each read me to setup and configure to meet your system needs. Apache 2.0.45 or another http Web Server of your choice, PHP 4 (current version 4.3.1 or Vincenzo Venuto's), MySQL/2 or Netlabs, Postgres SQL.Comparing the ChoicesThe initial setup of Caravan is easiest, taking just 5 minutes. CommunigatePro took 10-15 and Apache/PHP/MySQL or PGSQL about 30 minutes. The times are based on reading the installation and the speed of the text PII-266 Compaq System.Administration for Caravan and CommuniGate Pro were easiest and most efficient via the web interfaces. Apache had a number of third party tools that enhanced it, I like Serverconfig/2 for configuration and Analog/2 for system log analysis. For a home user the cost is, FREE. For commercial/industrial use please contact the respective vendors for current pricing. Apache, PHP, MySQL and PGSQL are free, and you may even compile your own version. Hey, I forgot InetPowerSever IPS http/ftp/smtp/pop server and Web/2! I just did not schedule enough time. If someone wishes to use IPS or Web/2 instead of Apache. The key is to find the solution that fits your needs. Support and Vendor CommitmentFree has a price. I do not expect support beyond forums and best effort among my peers. However, to ensure future development on the platform, I chose to license a copy and get maintenance. Please go see the vendors sites for current pricing.In all cases, the vendors and developers have shown a commitment to the OS/2 platform. It is now up to "US" the "OS/2 and eComstation" community to use the tools these people have created. It will be interesting to see if we can make use of them to create our own, black box solutions or embedded devices for home or commercial or industrial use, or better yet, full scale implementations. Give vendors your feedback for desired new features and most of all buy maintenance, and upgrades. Please also advise them of any deficiencies, as it will improve the overall application and perception of the product. It is not just a matter of the vendors being committed to the platform of OS/2 or eComstation, it is the community at large. Over the next few weeks, this Home Network Appliance Project will be underway thanks to the research I have done. More postings to the OS/2 community and newsgroups will occur over the next few weeks. Closing RemarksI hope you found the information (or at the very least the links included) useful in further investigation of Application Servers for OS/2. As I develop my Network Appliance Project I would like to share my expereinces."May your experiences be Warped!"
Caravan Vendor Homepage and OS/2 Pages CommuniGate Pro Apache 2.0.45 PHP 4 (current version 4.3.1 or Vincenzo Venuto's) MySQL/2 or Netlabs Postgres SQL Lone Peak x10 Home Automation and Security for OS/2 RDBMS Pages |
|||||
|