It is widely known that Quickbooks has a horrible storage engine, "requires" Windows to host multiuser access, etc. However, I've successfully been storing QuickBooks files on Samba shares at a handful of locations with no real issues other than slight performance degradation. However, a somewhat recent thread here mentioned the proper use of oplock'ing in the Samba configuration to considerably increase performance/reliability.
Could someone please share any hints/tips on configuring Samba for optimum use with QuickBooks? I have one server in particular that appears to be suffering performance problems with QuickBooks but runs lightning fast with all other applications. If I recall, and as the subject mentions, I believe the key lies with the oplock settings.
Thanks!
Tim Nelson Systems/Network Support Rockbochs Inc. (218)727-4332 x105
On Thu, Jan 29, 2009 at 11:36 AM, Tim Nelson tnelson@rockbochs.com wrote:
It is widely known that Quickbooks has a horrible storage engine, "requires" Windows to host multiuser access, etc. However, I've successfully been storing QuickBooks files on Samba shares at a handful of locations with no real issues other than slight performance degradation. However, a somewhat recent thread here mentioned the proper use of oplock'ing in the Samba configuration to considerably increase performance/reliability.
I am able to host all files other than Quickbooks on Samba shares. The issue with QuickBooks is they run their own WIndows service on port 10172 in addition to Windows file sharing.
If someone has figured out a way around this, I would prefer to host multiple user QuickBooks access on Samba.
Brett
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Brett Serkez Sent: Thursday, January 29, 2009 11:55 To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
On Thu, Jan 29, 2009 at 11:36 AM, Tim Nelson tnelson@rockbochs.com wrote:
It is widely known that Quickbooks has a horrible storage
engine, "requires" Windows to host multiuser access, etc. However, I've successfully been storing QuickBooks files on Samba shares at a handful of locations with no real issues other than slight performance degradation. However, a somewhat recent thread here mentioned the proper use of oplock'ing in the Samba configuration to considerably increase performance/reliability.
I am able to host all files other than Quickbooks on Samba shares. The issue with QuickBooks is they run their own WIndows service on port 10172 in addition to Windows file sharing.
We run QB Pro 2003, and it does not listen on any ports. We also have it on a samba share. Unsure about the perfomance, but it works for us.
If someone has figured out a way around this, I would prefer to host multiple user QuickBooks access on Samba.
Brett _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
-- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Principal Consultant 10 West 24th Street #100 - - +1 (443) 269-1555 x333 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is copyright PD Inc, subject to license 20080407P00.
On Thu, 2009-01-29 at 13:41 -0500, Jason Pyeron wrote:
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Brett Serkez Sent: Thursday, January 29, 2009 11:55 To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
On Thu, Jan 29, 2009 at 11:36 AM, Tim Nelson tnelson@rockbochs.com wrote:
It is widely known that Quickbooks has a horrible storage
engine, "requires" Windows to host multiuser access, etc. However, I've successfully been storing QuickBooks files on Samba shares at a handful of locations with no real issues other than slight performance degradation. However, a somewhat recent thread here mentioned the proper use of oplock'ing in the Samba configuration to considerably increase performance/reliability.
I am able to host all files other than Quickbooks on Samba shares. The issue with QuickBooks is they run their own WIndows service on port 10172 in addition to Windows file sharing.
We run QB Pro 2003, and it does not listen on any ports. We also have it on a samba share. Unsure about the perfomance, but it works for us.
---- They've made a bunch (and I mean a bunch) of changes since then. It's multi-user scheme seems to change with each new version.
Craig
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Craig White Sent: Thursday, January 29, 2009 15:52 To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
On Thu, 2009-01-29 at 13:41 -0500, Jason Pyeron wrote:
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Brett Serkez Sent: Thursday, January 29, 2009 11:55 To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
On Thu, Jan 29, 2009 at 11:36 AM, Tim Nelson
wrote:
It is widely known that Quickbooks has a horrible storage
engine, "requires" Windows to host multiuser access, etc. However, I've successfully been storing QuickBooks files on Samba shares at a handful of locations with no real issues other than slight performance degradation. However, a somewhat recent thread here mentioned the proper use of oplock'ing in the Samba configuration to considerably increase performance/reliability.
I am able to host all files other than Quickbooks on Samba shares. The issue with QuickBooks is they run their own WIndows
service on
port 10172 in addition to Windows file sharing.
We run QB Pro 2003, and it does not listen on any ports. We
also have
it on a samba share. Unsure about the perfomance, but it
works for us.
They've made a bunch (and I mean a bunch) of changes since then. It's multi-user scheme seems to change with each new version.
Yeah, we are looking to migrate away for just this reason. It changes away from what you need every upgrade.
Anyone else in a consulting/law firm/software dev shop who is a governemnt contractor that needs to do cost accounting and wants it to be hosted on a linux server? Let me know, we are going to have to do some thing else soon.
BTW, we just found out the Turbo Tax 2008 does not work with older version of Quickbooks today.
Craig
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
-Jason
-- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Principal Consultant 10 West 24th Street #100 - - +1 (443) 269-1555 x333 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is copyright PD Inc, subject to license 20080407P00.
Jason Pyeron wrote:
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Craig White Sent: Thursday, January 29, 2009 15:52 To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
On Thu, 2009-01-29 at 13:41 -0500, Jason Pyeron wrote:
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Brett Serkez Sent: Thursday, January 29, 2009 11:55 To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
On Thu, Jan 29, 2009 at 11:36 AM, Tim Nelson
wrote:
It is widely known that Quickbooks has a horrible storage
engine, "requires" Windows to host multiuser access, etc. However, I've successfully been storing QuickBooks files on Samba shares at a handful of locations with no real issues other than slight performance degradation. However, a somewhat recent thread here mentioned the proper use of oplock'ing in the Samba configuration to considerably increase performance/reliability.
I am able to host all files other than Quickbooks on Samba shares. The issue with QuickBooks is they run their own WIndows
service on
port 10172 in addition to Windows file sharing.
We run QB Pro 2003, and it does not listen on any ports. We
also have
it on a samba share. Unsure about the perfomance, but it
works for us.
They've made a bunch (and I mean a bunch) of changes since then. It's multi-user scheme seems to change with each new version.
Yeah, we are looking to migrate away for just this reason. It changes away from what you need every upgrade.
Anyone else in a consulting/law firm/software dev shop who is a governemnt contractor that needs to do cost accounting and wants it to be hosted on a linux server? Let me know, we are going to have to do some thing else soon.
BTW, we just found out the Turbo Tax 2008 does not work with older version of Quickbooks today.
Beware - they tell you QB2007 needs XP and will not work under W2K - this is rubbish, they just act as another marketing arm for Redmond. Also this year with Turbo Tax 2008 they warn it will be the last year it will work on W2K, let's wait and see..... Rob
Craig
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
-Jason
--
-- Jason Pyeron PD Inc. http://www.pdinc.us -
- Principal Consultant 10 West 24th Street #100 -
- +1 (443) 269-1555 x333 Baltimore, Maryland 21218 -
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is copyright PD Inc, subject to license 20080407P00.
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Jason Pyeron wrote:
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Brett Serkez Sent: Thursday, January 29, 2009 11:55 To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
On Thu, Jan 29, 2009 at 11:36 AM, Tim Nelson tnelson@rockbochs.com wrote:
It is widely known that Quickbooks has a horrible storage
engine, "requires" Windows to host multiuser access, etc. However, I've successfully been storing QuickBooks files on Samba shares at a handful of locations with no real issues other than slight performance degradation. However, a somewhat recent thread here mentioned the proper use of oplock'ing in the Samba configuration to considerably increase performance/reliability.
I am able to host all files other than Quickbooks on Samba shares. The issue with QuickBooks is they run their own WIndows service on port 10172 in addition to Windows file sharing.
We run QB Pro 2003, and it does not listen on any ports. We also have it on a samba share. Unsure about the perfomance, but it works for us.
If someone has figured out a way around this, I would prefer to host multiple user QuickBooks access on Samba.
Brett _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
--
-- Jason Pyeron PD Inc. http://www.pdinc.us -
- Principal Consultant 10 West 24th Street #100 -
- +1 (443) 269-1555 x333 Baltimore, Maryland 21218 -
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is copyright PD Inc, subject to license 20080407P00.
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
We had QB premier 2004 working well on Samba, then down graded to QB pro 2007 and the nightmare began. Long story - short version is we now run QB Pro 2007 on a CentOS 5 W/S running VirtualBox and a W2K instance with network bridging in multi-user mode so the four Windoze XP clients can access it. Performance is not great but adequate, however I can backup reliably and it stays up 24x7. Wish there was an alternative. Rob
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Rob Kampen Sent: Thursday, January 29, 2009 4:30 PM To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
Jason Pyeron wrote:
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Brett Serkez Sent: Thursday, January 29, 2009 11:55 To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
On Thu, Jan 29, 2009 at 11:36 AM, Tim Nelson tnelson@rockbochs.com wrote:
Long story - short version is we now run QB Pro 2007 on a CentOS 5 W/S running VirtualBox and a W2K instance with network bridging in multi-user mode so the four Windoze XP clients can access it. Performance is not great but adequate, however I can backup reliably and it stays up 24x7. Wish there was an alternative.
------------
So exactly what is the problem about running that version on Samba? What Samba configurations did you try if any?
JohnStanley
Sorry for the delayed response, needed to dreg the memory banks
John wrote:
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Rob Kampen Sent: Thursday, January 29, 2009 4:30 PM To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
Jason Pyeron wrote:
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Brett Serkez Sent: Thursday, January 29, 2009 11:55 To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
On Thu, Jan 29, 2009 at 11:36 AM, Tim Nelson tnelson@rockbochs.com wrote:
Long story - short version is we now run QB Pro 2007 on a CentOS 5 W/S running VirtualBox and a W2K instance with network bridging in multi-user mode so the four Windoze XP clients can access it. Performance is not great but adequate, however I can backup reliably and it stays up 24x7. Wish there was an alternative.
So exactly what is the problem about running that version on Samba? What Samba configurations did you try if any?
JohnStanley
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
QB2004 was happy to have multiple users access the QB file at the same time in multi-user mode and thus the QB file could be hosted on Samba with no issues. QB2007 insists that one machine become the "server" of the file for the other users in multi user mode. (where did their software architects learn their stuff?) Thus one needs to designate one of the five multi-user licensed machines as a "server". In my case, I wanted to host the QB server and of course I am running linux - hence the setup I described above. Rob
From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Rob Kampen Sent: Saturday, January 31, 2009 3:21 PM To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY
Sorry for the delayed response, needed to dreg the memory banks
John wrote:
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf OfRob Kampen Sent: Thursday, January 29, 2009 4:30 PM To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY Jason Pyeron wrote:
-----Original Message----- From: centos-bounces@centos.org[mailto:centos-bounces@centos.org] On Behalf Of Brett Serkez Sent: Thursday, January 29, 2009 11:55 To: CentOS mailing list Subject: Re: [CentOS] Quickbooks and Samba and Oplocks... OH MY On Thu, Jan 29, 2009 at 11:36 AM, Tim Nelson tnelson@rockbochs.com mailto:tnelson@rockbochs.com wrote:
Long story - short version is we now run QB Pro2007 on a CentOS 5 W/S running VirtualBox and a W2K instance with network bridging in multi-user mode so the four Windoze XP clients can access it. Performance is not great but adequate, however I can backup reliably and it stays up 24x7. Wish there was an alternative.
So exactly what is the problem about running that version on Samba? What Samba configurations did you try if any?
JohnStanley
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
QB2004 was happy to have multiple users access the QB file at the same time in multi-user mode and thus the QB file could be hosted on Samba with no issues. QB2007 insists that one machine become the "server" of the file for the other users in multi user mode. (where did their software architects learn their stuff?) Thus one needs to designate one of the five multi-user licensed machines as a "server". In my case, I wanted to host the QB server and of course I am running linux - hence the setup I described above. Rob
---- Let me research that because I recall that not being the case. As with a "Intuit" not QB client server app can be hosted over the network onto any type of CIFS server. The database file was way over some of the sizes reported on this list also. If the db file was hosted on a server it could also run the client app thus using a license up but you did not have to run the client app on the server.
One thing that does come to mind is the SMB/CIFS protocol difference. If that QB app is coded to use SMB then you will definately need an older SMB protocol Samba Server. Thus could be an interoperable cause?
BTW, this QB Intuit app was Intuits Construction client server app. Maybe you have seen it or used it?
JohnStanley
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Tim Nelson Sent: Thursday, January 29, 2009 11:37 AM To: centos@centos.org Subject: [CentOS] Quickbooks and Samba and Oplocks... OH MY
It is widely known that Quickbooks has a horrible storage engine, "requires" Windows to host multiuser access, etc. However, I've successfully been storing QuickBooks files on Samba shares at a handful of locations with no real issues other than slight performance degradation. However, a somewhat recent thread here mentioned the proper use of oplock'ing in the Samba configuration to considerably increase performance/reliability.
Could someone please share any hints/tips on configuring Samba for optimum use with QuickBooks? I have one server in particular that appears to be suffering performance problems with QuickBooks but runs lightning fast with all other applications. If I recall, and as the subject mentions, I believe the key lies with the oplock settings.
----- What do have for the current Samba configuration file? What version QB?
-
Brett Serkez -
Craig White -
Jason Pyeron -
John -
Rob Kampen -
Tim Nelson