DBI connect failed: orthomclLoadBlast
0
1
Entering edit mode
5.7 years ago
max_19 ▴ 170

Hi guys,

I am trying to run OrthoMCL on a remote server. When I get to the orthomclLoadBlast step, I keep getting this error message:

$ orthomclLoadBlast orthomcl.config similarSequences.txt

DBI connect('max_orthomcl','max',...) failed: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

I have been searching for a while, and it appears that the socket declaration should be in the my.cnf file. However socket is not specified in my.cnf file for me, and I cannot edit this file as part of the rules of using this server. Anyone know a way to fix this?

Not sure if this helps but here is the socket information if i do this in mysql:

$mysql
MariaDB [(none)]> show variables like 'socket';
+---------------+----------------------------+
| Variable_name | Value                      |
+---------------+----------------------------+
| socket        | /data/mariadb/mariadb.sock |
+---------------+----------------------------+
1 row in set (0.00 sec)

Any input is greatly appreciated.

orthomcl mcl sequence protein • 2.7k views
ADD COMMENT
0
Entering edit mode

are you sure you are using the correct credentials to access this remote SQL server? and set the ports to use correctly ?

ADD REPLY
0
Entering edit mode

I made sure the credentials in the my.cnf file match those in the orthomcl.config (below)

dbVendor=mysql 
dbConnectString=dbi:mysql:max_orthomcl
dbLogin=max
dbPassword=Password
dbname=max_orthomcl
similarSequencesTable=SimilarSequences
orthologTable=Ortholog
inParalogTable=InParalog
coOrthologTable=CoOrtholog
interTaxonMatchView=InterTaxonMatch
percentMatchCutoff=50
evalueExponentCutoff=-3
oracleIndexTblSpc=NONE

and I can see the database 'max_orthomcl' when I go into mysql

MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| max_orthomcl     |
+--------------------+

can you please let me know how i can check if ports are set up?

ADD REPLY
1
Entering edit mode

Are you running this on a compute cluster or such? If so , can you also check if you can actually access the MySQL server from the machine where you try to run OrthoMCL ?

ADD REPLY
0
Entering edit mode

Yes it is a compute cluster. I am trying to run both orthoMCL and MySQL from it. If I try to access mysql server using 'mysql' it appears to be working fine

$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g....etc etc

is there any other test I should try?

ADD REPLY
1
Entering edit mode

yes, try to connect to the specific orthomcl DB from the cluster, something like following:

mysql -h <hostname> -u max  max_orthomcl -p

in other words, try to connect to the required DB from the commandline using the credentials from your config file

ADD REPLY
0
Entering edit mode

Thanks. I tried this and I got :

$ mysql -u max -D max_orthomcl -p password -h host
>Enter password: 
ERROR 1045 (28000): Access denied for user 'max' (using password: YES)
ADD REPLY
2
Entering edit mode

voila there you have your answer: the 'max' account has no access to the mysql DB.

create an account on that server with the correct rights and then it should work. Alternatively try to use an account called orthomcl (it might be that that is the default one that is being created by orthomcl itself).

is your mysql server really called 'host' ?

ADD REPLY
1
Entering edit mode

I will contact the cluster administrators then, thank you for the help! No that is not the actual host name (Just put that to show the command/arguments that were run).

ADD REPLY
0
Entering edit mode

It's actually working now (I can access that specific DB from the cluster). apparently if you remove the space between -p and your password it works fine.

$ mysql -u max -D max_orthomcl -ppassword -h host

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Server version: 10.2.13-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [max_orthomcl]>

any other ideas what could be causing the issue? I still get the same error when I try to run orthomclLoadBlast

ADD REPLY
0
Entering edit mode

Hmm, running out of ideas here.

perhaps this post can help you further: http://seqanswers.com/forums/archive/index.php/t-31112.html ? (start from the bottom)

ADD REPLY

Login before adding your answer.

Traffic: 1133 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6