<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN Base Cannot connect to mysql"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134982">134982</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN Base Cannot connect to mysql
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>silvain-dupertuis@bluewin.ch
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>