Ok, sounds like a bug. Can you please open a jira issue for it?
Thx, Norman 2010/9/21, jbijoe <[email protected]>: > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
