FUDforum: FUDforum Suggestions » Synchronising Forum posts to NNTP

Home » FUDforum » FUDforum Suggestions » Synchronising Forum posts to NNTP - Retry after failure

Show: Today's Messages :: Polls :: Message Navigator

Synchronising Forum posts to NNTP - Retry after failure [message #166985]

Fri, 13 April 2012 12:18

Multitool

Messages: 47
Registered: February 2012

Karma: 1

Member

I've noticed that, when syncing Forum posts back to an NNTP newsgroup, if the newsgroup posting fails for *any* reason (even if that reason is transient) the posting is never re-tried and the post will never appear on the newsgroup.

For transient errors, e.g. if the NNTP server is unreachable, it would make more sense to re-try the posting on the next run, at least a limited number of times, or until successful.

Obviously if the NNTP server explicitly rejects the message due to violation of one of its policies, then we wouldn't want to re-try it Smile

Report message to a moderator

Re: Synchronising Forum posts to NNTP - Retry after failure [message #166987 is a reply to message #166985]

Fri, 13 April 2012 12:23

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Sounds like a good idea! Can you prepare a fix for us?

Report message to a moderator

Re: Synchronising Forum posts to NNTP - Retry after failure [message #166988 is a reply to message #166987]

Fri, 13 April 2012 13:19

Multitool

Messages: 47
Registered: February 2012

Karma: 1

Member

naudefj wrote on Fri, 13 April 2012 13:23

Sounds like a good idea! Can you prepare a fix for us?

Too difficult for me I'm afraid. I can't even work out how it determines which Forum posts have yet to be posted to the newsgroup.

Report message to a moderator

Re: Synchronising Forum posts to NNTP - Retry after failure [message #166995 is a reply to message #166988]

Sat, 14 April 2012 17:43

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

I don't use it, and are unlikely to code it myself. However, to get a list of messages not posted:

SELECT * 
FROM fud_msg m 
INNER JOIN fud_thread t ON m.thread_id=t.id
INNER JOIN fud_forum f ON t.forum_id=f.id
WHERE mlist_msg_id IS NOT NULL AND mlist_msg_id != ''
AND f.name = 'Your forum Name';

Report message to a moderator

Re: Synchronising Forum posts to NNTP - Retry after failure [message #166996 is a reply to message #166995]

Sat, 14 April 2012 20:05

Multitool

Messages: 47
Registered: February 2012

Karma: 1

Member

OK, so it sounds like we just need to ensure that "mlist_msg_id" is not assigned until the message has been successfully posted?

So we need to connect to the NNTP server first, and only after successfully connecting assign "mlist_msg_id" - if the connection is unsuccessful, do nothing, then it will just re-try next time around as "mlist_msg_id" has not been assigned. That would cover the case where the NNTP server is temporarily unreachable, which is the most likely reason for the post to fail.

Report message to a moderator

Re: Synchronising Forum posts to NNTP - Retry after failure [message #166997 is a reply to message #166996]

Sat, 14 April 2012 20:58

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Yes, mlist_msg_id is the USENET Message-ID. This column should actually be renamed to 'external_msg_id' in a future release.

When FUDforum imports messages, and encounters a message that it posted, it will extract the message id and put it into mlist_msg_id.

Report message to a moderator

Previous Topic:	Suggestion: Update all Newsgroups on every run
Next Topic:	gmane

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 27 15:57:29 GMT 2024

Total time taken to generate the page: 0.02544 seconds