[Samba] Samba + Quickbooks Idle Crash

Sun Feb 7 20:00:33 MST 2010

Quite possibly, this is not actually a Samba problem. Quickbooks is pretty poorly written and goes very deep into the system; simple file sharing isn't enough to get it to work. In fact, the main reason Microsoft implemented UAC in Windows Vista was that Intuit had flat out refused to fix the Quickbooks problems for close to ten years, and continued insisting on administrator access.

When Vista came out, Intuit finally was forced to fix that - but now instead you have to install a server component on the file server.

There is a Linux version of this Quickbooks server component (on Intuit's Web site), but in my experience, it does not work reliably, though - or at least, it didn't when I tried it a couple years ago. The main problem was that it sometimes kept the file locked; whenever a user's Quickbooks crashed, we had to reboot the server to clear up the mess. We ended up having to designate a Windows workstation as Quickbooks "server".

If you try to access Quickbooks without that component installed, I am not surprised about any kind of problem; I'd only be surprised if it works at all.

> -----Original Message-----
> From: samba-bounces at lists.samba.org [mailto:samba-
> bounces at lists.samba.org] On Behalf Of samba at cwraig.id.au
> Sent: Sunday, February 07, 2010 3:40 PM
> To: samba at lists.samba.org
> Subject: [Samba] Samba + Quickbooks Idle Crash
> 
> I have a samba server running on ubuntu 9.10 with windows (both Xp and
> vista) clients running quickbooks (accounting software).
> 
> Quickbooks can connect to the samba server and get access to the data
> files with no problems, if the secretary uses quickbooks continuously
> there is never a problem the system works for hours on end. However if
> the
> secretary leaves the software running but doing nothing for a few mins
> (somewhere between 10 and 30mins) when she tries to perform the task
> quickbooks says it cannot find the server.
> 
> I have been running this kind of setup for a number of years on deban
> etch
> and this bug has only showed up when I moved to ubuntu 9.10 this year.
> I
> am willing to do any kind of debugging to help resolve this issue.
> 
> Below is a copy of /var/log/samba/log.deb-sfs
> 
> 
> ####################start of log file######################
> 
> [2010/01/04 07:43:21,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:21,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:21,  1] smbd/service.c:1047(make_connection_snum)
>   deb-sfs (::ffff:192.168.0.53) connect to service data initially as
> user
> nobody (uid=65534, gid=65534) (pid 3372)
> [2010/01/04 07:43:21,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:21,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:22,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:22,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:22,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:22,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:23,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:23,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:23,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:23,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:23,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:23,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:24,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:24,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:24,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:24,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:25,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:25,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/projects
> failed. Permission denied
> [2010/01/04 07:43:26,  1] smbd/service.c:1047(make_connection_snum)
>   deb-sfs (::ffff:192.168.0.53) connect to service projects initially
> as
> user nobody (uid=65534, gid=65534) (pid 3372)
> [2010/01/04 07:43:26,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/projects
> failed. Permission denied
> [2010/01/04 07:43:26,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:27,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/projects
> failed. Permission denied
> [2010/01/04 07:43:37,  1] smbd/service.c:1226(close_cnum)
>   deb-sfs (::ffff:192.168.0.53) closed connection to service projects
> [2010/01/04 07:43:38,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:43:38,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/data
> failed.
> Permission denied
> [2010/01/04 07:44:05,  1] smbd/service.c:1226(close_cnum)
>   deb-sfs (::ffff:192.168.0.53) closed connection to service projects
> [2010/02/05 09:56:14,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 09:56:14,  1] smbd/service.c:1047(make_connection_snum)
>   deb-sfs (192.168.0.53) connect to service qbdata initially as user
> nobody (uid=65534, gid=65534) (pid 3241)
> [2010/02/05 09:56:15,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 09:56:15,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 09:56:15,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 09:56:16,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 09:56:16,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 09:56:22,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 09:56:22,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 09:56:25,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 09:56:26,  0] smbd/nttrans.c:2076(call_nt_transact_ioctl)
>   call_nt_transact_ioctl(0x900eb): Currently not implemented.
> [2010/02/05 09:56:58,  1] smbd/service.c:1226(close_cnum)
>   deb-sfs (192.168.0.53) closed connection to service qbdata
> [2010/02/05 09:56:59,  1] smbd/service.c:1047(make_connection_snum)
>   deb-sfs (192.168.0.53) connect to service qbdata initially as user
> nobody (uid=65534, gid=65534) (pid 3241)
> [2010/02/05 09:57:36,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 09:57:37,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 10:12:25,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 10:40:28,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> [2010/02/05 10:40:48,  0] lib/substitute.c:560(alloc_sub_basic)
>   alloc_sub_basic: NULL source string!  This should not happen
> [2010/02/05 10:40:48,  0] lib/substitute.c:560(alloc_sub_basic)
>   alloc_sub_basic: NULL source string!  This should not happen
> [2010/02/05 10:40:48,  0] lib/substitute.c:560(alloc_sub_basic)
>   alloc_sub_basic: NULL source string!  This should not happen
> [2010/02/05 10:40:48,  0] lib/substitute.c:560(alloc_sub_basic)
>   alloc_sub_basic: NULL source string!  This should not happen
> [2010/02/05 10:40:48,  0] lib/fault.c:41(fault_report)
>   ===============================================================
> [2010/02/05 10:40:48,  0] lib/fault.c:42(fault_report)
>   INTERNAL ERROR: Signal 11 in pid 3241 (3.4.0)
>   Please read the Trouble-Shooting section of the Samba3-HOWTO
> [2010/02/05 10:40:48,  0] lib/fault.c:44(fault_report)
> 
>   From: http://www.samba.org/samba/docs/Samba3-HOWTO.pdf
> [2010/02/05 10:40:48,  0] lib/fault.c:45(fault_report)
>   ===============================================================
> [2010/02/05 10:40:48,  0] lib/util.c:1480(smb_panic)
>   PANIC (pid 3241): internal error
> [2010/02/05 10:40:48,  0] lib/util.c:1584(log_stack_trace)
>   BACKTRACE: 19 stack frames:
>    #0 /usr/sbin/smbd(log_stack_trace+0x2d) [0xb74cf86d]
>    #1 /usr/sbin/smbd(smb_panic+0x2d) [0xb74cf98d]
>    #2 /usr/sbin/smbd [0xb74bd15e]
>    #3 [0xb7186400]
>    #4 /usr/sbin/smbd [0xb728283c]
>    #5 /usr/sbin/smbd [0xb728eeeb]
>    #6 /usr/sbin/smbd(reply_trans2+0x726) [0xb72904f6]
>    #7 /usr/sbin/smbd [0xb72b4abe]
>    #8 /usr/sbin/smbd [0xb72b4f2d]
>    #9 /usr/sbin/smbd [0xb72b5790]
>    #10 /usr/sbin/smbd(run_events+0x12e) [0xb74e0eae]
>    #11 /usr/sbin/smbd(smbd_process+0x7d2) [0xb72b4352]
>    #12 /usr/sbin/smbd [0xb77b3335]
>    #13 /usr/sbin/smbd(run_events+0x12e) [0xb74e0eae]
>    #14 /usr/sbin/smbd [0xb74e114f]
>    #15 /usr/sbin/smbd(_tevent_loop_once+0x79) [0xb74e1749]
>    #16 /usr/sbin/smbd(main+0xcaa) [0xb77b407a]
>    #17 /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xe6)
> [0xb6d06b56]
>    #18 /usr/sbin/smbd [0xb722ead1]
> [2010/02/05 10:40:48,  0] lib/util.c:1485(smb_panic)
>   smb_panic(): calling panic action [/usr/share/samba/panic-action
> 3241]
> [2010/02/05 10:40:48,  0] lib/util.c:1493(smb_panic)
>   smb_panic(): action returned status 0
> [2010/02/05 10:40:48,  0] lib/fault.c:321(dump_core)
>   dumping core in /var/log/samba/cores/smbd
> [2010/02/05 10:40:48,  1] smbd/service.c:1047(make_connection_snum)
>   deb-sfs (192.168.0.53) connect to service qbdata initially as user
> nobody (uid=65534, gid=65534) (pid 8514)
> [2010/02/05 10:40:51,  0] param/loadparm.c:8546(process_usershare_file)
>   process_usershare_file: stat of /var/lib/samba/usershares/qbdata
> failed.
> Permission denied
> 
> 
> ####################end of log file######################
> 
> Please let me know if you need any more information on this issue.
> I can easily repeat it on two seperate servers (both running 9.10)
> 
> Thanks
> Craig Ross
> 
> --
> To unsubscribe from this list go to the following URL and read the
> instructions:  https://lists.samba.org/mailman/options/samba