Hi all, I'm still seeing this error in the logs after setting the domain using the webadmin:
javax.persistence.NoResultException: Query "SELECT domain FROM JamesDomain domain WHERE domain.name=:name" selected no result, but expected unique result. at org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:346) at org.apache.james.domainlist.jpa.JPADomainList.containsDomainInternal(JPADomainList.java:162) at org.apache.james.domainlist.jpa.JPADomainList.containsDomainInternal(JPADomainList.java:100) at org.apache.james.domainlist.lib.AbstractDomainList.containsDomain(AbstractDomainList.java:179) at org.apache.james.mailetcontainer.impl.LocalResourcesImpl.isLocalServer(LocalResourcesImpl.java:67) Please can you help me understand what this query is doing and what is it querying? There is no "JamesDomain" table in the tables generated in our SQL Server database (there is a James_Domain). I presume :name is a dynamic marker, in which case what will it be setting the value to? Below is a list of tables generated by James in SQL Server: JAMES_DOMAIN JAMES_MAIL JAMES_MAILBOX JAMES_MAILBOX_ANNOTATION JAMES_MAIL_PROPERTY JAMES_MAIL_REPOS JAMES_MAIL_STORE JAMES_MAIL_USERFLAG JAMES_MAX_DOMAIN_MESSAGE_COUNT JAMES_MAX_DOMAIN_STORAGE JAMES_MAX_GLOBAL_MESSAGE_COUNT JAMES_MAX_Global_STORAGE JAMES_MAX_USER_MESSAGE_COUNT JAMES_MAX_USER_STORAGE JAMES_QUOTA_CURRENTQUOTA JAMES_RECIPIENT_REWRITE JAMES_SIEVE_QUOTA JAMES_SIEVE_SCRIPT JAMES_SUBSCRIPTION JAMES_USER OPENJPA_SEQUENCE_TABLE Thanks and kind regards Matt On Thu, 26 Oct 2023 at 12:41, Matt Pryor <pr...@international-presence.com> wrote: > Many thanks René! > > On Thu, 26 Oct 2023 at 03:32, René CORDIER <rcord...@linagora.com> wrote: > >> Hi Matt, >> >> On addition to using the cli, you have also other ways: >> >> - using webadmin: >> https://james.apache.org/server/manage-webadmin.html#Administrating_domains >> >> - the domainlist.xml file. localhost is configured as defaultDomain, but >> you can add extra domains in `domainnames.domainname`, which is a list, >> spearated by "," I think... it's undocumented, looks rather obscur (as a >> name) and doesn't seem really tested in the code I realized though... Might >> need to add a little something there :) >> >> Best regards, >> >> Rene. >> >> >> On Oct 26, 2023 1:36 AM, from Matt Pryor Thanks a lot Tung will try that >> tomorrow. >> >> >> On Wed, 25 Oct 2023 at 16:33, Tung Tran <vtt...@linagora.com> wrote: >> >> > Hi >> > Have you created a domain name yet? >> > By admin api, James Command line... >> > Ex: james.apache.org/server/manage-cli.html#Manage_Domains >> > >> > Tung, >> > >> > On 25/10/2023 22:16, Matt Pryor wrote: >> > > Hi, I'm seeing the following error in the logs: >> > > >> > > 16:07:55.691 [DEBUG] o.a.j.d.j.JPADomainList - No domain found >> > > javax.persistence.NoResultException: Query "SELECT domain FROM >> > JamesDomain >> > > domain WHERE domain.name=:name" selected no result, but expected >> unique >> > > result. >> > > at >> > > >> > >> org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:346) >> > > >> > > Queried the jamesdomain table and there's one result containing >> > "localhost". >> > > >> > > What should be in there, do I set it manually in the database, or >> does it >> > > come from a config file? >> > > >> > > Thanks >> > > Matt >> > > >> > >> > --------------------------------------------------------------------- >> > To unsubscribe, e-mail: server-user-unsubscr...@james.apache.org >> > For additional commands, e-mail: server-user-h...@james.apache.org >> > >> > >> >> >> > > -- > Kind regards > Matt Pryor > Software Developer > > The International Presence Group of Companies > EMAIL: pr...@presencebpm.com > URL: www.International-presence.com > > > -- Kind regards Matt Pryor Software Developer The International Presence Group of Companies EMAIL: pr...@presencebpm.com URL: www.International-presence.com
