<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 - Database Properties changes Name of the MySQL database string when a "/" is present"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119786">119786</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Database Properties changes Name of the MySQL database string when a "/" is present
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>gustik@gustik.eu
</td>
</tr></table>
<p>
<div>
<pre>Description:
In order to connect to a database over MySQL JDBC driver which complains about
the timezone, I need to set serverTimezone variable over
mydbname?serverTimezone="Europe/Vienna".
Steps to Reproduce:
1. Open LibreOffice Base
2. Configure a MySQL server over JDBC driver
3. Pass in ?serverTimezone="Europe/Vienna" as a database name parameter
Actual Results:
Libreoffice Base connects to the DBMS successfully, however, after pressing OK
in the Database Properties window, the the Name of the MySQL database string
gets changed to Vienna. Looks like someone is using a split() function which
filters out all "/" characters and returns the part after "/".
Expected Results:
Should not change the database name string.
Reproducible: Always
User Profile Reset: No
Additional Info:
I would suggest having something like escaping functionality, so that I can say
"Europe/Vienna" without getting the "/" inside of "" filtered out.
Anyway, the connection works, so if this is a security feature, then it is a
bad one, because it works one time, which is enough for a potential attack. The
problem occurs the next time you open the saved libreoffice base file, when it
tries to connect to the database name containing substring after "/".</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>