Re: Help with "no domain found" error James 3.8.0

It just a JPAQuery, the JamesDomain is an entity of table JAMES_DOMAIN.
:name is a "dynamic marker" as you wrote.

https://github.com/apache/james-project/blob/d7a4f45fa4d248a4911612eb367cef72e56c5f8c/server/data/data-jpa/src/main/java/org/apache/james/domainlist/jpa/model/JPADomain.java#L33


On 12/12/2023 18:42, Matt Pryor wrote:
> 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 <[email protected]>
> wrote:
>
>> Many thanks René!
>>
>> On Thu, 26 Oct 2023 at 03:32, René CORDIER <[email protected]> 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 <[email protected]> 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: [email protected]
>>>> For additional commands, e-mail: [email protected]
>>>>
>>>>
>>>
>>>
>> --
>> Kind regards
>> Matt Pryor
>> Software Developer
>>
>> The International Presence Group of Companies
>> EMAIL: [email protected]
>> URL: www.International-presence.com
>>
>>
>>