This guide covers the installation of the Quickbooks Database Monitoring engine on ClearOS. You will need to have root access to your server and be familiar with command line administration of your ClearOS server.

Prepare your server by creating a group for your accounting professionals. For this demonstration we have created a group called 'accounting'.

Create a flexshare for your Quickbooks data. For this demonstration we created a share called 'quickbooks' and we've mapped this using Windows Filesharing to the Q: drive on our workstations.

net use q: \\server\quickbooks /persistent:yes

Log into your server via command line as root. Download the package from Intuit.

wget http://http-download.intuit.com/http.intuit/CMO/qbes/resources/qbdbm-pubkeyv10.asc
wget http://http-download.intuit.com/http.intuit/CMO/qbes/resources/qbdbm-20.0-5.i386.rpm

Install the package.

rpm --import qbdbm-pubkey.asc
rpm -K qbdbm-20.0-5.i386.rpm
rpm -Uvh qbdbm-20.0-5.i386.rpm 

Add these two daemons as services:

chkconfig --add qbdbmgrn_20
chkconfig --add qbdbfilemon

As per the instructions, please add the QB data paths to /opt/qb/util/qbmonitord.conf file.

vi /opt/qb/util/qbmonitord.conf

Replace the /QBData path with the appropriate flexshare directory and path. The File Monitor will NOT search subdirectories. List each directory on its own line.

/var/flexshare/shares/quickbooks

Any time you update the qbmonitord.conf file, you will need to restart the qbdbfilemon daemon. It will index it automatically and should process the change without a restart but restart it anyways.

service qbdbfilemon restart

Be sure to restart the syslog service so that items get properly logged.

service syslog restart

Make sure that the /etc/init.d/qbdbfilemon script is stating. The status should be running. If it isn't it is likely that the service is not daemonizing. This is due to a SuSE convention which calls the service by using the command 'start_daemon' which is not in ClearOS. Remove the 'start_' so that it calls 'daemon' instead.

vi /etc/init.d/qbdbfilemon

Additionally, the /opt/qb/util/QBGLOBALAPPCONFIG.INI may need to have a space removed in the Range section before and after the equal sign.

[QBDBPortFinder]
StartPortNumber=55333
Range=5

Since this is a read-only file, you can save it in 'vi' with :w! and then :q

Lastly, please make sure you are running a good backup of these files.

Upgrading from previous versions is beyond the scope of this howto, please refer to the documentation contained within the link below.

Make sure that you can open the file and that it will go into multi-user mode.

If you have difficulty, make sure that the DNS, mapped network drive, unamd -a, and those names reported by QBES are absolutely right. The log file (/var/log/messages) will contain information about what the daemon thinks the server is. You need to make your mapped network drive connection to this resource (ie. \\system.clearos.lan\quickbooks).

Please note that the current Quickbooks Connection Diagnostic Tool, while extremely useful, is not certified for the Linux version of the Database Manager. In our testing it would report successes for everything but the 'DB Service Status' even when that service was working and configured properly.

• Quickbooks Linux Help

mkdir /root/support /root/support/quickbooks
cd /root/support/quickbooks
wget http://http-download.intuit.com/http.intuit/CMO/qbes/resources/qbdbm-pubkeyv10.asc
wget http://http-download.intuit.com/http.intuit/CMO/qbes/resources/qbdbm-20.0-5.i386.rpm
rpm --import qbdbm-pubkey.asc
rpm -K qbdbm-20.0-5.i386.rpm
rpm -Uvh qbdbm-20.0-5.i386.rpm
chkconfig --add qbdbmgrn_20
chkconfig --add qbdbfilemon
echo "" > /opt/qb/util/qbmonitord.conf
service qbdbfilemon restart
service syslog restart

/var/webconfig/api/Daemon.inc.php

"qbdbmgrn_20"   => array("qbdbm",            "QBDBMgrN_20",   "yes",  DAEMON_LANG_QBDBM,        "no",  "quickbooks.php"),
"qbdbfilemon"   => array("qbdbm",            "qbmonitord",    "yes",  DAEMON_LANG_QBFILEMON,    "no",  "quickbooks.php"),

/var/webconfig/api/lang/daemon.en_US

define("DAEMON_LANG_QBDBM", "Quickbooks Enterprise Manager");
define("DAEMON_LANG_QBFILEMON", "Quickbooks Enterprise File Monitor");