[ic] Can't Get MySQL running with IC

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


> is the interchange database user configured w/ INDEX capabilities, too?
> sounds to me like a database permissions problem.  both the
> interchange user needs to be set up for that database, and given
> privleges on that MySQL server.  what do your mysql.db and mysql.user
> tables look like?

I hope you can view these tables alright. I can at 1600 x 1200.

mysql.db
+-----------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host      | Db      | User | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
Index_priv | Alter_priv |
+-----------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| %         | test    |      | Y           | Y           | Y           |
Y           | Y           | Y         | N          | Y               |
Y          | Y          |
| %         | test\_% |      | Y           | Y           | Y           |
Y           | Y           | Y         | N          | Y               |
Y          | Y          |
| localhost | cigar   | bob  | Y           | Y           | Y           |
Y           | Y           | Y         | Y          | Y               |
Y          | Y          |
| localhost | cigars  | bob  | Y           | Y           | Y           |
Y           | Y           | Y         | N          | Y               |
Y          | Y          |
+-----------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
4 rows in set (0.00 sec)

mysql.user
+-----------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host      | User    | Password         | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv
| Index_priv | Alter_priv |
+-----------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root    |                  | Y           | Y           |
Y           | Y           | Y           | Y         | Y           |
Y             | Y            | Y         | Y          | Y              
| Y          | Y          |
| elide     | root    |                  | Y           | Y           |
Y           | Y           | Y           | Y         | Y           |
Y             | Y            | Y         | Y          | Y              
| Y          | Y          |
| localhost |         |                  | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          |
| elide     |         |                  | N           | N           |
N           | N           | N           | N         | N           |
N             | N            | N         | N          | N              
| N          | N          |
| elide     | zbert   | 71de86b43b49a854 | Y           | Y           |
Y           | Y           | Y           | Y         | N           |
N             | N            | N         | N          | N              
| N          | Y          |
| localhost | zbert   | 71de86b43b49a854 | Y           | Y           |
Y           | Y           | Y           | Y         | N           |
N             | N            | N         | N          | N              
| N          | Y          |
| localhost | bob     | 1608e1316eb485af | Y           | Y           |
Y           | Y           | Y           | Y         | Y           |
Y             | Y            | Y         | Y          | Y              
| Y          | Y          |
| localhost | interch | 29bad1457ee5e49e | Y           | Y           |
Y           | Y           | Y           | Y         | Y           |
Y             | Y            | Y         | Y          | Y              
| Y          | Y          |
| %         | interch | 29bad1457ee5e49e | Y           | Y           |
Y           | Y           | Y           | Y         | Y           |
Y             | Y            | Y         | Y          | Y              
| Y          | Y          |
| localhost | matthew | 33bbae35660053bb | Y           | Y           |
Y           | Y           | Y           | Y         | Y           |
Y             | Y            | Y         | Y          | Y              
| Y          | Y          |
| %         | matthew | 33bbae35660053bb | Y           | Y           |
Y           | Y           | Y           | Y         | Y           |
Y             | Y            | Y         | Y          | Y              
| Y          | Y          |
+-----------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
11 rows in set (0.00 sec)


 
> and does it work using the DBA (eg, root user) username / password?  no,
> this isn't an acceptable long-term solution, but might at least get you
> going.

I am able to perform just about anything I've thrown at MySQL while in
MySQL And when I run through makecat, the script appears to create the
db just fine. However, I end up with an empty database. No tables,
etc...

  --Ralph