RE: SSO_COOKIE varchar > 255, was: Maven Build Error with mysql Too big column length for column 'COOKIE'DateMo

["Matola, Tod" <To...@stercomm.com>]

Hello,

 Was wondering if there was ever any progress on this issue:

[sql] SQL:   CREATE TABLE SSO_COOKIE ( COOKIE_ID MEDIUMINT NOT NULL,
COOKIE VARCHAR(1024) NOT NULL, CREATE_DATE    TIMESTAMP NOT NULL,
PRIMARY KEY(COOKIE_ID))
      [sql] Failed to execute:   CREATE TABLE SSO_COOKIE ( COOKIE_ID
MEDIUMINT NOT NULL, COOKIE VARCHAR(1024) NOT NULL, CREATE_DATE TIMESTAMP
NOT NULL, PRIMARY KEY(COOKIE_ID))

BUILD FAILED
/home/matola/tmp/jetspeed-installer/build.xml:93: java.sql.SQLException:
Too big column length for column 'COOKIE' (max = 255). Use BLOB instead

It seems to work in mysql 4.1.x and is an issue for 4.0.x I hunted threw
the bug db and didn't see anything either. 

I saw a cross thread where someone said that it work from source build
but not the multDb installer, but what I noticed from the tar file 
ftp://apache.cs.utah.edu/pub/apache.org/portals/jetspeed-2/sources/jetsp
eed-2.0-src.tar.gz

was sql scripts are different from the installer, in fact the file
(security-schema.sql) with the issue isn't included. There is a
jetspeed-2.0-src/etc/schema/security-schema.xml does the source bundle
use Torque or some thing?  

Cheers Tod Matola

Here's the original thread.

FromRandy Watler <wa...@wispertel.net>SubjectRe: SSO_COOKIE varchar >
255, was: Maven Build Error with mysql Too big column length for column
'COOKIE'DateMon, 12 Dec 2005 23:07:39 GMT
Right. This is a problem. I will speak to Roger here at ApacheCon.

Randy

On Mon, 2005-12-12 at 12:26 -0500, Aaron Evans wrote:
> Doh! This was working before with MySQL 4.1.  I have an approximately
M4
> build that is using MySQL 4.1 just fine.
> 
> Someone must have changed the length for that column. I hope this gets
fixed
> soon, otherwise I won't be able to install 2.0 final...
> 
> On 12/12/05, Masashi Nakane@EBPass <na...@ebpass.com> wrote:
> >
> >
> > I had  Jetspeed 2.0 finals create tables on  Mysql 4.1.15
> >   and again  Too big column length for column 'COOKIE' .
> >
> >   With mysql 5.0  , No problems.
> >
> >   Masa
> >
> >
> > -----Original Message-----
> > From: Masashi Nakane@EBPass [mailto:nakane@ebpass.com]
> > Sent: Friday, December 09, 2005 2:44 PM
> > To: Jetspeed Users List
> > Subject: RE: Maven Build Error with mysql Too big column length for
> > column 'COOKIE'
> >
> >
> >
> > Mysql official reference says mysql 4.0 's varchar size is from 0 to
255.
> > http://dev.mysql.com/doc/refman/4.1/en/char.html
> > But it is not written explicitly about mysql 4.1.
> > Maybe 4.1 has more.
> >
> > -----Original Message-----
> > From: Roger Ruttimann [mailto:roger.ruttimann@earthlink.net]
> > Sent: Friday, December 09, 2005 2:18 PM
> > To: Jetspeed Users List
> > Subject: Re: Maven Build Error with mysql Too big column length for
> > column 'COOKIE'
> >
> >
> > I tested it with MySQL 4.1. Is it an issue with 4.0?
> >
> > Roger
> >
> > Masashi Nakane@EBPass wrote:
> >
> > >  Hi,  this is my first time posting to this ml
> > >
> > >  I have tried to  build jetspeed2 on
> > >
> > >  tomcat 5.5.12
> > >  mysql 4.0.28
> > >
> > >  by the commands on page
> > >http://portals.apache.org/jetspeed-2/getting-started-source.html
> > >
> > >  maven allClean allBuild
> > >  maven j2:quickStart
> > >
> > >  Then I got the error
> > >
> > >BUILD FAILED
> > >File...... C:\Documents and
> > >Settings\Administrator\.maven\cache\maven-jetspeed2-
> > >plugin-2.0-dev\plugin.jelly
> > >Element... sql
> > >Line...... 840
> > >Column.... -1
> > >java.sql.SQLException: Too big column length for column 'COOKIE'
(max =
> > >255). Us
> > >e BLOB instead
> > >Total time   : 8 minutes 16 seconds
> > >
> > >  Do i miss something ?
> > >
> > >Masa


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org