langcog / childesr

R interface to childes-db
14 stars 6 forks source link

Can't connect to MySQL server #43

Closed jinyoungjo closed 4 years ago

jinyoungjo commented 4 years ago

Hello,

Using the childesr package for the first time, I encountered this error message while trying to run the following code:

utt <- get_utterances(corpus = "Brown", target_child = "Adam")

Error in .local(drv, ...) : Failed to connect to database: Error: Can't connect to MySQL server on 'ec2-54-68-171-132.us-west2.compute.amazonaws.com' (0)

Could anyone identify what the problem is?

Thanks in advance!

smeylan commented 4 years ago

We see this most often when people try to access the database from a guest network at a university or from a coffeeshop where the firewall limits traffic on certain ports. Is either of these the case?

We should probably have some error-catching code on the R client that checks another MySQL server to see if it is a more general MySQL problem

jinyoungjo commented 4 years ago

Yes, I was using the university wifi, so that should have been the problem. Thank you for your reply!