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 <[email protected]> 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 <[email protected]>:
>> >
>> > attached
>> >
>> > Norman Maurer-3 wrote:
>> >>
>> >> Could you please paste the stacktrace ?
>> >>
>> >> Thx,
>> >> Norman
>> >>
>> >> 2010/9/20 jbijoe <[email protected]>:
>> >>>
>> >>>
>> >>>
>> >>> 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: [email protected]
>> >>> For additional commands, e-mail: [email protected]
>> >>>
>> >>>
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: [email protected]
>> >> For additional commands, e-mail: [email protected]
>> >>
>> >>
>> >>
>> > 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: [email protected]
>> > For additional commands, e-mail: [email protected]
>> >
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
>
--
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: [email protected]
For additional commands, e-mail: [email protected]
