Hi Joe,
James 3.0 doesn't use the sqlResources.xml to access database mailboxes.
You need to checkout svn code from
http://svn.apache.org/repos/asf/james/imap/trunk/,
and look at under
https://svn.apache.org/repos/asf/james/imap/trunk/jpa/src/main/java/org/apache/james/mailbox/jpa/
It uses plain (Open)JPA.
It's true that we still have to move all the mailbox code from 'imap'
and document the use of sqlResources.xml, JPA,...
(We are working on it)
From http://old.nabble.com/file/p29763618/stacktrace, I don't
understand where the "mailman" comes from (error message: "Table
'mailman.JamesUser' doesn't exist".
You can ajust the database properties in persistence.xml (in
conf/META-INF/persistence.xml).
Tks,
Eric
On 26/09/2010 14:27, jbijoe wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
