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

Hi Matt,

No problem actually I think. Looking at the code: 
https://github.com/apache/james-project/blob/master/server/data/data-jpa/src/main/java/org/apache/james/domainlist/jpa/JPADomainList.java#L164

We can see that it's just a debug log saying it tried to look if the 
domain existed internally or not, it didn't find it. James logged it 
then as a debug log and then returns false (so no error).

A bit verbose but my guess is also you are probably in a testing phase 
with debug logs enabled? If you turn off the debug logs in logback 
configuration file, you should not see them anymore I believe. But 
nothing to be alarmed of I think :)

Best regards,

Rene.


On 12/13/23 10:34, Tung Tran wrote:
> 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
>>>
>>>
>>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>