james-server-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Norman Maurer <nor...@apache.org>
Subject Re: JamesV3 SpringDeployment SNAPshot MYSQLdb errors
Date Wed, 22 Sep 2010 05:01:41 GMT
Ok, sounds like a bug. Can you please open a jira issue for it?


Thx,
Norman

2010/9/21, jbijoe <Joe@daggerpoint.com>:
>
> After more checking it looks like some tables get created, but others dont.
> So, I started trying to narrow it down...  I pulled out the sql statements
> that
> create the tables and tried to do a source file.sql and got errors.
> Looks like mysql doesnt like the field named "field"  it errors out with the
> following;
>
> ERROR 1074: Too big column length for column 'field' (max = 255). Use BLOB
> instead
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> show tables
>     -> ;
>     +--------------------------------+
>     | Tables_in_mailman              |
>     +--------------------------------+
>     | VirtualUserTable               |
>     | bayesiananalysis_ham           |
>     | bayesiananalysis_messagecounts |
>     | bayesiananalysis_spam          |
>     | mailbox                        |
>     | message                        |
>     | message_body                   |
>     | message_flags                  |
>     +--------------------------------+
>     8 rows in set (0.01 sec)
>
>     mysql> exit
>
>
>
> Ranjib Dey wrote:
>>
>> also, can you check the permissions for the user using which you  are
>> connecting to mysql?
>>
>> On Tue, Sep 21, 2010 at 5:17 PM, Norman Maurer <norman@apache.org> wrote:
>>
>>> Hi,
>>>
>>> from the exception it looks like the table does not exist, which is
>>> strange because it should get created on startup. Could you tell me if
>>> you only see the problem when using mysql ? In other word does it work
>>> with the default db (derby) ?
>>>
>>> Did you see any other errors before (while starting up james) ?
>>>
>>> I think this is the relevant part of the exception:
>>>
>>> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table
>>> 'mailman.JamesUser' doesn't exist {prepstmnt 7757452 SELECT
>>> COUNT(t0.name) FROM JamesUser t0 WHERE (t0.name = ?) [params=(String)
>>> joe]} [code=1146, state=42S02]
>>>
>>> Bye,
>>> Norman
>>>
>>> 2010/9/20 jbijoe <Joe@daggerpoint.com>:
>>> >
>>> > attached
>>> >
>>> > Norman Maurer-3 wrote:
>>> >>
>>> >> Could you please paste the stacktrace ?
>>> >>
>>> >> Thx,
>>> >> Norman
>>> >>
>>> >> 2010/9/20 jbijoe <Joe@daggerpoint.com>:
>>> >>>
>>> >>>
>>> >>>
>>> >>> Greetings list,
>>> >>> IM trying to enable mysql for the latest and greatest
>>> SpringDeployment.
>>> >>> I can start up OK after editing the config xml files..  THEN,
>>> >>> I telnet localhost 4555 and attempt to add a user.  IT HANGS,
>>> >>> In my debug window it looks like some mysql errors poppin out
>>> >>> that the Header field BIGINT is not suppoerted and to use BLOB.
>>> >>> Any Ideas on what could be wrong??
>>> >>> TIA
>>> >>> --
>>> >>> View this message in context:
>>> >>>
>>> http://old.nabble.com/JamesV3-SpringDeployment-SNAPshot--MYSQLdb-errors-tp29762391p29762391.html
>>> >>> Sent from the James - Users mailing list archive at Nabble.com.
>>> >>>
>>> >>>
>>> >>> ---------------------------------------------------------------------
>>> >>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>>> >>> For additional commands, e-mail: server-user-help@james.apache.org
>>> >>>
>>> >>>
>>> >>
>>> >> ---------------------------------------------------------------------
>>> >> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>>> >> For additional commands, e-mail: server-user-help@james.apache.org
>>> >>
>>> >>
>>> >>
>>> > http://old.nabble.com/file/p29763618/stacktrace stacktrace
>>> > --
>>> > View this message in context:
>>> http://old.nabble.com/JamesV3-SpringDeployment-SNAPshot--MYSQLdb-errors-tp29762391p29763618.html
>>> > Sent from the James - Users mailing list archive at Nabble.com.
>>> >
>>> >
>>> > ---------------------------------------------------------------------
>>> > To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>>> > For additional commands, e-mail: server-user-help@james.apache.org
>>> >
>>> >
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>>> For additional commands, e-mail: server-user-help@james.apache.org
>>>
>>>
>>
>>
>
> --
> View this message in context:
> http://old.nabble.com/JamesV3-SpringDeployment-SNAPshot--MYSQLdb-errors-tp29762391p29772908.html
> Sent from the James - Users mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>

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


Mime
View raw message