Financials 2.01-database on a linux server

Hi, we shared a volume on a linux-server with samba and tried to run a financials-2.01-database on this volume. With a client running Win98 this works fine. With a client running Windows 2000 something strange happens: the financials-client changes the file access permissions of the database from rwxrwxrwx to r-----rwx => financials can not open the database!!! Some ideas?

Which version of samba are you useing it should be 2.2.X (where X should be 2 but 1 or 1a will not hurt). What security method are you useing if you are part of a domain then use domain security. You can change the permissions of the file from NT by right clicking it and setting the permissions, try that. Does the user have execute permissions of the directory that the file is in. Paul Baxter

We are using samba 2.2.1a. The share is a guest-share with all rights (every other file e.g. a plain text-file or a word-document works fine).

Hi all, sorry for that question but I am a complete Linux newbie, and reading through the Linux posts, I got the idea that Financials does not run on Linux without any major efforts… (odbc bridges…) mainly linux has been used on webservers for webshops and some tables have been duplicated… but now… …this means you are running a Navision Server on a linux box, or do you “just” save the database on that drive… would be a very economic solution to have financials running on a linux server, without having to pay a W2k licence… Thanks a lot for this aclaration. Saludos Nils Edited by - nilsm on 2002 Jan 23 21:13:43

Hi Nils, we (our customer) “just” want to save the database on the linux-samba-drive.

Sorry for not getting back sooner but I do have a job to do, which gets in the way some times. I have tried it here with Samba 2.2.2 with NT,2000 and XP and all works no problem. The only thing I can think of is the user that is logged in to the samba server. Again can yo say which permissions setting you are using samba on. Also can you create a file (any file) with each differnt system and see who the owner is and what the permissions are. I am sure we can get this cracked. Nils you can easily run one of Navisions unix servers under linux. If you want to run a client you would have to use wine which I have not tried at all. Paul Baxter

Hi Paul, thank you for your engagement! :slight_smile: Here the details: configuration in smb.conf [TESTSHARE] path = / guest ok = yes guest only = yes read only = no share modes = yes The file I created from the W2000-PC on the samba-drive has the following permissions: -rwxr–r-- nobody nogroup I can open, change and delete this file from the W2000-PC. I am no linux-guru - I can´t see the problem…

erm yes. having looked at this and put the database on a ext2 filesystem instaed of an smb share I have to agree with you that things look strange. You can create a database and use it, but you can not open a database. Navision sets the permissions of the database in such a way that it stops itself from being able to write to the database. That is the r-----rwx permission, but all is not lost try putting force security mode = 700 in your smb.conf file in the TMP section and restart the smb server. This security mode is then ORed with any changes to the security mode, I have been unable to try it. But that is the way to go I think. The other option is to use admin users = nobody which will make all users act with root permissions or better force user = somebody admin user = somebody But it is not a good idea to have users with root priverages, so we should use that only if we can not get any thing else to work. Look at the man page for smb.conf as it lists all the options. Hope this helps, Paul Baxter

Thanks for this info, haven’t thought of installing a unix Nav server on linux, will be worth a try… but I see that quite some linux knowledge is needed. Saludos Nils

Hi Paul, >force security mode = 700 in your smb.conf file in the TMP section I put it into the [global] section and it works! Thank you very much - if we ever meet us I’ll give you a beer (or two). :slight_smile:

Glad it worked at last. There is just so much that can be tweeked in samba, and knowing which to try is difficult. Samba does struggle trying to link windows security (??what security??) to the Unix model. I will take you up on the beer but Germany is a bit far to go. Paul Baxter

Dear Paul. When you say that you can easily run one of Navisions unix-servers under Linux, what does easily mean. I thought, that Navision had made different Unix-versions for a reason. Is it really - easilly - possible to run any Navision unix server by choice using Linux? Regards

Allan When you compile the kernal you have the option to compile in emulation modes for different flavors of unix. You have to do a couple of other things as well but the binaries will run. That is what I mean by easily. About a day so not so easy but possible and much cheaper than not having to pay the microsoft tax! Paul Baxter

ok I lied its not that easy. You need to run them on linux on the right type of processor . AIX = PowerPC HP-UX = RISC Relient = ??? So while what I read about running binaries on linux was correct you have to have it running on the correct machine. Does anybody know differently. I know I have run SCO and system V binaries on linux with out much trouble (well a days worth of trouble). Sorry to get everybodies hopes up by giving and off the cuff answer to an off topic question. I will look up what I say next time. Paul Baxter

And any way, in november 2000 Navision announced that they would discontinue support and development of all Unix-versions except AIX as of 1. january 2002. So if I should use Unix-Navision with Linux it would be the AIX-version, but unfortunately I don’t have a RS/6000 in my backyard, and it sounds impossible anyway. Life sucks Regards

thanks Paul for the further clarification on that matter… looks like burying this idea for the moment and waiting for further development by navision in that direction… Saludos Nils