UbuntuHelp:Quickbooks Enterprise Data Server

文章出处:

https://help.ubuntu.com/community/Quickbooks%20Enterprise%20Data%20Server

点击翻译:

English

Introduction

Intuit has released a Linux version of their database manager for Quickbooks Enterprise Edition. The database manager is a program that is separate from the Quickbooks client, which currently runs only on Windows. The database manager is currently only available for the Enterprise version of Quickbooks. The Linux version of the data manager is available for Quickbooks v7R8 and v8. Please note that although Quickbooks Data Server can be made to run on Ubuntu, it is not officially supported by Intuit.

Quickbooks Enterprise Data Server 7 Release 8

Installation on Ubuntu 6.06.1 LTS

There are a couple of things you should note before you begin:

• These instructions assume that Samba is already correctly configured and working for other shares. Assistance with Samba is available elsewhere in this wiki.
• You can either preface all of the commands with "sudo" or you can enable the root account with "sudo passwd root".
• This guide uses alien to convert the official rpm to deb format.
• This guide uses the "quickbooks" Unix group to control access rights. You can use whatever group you want, just make the substitutions below.
• This guide uses "/home/qbdata" to hold the data files, but you can use whatever directory you want, just make the substitutions below.
• This guide uses fairly open access controls on the Samba share. You may be able to get away with more restricted access, but these settings are known to work.
• The main problem on Ubuntu is with the init scripts not being created, so the instructions below tell you how to create the links manually.

On the Ubuntu server at the bash prompt:

1. Login as root
2. apt-get install alien libfam0 portmap fam
3. mkdir /var/lock/subsys
4. wget http://http-download.intuit.com/http.intuit/CMO/qbes/resources/qbdbm-17.0-14.i386.rpm
5. alien --to-deb --scripts qbdbm-17.0-14_i386.rpm
6. dpkg -i qbdbm_17.0-15_i386.deb
7. ln -s /etc/init.d/qbmonitord /etc/rc2.d/S85qbmonitord
8. ln -s /etc/init.d/qbmonitord /etc/rc3.d/S85qbmonitord
9. ln -s /etc/init.d/qbmonitord /etc/rc4.d/S85qbmonitord
10. ln -s /etc/init.d/qbmonitord /etc/rc1.d/K15qbmonitord
11. ln -s /etc/init.d/qbmonitord /etc/rc6.d/K15qbmonitord
12. addgroup quickbooks
13. Add users to quickbooks group

• adduser user1 quickbooks
• adduser user2 quickbooks

1. mkdir /home/qbdata
2. chown root:quickbooks /home/qbdata
3. chown -R 775 /home/qbdata
4. nano /opt/qbes7/util/qbmonitord.conf
   1. Delete existing path
   2. Add /home/qbdata
   3. Quickbooks Enterprise does not scan for subdirectories, so if you have more than one directory each one will need to be added on separate lines in qbmonitord.conf
   4. Exit and Save
5. /etc/init.d/qbmonitord restart
6. nano -w /etc/samba/smb.conf
   1. Add the following share definition:

      [qbdata]
      comment = QuickBooks Data
      path = /home/qbdata
      guest ok = no
      browseable = yes
      writeable = yes
      create mask = 0664
      directory mask = 0775
      valid users = @quickbooks
      write list = @quickbooks
      force group = quickbooks
      admin users = @quickbooks
      

   2. Exit and Save
7. /etc/init.d/samba reload

Quickbooks Enterprise Data Server 8

Installation on Ubuntu 8.04.1 LTS

• These instructions assume that Samba is already correctly configured and working for other shares. Assistance with Samba is available elsewhere in this wiki.
• You can either preface all of the commands with "sudo" or you can enable the root account with "sudo passwd root".
• This guide uses alien to convert the official rpm to deb format.
• This guide uses the "quickbooks" Unix group to control access rights. You can use whatever group you want, just make the substitutions below.
• This guide uses "/home/qbdata" to hold the data files, but you can use whatever directory you want, just make the substitutions below.
• This guide uses fairly open access controls on the Samba share. You may be able to get away with more restricted access, but these settings are known to work.
• The main problem on Ubuntu is with the init scripts not being created, so the instructions below tell you how to create the links manually.

On the Ubuntu server at the bash prompt:

1. Login as root
2. apt-get install alien rpm lsb lsb-rpm gamin
3. mkdir /var/lock/subsys
4. alien qbdbm-VERSION.rpm

• Do not use the "--script" option, it will fail

1. dpkg -i qbdm-VERSION.deb

• For some reason Alien will bump the last number

1. nano -w /etc/syslog.conf
   1. Add daemon.* -/var/log/qbdbfilemon.log
   2. Exit and Save
2. touch /var/log/qbdbfilemon.log
3. /usr/lib/lsb/install_initd /etc/init.d/qbdbfilemon
4. /usr/lib/lsb/install_initd /etc/init.d/qbdbmgrn_18
5. addgroup quickbooks
6. Add users who will be accessing the samba share to the quickbooks group:

• usermod -G quickbooks USERNAME

1. mkdir /home/qbdata
2. chown root:quickbooks /home/qbdata
3. chmod -R 770 /home/qbdata
4. nano -w /etc/samba/smb.conf
   1. Add the following share definition:

      [qbdata]
      comment = QuickBooks Data
      path = /home/qbdata
      guest ok = no
      browseable = yes
      writeable = yes
      create mask = 0664
      directory mask = 0775
      valid users = @quickbooks
      write list = @quickbooks
      force group = quickbooks
      admin users = @quickbooks
      

   2. Exit and Save
5. nano -w /opt/qb/util/qbmonitord.conf
   1. Remove the default path
   2. Add /home/qbdata
   3. Quickbooks Enterprise does not scan for subdirectories, so if you have more than one directory each one will need to be added on separate lines in qbmonitord.conf
   4. Exit and Save
6. /etc/init.d/qbmonitord start
7. /etc/init.d/sysklogd restart

External links

• Quickbooks Enterprise Solutions Online Resource Center for Linux
• Quickbooks Linux Forums

---