Skip to main content

db.FTSearch != Ubuntu Server

We ran into a db.FTSearch problem with a customer a few years ago.  Full indexed search failed on PDF and DOCX file attachments. For other attachments it worked fine. We were using Ubuntu 10.4 LTS.  Searching through we could only find a few references to db.FTsearch and Linux regarding these two file formats, but all the postings provided no resolution to the issue.  Fortunately, when we moved the database to production on a Windows server, the db.FTsearch for PDFs and DOCX files worked.  At that time, I thought it might have been our Linux server setup done incorrectly.

We recently had the same problem again using a different and newer installation of Ubuntu, 12.04 LTS server.  Further research and many attempts in changing configuration file did not help.  So we switch the server to CentOS as suggested by Bill Malchisky. Using the installation instructions and videos on Youtube from Devin Olsen, we installed CentOS 6.4 and now db.FTSearch works with PDFs and DOCX files. It seems that the FTsearch have issues with the Debian distribution of Linux.  Whether it is implementation of the KeyView filters not working or there is a bug I do not know.  This is beyond my Linux skills to track down.

Though I like Ubuntu alot, we will be switching all my servers to CentOS.  Lesson learned, if you need to perform db.FTSearch on databases that includes PDF or DOCX file attachments, do not use Ubuntu for the client or the server. 


Popular posts from this blog

The iPhora Journey - Part 8 - Flow-based Programming

After my last post in this series -- way back in September 2022, several things happened that prevented any further installments. First came CollabSphere 2022 and then CollabSphere 2023, and organizing international conferences can easily consume all of one's spare time. Throughout this same time period, our product development efforts continued at full speed and are just now coming to fruition, which means it is finally time to continue our blog series. So let's get started... As developers, most of us create applications through the conscious act of programming, either procedural, as many of us old-timers grew up with, or object-oriented, which we grudgingly had to admit was better. This is true whether we are using Java, LotusScript, C++ or Rust on Domino. (By the way, does anyone remember Pascal? When I was in school, I remember being told it was the language of the future, but for some reason it didn't seem to survive past the MTV era).  But in the last decade, there a

Creating Twitter Bootstrap Widgets - Part II - Let's Assemble

Creating Twitter Bootstrap Widgets - Part I - Anatomy of a Widget Creating Twitter Bootstrap Widgets - Part II - Let's Assemble Creating Twitter Bootstrap Widgets - Part IIIA - Using Dojo To Bring It Together This is two part of my five part series "Creating Twitter Bootstrap Widgets".   As I mentioned in part one of this series, Twitter Bootstrap widgets are built from a collection standard HTML elements, styled, and programmed to function as a single unit. The goal of this series is to teach you how to create a Bootstrap widget that utilizes the Bootstrap CSS and Dojo. The use of Dojo with Bootstrap is very limited with the exception of Kevin Armstrong who did an incredible job with his Dojo Bootstrap, Our example is a combo box that we are building to replace the standard Bootstrap combo box. In part one, we built a widget that looks like a combo box but did not have a drop down menu associated with it to allow the user to make a select

The iPhora Journey - Part 3 - Creating an Integrated UI Framework

The iPhora Journey - Part 1 - Reimagining Domino The iPhora Journey - Part 2 - Domino, the Little Engine that Could The iPhora Journey - Part 3 - Creating an Integrated UI Framework There are many ways to create the user interface (UI) for a web application. The HTML page could be created on the server and then pushed out. It could be static with the data generated on the page by the server with JavaScript, providing a more dynamic experience, or the server could generate new HTML content to update portions of the web page. XPages or PHP are good examples of this. Another method is to have the web page partially generated by the server and have JavaScript build the rest of the HTML by pulling data from the server via an API. This is the approach used in the Single Page Application (SPA) model. In all cases, it is still dependent on the web server technology being using.  As mentioned previously in this blog, XPages is dependent on complete integration between form and document, which e