CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
Perl-MySQL interface problem with GENE counter

 



Jonny_D
New User

Apr 19, 2013, 4:34 AM

Post #1 of 3 (10902 views)
Perl-MySQL interface problem with GENE counter Can't Post

 Hi!

First time poster.

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 which is part of a large pipeline called GENE-counter (used to analyse transcriptomic data). 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 (-n, -v, variables aren't important, -i is the input file location, -d is the mysql database, -f is required by the script itself)

>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


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


FishMonger
Veteran / Moderator

Apr 19, 2013, 6:12 AM

Post #2 of 3 (10897 views)
Re: [Jonny_D] Perl-MySQL interface problem with GENE counter [In reply to] Can't Post

You need to post the installDBRNASEQ.pl script so we can see what params it accepts and how they're used.

Post it as an attachment.


(This post was edited by FishMonger on Apr 19, 2013, 6:13 AM)


Jonny_D
New User

Apr 19, 2013, 6:33 AM

Post #3 of 3 (10893 views)
Re: [FishMonger] Perl-MySQL interface problem with GENE counter [In reply to] Can't Post

Hi FishMonger,

thanks for the reply. 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.

That was painful...

Jonny

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives