[ic] DBD mysql

[Ed LaFrance]

At 10:39 AM 1/9/2004 -0500, you wrote:

>----- Original Message -----
>From: "Ed LaFrance" <edl at newmediaems.com>
>To: <interchange-users at icdevgroup.org>
>Sent: Tuesday, January 06, 2004 11:37 AM
>Subject: Re: [ic] DBD mysql
>
>
> > At 06:52 PM 1/5/2004 -0500, you wrote:
> > >On Monday 05 January 2004 06:22 pm, Scott Martin wrote:
> > > > Hello
> > > >
> > > > Running foundation demo using GBDM
> > > >
> > > > Also 4.8.7 IC on Debian Sarge, Perl 5.8.0, Apache
> > > >
> > > > Tried Installing DBD::mysql from package.  The perl module changed to
>5.8.2
> > > > and IC server says:
> > > >
> > > > We're sorry, the Interchange server is unavailable...
> > > > We are out of service or may be experiencing high system demand.
>Please try
> > > > again soon.
> > > >
> > >Also found this in IC error log:
> > >
> > >   Died in server spawn: Could not
> > > > tie to
>'/var/lib/interchange/catalogs/foundation/products/access.gdbm':
> > > > Resource temporarily unavailable at
>/usr/lib/interchange/Vend/Table/GDBM.pm
> > > > line 116.
> > >
> > >Any thoughts?
> >
> > This error message is probably unrelated to your trouble. Suggest you
> > restart interchange on the command line and observe for error messages.
> > Also check the suid and permissions on your link file.
> >
> > - Ed
> >
>Hi Ed,
>
>Thanks for your response, I am very new to this & appreciate your help. Who
>should be suid, interchange as user?, and which link are you referring.

That depends upon your webserver and interchange setup. There is some 
documentation on this issue at icdevgroup.org; spend some time there.


>I have been configuring foundation store with the GDBM default on a debian.
>How do I convert that to the mysql should I be fortunate enough to get it
>going.

Briefly, assuming you have mysql up and running and DBD::mysql installed 
for Perl, you would log into mysql as the admin, create the database for 
use by your catalog, then create a mysql user with full permissions on that 
database. Then you would set the following catalog variables:

SQLDSN          dbi:mysql:dbname
SQLUSER mysql_username
SQLPASS mysql_password
MYSQL           1

...then restart interchange.

- Ed



===============================================================
New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          edl at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax
===============================================================