Email stopped working after running upgrade to 2.7.7 [message #40246] |
Mon, 28 January 2008 19:14 |
BAD35th
Messages: 61 Registered: February 2007 Location: Hammertown
Karma: 0
|
Member |
|
|
Ok ran update script from 2.6.10RC3 to 2.7.7, everything seemed to run fine and completed.
Now however after a few days I have noticed email that used to feed into the forum when it was 2.6.10RC3 has stopped working. I have 2 forums where I use the email mailing list feature to send out copies of posts as email to an email distribution list. However since the upgrade: Mail is going out from the forums ok, but not coming back into the forums or being sorted into the threads...it just doesn't show up at all ??
Even though replies don't get inserted back into the forum, they do get redistributed back to the email distribution list as email and I receive those just fine.
The Mailing List rules are still intact and seem to be correct, everything else in globals.php also seems to be exactly the same.
The email acct. that is listed for forum to use is still exactly the same.
I checked the domain and MX records and they are fine.
Forgot to mention after the upgrade I get mail show up from just one user who posts in the forum as originating from G(at)prohost(dot)org?? This is not his email (see headers attached)
Any ideas what to check??
[Updated on: Mon, 28 January 2008 19:29] Report message to a moderator
|
|
|
|
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40257 is a reply to message #40256] |
Wed, 30 January 2008 03:39 |
BAD35th
Messages: 61 Registered: February 2007 Location: Hammertown
Karma: 0
|
Member |
|
|
I don't have access to the hosted areas where php is ie usr/lib/php.ini etc. I can only browse the forum files using the builtin in File Manager.
Under the errors directory I only see 2 files and no ini file.
The 2 files are the SQLErrorLOg and PHPErrorLog.
If I try to view the files using the forums Error Log Viewer I only see this under SQL:
Time Error Description
Thu Jan 1 0:00:00 GMT 1970
(System date looks wrong)
If I download the SQLError Log I see the error listed below which may be relevant. Note: I don't believe I have any command line access to the SQL Tables in use as it is hosted with you at your site ProForum.
What is next step ??
/home/c_pippy/forum_data/include/theme/default/db.inc:176<br />
/home/c_pippy/forum_data/include/mlist.inc:76<br />
/home/c_pippy/www/docs/adm/admmlist.php:40<br />
) 1064: 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 '
'',
73,
'',
'',
'',
'',
'',
''
)' at<br />
Query: INSERT INTO fud26_mlist(
forum_id,
name,
mlist_opt,
subject_regex_haystack,
subject_regex_needle,
body_regex_haystack,
body_regex_needle,
additional_headers,
custom_sig
)
VALUES(
,
'',
73,
'',
'',
'',
'',
'',
''
)<br />
_POST: array (
'SQ' => '4abb8badbbbef82ba1f97e223748e6f8',
'ml_name' => '',
'ml_forum_id' => '',
'ml_mlist_post_apr' => '1',
'ml_allow_frm_post' => '0',
'ml_frm_post_apr' => '0',
'ml_allow_mlist_attch' => '8',
'ml_allow_mlist_html' => '0',
'ml_complex_reply_match' => '0',
'ml_create_users' => '64',
'ml_skip_non_forum_users' => '0',
'ml_subject_regex_haystack' => '',
'ml_subject_regex_haystack_opt' => '',
'ml_subject_regex_needle' => '',
'ml_body_regex_haystack' => '',
'ml_body_regex_haystack_opt' => '',
'ml_body_regex_needle' => '',
'ml_additional_headers' => '',
'ml_custom_sig' => '',
'ml_submit' => 'Add Mailing List Rule',
'edit' =>
|
|
|
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40701 is a reply to message #40269] |
Sun, 06 April 2008 15:46 |
srchild
Messages: 88 Registered: December 2003 Location: UK
Karma: 1
|
Member |
|
|
I have the same problem. Any solution?
I just upgraded from 2.6.9 to 2.7.7
2.6.9 forum was running well for over two years, synchronising three mailing lists and three forums in both directions.
Now, as described above, a post to the forum is sent out to the lists, but a post to the lists does not appear in the forums.
I haven't changed my procmail or list setup, the script path is unchanged and exactly as appears in the control panel for the list, and I have confirmed from my procmail logs that the messages are getting passed to maillist.php
I have checked the shebang in maillist.php, and in fact have tried both php4 and php5 (both binaries are available to me), doesn't work with either.
php.ini shows:
log_errors Off ; Log errors into a log file
I have read-only access to php.ini, I can't edit it to enable logging.
The FUDforum and SQL error logs are empty (did the upgrade clear them?).
Suggestions please - this forum is quiet on Sunday but the mailing lists get busier on Monday morning!
Thanks.
Simon Child
[Updated on: Sun, 06 April 2008 16:28] Report message to a moderator
|
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40706 is a reply to message #40701] |
Sun, 06 April 2008 18:46 |
srchild
Messages: 88 Registered: December 2003 Location: UK
Karma: 1
|
Member |
|
|
Following on, I have traced where maillist.php is dying. I've inserted some simple logging in it, e.g.:
fud_use('err.inc');
exec("touch /path/to/logdir/1");
fud_use('db.inc');
exec("touch /path/to/logdir/2");
fud_use('imsg.inc');
exec("touch /path/to/logdir/3");
fud_use('imsg_edt.inc');
exec("touch /path/to/logdir/4");
1, 2, and 3 get created, but not 4.
FUDforum/include/theme/default/imsg_edt.inc is present.
Does that help?
Simon Child
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40731 is a reply to message #40706] |
Wed, 09 April 2008 23:19 |
srchild
Messages: 88 Registered: December 2003 Location: UK
Karma: 1
|
Member |
|
|
Does anyone have any ideas on this, I'm struggling with it.
Does anyone have mail importing working under 2.7.7?
The reason I chose fudforum a few years ago was specifically for mailing list synchronisation, and it has worked well until I upgraded - I need to get this working again ASAP.
Any clues welcome, thanks.
Simon Child
|
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40734 is a reply to message #40732] |
Wed, 09 April 2008 23:36 |
srchild
Messages: 88 Registered: December 2003 Location: UK
Karma: 1
|
Member |
|
|
Ilia wrote on Thu, 10 April 2008 00:20 | What errors are you seeing?
Make sure that the forum's files are unlocked (world-readable)
|
Problem as posts above - messages are not getting imported since I upgraded to 2.7.7. I haven't changed the configuration and it looks fine. As per postings above I have confirmed that maillist.php is getting run but seems to get no further than the include indicated above.
Forum files are unlocked, have checked that by ssh to the server and chmod -R 777 *
Any thoughts? Thanks
Simon Child
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40735 is a reply to message #40246] |
Thu, 10 April 2008 00:20 |
srchild
Messages: 88 Registered: December 2003 Location: UK
Karma: 1
|
Member |
|
|
I've just reconfirmed.
If I include exec("touch") statements in maillist.php (as described above), then as expected the touched files 1,2,3 are touched (created, or date changed).
The one before maillist.php line:
fud_use('imsg_edt.inc');
does touch the log directory, but the one after, doesn't.
furthermore, if I include touch lines at top and bottom of
FUDforum/include/theme/default/imsg_edt.inc
they do not do anything.
permissions are like this:
777 FUDforum/include/theme/default/imsg_edt.inc
777 FUDforum/include/theme/default
777 FUDforum/include/theme
777 FUDforum/include
777 FUDforum
If there was a problem with accessing the directory FUDforum/include/theme/default/ then why doesn't it fail earlier e.g. the preceding line:
fud_use('imsg.inc');
That is in the same directory!
This seems weird, any thoughts?
This was a straightforward upgrade from 2.6.9.
Thanks
Simon Child
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40736 is a reply to message #40735] |
Thu, 10 April 2008 00:31 |
srchild
Messages: 88 Registered: December 2003 Location: UK
Karma: 1
|
Member |
|
|
I'm using php 4.3.10, in case that is relevant. On FreeBSD 4.8
(I upgraded my forum from 2.6.9 as part of getting ready for a server upgrade to php5/Free BSD 6.2)
BTW, at what version does fudforum start to support php5, I have a couple of other smaller forums that are more recent and may not need upgrading?
Thanks
Simon Child
|
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40764 is a reply to message #40763] |
Thu, 10 April 2008 22:33 |
srchild
Messages: 88 Registered: December 2003 Location: UK
Karma: 1
|
Member |
|
|
Ilia wrote on Thu, 10 April 2008 23:20 | PHP5 is supported since 2.6.0 or so.
|
Thanks (so I didn't need to upgrade!)
Quote: | Have you tried running the maillist import via strace to see where it errors out?
|
I haven't, but shall try that. What is the best way to feed an appropriate input to maillist to test this? Currently I am piping a genuine email to it via procmail, is there a better way to do this for testing purposes?
Simon Child
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40765 is a reply to message #40764] |
Thu, 10 April 2008 23:06 |
srchild
Messages: 88 Registered: December 2003 Location: UK
Karma: 1
|
Member |
|
|
Ahah!
If I simply run:
maillist.php 8
I get:
Fatal error: Cannot redeclare poll_cache_rebuild() (previously declared in /path/to/FUDforum/include/theme/default/imsg.inc:25) in /path/to/FUDforum/include/theme/default/imsg_edt.inc on line 742
Indeed both do declare function poll_cache_rebuild()
The obvious solution is to delete one of these, but which one, they are different?
Simon Child
|
|
|
Re: Email stopped working after running upgrade to 2.7.7 [message #40766 is a reply to message #40765] |
Thu, 10 April 2008 23:57 |
srchild
Messages: 88 Registered: December 2003 Location: UK
Karma: 1
|
Member |
|
|
srchild wrote on Fri, 11 April 2008 00:06 | Ahah!
Fatal error: Cannot redeclare poll_cache_rebuild() (previously declared in /path/to/FUDforum/include/theme/default/imsg.inc:25) in /path/to/FUDforum/include/theme/default/imsg_edt.inc on line 742
Indeed both do declare function poll_cache_rebuild()
The obvious solution is to delete one of these, but which one, they are different?
|
Well I commented out the function definition in FUDforum/include/theme/default/imsg.inc and it seems to work fine. Is this all I need to do (and also update the .src file)?
Simon Child
|
|
|
|