<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Hi, </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
I'm investigating how to perform some searches in the COD programmatically via the mysql interface. In following the example
<a href="https://wiki.crystallography.net/howtoquerycod/" title="https://wiki.crystallography.net/howtoquerycod/">
online </a>I'm not managing to connect, however. Do you have any advice on how I might proceed? Below I show results of a ping (success), the mysql (with the error) and my mysql version.
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Many thanks in advance for your help! <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
All the best, <br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
Dean<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<span style="font-family: "Courier New", monospace;">$ ping -c 1 sql.crystallography.net</span>
<div><span style="font-family: "Courier New", monospace;">PING sql.crystallography.net (158.129.170.75) 56(84) bytes of data.</span></div>
<div><span style="font-family: "Courier New", monospace;">64 bytes from 158.129.170.75 (158.129.170.75): icmp_seq=1 ttl=46 time=47.7 ms</span></div>
<div><br>
</div>
<div><span style="font-family: "Courier New", monospace;">--- sql.crystallography.net ping statistics ---</span></div>
<div><span style="font-family: "Courier New", monospace;">1 packets transmitted, 1 received, 0% packet loss, time 0ms</span></div>
<div><span style="font-family: "Courier New", monospace;">rtt min/avg/max/mdev = 47.777/47.777/47.777/0.000 ms</span></div>
<div><span style="font-family: "Courier New", monospace;"><br>
</span></div>
<div><span style="font-family: "Courier New", monospace;">$ mysql -u cod_reader -h sql.crystallography.net -e 'select count(*) from data where flags like "%has Fobs%"' cod | cat</span></div>
<div><span style="font-family: "Courier New", monospace;">ERROR 2003 (HY000): Can't connect to MySQL server on 'sql.crystallography.net' (110)</span></div>
<div><span style="font-family: "Courier New", monospace;"><br>
</span></div>
<div><span style="font-family: "Courier New", monospace;">$ mysql --version</span></div>
<div><span style="font-family: "Courier New", monospace;">mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1</span></div>
<br>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(81, 167, 249);">Dean S. Keeble</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(81, 167, 249);">Data Analysis Scientist - Diffraction</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(81, 167, 249);">Diamond Light Source, </span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(81, 167, 249);">Harwell Campus, Oxon., OX11 0DE.</span></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
</div>
</div>
</div>
<p align="justify"> </p>
<p align="justify">-- </p>
<p align="justify">This e-mail and any attachments may contain confidential, copyright and or privileged material, and are for the use of the intended addressee only. If you are not the intended addressee or an authorised recipient of the addressee please notify us of receipt by returning the e-mail and do not use, copy, retain, distribute or disclose the information in or attached to the e-mail.<br />Any opinions expressed within this e-mail are those of the individual and not necessarily of Diamond Light Source Ltd. <br />Diamond Light Source Ltd. cannot guarantee that this e-mail or any attachments are free from viruses and we cannot accept liability for any damage which you may sustain as a result of software viruses which may be transmitted in or with the message.<br />Diamond Light Source Limited (company no. 4375679). Registered in England and Wales with its registered office at Diamond House, Harwell Science and Innovation Campus, Didcot, Oxfordshire, OX11 0DE, United Kingdom<br /> </p><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.
</body>
</html>