Skip to content

Connection error when using custom dataset #7

Description

@limwching190

Hi, I am trying to run correlationAnalyzeR using my own dataset. I managed to generate the correlations using the following command:
corrMat <- generateCorrelations(cts, transformed = T)

However, there is a connection error when running the following code:

                          corrMat = corrMat,
                          crossCompareMode = FALSE,
                          corrMat_label = "User-Supplied",
                          TERM2GENE = NULL)

Error message:

Warning in analyzeSingleGenes(genesOfInterest = c("CD68"), corrMat = corrMat,  :
  Failed to establish connection to database ... retrying now ... 3 attempts left.
Warning in analyzeSingleGenes(genesOfInterest = c("CD68"), corrMat = corrMat,  :
  Failed to establish connection to database ... retrying now ... 2 attempts left.
Error in analyzeSingleGenes(genesOfInterest = c("CD68"), corrMat = corrMat,  : 
  Unable to connect to database. Check internet connection and please contanct package maintainer if you believe this is an error.

I checked the script and try to connect to the database, but it says unknown server host, as below:

conn <- try(silent = T, eval({
+       DBI::dbConnect(
+         drv = RMySQL::MySQL(),
+         user = "public-rds-user@m2600az-db01p.mysql.database.azure.com", port = 3306,
+         dbname="correlation_analyzer",
+         password='public-user-password',
+         host="m2600az-db01p.mysql.database.azure.com"
+       )
+     }))
> conn
[1] "Error in .local(drv, ...) : \n  Failed to connect to database: Error: Unknown server host 'm2600az-db01p.mysql.database.azure.com' (11001)\n\n"
attr(,"class")
[1] "try-error"
attr(,"condition")
<simpleError in .local(drv, ...): Failed to connect to database: Error: Unknown server host 'm2600az-db01p.mysql.database.azure.com' (11001)

Does anyone have any suggestions or solution to this issue? Thank you very much!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions