[ic] IC Segmentation fault - HELP!
Marty Tennison
interchange-users@icdevgroup.org
Tue Apr 1 13:06:00 2003
On Tue, 2003-04-01 at 08:47, McTees wrote:
> I can access the database from mySQL without any problems.
[snip]
> Configuring catalog store...Using MySQL,
> DSN=dbi:mysql:mc_store...Segmentation fault
[snip]
Accessing Mysql from command line is different from accessing it through
dbi/dbd.
You'll probably want to write a perl script and test your dbi/DBD
installation. Something like...
#!/usr/bin/perl -w
use DBI;
$dbh =
DBI->connect("dbi:mysql:prod;mysql_read_default_file=${homedir}/.my.cnf") or die "cant connect";
$sth = $dbh->prepare("select code,name from area");
$sth->execute();
while ( ( $code, $name ) = $sth->fetchrow_array ) {
$area{$code} = $name;
}
$dbh->disconnect() or warn "disconnect failed";
Note: this is just a snippet from a script. you'll need to modify to
show values and such and put in a lot of debug stuff.
--
Marty Tennison <marty@sediva.com>