[ic] DBI/DBD

Webmaster interchange-users@icdevgroup.org
Tue Jan 28 10:29:01 2003


Josh,

I used your simple perl script below to test for DBD and I got the "all
good" message; however, when I configure one of my dabases to use mysql and
restart IC I get the following message:  Using MySQL,
DSN=dbi:mysql:iscl...perl: can't resolve symbol 'mysql_init'

Should your test script also work for DBI?  I changed DBD to DBI and reran
and got an error message.  I also checked the INC array then then looked
into the perl system directories listed in INC and found directories for
both DBD & DBI, so it appears my sysadmin did install DBI.  But like I said
earlier, I still get the above message when I restart IC.  Any ideas?

Colt


----- Original Message -----
From: "Joshua Lavin" <joshua@kingdomdesign.com>
To: <interchange-users@icdevgroup.org>
Sent: Wednesday, December 04, 2002 2:35 PM
Subject: Re: [ic] DBI/DBD


> > My sysadmin re-installed Perl and both DBI & DBD modules successfully.
> > We've also created a mysql database and can connect to it as the root
user
> > ok from the command prompt.  But when we restart the ic server we get an
> > error message saying that the Required Perl module DBD not
present...Line 2
> > of the configuration file.  Any ideas?
>
> Your problem is with perl.
>
> You can test for modules being found with a simple perl script:
>
> #!/usr/bin/perl -w
> use DBD::mysql
> print "all good\n";
>
> If not, then the directory containing the DBD module is not in your INC
> array. You need your sysadmin to either add it to the INC array or your
> login environment.
>
> For example, mine is set in my 'rc' file:
>
PERL5LIB="/usr/home/kingdomd/usr/local/lib/perl5:/usr/home/kingdomd/usr/loca
> l/lib/perl5/site_perl"
>
> But that's on a virtual server.
>
> Hope this helps,
> Josh
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>