Re: [libreoffice-users] Re: Reports Libre Base
Peter, Here are some links to the threads I posted on LinuxQuestions.org about this matter. The thread title is (in case you want to search for it instead of logging into LinuxQuestions): *Problem with the 4.4.75 kernel security upgrade dated 26 June 2017 (SSE 2017-177-01)* https://www.linuxquestions.org/questions/slackware-14/problem-with-the-4-4-75-kernel-security-upgrade-dated-26-june-2017-sse-2017-177-01-a-4175610351/ And somehow this one got separated from the main thread: https://www.linuxquestions.org/questions/slackware-14/problem-with-the-4-4-75-kernel-security-upgrade-dated-26-june-2017-sse-2017-177-01-a-4175610351/page2.html#post5771382 The fix, as stated in the response from "bormant" on the 08-07-17, 11:25 AM posting, is to add "stack_guard_gap=6" to the LILO "append=" statement. If you are not using Lilo, then this may look differently. The idea is to pass this statement to the kernel when it boots. The second link is from a *buntu user and has a link to a ubuntu answer to adding this argument to Grub, the *buntu boot loader. https://askubuntu.com/questions/19486/how-do-i-add-a-kernel-boot-parameter/19487#19487 There is one caveat to this fix I should have mentioned in my first response. The problem only shows up on 32-bit Linux, not 64-bit. So, if you are running 64-bit Linux, this may not help. The alternate solution would be to switch to 64-bit Linux, but then that could open up another can of worms. I have been sticking to 32-bit because of the 32-bit apps that I rely on. I said it was technical. HTH. Girvin On 11/28/2017 12:35 PM, Peter wrote: Generally I allow all updates that come through. How do I add the kernal boot parameter? Is there any documentation that will guide me through this process? Peter On 29/11/17 06:47, Girvin Herr wrote: Peter, What indication do you have that LO crashes? Does it lock up or disappear (a hard crash)? If the former, LO may just be taking a long time to process something. Patience is a virtue. I have some reports that search on database string fields that are quite slow to process the report. I can go out and have a cup of coffee and maybe it will be done when I return. If the latter, there is a known security fix problem with Linux kernels later than about 4.4.75 and Java. This problem affected LibreOffice, but not OpenOffice, from my experience. There is a fix, but it is technical, regarding stack frame gap size settings. The fix is to add a kernel boot parameter to your booter (Lilo or Grub or whatever). If you updated your *buntu since LO last worked, this may be your problem. HTH. Girvin Herr On 11/27/2017 09:25 PM, Peter wrote: Base is installed and for my financial database the only problem I have is reports. I followed the advice and installed the packages. This made no difference. When I open the data base and select a previously defined report the data bases crashes. If I use the report creation facility when I select the report wizard again the data base crashes. Does base log these failures and if so where can I look at it? My fishing data base opens but I cannot open fofms , tables , queries etc. This problem with Base has occurred in the last 12 months. Any suggestions on what to do next will be gratefully received. Peter On 28/11/17 09:20, Keith Bates wrote: I use Ubuntu 17.04 also, including the Libreoffice packages installed directly from Ubuntu. The default install excludes Base, and if you can't open a database, it seems like you don't have Base installed. sudo apt install libreoffice-base should fix that, For reports the packages you need are libreoffice-report-builder and libreoffice-report-builder-bin. Use sudo apt install libreoffice-report-builder* and they should install. Keith On 28/11/17 08:45, Peter wrote: I reinstalled Libre Office Base from the Ubuntu repository. I assumed that this wouls automatically install all necessary packages. a=There is nothing that I can find in the__Ubuntu Software Repository that appears to relate to reports for LibreBase. How can i find out what packages I have installed and what packages are required forreports to work. I have an old data base which has not been uses since January 2015 which I tried to open today. This will no longer open for any thing , no forms or views or tables can be opened. Peter On 28/11/17 04:50, Robert Großkopf wrote: Hi Peter, Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2 Ubuntu 16.4 When I first found the problem I removed LibreBase and reinstalled it but the problem with reportsremained the same. This is a special Ubuntu-version of LO. Have a look into your packagemanager. Did you install all packages for the libreoffice-report-builder? Have heard there isn't only one package, which should be installed for reports with the Ubuntu-version of LO. Regards Robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?
Re: [libreoffice-users] Re: Reports Libre Base
Peter, First, I have both Apache OpenOffice (AOO) and LibreOffice (LO) installed on my Slackware Linux computer. I mostly use AOO, but when I do my database reports, I open up LO to process them with the LO Base Report Builder. I do this because AOO does not have a stable Report Builder (see below) and LO does. So far, in more than a decade of use, I have not had any document compatibility problems between the two apps. We can thank the Open Document people and how strongly the app writers conform to the Open Document standards for that. In my experience, the database support file (the .odb file) that contains all the app support stuff and gui definitions for the database is compatible between the two apps. So, there should be nothing to do in your Base gui to switch. Actually, I copied my .odb file from AOO to use with LO when I installed LO and I keep them both in separate sub-directories, just to be sure either does not get corrupted from the other app. I makes a good backup too. That said, I have no experience with the LO or AOO internal database server (aka "engine", "back end", etc.). I use the external Mariadb (MySQL) server for my databases, so switching the clients (AOO and LO) is not a problem for me. If you are using the internal database server, I would strongly suggest saving your database first and then opening it on AOO to see if it works. You can always restore the database with your saved database if things go terribly wrong. Keep in mind that OpenOffice does not have a Report Builder bundled in like LibreOffice does. There is an old extension (Oracle Report Builder) available that is advertised as compatible up to AOO 3.x, but is claimed by some to still work with the latest AOO 4.x version. I have not tried it yet and even then, it may not be as stable or up-to-date as the one bundled in with LO. https://extensions.openoffice.org/en/project/oracle-report-builder HTH. Good luck. Girvin On 11/28/2017 12:31 PM, Peter wrote: Definitly a hard crash. When restarted it goes into a recovery process. If I install Open Office will it work with the Lire Base data bases or would I need to export the data and recreate new data bases? Peter On 29/11/17 06:47, Girvin Herr wrote: Peter, What indication do you have that LO crashes? Does it lock up or disappear (a hard crash)? If the former, LO may just be taking a long time to process something. Patience is a virtue. I have some reports that search on database string fields that are quite slow to process the report. I can go out and have a cup of coffee and maybe it will be done when I return. If the latter, there is a known security fix problem with Linux kernels later than about 4.4.75 and Java. This problem affected LibreOffice, but not OpenOffice, from my experience. There is a fix, but it is technical, regarding stack frame gap size settings. The fix is to add a kernel boot parameter to your booter (Lilo or Grub or whatever). If you updated your *buntu since LO last worked, this may be your problem. HTH. Girvin Herr On 11/27/2017 09:25 PM, Peter wrote: Base is installed and for my financial database the only problem I have is reports. I followed the advice and installed the packages. This made no difference. When I open the data base and select a previously defined report the data bases crashes. If I use the report creation facility when I select the report wizard again the data base crashes. Does base log these failures and if so where can I look at it? My fishing data base opens but I cannot open fofms , tables , queries etc. This problem with Base has occurred in the last 12 months. Any suggestions on what to do next will be gratefully received. Peter On 28/11/17 09:20, Keith Bates wrote: I use Ubuntu 17.04 also, including the Libreoffice packages installed directly from Ubuntu. The default install excludes Base, and if you can't open a database, it seems like you don't have Base installed. sudo apt install libreoffice-base should fix that, For reports the packages you need are libreoffice-report-builder and libreoffice-report-builder-bin. Use sudo apt install libreoffice-report-builder* and they should install. Keith On 28/11/17 08:45, Peter wrote: I reinstalled Libre Office Base from the Ubuntu repository. I assumed that this wouls automatically install all necessary packages. a=There is nothing that I can find in the__Ubuntu Software Repository that appears to relate to reports for LibreBase. How can i find out what packages I have installed and what packages are required forreports to work. I have an old data base which has not been uses since January 2015 which I tried to open today. This will no longer open for any thing , no forms or views or tables can be opened. Peter On 28/11/17 04:50, Robert Großkopf wrote: Hi Peter, Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2 Ubuntu 16.4 When I first found the problem I removed LibreBase and
Re: [libreoffice-users] Re: Reports Libre Base
Hi Peter, > Definitly a hard crash. When restarted it goes into a recovery process. > If I install Open Office will it work with the Lire Base data bases or > would I need to export the data and recreate new data bases? If you are using the internal HSQLDB (and not Firebird!) it will be no problem to change between LO and AOO. Hope you haven't made something with macros, specially dates and reading values from listboxes - this will be a problem. Also it could be a problem to read reports with charts ... But before changing to AOO: You use the packages from Ubuntu at tis moment. In lifetime of LO very old packages, together with Base and Report-Builder Ubuntu isn't very user-friendly during the installation. Try the packages, which are original supported by LO: http://downloadarchive.documentfoundation.org/libreoffice/old/5.3.7.2/deb/ (or if you prefer newer versions you could search this path upper way: /old/5.4.3.2/deb/) Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Reports Libre Base
Generally I allow all updates that come through. How do I add the kernal boot parameter? Is there any documentation that will guide me through this process? Peter On 29/11/17 06:47, Girvin Herr wrote: Peter, What indication do you have that LO crashes? Does it lock up or disappear (a hard crash)? If the former, LO may just be taking a long time to process something. Patience is a virtue. I have some reports that search on database string fields that are quite slow to process the report. I can go out and have a cup of coffee and maybe it will be done when I return. If the latter, there is a known security fix problem with Linux kernels later than about 4.4.75 and Java. This problem affected LibreOffice, but not OpenOffice, from my experience. There is a fix, but it is technical, regarding stack frame gap size settings. The fix is to add a kernel boot parameter to your booter (Lilo or Grub or whatever). If you updated your *buntu since LO last worked, this may be your problem. HTH. Girvin Herr On 11/27/2017 09:25 PM, Peter wrote: Base is installed and for my financial database the only problem I have is reports. I followed the advice and installed the packages. This made no difference. When I open the data base and select a previously defined report the data bases crashes. If I use the report creation facility when I select the report wizard again the data base crashes. Does base log these failures and if so where can I look at it? My fishing data base opens but I cannot open fofms , tables , queries etc. This problem with Base has occurred in the last 12 months. Any suggestions on what to do next will be gratefully received. Peter On 28/11/17 09:20, Keith Bates wrote: I use Ubuntu 17.04 also, including the Libreoffice packages installed directly from Ubuntu. The default install excludes Base, and if you can't open a database, it seems like you don't have Base installed. sudo apt install libreoffice-base should fix that, For reports the packages you need are libreoffice-report-builder and libreoffice-report-builder-bin. Use sudo apt install libreoffice-report-builder* and they should install. Keith On 28/11/17 08:45, Peter wrote: I reinstalled Libre Office Base from the Ubuntu repository. I assumed that this wouls automatically install all necessary packages. a=There is nothing that I can find in the__Ubuntu Software Repository that appears to relate to reports for LibreBase. How can i find out what packages I have installed and what packages are required forreports to work. I have an old data base which has not been uses since January 2015 which I tried to open today. This will no longer open for any thing , no forms or views or tables can be opened. Peter On 28/11/17 04:50, Robert Großkopf wrote: Hi Peter, Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2 Ubuntu 16.4 When I first found the problem I removed LibreBase and reinstalled it but the problem with reportsremained the same. This is a special Ubuntu-version of LO. Have a look into your packagemanager. Did you install all packages for the libreoffice-report-builder? Have heard there isn't only one package, which should be installed for reports with the Ubuntu-version of LO. Regards Robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Reports Libre Base
Definitly a hard crash. When restarted it goes into a recovery process. If I install Open Office will it work with the Lire Base data bases or would I need to export the data and recreate new data bases? Peter On 29/11/17 06:47, Girvin Herr wrote: Peter, What indication do you have that LO crashes? Does it lock up or disappear (a hard crash)? If the former, LO may just be taking a long time to process something. Patience is a virtue. I have some reports that search on database string fields that are quite slow to process the report. I can go out and have a cup of coffee and maybe it will be done when I return. If the latter, there is a known security fix problem with Linux kernels later than about 4.4.75 and Java. This problem affected LibreOffice, but not OpenOffice, from my experience. There is a fix, but it is technical, regarding stack frame gap size settings. The fix is to add a kernel boot parameter to your booter (Lilo or Grub or whatever). If you updated your *buntu since LO last worked, this may be your problem. HTH. Girvin Herr On 11/27/2017 09:25 PM, Peter wrote: Base is installed and for my financial database the only problem I have is reports. I followed the advice and installed the packages. This made no difference. When I open the data base and select a previously defined report the data bases crashes. If I use the report creation facility when I select the report wizard again the data base crashes. Does base log these failures and if so where can I look at it? My fishing data base opens but I cannot open fofms , tables , queries etc. This problem with Base has occurred in the last 12 months. Any suggestions on what to do next will be gratefully received. Peter On 28/11/17 09:20, Keith Bates wrote: I use Ubuntu 17.04 also, including the Libreoffice packages installed directly from Ubuntu. The default install excludes Base, and if you can't open a database, it seems like you don't have Base installed. sudo apt install libreoffice-base should fix that, For reports the packages you need are libreoffice-report-builder and libreoffice-report-builder-bin. Use sudo apt install libreoffice-report-builder* and they should install. Keith On 28/11/17 08:45, Peter wrote: I reinstalled Libre Office Base from the Ubuntu repository. I assumed that this wouls automatically install all necessary packages. a=There is nothing that I can find in the__Ubuntu Software Repository that appears to relate to reports for LibreBase. How can i find out what packages I have installed and what packages are required forreports to work. I have an old data base which has not been uses since January 2015 which I tried to open today. This will no longer open for any thing , no forms or views or tables can be opened. Peter On 28/11/17 04:50, Robert Großkopf wrote: Hi Peter, Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2 Ubuntu 16.4 When I first found the problem I removed LibreBase and reinstalled it but the problem with reportsremained the same. This is a special Ubuntu-version of LO. Have a look into your packagemanager. Did you install all packages for the libreoffice-report-builder? Have heard there isn't only one package, which should be installed for reports with the Ubuntu-version of LO. Regards Robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Reports Libre Base
Peter, What indication do you have that LO crashes? Does it lock up or disappear (a hard crash)? If the former, LO may just be taking a long time to process something. Patience is a virtue. I have some reports that search on database string fields that are quite slow to process the report. I can go out and have a cup of coffee and maybe it will be done when I return. If the latter, there is a known security fix problem with Linux kernels later than about 4.4.75 and Java. This problem affected LibreOffice, but not OpenOffice, from my experience. There is a fix, but it is technical, regarding stack frame gap size settings. The fix is to add a kernel boot parameter to your booter (Lilo or Grub or whatever). If you updated your *buntu since LO last worked, this may be your problem. HTH. Girvin Herr On 11/27/2017 09:25 PM, Peter wrote: Base is installed and for my financial database the only problem I have is reports. I followed the advice and installed the packages. This made no difference. When I open the data base and select a previously defined report the data bases crashes. If I use the report creation facility when I select the report wizard again the data base crashes. Does base log these failures and if so where can I look at it? My fishing data base opens but I cannot open fofms , tables , queries etc. This problem with Base has occurred in the last 12 months. Any suggestions on what to do next will be gratefully received. Peter On 28/11/17 09:20, Keith Bates wrote: I use Ubuntu 17.04 also, including the Libreoffice packages installed directly from Ubuntu. The default install excludes Base, and if you can't open a database, it seems like you don't have Base installed. sudo apt install libreoffice-base should fix that, For reports the packages you need are libreoffice-report-builder and libreoffice-report-builder-bin. Use sudo apt install libreoffice-report-builder* and they should install. Keith On 28/11/17 08:45, Peter wrote: I reinstalled Libre Office Base from the Ubuntu repository. I assumed that this wouls automatically install all necessary packages. a=There is nothing that I can find in the__Ubuntu Software Repository that appears to relate to reports for LibreBase. How can i find out what packages I have installed and what packages are required forreports to work. I have an old data base which has not been uses since January 2015 which I tried to open today. This will no longer open for any thing , no forms or views or tables can be opened. Peter On 28/11/17 04:50, Robert Großkopf wrote: Hi Peter, Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2 Ubuntu 16.4 When I first found the problem I removed LibreBase and reinstalled it but the problem with reportsremained the same. This is a special Ubuntu-version of LO. Have a look into your packagemanager. Did you install all packages for the libreoffice-report-builder? Have heard there isn't only one package, which should be installed for reports with the Ubuntu-version of LO. Regards Robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Reports Libre Base
Hi Peter, install all what begins with libreoffice-report . This will install the report-builder. I haven't installed any Ubuntu-version here, only SUSE. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted