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>