[ic] Can't Get MySQL running with IC

[Guy Soudant]

See my comments below.

-----Original Message-----
From: interchange-users-admin@developer.akopia.com
[mailto:interchange-users-admin@developer.akopia.com]On Behalf Of Ralph
Alberti
Sent: zondag 10 juni 2001 17:20
To: interchange-users@developer.akopia.com
Subject: Re: [ic] Can't Get MySQL running with IC


Thanks. Sounds familair except that I never end up with any tables in
the DB.
When you manually created the DB, did you create tables as well?

My Comment: No. I made some test tables to test whether I could properly
connect to the SQL server and edit the Database. That worked fine.

Did you have to edit catalog.cfg to enable the catalog to use the DB?

My Comment: No. I did not have to edit the catalog.cfg I did check
everything in this file, and everything looked OK.

Also, after you created the DB manually and ran the makecat script, did you
bypass
the part of the script that prompts you to have mysqladmin create the DB?

My Comment: Once I created the Database and tested it, I ran "bin/makecat"
from the interchange (default install) folder. When it came to the questions
about the SQL Database I indicated that I wanted to have a SQL Db (twice
pressing 1, I thought). After that you get some questions regarding the
user. I entered the user account under which the IC runs (in my case
formula). I think this is necessary to do, but I'm not completely sure (I
tried other users as well, but they failed, even though they had the proper
access rights). Entering login name and password was done as well, and when
I came to the question if makecat should create the Database, I entered yes.
This fails! But I guess that because the Db already exists, makecat created
the tables. So yes, I told makecat to create the Db, and I did not bypass
that part of the script. But once again, the creation of the Database
failed, but the tables are added (logical since it finds a database with
this name, and mysql can access the Db and create tables in the Db)

  --Ralph

If you need any information about my install, then please feel free to
contact me through e-mail (of list (private e-mail address is
soudant@home.nl) is fine, as long as the solution is posted together with
the initail question).

Regards

Guy Soudant