特殊:Badtitle/NS100:Quickbooks Enterprise Data Server:修订间差异
小无编辑摘要 |
小无编辑摘要 |
||
第2行: | 第2行: | ||
{{Languages|UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server}} | {{Languages|UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server}} | ||
== Introduction == | == Introduction == | ||
[http://www.intuit.com/ Intuit] has released a Linux version of their database manager for [http://quickbooks.intuit.com/ 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, v8, and | [http://www.intuit.com/ Intuit] has released a Linux version of their database manager for [http://quickbooks.intuit.com/ 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, v8, v9, and v10. | ||
Please note that although QuickBooks Data Server can be made to run on Ubuntu, it is not officially supported by Intuit. | 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 === | === QuickBooks Enterprise Data Server 7 Release 8 === | ||
第267行: | 第267行: | ||
</nowiki></pre> | </nowiki></pre> | ||
</li><li>On the client side I found that you must refer to the company file or share (via shortcut, mapped drive, etc) by either the ip address or the fully qualified domain name (FQDN) of the server or the clients will fail to connect to the file in multi-user mode with this error: You are trying to work on a company file located on another computer and this copy of QuickBooks cannot reach the server on that computer. (H202) I have tried using the host name and the Netbios name from Samba's smb.conf (if different from the host name) and they failed. This is different from v8 which also allowed host names.</li></ol> | </li><li>On the client side I found that you must refer to the company file or share (via shortcut, mapped drive, etc) by either the ip address or the fully qualified domain name (FQDN) of the server or the clients will fail to connect to the file in multi-user mode with this error: You are trying to work on a company file located on another computer and this copy of QuickBooks cannot reach the server on that computer. (H202) I have tried using the host name and the Netbios name from Samba's smb.conf (if different from the host name) and they failed. This is different from v8 which also allowed host names.</li></ol> | ||
=== QuickBooks Enterprise Data Server 10 === | |||
==== Installation on Ubuntu 8.04.4 LTS i386 ==== | |||
Notes: | |||
* These instructions assume that Samba is installed and configured correctly. Assistance with [[UbuntuHelp:ComprehensiveSambaGuide|Samba]] is available elsewhere in this wiki. | |||
* It also assumes that your Unix and Samba users have been created. | |||
* You can preface the commands with sudo or login as root | |||
Instructions: | |||
<ol><li>Install necessary packages: <pre><nowiki> | |||
apt-get install alien gamin | |||
</nowiki></pre> | |||
</li><li>Retrieve Quickbooks RPM from your Quickbooks Enterprise CD: <pre><nowiki> | |||
cp /media/cdrom/LinuxDBServer/qbdm-20.0-5.i386.rpm ./ | |||
</nowiki></pre> | |||
</li><li>Convert the RPM to .deb: <pre><nowiki> | |||
alien qbdbm-20.0-5.i386.rpm | |||
</nowiki></pre> | |||
</li><li>Install the .deb: <pre><nowiki> | |||
dpkg -i qbdbm_20.0-6_i386.deb | |||
</nowiki></pre> | |||
</li><li>Create the Quickbooks permissions group and users: <pre><nowiki> | |||
addgroup quickbooks | |||
adduser <username> quickbooks | |||
</nowiki></pre> | |||
</li><li>Create and configure the Quickbooks data directory: <pre><nowiki> | |||
mkdir /home/qbdata | |||
chown root:quickbooks /home/qbdata | |||
chmod 770 /home/qbdata | |||
</nowiki></pre> | |||
</li><li>Configure the Quickbooks file monitor:<pre><nowiki> | |||
cp /opt/qb/qbmonitord.conf /opt/qb/qbmonitord.conf.orig | |||
nano -w /opt/qb/qbmonitord.conf | |||
* Delete: existing path | |||
* Add: /home/qbdata | |||
* Exit and Save | |||
</nowiki></pre> | |||
</li><li>Add the Quickbooks file monitor and database manager to the boot sequence:<pre><nowiki> | |||
update-rc.d qbdbfilemon defaults 23 77 | |||
update-rc.d qbdbmgrn_20 defaults 24 76 | |||
</nowiki></pre> | |||
</li><li>Create the Quickbooks Samba share in /etc/samba/smb.conf:<pre><nowiki> | |||
[qbdata] | |||
comment = QuickBooks Data | |||
path = /home/qbdata | |||
guest ok = no | |||
browseable = yes | |||
writeable = yes | |||
create mask = 0660 | |||
directory mask = 0770 | |||
valid users = @quickbooks | |||
write list = @quickbooks | |||
force group = quickbooks | |||
admin users = @quickbooks | |||
</nowiki></pre> | |||
</li><li>Restart Services:<pre><nowiki> | |||
/etc/init.d/samba restart | |||
/etc/init.d/qbdbfilemon restart | |||
/etc/init.d/qbdbmgrn_20 restart | |||
</nowiki></pre></li></ol> | |||
== External links == | == External links == | ||
* [http:// | * [http://enterprisesuite.intuit.com/products/enterprise-solutions/?qbes_info=technical Quickbooks Enterprise Technical Documentation] | ||
* [http:// | * [http://community.intuit.com/quickbooks/ Quickbooks Forums] | ||
---- | ---- | ||
[[category:CategorySoftware]] [[category:CategoryCommercialSoftware]] | [[category:CategorySoftware]] [[category:CategoryCommercialSoftware]] | ||
[[category:UbuntuHelp]] | [[category:UbuntuHelp]] |
2010年5月20日 (四) 00:00的最新版本
文章出处: |
{{#if: | {{{2}}} | https://help.ubuntu.com/community/Quickbooks%20Enterprise%20Data%20Server }} |
点击翻译: |
English {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/af | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|Afrikaans| [[::Quickbooks Enterprise Data Server/af|Afrikaans]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/ar | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|العربية| [[::Quickbooks Enterprise Data Server/ar|العربية]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/az | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|azərbaycanca| [[::Quickbooks Enterprise Data Server/az|azərbaycanca]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/bcc | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|جهلسری بلوچی| [[::Quickbooks Enterprise Data Server/bcc|جهلسری بلوچی]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/bg | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|български| [[::Quickbooks Enterprise Data Server/bg|български]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/br | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|brezhoneg| [[::Quickbooks Enterprise Data Server/br|brezhoneg]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/ca | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|català| [[::Quickbooks Enterprise Data Server/ca|català]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/cs | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|čeština| [[::Quickbooks Enterprise Data Server/cs|čeština]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/de | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|Deutsch| [[::Quickbooks Enterprise Data Server/de|Deutsch]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/el | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|Ελληνικά| [[::Quickbooks Enterprise Data Server/el|Ελληνικά]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/es | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|español| [[::Quickbooks Enterprise Data Server/es|español]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/fa | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|فارسی| [[::Quickbooks Enterprise Data Server/fa|فارسی]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/fi | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|suomi| [[::Quickbooks Enterprise Data Server/fi|suomi]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/fr | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|français| [[::Quickbooks Enterprise Data Server/fr|français]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/gu | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|ગુજરાતી| [[::Quickbooks Enterprise Data Server/gu|ગુજરાતી]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/he | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|עברית| [[::Quickbooks Enterprise Data Server/he|עברית]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/hu | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|magyar| [[::Quickbooks Enterprise Data Server/hu|magyar]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/id | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|Bahasa Indonesia| [[::Quickbooks Enterprise Data Server/id|Bahasa Indonesia]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/it | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|italiano| [[::Quickbooks Enterprise Data Server/it|italiano]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/ja | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|日本語| [[::Quickbooks Enterprise Data Server/ja|日本語]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/ko | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|한국어| [[::Quickbooks Enterprise Data Server/ko|한국어]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/ksh | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|Ripoarisch| [[::Quickbooks Enterprise Data Server/ksh|Ripoarisch]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/mr | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|मराठी| [[::Quickbooks Enterprise Data Server/mr|मराठी]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/ms | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|Bahasa Melayu| [[::Quickbooks Enterprise Data Server/ms|Bahasa Melayu]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/nl | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|Nederlands| [[::Quickbooks Enterprise Data Server/nl|Nederlands]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/no | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|norsk| [[::Quickbooks Enterprise Data Server/no|norsk]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/oc | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|occitan| [[::Quickbooks Enterprise Data Server/oc|occitan]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/pl | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|polski| [[::Quickbooks Enterprise Data Server/pl|polski]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/pt | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|português| [[::Quickbooks Enterprise Data Server/pt|português]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/ro | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|română| [[::Quickbooks Enterprise Data Server/ro|română]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/ru | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|русский| [[::Quickbooks Enterprise Data Server/ru|русский]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/si | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|සිංහල| [[::Quickbooks Enterprise Data Server/si|සිංහල]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/sq | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|shqip| [[::Quickbooks Enterprise Data Server/sq|shqip]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/sr | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|српски / srpski| [[::Quickbooks Enterprise Data Server/sr|српски / srpski]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/sv | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|svenska| [[::Quickbooks Enterprise Data Server/sv|svenska]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/th | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|ไทย| [[::Quickbooks Enterprise Data Server/th|ไทย]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/tr | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|Türkçe| [[::Quickbooks Enterprise Data Server/tr|Türkçe]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/vi | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|Tiếng Việt| [[::Quickbooks Enterprise Data Server/vi|Tiếng Việt]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/yue | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|粵語| [[::Quickbooks Enterprise Data Server/yue|粵語]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/zh | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|中文| [[::Quickbooks Enterprise Data Server/zh|中文]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/zh-hans | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|中文(简体)| [[::Quickbooks Enterprise Data Server/zh-hans|中文(简体)]]}}|}} {{#ifexist: {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server | {{#if: | :}}Quickbooks Enterprise Data Server}}/zh-hant | • {{#if: UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|中文(繁體)| [[::Quickbooks Enterprise Data Server/zh-hant|中文(繁體)]]}}|}} |
{{#ifeq:UbuntuHelp:Quickbooks%20Enterprise%20Data%20Server|:Quickbooks Enterprise Data Server|请不要直接编辑翻译本页,本页将定期与来源同步。}} |
{{#ifexist: :Quickbooks Enterprise Data Server/zh | | {{#ifexist: Quickbooks Enterprise Data Server/zh | | {{#ifeq: {{#titleparts:Quickbooks Enterprise Data Server|1|-1|}} | zh | | }} }} }} {{#ifeq: {{#titleparts:Quickbooks Enterprise Data Server|1|-1|}} | zh | | }}
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, v8, v9, and v10. 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:
- Login as root
apt-get install alien libfam0 portmap fam
mkdir /var/lock/subsys
wget http://http-download.intuit.com/http.intuit/CMO/qbes/resources/qbdbm-17.0-14.i386.rpm
alien --to-deb --scripts qbdbm-17.0-14_i386.rpm
dpkg -i qbdbm_17.0-15_i386.deb
ln -s /etc/init.d/qbmonitord /etc/rc2.d/S85qbmonitord
ln -s /etc/init.d/qbmonitord /etc/rc3.d/S85qbmonitord
ln -s /etc/init.d/qbmonitord /etc/rc4.d/S85qbmonitord
ln -s /etc/init.d/qbmonitord /etc/rc1.d/K15qbmonitord
ln -s /etc/init.d/qbmonitord /etc/rc6.d/K15qbmonitord
addgroup quickbooks
- Add users to quickbooks group
adduser user1 quickbooks
adduser user2 quickbooks
mkdir /home/qbdata
chown root:quickbooks /home/qbdata
chown -R 775 /home/qbdata
nano /opt/qbes7/util/qbmonitord.conf
- Delete existing path
- Add
/home/qbdata
- 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
- Exit and Save
/etc/init.d/qbmonitord restart
nano -w /etc/samba/smb.conf
- 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
- Exit and Save
- Add the following share definition:
/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:
- Login as root
apt-get install alien rpm lsb lsb-rpm gamin
mkdir /var/lock/subsys
alien qbdbm-VERSION.rpm
- Do not use the "--script" option, it will fail
dpkg -i qbdm-VERSION.deb
- For some reason Alien will bump the last number
nano -w /etc/syslog.conf
- Add
daemon.* -/var/log/qbdbfilemon.log
- Exit and Save
- Add
touch /var/log/qbdbfilemon.log
/usr/lib/lsb/install_initd /etc/init.d/qbdbfilemon
/usr/lib/lsb/install_initd /etc/init.d/qbdbmgrn_18
addgroup quickbooks
- Add users who will be accessing the samba share to the quickbooks group:
usermod -G quickbooks USERNAME
mkdir /home/qbdata
chown root:quickbooks /home/qbdata
chmod -R 770 /home/qbdata
nano -w /etc/samba/smb.conf
- 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
- Exit and Save
- Add the following share definition:
nano -w /opt/qb/util/qbmonitord.conf
- Remove the default path
- Add
/home/qbdata
- 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
- Exit and Save
/etc/init.d/qbmonitord start
/etc/init.d/sysklogd restart
Installation on Ubuntu 8.04.1 LTS 64-bit
- 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.
On the Ubuntu server at the bash prompt:
- Login as root
apt-get install alien lsb gcc gamin ia32-libs
- Not positive you need the ia32-libs but should not cause any problems and likely you already have them installed
alien -g qbdbm-VERSION.rpm
- Do not use the "--script" option, it will fail
cd qbdbm-VERSION
- You don't want to descend into the .orig directory
nano -w debian/control
- Change
Architecture: i386
TOArchitecture: amd64
- Exit and Save
- Change
./debian/rules binary
cd ..
dpkg -i qbdm-VERSION.deb
- For some reason Alien will bump the last number
- We need to get the i386 gamin libraries that match our amd64 versions for this to run on amd64 architecture. We also need to modify the init scripts slightly
dpkg -l | grep libgamin
- Use to match the version from the i386 packages, i.e. 0.1.9-2ubuntu2
wget http://mirrors.kernel.org/ubuntu/pool/main/g/gamin/libgamin0_VERSION_i386.deb
mkdir temp
dpkg -x libgamin0_VERSION_i386.deb temp
cp -d temp/usr/lib/* /usr/lib32/
nano -w /etc/init.d/qbdbfilemon
- In the declaration section before the
case
statement addLD_LIBRARY_PATH="/usr/lib32:$LD_LIBRARY_PATH" export LD_LIBRARY_PATH
- Change
lockfile="/var/lock/subsys/qbdbfilemon"
TOlockfile="/var/lock/qbdbfilemon"
- If you want the service to say "..is stopped" instead of "..unused" when status is not running
- In status case change all instances of
echo "..unused"
TOecho "..is stopped"
- If you want to see the service startup messages
- In start case change
start_daemon ${qbmonitord} >/dev/null 2>&1
TOstart_daemon ${qbmonitord} #>/dev/null 2>&1
- Exit and Save
nano -w /etc/init.d/qbdbmgrn_VERSION
- Change
lockfile="/var/lock/subsys/qbdbmgrn_${DBMAJOR_VERSION}"
TOlockfile="/var/lock/qbdbmgrn_${DBMAJOR_VERSION}"
- In the stop case change
killproc ${qbdbm} >/dev/null 2>&1
TOkillall -TERM ${qbdbm} >/dev/null 2>&1
- If you want the service to say "..is stopped" instead of "..unused" when status is not running
- In status case change all instances of
echo "..unused"
TOecho "..is stopped"
- Exit and Save
nano -w /etc/syslog.conf
- Add
daemon.* -/var/log/qbdbfilemon.log
- Exit and Save
touch /var/log/qbdbfilemon.log
addgroup quickbooks
- Add users who will be accessing the samba share to the quickbooks group:
usermod -G quickbooks USERNAME
mkdir /home/qbdata
chown root:quickbooks /home/qbdata
chmod -R 770 /home/qbdata
nano -w /etc/samba/smb.conf
- 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
- Exit and Save
nano -w /opt/qb/util/qbmonitord.conf
- Remove the default path
- Add
/home/qbdata
- 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
- Exit and Save
/etc/init.d/qbmonitord start
/etc/init.d/qbmgrn_VERSION start
/etc/init.d/sysklogd restart
- Once you have verified that everything is working as it should you can remove the working directories
rm -r qbdbm-VERSION rm -r qbdbm-VERSION.orig rm -r temp
- On the client side I found that you must refer to the company file or share (via shortcut, mapped drive, etc) by the host name, the ip address, or the fully qualified domain name (FQDN) of the server or the clients will fail to connect to the file in multi-user mode with this error: You are trying to work on a company file located on another computer and this copy of QuickBooks cannot reach the server on that computer. (H202) I tried using the Netbios name from Samba's smb.conf (if different from the host name) and that failed. I found that v9 will only work when the clients refer to the ip address or FQDN so I would recommend only using one of those for future ease of upgrade.
QuickBooks Enterprise Data Server 9
Upgrade to version 9 from version 8 on Ubuntu 8.04.1 LTS 64-bit
- I have not done a clean install of QuickBooks Enterprise Data Server v9. However based upon the steps I took to install v8 and then upgrade to v9 I believe if you follow the instructions for installing v8 on 64-bit (above) changing filenames/versions as needed you may have success. But that is my humble opinion with no guarantee or warranty - try at your own risk!
- These instructions assume that you already have a working installation of QuickBooks Enterprise Data Server v8 that was installed using the above instructions for the 64-bit version only.
- When I did this upgrade I was able to have the server running v9 and the clients running v8 could still connect and work with v8 company files without issue. This allowed me to do a two-step upgrade process rather then everything at once. YMMV.
- 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.
On the Ubuntu server at the bash prompt:
- Login as root
/etc/init.d/qbdbfilemon stop
/etc/init.d/qbdbmgrn_OLDVERSION stop
alien -g qbdbm-NEWVERSION.rpm
- Do not use the "--script" option, it will fail
cd qbdbm-NEWVERSION
- You don't want to descend into the .orig directory
nano -w debian/control
- Change
Architecture: i386
TOArchitecture: amd64
- Exit and Save
- Change
./debian/rules binary
cd ..
dpkg -i qbdm-NEWVERSION.deb
- For some reason Alien will bump the last number
- If prompted say yes to overwriting existing files
1.We need to modify the init scripts
nano -w /etc/init.d/qbdbfilemon
- In the declaration section before the
case
statement addLD_LIBRARY_PATH="/usr/lib32:$LD_LIBRARY_PATH" export LD_LIBRARY_PATH
- Change
lockfile="/var/lock/subsys/qbdbfilemon"
TOlockfile="/var/lock/qbdbfilemon"
- If you want the service to say "..is stopped" instead of "..unused" when status is not running
- In status case change all instances of
echo "..unused"
TOecho "..is stopped"
- If you want to see the service startup messages
- In start case change
start_daemon ${qbmonitord} >/dev/null 2>&1
TOstart_daemon ${qbmonitord} #>/dev/null 2>&1
- Exit and Save
nano -w /etc/init.d/qbdbmgrn_NEWVERSION
- Change
lockfile="/var/lock/subsys/qbdbmgrn_${DBMAJOR_VERSION}"
TOlockfile="/var/lock/qbdbmgrn_${DBMAJOR_VERSION}"
- In the stop case change
killproc ${qbdbm} >/dev/null 2>&1
TOkillall -TERM ${qbdbm} >/dev/null 2>&1
- If you want the service to say "..is stopped" instead of "..unused" when status is not running
- In status case change all instances of
echo "..unused"
TOecho "..is stopped"
- Exit and Save
/etc/init.d/qbdbfilemon start
/etc/init.d/qbdbmgrn_NEWVERSION start
/etc/init.d/sysklogd restart
- Once you have verified that everything is working as it should you can remove the old v8 init scripts and working directories
rm /etc/init.d/qbdbfilemon.dpkg-old rm /etc/init.d/qbdbmgrn_OLDVERSION rm -r qbdbm-NEWVERSION rm -r qbdbm-NEWVERSION.orig rm -r temp
- On the client side I found that you must refer to the company file or share (via shortcut, mapped drive, etc) by either the ip address or the fully qualified domain name (FQDN) of the server or the clients will fail to connect to the file in multi-user mode with this error: You are trying to work on a company file located on another computer and this copy of QuickBooks cannot reach the server on that computer. (H202) I have tried using the host name and the Netbios name from Samba's smb.conf (if different from the host name) and they failed. This is different from v8 which also allowed host names.
QuickBooks Enterprise Data Server 10
Installation on Ubuntu 8.04.4 LTS i386
Notes:
- These instructions assume that Samba is installed and configured correctly. Assistance with Samba is available elsewhere in this wiki.
- It also assumes that your Unix and Samba users have been created.
- You can preface the commands with sudo or login as root
Instructions:
- Install necessary packages:
apt-get install alien gamin
- Retrieve Quickbooks RPM from your Quickbooks Enterprise CD:
cp /media/cdrom/LinuxDBServer/qbdm-20.0-5.i386.rpm ./
- Convert the RPM to .deb:
alien qbdbm-20.0-5.i386.rpm
- Install the .deb:
dpkg -i qbdbm_20.0-6_i386.deb
- Create the Quickbooks permissions group and users:
addgroup quickbooks adduser <username> quickbooks
- Create and configure the Quickbooks data directory:
mkdir /home/qbdata chown root:quickbooks /home/qbdata chmod 770 /home/qbdata
- Configure the Quickbooks file monitor:
cp /opt/qb/qbmonitord.conf /opt/qb/qbmonitord.conf.orig nano -w /opt/qb/qbmonitord.conf * Delete: existing path * Add: /home/qbdata * Exit and Save
- Add the Quickbooks file monitor and database manager to the boot sequence:
update-rc.d qbdbfilemon defaults 23 77 update-rc.d qbdbmgrn_20 defaults 24 76
- Create the Quickbooks Samba share in /etc/samba/smb.conf:
[qbdata] comment = QuickBooks Data path = /home/qbdata guest ok = no browseable = yes writeable = yes create mask = 0660 directory mask = 0770 valid users = @quickbooks write list = @quickbooks force group = quickbooks admin users = @quickbooks
- Restart Services:
/etc/init.d/samba restart /etc/init.d/qbdbfilemon restart /etc/init.d/qbdbmgrn_20 restart
External links
- In the declaration section before the