<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.E-MailFormatvorlage18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="DE" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="color:black">Hello Peter,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">Thanks for your reply.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">Updating of the database server process itself was no issue, also the migration of the data in the database was nothing unusual – this is also something I already did many times before in other projects.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">So the next step I did was trying to install DBD::mysql as per some of the error messages I got from the application, this module was missing (which was correct, as I started with a plain Debian container).
So I tried to install, but first I needed to get the mysql-config tool installed:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">apt-get install libmariadb-dev-compat<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">After that I tried again with:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">cpanm install DBD::mysql<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">and this failed, with the errors in the log:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">….<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">DBD::mysql requires MySQL 8.x or newer for building. Version reported by mysql_config --version</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">: 10.11.6 at Makefile.PL line 451, <PIPE> line 3.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">-> N/A</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">-> FAIL Configure failed for DBD-mysql-5.008. See /root/.cpanm/work/1725256110.1036/build.log f</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">or details.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">…..</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">As there is a DBD::MariaDB, I thought: Yes that one would most likely do the trick and I could actually install it. For this to be used I also needed to set the configuration in gbrowse to use the
MariaDB Connector (which is ok because this is what I just installed). However this does not work out as gbrowse used Bio::DB:SeqFeature:Store::DBI::mysql and now tries to use Bio::DB:SeqFeature:Store::DBI::MariaDB which is a module that does not exist.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">It might be that everything just works fine if I install the mysql libraries into the container, sourced from MySQL directly instead of relying on Debian packages that come out of the box. But this
feels kind of an ugly workaround.</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">Greetings,</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:black">Kai</span><span style="color:black"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">Von: </span></b><span style="font-size:12.0pt;color:black">Peter Cock <p.j.a.cock@googlemail.com><br>
<b>Datum: </b>Freitag, 30. August 2024 um 14:29<br>
<b>An: </b>"Schlachter, Kai" <kai.schlachter@dkfz-heidelberg.de><br>
<b>Cc: </b>"bioperl-l@bioperl.org" <bioperl-l@bioperl.org><br>
<b>Betreff: </b>[Extern] - Re: [Bioperl-l] Support for MariaDB in Bio::DB:SeqFeature:Store::DBI::<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">Hello Kai,<br>
<br>
Interesting question (although I'm viewing it from a Python and Biopython perspective).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="https://mariadb.com/kb/en/upgrading-from-mysql-to-mariadb/">https://mariadb.com/kb/en/upgrading-from-mysql-to-mariadb/</a> suggests this should<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">just work, with existing MySQL bindings treating MariaDB as a newer version.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">It sounds like your set is breaking in the Perl module DBD::mysql?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="https://metacpan.org/dist/DBD-mysql">https://metacpan.org/dist/DBD-mysql</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Looking at the change log there are entries from this year, and multiple mentions<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">of MariaDB - so I would expect this to work:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><a href="https://metacpan.org/release/DVEEDEN/DBD-mysql-5.008/source/Changes">https://metacpan.org/release/DVEEDEN/DBD-mysql-5.008/source/Changes</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Can you take a look at their issue tracker <a href="https://github.com/perl5-dbi/DBD-mysql">
https://github.com/perl5-dbi/DBD-mysql</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">and see if you've hit a known issue?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Also can you double check the version of DBD::mysql you have installed?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Peter<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Fri, Aug 30, 2024 at 12:15 PM Schlachter, Kai <<a href="mailto:kai.schlachter@dkfz-heidelberg.de">kai.schlachter@dkfz-heidelberg.de</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hi there,<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">I took over an older project to modernize the underlaying hardware / software.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">This also involves the use of gbrowse, which in turn relies quite a lot on BioPerl.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">As our freshly provided servers are all Debian based and we are highly encouraged to use a most recent version of Debian inside of our containers (docker), I
ran into the following issue:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Debian no longer supports MySQL but has switched to MariaDB, which leads me to the following:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">I tried to install gbrowse, resolving all the dependencies and stuff that came along. I also was able to compile the DBD::MariaDB as this is the required module
for MariaDB-Connections.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">However I was not able to find a Module in Bio::DB:SeqFeature:Store::DBI called MariaDB, there is only Mysql :(</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Although both adaptors should share at least some basic functionality, it is not possible to install the Mysql-Version on a recent Debian because DBD::MySQL will
refuse to work with mariadb because of a version mismatch (expected 8.x but reported 10.y).</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Are there any plans / ideas to add mariadb support to the modules?</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">I am not an original perl programmer so I don’t think it’s a good idea to start implementing / contributing with such a complex thing.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Greetings,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Kai</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Bioperl-l mailing list<br>
<a href="mailto:Bioperl-l@bioperl.org" target="_blank">Bioperl-l@bioperl.org</a><br>
<a href="https://mailman.open-bio.org/mailman/listinfo/bioperl-l" target="_blank">https://mailman.open-bio.org/mailman/listinfo/bioperl-l</a><o:p></o:p></p>
</div>
</blockquote>
</div>
</div>
</body>
</html>