[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 Julien Nabet changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #15 from Julien Nabet --- Could you try this: - please uninstall any LO version you got - upgrade to Ubuntu 23.10 (or 22.04 if you want to stick to LTS) - install LO version from https://launchpad.net/~libreoffice/+archive/ubuntu/ppa to have recent LO version - rename your LO directory profile (see https://wiki.documentfoundation.org/QA/FirstSteps#Corrupted_user_profile) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 Buovjaga changed: What|Removed |Added Blocks||104790 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=104790 [Bug 104790] [META] Database connectivity interfaces (ODBC, JDBC..) and external databases -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #14 from Robert Großkopf --- (In reply to AJ from comment #13) You couldn't get it working, because the direct connection from LO is a connection to MariaDB. So newer versions of MySQL might be not supported with direct connection. Again: JDBC connection will work. Have a look at Base Guide https://books.libreoffice.org/en/BG73/BG7302-CreatingADatabase.html#toc9 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||133092 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=133092 [Bug 133092] [META] Crash bugs -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #13 from AJ --- Sorry didn't mean to mislead about special. All my installs have been from Ubuntu repositories. I tried removing the libreoffice-mysql-connector package. Base seems to connect directly successfully without it. Still get the crash though. This problem does not seem to be affecting any one else, I think I will park it here for he moment as I have a workaround. I will probably be upgrading ubuntu when 22.04 releases with LO 7.2 I think and will test again. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #12 from Robert Großkopf --- (In reply to AJ from comment #11) > > My understanding is that direct connection just requires installation of > libreoffice-mysql-connector package. I have looked through all packages, which are part of LO. There is no package like "libreoffice-mysql-connector" part of the *.deb or *.rpm packages. The connection is included in the package for base. Could it be you installed an old connector, which worked in versions before LO 6.2? Since LO 6.2 the connector is included and couldn't be separately installed with packages from LO. When reading about your installation you are using special packages from Ubuntu, not from LO. Please download the packages from https://www.libreoffice.org/download/download/ and test this packages. You will get an installation like this: Version: 7.3.1.3 / LibreOffice Community Build ID: a69ca51ded25f3eefd52d7bf9a5fad8c90b87951 CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded Have a look at the Build ID. This is an ID from LO. The Ubuntu packages are packed and combined by Ubuntu, not by LO. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #11 from AJ --- I am not using any special packages or extensions. I am not using MariaDB, this is a mysql installation. My understanding is that direct connection just requires installation of libreoffice-mysql-connector package. I had problems with dependencies trying to install the ODBC Connector deb package from MySQL communities. I did not pursue. The JDBC connector from communities is a functioning workaround, but not that easy to configure. mysql-connector-java/now 8.0.28-1ubuntu20.04 all [installed,local] -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||7997 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #10 from Robert Großkopf --- If you are using the special Ubuntu packages for LO and the special connection to a MySQL 8.0-connection please report this bug to Ubuntu. See https://wiki.documentfoundation.org/ReleaseNotes/6.2#Base MySQL C++ connector has been removed and MariaDB C connector is used since LO 6.2 (LGPL). You database is working without problems with LO directly installed from the packages of LO and MariaDB. If the direct connector for MariaDB doesn't work well with your MySQL database please use JDBC or ODBC for the connection. You could get the JDBC connector from here: https://dev.mysql.com/downloads/connector/j/ You will only need mysql-connector-java-8.0.27.jar for the connection. The driver should be added in the class path for java (directly in LO). Connection to the driver will be set by com.mysql.cj.jdbc.Driver -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #9 from AJ --- I have revisited this problem after upgrading LO to 7.1 from backports Base still crashes when I scroll through the t_table1 table (second pgdn) Current software releases: Ubuntu 5.13.0-35-generic #40~20.04.1-Ubuntu LibreOffice 7.1.7.2 10(Build:2) libreoffice/focal-backports,now 1:7.1.7-0ubuntu0.21.04.1~bpo20.04.1 amd64 [installed] libreoffice-mysql-connector/focal-backports,now 1:7.1.7-0ubuntu0.21.04.1~bpo20.04.1 amd64 [installed] mysql Ver 8.0.28-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu)) mysql-client/focal-updates,focal-updates,focal-security,focal-security 8.0.28-0ubuntu0.20.04.3 all Have reproduced the problem while running with --backtrace option see attached gdbtrace.log -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #8 from AJ --- Created attachment 178884 --> https://bugs.documentfoundation.org/attachment.cgi?id=178884=edit soffice --backtrace gdbtrace.log -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #7 from Julien Nabet --- On pc Debian x86-64 with master sources updated today, I don't reproduce this. However since I use MariaDB server, I couldn't create the table with utf8mb4_0900_ai_ci since I had an unknown collation error. I used utf8mb4_general_ci instead. Also have in mind that the native connector used by LO is in fact MariaDB not Mysql one. (mariadb-connector-c-3.1.8-src.tar.gz) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #6 from AJ --- The problem is occurring on a system I have just migrated from Ubuntu 18.04 with mysql 5 which connected fine, to Ubuntu 20.04 with mysql 8. Mysql 8 seems less supported in 20.04. odbc and jdbc drivers are no longer in Ubuntu repositories and needed to be obtained from mysql community. Have any of these attempts to reproduce issue been against a mysql 8 server? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 Robert Großkopf changed: What|Removed |Added CC||rob...@familiegrosskopf.de --- Comment #5 from Robert Großkopf --- Couldn't confirm the buggy behavior. Tested with the attached table, also with a table with 8000 rows and 12 columns and a table with 3 rows and 15 columns. Scrolled though the table to the end and back to the start. Couldn't reproduce a crash with direct connection - here to MariaDB - and LO 7.2.0.1 VCL:kf5 on OpenSUSE 15.2 64bit rpm Linux. Think it is a special bug of Ubuntu version of LO and direct connection. Please try the packages from LO directly. You could install these packages parallel as a user-defined installation. If you need help for this: Send me a private mail. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 Alex Thurgood changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED --- Comment #4 from Alex Thurgood --- Copied and pasted the SQL manually and removed the collation statement via the mysql CLI. No crash for me when scrolling through result set in Table browse mode with Version: 7.1.4.2 / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR Calc: threaded I scrolled from the first record to the last record with no crash. This sounds like a bug that is specific to the Ubuntu version, whether it is GTK3 or some other handling error causing a crash. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #3 from Alex Thurgood --- The test SQL dump has a collation "utf8mb4_0900_ai_ci" which unfortunately fails to get imported into my version 5 server. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 --- Comment #2 from AJ --- I have upgraded using the PPA LO is now Version: 7.1.4.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 12; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: en-GB (en_GB.UTF-8); UI: en-GB Ubuntu package version: 1:7.1.4~rc2-0ubuntu0.20.04.1~lo1 Calc: threaded libreoffice-mysql-connector/focal,now 1:7.1.4~rc2-0ubuntu0.20.04.1~lo1 amd64 [installed] Problem still occurs. Second page forward browsing the test table results in Base crashing and recovery dialog starts. It has also introduced authentication issues for my jdbc connection so I will will have to revert to previous version as this is not a testing system. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 Julien Nabet changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 CC||serval2...@yahoo.fr --- Comment #1 from Julien Nabet --- Could you give a try to LO 7.1.4 from LO ppa (see https://launchpad.net/~libreoffice/+archive/ubuntu/ppa)? Indeed 6.X branch is EOL and there won't be any new LO version on 7.0 branch after the released 7.0.6 version. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 143317] Base crashes viewing / browsing mysql database table using direct mysql connector
https://bugs.documentfoundation.org/show_bug.cgi?id=143317 AJ changed: What|Removed |Added Summary|Base crashes viewing / |Base crashes viewing / |browsing mysql database |browsing mysql database |table using direct mysql a |table using direct mysql |connector |connector -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
