<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;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I'm looking for some assistance reading data from the ensembl mysql instance for EnsemblMetazoa.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have a very simple API script based on examples from the official documentation (attached), it works fine for listing the available DB adaptors via "get_all_DBAdaptors" if I point it at the vertebrate instance, but for the non-vertebrate
genomes I get an empty list (registry as <a href="https://metazoa.ensembl.org/info/docs/api/general_instructions.html#connectin">
described here</a>).<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If nothing else, I'm just looking for someone to confirm they see the same behaviour as me when using the documented connection details.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">P.s. the general ensembl instance is very slow, it was usable earlier today, not so much now. I also did a host lookup of the database hosts, both derive down to the same IP address via a chain of aliases, so it looks like it's the port
that is more important.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Keiran Raine, M.Sc., MBCS<o:p></o:p></p>
<p class="MsoNormal">Principal Software Developer<o:p></o:p></p>
<p class="MsoNormal">Cancer, Ageing and Somatic Mutation<o:p></o:p></p>
<p class="MsoNormal">Wellcome Sanger Institute<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><a href="mailto:kr2@sanger.ac.uk"><span style="color:#0563C1">kr2@sanger.ac.uk</span></a><o:p></o:p></p>
<p class="MsoNormal">Office: D3-19<o:p></o:p></p>
<p class="MsoNormal">Ext: 4983<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please note that due to childcare requirements due to covid restrictions I am generally not available after 4pm.<o:p></o:p></p>
</div>
</body>
</html>