[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #36 from Commit Notification --- Krzysztof Hałasa committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/0c5e0dcd19403f967bc1ae46ebb8649b27b29b86 tdf#134982: use the right protocol for Mysql/Mariadb It will be available in 7.3.0.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 Commit Notification changed: What|Removed |Added Whiteboard|target:7.4.0|target:7.4.0 target:7.3.0.2 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 Buovjaga changed: What|Removed |Added Resolution|--- |FIXED Status|REOPENED|RESOLVED CC||ilmari.lauhakangas@libreoff ||ice.org -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #35 from Commit Notification --- Krzysztof Hałasa committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0143ec4d3d567edf16371c1d3c3981890b71 tdf#134982: use the right protocol for Mysql/Mariadb It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 Commit Notification changed: What|Removed |Added Whiteboard||target:7.4.0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #34 from Julien Nabet --- Thank you Krzysztof Hałasa for your feedback! Patch submitted here: https://gerrit.libreoffice.org/c/core/+/127673 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #33 from Krzysztof Hałasa --- (In reply to Julien Nabet from comment #32) > Ok but since I'm not familiar to submit a patch from someone else because > even if there's the command "git commit --author="xxx " -m > "patch from xxx"", I got 2 pbs: > 1) what email to put Right, Krzysztof Hałasa , or in pure ASCII, Krzysztof Halasa. Or you can submit it under your own name, it's so trivial so there is no difference for me. > 2) there's no license statement from you (see > https://wiki.documentfoundation.org/Development/ > GetInvolved#License_statement) Sure: All of my past & future contributions to LibreOffice may be licensed under the MPLv2/LGPLv3+ dual license. Thanks for handling this patch. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #32 from Julien Nabet --- (In reply to Krzysztof Hałasa from comment #31) > Hello Julien, > > (In reply to Julien Nabet from comment #30) > > > I can't tell if it's ok or not but since you already analyzed the code and > > thought about a fix, would you be interested in contributing to LO by > > submitting the patch? (see > > https://wiki.documentfoundation.org/Development/GetInvolved) > > Well, the above seems very, very, very complicated and, most certainly, very > time-consuming. A lot of effort for such a trivial patch. Isn't there a > simpler way? >... Ok but since I'm not familiar to submit a patch from someone else because even if there's the command "git commit --author="xxx " -m "patch from xxx"", I got 2 pbs: 1) what email to put 2) there's no license statement from you (see https://wiki.documentfoundation.org/Development/GetInvolved#License_statement) Anyway, not much people complain about this pb so if there's some workaround, no big deal. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #31 from Krzysztof Hałasa --- Hello Julien, (In reply to Julien Nabet from comment #30) > I can't tell if it's ok or not but since you already analyzed the code and > thought about a fix, would you be interested in contributing to LO by > submitting the patch? (see > https://wiki.documentfoundation.org/Development/GetInvolved) Well, the above seems very, very, very complicated and, most certainly, very time-consuming. A lot of effort for such a trivial patch. Isn't there a simpler way? I don't even know if the patch still applies cleanly to current code, after all this time, while such things are trivial for someone working with right git trees etc. Merry Christmas, and a better New Year :-) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #30 from Julien Nabet --- (In reply to Krzysztof Hałasa from comment #28) > Created attachment 170575 [details] > Fix MySQL UNIX socket connector > > This patch fixes the problem for me. With this applied, LibreOffice Base can > connect securely - without a need for a password - to MySQL using > /var/.../mysql.sock UNIX socket, instead of using (insecure) TCP on > localhost or going through the complicated JDBC case. This patch is thus > compatible with MySQL's "skip-networking". > > I haven't tested the MYSQL_PROTOCOL_PIPE case. I can't tell if it's ok or not but since you already analyzed the code and thought about a fix, would you be interested in contributing to LO by submitting the patch? (see https://wiki.documentfoundation.org/Development/GetInvolved) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 Krzysztof Hałasa changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|NOTOURBUG |--- --- Comment #29 from Krzysztof Hałasa --- Guess I need to reopen this bug to propagate the fix upstream. -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #28 from Krzysztof Hałasa --- Created attachment 170575 --> https://bugs.documentfoundation.org/attachment.cgi?id=170575=edit Fix MySQL UNIX socket connector This patch fixes the problem for me. With this applied, LibreOffice Base can connect securely - without a need for a password - to MySQL using /var/.../mysql.sock UNIX socket, instead of using (insecure) TCP on localhost or going through the complicated JDBC case. This patch is thus compatible with MySQL's "skip-networking". I haven't tested the MYSQL_PROTOCOL_PIPE case. -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #27 from Duns --- Today I managed to fix this problem: commenting the line skip-networking in my.conf (using lampp, therefore in /opt/lampp/etc). LO Version: 6.4.6.2 Build ID: 1:6.4.6-0ubuntu0.20.04.1 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: kf5; Locale: it-IT (en_US.UTF-8); UI-Language: en-US Calc: threaded -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #26 from Alex Thurgood --- (In reply to Alex Thurgood from comment #25) > FWIW, testing with : > > Version: 7.0.1.2 > Build ID: 88a63c56098013eb4038e11ebe7c8c0daab09aa8 > CPU threads: 1; OS: Linux 4.15; UI render: default; VCL: gtk3 > Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR > Calc: threaded > > accessing a mariadb server > 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04 > > installed on > DISTRIB_ID=LinuxMint > DISTRIB_RELEASE=19 > DISTRIB_CODENAME=tara > DISTRIB_DESCRIPTION="Linux Mint 19 Tara" > > works just fine. FWIW, using the native mysql 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
[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #25 from Alex Thurgood --- FWIW, testing with : Version: 7.0.1.2 Build ID: 88a63c56098013eb4038e11ebe7c8c0daab09aa8 CPU threads: 1; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded accessing a mariadb server 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04 installed on DISTRIB_ID=LinuxMint DISTRIB_RELEASE=19 DISTRIB_CODENAME=tara DISTRIB_DESCRIPTION="Linux Mint 19 Tara" works just fine. -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 Alex Thurgood changed: What|Removed |Added Resolution|--- |NOTOURBUG Status|NEEDINFO|RESOLVED --- Comment #24 from Alex Thurgood --- (In reply to Robert Großkopf from comment #22) > And with phpmyadmin you could see in "users" the user root (root is the same > as root of the system!) is connected to localhost? @Robert, forget it, Linux Mint uses the DEB packages provided by Ubuntu, and these are currently configured by default to only allow mysql/mariadb root account access from a process that is already running as root using a unix socket authentication plugin. This is a security "feature" of the DEB packages provided by those distros. https://stackoverflow.com/questions/30815971/mariadb-installed-without-password-prompt/34674254#34674254 I am closing this report as NOTOURBUG. Both Sylvain and Duns need to learn to configure their mariadb/mysql server with the relevant authentication plugin for each user and assign them a corresponding password, and then try and connect from LO with a supported password authentication mechanism before filing a report here. This bugzilla isn't the place for general exchanges on configuring mysql/mariab, and only muddles any real issue that might be present. -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #23 from Duns --- I think so: Server: Localhost via UNIX socket Server type: MariaDB Server connection: SSL is not being used Documentation Server version: 10.4.14-MariaDB - Source distribution Protocol version: 10 User: root@localhost Server charset: cp1252 West European (latin1) -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #22 from Robert Großkopf --- (In reply to Duns from comment #21) > But here the point is not security: the point is that in Linux Mint as well > Libre-mysql-connector doesn't work, even user root (I'm not sure if "mysql > root" is the same as "system user root") is recognized by mysql server and > by phpmyadmin, f.e. And with phpmyadmin you could see in "users" the user root (root is the same as root of the system!) is connected to localhost? -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #21 from Duns --- But here the point is not security: the point is that in Linux Mint as well Libre-mysql-connector doesn't work, even user root (I'm not sure if "mysql root" is the same as "system user root") is recognized by mysql server and by phpmyadmin, f.e. Any way, I tried with other name: same failure. -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982
--- Comment #20 from Robert Großkopf ---
(In reply to Duns from comment #19)
>
>Error code: 1698
>Access denied for user 'root'@'localhost'
This is depending on your installation. I don't think you really want to
connect to the MySQL database as root of a Linux system. You will create a user
with a password, who should connect to the database. And you have to allow this
user a connection from localhost, something like
SET PASSWORD FOR testuser@localhost=PASSWORD('.');
--
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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #19 from Duns --- I. tested in Linux Mint (fresh installation yesterday in virtualbox). 1) installed mysql-server but a deal of problems because of password. Disintalled! 2) Installed lampp: I get another kind of error in LibreBase when I try a direct connection: Error code: 1698 Access denied for user 'root'@'localhost' II. reported the problem in apachefriends forum: https://community.apachefriends.org/f/viewtopic.php?f=17=79847=0 -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #18 from Duns --- I see. Thank you. I just add that I have beforehand reported this bug on Ubuntu bugs (https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1892635). I will wait and do some other attempt, but, as I said, so far I was not able to install mysql server from ubuntu packages (held packages issue). I will ask XAMPP developers if they can help. -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #17 from Alex Thurgood --- (In reply to Duns from comment #16) > To sum up I think that fixing this issue should be made by LibreOffice > developers: either go back to the previous relase of mysql-connector or > (better) developing a new release *working*. A not working app is useless, > isn't it? You are assuming that the issue is a LibreOffice one, and not an issue caused by packaging and/or library version decisions made by Ubuntu... Having just gone through the native connector setup dialog again on macOS this morning and yesterday on Linux Ubuntu 20.04, when you set up the database, you get to indicate the path of the of the socket. If the entry you type here isn't registered for some reason, that would be a bug in that dialog, or the parsing of information by LO which handled by that dialog. The alternative suggestion to use TCP connectivity instead of Unix socket, relies on you knowing how to activate TCP connections in your mysql server instance, by modifying the relevant configuration file. That information can be found all over the internet, and has absolutely nothing to do with LibreOffice. By default these days, current versions of mysql server provided on Linux platforms do not allow TCP access via Class C IP addresses. Again, this is nothing to do with LibreOffice, but decisions made by the packager and provider of the mysql server. Telling the LibreOffice project that they have to fix a bug which is as yet undetermined to be within the LO project's remit, is a bit like saying "I can't fly to the moon, it's your fault, fix it for me." For all we know, this might indeed be a LO problem, then again, it might not. I have yet to see any information from any of the posters complaining about the problem, that they have attempted to at least try and solve it by themselves, and report back here what exactly they have done. For starters, one might try installing standard Linux distribution provided mysql server packages rather than some weird separate bundle that someone thought might conveniently go in /opt ? Where did you get that XAMPP bundle from ? How is the server configured in that bundle ? How can you get it to accept TCP connections over IP ? All of these questions are the responsibility of the person who chooses to install that particular bundle, and have zero/zilch/nada to do with LO. Once you know the answer to these questions, how the XAMPP bundle is supposed to function, the attempts you have tried to resolve the problem, and still come up with a failure of LO to connect, then we can start trying to see where there might be an issue with LO. -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #16 from Duns --- To sum up I think that fixing this issue should be made by LibreOffice developers: either go back to the previous relase of mysql-connector or (better) developing a new release *working*. A not working app is useless, isn't it? Ask users to waste their time in useless attempts is not the best. If the solution requires time, we will wait. But, please, do something to fix this problem. Thanks! -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #15 from Duns --- Thank you, @Alex: «allow TCP connections». But how should I do? Searching with Google so far I didn't find a clear and complete answer... -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982
Alex Thurgood changed:
What|Removed |Added
CC||ipla...@tuta.io,
||lio...@mamane.lu
--- Comment #14 from Alex Thurgood ---
Also note however, that the code in lines 124-174 of mysql_connection.cxx seems
to imply that a Unix sokcet, or even a named pipe, can be used as a connection
paramater:
// get user and password for mysql connection
125 const PropertyValue* pIter = info.getConstArray();
126 const PropertyValue* pEnd = pIter + info.getLength();
127 OUString aUser, aPass, sUnixSocket, sNamedPipe;
128 bool unixSocketPassed = false;
129 bool namedPipePassed = false;
130
131 m_settings.connectionURL = url;
132 for (; pIter != pEnd; ++pIter)
133 {
134 if (pIter->Name == "user")
135 {
136 OSL_VERIFY(pIter->Value >>= aUser);
137 }
138 else if (pIter->Name == "password")
139 {
140 OSL_VERIFY(pIter->Value >>= aPass);
141 }
142 else if (pIter->Name == "LocalSocket")
143 {
144 OSL_VERIFY(pIter->Value >>= sUnixSocket);
145 unixSocketPassed = !sUnixSocket.isEmpty();
146 }
147 else if (pIter->Name == "NamedPipe")
148 {
149 OSL_VERIFY(pIter->Value >>= sNamedPipe);
150 namedPipePassed = !sNamedPipe.isEmpty();
151 }
152 else if (pIter->Name == "PublicConnectionURL")
153 {
154 OSL_VERIFY(pIter->Value >>= m_settings.connectionURL);
155 }
156 else if (pIter->Name == "NewURL")
157 { // legacy name for "PublicConnectionURL"
158 OSL_VERIFY(pIter->Value >>= m_settings.connectionURL);
159 }
160 }
161
162 OString host_str = OUStringToOString(aHostName, m_settings.encoding);
163 OString user_str = OUStringToOString(aUser, m_settings.encoding);
164 OString pass_str = OUStringToOString(aPass, m_settings.encoding);
165 OString schema_str = OUStringToOString(aDbName, m_settings.encoding);
166 OString socket_str;
167 if (unixSocketPassed)
168 {
169 socket_str = OUStringToOString(sUnixSocket, m_settings.encoding);
170 }
171 else if (namedPipePassed)
172 {
173 socket_str = OUStringToOString(sNamedPipe, m_settings.encoding);
174 }
As I'm not familiar with which part takes priority or why, I can't help out
here, this would require someone more knowledgeable about the code in the
connector.
@Lionel : any insights you might be able to offer ?
--
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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982
--- Comment #13 from Alex Thurgood ---
Not sure whether this is going to be of any use, BUT, it might be that you can
no longer specify a link to a Unix socket...
Reading this :
https://docs.libreoffice.org/connectivity/html/mysqlc__connection_8cxx_source.html
the code at lines 76-86
76 // use TCP as connection
77 mysql_protocol_type protocol = MYSQL_PROTOCOL_TCP;
78 mysql_options(_mysql, MYSQL_OPT_PROTOCOL, );
79 OString charset_name{ "utf8mb4" };
80 mysql_options(_mysql, MYSQL_SET_CHARSET_NAME,
charset_name.getStr());
81
82 sal_Int32 nIndex;
83 OUString token;
84 OUString aHostName("localhost");
85 sal_Int32 nPort = 3306;
86 OUString aDbName;
would seem to indicate that one can only use a TCP connection (and therefore
not a pure Unix socket) with the native driver code to connect to a running
mysql instance.
I seem to recall that this was not the case in the past and one could
previously specify a Unix socket path in the UI wizard configuration of the
native connector driver extension. It would appear that that possibility has
been removed, probably during UI rework of the connection wizard (guessing
here).
If this is indeed the case, then the only solution for people like Silvain and
Duns, etc, would be to edit their mysql configuration file and change the
connection type to explicitly allow TCP connections.
See my comment 4 here:
"- or your reconfigure your mariadb server to use TCP/IP (see the bind-address
entry) instead of acessing the Unix socket - this is generally done by editing
the my/cnf file, but beware of the safety considerations in doing so
(especially if you have access from outside your network into your LAN."
--
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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #12 from Duns --- To see where should point symlink of mysql soceket, I'm trying to install mysql server on KDE Neon, but both in a fresh installation in Virtualbox and on my main PC I have a problem of held packages and conflit of dependecies. Why developers have complicated so much our lives? (maybe the covid, I guess... I am grateful for their work, any way) -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #11 from Duns --- but install jdbc is very complicated. You know if there is a guide to install it? -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 Alex Thurgood changed: What|Removed |Added CC||fberto...@tiscali.it --- Comment #10 from Alex Thurgood --- *** Bug 136290 has been marked as a duplicate of this bug. *** -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #9 from Robert Großkopf --- (In reply to Silvain Dupertuis from comment #8) > I have tried different combinations with no success so far, then I did not > have the time to do more tests, and no time to give more details just now. Try it with JDBC, not with the native connector. Works better. You could create views for example ... -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #8 from Silvain Dupertuis --- I have tried different combinations with no success so far, then I did not have the time to do more tests, and no time to give more details just now. On another computer, I installed both xampp and mysql. Both work independanty, LO Base can connect to mysql, but I did not manage so far to to connect Base to the xampp databases. I tried using symlinks to use the same databases for both, but it did not work. If I find my way, I will post a comment. -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 --- Comment #7 from Duns --- I have the same problem of Silvain. You says to do a symlink from the lampp socket (in /opt) to "the place where LO expects to find it". But can you kindly tell me where is this place? -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 Alex Thurgood changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO --- Comment #6 from Alex Thurgood --- @Sylvain - have you solved your problem ? -- 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 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04
https://bugs.documentfoundation.org/show_bug.cgi?id=134982 Alex Thurgood changed: What|Removed |Added Summary|Base - cannot connect via |Base - cannot connect via |native mysql connector to |native mysql connector to |XAMMP mysql instance|XAMMP mysql/mariadb |installed on Ubuntu 18.04 |instance installed on ||Ubuntu 18.04 -- 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
