james-server-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jbijoe <...@Daggerpoint.com>
Subject Re: JamesV3 SpringDeployment SNAPshot MYSQLdb errors
Date Tue, 21 Sep 2010 19:26:16 GMT

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


Mime
View raw message