On 12/14/2013 05:58 AM, Patrick Shanahan wrote:

Yes, lock files were removed from the spreadsheet directory and the ~/.config/libreoffice/... directory before repeating attempt to edit but did not allow opening original, "Open Read-Only or Open Copy" or saving an "Open Copy".

Very strange. Only the lock in the document directory should affect this, because a lock in your .config structure would not be available to other users, defeating the purpose of a lock. If look at the linux attributes do the look in any way different? user or group changed by some other process? It said un-known user, right? Perhaps the file was changed by a user that is unknown on the current system (one of the biggest gotcha's in NFS). The only other thing off the top of my head would be if some how it became immutable (man chattr) for some reason. -- Explain again the part about rm -rf / -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

* Patrick Shanahan [12-14-13 16:08]:

* John Andersen [12-14-13 16:02]: [...]

...

The only other thing off the top of my head would be if some how it became immutable (man chattr) for some reason.

I can test the unknown user by moving the remote file to local, opening in locally in oocalc and then saving or attempting to save it to the remote location.

mv /mnt/nfs/<remote>/Documents/<spreadsheet>.ods ./Documents/<spreadsheet>.ods opened with oocalc attempted to save to /mnt/nfs/<remote>/Documents/<spreadsheet>.ods "Error saving the document ######." "Error during shared access to /mnt/nfs/..../<spreadsheet>.ods" still no cigar :^( tks, -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

* Carlos E. R. [12-14-13 20:23]:

On 2013-12-14 22:18, Patrick Shanahan wrote:

...

still no cigar :^(

I assume that you can write files on the nfs directory, just not with libreooffice. I have seen often reports in the past about openoffice having problems writing to network locations, but typically it was using samba rather than nfs.

yes, I have <user> and root rwx to all ... tks, -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

* John Andersen [12-14-13 21:23]:

On 12/14/2013 5:20 PM, Carlos E. R. wrote:

...

On 2013-12-14 22:18, Patrick Shanahan wrote:

...

still no cigar :^(

I assume that you can write files on the nfs directory, just not with libreooffice. I have seen often reports in the past about openoffice having problems writing to network locations, but typically it was using samba rather than nfs.

I've never had a lick of trouble with OO over Samba.

We use Samba at work in preference to NFS simply to shed the need for keeping all group/user ids unique. (Not to mention there are still a few Windows machines around).

Well, I could but no more and nothing has changed samba wise. Gnumeric and calligra both work over smb. Next step will completely remove ~/.config/libreoffice and try. brb -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On 2013-12-15 03:20, John Andersen wrote:

On 12/14/2013 5:20 PM, Carlos E. R. wrote:

...

On 2013-12-14 22:18, Patrick Shanahan wrote:

...

still no cigar :^(

...

I assume that you can write files on the nfs directory, just not with libreooffice. I have seen often reports in the past about openoffice having problems writing to network locations, but typically it was using samba rather than nfs.

I've never had a lick of trouble with OO over Samba.

We use Samba at work in preference to NFS simply to shed the need for keeping all group/user ids unique. (Not to mention there are still a few Windows machines around).

But, as I say, several people have reported problems with samba and *office over the years. If they are reading, they'll comment. That you have not proves nothing, except that it can work, and that we don't know why it does or does not. -- Cheers / Saludos, Carlos E. R. (from 12.3 x86_64 "Dartmouth" at Telcontar)

* Werner Flamme [12-15-13 08:05]:

[15.12.2013 13:26] [Carlos E. R.]:

...

But, as I say, several people have reported problems with samba and *office over the years. If they are reading, they'll comment.

Well, LibreOffice and SMB/CIFS shares sometimes do not work together well. Sometimes the "nobrl" option is required for working with mounts, sometimes you must remove it.

At the office, I just succeeded in re-enabling nobrl in order to save a changed file to the share - before adding, it simply told me that it was impossible to create a safety copy and thus saving the file was aborted - unless I chose to save the file with another name. The shares are provided by a HNAS as described on http://www.hds.com/products/file-and-content/network-attached-storage/, so very little influence possible on the server side...

I thought of this, but I'm not aware of a "nobrl" option in NFS. Here I'd guess of a idmapd problem first, as this caused my problems with NFSv4. I did not find the info about the used NFS version in this thread.

Patrick tested with moving a file from NFS to local, editing it and trying to save it back to the NFS share. Does it work to save it locally and copy/move it back to the share?

Yes, I can read/write/delete/... any file in the nfs directory over ssh w/o a problem. Gnumeric can read/alter/write the same files. OO cannot open as write-able *any* file in the nfs share.

Which options are used to mount? What is shown the line of the respective share, when "mount" is run without parameters?

server: rw,no_root_squash,sync,no_subtree_check client: defaults tks, -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

* David C. Rankin [12-17-13 15:03]:

On 12/16/2013 09:23 PM, Patrick Shanahan wrote:

...

Yes, I can read/write/delete/... any file in the nfs directory over ssh w/o a problem. Gnumeric can read/alter/write the same files. OO cannot open as write-able *any* file in the nfs share.

...

...

Which options are used to mount? What is shown the line of the respective share, when "mount" is run without parameters? server: rw,no_root_squash,sync,no_subtree_check client: defaults

The only thing I can think of is that the umask is getting screwed up by one of the filesystems mounts you are working over. No, I don't have a silver-bullet for you, but find a way to confirm that the umask you get when accessing the remote FS isn't causing your file permissions to be off. The only experience I have with them is with ftp. There, if you don't have the correct mask set when accessing remote files, you see issues similar to what you are describing. HTH.

But wouldn't file masks cause similar problem with other apps accessing files? tks, -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

* ellanios82 [12-14-13 08:55]:

On 12/14/2013 08:06 AM, Patrick Shanahan wrote: [...]

...

For quite a few years I have been editing a remote spreadsheed with oocalc over nfs. This afternoon I began getting notice that the file was locked by "unknown user" and I could open a copy or ... But I am unable to save the file back to it's correct location (over nfs).

I can open the same file with gnumeric, edit and save it. What has happened to libreoffice-calc?

Reinstalling the entire libreoffice package made no difference. Present version was first installed about a month ago and, until today, has functioned properly afaict.

---

- unlikely but : maybe, Tools --> Protect Document --> Sheet ?

Not set ?? tks, -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

That wouldn't prevent opening the sheet, and protected sheets are honored by gnumeric as well.

I understand this, tks. Sheets are *not* protected.

There is most likely a hidden file in the same directory that begins with a dot (.lock....). The part following "lock" will be the document file name. This is how OO knows the file is locked even before it opens it.

[...] There are *no* lock files.

However gnumeric does not use the same locking mechanism, so it ignored the lock. It's s simple matter of looking for hidden .lock files and deleting them.

Didn't realize that but still, there are *no* lock files. In order to make certain that I have not missed a "lock" file, I tried to access another nfs file in a different remote directory which I have never opened with any libreoffice app (created a *new* text file) with the same result. tks, -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

* John Andersen [12-14-13 16:05]:

On 12/14/2013 12:56 PM, Patrick Shanahan wrote:

...

Didn't realize that but still, there are *no* lock files.

In order to make certain that I have not missed a "lock" file, I tried to access another nfs file in a different remote directory which I have never opened with any libreoffice app (created a *new* text file) with the same result.

Whoa, so you can replicate this on demand? What about on a local drive?

nfs users and groups numbers match your machine's user/groups?

there is no nfs user/group users, groups and id#'s match accross machines -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri http://wahoo.no-ip.org Photo Album: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org