[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Selecting a Database via Web, via InterChange
At 04:00 PM 10/4/2002 -0500, you wrote:
>Ok, so where would it be that I set these settings? In
>/var/lib/interchange/foundation/products/varible.txt? How do i get the
>stupid thing to not use GDBM (it seems insistent on that)? I think I
>have all the rest of my automation done except this one.
If you look at the table definition files in yourcat/dbconf/mysql you will
see that some tables are still defined to be dbm's. You would want to
convert those to mySQL definitions and optionally add COLUMN_DEF's to each
file for the fields in those tables, if you want to go 100% SQL. I think
you would need to hard-code the SQL* variables I mentioned in my previous
post into catalog.cfg, very near the top of the file, in this case; leaving
them in the variable table would be putting the chicken before the egg.
- Ed L.
>Chris Tooley
>
>On Fri, 2002-10-04 at 08:37, Ed LaFrance wrote:
> > At 12:28 AM 10/4/2002 -0400, you wrote:
> > >Excuse my Newbility...
> > >I have set up my interchange cart. Everything but the database (as far as
> > >editing/updating via the web interface) is working great.
> > >
> > >I have MySQL on the server..ready to go. Only thing is, I am not familiar
> > >with the way Interchange selects mySQL. I am new to mySQL and new to
> > >InterChange.
> > >
> > >How do I utilize mySQL for use with my Interchange Cart?
> > >
> > >This is all I could find from my mySQL area ...but what do I need to do to
> > >get it working AND do I need to upload the database file to mySQL on my
> > >server OR will InterChange place it there?
> > >
> > >$dbh =
> > >DBI->connect("DBI:mysql:database_name_:localhost","username","<password
> >");
> > >
> > >I have been up and down the information and all I can find is where
> you can
> > >set if the db will be variable. I can't seem to locate where it might
> allow
> > >you to choose what database you will run and such...like the way it
> lets you
> > >select which payment gateway you are using. Is there such a field.
> > >
> > >Thanks in advance
> > >
> > >Chris Bartholomew....Accomplished artist, struggling programmer.
> >
> > With the distributed foundation demo, if you set the catalog variables as
> > follows:
> >
> > MYSQL 1
> > SQLDSN dbi:mysql:dbname
> > SQLUSER mysql_username
> > SQLPASS mysql_pass
> >
> > ...and reconfig the catalog (or restart Interchange), IC should connect to
> > mysql and build the tables for the catalog, provided that:
> >
> > 1. You have already created dbname in mysql, and given full privileges on
> > it to mysql_username
> >
> > 2. You have installed the Bundle::DBI and DBD::mysql Perl modules
> successfully.
> >
> > - Ed L.
> >
> >
> > ===============================================================
> > New Media E.M.S. Technology 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
> > ===============================================================
> >
> > _______________________________________________
> > interchange-users mailing list
> > interchange-users@icdevgroup.org
> > http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>_______________________________________________
>interchange-users mailing list
>interchange-users@icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users
===============================================================
New Media E.M.S. Technology 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
===============================================================