Have numerous problems trying to create a Base document connecting to MySQL database on my local drive. Steps I follwed include: 1. Opened LibreOffice and selected Base option to create a new Base database/document. 2. Selected connect to existing database. 3. Selected connect using JDBC 4. Entered a database name that exists on my local MySQL server, Server is localhost, and port is 3306. MySQL JDBC driver class is com.mysql.jdbc.Driver. 5. Selected Next and entered my ID and password. Clicked on Test Connection. After step 5 when I clicked on Test Connection, LibreOffice closes. If I test class in step 4, it also crashes. I am able to connect to the database via MySQL Workbench and also via NetBeans. Hree are the details of the version and OS: Version: 5.3.1.2 Build ID: 1:5.3.1-0ubuntu2 CPU Threads: 1; OS Version: Linux 4.10; UI Render: default; VCL: gtk3; Layout Engine: new; Locale: en-US (en_US.UTF-8); Ubuntu provded a crash report and it appears to creash with SIGSEGV in_expand_stack_to(). Any additional information, please let me know.
Could you give a try with last stable LO version 5.3.4? Also, since you use LO x86 (so 32 bits), do you have Java 32 bits? Finally, could you rename your LO directory profile (see https://wiki.documentfoundation.org/UserProfile#GNU.2FLinux) and give a new try? Alex: could it be related to the Ubuntu kernel pb?
(In reply to Julien Nabet from comment #1) > > Alex: could it be related to the Ubuntu kernel pb? Possibly, but we'd need the OP's kernel version to know, or better still get them to read bug 108619
The described behaviour definitely sounds like bug 108619
@J Leslie : During setup of the connection, there is the possibility of testing the correct loading of the driver before actually testing the connection. Does the JDBC driver load successfully or do you also get a crash at this point ?
(In reply to Julien Nabet from comment #1) > Could you give a try with last stable LO version 5.3.4? > Also, since you use LO x86 (so 32 bits), do you have Java 32 bits? > Finally, could you rename your LO directory profile (see > https://wiki.documentfoundation.org/UserProfile#GNU.2FLinux) and give a new > try? > > Alex: could it be related to the Ubuntu kernel pb? I installed 5.3.4.2 and I received the same problem. Yes, I have Java 32 bits. It is already renamed as listed from that link: /home/jim/.config/libreoffice/4/user. Do you need anything from that directory?
(In reply to Alex Thurgood from comment #4) > @J Leslie : > > During setup of the connection, there is the possibility of testing the > correct loading of the driver before actually testing the connection. Does > the JDBC driver load successfully or do you also get a crash at this point ? Are you asking if I use the Test Class to the mysql.jdbc.driver class from LibreOffice? I tried it using version 5.3.4.2 and it also crashes.
(In reply to J Leslie from comment #7) > (In reply to Alex Thurgood from comment #4) > > @J Leslie : > > > > During setup of the connection, there is the possibility of testing the > > correct loading of the driver before actually testing the connection. Does > > the JDBC driver load successfully or do you also get a crash at this point ? > > Are you asking if I use the Test Class to the mysql.jdbc.driver class from > LibreOffice? I tried it using version 5.3.4.2 and it also crashes. Thanks, setting as DUP of 108619 *** This bug has been marked as a duplicate of bug 108619 ***
(In reply to Alex Thurgood from comment #8) > (In reply to J Leslie from comment #7) > > (In reply to Alex Thurgood from comment #4) > > > @J Leslie : > > > > > > During setup of the connection, there is the possibility of testing the > > > correct loading of the driver before actually testing the connection. Does > > > the JDBC driver load successfully or do you also get a crash at this point ? > > > > Are you asking if I use the Test Class to the mysql.jdbc.driver class from > > LibreOffice? I tried it using version 5.3.4.2 and it also crashes. > > Thanks, > setting as DUP of 108619 > > *** This bug has been marked as a duplicate of bug 108619 *** I know the workaround listed in 108619, use Java Runtime environment, does not work for me. It is selected, and it is required in order to use Base. It also appears that bug addressed the issue with Calc. This is base. Please explain why decided that this is a duplicate.
(In reply to J Leslie from comment #9) ** This bug has been marked as a duplicate of bug 108619 *** > > I know the workaround listed in 108619, use Java Runtime environment, does > not work for me. It is selected, and it is required in order to use Base. > It also appears that bug addressed the issue with Calc. This is base. > Please explain why decided that this is a duplicate. Bug 108619 is about people having a kernel version that causes the java virtual machine instantiation to fail everytime it is called. This causes any application which instantiates a JVM to crash. This is the bug you are experiencing IMHO - the solution is not to change your Java version, as that will have no effect, and turning Java off in the LO options (Comment 16) will obviously not work for a Base file that is connecting via JDBC. The problem lies in the kernel, so find a different kernel which is not affected and use that instead. You could also read this thread : https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1699772 which is cited in Comment 8 of bug 108619.