Hi All,
I recently discovered that Quickbooks has a Linux Database manager and I'm trying to implement this at one of our clients so that they don't need to run the primary Quickbooks database on the windows workstation but rather on the ClearOS firewall. They have around 5 staff (small business) but this would be really handy as the backups can then be done on the server as they are currently being done.
I'm not sure if anyone else has tried this but I hope that the following will help someone out there:
Steps:
1) Download the Quickbooks Database Manager and Pub key from
http://intuitglobal.intuit.com/iq/quickbooks/docs/qbdbm-pubkey.asc
http://intuitglobal.intuit.com/iq/quickbooks/docs/qbdbm-22.0-2.i386.rpm
Manual if needed: http://enterprisesuite.intuit.com/resources/LinuxInstallGuide_12.0.pdf
2) Import the pubkey for the RPM with rpm --import filename.asc
You can check the RPM with "rpm -K packagename"
3) Install the package with "rpm -ivh packagename"
4) Make sure that the company files are on a Flexshare that everyone who needs is access has RWX access to
5) You specify Company files in the qbmonitord.conf file.
Edit the /opt/qb/util/qbmonitord.conf file to list the directories that store the QuickBooks company files. Type the full path of each directory on a separate line, for example:
/var/flexshare/shares/QB/QBData
/var/flexshare/shares/QB/QBcompanyfiles
The qbmonitord daemon monitors the directories
For each directory, the qbmonitord daemon ensures that the correct qbdir.dat file exists.
Restart the qbmonitord or qbdbfilemon service.
Apparently the qbmonitord daemon does not monitor subdirectories. Be sure you list subdirectories that contain company files in the qbmonitord.conf file.
6) Restart syslog ...
---
The above has been successful so far but have had some minor problems here and there. Anyone else who has done this, I'd appreciate their feedback
I recently discovered that Quickbooks has a Linux Database manager and I'm trying to implement this at one of our clients so that they don't need to run the primary Quickbooks database on the windows workstation but rather on the ClearOS firewall. They have around 5 staff (small business) but this would be really handy as the backups can then be done on the server as they are currently being done.
I'm not sure if anyone else has tried this but I hope that the following will help someone out there:
Steps:
1) Download the Quickbooks Database Manager and Pub key from
http://intuitglobal.intuit.com/iq/quickbooks/docs/qbdbm-pubkey.asc
http://intuitglobal.intuit.com/iq/quickbooks/docs/qbdbm-22.0-2.i386.rpm
Manual if needed: http://enterprisesuite.intuit.com/resources/LinuxInstallGuide_12.0.pdf
2) Import the pubkey for the RPM with rpm --import filename.asc
You can check the RPM with "rpm -K packagename"
3) Install the package with "rpm -ivh packagename"
4) Make sure that the company files are on a Flexshare that everyone who needs is access has RWX access to
5) You specify Company files in the qbmonitord.conf file.
Edit the /opt/qb/util/qbmonitord.conf file to list the directories that store the QuickBooks company files. Type the full path of each directory on a separate line, for example:
/var/flexshare/shares/QB/QBData
/var/flexshare/shares/QB/QBcompanyfiles
The qbmonitord daemon monitors the directories
For each directory, the qbmonitord daemon ensures that the correct qbdir.dat file exists.
Restart the qbmonitord or qbdbfilemon service.
Apparently the qbmonitord daemon does not monitor subdirectories. Be sure you list subdirectories that contain company files in the qbmonitord.conf file.
6) Restart syslog ...
---
The above has been successful so far but have had some minor problems here and there. Anyone else who has done this, I'd appreciate their feedback
In Database
Share this post:
Responses (9)
-
Accepted Answer
how do i get multi user to work on quickbooks i installed the linux software and setup every thing but in quickbooks i get a h202 error and i tried to follow and it still dose not help i looked at /var/log/message and i get error value to large for defined date type
i do not know how to fix that can any one help
please help -
Accepted Answer
I'm fighting with this right now...
QBES support told me that I need to add root to the group that owns the samba share (so allusers) but that doesn't seem like the best idea to me.
Does anyone know (or theorize) what side effect adding root to allusers will have? What if I make root own the flexshare? Apparently the qbes database driver uses root to access data (or I'm missing a fundamental concept here).
Also, I thought about the "winadmin" user... But I can't add it to any groups ("usermod: winadmin not found in /etc/passwd")
QBES support are dicks about supporting ClearOS.
I am planning an upgrade to 6.5x 64bit (well, a new full install to upgrade from 5.2) but am concerned with the fact that one service I must have running is a 32bit precompiled package for the "QuickBooks Enterprise Solutions Database Driver", qbdbm-24.0-1.i386.rpm. An old howto in a ClearOS forum (http://www.clearcenter.com/support/documentation/clearos_guides/quickbooks_enterprise_on_clearos) describes installing QBES on ClearOS, but mentions the need to install 32bit libraries. Is this still the case for ClearOS 6.5, and, if so, is the method the same as described in the old howto? -
Accepted Answer
i am using quickbooks pro and only one person at a time is opening the file but when i open the file then i close the file and some one trys to open it they cant the file is read only then i have to change the file to read/write and they can open it then then when they exit i can't open it and i have to go and change it to read/write again is there a way so that dose not happend and it is only on the quickbooks files -
Accepted Answer
This is definitely correct that this only works with Quickbooks Enterprise and not with Quickbooks Pro.
The Quickbooks Pro 2014 version will apparently have a database manager that will work with *Nix
For one of our clients who is running Quickbooks Pro on a little workstation we are merely using Second Copy to copy the Quickbooks Company files daily to a network share using flexshare authentication data.
Lou: What are the directory and file ownership permissions and are you using the flexshares to access the files? -
Accepted Answer
We too have QuickBooks Enterprise running for a couple of clients, both on ClearOS 6.4. The only issues we have is that whoever "owns" QuickBooks files on the server has to be the first one to open QuickBooks. Once that user opens QuickBooks, everybody else can access the files. There may be a way around this but it hasn't really been an issue with our two customers so we haven't bothered yet. The other issue is that a user from time to time will close QuickBooks incorrectly and won't be able to log back in to QuickBooks because QuickBooks sees them as already connected. A simple restart of the QuickBooks server program fixes that. -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
I've done this for a number of my customers. I've found that the Linux server edition of QB isn't exactly a first class citizen - if you require QB support for any reason and tell them you're on a Linux Server the support personnel start hemming & hawing.
But anyway, I'm using for 3 customers - 2 on COS 5 and one on COS 6. Have you had trouble with clients not connecting if the DNS name is not the same as the netbios name?
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »