[Cod-bugs] {Disarmed} Re: Unable to connect to SQL server

Fri Jul 7 17:18:32 EEST 2023

Dear Anders,

I am very glad to hear that your company finds the COD useful. I am not in
the position to individually
make high-level policy decisions, but I will definitely forward your email
to my supervisor (Saulius Gražulis)
and other members of the COD Advisory Board. Please keep in mind, however,
that it may take some time
for them to respond as most of them have other primary work
responsibilities.

Please also let us know if you need any additional assistance at resolving
the database connection issues on your end.

Sincerely
Antanas

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

> Thank you for the quick response, Antanas. It’s very good to know that the
> server is working.
>
>
>
> Let me give some context also on this. I work for the team that develops
> the atomic-scale modeling tool QuantumATK for DFT and other simulations.
> The company was QuantumWise earlier, before being acquired in 2017 by
> Synopsys.
>
>
>
> We have for several years provided an interface to COD in our GUI, which
> allows users to build relatively advanced queries with a few clicks, and
> then retrieve and directly use structures from COD in their simulations. An
> example is shown in one of our tutorials:
> https://docs.quantumatk.com/tutorials/li_ion_diffusion/li_ion_diffusion.html#import-lifepo4-bulk-structure
>
>
>
> If relevant and interesting to COD, we could perhaps consider making this
> a more formal partnership, although I have to consult other people on my
> side in terms of co-marketing or PR announcements.
>
>
>
> Let me also point out that QuantumATK is essentially free for academic use
> in Europe, as it is provided via EuroPractice (
> https://www.europractice.stfc.ac.uk/tools/synopsys_details.html#QATK) for
> a cost of only ~€100 per year for a practically unlimited license. We would
> be delighted if you would consider promoting QuantumATK to your friends and
> colleagues – our DFT-LCAO code is particularly useful for large-scale
> simulations of 1000+ atoms, even with HSE, and recently we have taken big
> steps towards automating fitting of machine-learned MTP forcefields!
>
>
>
> So, now I just have to figure out if there are some special firewall rules
> that need to be set for it to work from at least our own internal network.
>
>
>
> With thanks, and with hopes for a continued mutually beneficial
> relationship,
>
> Anders
>
>
>
>
>
>
>
>
>
>
>
> ------------------------------------------------
>
> *Anders Blom, Ph.D.*
> Solutions Engineer, Sr Staff
>
> EDAG, Circuit Design & TCAD Solutions
>
> +1 650-584-5000 (ext 47495)
>
>
>
> *From:* Antanas Vaitkus <antanas.vaitkus90 at gmail.com>
> *Sent:* Friday, July 7, 2023 15:33
> *To:* Anders Blom <andersb at synopsys.com>
> *Cc:* cod-bugs at ibt.lt; Bo Lue <bolu at synopsys.com>
> *Subject:* Re: [Cod-bugs] Unable to connect to SQL server
>
>
>
> 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
> <https://urldefense.com/v3/__http:/sql.crystallography.net__;!!A4F2R9G_pg!eWRgu5jS9uWlm2_CBj1I4LlR8nz0Z0XnbZbgrjDsj_B0oeW2Q8r9K4tpNypBOl2WK0gGVYOsnL6SvbLll7PTWDiJUPRYMQ$>
> -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*
> <https://urldefense.com/v3/__http:/www.mailscanner.info/__;!!A4F2R9G_pg!eWRgu5jS9uWlm2_CBj1I4LlR8nz0Z0XnbZbgrjDsj_B0oeW2Q8r9K4tpNypBOl2WK0gGVYOsnL6SvbLll7PTWDji36vMrQ$>,
> 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
> <https://urldefense.com/v3/__http:/lists.crystallography.net/cgi-bin/mailman/listinfo/cod-bugs__;!!A4F2R9G_pg!eWRgu5jS9uWlm2_CBj1I4LlR8nz0Z0XnbZbgrjDsj_B0oeW2Q8r9K4tpNypBOl2WK0gGVYOsnL6SvbLll7PTWDhq5hQw9Q$>
>
>
>
> --
>
> Antanas Vaitkus,
>
> Vilnius University,
> Life Sciences Center,
> Institute of Biotechnology,
> room C521, Saulėtekio al. 7,
> LT-10257 Vilnius, Lithuania
>
>
>

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