[opensuse] Open Office Database Files, cifs and samba
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 In rebuilding my machine after a crash I decided to try out mounting with cifs from samba, to avoid having to load both NFS and samba. I have hit a rather peculiar problem. When opening various Openoffice Database odb files that include queries and forms I find that the Forms and queries have disappeared and the database connection information goes awol. After various experiments I have found this happens when the odb file is stored to the cifs mount but not when I store the odb on the local file system. Documents seem to load and save without corruption (I have not checked other things yet). These worked without problem from a NFS mount before, and so far this only issue with the cifs mount I have found, but for me it is a bit of a showstopper. So far copying the the original odb files across directly from the cifs mount generates no problems, but I do not want to store these files locally. I have come across no references to this particular problem in searching. My samba config is now not entirely sane with the various things I have tried out and before I ditch the idea as unworkable, I am just wondering whether anyone else has come across this, and if so did they fix it (and how)?. - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFGkqSEasN0sSnLmgIRAte/AJ4wWbt1w5tPqXxMO7irex+NT5kTrwCdHyC6 RTfjfaCSiBzzCx5e8zEYUBM= =70xG -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 G T Smith wrote:
I have hit a rather peculiar problem. When opening various Openoffice Database odb files that include queries and forms I find that the Forms and queries have disappeared and the database connection information goes awol. After various experiments I have found this happens when the
< snip >
So far copying the the original odb files across directly from the cifs mount generates no problems, but I do not want to store these files locally.
I have come across no references to this particular problem in searching. My samba config is now not entirely sane with the various things I have tried out and before I ditch the idea as unworkable, I am just wondering whether anyone else has come across this, and if so did they fix it (and how)?.
Just to make live more interesting just did the online update which included a kernel patch.... which seems to have broken cifs mounting completely.... The contents of... /proc/fs/cifs ... had been set to read only, and had to be reset read/write so I could get the following debug output...
Jul 10 17:04:21 GTSSony kernel: CIFS VFS: cifs_mount failed w/return code = -111 Jul 10 17:08:00 GTSSony kernel: fs/cifs/cifsfs.c: Devname: //GTSDual.gtshome/Downloads flags: 64 Jul 10 17:08:00 GTSSony kernel: fs/cifs/connect.c: CIFS VFS: in cifs_mount as Xid: 10 with uid: 0 Jul 10 17:08:00 GTSSony kernel: fs/cifs/connect.c: Username: grahamsmith Jul 10 17:08:00 GTSSony kernel: fs/cifs/connect.c: UNC: \\GTSDual.gtshome\Downloads ip: 192.168.0.20 Jul 10 17:08:00 GTSSony kernel: fs/cifs/connect.c: Socket created Jul 10 17:08:00 GTSSony kernel: fs/cifs/connect.c: Error -111 connecting to server via ipv4 Jul 10 17:08:00 GTSSony kernel: CIFS VFS: Error connecting to IPv4 socket. Aborting operation Jul 10 17:08:00 GTSSony kernel: fs/cifs/connect.c: CIFS VFS: leaving cifs_mount (xid = 10) rc = -111 Jul 10 17:08:00 GTSSony kernel: CIFS VFS: cifs_mount failed w/return code = -111
now before the kernel update this was not a problem :-( The samba server is receiving nothing so the connection is now broken at this end somewhere.... If anyone else is using cifs be warned....got to look at this further. grrrrr..... - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFGk7NqasN0sSnLmgIRAgiVAJ0d0H6qj4LfQbfoYh0Z2izZcPXnVACghAR5 IJ4MmG3zwC8QLOFcW7vnTTA= =CJKR -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Which kernel and which distribution is this? This should be filed in bugzilla... Andreas -- Andreas Jaeger, Director Platform/openSUSE, aj@suse.de SUSE LINUX Products GmbH, GF: Markus Rex, HRB 16746 (AG Nürnberg) Maxfeldstr. 5, 90409 Nürnberg, Germany GPG fingerprint = 93A3 365E CE47 B889 DF7F FED1 389A 563C C272 A126
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Andreas Jaeger wrote:
Which kernel and which distribution is this? This should be filed in bugzilla...
Andreas
openSuSE 10.2 Kernel Default 2.6.18.8-0.5 i586 online update from 2.6.18.8-0.3 Trying to find out bit more about what is going on. A quick look at the source seems to indicate something not right further down. Looks like I need to try to roll back the kernel to an earlier version if possible. Could you (or someone) pass this to bugzilla as may not be in position to do this for a bit. - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFGk74QasN0sSnLmgIRAlqDAJ9wvgZSKK57+ykfIMPBuVsH8DdrDgCdEfuD dwhPdwZQ/PuCVq4F/IlVklI= =jKa8 -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 G T Smith wrote:
I have hit a rather peculiar problem. When opening various Openoffice Database odb files that include queries and forms I find that the Forms and queries have disappeared and the database connection information goes awol. After various experiments I have found this happens when the odb file is stored to the cifs mount but not when I store the odb on the local file system. Documents seem to load and save without corruption (I have not checked other things yet).
After a diversion due to a problem with the latest kernel update and cifs, I have tried out the fusesmb support. Apart from the problem that this is incredibly slow, (it seems to go through a full authentication cycle for each operation), it did load the OpenOffice database files without any corruption problems. I got a similar result (but a lot faster), with a WIndowsXP connection. - From this it does seem that this is a problem specific to Openoffice and the Linux cifs implementation. After a little further work found that adding the OpenOffice files to the Oplock veto list on the samba server does seem to have solved the issue (for the moment). There are reports that oplocks cause problems in the windows world for some other usages so this seems to be a more general SMB/Windows networking problem anyway. - -- ============================================================================== I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone. Bjarne Stroustrup ============================================================================== -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFGlhK5asN0sSnLmgIRAoyYAJ9lt91ulUUaykQDgCHVIHYVCZaPZACfbaSm zJvV3U6GQRHaEPKCTqsltPY= =NVKO -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (2)
-
Andreas Jaeger
-
G T Smith