You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by "Masashi Nakane@EBPass" <na...@ebpass.com> on 2005/12/13 14:53:26 UTC

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

I found that  there is defference between  Installer and source build like
below.

                      Mysql 4.0    Mysql 4.1     Mysql 5.0
Source build      NG           No Problem   No Problem
Installer build     NG              NG             No Problem
Binary build       not yet        not yet         not yet

NG means it shows  the error about varchar size of COOKIE column.

About mysql 4.1 , js2 FINAL installer  failes
but source install( maven allClean allBuild j2:quickStart) successes.

Thanks,

Masa

-----Original Message-----
From: Randy Watler [mailto:watler@wispertel.net]
Sent: Monday, December 12, 2005 6:08 PM
To: Jetspeed Users List
Subject: Re: SSO_COOKIE varchar > 255, was: Maven Build Error with
mysqlToo big column length for column 'COOKIE'


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
> > >
> > >
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> > For additional commands, e-mail: jetspeed-user-help@portals.apache.org
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> > For additional commands, e-mail: jetspeed-user-help@portals.apache.org
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> > For additional commands, e-mail: jetspeed-user-help@portals.apache.org
> >
> >


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



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


Re: SSO_COOKIE varchar > 255, was: Maven Build Error with mysqlToo big column length for column 'COOKIE'

Posted by Roger Ruttimann <ro...@earthlink.net>.
Masashi,

thanks for tracking it down. I'll have to check why the installer fails
on the 4.1.

Roger


Masashi Nakane@EBPass wrote:

>I found that  there is defference between  Installer and source build like
>below.
>
>                      Mysql 4.0    Mysql 4.1     Mysql 5.0
>Source build      NG           No Problem   No Problem
>Installer build     NG              NG             No Problem
>Binary build       not yet        not yet         not yet
>
>NG means it shows  the error about varchar size of COOKIE column.
>
>About mysql 4.1 , js2 FINAL installer  failes
>but source install( maven allClean allBuild j2:quickStart) successes.
>
>Thanks,
>
>Masa
>
>-----Original Message-----
>From: Randy Watler [mailto:watler@wispertel.net]
>Sent: Monday, December 12, 2005 6:08 PM
>To: Jetspeed Users List
>Subject: Re: SSO_COOKIE varchar > 255, was: Maven Build Error with
>mysqlToo big column length for column 'COOKIE'
>
>
>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
>>>>
>>>>
>>>>
>>>>
>>>>        
>>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>>>For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>>
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>>>For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>>
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>>>For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>>>
>>>
>>>      
>>>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
>For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
>  
>


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