Grouper Users - Open Discussion List

[Chris Hyzer <>]

That's not good.  My mysql works fine, but I think it automatically tells the 
index to only use the first part of the col.  i.e. try this and see if it 
works:

CREATE INDEX attribute_field_value_idx ON grouper_attributes (field_id, 
value(767));

http://dev.mysql.com/doc/refman/5.0/en/create-index.html

I only have 5.0.45, but it is windows...

I wonder if we should change ddlutils to account for this...

Regards,
Chris


> -----Original Message-----
> From: 
> 
>  
> [mailto:]
>  On Behalf Of Tom
> Zeller
> Sent: Tuesday, December 09, 2008 2:39 PM
> To: Grouper Users Mailing List
> Subject: [grouper-users] newbie help with mysql, please
>
> 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