[Libreoffice-bugs] [Bug 134982] New: FILEOPEN Base Cannot connect to mysql

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134982
           Summary: FILEOPEN Base Cannot connect to mysql
           Product: LibreOffice
           Version: 6.4.5.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: silvain-dupertuis at bluewin.ch

In the past, I had been able to connect Base to my local mysql databases using
the integrated SQL connector in Base, and it was easy with the integrated SQL
connector.
Then later it became impossible. As it was not critical for my work, I just
thought it would come back… but I think I have not been able to get this
connection working for a couple of years now. 

I do have some bases for which I need a SQL version to use them online. The
workaround I have is to use a standard LO Base document and transfer data from
Base to SQL using an intermediate calc file connected to LO Base database.

I tried the different kind of connections, including JDB connector (the class
is working ok) and direct connection, but the connection is systematically
refused.
Whatever I do, I get the error «Could not connect to localhost:3306 :
(Connection refused).
Direct SQL connection returns this message :
Code d’erreur: 2003
Can't connect to MySQL server on 'localhost' (111)

For the mysql installation, I am using xampp – which is launched at start-up. I
can connect normally to localhost from my internet browser, as well as from the
command line (mysql).
My system uses MariaDB version 10.1.37, on Ubuntu 18.04.

Any indication on why it does not work for me would be appreciated.

-- 
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/20200720/c847b6c6/attachment.htm>