Seqanswers Leaderboard Ad

Collapse

Announcement

Collapse
No announcement yet.
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • ERROR in DBI connect orthomclInstallSchema

    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...
    Last edited by kai3192; 06-14-2013, 01:59 PM. Reason: Typing Error

  • #2
    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.

    Comment


    • #3
      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'

      Comment


      • #4
        Originally posted by kai3192 View Post
        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.

        Code:
        ps aux | grep mysqld

        Comment


        • #5
          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

          Comment


          • #6
            does this mean that the Daemon is working ??

            Comment


            • #7
              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.

              Comment


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

                Comment


                • #9
                  Originally posted by kai3192 View Post
                  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.

                  Comment


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

                    Comment


                    • #11
                      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.'

                      Comment


                      • #12
                        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...

                        Comment


                        • #13
                          Originally posted by kai3192 View Post
                          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.

                          Comment


                          • #14
                            Originally posted by kai3192 View Post
                            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.

                            Comment


                            • #15
                              Originally posted by kai3192 View Post
                              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.

                              Comment

                              Latest Articles

                              Collapse

                              • seqadmin
                                Strategies for Sequencing Challenging Samples
                                by seqadmin


                                Despite advancements in sequencing platforms and related sample preparation technologies, certain sample types continue to present significant challenges that can compromise sequencing results. Pedro Echave, Senior Manager of the Global Business Segment at Revvity, explained that the success of a sequencing experiment ultimately depends on the amount and integrity of the nucleic acid template (RNA or DNA) obtained from a sample. “The better the quality of the nucleic acid isolated...
                                03-22-2024, 06:39 AM
                              • seqadmin
                                Techniques and Challenges in Conservation Genomics
                                by seqadmin



                                The field of conservation genomics centers on applying genomics technologies in support of conservation efforts and the preservation of biodiversity. This article features interviews with two researchers who showcase their innovative work and highlight the current state and future of conservation genomics.

                                Avian Conservation
                                Matthew DeSaix, a recent doctoral graduate from Kristen Ruegg’s lab at The University of Colorado, shared that most of his research...
                                03-08-2024, 10:41 AM

                              ad_right_rmr

                              Collapse

                              News

                              Collapse

                              Topics Statistics Last Post
                              Started by seqadmin, Yesterday, 06:37 PM
                              0 responses
                              8 views
                              0 likes
                              Last Post seqadmin  
                              Started by seqadmin, Yesterday, 06:07 PM
                              0 responses
                              8 views
                              0 likes
                              Last Post seqadmin  
                              Started by seqadmin, 03-22-2024, 10:03 AM
                              0 responses
                              49 views
                              0 likes
                              Last Post seqadmin  
                              Started by seqadmin, 03-21-2024, 07:32 AM
                              0 responses
                              67 views
                              0 likes
                              Last Post seqadmin  
                              Working...
                              X