I am willing to pay for a NNTP news server. What news server can I use ? Anybody with Usenet.com or Newsfeeds.com ? Or it doesn't matter ? Here is their answer (usenet, newsfeeds):

"You can access the newsgroups through the web to news gateway, but I am not familiar with access through Vbulletin NNTP Gateway. You can give it a try, but as I said I am not familiar with it."

"Hello, You can gain access via web to news gateway. I do not know what vbulletin is. Thank you, Sales"

I use giganews.com Pretty good.

-Jason

Probem (1) Everytime I run the gateway it keeps reposting the same messages that already posted to usenet. They are below:

Gateway version 2.2.1 1 group(s) gatewayed.

Connecting to server, server says: 200 News.GigaNews.Com

Server responded after user name: 381 more authentication required

Server responded after password: 281 News.GigaNews.Com

Info for rec.gambling.poker at news.giganews.com:
211 379884 554640 934523 rec.gambling.poker

Posting Message 'Sorry about duplicate posts' from pokerpartys. Result: 340 send article240 post accepted.
Posting Message 'Re: PartyPoker: Play money tables are gone.' from Tommy21. Result: 340 send article240 post accepted.
Posting Message 'Re: Lost my whole buy in, need some analysis' from pokeranch.com. Result: 340 send article240 post accepted.
Posting Message 'Re: Sorry about duplicate posts' from pokerpartys. Result: 340 send article240 post accepted.
Getting message number 567500:
'Define "Tough"' from Linda K Sherman. New thread.
Getting message number 567501:
'Re: hold em: missed bets?' from Linda K Sherman. Thread found by References.
Getting message number 567503:

Problem (2) - I used the prune option several times for my forums but my sql database size stays the same - isnt that suppose to be pruned also?

According to this post:

http://groups.google.com.au/groups?h...okerpartys.com

You modified the script at some stage. You could have stuffed it up. I suggest you to put back the original script before too many abuse emails arrive.:)

The question need to be asked is: can the web server access the news server? It is perhaps easier to use the news server that your web hosting company might have. Failing that, you just need to make sure the web server can access the news server on port 119 using tcp protocol. In a nutshell, the web server which runs this script will act as a news reader, it must be able to read news via port 119 using tcp protocol. You might need to check this with your web host company in case they run outbound firewall on the web server. Some commercial news contents providers let you access news (nntp) through other common ports (eg. port 80) to get around.

Lierduh,

This has probably been asked but what is the Prefix field for in the newsgroup settings? Will this add text before the title when it is imported?

Thanks again for the great work,

-Jason

Prefix is now used for filtering mailing lists. With a single email account subscribed to multiple mailing lists, one group will only import those emails with defined "Prefix" in the subject. eg.

Set:
newbie

as prefix for forum 1.

Set:
develope

as prefix for forum 2.

forum 1 will only import the emails with [newbie] in the subject (newbie as well)

forum 2 will ignore those and only take care of emails with [develope]/develope in the subject.

Ok I deleted the 2 databases that get created and reinstalled the files again and you were right it now only posts one message. Everything seems to be working great except for my sql database. I pruned even deleted my entive newsgroup forum but the size of my sql database doesnt get smaller? Is this normal? If it is normal how can I safely prune the sql database to throw away all the old garbage?

I appreciate all your help and must applaud you on this great script! :squareeyed:

Ugg.

Ok, I got everything working.

It was all working fine...cron scheduled hourly and it would run great.

Then, all of a sudden, it just doesn't download (import) any new messages anymore.

So, I posted a message in my forum and ran it manually - that message was exported, but nothing was imported.

So, I check the last post ID variable and found it to be 194025. I set it down to 193000 and reran the gateway (with debug =1). Nothing was imported, however, the last post ID was RESET to 194025.

All I get now is this:

Gateway version 2.2.1 1 group(s) gatewayed.

Connecting to server, server says: 200 216.128.74.129

Server responded after user name: 381 Helo adx785 password required

Server responded after password: 281 Authorization accepted

Info for rec.gambling.poker at news.athenanews.com:
211 45712 653980 704305 rec.gambling.poker selected

Well, I got it working. I had set the Post ID and not the message ID.

The message ID is in the Groups page and the post is in the settings page.

Message is for the usenet number and postid is for the internal (max vbulletin forum post) number.

There must be some messages that cause this script to die. Once I bumped the message number up again, it worked.

Not sure what size you are referring to. The raw mysql file size? or the mysqldump file size?

MyISAM tables keep the space after deletion. New records will be inserted into the empty spaces. You might like to search Google for
optimize myisam table
and/or
phpmyadmin overhead optimize