Hey, thanks for the reply. When I run gateway.php manually, I do not get a message but rather a blank white page. It does do something though... (pauses for a few seconds) and brings up new posts from the groups. I test my outgoing messages by posting a reply in my forum, running gateway.php manually, and then waiting for it to appear in Usenet. I have yet to get a reply to appear.

I am currently running...

VB 3.0.1
VB Portal 3.0.0 Beta 2
PhotoPost

site: www.cghaus.com

I installed the original hack from this thread

https://vborg.vbsupport.ru/showthrea...7&page=1&pp=15

and then followed up with the additions from this thread

https://vborg.vbsupport.ru/showpost....&postcount=658

I am still waiting for someone to reply to my posts on my host's forums regarding my cron job. In the meantime, I am running gateway.php manually.

http://www.lunarforums.com/forum/viewtopic.php?t=15006

TIA!

I just got a reply back from tech support and they say my cron job is correct. I check my web email and see this msg.

My cron line is...

I'm not sure about the "log=cron" part... I got it from the 1st hack.

I have rewritten big chunks of the gateway.php. I will give it some test before uploading.

Improvement include:

1) TABLE_PREFIX is now supported.
2) Messages imported from usenet are now inserted into threads based on Reference in the header instead of the subject.
3) Built mechanism to avoid two instances of the gateway.php running at the same time. This can easily happen if someone clicks the link in the Who Is On Line page. This should also solve the problem of double up posts and wrong post counters.
4) Masive speed improvement!
5) Cleaned up the codes.
...

Stay tuned.

lierduh, perhaps any idea how to exclude the p´NG postings from the counter of new posts and themes?

Awesome! I'm hoping your new code fixes my problem of VB posts going out to Usenet. I removed the "log=cron" part of my cron job yesterday and now I am getting better results.


Thans in advance for taking the time to work out some updated code. :)

I have just uploaded the new package to page 44.

https://vborg.vbsupport.ru/showpost.php?p=444521

== TABLE_PREFIX is now supported.
== Messages imported from usenet are now inserted into threads based
on Reference in the header instead of the subject.
== Built mechanism to avoid two instances of the gateway.php running
at the same time. This can easily happen if someone clicks the link in
the Who Is On Line page. This should also solve the problem of double
up posts and wrong post counters.
== Massive speed improvement!
== Cleaned up the codes.
== Implemented parentid for imported posts
== lastmessage is updated now after each message retrieval. This way
no message will be imported twice, even if the script is crashed at
some stage.
== Fixed a bug which occurs in long header lines. Message may not be
retrieved due to this bug.

This time instead of a quick hack, I have gone through almost each line. So it should be a much better script.

Sorry hubba, I don't quite get what you meant.:)

Awesome! This patch came through really fast.

I have one question though... it seems I'm getting some SQL errors when attemtping to "insert" the two new tables. They already exist. In fact, value 9 is showing Organization values. Should we just overwrite this stuff manually?

I see, just change the 8 and 9 in the insert to NULL. So use:

INSERT INTO `nntp_settings` VALUES (NULL, 'Is Gateway Running', 'is_running', '0', 'Check if another instance of gateway.php is running', NULL, 0, 0);
INSERT INTO `nntp_settings` VALUES (NULL, 'Last Time Run', 'last_run', '1084316100', 'Last time the gateway.php was run', NULL, 0, 0);

I made a stupid mistake at the last minute. Please download the gateway.php again. I have attached a "a" to the end of the file name. The only thing changed was two lines in the gateway.php script. There is no need to replace the other files.

>p?NG postings

Uff... :D

On the forumhome "new posts" and "new themes" counting includes the Newsgroupposts, that I would like to exclude, so that only "real" forumposts are added...

So all the joy I had trying to get this to work last night has been addressed? :D

Thanks, lierduh - I really appreciate all your hard work.

I think I am still having issues with VB posts going out to Usenet. I'm giving it a bit of time... for the post to propagate... but it still looks like they're not showing up. This is for new posts and replies.

hmmmm...

I bascially dropped my NNTP SQL tables and installed them fresh from the new ZIP file. I also replaced the PHP files.

installed the updated script. Now MySQL error:

UPDATE post AS post, thread AS thread SET isusenetpost = 1 WHERE
post.threadid = thread.threadid AND
isusenetpost = 0 AND
thread.forumid NOT IN (200,201,202)

mysql error: Column: 'isusenetpost' in field list is ambiguous

oh buggar! now I have an even bigger problem. This is from my host...

:ermm:

Is there any way to make this script less system intensive? :rolleyes:

Run it less often ;)

I run mine every 15 minutes. Once the newsgroups are populated the script doesn't beat hell out of the server.

Got it. Just renamed all instances of "isusenetpost" in gateway.php to "isusenetp" and the sql field to "isusenetp".

Edit...

Now all seems to be OK, the script shows "240 posting OK" but no new postings are made in the forum...

Again got it ;) just deleted all posts in the forum, run the gateway and it works

Well bollocks! Lunarpages just told me to not run the script ever again. :ermm:

I can't imagine it putting that much load on the server... especially if it only collects new messages.

this sucks...

Check if your thread table has an 'isusenetpost' field. There shouldn't be one in the thread table. Only in the post table.

Yes that was the error, a double field. I thought about that but couldnt find it. Thanks!

I run each 10 minutes. It takes a few seconds to run each time. If you were using the old script and run every 5 minutes. Then if the script is called before the first one is finished. You can push the server over the edge! The new script prevents this. The new script is less system intensive.

Depending on how many messages stored on the server, the first time the script runs, it can take a long time to import all the messages. You should be able to set the last message number to a high one. That way you ignore all the older messages, only import the new ones. To find out the current message number, open the news post using a normal browser, look for Xref in the headers.

Xref: freenews.iinet.net.au aus.tv.pay:132041

The 132041 is the message number.

Check your current message setting in the nntp_groups table against what is on the server, and set the lastmsg for that group to the latest message number. Run the script manually, keep an eye on the server load. If you have shell access, type "top" should show. After you are sure that your script is not a resource hog, email the support nicely and explain to them you have fixed the problem.:)

(The next version will be even less server intensive.)

Still in the dark.:)

I searched my forum's home page for the word "theme", not there. I then searched for "post", nothing is associated with a number.

Greetings,

Can anyone confirm whether the test newsgroup list described above (here is still running? The original parameters were these:

newsgroup= webdiscuss.test
server= free.teranews.com

I have the c-imap library installed and my web services provider opened TCP port 119, but I get a notepad window popping up which says

1 group(s) gatewayed.
Logging in to free.teranews.com, group webdiscuss.test

and that's it - nothing gets imported into my designated empty forum. It seems a little further along than before they opened the port, when it used to say
"1 group(s) gatewayed.
Could not connect to NNTP-serverLogging
NotConnected Not Connected."

So, further along, but no joy!

Regards,

Matt

EDIT: To try uploading I put a test message in the forum and got this result in a popup

Posting Message from Username: 501 Unknown command: From: Username <Username.1666kd@timelimit.yourserver.com>
Posting Message from Username: 501 Unknown command: Newsgroups: webdiscuss.test

memobug, maybe you can try using the nntp.php that's on page 24 of this thread? It'll do extended logging and maybe we can figure out what's what.

No, it does not work.

[root@hd root]# telnet webdiscuss.com 119
Trying 66.51.100.134...
telnet: connect to address 66.51.100.134: Connection refused
telnet: Unable to connect to remote host: Connection refused

I get the following error when I try and run the gateway.php. Please keep in mind I am a ASP guru and PHP is all new to me... I have run this mod with VB 2 in the past with no issues.

Warning: implode(): Bad arguments. in /home/hsphere/local/home/changed/changed/forum/gateway.php on line 83

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE post AS post, thread AS thread SET isusenetpost = 1 WHERE
post.threadid = thread.threadid AND
isusenetpost = 0 AND
thread.forumid NOT IN ()
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4

mysql error number: 1064

Thank you for your time.

Mark

Thanks allan for the suggestion and lierduh for the test. I really appreciate the help. It took me nearly a month of haggling to get that port opened!

I installed the debug version of nntp that allan suggests and got this
So I guess this is consistent with what lierduh reports in his trial. Is there another mail server to try before I subscribe to a news service or do my results suggest I am getting far enough along for a reasonable chance of success?

Any recommendation on which news service I should go with when I subscribe? I'm looking to bring in rec.arts.bonsai , which is a text-based service. My three main requirements are cheap, cheap and you-guessed-it.

The email mod built into gateway - for posting - seemed to be generating errors on my server, so I commented it out as recommended in another post here.

Regards,

Matt

Mark, it will be easier since you are a programmer. :) The error is in

"thread.forumid NOT IN ()"
where it should be "thread.forumid NOT IN (100,101,102,103)

The numbers are the forum IDs.

The following code is used to retrieve the forum ID for those usenet forums

Looks like the above query did not return anything.

Is there any of the nntp_groups has "enabled" set to 1 instead of 0?

>themes

Boy ME and my english :D sorry. I mean THREADS... I have the "total new threads since last visit" and "total new postings since last visit" link in the forum. Excluded the NG Forums, that works fine, they dont show up if one searches for new postings, but the NG posts still COUNT. So, i.e. no "real" new posts in the forum, but 3 new in the NG forum = "3 new postins since last visit". I just wanna make a "Totalposts" = xxx - NGposts = realposts.

Hmmm. I applied for one of those $2.95, five-day Newsranger evaluations and tried to pull in posts from rec.arts.bonsai for the past couple of days.

I got this message:

UPDATE: this problem was corrected by using client.newsranger.com instead of www.newsranger.com so things are looking good now!
Regards,

Matt

Things are looking good now, but I have a question pertaining to follow-up gateway.php synchronization. I want to be careful not to import the same records or export them!

A) Do I run setlastmessage.php

1) ...before every gateway import
2) ...after every gateway import

and

B) Do I run it only once or every time I run gateway?

The Readme isn't clear. It says:

Looking at the code, it appears I need to run it AFTER gateway and possibly EVERY time to keep the lastmsg counter updated.

Thanks,

Matt

That is only for people who do not want to import all the existing messages on the server. So run it once only at the installation if needed. Don't blame no posts are imported if you do decided to run. :nervous:

Sorry, we are running different vBulletin. :) :surprised: I don't have these links.

>different

Maybe ;) I mean the $newposts[count] und $activethreads[count] variables. They count ALL including the NG posts. The exclude statement only shows them not up, but counts it....

Lierduh,

There is a BIG error in your code in function sendnews.

There is No WHERE clause in the query.

After using this, EVERY thread in my DB has been updated with the new msgid from the latest new thread created in the newsgroup forums.

Any way to fix this? By fixing this, I mean, resetting all the msgid's to the correct ones, or removing values where they don't belong in the thread table?

Corrected code:

If you've got any suggestions on a quick script to repair those corrupted fields, I would be greatly appreciative. I'm not sure what effect this error, and now having a incorrect msgid on EVERY thread in the DB might or might not cause. I'm not even sure what effect that field has in general to future postings. Could I just reset all those values to empty?

Got a little trouble here too, lierduh :)Any thoughts?

Mine's also not assigning posts to the proper thread after this change. I'm going to look over the code again for another hour or so, and revert to my last version if I can't get it working properly.

Messed up part is, the posting via the vB adminCP scheduled tasks worked after only minimal tweaking of the new script, and I have it tested to successfully post properly. (which was my only problem before)

I think the main problem is coming from the references. They don't seem to be assigning at all anymore.

No need to worry, although thank you very much for pointing out.:)

the msgid in the thread table is not actually used. So it does not cause any problem at all. You can safely comment this section out. I have got a new version ready to be uploaded including an optional "X-No-Archive" header honouring. Allan will love this.

I am thinking of getting rid of this field altogether. Saving a field or index is always a good thing.

(by the way, the error is inherited from the original script:))