Grouper Users - Open Discussion List

[Tom Barton <>]

I think Michael Gettes' email to the list on Sep 16 2007 addresses this. 
<https://mail.internet2.edu/wws/arc/grouper-users/2007-09/msg00040.html>.

Martti Jokipii wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello,
>
> I encountered the following problem when installing grouper-1.2.0 API on MySQL
> database:
>
> 'ant schemaexport' fails with the following messages in API error
> (grouper_error) logfile:
>
> 2007-11-01 19:55:43,531 [GROUPER-API] ERROR: Unsuccessful: create table
> grouper_attributes (id varchar(128) not null, group_id varchar(128), 
> field_name
> varchar(32) not null, value text not null, primary key (id), unique (group_id,
> field_name, value))
> 2007-11-01 19:55:43,532 [GROUPER-API] ERROR: BLOB/TEXT column 'value' used in
> key specification without a key length
> 2007-11-01 19:55:44,486 [GROUPER-API] ERROR: Unsuccessful: create index
> attribute_value_idx on grouper_attributes (value)
> 2007-11-01 19:55:44,486 [GROUPER-API] ERROR: Table
> 'GROUPER_DB.grouper_attributes' doesn't exist
> 2007-11-01 19:55:44,487 [GROUPER-API] ERROR: Unsuccessful: create index
> attribute_group_idx on grouper_attributes (group_id)
> 2007-11-01 19:55:44,487 [GROUPER-API] ERROR: Table
> 'GROUPER_DB.grouper_attributes' doesn't exist
> 2007-11-01 19:55:44,487 [GROUPER-API] ERROR: Unsuccessful: create index
> attribute_field_idx on grouper_attributes (field_name)
> 2007-11-01 19:55:44,487 [GROUPER-API] ERROR: Table
> 'GROUPER_DB.grouper_attributes' doesn't exist
>
>
> The software components involved are:
>
> OS:     Red Hat Enterprise Linux AS release 4 (kernel 2.6.9-55)
> Java:   1.5.0_13-b05
> MySQL:  Ver 14.7 Distrib 4.1.20 (RedHat)
> JDBC:   mysql-connector-java-5.0.7 (net.sf.hibernate.dialect.MySQLDialect)
> Tomcat: 6.0.14
>
>
> Any ideas, what causes this?
>
> - - Martti
>
> - --
> Martti Jokipii                         #  E-mail:   
>
> Tampere University of Technology       #  Phone:    +358  3 3115 2425
> Network Administration                 #  GSM:      +358 40 849 0804
> P.O. Box 692, 33101 Tampere, FINLAND   #  FAX:      +358  3 3115 2172
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iQCVAwUBRyoUoJiG4xCv5ApJAQLROAQAyZac2Kc9cgKmT1lFoogAJ0iHW6u4+w7f
> oayykxIYyxQq9Q5I6TF49R8tpnjZx64zBSGs0w28BmLTU9i0lNjkBG7YoORh3KDZ
> sUOQk+xq0mosih3/FlgK2uml3NAgKahjFeeomR0oKMKWvmptV193Kxx8+SvhXDBa
> wF6vEWeSGOY=
> =a3GG
> -----END PGP SIGNATURE-----