[ic] Setting up SQL

[Farhan Mashraqi]

I have tested this Interchange 4.8.6 that comes installed with Cpanel5.

Before continuing make sure you have created a mysql database properly
alongwith the necessary permissions for the database user.

1. If not already installed, Install the Perl Module DBD::mysql . This can
be installed using WHM
2: Go to Interchange foundation store admin area
3. Click on "Administration" button
4. Click on "Preferences"
5. Select the check boxes next to "MV_DEFAULT_SEARCH_DB", "MYSQL", "SQLDSN",
"SQLPASS", "SQLUSER"
6. Click on "Edit checked records in sequence".
   a) Change the "Variable" value for MV_DEFAULT_SEARCH_DB field from 1 to 0
and click on "OK"
   b) Set the "Variable" value for MYSQL to "Yes"
   c) For SQLDSN set the value of "Variable" to a format like this
      "dbi:mysql:database=database_name:host=localhost"
      (without the quotation marks)
   d) For SQLPASS set the value of "Variable" to your password
   e) For SQLUSER set the value of "Variable" to your mysql username
7. Now click on "Apply Changes" and you are done.
Farhan Mashraqi
Creative and Development Manager
Designerz L.L.C
www.Designerz.com
www.HostingAndBeyond.com
----- Original Message -----
From: "Webmaster" <webmaster@lynlinks.com>
To: "Interchange Listserver" <interchange-users@icdevgroup.org>
Sent: Friday, November 15, 2002 2:45 PM
Subject: [ic] Setting up SQL


> What's the quick & dirty configuration settings on running ic with mysql
as
> opposed to the default text database?  I had my sys admin create a
database
> named "store" and now I'm trying to get sql configured.  I have the
server,
> user & password variables and I have the path command
(/opt/mysql/bin/mysql
> store)  supposedly to access my database but can't make it work.
Something
> is not clicking here.  Any asssistance would be great!
>
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>
>