Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-06 Thread Michael Sztachanski

Grant Parnell wrote:

 On Sat, 5 Jan 2002, Michael Sztachanski wrote:
 
 
 FYI,
 
 an running MYOB Premier 4.5+ at a clients premises. The Head Office 
 (Syd) has 5 accounts people, with another 2 connect via VPN from Melb., 
 with another 2 from Qld via VPN as well.
 
 Clients are M$ W98.
 
 File Server: Turbolinux 6.5 running samba (PCD)
 
 Firewall/routers: TL6.5
 
 VPN: FreeS/WAN over ADSL
 
 This site has been up and running for over 9mths with no corruption so far.
 
 regards
 
 Michael Sztachanski
 Snr. Tech. Engineer
 cell: 0410 547593
 
 
 Would you care to give details on the filesystem used, samba version and 
 the samba config you've got, just for reference?

MYOB data file is on a linux partition. samba version was 2.0.7 plus 
patches, have recently upgraded to 2.2.2 on my test box - very nice, 
will update production system need next week.

Will send you config. tomorrow when I fire up my laptop.

A little note for people who are supporting clients with MYOB on Linux 
--- MAKE SURE that your clients optimises the file regularly, as the 
MYOB dbase file is very flakey - try to get that at from their tech 
support, as some of you have found out.

cheers

Michael

-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



RE: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-06 Thread Steven Evans

 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

 Samba 2.0.7 patched - File server is PCD, DNS2, WINS and 
Which patches have you installed?  ie did you install a pam patch or
something different?

 dhcp.(will be going over to 2.2.2 soon - some nice things there).
yeah, hopefully v3 will come out soon too, winbind sounds like a step
forward.

 
 Clients logon to domain.
no domain environment, just a simple workgroup.

 
 Clients also have correct tcp/ip naming convention, with 
 Windows domain name different.
 ie sys1.domain.com.au, with windows domain not being domain 
 but kingdom, as windows
 screws up smb/netbios to tcp/ip. Richard Sharp's latest book 
 on Samba is very good
 (still waiting for John Terpstra to get off his ass and write his).
   
 
 ClientAcc.prm lives on Linux partition (ext2) in the share 
mine lives on a raid1 ext2 partition

 homes - will send smb.conf file latter as on laptop.
That would be nice.  I havnt tuned any file locking on this server,
so maybe that is what is what needs to be done?

 
 Have found the file locking ok, but what I have found is that 
 the MYOB dbase file .prm
 is very flakey - tested it on windoses NT  2000, I mean, 
 that the some problem occurs.
 The dbase file corrupts - especially as it gets bigger ie 
 200/300Mb +. So you need to
 make sure that your client - first on to logon optomises the 
 file first - or you can
 write a little script for when the user logs on to the domain.
Yeah we notice the same with a 150meg prm file.  Very unstable format
to store data, imho.


Cheers,
Steve

-BEGIN PGP SIGNATURE-
Version: PGP 7.0.1

iQA/AwUBPDkM5hMcfLgR5MndEQJYlQCgj7/zxLqT3r1FltNlS+Vxmqi0MVoAn3d6
uq+puqnBK0GzrKmgsJxua7Pn
=xmi5
-END PGP SIGNATURE-
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



RE: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-06 Thread Luke McKee


Very unstable format to store data, imho.

No it's commercial marketing. They want you to buy the commercial Premiere
edition where only one user locks the file and shares it through a
proprietary NETBIOS protocol? So how much money have you got to solve this
problem?

This is not a plug for MYOB :-)

Luke


-Original Message-
From: Steven Evans [mailto:[EMAIL PROTECTED]] 
Sent: Monday, 7 January 2002 1:50 PM
To: 'Michael Sztachanski'
Cc: 'Grant Parnell'; [EMAIL PROTECTED]
Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB ???

 
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



RE: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-06 Thread Steven Evans

 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

The workstations use MYOB Premier 5.0.2 (atleast, they get update
notices via email and download the patches over the web).

The workstations have been told to use TCP/IP as the communications
method.

Not enough money, sorry, maybe these features/bugs are fixed in MYOB
Accountants office, maybe?  If i had enough time to code a
linux-based myob solution, i would think about it ...

Cheers,
Steve

 -Original Message-
 From: Luke McKee [mailto:[EMAIL PROTECTED]]
 Sent: Monday, 7 January 2002 4:26 PM
 To: Steven Evans
 Cc: '[EMAIL PROTECTED]'
 Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB ???
 
 
 
 Very unstable format to store data, imho.
 
 No it's commercial marketing. They want you to buy the 
 commercial Premiere
 edition where only one user locks the file and shares it through a
 proprietary NETBIOS protocol? So how much money have you got 
 to solve this
 problem?
 
 This is not a plug for MYOB :-)
 
 Luke
 
 
 -Original Message-
 From: Steven Evans [mailto:[EMAIL PROTECTED]] 
 Sent: Monday, 7 January 2002 1:50 PM
 To: 'Michael Sztachanski'
 Cc: 'Grant Parnell'; [EMAIL PROTECTED]
 Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB ???
 
  
 -- 
 SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
 More Info: http://lists.slug.org.au/listinfo/slug
 

-BEGIN PGP SIGNATURE-
Version: PGP 7.0.1

iQA/AwUBPDlTixMcfLgR5MndEQKtVQCePbkth2FhB3T3H6ePlfgpntGU2XMAoIAi
h68JW9b2oJYyRV6+MkjQ0pMs
=gRPI
-END PGP SIGNATURE-
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



RE: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-06 Thread Luke McKee

Steven,

Just the be more precise.
NetBIOS over TCP/IP.

They code it in NetBIOS so it works over IPX, TCP/IP, NETBEUI whatever crap
is laying around. Hey isn't that a really old version of MYOB you have
there?.. I think I've found another excuse for you to pay money? Commercial
non-plug...

Luke


-Original Message-
From: Steven Evans [mailto:[EMAIL PROTECTED]] 
Sent: Monday, 7 January 2002 6:52 PM
To: 'Luke McKee'
Cc: '[EMAIL PROTECTED]'
Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB ???

 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

The workstations use MYOB Premier 5.0.2 (atleast, they get update
notices via email and download the patches over the web).

The workstations have been told to use TCP/IP as the communications
method.

Not enough money, sorry, maybe these features/bugs are fixed in MYOB
Accountants office, maybe?  If i had enough time to code a
linux-based myob solution, i would think about it ...

Cheers,
Steve

 -Original Message-
 From: Luke McKee [mailto:[EMAIL PROTECTED]]
 Sent: Monday, 7 January 2002 4:26 PM
 To: Steven Evans
 Cc: '[EMAIL PROTECTED]'
 Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB ???
 
 
 
 Very unstable format to store data, imho.
 
 No it's commercial marketing. They want you to buy the 
 commercial Premiere
 edition where only one user locks the file and shares it through a
 proprietary NETBIOS protocol? So how much money have you got 
 to solve this
 problem?
 
 This is not a plug for MYOB :-)
 
 Luke
 
 
 -Original Message-
 From: Steven Evans [mailto:[EMAIL PROTECTED]] 
 Sent: Monday, 7 January 2002 1:50 PM
 To: 'Michael Sztachanski'
 Cc: 'Grant Parnell'; [EMAIL PROTECTED]
 Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB ???
 
  
 -- 
 SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
 More Info: http://lists.slug.org.au/listinfo/slug
 

-BEGIN PGP SIGNATURE-
Version: PGP 7.0.1

iQA/AwUBPDlTixMcfLgR5MndEQKtVQCePbkth2FhB3T3H6ePlfgpntGU2XMAoIAi
h68JW9b2oJYyRV6+MkjQ0pMs
=gRPI
-END PGP SIGNATURE-
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



RE: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-06 Thread Luke McKee

Steve,

Sorry. MYOB permier version 5 is latest.. I was thinking of their other
dummed down product. MYOB Accounting that's version 11 now.

God we shouldn't be talking about commercial products on the list I know.

More to the point commercial applications that access databases over SMB
shouldn't be trusted with Linux on my opinion.
I've seen a Samba server shred an address plus database at my work with
thousand of contacts. We did it as a test because it was rumored to have
happened at other offices overseas.

This sort of problem has been happening for years. Before Samba was big, I
remember in 97 Novell used to do the same thing with packet signing with
some dos applications that wrote to data files. The problem then too was to
do with locking over the network.

Luke


-Original Message-
From: Steven Evans [mailto:[EMAIL PROTECTED]] 
Sent: Monday, 7 January 2002 6:56 PM
To: 'Luke McKee'
Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB ???

 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

lol ;)

 -Original Message-
 From: Luke McKee [mailto:[EMAIL PROTECTED]]
 Sent: Monday, 7 January 2002 6:55 PM
 To: Steven Evans
 Cc: '[EMAIL PROTECTED]'
 Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB ???
 
 
 Steven,
 
 Just the be more precise.
 NetBIOS over TCP/IP.
 
 They code it in NetBIOS so it works over IPX, TCP/IP, NETBEUI 
 whatever crap
 is laying around. Hey isn't that a really old version of MYOB you
 have there?.. I think I've found another excuse for you to pay 
 money? Commercial
 non-plug...
 
 Luke
 
 
 -Original Message-
 From: Steven Evans [mailto:[EMAIL PROTECTED]] 
 Sent: Monday, 7 January 2002 6:52 PM
 To: 'Luke McKee'
 Cc: '[EMAIL PROTECTED]'
 Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB ???
 
  
 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1
 
 The workstations use MYOB Premier 5.0.2 (atleast, they get update
 notices via email and download the patches over the web).
 
 The workstations have been told to use TCP/IP as the communications
 method.
 
 Not enough money, sorry, maybe these features/bugs are fixed in
 MYOB Accountants office, maybe?  If i had enough time to code a
 linux-based myob solution, i would think about it ...
 
 Cheers,
 Steve
 
  -Original Message-
  From: Luke McKee [mailto:[EMAIL PROTECTED]]
  Sent: Monday, 7 January 2002 4:26 PM
  To: Steven Evans
  Cc: '[EMAIL PROTECTED]'
  Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB
  ???  
  
  
  
  Very unstable format to store data, imho.
  
  No it's commercial marketing. They want you to buy the 
  commercial Premiere
  edition where only one user locks the file and shares it through
  a proprietary NETBIOS protocol? So how much money have you got 
  to solve this
  problem?
  
  This is not a plug for MYOB :-)
  
  Luke
  
  
  -Original Message-
  From: Steven Evans [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, 7 January 2002 1:50 PM
  To: 'Michael Sztachanski'
  Cc: 'Grant Parnell'; [EMAIL PROTECTED]
  Subject: RE: [SLUG] Linux not suitable as a fileserver for MYOB
  ???  
  
   
  -- 
  SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
  More Info: http://lists.slug.org.au/listinfo/slug
  
 
 -BEGIN PGP SIGNATURE-
 Version: PGP 7.0.1
 
 iQA/AwUBPDlTixMcfLgR5MndEQKtVQCePbkth2FhB3T3H6ePlfgpntGU2XMAoIAi
 h68JW9b2oJYyRV6+MkjQ0pMs
 =gRPI
 -END PGP SIGNATURE-
 

-BEGIN PGP SIGNATURE-
Version: PGP 7.0.1

iQA/AwUBPDlUcBMcfLgR5MndEQIOWgCfWNfymcJ4ocYK1vAqCU2bzLBIj7sAoPTk
IiTz91VhIlj8kNmnqoeaX20e
=vOeH
-END PGP SIGNATURE-
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-05 Thread Grant Parnell

On Sat, 5 Jan 2002, Michael Sztachanski wrote:

 FYI,
 
 an running MYOB Premier 4.5+ at a clients premises. The Head Office 
 (Syd) has 5 accounts people, with another 2 connect via VPN from Melb., 
 with another 2 from Qld via VPN as well.
 
 Clients are M$ W98.
 
 File Server: Turbolinux 6.5 running samba (PCD)
 
 Firewall/routers: TL6.5
 
 VPN: FreeS/WAN over ADSL
 
 This site has been up and running for over 9mths with no corruption so far.
 
 regards
 
 Michael Sztachanski
 Snr. Tech. Engineer
 cell: 0410 547593

Would you care to give details on the filesystem used, samba version and 
the samba config you've got, just for reference?

-- 
---GRiP--- 
Web: www.arcadia.au.com/gripz 
Phone/fax: 02 4950 1194   
Mobile: 0408 686 201

-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



RE: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-05 Thread Steven Evans

Could you make the reply to this post public for all of us to see. 

All the research done on this topic on google comes up with one response:
myob has left a bug in their product to stop multiple users (1 is ok, 1  is
bad and reduce to crawl) from using linux as the file server of their .prm
files.  

Slackware 7.1, samba 2.0.7, tcp as the protocol used (not ipx).

Cheers,
Steve


 -Original Message-
 From: Grant Parnell [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, 5 January 2002 11:26 PM
 To: Michael Sztachanski
 Cc: [EMAIL PROTECTED]
 Subject: Re: [SLUG] Linux not suitable as a fileserver for MYOB ???
 
 
 On Sat, 5 Jan 2002, Michael Sztachanski wrote:
 
  FYI,
  
  an running MYOB Premier 4.5+ at a clients premises. The Head Office 
  (Syd) has 5 accounts people, with another 2 connect via VPN 
 from Melb., 
  with another 2 from Qld via VPN as well.
  
  Clients are M$ W98.
  
  File Server: Turbolinux 6.5 running samba (PCD)
  
  Firewall/routers: TL6.5
  
  VPN: FreeS/WAN over ADSL
  
  This site has been up and running for over 9mths with no 
 corruption so far.
  
  regards
  
  Michael Sztachanski
  Snr. Tech. Engineer
  cell: 0410 547593
 
 Would you care to give details on the filesystem used, samba 
 version and 
 the samba config you've got, just for reference?
 
 -- 
 ---GRiP--- 
 Web: www.arcadia.au.com/gripz 
 Phone/fax: 02 4950 1194   
 Mobile: 0408 686 201
 
 -- 
 SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
 More Info: http://lists.slug.org.au/listinfo/slug
 
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-04 Thread Michael Sztachanski

FYI,

an running MYOB Premier 4.5+ at a clients premises. The Head Office 
(Syd) has 5 accounts people, with another 2 connect via VPN from Melb., 
with another 2 from Qld via VPN as well.

Clients are M$ W98.

File Server: Turbolinux 6.5 running samba (PCD)

Firewall/routers: TL6.5

VPN: FreeS/WAN over ADSL

This site has been up and running for over 9mths with no corruption so far.

regards

Michael Sztachanski
Snr. Tech. Engineer
cell: 0410 547593

--

Russell Ashdown wrote:

 Netware incorporates proprietary system calls that can be utilised 
 by developers for file locking. date retrieval and many other 
 functions.  If you are using mars-nwe the Netware server emulator, 
 it may be that not all these system calls are supported.  The calls 
 themselves have changed since Netware 3.11 (which mars-nwe 
 emulates).  This may be the source of your problem.
 
 Further, if this is the source of your problem, and you are able to 
 get a test system running MYOB, it is likely that if MYOB works 
 fine with a single workstation it will not ALWAYS work well in multi-
 user mode, it is important that you emulate the customers 
 environment.  You will need to test using simultaneous input from 
 multiple workstations, and attempt to cause file read/write 
 collisions.  While I have no knowledge of MYOB, my experience 
 with other databases running on Netware servers indicates that file 
 locking failure (and file unlocking failure) is a major cause of 
 database corruption and deadly embrace causing user abort and 
 further file and database corruption.
 
 Sad as it may seem, if MYOB will NOT support their product on a 
 Linux server running a Netware emulator, you would be very foolish 
 to proceed.  File corruption in an accounting database can be 
 extremely costly for the client (and, ultimately for you if you 
 recommend they ignore MYOB and proceed).
 
 Why not downsize (remove all applications) the existing Netware 
 server and leave ONLY MYOB on it?  Then install a second, more 
 powerful Linux machine configured as a mars-nwe server, to which 
 the users could authenticate and use as the general purpose 
 fileserver/applications server.  To my mind that would be the safest 
 alternative and should earn you kudos from your customer.
 
 On 2 Jan 2002, at 17:29, Vince Meissner wrote about:
 [SLUG] Linux not suitable as a fileserver for MYO
 
 
I've got a client that uses MYOB Accountant's Office.
It's a multi-user practice managment, time billing, invoicing type
program.

They're looking at replacing their existing Novell server which is at
the end of it's life.
I had them sold on the idea of a Linux based server until we discovered
this little gem from MYOB's support pages.

**
Question
Is Accountants Office supported on a Linux Server?

Answer
No, Linux is not a compatible Network Operating System for Accountants
Office because of
fundamental incompatibilies in file and record locking within Linux and
is therefore not supported
under any circumstances.

Link:
http://myobaustralia.custhelp.com/cgi-bin/myobaustralia.cfg/php/enduser/std_adp.php?p_sid=*kRtyb4gp_lva=010130-51p_refno=010130-

 
51p_created=980896579p_sp=cF9ncmlkc29ydD0mcF9yb3dfY250PTImcF9zZWFyY2hfdGV4dD1saW51eCZwX3NlYXJjaF90eXBlPTYmcF9wcm9kX2x2bDE9OSZwX3Byb2RfbHZsMj1_YW55fiZwX2NhdF9sdmwxPX5hbnl_JnBfc29ydF9ieT1kZmx0JnBfcGFnZT0xp_li=
 
 snip
 


-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-03 Thread Scott Howard

On Wed, Jan 02, 2002 at 11:55:52PM +1100, Vince Meissner wrote:
 To clarify,  I am looking at using samba not the netware emulator.
 The other reason for upgrading is that they have reached the user limits of
 their netware licence and will need to upgrade regardless (25 user, NW 4.10)
 so removing load from the existing server will not be a solution.
 
 The big problem is that magical word support,  If MYOB don't support Linux
 and the customer has problems with MYOB on linux, then MYOB can (and do) say
 sorry it's your network, not our software.

... and historically they would have been right.

The issues of MYOB and Samba has been discussed on this and most every other
Linux and Samba mailing list.

In the past there have been a number of issues with Samba and MYOB, ranging
from inability to run MYOB in multiuser mode up to corruption of data files.
These issues have been solved by patches to Samba.

Even if these issues have been resolved, cant you see why MYOB wouldn't want
to support Linux?

  Scott.
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-02 Thread Russell Ashdown

Netware incorporates proprietary system calls that can be utilised 
by developers for file locking. date retrieval and many other 
functions.  If you are using mars-nwe the Netware server emulator, 
it may be that not all these system calls are supported.  The calls 
themselves have changed since Netware 3.11 (which mars-nwe 
emulates).  This may be the source of your problem.

Further, if this is the source of your problem, and you are able to 
get a test system running MYOB, it is likely that if MYOB works 
fine with a single workstation it will not ALWAYS work well in multi-
user mode, it is important that you emulate the customers 
environment.  You will need to test using simultaneous input from 
multiple workstations, and attempt to cause file read/write 
collisions.  While I have no knowledge of MYOB, my experience 
with other databases running on Netware servers indicates that file 
locking failure (and file unlocking failure) is a major cause of 
database corruption and deadly embrace causing user abort and 
further file and database corruption.

Sad as it may seem, if MYOB will NOT support their product on a 
Linux server running a Netware emulator, you would be very foolish 
to proceed.  File corruption in an accounting database can be 
extremely costly for the client (and, ultimately for you if you 
recommend they ignore MYOB and proceed).

Why not downsize (remove all applications) the existing Netware 
server and leave ONLY MYOB on it?  Then install a second, more 
powerful Linux machine configured as a mars-nwe server, to which 
the users could authenticate and use as the general purpose 
fileserver/applications server.  To my mind that would be the safest 
alternative and should earn you kudos from your customer.

On 2 Jan 2002, at 17:29, Vince Meissner wrote about:
[SLUG] Linux not suitable as a fileserver for MYO

 I've got a client that uses MYOB Accountant's Office.
 It's a multi-user practice managment, time billing, invoicing type
 program.
 
 They're looking at replacing their existing Novell server which is at
 the end of it's life.
 I had them sold on the idea of a Linux based server until we discovered
 this little gem from MYOB's support pages.
 
 **
 Question
 Is Accountants Office supported on a Linux Server?
 
 Answer
 No, Linux is not a compatible Network Operating System for Accountants
 Office because of
 fundamental incompatibilies in file and record locking within Linux and
 is therefore not supported
 under any circumstances.
 
 Link:
 
http://myobaustralia.custhelp.com/cgi-bin/myobaustralia.cfg/php/enduser/std_adp.php?p_sid=*kRtyb4gp_lva=010130-51p_refno=010130-
51p_created=980896579p_sp=cF9ncmlkc29ydD0mcF9yb3dfY250PTImcF9zZWFyY2hfdGV4dD1saW51eCZwX3NlYXJjaF90eXBlPTYmcF9wcm9kX2x2bDE9OSZwX3Byb2RfbHZsMj1_YW55fiZwX2NhdF9sdmwxPX5hbnl_JnBfc29ydF9ieT1kZmx0JnBfcGFnZT0xp_li=
 
snip

-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-02 Thread Vince Meissner

To clarify,  I am looking at using samba not the netware emulator.
The other reason for upgrading is that they have reached the user limits of
their netware licence and will need to upgrade regardless (25 user, NW 4.10)
so removing load from the existing server will not be a solution.

The big problem is that magical word support,  If MYOB don't support Linux
and the customer has problems with MYOB on linux, then MYOB can (and do) say
sorry it's your network, not our software.

Also, if you do a search for linux on MYOB's website you get a total of 2 articles,
this one and another on myob premier which basically says don't use it with a linux 
server.
Mind you the same article also advocates disabling virus software on the fileserver to 
increase performance and reliability
so I'm not too confident with the level of technical expertise...

-Vince


Russell Ashdown wrote:

 Netware incorporates proprietary system calls that can be utilised
 by developers for file locking. date retrieval and many other
 functions.  If you are using mars-nwe the Netware server emulator,
 it may be that not all these system calls are supported.  The calls
 themselves have changed since Netware 3.11 (which mars-nwe
 emulates).  This may be the source of your problem.

 Further, if this is the source of your problem, and you are able to
 get a test system running MYOB, it is likely that if MYOB works
 fine with a single workstation it will not ALWAYS work well in multi-
 user mode, it is important that you emulate the customers
 environment.  You will need to test using simultaneous input from
 multiple workstations, and attempt to cause file read/write
 collisions.  While I have no knowledge of MYOB, my experience
 with other databases running on Netware servers indicates that file
 locking failure (and file unlocking failure) is a major cause of
 database corruption and deadly embrace causing user abort and
 further file and database corruption.

 Sad as it may seem, if MYOB will NOT support their product on a
 Linux server running a Netware emulator, you would be very foolish
 to proceed.  File corruption in an accounting database can be
 extremely costly for the client (and, ultimately for you if you
 recommend they ignore MYOB and proceed).

 Why not downsize (remove all applications) the existing Netware
 server and leave ONLY MYOB on it?  Then install a second, more
 powerful Linux machine configured as a mars-nwe server, to which
 the users could authenticate and use as the general purpose
 fileserver/applications server.  To my mind that would be the safest
 alternative and should earn you kudos from your customer.

-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: I can feel it in my water (Was: [SLUG] Linux not suitable as a fileserver for MYOB ???)

2002-01-02 Thread John Clarke

On Thu, Jan 03, 2002 at 10:25:13AM +1100, Peter Hardy wrote:
 On Wed, 2002-01-02 at 18:16, Jeff Waugh wrote:
  If pain persists, please read the man page, it's a much better reference
  than my blabber. ;)
 
 Am I the only one who read this as bladder?

No, but it didn't seem strange that Jeff was using his bladder as a
reference ...

-- 
whois [EMAIL PROTECTED]
GPG key id: 0xD59C360F
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-02 Thread David Kempe

 The big problem is that magical word support,  If MYOB don't support
Linux
 and the customer has problems with MYOB on linux, then MYOB can (and do)
say
 sorry it's your network, not our software.

I think that this problem is a bit of a myth. Experience with these software
vendors shows that they can all to readily blame your network anyway. Often
the client will get best support if you troubleshoot the problem yourself
(being familiar with the entire setup) rather than some lame MYOB tech who
only knows about the MYOB manuals. Running a Linux server probably just
means you get involved a bit earlier in the support process. I'm pretty sure
a recent version of samba can pretty much completely emulate an NT 4 file
server barring some domain controller functions. Just tell you client to
call you first then MYOB second - you should be able to tell the difference
between an MYOB problem and a network problem. Hey if they get really stuck,
get em to call us :)

Thanks,

Dave


-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



[SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-01 Thread Vince Meissner

I've got a client that uses MYOB Accountant's Office.
It's a multi-user practice managment, time billing, invoicing type
program.

They're looking at replacing their existing Novell server which is at
the end of it's life.
I had them sold on the idea of a Linux based server until we discovered
this little gem from MYOB's support pages.

**
Question
Is Accountants Office supported on a Linux Server?

Answer
No, Linux is not a compatible Network Operating System for Accountants
Office because of
fundamental incompatibilies in file and record locking within Linux and
is therefore not supported
under any circumstances.

Link:
http://myobaustralia.custhelp.com/cgi-bin/myobaustralia.cfg/php/enduser/std_adp.php?p_sid=*kRtyb4gp_lva=010130-51p_refno=010130-51p_created=980896579p_sp=cF9ncmlkc29ydD0mcF9yb3dfY250PTImcF9zZWFyY2hfdGV4dD1saW51eCZwX3NlYXJjaF90eXBlPTYmcF9wcm9kX2x2bDE9OSZwX3Byb2RfbHZsMj1_YW55fiZwX2NhdF9sdmwxPX5hbnl_JnBfc29ydF9ieT1kZmx0JnBfcGFnZT0xp_li=

**


Upon reading this I immediately thought What the !?
Lets not worry about all those thousands of businesses sucessfully using
Linux as a filesserver,
this one program doesn't work with it and of course it's a Linux problem
?
Wouldn't be sloppy coding of the program would it by any chance would
it?

Comments anyone ?


-Vince


-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-01 Thread David Kempe

 Comments anyone ?

We have a couple of clients not to mention our own internal systems running
myob fine off a file server.
I'm sure any samba feature that you have problems with can be configured
away anyway.

I would not worry at all, if you client needs references from business using
MYOB on a samba server get in touch with me I can help :)

Dave


-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-01 Thread Andre Pang

On Wed, Jan 02, 2002 at 05:29:59PM +1100, Vince Meissner wrote:

 **
 Question
 Is Accountants Office supported on a Linux Server?
 
 Answer
 No, Linux is not a compatible Network Operating System for Accountants
 Office because of
 fundamental incompatibilies in file and record locking within Linux and
 is therefore not supported
 under any circumstances.
 
 Link:
 
http://myobaustralia.custhelp.com/cgi-bin/myobaustralia.cfg/php/enduser/std_adp.php?p_sid=*kRtyb4gp_lva=010130-51p_refno=010130-51p_created=980896579p_sp=cF9ncmlkc29ydD0mcF9yb3dfY250PTImcF9zZWFyY2hfdGV4dD1saW51eCZwX3NlYXJjaF90eXBlPTYmcF9wcm9kX2x2bDE9OSZwX3Byb2RfbHZsMj1_YW55fiZwX2NhdF9sdmwxPX5hbnl_JnBfc29ydF9ieT1kZmx0JnBfcGFnZT0xp_li=

I know nofink about samba, but these two URLs will be a starting
point:

http://www.google.com/search?q=cache:G8S3vmerLUM:lists.sage-au.org.au/pipermail/sage-au/2000-October/017600.html+linux+myob+locking+sambahl=en
http://www.google.com/search?q=cache:3HTteHFaeCI:lists.samba.org/pipermail/samba/2001-January/053119.html+linux+myob+lockinghl=en

Good luck!


-- 
#ozone/algorithm [EMAIL PROTECTED]  - trust.in.love.to.save
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-01 Thread admin

On Wed, Jan 02, 2002 at 05:29:59PM +1100, Vince Meissner wrote:
 I've got a client that uses MYOB Accountant's Office.
 It's a multi-user practice managment, time billing, invoicing type
 program.

An Accountant needing a special version of MYOB to run thier own practise? 
Oooh the irony... =)
 
 They're looking at replacing their existing Novell server which is at
 the end of it's life.
 I had them sold on the idea of a Linux based server until we discovered
 this little gem from MYOB's support pages.
 
 Upon reading this I immediately thought What the !?
 Lets not worry about all those thousands of businesses sucessfully using
 Linux as a filesserver,
 this one program doesn't work with it and of course it's a Linux problem
 ?
 Wouldn't be sloppy coding of the program would it by any chance would
 it?

My guess is this- It is not Samba which is the problem but it is other 
filesharing systems such as NFS which do not have the needed file/record
locking. They probably want to discourage as much cross-platform configurations
as possible in order to reduce end-user support costs.

It is not very logical that it works with a *OLD* Novell server but not with
a newer filesharing OS/protocol.

Regards,

Jon
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-01 Thread Jeff Waugh

quote who=David Kempe

  Comments anyone ?
 
 We have a couple of clients not to mention our own internal systems running
 myob fine off a file server.

Not hugely multi-user though.

 I'm sure any samba feature that you have problems with can be configured
 away anyway.

locking = yes (default)
posix locking = yes (default)
strict locking = yes (if you're *really* keen)
sync always = yes (if you're *really* keen)

If pain persists, please read the man page, it's a much better reference
than my blabber. ;) I don't really recommend the second two, but they may
help if you do hit screwups.

- Jeff

-- 
   I think we agnostics need a term for a holy war too. I feel all left
out. - George Lebl 
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-01 Thread Jeff Waugh

quote who=[EMAIL PROTECTED]

 It is not very logical that it works with a *OLD* Novell server but not
 with a newer filesharing OS/protocol.

It is logical, you're just looking at it from the protocol angle, not the
destination filesystem management angle. Newness doesn't imply
appropriateness.

- Jeff

-- 
  There's no horse higher, no mailing list taunt lower, no developer base   
  wider. Rock My Software in the Bosom of Debian.   
-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug



Re: [SLUG] Linux not suitable as a fileserver for MYOB ???

2002-01-01 Thread Howard Lowndes

Is this MYOB plain or MYOB Premier?

I haven't had the chance to try MYOB on a Linux server as the one client
of mine who uses MYOB Premier has just ditched me because he wanted to
upgrade to a M$ SBS server and I wasn't prepared to recommend it to him.
I guess the new consultant will have the chance to fleece him big time for
supporting M$.

What I have been successful with though is Attache on Linux and they say
that that is not supported on Linux, but it works fine.  The only caveat
is that shitty M$ programs are very non-deterministic about whether they
generate file names in upper or lower case.  It doesn't matter to M$ but
it does matter to Linux.  When doing a system compression in Attache this
can cause new files to be created with a case that is different from the
old files.  When Attache next gets run it is non-deterministic about which
file it uses, the upper case or the lower case file.  As you can imagine
this can stuff things up big time.  The answer is to make Samba force the
case, which is not difficult.

I wouldn't mind betting that this sort of problem is why MYOB say that it
is not supported on Linux, and that it is not a locking problem at all.

All I know, is my client whom I switched his Attache from a M$ server to a
Linux server couldn't be happier.

On Wed, 2 Jan 2002, Vince Meissner wrote:

 I've got a client that uses MYOB Accountant's Office.
 It's a multi-user practice managment, time billing, invoicing type
 program.

 They're looking at replacing their existing Novell server which is at
 the end of it's life.
 I had them sold on the idea of a Linux based server until we discovered
 this little gem from MYOB's support pages.

 **
 Question
 Is Accountants Office supported on a Linux Server?

 Answer
 No, Linux is not a compatible Network Operating System for Accountants
 Office because of
 fundamental incompatibilies in file and record locking within Linux and
 is therefore not supported
 under any circumstances.

 Link:
 
http://myobaustralia.custhelp.com/cgi-bin/myobaustralia.cfg/php/enduser/std_adp.php?p_sid=*kRtyb4gp_lva=010130-51p_refno=010130-51p_created=980896579p_sp=cF9ncmlkc29ydD0mcF9yb3dfY250PTImcF9zZWFyY2hfdGV4dD1saW51eCZwX3NlYXJjaF90eXBlPTYmcF9wcm9kX2x2bDE9OSZwX3Byb2RfbHZsMj1_YW55fiZwX2NhdF9sdmwxPX5hbnl_JnBfc29ydF9ieT1kZmx0JnBfcGFnZT0xp_li=

 **


 Upon reading this I immediately thought What the !?
 Lets not worry about all those thousands of businesses sucessfully using
 Linux as a filesserver,
 this one program doesn't work with it and of course it's a Linux problem
 ?
 Wouldn't be sloppy coding of the program would it by any chance would
 it?

 Comments anyone ?


 -Vince




-- 
Howard.
LANNet Computing Associates - Your Linux people
Contact detail at http://www.lannetlinux.com
 We are either doing something, or we are not.
 'Talking about' is a subset of 'not'.

-- 
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://lists.slug.org.au/listinfo/slug