Simple newbie question

[jamarkha]

Downloaded JBMS from HEAD (JBossMail 1.0M4-preX) yesterday and built it OK. Edited org.jboss.mail.store.postgresql.PostgreSQLStore to work with the latest 8.x PostgreSQL JDBC driver and put in a few methods in org.jboss.mail.util.Base64 to keep the build from complaining (public static String md5AsHexString(String text), public static String toHexString(byte[] bytes), public static byte[] md5(String text)).

Edited the jboss-service.xml to use the PostgreSQLStore and to use a JaasUserRepository of type DatabaseServerLoginModule. Added a user/pwd record to the table defined in the DatabaseServerLoginModule.

Deployed the mail.ear to a JBoss 4.0.3RC1 server (-c all) and sent and received seemingly well. By 'well', I mean I sent email under the user I set up and, from another email account, sent to the user I set up. The logs show no errors. I see the inserts into STORE_ITEM_METADATA but that's where all the activity stops.

I can't pick up any email although I see I'm authenticated and there doesn't seem to be anything in BLOB_MAIL_STORE.

Can anybody tell from this explanation if I'm doing something obviously wrong or is a massive config file/log post necessary?

Thanks in advance.

Jeff Markham

[mikezzz]

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.

Mike.

[acoliver]

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)

[acoliver]

yes, I moved base64 but forgot to make CVS realize it...it should work now.