[Cod-bugs] Unable to connect to SQL server

[Antanas Vaitkus]

Dear Anders Blom,

I just tried running your query [1] useing MySQL/MariaDb from my machine
and everything
works as expected so the issue is most likely on your end.

I also attach a file with the results of the query in case they would prove
useful for you in the short term.

[1] mysql -u cod_reader -h sql.crystallography.net -e "select file from
data where ((LOWER(formula) RLIKE ' ag') AND (nel = 1))" cod

On Fri, 7 Jul 2023 at 16:29, Anders Blom <Anders.Blom at synopsys.com> wrote:

> 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
>
>
>
>
>
> 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
> synopsys.com <http://www.synopsys.com/> | 675 Almanor Ave, Sunnyvale, CA
> 94085, USA
>
>
> <https://www.synopsys.com/silicon/quantumatk.html>
>
>
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by *MailScanner* <http://www.mailscanner.info/>, and is
> believed to be clean.
> _______________________________________________
> Cod-bugs mailing list
> Cod-bugs at lists.crystallography.net
> http://lists.crystallography.net/cgi-bin/mailman/listinfo/cod-bugs
>


-- 
Antanas Vaitkus,
Vilnius University,
Life Sciences Center,
Institute of Biotechnology,
room C521, Saulėtekio al. 7,
LT-10257 Vilnius, Lithuania

-- 
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/65c2474e/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 34938 bytes
Desc: not available
URL: <http://lists.crystallography.net/pipermail/cod-bugs/attachments/20230707/65c2474e/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 10321 bytes
Desc: not available
URL: <http://lists.crystallography.net/pipermail/cod-bugs/attachments/20230707/65c2474e/attachment-0003.png>
-------------- next part --------------
file
1100136
1509145
1509146
1509194
1512487
5000218
9008459
9011607
9011608
9012431
9012961
9013045
9013046
9013047
9013048
9013049
9013050
9013051
9013052
9013053