[Libreoffice-bugs] [Bug 134982] Base - cannot connect via native mysql connector to XAMMP mysql/mariadb instance installed on Ubuntu 18.04

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134982

--- Comment #13 from Alex Thurgood <iplaw67 at tuta.io> ---
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(&m_mysql, MYSQL_OPT_PROTOCOL, &protocol);
   79     OString charset_name{ "utf8mb4" };
   80     mysql_options(&m_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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200901/0d58782e/attachment.htm>