vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   NNTP Gateway for Usenet ( Newsgroups ), Mailing Lists (https://vborg.vbsupport.ru/showthread.php?t=92588)

KW802 01-12-2007 04:35 PM

Quote:

Originally Posted by kjhkjh (Post 1157185)
...
I'm registered with http://www.tigerusenet.com/ (I think it's $7.50 a month - for 15GB / month)
This newsserver allows access on ports: 119, 80, 3128, 23, 7000, 8000, 9000

I had to then keep pushing my hosting company to open port 7000 (because they wouldn't open port 119 on a shared hosting plan) eventually they did it. It took 24 hours for them to process this change. They needed to know the ip address of the where the open port was connecting to so I did an ip lookup for news.tigerusenet.com ...

To make your life easier in the future I suggest using port 80 instead. Port 80 is the port that HTML (www.yoursite.com) goes over so it's almost a 'universal' port number. By using port 80 instead of 7000 then if you switch your hosting service to a different company in the future then you'll know that you don't have to go through this all over again with asking them to open up a different port number.

bashy 01-13-2007 09:39 AM

Hi

I have had port 119 enabled on my dedicated server but i still get
Connecting to server, server says: 502 Permission Denied - Permission Denied -- http://www.highwinds-software.com/ (Tornado v1.0.6.380)

Info for uk.media.tv.misc at news.ntlworld.com:

Connecting to server, server says: 502 Permission Denied - Permission Denied -- http://www.highwinds-software.com/ (Tornado v1.0.6.380)

Info for alt.binaries.movies.divx at news.ntlworld.com:

This happens whenever i try to connect to the news.ntlworld.com (free server)
Or when i try to connect to my paid newshosting server

Any thoughts on this please?

TMM-TT 01-14-2007 04:07 PM

Quote:

Originally Posted by bashy (Post 1157879)
Hi

I have had port 119 enabled on my dedicated server but i still get
Connecting to server, server says: 502 Permission Denied - Permission Denied -- http://www.highwinds-software.com/ (Tornado v1.0.6.380)

Info for uk.media.tv.misc at news.ntlworld.com:

Connecting to server, server says: 502 Permission Denied - Permission Denied -- http://www.highwinds-software.com/ (Tornado v1.0.6.380)

Info for alt.binaries.movies.divx at news.ntlworld.com:

This happens whenever i try to connect to the news.ntlworld.com (free server)
Or when i try to connect to my paid newshosting server

Any thoughts on this please?

Do you get such errors even if you login manually?

bashy 01-14-2007 04:41 PM

Sorry, can you elaborate, not quite sure what ya mean by login manually?

KevinM 01-14-2007 04:48 PM

Quote:

Originally Posted by bashy (Post 1157879)
Hi

I have had port 119 enabled on my dedicated server but i still get
Connecting to server, server says: 502 Permission Denied - Permission Denied -- http://www.highwinds-software.com/ (Tornado v1.0.6.380)

Info for uk.media.tv.misc at news.ntlworld.com:

Connecting to server, server says: 502 Permission Denied - Permission Denied -- http://www.highwinds-software.com/ (Tornado v1.0.6.380)

Info for alt.binaries.movies.divx at news.ntlworld.com:

This happens whenever i try to connect to the news.ntlworld.com (free server)
Or when i try to connect to my paid newshosting server

Any thoughts on this please?

When you say free, do you mean the service which you get with your broadband provider on your home pc? If so, they probably perform an IP check and when it is not coming from a non-NTL line (which your ded server won't), it won't connect. The first time I got this hack I tried using the free BT service I got (and failed).

If you are getting this with a paid service (e.g. giganews, teranews etc), then I would guess the most common reason is username & password issues. Can you log in with these on a normal newsreader? The fact you are getting permission denied errors means the port is problably enabled correctly, or you wouldn't have got this far. What paid service have you gone for?

bashy 01-14-2007 06:11 PM

I am using newshosting, have been for about a year now, i copied and pasted the login details so theres no mistyping..... The only server i have managed to connect to is the free Microsoft 1

TMM-TT 01-14-2007 06:23 PM

Quote:

Originally Posted by bashy (Post 1159020)
Sorry, can you elaborate, not quite sure what ya mean by login manually?

Manually with, for example, a news client. I was thinking of the 502-message, that may indicate missing username/password.

bashy 01-14-2007 07:17 PM

ah right, yeah im downloading with grabit as we speak lol

Rik Brown 01-14-2007 07:36 PM

For aesthetic reasons, I prefer not to have the "Re :" in the subject line created by incoming Usenet threads/posts even if it is a reply. vBulletin doesn't use such formatting and any reply post leaving our system via the gateway will get the "Re: " pre-appended to the subject line for Usenet compatability.

If you likewise wish to remove the incoming "Re: " from the subject line, find the following line in gateway.php:

PHP Code:

 $subject htmlspecialchars(trim($message['subject'])); 

After the above line, simply insert the following:

PHP Code:

if (substr($subject04) == 'Re: '){
$subject substr_replace($subject''04);


If you wish to change your entire message database to remove any prior "Re: " in both threads and posts, just look for my prior post #396 in this thread which indicates the two mySQL queries to do so. Once done, all your threads/posts will be in this same format.

Again, this is only an aesthetic choice for me and shouldn't be considered a bug fix. I hope others might find it useful. If anyone sees any code conflict here, please advise.

Regards. -- Rik

ps: I'm not a PHP programmer so anything I say must be taken at your own risk. Backup your database first. But I've been using this change for several weeks now and all appears working fine.

After the above coding, NNTP_GW attempts to match the incoming post to vb threads "by reference" or "by subject." I'd prefer to make that a single lookup by subject at a future time as threading is already mangled if you are using a killfile that breaks thread sequences. Note, for example, that if the first message in a thread was deleted by your killfile, message #2 will now start a new thread without any "Re: " in it.

TMM-TT 01-14-2007 08:16 PM

Quote:

Originally Posted by Rik Brown (Post 1159228)
PHP Code:

if (substr($subject04) == 'Re: '){
$subject substr_replace($subject''04);




How about a single line?

PHP Code:

$subject preg_replace('[^Re: ]'''$subject); 


Rik Brown 01-14-2007 08:19 PM

Quote:

Originally Posted by TMM-TT (Post 1159266)
How about a single line?

PHP Code:

$subject preg_replace('[^Re: ]'''$subject); 


Great! I'm just starting out with PHP and any tips are appreciated. Thanks. -- Rik

TMM-TT 01-15-2007 01:05 AM

Quote:

Originally Posted by Rik Brown (Post 1159270)
Great! I'm just starting out with PHP and any tips are appreciated. Thanks. -- Rik

Another example that should fix all Re:'s no matter if it's in upper or lower-case. :)

PHP Code:

$subject preg_replace('/^re: /i'''$subject); 


jgrtap 01-17-2007 01:45 PM

Has anyone managed to get this to work using the internal scheduler in vBulletin? We're a small board on a shared server hosted at GoDaddy and I'm not sure we have access to an external scheduler...

KW802 01-17-2007 03:50 PM

Quote:

Originally Posted by jgrtap (Post 1161430)
Has anyone managed to get this to work using the internal scheduler in vBulletin? We're a small board on a shared server hosted at GoDaddy and I'm not sure we have access to an external scheduler...

What kind of problem are you having?

jgrtap 01-17-2007 05:14 PM

Quote:

Originally Posted by KW802 (Post 1161508)
What kind of problem are you having?

For 15 hours yesterday and this morning, the scheduled task (retrieving messages forwarded to an email account from a Yahoo group) ran ONLY if I ran the task manually. Now, all of a sudden, it seems to have started working. Let me give it 24-48 hours to test more thoroughly and I'll be back... (sounds like a threat, doesn't it?)

Thanks...

-- jgr

Rik Brown 01-17-2007 06:20 PM

Ignore.

TMM-TT 01-18-2007 11:37 AM

Quote:

Originally Posted by jgrtap (Post 1161558)
For 15 hours yesterday and this morning, the scheduled task (retrieving messages forwarded to an email account from a Yahoo group) ran ONLY if I ran the task manually. Now, all of a sudden, it seems to have started working. Let me give it 24-48 hours to test more thoroughly and I'll be back... (sounds like a threat, doesn't it?)

Thanks...

-- jgr

I've had the same problem but not only for this hack - all scheduling seem to have stopped here too.

jgrtap 01-20-2007 03:27 AM

Quote:

Originally Posted by TMM-TT (Post 1162096)
I've had the same problem but not only for this hack - all scheduling seem to have stopped here too.

I'm totally baffled. The gateway works, no problem. But the scheduler is a disaster. It starts, it stops, no error messages, no nothing. I can't figure it out for the life of me.

Is there an external scheduler for a GoDaddy shared hosting account?

Rik Brown 01-20-2007 05:50 PM

Quote:

Originally Posted by jgrtap (Post 1163225)
I'm totally baffled. The gateway works, no problem. But the scheduler is a disaster. It starts, it stops, no error messages, no nothing. I can't figure it out for the life of me.

I hate to say it but the vb scheduler has worked flawlessly for us over the past several months that we have had this mod installed.

I have the log entries disabled and we run the gateway.php script hourly. I can't think of any reason it would operate manually but not operate under the scheduler except some conflict with the logging because almost all other options are simply for times/day, etc.

Sorry, I know that doesn't help much except to say that it can work flawlessly via the scheduler.

Regards. -- Rik :o

jgrtap 01-20-2007 06:12 PM

Quote:

Originally Posted by Rik Brown (Post 1163650)
I hate to say it but the vb scheduler has worked flawlessly for us over the past several months that we have had this mod installed. I have the log entries disabled and we run the gateway.php script hourly. I can't think of any reason it would operate manually but not operate under the scheduler except some conflict with the logging because almost all other options are simply for times/day, etc. Sorry, I know that doesn't help much except to say that it can work flawlessly via the scheduler.

As long as it CAN work, I'll keep plugging away, Rik, and I appreciate the info -- it gives me some hope!

jgrtap 01-20-2007 10:07 PM

Quote:

Originally Posted by Rik Brown (Post 1163650)
I hate to say it but the vb scheduler has worked flawlessly for us over the past several months that we have had this mod installed.

Rik, to double check, would you mind telling me exactly what the settings are that you have in nntp_groups, nntp_settings (substituting for any private info) and the scheduled task manager? I'd appreciate it.

KW802 01-21-2007 04:06 AM

Quote:

Originally Posted by jgrtap (Post 1163225)
I'm totally baffled. The gateway works, no problem. But the scheduler is a disaster. It starts, it stops, no error messages, no nothing. I can't figure it out for the life of me.

By any chance, are you trying to bring in all of the articles in a particular group or groups? The script will time itself out after 30 minutes so if you're trying to bring in thousands of articles and the script is still running for greater than 30 minutes the next time the scheduled task runs then it'll kill the prior task and try over again.

jgrtap 01-21-2007 04:47 AM

Quote:

Originally Posted by KW802 (Post 1164036)
By any chance, are you trying to bring in all of the articles in a particular group or groups? The script will time itself out after 30 minutes so if you're trying to bring in thousands of articles and the script is still running for greater than 30 minutes the next time the scheduled task runs then it'll kill the prior task and try over again.

No, this is a very small email gateway for a private forum on one side and a small Yahoo group on the other. We might be talking about 200 messages in a busy week.

familyhistory 01-21-2007 12:20 PM

I have found a news supplier, who will accept port 80. I have changed the code in gateway.php
But I get the following errors:
Quote:

Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT post.*, thread.*,
post.dateline AS postdateline, post.msgid AS postmsgid,
thread.title AS threadtitle, post.visible AS postvisible,
thread.visible AS threadvisible
FROM vbpost as post LEFT JOIN vbthread as thread
ON (thread.threadid = post.threadid
AND post.userid = thread.postuserid
AND post.postid = thread.firstpostid)
WHERE post.isusenetpost = 0
AND post.postid > 966
AND thread.forumid = 67;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Sunday, January 21st 2007 @ 02:08:15 PM
Script : http://www.forum.xx.com/gateway.php?debug=1
Referrer :
IP Address : 82.xxxxxx
Any help on this please,:)
Dave

Rik Brown 01-21-2007 08:51 PM

Quote:

Originally Posted by jgrtap (Post 1163838)
Rik, to double check, would you mind telling me exactly what the settings are that you have in nntp_groups, nntp_settings (substituting for any private info) and the scheduled task manager? I'd appreciate it.

I don't have a screen capture utility installed (a company no-no). But here is a sample setting for a newsgroup:

HTML Code:

Newsgroup/Mailing list E-mail                  [alt.pandas              ]
Forum                                        [-- Pandas Forum        ] <- vBulletin Forum
Prefix                                        [                        ]
Last Message                                [                        ]
Server                                        [news.yournewsserver.com ]
User name (only if required)                [your_user_name_here    ]
Password (only if required)                [your_password_here      ]
Enter 'use_real_email' if you want the  [                        ] <- I leave blank
posts to use the real email addresses.
Enter 'My Name <myemail@a_domain.com>' if you want all the posts use this name and email.
Please leave this empty if unsure!!!       
Enabled                                Yes No                    <- Your choice

Except to change URLs to reflect our own site, we have used the defaults in the gateway settings except perhaps the following (set to 1 or zero):

Override useragent and organization checks to import absolutely everything from USENET. 1 = Full Import from oldest existing message, 0 = Ignore and start at next message.
Full import from USENET full_import_from_usenet 0

Use the email address to associate postings with the corresponding vBulletin user.
Associate by Email associate_by_email 1

Skip the message if the message has the X-No-Archive header set to yes. Google Group honours this Non-standard header. Set to 1 to honour. 0 to ignore.
Honour No-Archive honor_no-archive 0 [Edit]

When it is set to 1, no signatures will be sent with posts. When it is set to 0, users' signature selection at post is honoured.
Send no signature nosignature 1 [Edit]

Set to 1 : no profile/view thread footer will be sent. Set to 0 : attach user profile and view forum thread footer with each message posted.
Send no footer nofooter 1

Default = 0. Set to 1 : Time stamp for imported messages use the original post time. Set to 0 : Time stamp uses the time when the messages is imported
Use Post Time use_post_time 1

The vb scheduler looks like:

HTML Code:

Varname                          gateway_varname
Title [Translations]                NNTP Gateway
Description [Translations]        Usenet newsgroups gateway mailer.
Log Phrase [Translations]        NNTP Gateway
Day of the Week (Note: this    *
overrides the 'day of the
month' option)       
       
Day of the Month                *
       
Hour                                *
       
Minute                                30 - - - - -
       
Active                                yes
Yes No
       
Log Entries                        no               
Yes No
       
Filename                        ./gateway.php       
       
Product                        vBulletin       

I hope the above helps. We are only importing newsgroups so we haven't tried binaries or mailinglists.

Regards. -- Rik

ps: Sorry, the gateway options order above may be different as we may have sorted them.

jgrtap 01-21-2007 09:53 PM

We copied our install onto a dedicated server so we could see the Apache error logs and the immediately obvious error was having gateway.php installed in includes/cron causing it to fail trying to require files from includes/cron/includes/cron thus causing cron.php to fail.

Quote:

Originally Posted by Rik Brown
Code:

Filename                        ./gateway.php

We've corrected the task to use ./gateway.php -- and now the forum doesn't respond. (sigh)

Rik Brown 01-22-2007 06:40 PM

Quote:

Originally Posted by jgrtap (Post 1164593)
We copied our install onto a dedicated server so we could see the Apache error logs and the immediately obvious error was having gateway.php installed in includes/cron causing it to fail trying to require files from includes/cron/includes/cron thus causing cron.php to fail.

We've corrected the task to use ./gateway.php -- and now the forum doesn't respond. (sigh)

Forget cron for the time being. You need to have the gateway.php file installed in your vb forums root directory and functions_nntp.php, mime.php, and pop.php in the "includes" subdirectory beneath your forums root directory (and all other files in their correct directories per the install instructions).

Then run gateway.php in debug mode such as vb.com/forums/gateway.php?debug=1. You should see some sort of output that should help indicate if you have any further problems. But it just looks like you need to get the directory structure correct first. Then the vb scheduler should also work since ./gateway.php is referring to executing the gateway.php file in your root vb forum directory.

-- Rik

gbechtel 01-23-2007 07:54 PM

Quote:

Originally Posted by poliveira (Post 944948)
I am receiving this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE nntp_settings
SET value = WHERE varname = 'last_postid';

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 'WHERE varname = 'last_postid'' at line 2
Error Number : 1064
Date : Saturday, April 8th 2006 @ 10:18:32 PM
Script : http://.../forums/gateway.php
Referrer :
IP Address : ...
Username : ...
Classname : vB_Database


I am getting the same type of error message. I am not seeing the tables in my vb database

Mine...

Quote:

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT post.*, thread.*,
post.dateline AS postdateline, post.msgid AS postmsgid,
thread.title AS threadtitle, post.visible AS postvisible,
thread.visible AS threadvisible
FROM vb3_post as post LEFT JOIN vb3_thread as thread
ON (thread.threadid = post.threadid
AND post.userid = thread.postuserid
AND post.postid = thread.firstpostid)
WHERE post.isusenetpost = 0
AND post.postid >
AND thread.forumid = 93;

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 'AND thread.forumid = 93' at line 11 Error Number : 1064
Date : Tuesday, January 23rd 2007 @ 04:50:20 PM
Script : http://www.domain.com/forums/gateway.php?debug=1
Referrer :
IP Address : *.*.*.*
Username : *********
Classname : vb_database

jgrtap 01-24-2007 04:13 AM

Quote:

Originally Posted by Rik Brown (Post 1165190)
Then run gateway.php in debug mode such as vb.com/forums/gateway.php?debug=1. You should see some sort of output that should help indicate if you have any further problems.

We get the missing-value SQL error.
Code:

SET value =  WHERE varname = 'last_postid'
This message appears to be a consequence of having NO postings in the section.

leeherron 01-24-2007 11:03 AM

Jul 2005? What ever happened to this mod? Has anyone successfully installed it on 3.6.4?

gbechtel 01-24-2007 03:17 PM

I got mine running by putting the number 1 in the field for last_postid

Now to work on the killfile, does anyone have one they are willing to share. I love the mod but the spam on USENET makes it worthless unless I can filter most of it out.

leeherron 01-24-2007 03:39 PM

It's a great mod. I was just amazed to see it hadn't been updated since Jul 05! Working on updating my old setup (installed NNTP on that one back in '02) and would love to install this on my stage box but wasn't sure if it worked on 3.6.4 - thanks for the tip.

KW802 01-24-2007 05:07 PM

Quote:

Originally Posted by leeherron (Post 1166464)
It's a great mod. I was just amazed to see it hadn't been updated since Jul 05! Working on updating my old setup (installed NNTP on that one back in '02) and would love to install this on my stage box but wasn't sure if it worked on 3.6.4 - thanks for the tip.

Due to time constraints the original creator has had to give up support for it. It still works fine with the current versions of vBulletin but essentially it is now a user-to-user supported modification.

Lierduh has also given permission for people to create branch versions of the project so you may see some of them floating around as well.

jarosciak 01-25-2007 11:47 AM

Quote:

Originally Posted by KW802 (Post 1166521)
...also given permission for people to create branch versions of the project so you may see some of them floating around as well.

Can you point me please to download or thread of one known to work with 3.6.4?
Thanks
Joe

KW802 01-25-2007 07:39 PM

Quote:

Originally Posted by jarosciak (Post 1166973)
Can you point me please to download or thread of one known to work with 3.6.4?
Thanks
Joe

Have you tried the one in this thread? Seems to be working fine yet.

Icehawk002 01-27-2007 10:07 PM

Installed on 3.6.4 appears to work ok with the mailing lists although not tested the reply from forum feature as yet.

Two issues, when the showthread does not go to the specified thread but to no such thread, despite the link appearing to be a numbered showthread and correct.

Secondly sometimes the prefix is RE:[PREFIX] and is therefore excluded can you add some value or more than one prefix for a mail list.

Any help?

Icehawk002 01-27-2007 11:05 PM

I read some of the posts in this thread reference the RE: issue.

First I think I may have set the mailing list prefix wrong should this be a reference in the subject line.

emails are sent to the mailing list as either [group]topic or RE:[group]topic by setting the newsgroup prefix in admincp to [group] gateway.php ignores all RE:[group] messages.

hope thats clearer for understanding my problem.

Icehawk002 01-27-2007 11:29 PM

OK partially sorted problem now is that RE[group] starts a new thread from.

tpearl5 02-01-2007 03:36 AM

Quote:

Originally Posted by KW802 (Post 1145403)
Did you try the killfile settings? (ACP => NNTP Gateway Options => NNTP Gateway Settings => Global Killfile) I have a few entries in my and it seems to be working as expected.

Ah sweet, I didn't even see that!

Second question: is anyone having issues with posts not being added to newsgroups threads if the user doesn't quote a reply? The instructions in Advanced_gateway_hacking_guide.txt are a little off. If you corrected this, how?

For example, here is a newsgroup thread looking through google groups: http://groups.google.com/group/alt.c...a47317?lnk=gst

Here it is on the forums: http://cellphoneforums.net/alt-cellu...ata-plans.html

tpearl5 02-01-2007 12:27 PM

Oh, and where do you actually put the killfile? I don't have a form to put any values in.


All times are GMT. The time now is 04:46 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02049 seconds
  • Memory Usage 1,913KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_html_printable
  • (6)bbcode_php_printable
  • (27)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete