[Cod-bugs] cannot connect through mysql

[Keeble, Dean (DLSLtd,RAL,LSCI)]

Hi,

I'm investigating how to perform some searches in the COD programmatically via the mysql interface. In following the example online <https://wiki.crystallography.net/howtoquerycod/> 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.

Many thanks in advance for your help!

All the best,
Dean

$ ping -c 1 sql.crystallography.net
PING sql.crystallography.net (158.129.170.75) 56(84) bytes of data.
64 bytes from 158.129.170.75 (158.129.170.75): icmp_seq=1 ttl=46 time=47.7 ms

--- sql.crystallography.net ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 47.777/47.777/47.777/0.000 ms

$ mysql -u cod_reader -h sql.crystallography.net -e 'select count(*) from data where flags like "%has Fobs%"' cod | cat
ERROR 2003 (HY000): Can't connect to MySQL server on 'sql.crystallography.net' (110)

$ mysql --version
mysql  Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1


Dean S. Keeble
Data Analysis Scientist - Diffraction
Diamond Light Source,
Harwell Campus, Oxon., OX11 0DE.


-- 
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.
Any opinions expressed within this e-mail are those of the individual and not necessarily of Diamond Light Source Ltd. 
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.
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


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.crystallography.net/pipermail/cod-bugs/attachments/20220413/6ec6fe7d/attachment.htm>