[ic] Interchange using MySQL on a different machine
Caleb Phillips
interchange-users@icdevgroup.org
Thu Oct 17 14:04:01 2002
On Tue, 2002-10-15 at 09:50, Schuyler Langdon wrote:
> Tommy Pruitt wrote
> > Where do I modify the database to be used? I have looked at
> > /var/lib/interchange/pci/catalog.cfg and modified it to have
> > dbi:mysql:pci_2002:sql.pruittcom.com:3306 where pci_2002 is the database
> > on another machine. It makes no difference. When I restart interchange
> > it still uses dbi:mysql:test_pci
>
> It's in the variable table, SQLDSN column
It should look like:
ifdef SQLDSN
Variable SQLDSN dbi:mysql:<db>:<server>
endif
and in products/variable.txt
you should have:
MYSQL 1 Database
SQLDSN dbi:mysql:<db>:<server> Database
This is all I did (on a similar setup), and it works fine for me.
Good luck.
>
> -
> Schuyler Langdon
> GatorDev
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
--
-------------------------------------------
| Caleb Phillips |
| The Studio Resource |
| IT Specialist |
| |
| Handcrafted for you in Ximian Evolution |
-------------------------------------------