QuickBooks Linux Database Server Manager

Recently we have shared a lot of articles with you, but today’s article is something different from the other articles, especially for both Linux and QuickBooks users. Yes, Accountwizy is here again with a new article regarding the QuickBooks Linux database server manager. Are you interested to know about this topic? If yes, then don’t wait, just go for the article, and read the blog carefully till the end.   

QuickBooks Linux database server manager contains the QuickBooks Desktop Enterprise database server which stores all the company files of QuickBooks. The user of Linux can use the Linux database server manager in QuickBooks, and the Windows users can use the QuickBooks database server manager directly in QuickBooks. It allows the users to access the QuickBooks company files for the QuickBooks enterprise operations, and request data through the users running QuickBooks Desktop Enterprise on a Windows client computer. So it is very easy to use the Linux database server manager in QuickBooks. 

If you are a QuickBooks user, and also a Linux user, and you want to use the Linux database server manager in QuickBooks then you need to install it first. Here is the procedure to install the QuickBooks Linux database server manager. 

Other Recommended Articles:

How to Update Payment Information with Apple Billing in QuickBooks Online?
How to Import and Export CSV Files in QuickBooks Desktop?
How to Order Checks, Tax Forms And Other Supplies for QuickBooks Online

Procedure to Install QuickBooks Linux Database Server Manager 

To install the Linux database server manager in QuickBooks you need to follow three simple steps perfectly, one is to prepare some requirements for the installation, and the second one is the installation process, and the other one is the configuration of the database server manager. Now let’s start the procedure:

Step 1: Prepare Requirments for the Install of Database Server Manager

Before installing the database server manager, it is very important to prepare all the requirements. 

Components

Component Files	Function
Database Server Files	This enables the QuickBooks Desktop Enterprise users to read, and write data from the company file located on the Linux server.
qbmonitord daemon	This monitors the directories which contain the company files to ensure each directory has a qbdir.dat file. QuickBooks clients use the qbdir.dat file to generate a network definition file for each and every company file of QuickBooks when connected to a Linux server. The monitored daemon creates a new one if a qbdir.dat file for the monitored directory is deleted or modified.
qbmonitord Configuration File (qbmonitord.conf)	The file directories the qbmonitord daemon monitors, which contains all the QuickBooks company files. The qbmonitord daemon automatically reads the file and immediately monitors the specified directories whenever you modify the monitored.conf file.

System Requirements

Hardware & software	Recommended	Minimum
RAM	2 GHz Intel Pentium 4	1.2 GHz Intel Pentium 3
Processor	As much as possible	1 GB
Disk Space	Additional Space for the QuickBooks Company File	2.5 GB

Apart from that, you need the Linux distribution, let’s know, what is the Linux distribution?

Distribution 

Linux Distribution (Operating System – Client and Server)

Linux File Server – Function & Requirements

• The directories on Linux servers, which contains the company file must be configured as a Samba Share.
• And one more thing is, Samba Share can be mapped as a drive on Windows client.
• The performance will be impacted by networks (less than 100Mbps).

Client Computers

QuickBooks Desktop Version	Support for QuickBooks Desktop (32-bit and 64-bit version)
QuickBooks Desktop Enterprise 20.0	Fedora 29OpenSuse Leap 15.0Red Hat Enterprise 7 (RHEL 7)
QuickBooks Desktop Enterprise 19.0	Fedora 27OpenSuse 42.3Red Hat Enterprise 7 (Update 4)
QuickBooks Desktop Enterprise 18.0	Fedora 29OpenSuse Leap 15.0Red Hat Enterprise 7 (Update 3)

Firewall & Antivirus Compatibility

Maybe in this case, you need to adjust the settings of firewalls if you are using firewalls, and antivirus products. And these changes ensure you the best possible performance with Desktop Enterprise. 

If in case, the firewall stops the Linux database server manager from working then, make sure that the configuration is incorrect.  

And if you facing any firewall issues then you can contact your firewall assistance to troubleshoot your problem. 

The Linux database server manager uses the following ports:

• QuickBooks Desktop Enterprise 20.0: Ports 55343 or 8019 through 55347
• QuickBooks Desktop Enterprise 19.0: Ports 55383 or 8019 through 55387
• QuickBooks Enterprise 18.0: Ports 55378 or 8019 through 55382

You can check the Port 10172 is open on both Windows client and Linux server if you are unable to access any QuickBooks company file. 

Configuration Recommendations

Case Sensitive File Names- 

The Filesystem used on Linux is case-sensitive. The filename only differs by the case of preventing the desktop from working properly. And you should remember that all the file names are unique.  

Sharing and User Permissions-

Always remember that the directory on the QuickBooks Linux database server manager where you save the company files is must be configured as the Samba share so that the directory can be mapped as a drive on Windows client computers.  

Host Name Resolution- 

If the windows clients are able to resolve the hostname or IP address of the Linux server, then you can access the QuickBooks company files. Samba configured correctly to use the Domain Name Server, so check it. 

The requirements are completed now, let’s go to the installation process of the QuickBooks Linux database server manager.

Step 2: Install Linux Database Server Manager in QuickBooks

Here this the procedure to install the QuickBooks Linux database server manager in QuickBooks. Follow the steps carefully:  

• First of all, become the main user on the Linux server.
• Then download the Linux database server manager RPM package
• After logging into the RPM package, verify the integrity of the package with the GPG public key. To do that, you can follow the sub-points
  • Download the Public key on the Linux server from the official site of QuickBooks Desktop Enterprise.
  • Enter the command ‘rpm–import qbdbm-pubkey.asc’ in a terminal window, and press the ‘Enter’ key from the keyboard to import the public key into the ‘keyring’. 
  • Keyring is a database of trusted keys on the Linux server.
  • After that, enter the ‘rpm -K <packagename>’, and press the ‘Enter’ key from the keyboard, where the package name is the name of the Linux database server manager RPM package. 
• Again then, type ‘rpm -ivh <packagename>’ in a terminal window, and press the ‘Enter’ keyboard, where the package name is the name of the Linux database server manager RPM package. Go to the ‘What files installed on my Linux server’ to get the list of the files installed by the RPM.
• Store QuickBooks company file by creating a directory.  (Ensure that, the company files must be configured as a Samba share directory. Go to the Samba Documentation to get the detailed information, and make sure that you set the appropriate permissions for the directory which contains the company file, so that the user group can access it.
• At the last of the installation, copy the company files to the directory you created. 

(Note: In the sensitive case, the filesystem is used on Linux. Don’t try to create a company file name on Linux which varies only by case. And ensure that, you have set the exact permission for the company file so that the juicer group can access them.) 

Step 3: Configure the Linux Database Server Manager

Finally, we are in the last step. After completing the database server manager, the procedure will complete. Then hurry up, and follow the procedure to complete it:

• At first, you need to specify the company file directories
  • Open a terminal window, and list the directories stored in the QuickBooks Company Files on a separate line by editing the /opt/qb/util/qbmonitord.conf file.
  • Restart the qbdbfilemon or qbmonitord service.
• Then, in the next step, create a Samba share
  • Use Linux, and QuickBooks as the main user.
  • Go to the terminal window, and enter ‘groupadd -r groupname’ to create a Linux group. 
  • To list the user name, add the line ‘groupname: user1, user2, user3’ to the /etc/group file. And this will be part of the created group. 
  • Enter ‘useradd’ to add to each user you specified. This will access the company files which are stored on the shared directory.  
  • Provide the users read/write/execute permission by entering the ‘chmod -R 775 /directory’.
  • Change the group ownership, type, ‘chgrp -R groupname /directory’ for the share directory.
  • In the next step, edit the smb.conf file. See the following lines, and include them, in the file: 
    • [share_name]
    • path = /directory
    • comment = samba share for company files
    • valid users = user1 user2 user3
    • public = no
    • writable = yes
    • printable = no
    • create mask = 0765 
  • You can locate the smb.conf file easily its default location (/etc/samba).
  • After that rename the share_name, according to choice, or what you want to use for the share. 
  • Then, replace the directory with the full path of the directory that you want to configure with as the Samba share.
  • Enter, ‘service smb restart’ to enter the Samba daemon. 
• And start the monitored.log logging
  • Restart the Syslog daemon after installation to start outputting log messages to the qbmonitord.log file.
  • Now enter /etc/init.d/syslog restart in a terminal window, and press the ‘Enter’ key from your keyboard. 

We hope, you have completed the procedure successfully, and the installation and configuration of the QuickBooks Linux database server manager are easy for you. 

Wrapping Up 

We tried our best to put the valuable information in the blog, we hope, you like it. And now you are able to install the QuickBooks Linux database server manager own self now. But further if in case, you need any help to install the database server manager or want to get more knowledge regarding this topic then you can get our Accountwizy ProAdvisor support for instant help. Don’t hesitate to take our help, and support, we are always with you, so stay connected with us.