Seqanswers Leaderboard Ad

Collapse

Announcement

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

  • GENE-counter installation problem

    Hi!

    First time poster.

    First off, I'm extremely new to Perl / MySQL / Linux (Ubuntu), so there is every chance that I'm doing something ridiculous. Any help would be greatly appreciated. If i'm asking in the wrong place, sorry.

    I'm trying to install a sequence database using the installDBRNASEQ.pl script. I have set up a MySQL database, I can log in and out without any problems, but when I run the command below from the appropriate folder location:

    >perl installDBRNASEQ.pl -n Arabidopsis -v TAIR10 -i /home/jonny -d rnaseq -f

    I get the following error message:

    DBI connect('rnaseq:;mysql_local_infile=1','',...) failed: Access denied for user 'root'@'localhost' (using password: NO) at /usr/local/lib/perl/GENE-counter-v0.4.4/src/installRNASEQ/../commonRNASEQ/commonRNASEQ.pm line 321.
    Error: cannot connect to supplied database.

    I have tried propmting for a password using derivatives of:

    >perl installDBRNASEQ.pl -n Arabidopsis -v TAIR10 -i /home/jonny -d rnaseq -f -p
    etc.

    I'm not sure I expect that to work however as I'm running everything through Perl here. I can run another terminal window, connect to the relevant MySQL database etc., but I don't know how to specify a password and connect to the database using the above command?

    Any thoughts /comments would be greatly appeciated. If anyone is willing to help I can post more info as needed.

    Jonny

  • #2
    Solution

    I think I've got to the root problem (in the last few minutes actually) which relates to a change in syntax from TYPE=MyISAM, to ENGINE=MyISAM in one of the associated Perl scripts which connects data to the mysql database. The latest MySQL update changed the syntax and I guess some Perl scripts must be lagging behind.

    Comment

    Latest Articles

    Collapse

    • seqadmin
      Recent Advances in Sequencing Analysis Tools
      by seqadmin


      The sequencing world is rapidly changing due to declining costs, enhanced accuracies, and the advent of newer, cutting-edge instruments. Equally important to these developments are improvements in sequencing analysis, a process that converts vast amounts of raw data into a comprehensible and meaningful form. This complex task requires expertise and the right analysis tools. In this article, we highlight the progress and innovation in sequencing analysis by reviewing several of the...
      05-06-2024, 07:48 AM
    • seqadmin
      Essential Discoveries and Tools in Epitranscriptomics
      by seqadmin




      The field of epigenetics has traditionally concentrated more on DNA and how changes like methylation and phosphorylation of histones impact gene expression and regulation. However, our increased understanding of RNA modifications and their importance in cellular processes has led to a rise in epitranscriptomics research. “Epitranscriptomics brings together the concepts of epigenetics and gene expression,” explained Adrien Leger, PhD, Principal Research Scientist...
      04-22-2024, 07:01 AM

    ad_right_rmr

    Collapse

    News

    Collapse

    Topics Statistics Last Post
    Started by seqadmin, 05-14-2024, 07:03 AM
    0 responses
    26 views
    0 likes
    Last Post seqadmin  
    Started by seqadmin, 05-10-2024, 06:35 AM
    0 responses
    45 views
    0 likes
    Last Post seqadmin  
    Started by seqadmin, 05-09-2024, 02:46 PM
    0 responses
    59 views
    0 likes
    Last Post seqadmin  
    Started by seqadmin, 05-07-2024, 06:57 AM
    0 responses
    46 views
    0 likes
    Last Post seqadmin  
    Working...
    X