This content has been marked as final. Show 3 replies
Edited org.jboss.mail.store.postgresql.PostgreSQLStore to work with the latest 8.x PostgreSQL JDBC
Not sure why you need to do this. It works fine with the supplied JDBC driver and PostgreSQL 8.0 (PostgreSQL 8.1 is still in beta, therefore we havn't tested against it).
It's difficult to know if your changes have broken something or not.
Edited the jboss-service.xml to use the PostgreSQLStore
You shouldn't need to do this either. We use a Velocity template that generates the jboss-service.xml file. Try doing a ./build.sh dist and then java -jar build/dist/install.jar and install JBMail using the installer. This is more likely to give you a consistant configuration. Use the M3 instructions for installation. http://wiki.jboss.org/wiki/Wiki.jsp?page=JBMSInstallingM3
there doesn't seem to be anything in BLOB_MAIL_STORE.
There won't be. The PostgreSQLStore doesn't use this table. It uses a the Large Object API which stores the data in a table internal to PostgreSQL (pg_largeobject I think).
My recommendation would be to start off by installing a vanilla version of the Mail Server from CVS to make sure your configuration is correct. Then start with any code modifications, then you will know whether it is the configuration or the code changes that have preventing the server from working.
doh I may have goofed up when I checked stuff in the other day....I'll check (I think I failed to remove the old BASE64 when I moved it to a new dir)
yes, I moved base64 but forgot to make CVS realize it...it should work now.