Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

cron pulls mail but MySQL stopped updating

Quote Reply
cron pulls mail but MySQL stopped updating
Very odd... servers changed..site was updated. Cron jobs changed to access new mailboxes (for mailarc) no cgi errors in logs from cron jobs. Mail DOES get pulled from the mailbox, but the SQL db (hence the Forum) is not being updated with the new messages.

So what do I need to look at? Paths all appear to be correct (on the sites admin setup and via gforum admin) Sending test emails to the mailbox do show it to be a working box... and they dissappear right around the clock time the cron job is suppose to run. But the forum is not getting updated. I tried a re-sync of the db but nadda, nothing zip.

I've now lost rouhgly a weeks worth of email archiving and can not sem to figure out what you'd think would be a straightforward path issue.

Any ideas? getting VERY desperate here. I'd hate to say..frustrated to the point of moving to another forums package. :-(

HELP!
Quote Reply
Re: [ptegler] cron pulls mail but MySQL stopped updating In reply to
Have you tried running the script manually with debug on to see what's going on?

Adrian
Quote Reply
Re: [brewt] cron pulls mail but MySQL stopped updating In reply to
I have a page full of cgi errors you could review as to past possible problems... but after the last few edits... the script error buffer has not shown any error as far as the cgi stuff is concerned. (I cleared the buffer after this page info grab)

Maybe you can spot something that was going on...please take a look at
http://www.nasshq.org/gforum_errors.html

The last four errors shown were after I changed the cron job script around to a bit. Really... the bulk of those errors were showing up before I realized there were problems. The last 1/5th of the page or so was while I was working at trying fixing stuff

If you can spot a trend...or something that one of the GT statements 'was' doing...PLEASE let me know and give me some ideas of what to look at.

tia
Quote Reply
Re: [ptegler] cron pulls mail but MySQL stopped updating In reply to
That just looks like your error log (which you probably should fix your mail sending error). You need to run the archive.pl command that your cronjob is running and look for errors that it outputs.

Adrian
Quote Reply
Re: [brewt] cron pulls mail but MySQL stopped updating In reply to
...best I could do was to run fileman and cut and past in the script.....
results=

Plugins/GForum/archive.pl --forum=1 --pop-host=pop.powweb.com --pop-user=nassforum --pop-pass=pownasshqpat1 sh: Plugins/GForum/archive.pl: /usr/bin/perl: bad interpreter: Permission denied

the perl path looks correct.
Is there a perl function needed that IS NOT in the following list? (taken from the isps FAQ)

AnyDBM_File.pm
Archive/Tar.pm
attributes.pm
attrs.pm
AutoLoader.pm
AutoSplit.pm
autouse.pm
base.pm
Benchmark.pm
blib.pm
bytes.pm
Carp/Heavy.pm
Carp.pm
CGI/Apache.pm
CGI/Carp.pm
CGI/Cookie.pm
CGI/Fast.pm
CGI.pm
CGI/Pretty.pm
CGI/Push.pm
CGI/Switch.pm
CGI/Util.pm
charnames.pm
Class/Struct.pm
Compress/Zlib.pm
Config.pm
constant.pm
CPAN/Admin.pm
CPAN/Config.pm
CPAN/FirstTime.pm
CPAN/Nox.pm
CPAN.pm
CPAN/WAIT.pm
Crypt/Blowfish.pm
Crypt/CBC.pm
Crypt/DES.pm
Crypt/SSLeay/Conn.pm
Crypt/SSLeay/CTX.pm
Crypt/SSLeay/Err.pm
Crypt/SSLeay/MainContext.pm
Crypt/SSLeay.pm
Crypt/SSLeay/X509.pm
Cwd.pm
Data/Dumper.pm
Data/Grove/Parent.pm
Data/Grove.pm
Data/Grove/Visitor.pm
Data/ShowTable.pm
Date/Calc.pm
Date/Format.pm
Date/Language/Austrian.pm
Date/Language/Czech.pm
Date/Language/Dutch.pm
Date/Language/English.pm
Date/Language/French.pm
Date/Language/German.pm
Date/Language/Italian.pm
Date/Language/Norwegian.pm
Date/Language.pm
Date/Manip.pm
Date/Parse.pm
DBD/ExampleP.pm
DBD/mysql.pm
DBD/NullP.pm
DBD/Proxy.pm
DBD/Sponge.pm
DB_File.pm
DBI/DBD.pm
DBI/FAQ.pm
DBI/Format.pm
DBI.pm
DBI/ProxyServer.pm
DBI/Shell.pm
DBI/W32ODBC.pm
DB.pm
Devel/SelfStubber.pm
diagnostics.pm
Digest/HMAC_MD5.pm
Digest/HMAC.pm
Digest/HMAC_SHA1.pm
Digest/MD2.pm
Digest/MD5.pm
Digest/SHA1.pm
DirHandle.pm
Dumpvalue.pm
DynaLoader.pm
English.pm
Env.pm
Errno.pm
Exporter/Heavy.pm
Exporter.pm
ExtUtils/Command.pm
ExtUtils/Embed.pm
ExtUtils/Installed.pm
ExtUtils/Install.pm
ExtUtils/Liblist.pm
ExtUtils/MakeMaker.pm
ExtUtils/Manifest.pm
ExtUtils/Miniperl.pm
ExtUtils/Mkbootstrap.pm
ExtUtils/Mksymlists.pm
ExtUtils/MM_Cygwin.pm
ExtUtils/MM_OS2.pm
ExtUtils/MM_Unix.pm
ExtUtils/MM_VMS.pm
ExtUtils/MM_Win32.pm
ExtUtils/Packlist.pm
ExtUtils/testlib.pm
Fatal.pm
Fcntl.pm
fields.pm
File/Basename.pm
FileCache.pm
File/CheckTree.pm
File/Compare.pm
File/Copy.pm
File/DosGlob.pm
File/Find.pm
File/Glob.pm
FileHandle.pm
File/Listing.pm
File/Path.pm
File/Spec/Functions.pm
File/Spec/Mac.pm
File/Spec/OS2.pm
File/Spec.pm
File/Spec/Unix.pm
File/Spec/VMS.pm
File/Spec/Win32.pm
File/stat.pm
filetest.pm
FindBin.pm
FreezeThaw.pm
GDBM_File.pm
GD.pm
Getopt/Long.pm
Getopt/Std.pm
HTML/Entities.pm
HTML/Filter.pm
HTML/Form.pm
HTML/HeadParser.pm
HTML/LinkExtor.pm
HTML/Parser.pm
HTML/PullParser.pm
HTML/Tagset.pm
HTML/TokeParser.pm
HTTP/Cookies.pm
HTTP/Daemon.pm
HTTP/Date.pm
HTTP/Headers/Auth.pm
HTTP/Headers/ETag.pm
HTTP/Headers.pm
HTTP/Headers/Util.pm
HTTP/Message.pm
HTTP/Negotiate.pm
HTTP/Request/Common.pm
HTTP/Request.pm
HTTP/Response.pm
HTTP/Status.pm
I18N/Collate.pm
Image/Magick.pm
Image/Size.pm
integer.pm
IO/AtomicFile.pm
IO/Dir.pm
IO/File.pm
IO/Handle.pm
IO/InnerFile.pm
IO/Lines.pm
IO/Pipe.pm
IO.pm
IO/Poll.pm
IO/ScalarArray.pm
IO/Scalar.pm
IO/Seekable.pm
IO/Select.pm
IO/Socket/INET.pm
IO/Socket.pm
IO/Socket/UNIX.pm
IO/Stringy.pm
IO/Wrap.pm
IO/WrapTie.pm
IPC/Open2.pm
IPC/Open3.pm
less.pm
lib.pm
locale.pm
LWP/Authen/Basic.pm
LWP/Authen/Digest.pm
LWP/Debug.pm
LWP/MediaTypes.pm
LWP/MemberMixin.pm
LWP/Parallel.pm
LWP/Parallel/Protocol/ftp.pm
LWP/Parallel/Protocol/http.pm
LWP/Parallel/Protocol/https.pm
LWP/Parallel/Protocol.pm
LWP/Parallel/RobotUA.pm
LWP/ParallelUA.pm
LWP/Parallel/UserAgent.pm
LWP.pm
LWP/Protocol/data.pm
LWP/Protocol/file.pm
LWP/Protocol/ftp.pm
LWP/Protocol/GHTTP.pm
LWP/Protocol/gopher.pm
LWP/Protocol/http11.pm
LWP/Protocol/http.pm
LWP/Protocol/https.pm
LWP/Protocol/mailto.pm
LWP/Protocol/nntp.pm
LWP/Protocol.pm
LWP/RobotPUA.pm
LWP/RobotUA.pm
LWP/Simple.pm
LWP/UserAgent.pm
Mail/Address.pm
Mail/Cap.pm
Mail/Field/AddrList.pm
Mail/Field/Date.pm
Mail/Field.pm
Mail/Filter.pm
Mail/Header.pm
Mail/Internet.pm
Mail/Mailer/mail.pm
Mail/Mailer.pm
Mail/Mailer/rfc822.pm
Mail/Mailer/sendmail.pm
Mail/Mailer/smtp.pm
Mail/Mailer/test.pm
Mail/POP3Client.pm
Mail/Sender.pm
Mail/Send.pm
Mail/Util.pm
Math/BigFloat.pm
Math/BigInt.pm
Math/Complex.pm
Math/Trig.pm
MD5.pm
MIME/Base64.pm
MIME/Body.pm
MIME/Decoder/Base64.pm
MIME/Decoder/Binary.pm
MIME/Decoder/Gzip64.pm
MIME/Decoder/NBit.pm
MIME/Decoder.pm
MIME/Decoder/QuotedPrint.pm
MIME/Decoder/UU.pm
MIME/Entity.pm
MIME/Field/ContDisp.pm
MIME/Field/ConTraEnc.pm
MIME/Field/ContType.pm
MIME/Field/ParamVal.pm
MIME/Head.pm
MIME/Lite.pm
MIME/Parser/Filer.pm
MIME/Parser.pm
MIME/Parser/Reader.pm
MIME/Parser/Results.pm
MIME/QuotedPrint.pm
MIME/Tools.pm
MIME/WordDecoder.pm
MIME/Words.pm
MLDBM.pm
MLDBM/Serializer/Data/Dumper.pm
MLDBM/Serializer/FreezeThaw.pm
MLDBM/Serializer/Storable.pm
Mysql.pm
Mysql/Statement.pm
NDBM_File.pm
Net/Cmd.pm
Net/Config.pm
Net/DNS/Header.pm
Net/DNS/Packet.pm
Net/DNS.pm
Net/DNS/Question.pm
Net/DNS/Resolver.pm
Net/DNS/RR/AAAA.pm
Net/DNS/RR/AFSDB.pm
Net/DNS/RR/A.pm
Net/DNS/RR/CNAME.pm
Net/DNS/RR/EID.pm
Net/DNS/RR/HINFO.pm
Net/DNS/RR/ISDN.pm
Net/DNS/RR/LOC.pm
Net/DNS/RR/MB.pm
Net/DNS/RR/MG.pm
Net/DNS/RR/MINFO.pm
Net/DNS/RR/MR.pm
Net/DNS/RR/MX.pm
Net/DNS/RR/NAPTR.pm
Net/DNS/RR/NIMLOC.pm
Net/DNS/RR/NSAP.pm
Net/DNS/RR/NS.pm
Net/DNS/RR/NULL.pm
Net/DNS/RR.pm
Net/DNS/RR/PTR.pm
Net/DNS/RR/PX.pm
Net/DNS/RR/RP.pm
Net/DNS/RR/RT.pm
Net/DNS/RR/SOA.pm
Net/DNS/RR/SRV.pm
Net/DNS/RR/TXT.pm
Net/DNS/RR/X25.pm
Net/DNS/Update.pm
Net/Domain.pm
Net/DummyInetd.pm
Net/FTP/A.pm
Net/FTP/dataconn.pm
Net/FTP/E.pm
Net/FTP/I.pm
Net/FTP/L.pm
Net/FTP.pm
Net/hostent.pm
Net/HTTP.pm
Net/netent.pm
Net/Netrc.pm
Net/NNTP.pm
Net/Ping.pm
Net/POP3.pm
Net/protoent.pm
Net/servent.pm
Net/SMTP.pm
Net/SSL.pm
Net/Telnet.pm
Net/Time.pm
Net/Whois.pm
Opcode.pm
open.pm
ops.pm
overload.pm
Parse/Yapp/Driver.pm
Parse/Yapp/Grammar.pm
Parse/Yapp/Lalr.pm
Parse/Yapp/Options.pm
Parse/Yapp/Output.pm
Parse/Yapp/Parse.pm
Parse/Yapp.pm
Pod/Checker.pm
Pod/Find.pm
Pod/Functions.pm
Pod/Html.pm
Pod/InputObjects.pm
Pod/Man.pm
Pod/Parser.pm
Pod/ParseUtils.pm
Pod/Plainer.pm
Pod/Select.pm
Pod/Text/Color.pm
Pod/Text.pm
Pod/Text/Termcap.pm
Pod/Usage.pm
POSIX.pm
re.pm
Safe.pm
SDBM_File.pm
Search/Dict.pm
SelectSaver.pm
SelfLoader.pm
SHA.pm
Shell.pm
sigtrap.pm
Socket.pm
Storable.pm
strict.pm
subs.pm
Symbol.pm
Sys/Hostname.pm
Term/ANSIColor.pm
Term/Cap.pm
Term/Complete.pm
Term/ReadKey.pm
Term/ReadLine/Perl.pm
Term/ReadLine.pm
Term/ReadLine/readline.pm
Test/Harness.pm
Test.pm
Text/Abbrev.pm
Text/ParseWords.pm
Text/Soundex.pm
Text/Tabs.pm
Text/Wrap.pm
Tie/Array.pm
Tie/Handle.pm
Tie/Hash.pm
Tie/IxHash.pm
Tie/RefHash.pm
Tie/Scalar.pm
Tie/SubstrHash.pm
Time/CTime.pm
Time/DaysInMonth.pm
Time/gmtime.pm
Time/HiRes.pm
Time/JulianDay.pm
Time/Local.pm
Time/localtime.pm
Time/ParseDate.pm
Time/Timezone.pm
Time/tm.pm
Time/Zone.pm
UNIVERSAL.pm
URI/data.pm
URI/Escape.pm
URI/file/Base.pm
URI/file/FAT.pm
URI/file/Mac.pm
URI/file/OS2.pm
URI/file.pm
URI/file/QNX.pm
URI/file/Unix.pm
URI/file/Win32.pm
URI/_foreign.pm
URI/ftp.pm
URI/_generic.pm
URI/gopher.pm
URI/Heuristic.pm
URI/http.pm
URI/https.pm
URI/ldap.pm
URI/_login.pm
URI/mailto.pm
URI/news.pm
URI/nntp.pm
URI.pm
URI/pop.pm
URI/_query.pm
URI/rlogin.pm
URI/rsync.pm
URI/_segment.pm
URI/_server.pm
URI/snews.pm
URI/telnet.pm
URI/URL.pm
URI/_userpass.pm
URI/WithBase.pm
User/grent.pm
User/pwent.pm
utf8.pm
vars.pm
WAIT/Client.pm
warnings.pm
warnings/register.pm
Win32/DBIODBC.pm
WWW/RobotRules/AnyDBM_File.pm
WWW/RobotRules.pm
XML/Checker/DOM.pm
XML/Checker/Parser.pm
XML/Checker.pm
XML/DOM/DOMException.pm
XML/DOM/NamedNodeMap.pm
XML/DOM/NodeList.pm
XML/DOM/PerlSAX.pm
XML/DOM.pm
XML/DOM/ValParser.pm
XML/ESISParser.pm
XML/Filter/DetectWS.pm
XML/Filter/Reindent.pm
XML/Filter/SAXT.pm
XML/Handler/BuildDOM.pm
XML/Handler/CanonXMLWriter.pm
XML/Handler/Composer.pm
XML/Handler/PrintEvents.pm
XML/Handler/Sample.pm
XML/Handler/Subs.pm
XML/Handler/XMLWriter.pm
XML/Parser/Expat.pm
XML/Parser/PerlSAX.pm
XML/Parser.pm
XML/PatAct/ActionTempl.pm
XML/PatAct/Amsterdam.pm
XML/PatAct/MatchName.pm
XML/PatAct/PatternTempl.pm
XML/PatAct/ToObjects.pm
XML/Perl2SAX.pm
XML/RegExp.pm
XML/SAX2Perl.pm
XML/UM.pm
XML/XQL/Date.pm
XML/XQL/Debug.pm
XML/XQL/DirXQL.pm
XML/XQL/DOM.pm
XML/XQL/Parser.pm
XML/XQL/Plus.pm
XML/XQL.pm
XML/XQL/Strict.pm
XSLoader.pm