Hi Suo,

please execute the following perl code on your machine.

##############################
#!/usr/bin/perl
use strict;
use DBI;

my $conString = "dbi:mysql:database=ensembl_mart_52;host=martdb.ensembl.org;port=5316;user=anonymous";

my $dbh = DBI->connect($conString) or die "Couldn't connect to database: " . DBI->errstr;

##############################

let me know what you see,

thanks,
Syed



On 21/10/2010 19:28, suo wrote:
Hello all:

I am installing biomart0.7 on MySQL5 on RHEL5. There is some problem when 
issuing:

perl bin/configure.pl -r conf/myRegistry.xml

Here is the error message:

DBD::mysql::st execute failed: Table 'mymart.meta_conf__user__dm' doesn't exist 
at /root/biomart-perl/bin/../lib/BioMart/Configuration/MartDBLocation.pm line 
210.

ERROR something wrong with your registry: DBD::mysql::st execute failed: Table 
'mymart.meta_conf__user__dm' doesn't exist at 
/root/biomart-perl/bin/../lib/BioMart/Configuration/MartDBLocation.pm line 210.


Here is my myRegistry.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE MartRegistry>
<MartRegistry>

<MartDBLocation
                     name         = "my_mart"
                     displayName  = "My BioMart Database"
                     databaseType = "mysql"
                     host         = "127.0.0.1"
                     port         = "3306"
                     database     = "mymart"
                     schema       = "mymart"
                     user         = "root"
                     password     = "******"
                     visible      = "1"
                     default      = ""
                     includeDatasets = ""
                     martUser     = ""
/>
</MartRegistry>





Reply via email to