Found the bug, please download again and replace the nntp.php file.

Ok, i'm finally making some progress on this! I'm finally able to post messages to usenet. New threads and replies are showing up fine.

When I saw there was an upgrade, I deleted the old files and replaced them with the new version you just uploaded a few hours ago. Only know I have found a new problem. This is a far smaller problem than before though.(I'm just relieved I can finally post!) Everytime I post a message when I check usenet the sender is show like this in the username field; "newthread[username]"

What have I done wrong?

I saw the new option for designating a name for all users to display in usenet, but I dont want everyone to have the same name. I want THEIR names to show up. I also don't want their real emails to show up. That's an invitation for spam. So I left the new option black.

Is this "newthread[username]" thing in place of the senders name a bug, or have I done something wrong?

/done and working fine.

And again - Thanks for all the work, lierduh !

Hello, I am using the new version and got a quick question. Is it possible to:

use this function "My Name <myemail@a_domain.com>" in the "Edit Newsgroup Settings"

but have "My Name" be a dynamic variable of the posts username?

Can?t confirm that for my forums - everything shows up as it should. Have you downloaded 2.3.1 and re-updated your files ?

It is certainly a bug. I have found one "$" missing in the code. This bug would only show when you allow the Guests to post (unregistered users to post).

I have fixed that and uploaded again. For the folks who just downloaded the v2.3.1, please do it again. To justify all the downloads. I have added a new feature in the script. When you change the $do_cron_log value from 1 to 0. The debug message will be emailed to the site email, even if you use the Unix cron job.

This can not be done without changing the code.

but those messages are not on the NNTP servers, mentioned above..
this is the major problem i have..

any idea ? or how can i debug the same ?

Regards,

Any chance of adding this as a feature? Or if its not to much guide me to the section of code that would need changing.. :)

Then who sent these posts?:)

http://groups.google.com.au/groups?h...3DN%26tab%3Dwg

I do not understand the need for such. Do you want a working email address to be used, yet you change the username each time someone posts? What would the usernet user say? Why would you want to fake the identity while having a working email address? The normal usenet users will see the same user posting under different nicks.

Actually I am using this to post back to a mailing list, offering this as a solution to visitors who dont want to get 200+ emails a day. The benefit of having the senders named changed and the email address stay the same is, only 1 email address has to be registered to the mailing list and people on the mailing list know the post is from more then one user.

I hope i explained this ok.

Run 2.3.1 + fresh install vb 3.0.3 (reloaded scripts and re-installed forum with an empty MySQL database every time) with two differents news servers (public and paid). Got always same problem: MySQL error + posts correctly imported and threaded but with wrong statistics, it doubles the amount of posts : Threads: 4, Posts: 12 (see screenshot). I have to update counters to correct problem at every cron job.

NNTP Gateway_settings: all default.
NNTP Gateway Newsgroup: see screenshot.

Config.php checked.

Any ideas ?

Each post has the user name in the signature area any way. You can set the Common user as eg. "X Forum Gateway" and the footer will identify the real user.

In gateway.php, find: $good_to_set_postid = 1;

Before that, insert one line:
print_r($get_max_postid);

Post the result again.

@ lierduh

I am just running the script http://www.xxxxxx.org/forum/gateway.php?debug=1 (without re-install). I got:

Array ( [postid] => 6 ) Gateway version 2.3.1 1 group(s) gatewayed. Connecting to server, server says: 200 NNTP Service 6.0.3790.206 Version: 6.0.3790.206 Posting Allowed Info for microsoft.public.netiquette at msnews.microsoft.com: 211 7 5366 5429 microsoft.public.netiquette

reinstall:

Array ( [postid] => ) Gateway version 2.3.1 1 group(s) gatewayed. Connecting to server, server says: 200 NNTP Service 6.0.3790.206 Version: 6.0.3790.206 Posting Allowed Info for microsoft.public.netiquette at msnews.microsoft.com: 211 7 5366 5429 microsoft.public.netiquette Getting message number 5367: 'Re: 8-30-04' from John Eddy [MSFT]. New thread. Getting message number 5368: 'Re: 8-30-04' from rosie. Thread found by References. Getting message number 5369: 'Re: 8-30-04' from John Eddy [MSFT]. Thread found by References. Getting message number 5425: 'Newsgroup postings' from Joan. New thread. Getting message number 5426: 'Re: Newsgroup postings' from John Eddy [MSFT]. Thread found by References. Getting message number 5429: 'Re: Newsgroup postings' from Joan. Thread found by References.


There seems to have been a slight problem with the Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin 3.0.3:

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 3

mysql error number: 1064

Date: Wednesday 27th of October 2004 08:17:09 AM
Script: http://www.xxxxxxxxorg/forum/gateway.php?debug=1
Referer:
Username: Unregistered
IP Address: xxxxx

Here is your problem. Do you only have this problem when you do a refresh installation? You will get this problem if you do not even have one post in the post table.

Otherwise your problem might be related to the version of php and MySQL. Basically it returned nothing when the query tried to find the max(postid). It returned 6 in your last message, now it does not return anymore.

Yes, I have this when I do a fresh installation without post in the post table.
Maybe it's the problem. I reinstalled it. Posted 2 messages. Now, I have somthing new. It tries to download instead of displaying the contents... I run it with mozilla. I got:

Gateway version 2.3.1 1 group(s) gatewayed.

Connecting to server, server says: 200 NNTP Service 6.0.3790.206 Version: 6.0.3790.206 Posting Allowed

Info for microsoft.public.netiquette at msnews.microsoft.com: 211 7 5366 5429 microsoft.public.netiquette


Without MySQL error but the stats are wrong again (double post).

I'll redo tonight.

Just one more question.

Can I run it only with mozilla or mozilla firefox ?
With IE, I have to fix the registry.

Thanks for your time.

Feel good to see the hack is now working for me ;)
I tried to reply to 3 posts using quickreply, small reply button and large reply buttons and it worked perfect with all of them, my replies got posted in the same thread/post on NTTP Server. this is the log
However i noticed a few things now -
My username - newthread[username]
appears that on all the 3 posts i made.

Also i am still waiting for your comments on 1 thing.
I noted that degugging messages are only inserted when the task is ran manually else it just adds up entries in admincp like:

8632 Gateway Messages Import 01:45, 26th Oct 2004 Ran NNTP Gateway

Found another bug, at line 1083. I missed another "$".
Change
$from_header = "newthread[username] <$msgid>";

To
$from_header = "$newthread[username] <$msgid>";

(notice the $ before newthread)

I will check the debug/log thing later. I do not use the Scheduled Tasks makes it a little harder.

Hi all,

I'm having problems getting my website hosted with a gateway hack. Can anyone point me towards a host that you use and that lets you use a gateway?

thanks

1 most important part lierduh
Please also add some customized security to gateway.php file (should only be able to execute via usergroup id 6 or some user ids which can be added to that file) coz @ the moment any damn user is able to run that file (this may create server load problems or other issues).. or possibly taking the gatway.php under admincp folder.

Regards,

No, you don't need to worry about this (server load etc.), trust me.

What would one put in the server block for alt.religion ?

OK, I run it once more (scripts reloaded + forum re-installed with empty databse). I got nio more MySQL error. Posts are correctly imported and threaded but bad news: the forum displays again wrong statistics, it doubles the amount of posts (see screenshot). I have to update counters and Rebuild Forum Information to correct problem at every cron job.

Didn't I mentioned the script will give error when you have empty post table? I am not sure why you insist on empty database.

I counted you have 8 posts imported and the forum shows 8 posts in there. If you had errors, then the counter could be out.

Ok, with all of these newer versions of the script my posts are finally showing up in usenet. And with the latest bug fix, the correct username is also showing. However, I still have one little hurdle. My post *only* show up in usenet when I run the gateway myself in debug mode. When the gateway script is auto-run via a scheduled task it downloads post into the forum at the correct time, but doesn't upload any local post to usenet. Very weird! Can you think of any reason why it would do that?

Another question; if I were to change the URL in the cronjobs to say gateway.php?debug=1 instead of just gateway.php, do you think that would work for me? Or would it cause any additional problems?

You're right :squareeyed:

Weird! You're so right. I only take a look to Forum Statistics, 7 Threads/18 posts. I'll check the counter.

Thanks.

Click Install.

anyone?

I really need a host...

What kind of problems are you having, have you tested the script yet? Do you need a host that has NNTP newsgroups on it, or just one that allows access to port 119 and you'll use your own news server?

Hello James, i am using the free services from microsoft news server now,
i want to however add alt.comp.hardware newgroup to my forums too, can you recommend me what free server can i use for same ?

Regards,

I'm using giganews for my PC's newsreader as well as for this gateway, and I love it. But I also have an account at http://individual.net, which is free. You have to register on their site and wait a few days for them to activate your account.

I have a giganews account. And it works fine. I have tested the script and everything seemed ok, but now my host tells me having a gateway like mine opens up security issues and they don't want me to run it anymore. Also, the cron job is too much juice.

So, I need a place where they will allow me to do a cron job and that is ok with the gateway.

I can use my giganews account. But if my new host had a newsserver and would save me the GGN fees, I'd sure go for it, but it's not necessary.

thanks

Hi lierduh,

your hack is very dependable. Since the first release of you hack I noticed for some reasons the gateway isn?t exporting new threads in the forums into the newsgroups. I never found out why this was happening and in a post a few threadsites ago someone mentioned that too.

While bug tracing today I found something that I?ve never noticed before. I guess because I never run the gateway.php through the admincp/cronadmin.php. I always run the gateway as ?debug=1 in a seperate browser window, even if I had set the cronadmin.php to do this job. I only wanted to see the results time by time.

First I got to say that my host is running php as a module under cgi. So my account is restricted by various limitations through that.
My installed version of your hack is 2.3.1 (gateway.php,v 1.40 2004/10/26 14:53:00) modified with your posted additional bugfixes.

As said before, I struggled with the problem that some posts made in the forums doesn?t became exported to the newsgroups. They just never showed up there. I couldn?t figure out why this happend and I couldn?t see or find conditions, which caused this.
Everytime someone informed me about not exported posts, I posted a testpost in my forums and exported this one to the ng through the link http://www.myforums.com/forum/gateway.php?debug=1 - and it worked just perfect. So I never found out what the heck was going on.

Today I noticed that various posts haven?t been exported to the ng again. So I posted some testpost in the forums. But this time - dunno why ;) - I went back to the admincp and run the gateway through the cronjob in admincp/cronadmin.php - and whooops..what?s that ?! I had to recognize that something was going terrible wrong with that:

None of the new posts became exported to the ng - but posts from the ng became imported to the forum. So at least something seemed to happen in the background. Even if I don?t know what exactly.
At first glance I thought I could have uploaded gatway.php to the wrong DIR, uploaded 2 different gateway.php?s to 2 different DIR?s or/and had set the paths incorrect, double-checked everything, but all params were set correctly and gateway.php only exists in the DIR /forum/.

I wrote another testpost and tried to export this one the way I did it the last weeks through a single browser window and the adress http://www.myforums.com/forum/gateway.php?debug=1. Again, that worked perfect, imported and exported all posts absolutly reliable.

After that I thought give it a try and changed the admincron-param from ?./gateway.php? to ?./gateway.php?debug=1?. But that only leads to another error-msg:
This time the gateway went on strike and im- or exported nothing.

I changed the admincron-param again to the full http adress ?http://www.myforums.com/forum/gateway.php?. With this the gateway seems to work fine and is exporting the new posts from the forums to the ng. It?s running now about an hour and it seems to be dependable and stable. I stress seems cause I thought this a few times before ;)

But..I would like to know wether anyone could confirm this for his/her forums or am I the only one having this problem ?

lierduh,

may be you could do us a favor.

When using a local newsreader and replying to a post, quotes are marked with :
Could you add something like that to your hack ? Would be great - thanks !

You should enter "gateway.php" instead of "./gateway.php".

You?re funny, lierduh - don?t you think I?ve already tried this before ;)
Since my first installation of your hack the param `gateway.php` isn?t working for me. With this I only receive a blank page in admincp and gateway.php is doing nothing. Wether importing nor exporting.

I was having the exact same problem. Posts were coming into the forums fine but no post were being exported to usenet unless I manually went to the gateway myself. After a lot of frustration I deleted the usenet schedued tasks (all five of them) from the forums adminCP and decided to try one last idea. I decided to set REAL cronjobs to run the gateway instead of using vB's built in functionality. I set the cronjob to run 'http://www.myforums.com/forums/gateway.php' and now it works perfectly. For anyone else who is recieving posts but none of your post are being sent to usenet, maybe this will work for you as well?

Now that it works... Lierduh, this is a great hack. For me and my forums, this is the most useful vb mod on this site. Thanks for all of your work on it and I hope you keep updating this thing!