Forums

Resolved
0 votes
I'm trying to get the QuickBooks Enterprise Solutions 14 Linux Database Manager set up in ClearOS.

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?

Thanks for any help anyone can provide.
Friday, January 10 2014, 06:35 PM
Share this post:
Responses (7)
  • Accepted Answer

    Friday, September 23 2016, 01:17 AM - #Permalink
    Resolved
    0 votes
    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
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, January 16 2014, 10:03 PM - #Permalink
    Resolved
    0 votes
    Thank you very much for your help.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, January 16 2014, 08:47 PM - #Permalink
    Resolved
    0 votes
    If you entered it at the command line, either change the -I to a -D or just restart the firewall (service firewall restart).
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, January 16 2014, 08:27 PM - #Permalink
    Resolved
    0 votes
    Thank you.

    That did accomplish what I was trying to do but QuickBooks is still being a jerk.

    How do I UN-do the firewall port redirect, should I want to?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, January 16 2014, 07:49 PM - #Permalink
    Resolved
    0 votes
    Try:
    iptables -t nat -I PREROUTING -p tcp -d 192.168.21.1 -m multiport --dports 55358:55362  -j REDIRECT --to-ports 55363
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, January 16 2014, 05:53 PM - #Permalink
    Resolved
    0 votes
    Excellent suggestion. I was able to fix one part of the trouble I was having, but I'm still having trouble with the ports the QBES manager sets up on. Unfortunately it's not open-source so I have no way to figure out how it chooses without Intuit's help and it seems they aren't eager to support anything besides RHEL 6.5 or some specific Fedora version.

    Does anyone know of a way to remap a port on the inside of the firewall? I mean, the database driver sets up on port 55363 (on its internal address, 192.168.21.1 and I can Nmap scan the server from a workstation and see the open port) but the QuickBooks clients expect the server on any one of ports between 55358 to 55362. Can I use the firewall to establish a port 55358 that just redirects to 55363 at least for testing?

    I realize the proper way to fix this is to figure out how the driver chooses a port but I have no idea how to even start doing that with a precompiled binary service.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, January 10 2014, 08:13 PM - #Permalink
    Resolved
    0 votes
    Why not manage that share outside the flexshare system and do it manually? Create another file, /etc/samba/anything.conf. You can copy in your current share definition from from the flexshare.conf file and give it a slightly different share name. In /etc/samba/smb.conf add a line "include = /etc/samba/anthing.conf". I add it after the line "include = /etc/samba/flexshare.conf". Then you can change your share definition to your heart's content. Line you probably want is "valid users = ....". Group names are preceded with an @, individuals are just listed. If you fancy years of bedtime reading (i.e. don't print it), have a look at the Samba Howto
    The reply is currently minimized Show
Your Reply