[ic] DBD mysql

[Scott Martin]

----- Original Message -----
From: "Ed LaFrance" <edl at newmediaems.com>
To: <interchange-users at icdevgroup.org>
Sent: Friday, January 09, 2004 12:00 PM
Subject: Re: [ic] DBD mysql


> 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
>
Thank you, I will give it a shot!
>
>
> ===============================================================
> 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
> ===============================================================
>
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users