[libreoffice-users] Re: Vector Graphics in PDF
Berengar Lehr wrote: Hy, I'm asking if anyone could provide me with a list of vector graphics formats that can be used in ODT _and_ that will be exported as vector graphic. SVG e.g. is not a valid example: while it can be used in ODT, SVG will be rasterized during conversion to PDF. ODG on the other hand works for both. WMF/EMF work for both but I could not find *nix libs for these microsoft formats. Any other ideas? In the ideal case the source would be svg and I would import that into Draw. Currently this conversions does not goes 100% perfect (like closed shapes become open and because of that don't fill). At this time importing pdf goes pretty good in most cases. If needed I do some touch ups in Draw and then paste the whole thing into Writer (as a Draw object, so you need to 'paste as'). This procedure seems to work well even for complex stuff like Autocad drawings (dxf), and PCB layouts (gerber files) Thank you, waiting patiently, Ber -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: documentation for LO base
I agree. I use it at the office for time registration and invoicing. At home for the Taekwon-do club membership. It's actually marvelous in combination with postgresql SDBC driver. And actually useful as it is so easy to get your data to Calc, more useful then I remember Access. It always hurts a bit when people who don't use databases say that Base is not good, databases are not useful etc. I know a lot of people that never use a spreadsheet either. But I think LO wouldn't be complete with Calc or Base. My experience: de builtin hsql backend was very slow last time I tried, sqlite unusefull, mysql OK but I couldn't find anything like PG Admin to administer it. So, if you have the choice, go for postgresql. Ferry Wolfgang Keller schreef op za 06-10-2012 om 21:34 [+0200]: I am going to stick my head above the parapet and say it should have an embedded database functionality that is secure and reliable. Since recently, LO comes with a native driver for PostgreSQL. That's probably the best thing that the LO developers have done for quite some time. Since it makes LO Base actually useable *and a lot better* than Access (which is unusable with PostgreSQL). That is an essential requirement for entry-level users that have only ever used Access. Reliability? As an essential requirement for Access users? Huh? Access is a pathological data shredder. Sincerely, Wolfgang -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Re: SQL statement in Base query
Did you try with another database as a backend? I like postgres as a backend a lot. Ferry Dan schreef op wo 18-07-2012 om 16:40 [-0400]: Andreas Säger wrote: On this simple level I would consider HSQLDB as free of bugs whereas the primitive Base parser fails in many different ways. Did you try the direct SQL mode (SQL view, menu:EditRun SQL directly)? If you get reasonable result in direct mode, it is one of many bugs in the Base's SQL parser. -- View this message in context: http://nabble.documentfoundation.org/SQL-statement-in-Base-query-tp3996273p3996282.html Sent from the Users mailing list archive at Nabble.com. That is the one thing that I forgot to mention: I get the same message when using direct SQL mode. I even tried using Tools SQL, but with the same message. --Dan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Sending mail merged document to email
My provider uses TLS on the SMTP server which is on port 25. When I select that server from LO, check use SSL, type in user name and password under server verification and the click on test settings I get the window showing that it passed. Are you sure TLS is not working? Or is my provider supporting both SSL and TLS? Ferry Gordon Burgess-Parker schreef op wo 11-04-2012 om 08:03 [+0100]: On 09/04/2012 13:01, Gordon Burgess-Parker wrote: LO 3.5.2.2 I am trying to send a mail-merged document direct to email and some rather baffling occurrences present themselves. 1. It seems that LO uses it's own mail sending function rather than the default email client that is installed on my machine! What on earth is that all about? Why doesn't it just call my default email client? 2. As my email address is GMail, the GMail smtp server uses TLS authentication. There is NO option to select TLS for the sept server in the built-in LO mailing function. So it seems that I cannot mail merge a document from LO direct to email. Great. OK, if no-one's going to respond to this, where do I file a bug for this? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: XML as mailmerge data source?
A long time ago (before I abandoned windows) I used MSDAC and oledb. M$ had a connector thingy to use XML as a row source. A simpler way to say this is that XML get converted into a table, with the deeper nested tags stored in a cell. So you could drill down in the data by getting the XML data from a cell and use that again to get a table. I guess that might work with ODBC and thus with LO on windows. Ferry Mark Stanton schreef op za 31-03-2012 om 20:38 [+0100]: That's a sufficiently good-English explanation. I've got a very simple XML file that I'd like to use, which is why I hadn't thought about the wider issue. Just need to be a database engine that uses XML files... And package it with Base... :-s Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc DATEVALUE() accepts only locale format
Thanks Brian, This exactly how I solved it. But cumbersome given that DATEVALUE seems to be intended to do just this. Thanks, Ferry Brian Barker schreef op ma 05-03-2012 om 00:32 [+]: At 22:35 04/03/2012 +0100, Ferry Toth wrote: With the dutch localization DATEVALUE accepts 1-jan-2011 and 1-mrt-2011 (correct dutch format) but not 1-mar-2011 (english US) regardless if I set the standard language for the document to English US or not. Only if I set the 'locale setting' to US does it accept 1-mar-2011. I am trying make sense of some weird data format (2011MAR) which is English based. To me that seems a common situation, and I would not want to change the LO global localization settings as that changes all date formats in the spreadsheet to english. Couldn't datavalue take the locale of the formatted cell? Or is there a better trick to ge this done? If you cannot find a direct way of doing this sort of thing, you can always do the conversion yourself explicitly. It's no doubt sensible for you to keep Dutch settings, so you will probably need to write up the English month name abbreviations. Construct a table of these, with JAN, FEB, MAR, and so on in one column and the numbers 1 to 12 in the next column to the right. Select all twenty-four cells, go to Insert | Names | Define..., and give the table a name - perhaps Months. Suppose your value 2011MAR is in A1. Try this formula: =DATE(LEFT(A1;4);VLOOKUP(RIGHT(A1;3);Months;2;0);1) The LEFT() function takes the first four characters as the year. The RIGHT() function takes the last three characters, and the VLOOKUP() function looks these up in the Months list to produce a month number. These are combined by DATE() to give the first of the relevant month. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc DATEVALUE() accepts only locale format
With the dutch localization DATEVALUE accepts 1-jan-2011 and 1-mrt-2011 (correct dutch format) but not 1-mar-2011 (english US) regardless if I set the standard language for the document to English US or not. Only if I set the 'locale setting' to US does it accept 1-mar-2011. I am trying make sense of some weird data format (2011MAR) which is English based. To me that seems a common situation, and I would not want to change the LO global localization settings as that changes all date formats in the spreadsheet to english. Couldn't datavalue take the locale of the formatted cell? Or is there a better trick to ge this done? The same probably holds for other localized conversions as well. Ferry -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: How to create a custom control on a form?
Alex, The question really is: if LO is based on an 'object broker' as UNO, is there an easy way to add an object *without recompiling and building LO entirely*. Like with ActiveX controls: once you've created one and 'registered' it you can put them on any ActiveX container and if you have a scripting language available can actually make the control do some useful work. Let's say I steel the code of Evolutions calendar window, can I build a standalone control from that, register it with UNO, place it on a form and fill it with data from Base? Ferry Alex Thurgood schreef op vr 02-03-2012 om 08:40 [+0100]: Le 01/03/2012 23:38, Ferry Toth a écrit : Hi Ferry, Is there an easy way? Trick question : you know there isn't ;-) We would like to put an 'agenda' (like daily/weekly/monthly tasks) control on a Base form. Any suggestions? Errrm, the only thing I can think of offhand is a programmatically created multipage/tab dialog box. Do you have Roberto Benitez' book on Base programming ? I seem to recall it covers things like this. Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc broke my document
A spreadsheet (ods) I have been using a while broke, and now Calc won't open it. Also alternatives refuse to open it. Passing it through http://odf-validator.rhcloud.com/ led to the following result (note the *Fatal*) below. Now I know that I can unzip the document, search for the offending attribute, delete this and rezip - and of course that didn't work. The point is, in 6 years that I use OO, and LO intensively I never had this before. And recently I saw other mentions on this list of broken Calc spreadsheets. I think there is a regression in Calc. I am using LO 3.4.4 from Ubuntu. Ferry Validator results below *** The document is NOT conformant ODF1.2! Details: Betalingen 2012.ods: Info: ODF version of root document: 1.2 internal:/schema/odf1.2/OpenDocument-v1.2-cos01-manifest-schema.rng: Info: parsed. Betalingen 2012.ods/META-INF/manifest.xml: Info: no errors, no warnings Betalingen 2012.ods/mimetype: Info: no errors, no warnings Betalingen 2012.ods: Info: Media Type: application/vnd.oasis.opendocument.spreadsheet internal:/schema/odf1.2/OpenDocument-v1.2-cos01-schema.rng: Info: parsed. Betalingen 2012.ods/meta.xml: Info: Generator: LibreOffice/3.4$Unix LibreOffice_project/340m1$Build-402 Betalingen 2012.ods/meta.xml: Info: no errors, no warnings Betalingen 2012.ods/settings.xml: Info: no errors, no warnings Betalingen 2012.ods/styles.xml[2,25749]: Error: unexpected attribute style:scale-to-X Betalingen 2012.ods/styles.xml: Info: 1 errors, no warnings Betalingen 2012.ods/content.xml[2,19097]: Error: attribute style:vertical-align has a bad value. Possible values are: automatic,bottom,middle,top Betalingen 2012.ods/content.xml[2,19520]: Error: attribute style:vertical-align has a bad value. Possible values are: automatic,bottom,middle,top Betalingen 2012.ods/content.xml[2,23292]: Error: unexpected attribute style:vertical-justify Betalingen 2012.ods/content.xml[2,24719]: Error: attribute style:vertical-align has a bad value. Possible values are: automatic,bottom,middle,top Betalingen 2012.ods/content.xml[2,28322]: Error: unexpected attribute style:vertical-justify Betalingen 2012.ods/content.xml[2,29008]: Error: unexpected attribute style:vertical-justify Betalingen 2012.ods/content.xml[2,29665]: Error: unexpected attribute style:vertical-justify Betalingen 2012.ods/content.xml[2,176262]: Error: element text:a is missing type attribute Betalingen 2012.ods/content.xml[2,429302]: Error: element text:a is missing type attribute Betalingen 2012.ods/content.xml[2,550174]: Error: element text:a is missing type attribute Betalingen 2012.ods/content.xml[2,671039]: Fatal: Attribute end-cell-address bound to namespace urn:oasis:names:tc:opendocument:xmlns:table:1.0 was already specified for element table:table-cell. Betalingen 2012.ods/content.xml: Info: 11 errors, no warnings internal:/schema/odf1.2/OpenDocument-v1.2-cos01-dsig-schema.rng: Info: parsed. Betalingen 2012.ods: Info: 12 errors, no warnings -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Export as PDF in LO 3.5
Could it be that LO is trying to overwrite the original odt with the pdf? I had that in the past as the save as dialog was trying to be clever but not clever enough to create a pdf extension. Don't know how that works on Mac exactly, but how about trying to create a pdf with a different name? Ferry Tinkerer schreef op vr 10-02-2012 om 12:10 [-0800]: Many thanks. I found it OK, but the result was the same Write error, Unable to write to file. Tink. -- View this message in context: http://nabble.documentfoundation.org/Export-as-PDF-in-LO-3-5-tp3727436p3733551.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: UNSUBSCRIBE
I use Evolution as a news reader and subscribed to gmane.comp.documentfoundation.libreoffice.user. Long before forums there was usenet to replace mailings lists. And still works fine. Ferry Tom Davies schreef op do 19-01-2012 om 09:58 [+]: Hi :) This is an extremely high-traffic list and that is not made clear to people when they sign-up so it can cause panic. A proper official forum such as most modern projects use (Firefox, Fedora, Ubuntu, Mint and so on and on) would neatly avoid all sorts of recurring problems. But of course we have to stick with some ancient system that makes the project look like something pre-Win95. Even Arch has forums ffs. Regards from Tom :) --- On Thu, 19/1/12, Onyeibo Oku twoho...@gmail.com wrote: From: Onyeibo Oku twoho...@gmail.com Subject: Re: [libreoffice-users] UNSUBSCRIBE To: Libre, Users users@global.libreoffice.org Date: Thursday, 19 January, 2012, 9:51 Lol! This is happening again! Each time with the same vocabulary ... Are these people graduates of the same grammar school or what? - from twohot@device.mobile :) -Original Message- From: RandyMcD randy...@gondtc.com Date: Thu, 19 Jan 2012 03:27:57 To: users@global.libreoffice.org Reply-To: users@global.libreoffice.org Subject: [libreoffice-users] UNSUBSCRIBE HOW DO I UNSUBSCRIBE FROM THIS SHIT! -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Crashes with e-mail merge
To answer my own question: De problem appears to be related to Qt and occurs under KDE but not under gnome. Workaround: In Kubuntu I installed package gnome (adding 500MB and Unity which is nice for notebooks but not for a desktop) keeping kwin as window manager. Then opening a second X session of type gnome I can do the emailmerge and then quickly change back to KDE on the first session. Ferry Ferry Toth schreef op wo 04-01-2012 om 23:02 [+0100]: Problem description: When running mail merge with a document header that contains an image, libre office crashes without sending the mail. Steps to reproduce: Tools Mail merge Wizard Fill in all the data to get simplest type of email merge (i.e. Hello field somemessage, Bye) without any special formatting In the final step (sending the merged document per e-mail) writer crashes. I have tried sending plain text, as html. Tried various other data sources. Tried various mailreader back ends (under ToolsOptionsInternetE-mail, I am hoping this is used for sending?). My default = Evolution, but also tried Thunderbird and Kmail. Platform: Kubuntu Oneric with LO 3.4.4 This used to work well with LO 3.3.x on Kubuntu, so it is a regression. Note: the bug or similar is reported on LO bugzilla #43867 except there is reported due to OLE image in the header. Any quick fix that will help me send out my mail merge is highly appreciated. Ferry -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Crashes with e-mail merge
Problem description: When running mail merge with a document header that contains an image, libre office crashes without sending the mail. Steps to reproduce: Tools Mail merge Wizard Fill in all the data to get simplest type of email merge (i.e. Hello field somemessage, Bye) without any special formatting In the final step (sending the merged document per e-mail) writer crashes. I have tried sending plain text, as html. Tried various other data sources. Tried various mailreader back ends (under ToolsOptionsInternetE-mail, I am hoping this is used for sending?). My default = Evolution, but also tried Thunderbird and Kmail. Platform: Kubuntu Oneric with LO 3.4.4 This used to work well with LO 3.3.x on Kubuntu, so it is a regression. Note: the bug or similar is reported on LO bugzilla #43867 except there is reported due to OLE image in the header. Any quick fix that will help me send out my mail merge is highly appreciated. Ferry -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Base slowness and Java update
All this is true, but you might want to consider if you really want to use the built-in HSQLDB database for serious stuff. It is all java, which will never be really fast. Even with the java issues solved. With an external database you can avoid using the jdbc driver and instead use the SDBC driver. With debian and ubuntu (oneric, since yesterday) the postgresql sdbc driver (0.8) has been included which gives GOOD results with postgresql serves = 8.4. (thank you, Lionel) Windows users will need to wait until someone make the driver available as an extension. See http://wiki.documentfoundation.org/PostgreSQL-SDBC I have also tried the native mysql connector which works fast, but still has some issues (I did not get autonum fields to work, but that may be just me, also headache with special characters (unicode translation problems) ). Ferry jowyta schreef op do 13-10-2011 om 16:54 [+0100]: Hello This topic has rather hijacked my question about base and external data tables so I am starting a separate thread. I am well aware of the problem, as summarised here: http://wiki.documentfoundation.org/Base The current workaround involves using an older version of openjdk-jre. (Not straightforward, as far as I can tell, if using Debian testing - yes, I know I could get Java from elsewhere) However, base needs to work with up to date Java, in other words some bug fixing needs doing. For this reason I have asked a question on http://lists.freedesktop.org/mailman/listinfo/libreoffice . It seems to me that for the OpenJDK people to be able to sort out this problem they need to know what it is about Java that is affecting base so badly. And we are not dependent on Oracle as far as I can see, OpenJDK is an open source project and anyone can join in. So if anyone thinks they know which change in openjdk has caused this problem or how to find out I would like them to head over to the development mailing list and contribute there. (And thanks, Alex, for your suggestion that it may have something to do with accessibility and reminding us that many of the developers are currently at the LibreOffice annual conference.) John -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Digital Signature cannot validate (linux)
Yeah, it is quite possible to blame the Ubuntu Natty build. But the problem occurs just since my most recent Firefox update. So it would be nice to see if somebody can reproduce this before I file a bug. I'm looking into your links now. Ferry Op maandag 12-09-2011 om 11:30 uur [tijdzone -0700], schreef NoOp: On 09/12/2011 07:04 AM, Ferry Toth wrote: I think you missed the following points in my story: - the CA certificate is generated internally. This means we are CA for our own certificates. They are not blacklisted by FF. - to be validated we manually add the CA certificate ourselves to FF and windows certificate store). - FF shows the certificates are valid (linux) and so does IE (windows). The certificates are NOT blocked. - LO under ubuntu shows the user certificate is invalid because the CA is not in the path (this is new) - LO under windows works fine (yes with the security update installed that removes diginotar) I suggest you file a bug report on launchpad against Ubuntu's LO (ULO) version: https://bugs.launchpad.net/ubuntu/+source/libreoffice You might also install standard LO (you can do this without affecting ULO) and test to see if that is broken also. If so then you can file a bug report on bugzilla: http://wiki.documentfoundation.org/BugReport Perhaps you are experiencing this bug: https://bugs.freedesktop.org/show_bug.cgi?id=39825 [Does not find Firefox profile for digital certificate signing] The recent certificate bugs/updates are: http://www.ubuntu.com/usn/usn-1197-3 http://www.ubuntu.com/usn/usn-1197-1 https://launchpad.net/bugs/838322 http://www.ubuntu.com/usn/usn-1197-4 http://www.ubuntu.com/usn/usn-1197-1 http://www.ubuntu.com/usn/usn-1197-3, https://launchpad.net/bugs/837557 So it's quite possible that one (any) of those may have also cause breakage in ULO. Op maandag 12-09-2011 om 13:07 uur [tijdzone +0100], schreef Dave Sergeant: On 12 Sep 2011 at 10:52, Ferry Toth wrote: Since years we use digital signatures to sign our documents and protect them from inadvertent modifications. The CA certificate is one generated internally. Now on linux (ubuntu natty) the certificates are stored by firefox and since a recent upgrade to firefox 6.0.2 LO complains that the certificate cannot be validated. This happen even right after adding the signature. Apparently the root certificate cannot be found by LO. However, in firefox both personal and CA certificate validate fine. Switching to windows LO does validate the certificate fine (but there the certificates are stored elsewhere). It look like something changed in FF that broke the digital signing in LO. Or is it a configuration issue on my side? This one is easy to answer. Due to an issue with fraudulent certificates from the Dutch company Diginotar, Firefox has removed the Diginotar root certificate from its certificate store. Other browsers have acted similarly, ie there was a Windows update to achieve the same on IE. Since you are based in the Netherlands I guess your documents are validated against Diginotar certificates. See http://en.wikipedia.org/wiki/DigiNotar For many of us not in your country we have never encountered a Diginotar certificate and it was not even in my certificate store in Opera. Not sure what the answer is, but this seems to be a case of unexpected consequences of a fairy radical update to Firefox. Your internal certificates are clearly properly issued, and to block them because of a few fraudulent ones you are only going to encounter on dodgey sites seems a bit OTT. Dave http://www.davesergeant.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Digital Signature cannot validate (linux)
Checking the links below I find: - they are all connected with the diginotar CA and have nothing to do with my issue - except https://bugs.freedesktop.org/show_bug.cgi?id=39825 However here it is described the dialog box comes up empty. This is not so in my case. I sign the document as always. Then when I check the signature it shows it can't validate (apparently because it can not find the root CA). I'm wandering if all types of certificates fail to validate or only the ones where the CA is on the 'software security device' (as opposed to the 'built-in object token') in Firefox. Ferry Op zondag 18-09-2011 om 22:32 uur [tijdzone +0200], schreef Ferry Toth: Yeah, it is quite possible to blame the Ubuntu Natty build. But the problem occurs just since my most recent Firefox update. So it would be nice to see if somebody can reproduce this before I file a bug. I'm looking into your links now. Ferry Op maandag 12-09-2011 om 11:30 uur [tijdzone -0700], schreef NoOp: On 09/12/2011 07:04 AM, Ferry Toth wrote: I think you missed the following points in my story: - the CA certificate is generated internally. This means we are CA for our own certificates. They are not blacklisted by FF. - to be validated we manually add the CA certificate ourselves to FF and windows certificate store). - FF shows the certificates are valid (linux) and so does IE (windows). The certificates are NOT blocked. - LO under ubuntu shows the user certificate is invalid because the CA is not in the path (this is new) - LO under windows works fine (yes with the security update installed that removes diginotar) I suggest you file a bug report on launchpad against Ubuntu's LO (ULO) version: https://bugs.launchpad.net/ubuntu/+source/libreoffice You might also install standard LO (you can do this without affecting ULO) and test to see if that is broken also. If so then you can file a bug report on bugzilla: http://wiki.documentfoundation.org/BugReport Perhaps you are experiencing this bug: https://bugs.freedesktop.org/show_bug.cgi?id=39825 [Does not find Firefox profile for digital certificate signing] The recent certificate bugs/updates are: http://www.ubuntu.com/usn/usn-1197-3 http://www.ubuntu.com/usn/usn-1197-1 https://launchpad.net/bugs/838322 http://www.ubuntu.com/usn/usn-1197-4 http://www.ubuntu.com/usn/usn-1197-1 http://www.ubuntu.com/usn/usn-1197-3, https://launchpad.net/bugs/837557 So it's quite possible that one (any) of those may have also cause breakage in ULO. Op maandag 12-09-2011 om 13:07 uur [tijdzone +0100], schreef Dave Sergeant: On 12 Sep 2011 at 10:52, Ferry Toth wrote: Since years we use digital signatures to sign our documents and protect them from inadvertent modifications. The CA certificate is one generated internally. Now on linux (ubuntu natty) the certificates are stored by firefox and since a recent upgrade to firefox 6.0.2 LO complains that the certificate cannot be validated. This happen even right after adding the signature. Apparently the root certificate cannot be found by LO. However, in firefox both personal and CA certificate validate fine. Switching to windows LO does validate the certificate fine (but there the certificates are stored elsewhere). It look like something changed in FF that broke the digital signing in LO. Or is it a configuration issue on my side? This one is easy to answer. Due to an issue with fraudulent certificates from the Dutch company Diginotar, Firefox has removed the Diginotar root certificate from its certificate store. Other browsers have acted similarly, ie there was a Windows update to achieve the same on IE. Since you are based in the Netherlands I guess your documents are validated against Diginotar certificates. See http://en.wikipedia.org/wiki/DigiNotar For many of us not in your country we have never encountered a Diginotar certificate and it was not even in my certificate store in Opera. Not sure what the answer is, but this seems to be a case of unexpected consequences of a fairy radical update to Firefox. Your internal certificates are clearly properly issued, and to block them because of a few fraudulent ones you are only going to encounter on dodgey sites seems a bit OTT. Dave http://www.davesergeant.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail
[libreoffice-users] Digital Signature cannot validate (linux)
Since years we use digital signatures to sign our documents and protect them from inadvertent modifications. The CA certificate is one generated internally. Now on linux (ubuntu natty) the certificates are stored by firefox and since a recent upgrade to firefox 6.0.2 LO complains that the certificate cannot be validated. This happen even right after adding the signature. Apparently the root certificate cannot be found by LO. However, in firefox both personal and CA certificate validate fine. Switching to windows LO does validate the certificate fine (but there the certificates are stored elsewhere). It look like something changed in FF that broke the digital signing in LO. Or is it a configuration issue on my side? Ferry -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Digital Signature cannot validate (linux)
I think you missed the following points in my story: - the CA certificate is generated internally. This means we are CA for our own certificates. They are not blacklisted by FF. - to be validated we manually add the CA certificate ourselves to FF and windows certificate store). - FF shows the certificates are valid (linux) and so does IE (windows). The certificates are NOT blocked. - LO under ubuntu shows the user certificate is invalid because the CA is not in the path (this is new) - LO under windows works fine (yes with the security update installed that removes diginotar) Op maandag 12-09-2011 om 13:07 uur [tijdzone +0100], schreef Dave Sergeant: On 12 Sep 2011 at 10:52, Ferry Toth wrote: Since years we use digital signatures to sign our documents and protect them from inadvertent modifications. The CA certificate is one generated internally. Now on linux (ubuntu natty) the certificates are stored by firefox and since a recent upgrade to firefox 6.0.2 LO complains that the certificate cannot be validated. This happen even right after adding the signature. Apparently the root certificate cannot be found by LO. However, in firefox both personal and CA certificate validate fine. Switching to windows LO does validate the certificate fine (but there the certificates are stored elsewhere). It look like something changed in FF that broke the digital signing in LO. Or is it a configuration issue on my side? This one is easy to answer. Due to an issue with fraudulent certificates from the Dutch company Diginotar, Firefox has removed the Diginotar root certificate from its certificate store. Other browsers have acted similarly, ie there was a Windows update to achieve the same on IE. Since you are based in the Netherlands I guess your documents are validated against Diginotar certificates. See http://en.wikipedia.org/wiki/DigiNotar For many of us not in your country we have never encountered a Diginotar certificate and it was not even in my certificate store in Opera. Not sure what the answer is, but this seems to be a case of unexpected consequences of a fairy radical update to Firefox. Your internal certificates are clearly properly issued, and to block them because of a few fraudulent ones you are only going to encounter on dodgey sites seems a bit OTT. Dave http://www.davesergeant.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Re: Postgresql with LibO-3.3.2 BASE
I found that with the JDBC driver I can add/modify records. This driver is extremely slow (currently) especially over a WAN. The slowness is similar to the builtin HSQL database, so may be a java problem. Using the SDBC driver you can retrieve records fast, but are not allowed to add/modify. Note that we are using Postgresql with the SDBC for years now. This definitely a regression, and easy to reproduce too. Ferry amine amine schreef op za 09-04-2011 om 19:38 [+]: Salam, Thank you very much for your help, i think the problem was due to JDBC-4. i've reiterate the manipulation as you described with the JDBC-3, and now it's ok, so afterthat i switched back once again to JDBC4 and it's still ok. I'll try to investigate the problem with another machine to see more clearly. Thank you again for your help and your time, Good luck ! -- Amine Arrahmane Achargui Effectiveness (“Do the right things”) Efficiency (“Do the things right”) Great to see that great projects choose to use great projects to become even greater -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Postgresql with LibO-3.3.2 BASE
I have been using postgres with base for several years now. (unlike most I only used mysql in a recent project, and my feeling is postgres is way better) Right now it is impossible to add/edit/change rows in tables or forms using the SDBC driver. Reverting to the JDBC driver restores normal functionality. Unfortunately the JDBC driver is very slow, especially across a WAN. My guess is the problem is with sdbc driver. The same in OO 3.3 and 3.4 BETA. For a working LO/SDBC?Porgresql combination we need to fall back to OO 3.2.1. Which is hard when you just upgraded to Natty. I hope somebody will take the time to fix the driver. Ferry Joe Collura schreef op vr 08-04-2011 om 01:15 [-0400]: On 6 April 2011 ammine...@gmail.com wrote about postgresql with libre-3.3.2 base: I'm struggling with Inserting/Updating/Deleting data using BASE forms and the postgresql-server, i'm using both the jdbc and sdbc driver, But both does not allow me to Insert/Update/Delete data with the postgresql server same issue with LibO-3.3.2 on Linux/Ubuntu-10.10 and winXP Plz if anyone can help good luck to you all! hi armine, i havent quite got postgres to talk to libre yet either these might be worth following though: 0) Bug 35683 - RFE: consider adding SDBC into libreoffice for better access to postgresql https://bugs.freedesktop.org/show_bug.cgi?id=35683 1) Bug 31398 - RFE: LibreOffice Base should allow update/insert/drop query in sql-editor with hsqldb access controls https://bugs.freedesktop.org/show_bug.cgi?id=31398 also a while ago there was a patch to fedora implementation to postgresql-libs-8.4.7-1.fc14 that seemed to help but still havent quite got it. jc. -- Wherever you go; There you are. --BB -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted