This is a test version of Biostars. For the public version, visit https://www.biostars.org.
OrthoMCL problem when connecting with mysql

Hi,

I am trying to use OrthoMCL. Having problem at the step 8. I am getting this message over and over again.

DBD::mysql::st execute failed: The used command is not allowed with this MySQL version at .......orthomclSoftware-v2.0.9/bin/orthomclLoadBlast line 39, <f> line 14.

My command was: ...bin/orthomclLoadBlast .....orthomclSoftware-v2.0.9/my_orthomcl_dir/orthomcl.config.template ....orthomclSoftware-v2.0.9/my_orthomcl_dir/compliantFasta/similarSequences

I have installed mysql-8.0.11-macos10.13-x86_64.dmg in MacOS High Sierra 10.13.6

I have tried to add: dbConnectString=dbi:mysql:orthomcl:mysql_local_infile=1 to my orthomcl.config.template file. Still not working.

Please help me. Thanks.

genome gene software error
• 2,493 views • link
updated by Biostar Biostar • written by Seq225 Seq225

You can try orthofinder or get_homologues instead for gene family clustering or identification of orthologs. Neither of them needs mysql connection.

• 1 views • link
written by Sishuo Wang Sishuo Wang

you're working with a 2013 software (orthMCL) and a 2018 version of MySQL. In case you're not keen on reading the MySQL releas notes and then troubleshooting the orthoMCL source code to update all connection parameters, try an older release:

see https://en.wikipedia.org/wiki/MySQL#Release_history

• 1 views • link
written by Carambakaracho Carambakaracho

Thank you. Yes, that is the case. I tried older version of mysql. It was a mess (for me). Now I am trying to get the command for the new version.

• 0 views • link
written by Seq225 Seq225

0 answers

No answers yet.

Log in to answer this question.

More posts like this