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 02-01-2007 01:58 PM

Quote:

Originally Posted by tpearl5 (Post 1172044)
Oh, and where do you actually put the killfile? I don't have a form to put any values in.

The name "killfile" is kind of a misnomer... any entries you put into that ACP option will actually have the affect of skipping the post, not actually moving it to a seperate forum or file.

tpearl5 02-01-2007 03:07 PM

Quote:

Originally Posted by KW802 (Post 1172119)
The name "killfile" is kind of a misnomer... any entries you put into that ACP option will actually have the affect of skipping the post, not actually moving it to a seperate forum or file.

Right. I didn't realize there was a 'values' field. duhh

I just figured out how to get the quick reply and reply buttons to go away for newsgroup threads.

See attached Advanced gateway hacking guide for the steps I used. I have 3.5 but I would think it would work fine in 3.6 as well.

Aylwin 02-13-2007 07:00 AM

I've just noticed that forum subscription doesn't work (at least not for me). When new threads are created from the newsgroup/mailing list I don't receive any email notification.

Does anyone know how to code this? Or point me in the right direction?

Rik Brown 02-17-2007 08:49 PM

I'm looking for other sources to network this Gateway with beyond Usenet. Is anyone using this Gateway to network forums other than Usenet? It appears Microsoft pubic forums are a possibility. Is there anything else out there that people are using the Gateway with?

Thanks. -- Rik

mpascal 02-17-2007 11:21 PM

Just upgraded from 3.5.2 to 3.6.4

The instructions say:
Quote:

2. How to run your AdminCP interface?

OPTION A (Edit a php file)

Edit ./admincp/index.php file
Find
construct_nav_option($vbphrase['vbulletin_options'], 'options.php?null=0', '<br />');

Below, add
construct_nav_option('NNTP Gateway Settings', 'nntp_settings.php', '<br />');
construct_nav_option('NNTP Gateway Newsgroups', 'nntp_groups.php', '<br />');

Above step adds two links to your Admin Control Panel for you to click.
================================================== =======================
That worked fine in 3.5.x but in 3.6 there is no such line.
I tried a couple of similar places but then the NNTP links would show up in every menu category.

Thanks
Marino

tpearl5 03-27-2007 05:08 AM

I found that if I put 'www' and 'http' in the killfile, there are a significant amount of posts that are not imported from usenet, sometimes causing threads to be not found by reference and split up. Has anyone else experienced this?

dotcomguy 03-30-2007 03:22 PM

Thank you for this hack. I currently have it setup and am importing posts from four newgroups. However, I am noticing a problem with bbcodes. The gateway script automatically adds color and adds [url] tags around URL's, however these bbcodes are not being parsed correctly when viewing the thread. The raw bbcode appears. I suppose I could rebuild the post cache to fix all those that I have already imported, but it would be nice if new posts added would have corresponding entries in the postparsed table.

Thanks

Droll 04-01-2007 05:58 PM

Installed this hack and finally got it running, I think I have applied all "updates" found in this thread, but I got a big problem.......

When downloading pictures from the news, some of them will be corrupted ( not all, pictures I have sent to the news group are fine :confused: , most of the other are distorted or just blank )

This one is downloaded with Thurderbird news client
http://tinyurl.com/376raf

This one is downloaded with this hack :confused:
http://tinyurl.com/3a2lma

Running vBulletin 3.6.5 on a ClarkConnect ( Linux Centios ) based server ( dual P3, 1GB ram )

Arne Kjetil

panda1 04-15-2007 08:40 PM

Will this NTTP Newsgroup hack work well with 3.6.5?

I coudn't locate any hack for 3.6.5!

Any body around have installed it successfully?

Thanks!

Panda1

Rik Brown 04-18-2007 03:32 PM

Quote:

Originally Posted by panda1 (Post 1228586)
Will this NTTP Newsgroup hack work well with 3.6.5?

I only use the newsgroup option but that part works fine for me with vb 3.6.5. -- Rik

panda1 04-18-2007 09:15 PM

Quote:

Originally Posted by Rik Brown (Post 1230483)
I only use the newsgroup option but that part works fine for me with vb 3.6.5. -- Rik


Rik,

Every think went fine with me but when trying to run gateway.php i received the following error:
------------------------------------------------
Database error in vBulletin 3.6.5:

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 : Wednesday, April 18th 2007 @ 04:59:06 PM
Script : http://forums.networkingland.com/adm...cron&cronid=19
Referrer : http://forums.networkingland.com/admincp/index.php
IP Address : 212.35.77.232
Username : admin
Classname : vB_Database

--------------------------------------------------

any help to fix this

Panda

manuelsechi 04-19-2007 07:13 AM

hi all
what's happen if i have to change NNTP server?
I done it and I was not able to receive any new news message...

thanx a lot for any help

manuelsechi 04-19-2007 12:59 PM

please help

I was using a NNTP server and everything went fine
I decided to change server, and now I'm not able to receive any message.
The new NNTP server works well, because i use it for another service
so I think now it doesn't work because of the last message id number

I can reset that number but I don't want duplicate messages from usenet in my board...

any idea?

thank u

Rik Brown 04-19-2007 06:07 PM

Quote:

Originally Posted by panda1 (Post 1230810)
Rik,

Every think went fine with me but when trying to run gateway.php i received the following error:
------------------------------------------------
Database error in vBulletin 3.6.5:

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 : Wednesday, April 18th 2007 @ 04:59:06 PM
Script : http://forums.networkingland.com/adm...cron&cronid=19
Referrer : http://forums.networkingland.com/admincp/index.php
IP Address : 212.35.77.232
Username : admin
Classname : vB_Database

--------------------------------------------------

any help to fix this

Panda

Panda:

Sorry, I'm not much of help with mySQL. But it looks to me that a variable is not set since the
line "SET value = (some value should be here) WHERE varname = 'last_postid';" is missing a value which should be in your nntp settings. See the "Last Max postid" variable in your NNTP Gateway Settings.

I'd make sure you have the defaults all set there and leave nothing blank.

-- Rik

panda1 04-19-2007 07:06 PM

Quote:

Originally Posted by Rik Brown (Post 1231390)
Panda:

Sorry, I'm not much of help with mySQL. But it looks to me that a variable is not set since the
line "SET value = (some value should be here) WHERE varname = 'last_postid';" is missing a value which should be in your nntp settings. See the "Last Max postid" variable in your NNTP Gateway Settings.

I'd make sure you have the defaults all set there and leave nothing blank.

-- Rik

Thanks Rik!

You are right, this is a testing forum and I have no messages yet and the 'last_postid' should be some thing greater than zero.

I did created one message in my testing board and the problem was fixed, but I still have a problem connecting to google Usenet groups servers.... and I don't know if I am providing the right newsgroups sever URL, username and password!!!

I keep getting the following error message:
----------------------------------------------------
Gateway version 2.3.2 4 group(s) gatewayed.
Could not connect to NNTP-servegoggler. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
(10060))

Not connected
----------------------------------------------------

Any help will be appreciated


Panda1:cool:

panda1 04-19-2007 08:19 PM

Quote:

Originally Posted by mpascal (Post 1184915)
Just upgraded from 3.5.2 to 3.6.4

The instructions say:

That worked fine in 3.5.x but in 3.6 there is no such line.
I tried a couple of similar places but then the NNTP links would show up in every menu category.

Thanks
Marino


Marino,

Go to next installation option
---------------------------------------------------------
OPTION B (No need to edit php file)

Just run your AdminCP interface from:

http://forums.yourdomain.com/admincp/nntp_settings.php
http://fourms.yourdomain.com/admincp/nntp_groups.php
---------------------------------------------------------------------------

It worked well with me, but don't forget to copy all hack files to your forum not only the ones in the readme file!!


good luck!

Panda1

silurius 04-20-2007 09:55 PM

Quote:

Originally Posted by woodp (Post 1145596)
I'm running vB3.6.4 and Mailman 2.1.9 and using this script to provide gateways between vB and email.

vB->email: Took a while to figure out all the Mailman idiosyncrasies but this part of the script is running perfectly. I'm certain my users will love it.

email->vB: Struggling with this. I can send an email to MailMan's pop account and it will a) get properly reflected to all users, and b) show up in the MailMan archive. Or I can "reply" to an email from the gateway and it will also a) get properly reflected to all users, and b) show up in the MailMan archive.

What isn't working is vB reading the POP3 account and posting the "email" or "reply" into the message board thread. I'm not certain what might be going on except that MailMan is immediately reading the POP3 account, then clearing it and vB has nothing to import? What else could be going on?

Any ideas out there?

(Noob here - How do I click INSTALL to indicate I'm running this script?)

Did I miss any replies to this question? I'm also attempting to get Mailman->vB working.

silurius 04-23-2007 04:31 PM

Quote:

Originally Posted by silurius (Post 1232241)
Did I miss any replies to this question? I'm also attempting to get Mailman->vB working.

Never mind. Just filling in a few more fields in the list management vB console and subscribing the appropriate address in Mailman seemed to take care of it.

amaarvell 04-24-2007 09:40 PM

Hi

when i do all the tests on the gateway they show as working and open, but when the cron does a scheduled start, I get n error message as below
.................................................. .................................................. .......
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, carl@whereinhull.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.


--------------------------------------------------------------------------------

Apache (Secured-VIPER) Server at www.vistareadygames.com Port 80

.................................................. .................................................. ........

I have checked the logs and its ahowing p as

[Tue Apr 24 23:27:33 2007] [error] [client 83.100.189.61] Premature end of script headers: php-script, referer: http://www.vistareadygames.com/admincp/index.php

Can you shed any light on this

Cheers

bkaul 04-26-2007 02:59 PM

<a href="https://vborg.vbsupport.ru/attachment.php?attachmentid=63669&d=1177602990" target="_blank" title="Name: 1.jpgViews: 34Size: 40.0 KB">1.jpg</a>

The link is to showthread.php?p=0#post0 rather than the actual post number, when the post is one that is generated by the gateway. Any ideas on what modifications would be necessary to fix this bug?

mzeitler 04-30-2007 06:14 AM

Hi,

I am pretty happy with the add-on. However some of the threads are duplicated since the usenet poster crossposts into multiple groups.

Is there a way to prevent this duplication from happening?

Since I compbine multiple usenet groups into one master group on my site, this is really annoying.

Matthias

amaarvell 04-30-2007 06:19 AM

hi guys

I am still having the problem I posted on reply 499
the anoying thing is occasionally the odd post gets through (3 so far)
this is wracking my head .. please help me someone

bkaul 04-30-2007 05:26 PM

Quote:

Originally Posted by bkaul (Post 1235871)
Attachment 63669

The link is to showthread.php?p=0#post0 rather than the actual post number, when the post is one that is generated by the gateway. Any ideas on what modifications would be necessary to fix this bug?

Clarification: I think this is only true of the initial post in a newly created thread, before any replies. Replies to existing threads appear to work properly.

tadast 05-04-2007 07:27 AM

Quote:

Originally Posted by panda1 (Post 1230810)
Rik,
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 : Wednesday, April 18th 2007 @ 04:59:06 PM
Script : http://forums.networkingland.com/adm...cron&cronid=19
Referrer : http://forums.networkingland.com/admincp/index.php
IP Address : 212.35.77.232
Username : admin
Classname : vB_Database

There are ' missing in the gateway.php code, change

Code:

                SET value = " . ((empty($get_max_postid))?(0):

($get_max_postid['postid'])) . " WHERE varname = 'last_postid'

to
Code:

                SET value = '" . ((empty($get_max_postid))?(0):

($get_max_postid['postid'])) . "' WHERE varname = 'last_postid'

That would fix the problem.

panda1 05-04-2007 06:05 PM

Quote:

Originally Posted by tadast (Post 1241156)
There are ' missing in the gateway.php code, change

Code:

                SET value = " . ((empty($get_max_postid))?(0):

($get_max_postid['postid'])) . " WHERE varname = 'last_postid'

to
Code:

                SET value = '" . ((empty($get_max_postid))?(0):

($get_max_postid['postid'])) . "' WHERE varname = 'last_postid'

That would fix the problem.

Thank you tadast for the help!


Now I have this NTTP newsgroup hack working fine with VB 3.5.6 in my new forum http://forums.networkingland.com.

But I am still facing posting problems, I am using www.teranews.com news server with posting allowed.


Frankly speaking, I am very happy with this hack, it saved me months of work! many thanks to the coder who created this hack in the first place and to all of you fellows for the help.

amaarvell 05-05-2007 08:57 AM

Guys I have this installed but I cant get it working

Gateway debug says its fine
but the cron fails every time

vbulletin say its nothing to do with them and my web host says its nothing to do with them

the script appears to be installed correctly
and my head is in bits trying to sort it

please help

amaarvell 05-05-2007 08:59 AM

Quote:

Originally Posted by panda1 (Post 1241475)
Now I have this NTTP newsgroup hack working fine with VB 3.5.6 in my new forum http://forums.networkingland.com.

you are running the gateway on the same usenet groups as me and on the same vb version .. any idea what i am doing wrong ... www.vistareadygames.com

cheers

X-Man70 05-06-2007 05:05 PM

when i start the gateway in debug mode 1, i become an erreo msg. can someone help me ?

Datenbankfehler in vBulletin 3.6.5:

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 post as post LEFT JOIN 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 &gt; 0
AND thread.forumid = 40;

MySQL-Fehler : Lost connection to MySQL server during query
Fehler-Nr. : 2013

panda1 05-07-2007 09:48 AM

Quote:

Originally Posted by amaarvell (Post 1241801)
you are running the gateway on the same usenet groups as me and on the same vb version .. any idea what i am doing wrong ... www.vistareadygames.com

cheers

Hi Amaarvel,

You are right we are running the same VB version 3.6.5 and the same newsgroup server!

It wasn't a staright forword job, actully it took me some time to fix it ( I am not a coder)

Which satge you are stuck in ?

Can you post the debug log if you reached that stage.

More details will help both of us.

amaarvell 05-07-2007 02:02 PM

Hi Panda
as far as i know its set right
if i use the debug it says its gateway'ed open

but thats it
the cron runs the gateway script every 15 minutes
but in the last 10 days i have got 4messages through

I know its a microsoft server but it should be a whole lot faster than that

any help i get will save the samaratins a head ache

panda1 05-07-2007 05:24 PM

Hi amaarvell,

It is not normal to get few messages in days or even hours.

You can try the following free usenet server : freetext.usenetserver.com ( posting not allowed) no need for username or password to start importing usenet messages.

I thing the gateway.php script is not consistent in it's behavior and it's results.

Right now one of my usenet groups is not updated since May 2nd ,2007 without any known reason from teranews.com or VB.

From admin Control Panel go maintenance and open update counters and rebuild some items there, it might help!.

Also, from admin Control Panel go maintenance and open repair/ optimize tables and repair some tables there, it might help!.

As I told you I am not a coder or programer I am a networking man!

Good Luck!

amaarvell 05-07-2007 06:53 PM

oh crap .. lol
nightmares upon night mares

it downloaded a lot of posts but 2 and 3 duplicates of each one .. how do i stop it doing that
as i now have to find a way to delete 40,000 duplicate posts

hehehe aint i the lucky one
insodently i used msnews.microsoft.com as a server

panda1 05-08-2007 05:26 AM

Don't panic my friend!

You can do duplicate deletion from VB control Panel - Maintenance- update counters- Delete Duplicate Threads.

This will solve the duplication problem, i guess!

If worked with this freetext.usenetserver.com server then you might have problems with teranews.com.

good luck!

fenris 05-27-2007 02:53 PM

Hy,

ich hoffe hier kann jemand Deutsch und mir weiterhelfen.

habe den Hack installiert und es klappt so weit alles sehr gut. Wenn ich aber nun z.B. a.b.mom auslesen lasse und dann im Forum auf den entsprechenden Beitrag klicke, versucht das Forum z.B. eine gepostetet Datei zu öffnen - was natürlich nicht klappt. Wie kann ich das den einstellen, das z.B. nur die Header ausgelesen werden und nicht die ganzen Dateien ? Oder gibt es z.B. nur die Möglichkeit neue Posts mit der Dateiendeung txt anzeigen zu lassen ?

Gruß

Fenris

TMM-TT 05-29-2007 05:35 AM

Quote:

Originally Posted by bkaul (Post 1235871)
Attachment 63669

The link is to showthread.php?p=0#post0 rather than the actual post number, when the post is one that is generated by the gateway. Any ideas on what modifications would be necessary to fix this bug?

I also had this problem until I changed the code in includes/functions_nntp.php

Somewhere around line 591 there should be something like this:
PHP Code:

        //So that thread preview works
        
$db->query("
                UPDATE " 
TABLE_PREFIX "thread
                SET firstpostid = 
$postid
                WHERE threadid = 
$threadid
        "
); 

... was changed to ...
PHP Code:

        //So that thread preview works
        
$db->query("
                UPDATE " 
TABLE_PREFIX "thread
                SET firstpostid = 
$postid,
                        lastpostid = 
$postid
                WHERE threadid = 
$threadid
        "
); 

After this I didn't have any trouble with it... I'm not sure it's a correct way to fix it, but it at least removes the zero. :)

digital3 06-03-2007 05:28 AM

As someone who has never used USENET at all, let alone attempted to find a good newsgroup or set a forum up to run it I am at a loss here. Installing the mod was simple, of course, but configuring it to actually work is another matter. There are a lot of settings in this thing under Gateway Newsgroups Management and I have no clue where to get the information I need to place in these fields. I found a newsgroup that I want to join but where do I get the info I need to connect to it? I can't find these details anywhere on their site. Do I need to create a sticky thread for this Newsgroup "before" I try adding it? There should really be a guide somewhere on how to set this thing up from ground zero. Not everyone has used USENET before and this readme makes a lot of assumptions that the end user already knows certain basic things.

itdevil 06-09-2007 06:33 PM

Quote:

Originally Posted by digital3 (Post 1260161)
As someone who has never used USENET at all, let alone attempted to find a good newsgroup or set a forum up to run it I am at a loss here. Installing the mod was simple, of course, but configuring it to actually work is another matter. There are a lot of settings in this thing under Gateway Newsgroups Management and I have no clue where to get the information I need to place in these fields. I found a newsgroup that I want to join but where do I get the info I need to connect to it? I can't find these details anywhere on their site. Do I need to create a sticky thread for this Newsgroup "before" I try adding it? There should really be a guide somewhere on how to set this thing up from ground zero. Not everyone has used USENET before and this readme makes a lot of assumptions that the end user already knows certain basic things.

Same here... Looking for public accessible Usenet server, but unable to find any. There a few paid one i found, alas none free...

Anyone have any server were they could share to use with this great mod ?

Geraldm 06-09-2007 07:10 PM

Hi,

I've installed everything as instructed in the readme text file. I have setup a new forum and added a NNTP newsgroup. But when I run the gateway.php I get the following error:

Quote:

Gateway version 2.3.2 1 group(s) gatewayed.
Could not connect to NNTP-server. (Connection refused (111))

Not connected
Not connected

The NNTP server address is correct as well as the username and password. The details have been checked with the NNTP reader called Agent and it works fine.

Does anyone know why I am getting this error when using the gateway?

Regards,
Gerald.

Geraldm 06-09-2007 09:51 PM

Ok, I found what was going on ...... My host (hostgator) was blocking port 119 (NNTP). I've spoken to them and they have now unblocked that port and the script now works perfectly.

Thank you! :)

Cheers ....
Gerald.





Quote:

Originally Posted by Geraldm (Post 1264971)
Hi,

I've installed everything as instructed in the readme text file. I have setup a new forum and added a NNTP newsgroup. But when I run the gateway.php I get the following error:




The NNTP server address is correct as well as the username and password. The details have been checked with the NNTP reader called Agent and it works fine.

Does anyone know why I am getting this error when using the gateway?

Regards,
Gerald.


Geraldm 06-11-2007 08:26 AM

Hi,

I have another question. When importing USENET messages, is there a way to set the maximum length of the original posters username?

My board is set to only accept usernames with a maximum length of 25 characters, but when importing USENET messages this setting is overwritten. How can I tunicate the usernames?

Regards,
Gerald.


All times are GMT. The time now is 04:56 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.02018 seconds
  • Memory Usage 1,901KB
  • 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
  • (4)bbcode_code_printable
  • (2)bbcode_php_printable
  • (19)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