Access Issue :mysqladmin flush-hosts

[Chen, John]

Hi

I recently setup a new Genome Browser for our use at NYU hospital  ( based on the Virtual Box image).  The server is up and running.  But when user access the link, then get an Error.  Any help is greatly appreciated.   If possible could someone explain to me how this entire research site works ?  Does it get the data from externally or locally?  I search that it try local first then outside… (assuming we have a local copy).   

This is the below error.

Warning/Error(s):

• Couldn't connect to database hg38 on genome-mysql.cse.ucsc.edu as genomep.
  Host '216.165.126.118' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

John Chen

Unix Server Operations

360 Park ave S, 12th floor

New York, NY 10010

Email: john....@nyumc.org

------------------------------------------------------------
This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is proprietary, confidential, and exempt from disclosure under applicable law. Any unauthorized review, use, disclosure, or distribution is prohibited. If you have received this email in error please notify the sender by return email and delete the original message. Please note, the recipient should check this email and any attachments for the presence of viruses. The organization accepts no liability for any damage caused by any virus transmitted by this email.
=================================

[Brian Lee]

Dear John,

Thank you for using the UCSC Genome Browser in a Box (GBiB) on Virtual Box and your question about connections issues.

One of our engineers shares that this error happens when GBiB has not mirrored some tracks, or another needed table. He asks if you are able to open the mysql port in your firewall?

If you are not able to open the port, can you look into the apache error log on the GBiB at /var/log/apache2/error.log to help our engineers give an idea what is missing. Please send this to our more private genom...@soe.ucsc.edu mailing list, where information is kept within our team of engineers. Another piece of information that would be helpful is to know what VM solution you are using, VMWware or Microsoft HyperV or another?

Thank you again for your inquiry and using the UCSC Genome Browser. If you have public questions, please send to gen...@soe.ucsc.edu. All messages sent to that address are archived on a publicly-accessible forum. If your question includes sensitive data, you may send it instead to genom...@soe.ucsc.edu.

All the best,

Brian Lee
UCSC Genomics Institute

> --
>

[Brian Lee]

Dear John,

Thank you for using the UCSC Genome Browser and your question about connecting to genome-mysql.cse.ucsc.edu and about being blocked because of many connection errors.

I'm sending an email for our mailing list archives to explain that it sounds as though the connection issue was part of a 'stateful firewall' security from your institution, where some packets of information where allowed initially, but connections where then ended, and our public MySQL server then acted to not allow your IP to open new connections due due to default MySQL behavior to limit connections that are generating too many errors.

For future readers wishing to test connections, a GBiB command "sqlUcsc", aliased to "mysql --no-defaults -h genome-mysql.cse.ucsc.edu -u genome -A" can be used on GBiB to test connections along with a "ping genome-mysql.cse.ucsc.edu" or "telnet genome-mysqlcse.ucsc.edu 3306".

Thank you again for your inquiry and using the UCSC Genome Browser. If you have any further questions, please reply to gen...@soe.ucsc.edu. All messages sent to that address are archived on a publicly-accessible forum. If your question includes sensitive data, you may send it instead to genom...@soe.ucsc.edu.

All the best,

Brian Lee
UCSC Genomics Institute