Grouper Users - Open Discussion List

["Tom Zeller" <>]

When using Grouper 1.4.0 RC1 and mysql 5.0 and attempting to
initialize via gsh -registry -check I receive "Specified key was too
long; max key length is 1000 bytes".

Help ? (I'm not using the utf8 charset.)

Hopefully it's operator error. I don't have much experience with mysql.

Thanks,
TomZ


mysql> CREATE INDEX attribute_field_value_idx ON grouper_attributes
(field_id, value);
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

mysql> describe grouper_attributes;
+--------------------------+---------------+------+-----+---------+-------+
| Field                    | Type          | Null | Key | Default | Extra |
+--------------------------+---------------+------+-----+---------+-------+
| id                       | varchar(128)  | NO   | PRI | NULL    |       |
| group_id                 | varchar(128)  | NO   | MUL | NULL    |       |
| field_id                 | varchar(128)  | NO   |     | NULL    |       |
| value                    | varchar(1024) | NO   |     | NULL    |       |
| hibernate_version_number | bigint(20)    | YES  |     | NULL    |       |
+--------------------------+---------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> status;
--------------
./mysql5  Ver 14.12 Distrib 5.0.67, for apple-darwin9.5.0 (i686) using
 EditLine wrapper

Connection id:          23
Current database:       grouper
Current user:           
root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.67 Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1

grouper.hibernate.properties :

hibernate.dialect               = org.hibernate.dialect.MySQL5Dialect
hibernate.connection.driver_class = com.mysql.jdbc.Driver
hibernate.connection.url = jdbc:mysql://127.0.0.1:3306/grouper