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

Hi,

You can use `SizeAndTimeBasedRollingPolicy` in logback file for rotate 
the file log
https://logback.qos.ch/manual/appenders.html#SizeAndTimeBasedRollingPolicy


On 08/01/2024 18:57, Matt Pryor wrote:
> OK thanks Rene.
>
> I'm finding the logs a bit challenging, the main use for logs for our use
> is to track down deliverability issues, but in order to do this we need to
> turn on debug logging, for example:
>
> 16:36:59.492 [DEBUG] o.a.j.t.m.r.d.MailDelivrer - Temporary exception
> delivering mail
> (Mail1704386217842-49641a56-f7cf-43c3-911f-bf83b88a4fd4-to-aol.com).
> RemoteHost said: 421 4.7.0 [TSS04] Messages from 13.82.57.241 temporarily
> deferred due to unexpected volume or user complaints - 4.16.55.1; see
> https://postmaster.yahooinc.com/error-codes
>
> But this then generates 500+ Mb per day which is a lot to look through. Any
> tips on how to better manage this would be great.
>
> Thanks
> Matt
>
>
>
>
>
>
> On Wed, 13 Dec 2023 at 04:14, Rene Cordier <[email protected]> wrote:
>
>> 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]
>>>
>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>