[ic] Problem with lib/Vend/Table/GDBM.pm (Can MySQL be used instead?)

Ed LaFrance interchange-users@lists.akopia.com
Wed Jun 20 11:48:00 2001


At 10:38 PM 06/19/2001 -0500, you wrote:
>Hello everyone.
>
>I'm still pretty new to Interchange.
>
>I've installed a store based on the construct demo using MySQL as the
>database.  Everything seems to be working except those portions that rely on
>the .dbm files.  I've read posts regarding using the MINIVEND_DBFILE, but
>that approach did not work for my installation.  I'm in a shared hosted
>environment, so I don't have much access to reinstall Perl or things of that
>sort.
>
>Is it possible to run all the data through MySQL, rather than storing some
>in .dbm files?  Both the GDBM and DB_File implementations on my hosting
>provider's server seem to be giving me some attitude.
>
>I've read through the documentation regarding how Interchange uses
>databases, but I'm not totally clear what the process would be to move the
>data in the .dbm files into MySQL.
>

You might want to try a script which was included with IC 4.6.x (don't know 
about 4.7.x): cpan_local_install.  You should find it within the IC 
distribution directory: interchange-4.6.x/dist/src/.  This assumes that you 
installed IC in your home directory using the .tar.gz dist.  If your 
hosting provider runs interchange centrally and merely provides you with a 
catalog, you should complain loudly about any missing or broken Perl 
modules.  Failing both of those, you can go into yourcat/dbconf/mysql, and 
try your hand at converting all the .dbm database definitions into mysql 
definitions - there are plenty of the latter to follow as examples.

- Ed L.




===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================