[Cod-bugs] Unable to connect to SQL server

[Anders Blom]

Hi COD,

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?

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

[cid:image002.png at 01D9B0E4.F08684C0]

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.

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).

Kind regards,
Anders Blom


------------------------------------------------
Anders Blom, Ph.D.
Solutions Engineer, Sr Staff
EDAG, Circuit Design & TCAD Solutions
M: +1 408 874 5806 | W: +1 650 584 5000 (ext 47495) | anders.blom at synopsys.com<mailto:anders.blom at synopsys.com>
synopsys.com<http://www.synopsys.com/> | 675 Almanor Ave, Sunnyvale, CA 94085, USA

[cid:image001.png at 01D9B0E0.8735E780]<https://www.synopsys.com/silicon/quantumatk.html>



-- 
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/20230707/f2c7d5c4/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 34938 bytes
Desc: image001.png
URL: <http://lists.crystallography.net/pipermail/cod-bugs/attachments/20230707/f2c7d5c4/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 10321 bytes
Desc: image002.png
URL: <http://lists.crystallography.net/pipermail/cod-bugs/attachments/20230707/f2c7d5c4/attachment-0003.png>