[opensuse] weird permission prob w/oocalc
openSUSE Tumbleweed libreoffice-calc-4.1.3.2-4.2.x86_64 Weird thing happened on the way to the office today! 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. 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
Doesn't it write some lock file in the directory or something? Failure to remove those cause it to look locked. Patrick Shanahan <paka@opensuse.org> wrote:
openSUSE Tumbleweed libreoffice-calc-4.1.3.2-4.2.x86_64
Weird thing happened on the way to the office today!
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.
tks,
-- Sent from my Android phone with K-9 Mail. Please excuse my brevity. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
* John Andersen <jsamyth@gmail.com> [12-14-13 01:18]:
Patrick Shanahan <paka@opensuse.org> wrote: [...]
For quite a few years I have been editing a remote spreadsheet 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.
Doesn't it write some lock file in the directory or something? Failure to remove those cause it to look locked.
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". 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
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
* John Andersen <jsamyth@gmail.com> [12-14-13 16:02]:
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.
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. 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
* Patrick Shanahan <paka@opensuse.org> [12-14-13 16:08]:
* John Andersen <jsamyth@gmail.com> [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
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. -- Cheers / Saludos, Carlos E. R. (from 12.3 x86_64 "Dartmouth" at Telcontar)
* Carlos E. R. <robin.listas@telefonica.net> [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
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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). - -- _____________________________________ - ---This space for rent--- -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) iEYEARECAAYFAlKtEgkACgkQv7M3G5+2DLLJjACdHO4pAGYrAtqCwZ+bzecjTjsA tfQAnj6XxxA7jhcuZKRZTxoXRkYvXVgR =kKlc -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
* John Andersen <jsamyth@gmail.com> [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
* Patrick Shanahan <paka@opensuse.org> [12-14-13 22:16]: [...]
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.
That failed also :^( -- (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)
[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? Which options are used to mount? What is shown the line of the respective share, when "mount" is run without parameters? Werner -- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
* Werner Flamme <werner.flamme@email.de> [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
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
tks,
Patrick, 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. -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
* David C. Rankin <drankinatty@suddenlinkmail.com> [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
On 12/14/2013 08:06 AM, Patrick Shanahan wrote:
openSUSE Tumbleweed libreoffice-calc-4.1.3.2-4.2.x86_64
Weird thing happened on the way to the office today!
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 ? ............ regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
* ellanios82 <ellanios82@gmail.com> [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
ellanios82 <ellanios82@gmail.com> wrote:
On 12/14/2013 08:06 AM, Patrick Shanahan wrote:
openSUSE Tumbleweed libreoffice-calc-4.1.3.2-4.2.x86_64
Weird thing happened on the way to the office today!
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 ?
............
regards
--
That wouldn't prevent opening the sheet, and protected sheets are honored by gnumeric as well. 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. These are created when you open a document, and are supposed to be deleted when you close it. But sometimes this fails. So even a Windows machine will lock the same way. They are honored across platforms. 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. -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. -- 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
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? -- 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
* John Andersen <jsamyth@gmail.com> [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
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Saturday, 2013-12-14 at 01:06 -0500, Patrick Shanahan wrote:
openSUSE Tumbleweed
Then you should consider asking in the factory mail list ;-) - -- Cheers, Carlos E. R. (from 12.3 x86_64 "Dartmouth" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (GNU/Linux) iEYEARECAAYFAlKsf0MACgkQtTMYHG2NR9X+egCfQFjN0D4eep+nwyEPqItqsYoO Y0EAnRyllkvy1eWQk03EAKTF1VSNOE4F =7ClS -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (6)
-
Carlos E. R. -
David C. Rankin -
ellanios82 -
John Andersen -
Patrick Shanahan -
Werner Flamme