QQube Multi-User Client Cannot See Server | CLEARIFY

You install the QQube multi-user client, and arrive at the screen where the QQube Engine Name gets populated with your network server name and address - and it is blank.

Cause

The IP Address and/or port is being blocked.  The QQube installer uses a Sybase Utility to "ping" the database server using UDP

There are five potential reasons for this:

1. Service not running on server
2. Incorrect DNS settings on the server
3. Workstation Firewall is blocking port 2638
4. Server Firewall is blocking port 2638
5. The workstation is on a different subnet

Resolution

Cause 1.  Login to the dedicated server synch user, and open up the QQube Configuration Tool.  Go to Advanced Options>Database (Show More).  The Start Database Service should be greyed out.  If it isn't then exit the qqube synchronizer in the lower right hand tray (right click on the lightning bolt and exit); then Start the Database Service.

Cause 2.  Open up a DOS Prompt Window, and do a ping on the server name to see if it comes up with the expected IP address.  If it doesn't please get with your IT personnel to troubleshoot and fix.

Cause 3. Temporarily disable the firewall on the workstation, then hit the "Back" button, and the "Next" button again to see if it finds the Server Engine Name.

Cause 4. If the resolution for Cause 2 did not work, then either temporarily disable the server firewall, or disable the firewall operation that prevents pings, and ports.

Cause 5 - for QQube Versions 7.7 Build 508 and LATER.  Here is an easy work around.

FIRST - cancel the current installation.

SECOND (OPTION FOR WORKSTATION) - open up a cmd window (with administrative rights) and run a switch (OVERRIDENODBSERVER=1) that will allow the installer to ignore the search. 

SECOND (OPTION FOR SERVER) - the switch is  (OVERRIDESERVERCLIENT=1): 

In these two examples above, the qqubeinstall.exe was placed in the downloads directory; and run from that directory.

As you run through the installer, then you will notice that the "Next" button is now available in the Other Installation Options Window, even though there are no database servers found.

THIRD - once you complete the installation, run the QQube Configuration Tool.  It will return a message saying that it can't find the database server, and defaults to this window:

THIRD (CONTINUED) - Type in the name of the database server that you see in the QQube Configuration Tool on the server, then physically type in the IP Address and Port in the Server IP Address window.  Unless the database service is not running on the server, or your firewall is specifically blocking this port, this option will always work.

Cause 5 - for versions BEFORE QQube Release 7.7 Build 508  This is a more involved work around that involves the installation of a single-user, changing some registry entries, and "fooling" it to act as multi-user client with the information already filled in.

FIRST Install QQube as a single-user.   This is going to install its own database etc, but we will effect changes to make it a client instead.

SECOND Don't open up the Configuration Tool.  Instead run regedit so we can make changes in the registry.  You will be looking for the key:

Computer\HKEY_CURRENT_USER\Software\CLEARIFY\QQube Tool\[7.x]\Database

Make the changes as shown in the Red and White Callouts.  Open up the Configuration Tool, and it will be in Client Mode.