[ic] Can't Get MySQL running with IC

Ralph Alberti interchange-users@lists.akopia.com
Sun Jun 10 13:04:01 2001


> firstly, i didn't want the makecat script to create the DB for me.  if
> you create it yourself, you can make sure the interch user can access it
> before you go about actually creating your new catalog.

I created the db manually and answered no to letting mysqladmin create
the db for me when running the script.


 
> you can read through a MySQL book or tutorial (there's a pretty good one
> on the MySQL website) to tell you how to do these things manually.  me,
> i'm a wimp, and prefer to let the scripts that come w/ MySQL do it for
> me.  so, log in as root.  run mysql_setpermission, and give it your DBA
> password (assuming you set one!!)  select #2, give it a database name, a
> username (interch) and a password (whatever you want.)  when it asks
> from what host you wish to connect, you should probably say 'localhost',
> though a '%' for any host would be safe.  tell it "y", you want to
> implement this, then exit the program.

I didn't try this yet. Because I did it manually.

 
> now.  before you run 'makecat', make *sure* you can access that database
> as that user.  run 'mysql -u USERNAME -p'  (replacing USERNAME with
> whatever user you selected), and give it the password when it asks.  if
> you *can* connect to the database server, try 'use DBNAME;', where
> DBNAME is the name of the database you created.  try creating a
> temporary table, then dropping it.
> 
> if that works, you're good to go.  one final thing:  in the mysql
> client, 'use mysql;' then 'select * from db;'  check that, for the user
> / db you just created (probably on the last line) you have 'Y' set for
> all the privleges but 'Grant_priv.'

I did all of this.

 
> try makecat (make SURE to give it the right user, db, password!) then
> restart your interchanger server.  you should get a bunch of stuff
> scrolling by as it creates the default databases.

I think this is where I am having major problems. I am not sure what the
correct answers to the makecat script should be. I've tried all
different variations. I've created an interch user in MySQL. I've
created other users in MySQL. And I've tried creating the DB in
MySQL manually.

I've followed the tutorials except that they don't get into using
MySQL. And I've created catalogs using the default database for IC.
I wish there was a step by step tutorial for creating catalogs
using MySQL. If I ever get this down, I will create one and post
it on a web site.

 
> one more thing.  are you using Linux?  i coulnd't get 'sockets' to work
> for me, i had to use the INET setting.  that tricked me up for, oh, 8
> hours worth of work.  (-;
 
Yes. I am using RedHat 7.0 and MySQL 3.23.22

  --Ralph