[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Trouble with recurring invoices and email



I did some more poking around with regard to this path.  I know looking
at an old sql-ledger install and comparing it to a new lsmb install is
far from definitive, but...

I got to comparing the whole bin/mozilla directory against the bin
directory in new lsmb.  They look pretty close...

so I made a symlink in new lsmb: bin/mozilla -> bin.  

We did another scheduled invoices run today, but we did not get the bcc
and the invoice did not send.  Unfortunately, I wasnt' around to tail
the logs and check things over at the time, but the same error message
spit out to the screen as happened before.  

So my symlink idea didn't work, but seems like it should have, so maybe
I just don't have the path thing figured out quite right yet.  I guess
some more experimentation is in order...

I also searched through all the code for bin/mozilla, and it shows up in
quite a few places, so given that there is no mozilla file/directory, I
suspect this is not the last time we will see this issue.  But since my
symlink thing didn't work, I am not eager to make changes to the code
when I clearly don't have a good handle on what exactly I should be
changing it too.

We have another scheduled invoice to send out in a day or two, will post
back if I find anything useful...



-- 
Computerisms
Bob Miller      
867-334-7117 / 867-633-3760
http://computerisms.ca


On Tue, 2013-07-30 at 23:18 +0200, Erik Huelsmann wrote:
> Hi Bob,
> 
> 
> Added this to ticket #873. Thanks for researching!
> 
> 
> 
> 
> On Tue, Jul 30, 2013 at 7:08 PM, Bob Miller <..hidden..>
> wrote:
>         Greetings,
>         
>         We just did our scheduled invoices run.  This time we set
>         ourselves up
>         to be BCC'd.  Unfortunately, we never received the invoices.
>         
>         I tcpdump'd the lo interface on port 25, and tailed apache
>         access log,
>         apache error log, exim log, and syslog.  Apache error log
>         showed nothing
>         interesting, all debug info is related to SSL, the access log
>         showed
>         that the page loaded when we did the transactions.  Exim log
>         shows no
>         connections, and the tcpdump shows no traffic on port 25.
>          syslog
>         reports no activity at all.
>         
>         So what ever the problem is, it seems that the recurring
>         transactions
>         are not attempting to mail out through smtp...
>         
>         The following errors came up on the screen immediately after
>         the run:
>         
>         Posting Sales Invoice 3180 ..... done
>         Sending Invoice 3180Location:
>         is.pl?action=reprint&module=ar&type=invoice&login=linda&path=bin/mozilla&sessionid=&id=357&formname=invoice&format=pdf&media=email&vc=customer&ARAP=AR&message= Content-type: text/html ..... done
>         Posting Sales Invoice 3181 ..... done
>         Sending Invoice 3181Location:
>         is.pl?action=reprint&module=ar&type=invoice&login=linda&path=bin/mozilla&sessionid=&id=358&formname=invoice&format=pdf&media=email&vc=customer&ARAP=AR&message= Content-type: text/html ..... doneLocation: am.pl?action=recurring_transactions&path=bin/mozilla&login=linda&sessionid=&header=1 Content-type: text/html
>         
>         I find myself agreeing with Bill that this problem seems
>         related to the
>         path argument.  It is really the only discrepancy that shows
>         up.  There
>         is indeed no bin/mozilla anywhere on this machine.  By mere
>         happenstance, I happen to have a very old box temporarily back
>         on my
>         network from when I first opened my business, it has
>         sql-ledger on it,
>         and it has a bin/mozilla (and a bin/lynx) within its directory
>         structure.
>         
>         So perhaps bin/mozilla was removed and the code for recurring
>         transactions was not updated to reflect that?
>         
>         As per before, the invoices were created, and we were able to
>         re-send
>         them by email after.
>         
>         If there is anything else I can add to be helpful, or anything
>         I can do
>         to assist with testing a fix, please let me know
>         
>         
>         --
>         Computerisms
>         Bob Miller
>         867-334-7117 / 867-633-3760
>         http://computerisms.ca
>         
>         
>         
>         On Thu, 2013-07-25 at 11:29 +0200, Erik Huelsmann wrote:
>         > Hi all,
>         >
>         > On Thu, Jul 25, 2013 at 7:05 AM, Bob Miller
>         <..hidden..>
>         > wrote:
>         >         We noticed this recently too, chasing down bills
>         that hadn't
>         >         been paid
>         >         yet we discovered people haven't been receiving
>         their emailed
>         >         recurring
>         >         transactions.  Normal invoices send through mail
>         just fine.
>         >
>         >         It also turns out we can find the transactions and
>         resend
>         >         them, so the
>         >         only part of it that isn't working is the emailing
>         (as far as
>         >         I can tell
>         >         right now).
>         >
>         >         I have set the smtp server as 127.0.0.1 in
>         ledgersmb.conf, and
>         >         exim
>         >         listens and obviously works since normal invoicing
>         works.
>         >
>         >         According to my exim logs there was no connection
>         made, so it
>         >         appears
>         >         that it isn't sending via smtp.  I find nothing in
>         the apache
>         >         logs that
>         >         indicates any clues.  As best as I can tell, the box
>         is doing
>         >         what it
>         >         thinks it should be doing.
>         >
>         >         Our next scheduled run of recurring transactions is
>         in another
>         >         week, so
>         >         I was planning on turning up the debugging and
>         taking a closer
>         >         look at
>         >         it during that run.
>         >
>         > Thanks for reporting! I've
>         > created https://sourceforge.net/p/ledger-smb/bugs/873/ to
>         track this
>         > issue. If you have any findings next week, please don't
>         hesitate to
>         > mail them or add them to the ticket.
>         >
>         >
>         > --
>         > Bye,
>         >
>         >
>         > Erik.
>         >
>         >
>         > http://efficito.com -- Hosted accounting and ERP.
>         > Robust and Flexible. No vendor lock-in.
>         
>         >
>         ------------------------------------------------------------------------------
>         > See everything from the browser to the database with
>         AppDynamics
>         > Get end-to-end visibility with application monitoring from
>         AppDynamics
>         > Isolate bottlenecks and diagnose root cause in seconds.
>         > Start your free trial of AppDynamics Pro today!
>         >
>         http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
>         > _______________________________________________
>         Ledger-smb-users mailing list
>         ..hidden..
>         https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>         
>         
>         ------------------------------------------------------------------------------
>         
>         Get your SQL database under version control now!
>         Version control is standard for application code, but
>         databases havent
>         caught up. So what steps can you take to put your SQL
>         databases under
>         version control? Why should you start doing it? Read more to
>         find out.
>         http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
>         _______________________________________________
>         Ledger-smb-users mailing list
>         ..hidden..
>         https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>         
> 
> 
> 
> 
> -- 
> Bye,
> 
> 
> Erik.
> 
> 
> http://efficito.com -- Hosted accounting and ERP.
> Robust and Flexible. No vendor lock-in.
> ------------------------------------------------------------------------------
> Get your SQL database under version control now!
> Version control is standard for application code, but databases havent 
> caught up. So what steps can you take to put your SQL databases under 
> version control? Why should you start doing it? Read more to find out.
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> _______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent 
caught up. So what steps can you take to put your SQL databases under 
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users