3 Replies Latest reply on Sep 25, 2005 3:56 PM by Andrew Oliver

    Simple newbie question

    Jeff Markham Newbie

      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

        • 1. Re: Simple newbie question
          Michael Barker Apprentice

           

          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.

          • 2. Re: Simple newbie question
            Andrew Oliver Master

            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)

            • 3. Re: Simple newbie question
              Andrew Oliver Master

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