Re: [ic] MYsql?

[dingdong <dingdong.sobida@q-linux.com>]

Ed,

I've followed your note and was able to create/import the product table
on my PostgreSQL but i get the "Undefined catalog: /cgi-bin/catalog"
but if i comment the lines concerning the SQL server it runs perfectly.

Any ideas.


Yo


Ed LaFrance wrote:

> At 10:02 AM 03/23/2001 -0700, you wrote:
> >So I need to make a new catalog in order to switch? It makes sense, I was
> >just hoping for a less involved solution. Lazy again :)
>
> NO, you can just edit the catalog.cfg for your existing catalog:
>
> Variable    SOMESQL         1
> Variable    MYSQL           1
> #Variable    PGSQL
> #Variable    ORACLE
> Variable    SQLDSN          dbi:mysql:databasename
> Variable    SQLDB           databasename
> Variable    SQLUSER         username
> Variable    SQLPASS         password
>
> Create a database with 'databasename' in mysql and grant all privileges to
> username@localhost identified by 'password'.  Then make the changes to you
> catalog.cfg (like above) and restart interchange. If all goes well you
> should see the table creation messages echoed to the screen and the data
> will be be imported.  You can look in yourcat/dbconf/mysql to see the table
> definition files.
>
> You will need to have the proper Perl modules installed before doing any of
> this - they are listed in the docs for SQL Support.
>
> - Ed L.
>
> >GL
> >
> >----- Original Message -----
> >From: Jason Kohles <jkohles@redhat.com>
> >To: <interchange-users@lists.akopia.com>
> >Sent: Friday, March 23, 2001 9:33 AM
> >Subject: Re: [ic] MYsql?
> >
> >
> > > On Fri, Mar 23, 2001 at 09:29:46AM -0700, George Loch wrote:
> > > > How many folks have taken the construct demo and converted it to a mysql
> >DB
> > > > instead of the flat file? What is the procedure other than by hand?
> > > >
> > > It should take nothing more than telling makecat to use mysql when you
> >create
> > > the catalog, I've always installed it using mysql.
> > >
> > > --
> > > Red Hat E-Business Solutions                    Jason Kohles
> > > 11480 Sunset Hills Road                         Senior System Architect
> > > Reston, VA 20190                                jkohles@redhat.com
> > >
> > > _______________________________________________
> > > Interchange-users mailing list
> > > Interchange-users@lists.akopia.com
> > > http://lists.akopia.com/mailman/listinfo/interchange-users
> > >
> >
> >
> >_______________________________________________
> >Interchange-users mailing list
> >Interchange-users@lists.akopia.com
> >http://lists.akopia.com/mailman/listinfo/interchange-users
>
> ===============================================================
> **** Virtual Hosting w/private IC Installation, $65/month! ****
> ---------------------------------------------------------------
> 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
> ===============================================================
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users


_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users