ERROR in DBI connect orthomclInstallSchema

[kai3192]

Hello,
I am using orthomcl ... at the step 5 (orthomclInstallSchema) in the manual (http://orthomcl.org/common/downloads.../UserGuide.txt) it gives me an error saying 'DBI connect('orthomcl:localhost:3307','orthomcl',...) failed: Access denied for user 'orthomcl'@'localhost' (using password: YES) at /home/kaivalya3192/orthomclSoftware-v2.0.8/bin/../lib/perl/OrthoMCLEngine/Main/Base.pm line 56
kaivalya3192@ubuntu:~/orthomclSoftware-v2.0.8/bin$' ...

Can somebody please help me ???

Thank you...

[SES]

It appears you don't have permissions on the database. You will need to create a database and give a user permissions on that. Then, create a simple config file like the one printed when you run orthomclInstallSchema with no arguments. In that config file you will include the database name, user and password and names for the tables to create. If you run the program again with the config file as the only argument, it should work. Let us know if that does not solve your problem.

[kai3192]

I should create a config file in orthomcl means that I need to edit the preexisting file orthomcl.config.template right ??
I did edit that and entered the same database name and password as for the database i created in mysql... i also entered same user name a nd have granted the privileges for that user name in mysql for the same database....

IT IS STILL GIVing me an error 'DBI connect('orthomcl:3307','kaivalya3192',...) failed: Can't connect to MySQL server on '3307' (22) at /home/kaivalya3192/orthomclSoftware-v2.0.8/bin/../lib/perl/OrthoMCLEngine/Main/Base.pm line 56'

[SES]

IT IS STILL GIVing me an error 'DBI connect('orthomcl:3307','kaivalya3192',...) failed: Can't connect to MySQL server on '3307' (22) at /home/kaivalya3192/orthomclSoftware-v2.0.8/bin/../lib/perl/OrthoMCLEngine/Main/Base.pm line 56'

Okay, now this is a different error and it indicates your serving is not running. Start the daemon (mysqld or mysqld_safe) and then try to connect. By the way, you can use the following command to see if the daemon is running.

ps aux | grep mysqld

[kai3192]

When I use the script u just gave me it says

mysql 1033 0.0 0.5 492532 43256 ? Ssl 10:21 0:02 /usr/sbin/mysqld
1000 5070 0.0 0.0 8108 924 pts/1 R+ 21:19 0:00 grep --color=auto mysqld

[kai3192]

does this mean that the Daemon is working ??

[SES]

At this point, I recommend you try to connect to the database from the command line. If you are able to do so, that would suggest there is a typo in your config file or possibly something wrong with your DBI installation/configuration.

[kai3192]

I was able to connect to the database using commandline using the user root, but not using the user kaivalya3192

[SES]

I was able to connect to the database using commandline using the user root, but not using the user kaivalya3192

I think that points to your issue because the DBI module is just an interface, and you'll have to be able to connect using the credentials you provide.

[GenoMax]

Original post indicated that the user is/needs to be "orthomcl". Isn't that still valid?

[kai3192]

Thank you so much... It just worked and I was able to run the OrthomclInstallSchema....

BUT NOW I am getting an error in the 9th step orthomclLoadBlast saying 'DBD::mysql::st execute failed: The used command is not allowed with this MySQL version at orthomclLoadBlast line 39, <F> line 14.'

[kai3192]

I am using ubuntu.... and I have installed MySQL version 5.5 server.... I aslo tried reinstalling by building the source and then typing DENABLED--local-infile=1 while using the c-make command...

After installation it still does not work...

[SES]

I am using ubuntu.... and I have installed MySQL version 5.5 server.... I aslo tried reinstalling by building the source and then typing DENABLED--local-infile=1 while using the c-make command...

After installation it still does not work...

If you see the server running and you can connect and create databases, then you probably have a working installation. That error is most likely a Perl DBI error, so I would suggest you take a look at the DBI test suite and see if everything is installed correctly. Or, install a more recent DBI version.

So, try to get the database access working again and then re-install Perl DBI and see if that doesn't solve your problems. Good luck.

[gyuxutong]

Thank you so much... It just worked and I was able to run the OrthomclInstallSchema....

I encounter the same question you mentioned. Could you give me a help to pass the first step, running the OrthomclInstallSchema. Thank you.

[amaruquyllur]

Thank you so much... It just worked and I was able to run the OrthomclInstallSchema....

BUT NOW I am getting an error in the 9th step orthomclLoadBlast saying 'DBD::mysql::st execute failed: The used command is not allowed with this MySQL version at orthomclLoadBlast line 39, <F> line 14.'

Hello. Thanks god i found your thread.

I am still stuck in your first problem. Even if i put "root" and my root password in the .config file, i cannot connect. I have the same message error that you had.

Did you do some extra things or it just worked like that?

Thanks.