<div dir="ltr"><div><div>Dear Anders Blom,<br><br></div>I just tried running your query [1] useing MySQL/MariaDb from my machine and everything<br>works as expected so the issue is most likely on your end.<br><br></div><div>I also attach a file with the results of the query in case they would prove useful for you in the short term.<br></div><div><br>[1] mysql -u cod_reader -h <a href="http://sql.crystallography.net">sql.crystallography.net</a> -e "select file from data where ((LOWER(formula) RLIKE ' ag') AND (nel = 1))" cod</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, 7 Jul 2023 at 16:29, Anders Blom <<a href="mailto:Anders.Blom@synopsys.com">Anders.Blom@synopsys.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-2962859575026305366">
<div style="overflow-wrap: break-word;" lang="EN-US">
<div class="m_-2962859575026305366WordSection1">
<p class="MsoNormal">Hi COD,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I am trying to connect and query the COD database via MySQL, but it is not working. Are you aware of any problems on your end?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I have tried multiple clients, such as pymysql, mysql command line, Oracle MySQLshell and DBeaver GUI. In each case I am able to establish some initial connection, but ultimately it just times out<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><img style="width: 10.052in; height: 0.6354in;" id="m_-2962859575026305366Picture_x0020_2" src="cid:189308b56e75b16b22" width="965" height="61"><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I say “establish connection” in the sense that if I use incorrect server parameters such as the wrong port or hostname, it fails immediately, whereas with the correct COD hostname and port it does wait until the timeout before showing the
above error.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">If this is a problem with your server, I hope it can be resolved, whereas if you believe the database is functioning properly for queries like this, then I have to dig further on my end (firewalls, perhaps, although I have tried multiple
networks as well).<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Kind regards,<u></u><u></u></p>
<p class="MsoNormal">Anders Blom<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><b><u></u> <u></u></b></p>
<p class="MsoNormal"><b><span><u></u> <u></u></span></b></p>
<p class="MsoNormal"><span>------------------------------------------------<u></u><u></u></span></p>
<p class="MsoNormal"><b><span>Anders Blom, Ph.D.</span></b><span><br>
Solutions Engineer, Sr Staff<u></u><u></u></span></p>
<p class="MsoNormal"><span>EDAG, Circuit Design & TCAD Solutions<u></u><u></u></span></p>
<p class="MsoNormal"><span>M: +1 408 874 5806 | W: +1 650 584 5000 (ext 47495) |
<a href="mailto:anders.blom@synopsys.com" target="_blank"><span style="color:blue">anders.blom@synopsys.com</span></a><br>
<a href="http://www.synopsys.com/" target="_blank"><span style="color:blue">synopsys.com</span></a> | 675 Almanor Ave, Sunnyvale, CA 94085, USA<u></u><u></u></span></p>
<p class="MsoNormal"><span><br>
</span><a href="https://www.synopsys.com/silicon/quantumatk.html" target="_blank"><span style="color:windowtext;text-decoration:none"><img style="width: 4.1666in; height: 0.4687in;" id="m_-2962859575026305366Picture_x0020_1" src="cid:189308b56e64cff311" width="400" height="45" border="0"></span></a><span><u></u><u></u></span></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<br>--
<br>This message has been scanned for viruses and
<br>dangerous content by
<a href="http://www.mailscanner.info/" target="_blank"><b>MailScanner</b></a>, and is
<br>believed to be clean.
</div>
_______________________________________________<br>
Cod-bugs mailing list<br>
<a href="mailto:Cod-bugs@lists.crystallography.net" target="_blank">Cod-bugs@lists.crystallography.net</a><br>
<a href="http://lists.crystallography.net/cgi-bin/mailman/listinfo/cod-bugs" rel="noreferrer" target="_blank">http://lists.crystallography.net/cgi-bin/mailman/listinfo/cod-bugs</a><br>
</div></blockquote></div><br clear="all"><br><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div>Antanas Vaitkus,<br></div>Vilnius University,<br>Life Sciences Center,<br>Institute of Biotechnology,<br><span><span><span>room C521, </span></span></span>Saulėtekio al. 7,<br>LT-10257 Vilnius, Lithuania<br></div><div><div><div><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><br><br></div></div></div></div></div></div></div></div></div></div></div>
<br />--
<br />This message has been scanned for viruses and
<br />dangerous content by
<a href="http://www.mailscanner.info/"><b>MailScanner</b></a>, and is
<br />believed to be clean.