I think there is more wrong here than just this problem. I have been trying to wade into the source code and manually create the required tables. However, Im finding that the code is bordering on un-readable.. Must be machine generated??? For example, looking at the sqlResources.xml "UBER" module, (something for everyone in there) I have no clue whats going on in there... I can see its a one stop shop for every ice cream flavor ( lots a db's) :) I get one table created manually then stack trace hollars about another. Currently its knocking the Membership table when a GOOD email is rec'vd.. Is there a database table map anywhere??? I dont mind lookin through the java code if you can point me to where these dynamic table allocations are being set??? Any help greatly appreciated, and if I hit on whatever is the issue I dont mind giving back... TIA
Norman Maurer-3 wrote: > > 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] > > > -- View this message in context: http://old.nabble.com/JamesV3-SpringDeployment-SNAPshot--MYSQLdb-errors-tp29762391p29811328.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]
