Menu
▾
▴
sql-ledger-users
|
From: RYAN M. v. G. <lu...@co...> - 2006-10-22 04:06:21
|
Hello again thank you for your reply i played around with nullmailer and could not get it to work. Decieded to fix my postfix install and have it working now, however can not get SL to send mail. When I try to send an invoce using SL i get no confirmation from SL that anything got send and nothing in my sendmail logs. This is was appears in my /usr/local/sql-ledger.conf about email. # location of sendmail $sendmail = "| /usr/sbin/sendmail -t"; Is this correct for FreeBSD using Postfix? because nothing seems to happen ----- P.V.Anthony <an...@so...> wrote: > On this day, 20-October-2006 9:06 AM, RYAN M. vAN GINNEKEN wrote: > > Hello all I am very new to sql-ledger have installed it on a Freebsd > Box. My problem is with email this machine has a very broken version > of postfix on it that seems to be spamming poeple. Therefor i have > turned it off and do not use the email server on this machine anymore. > > > > > Is there a way to send email using a remote machine? As i have other > email servers that work well. They are TLS/SSL based servers and > require username and password authentication is this possible with > sql-ledger or would it be easier to try and fix my broken postfix? > > > > Installing nullmailer may solve the problem. > > http://untroubled.org/nullmailer/ > > nullmailer > Simple relay-only mail transport agent > Bruce Guenter <br...@un...> > Version 1.03 > 2006-06-29 > > This is nullmailer, a sendmail/qmail/etc replacement MTA for hosts > which > relay to a fixed set of smart relays. It is designed to be simple to > configure, secure, and easily extendable. > > P.V.Anthony > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users -- Computer King/CaNMail http://www.computerking.ca http://www.canmail.org Sales, Service, and Hosting Email, Data, and Web Packages Ask about web design specials Affiliates http://www.computerking.ca/pages/links/affiliates/affiliates.htm Maybe Computer Science should be in the College of Theology. -- R. S. Barton |
|
From: RYAN M. v. G. <lu...@co...> - 2006-10-22 20:51:26
|
Oct 22 14:25:23 tokyo postfix/pickup[47130]: CCEEC6C25F: uid=0 from=<root> Oct 22 14:25:23 tokyo postfix/cleanup[47388]: CCEEC6C25F: message-id=<200...@ma...> Oct 22 14:25:23 tokyo postfix/qmgr[39805]: CCEEC6C25F: from=<ro...@co...>, size=506, nrcpt=1 (queue active) Oct 22 14:25:24 tokyo postfix/smtp[47389]: CCEEC6C25F: to=<van...@ya...>, relay=mx2.mail.yahoo.com[4.79.181.136]:25, delay=0.69, delays=0.02/0/0.34/0.33, dsn=2.0.0, status=sent (250 ok dirdel) Oct 22 14:25:24 tokyo postfix/qmgr[39805]: CCEEC6C25F: removed ----- Stroller <lin...@my...> wrote: > On 22 Oct 2006, at 04:54, RYAN M. vAN GINNEKEN wrote: > > ...When I try to send an invoce using SL i get no confirmation from > > > SL that anything got send and nothing in my sendmail logs. > > I've only tried sending invoices by email a couple of times so far > (I'm about to set up the correct template layout for my invoices & > then it'll be full-steam ahead), but SL seems to give no confirmation > > - it only adds a general note to the invoice to the effect of "sent > at 22/10/2006". > > > This is was appears in my /usr/local/sql-ledger.conf about email. > > > > # location of sendmail > > $sendmail = "| /usr/sbin/sendmail -t"; > > > > Is this correct for FreeBSD using Postfix? because nothing seems to > > > happen > > This is correct under on my Linux install for Postifx - the -t flag > is required to "extract recipients from message headers". > > What happens when you type at the command line `cat some_file.txt | / > > usr/sbin/sendmail -t yo...@yo...p`? (without the quotes) #cat ghost.bat | /usr/sbin/sendmail -t van...@ya... seems to work hits the postfix log like this and get an email in my yahoo inbox Oct 22 14:25:23 tokyo postfix/pickup[47130]: CCEEC6C25F: uid=0 from=<root> Oct 22 14:25:23 tokyo postfix/cleanup[47388]: CCEEC6C25F: message-id=<200...@ma...> Oct 22 14:25:23 tokyo postfix/qmgr[39805]: CCEEC6C25F: from=<ro...@co...>, size=506, nrcpt=1 (queue active) Oct 22 14:25:24 tokyo postfix/smtp[47389]: CCEEC6C25F: to=<van...@ya...>, relay=mx2.mail.yahoo.com[4.79.181.136]:25, delay=0.69, delays=0.02/0/0.34/0.33, dsn=2.0.0, status=sent (250 ok dirdel) Oct 22 14:25:24 tokyo postfix/qmgr[39805]: CCEEC6C25F: removed > What happens when you `echo yo...@yo...p > foo && cat foo > some_file.txt | /usr/sbin/sendmail -t`? (again without the quotes) echo van...@ya... > foo && cat foo ghost.bat | /usr/sbin/sendmail -t sendmail: fatal: No recipient addresses found in message header here is the postfix log is this supposed to happen? Also i get no email Oct 22 14:30:03 tokyo postfix/sendmail[47523]: fatal: No recipient addresses found in message header Oct 22 14:30:35 tokyo postfix/sendmail[47536]: fatal: No recipient addresses found in message header > > If the messages are not delivered then this is a postfix problem, not > > one with SQL-Ledger. > > Check `postqueue -p` immediately after sending, or have `watch -n 0.5 > > postqueue -p` running in another terminal. > > Stroller. > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users -- Computer King/CaNMail http://www.computerking.ca http://www.canmail.org Sales, Service, and Hosting Email, Data, and Web Packages Ask about web design specials Affiliates http://www.computerking.ca/pages/links/affiliates/affiliates.htm Maybe Computer Science should be in the College of Theology. -- R. S. Barton |
|
From: Stroller <lin...@my...> - 2006-10-23 00:58:02
|
On 22 Oct 2006, at 21:39, RYAN M. vAN GINNEKEN wrote: >> >> What happens when you `echo yo...@yo...p > foo && cat foo >> some_file.txt | /usr/sbin/sendmail -t`? (again without the quotes) > > > echo van...@ya... > foo && cat foo ghost.bat | /usr/sbin/ > sendmail -t > sendmail: fatal: No recipient addresses found in message header > > here is the postfix log is this supposed to happen? Also i get no > email > Oct 22 14:30:03 tokyo postfix/sendmail[47523]: fatal: No recipient > addresses found in message header > Oct 22 14:30:35 tokyo postfix/sendmail[47536]: fatal: No recipient > addresses found in message header My bad. That should have read: echo To: yo...@yo...p > foo && cat foo some_file.txt | /usr/sbin/ sendmail -t Glad you're now sorted. Stroller |
|
From: RYAN M. v. G. <lu...@co...> - 2006-10-22 22:30:27
|
Strange email seems to work great now, however only with html I would like to use PDF. When i try i get a big red error nothing in my /var/log/messages where does sql-ledger do it's logging? ps I think i am in love with SL Thanks - |
|
From: Stroller <lin...@my...> - 2006-10-23 01:06:08
|
On 22 Oct 2006, at 23:18, RYAN M. vAN GINNEKEN wrote: > Strange email seems to work great now, however only with html I > would like to use PDF. http://www.sql-ledger.org/cgi-bin/nav.pl?page=misc/faq.html&title=FAQ PDF option not working Check if you have latex and pdflatex installed. You also have to ensure that $latex = 1 in /usr/local/sql-ledger/sql- ledger.conf Email via PDF works very much out of the box for me - it's the learning of LaTeX in order to customise my invoice design that is keeping me up at 2am!! HTH, Stroller. |
|
From: RYAN M. v. G. <lu...@co...> - 2006-10-23 02:09:20
|
Thanks agian for your reply now that i have email working i am stumped on the logo thing. I have added my logo to /usr/local/sql-ledger directory it has the following perms and onwerships.
-rwxrwxrwx 1 www www 2425 Oct 22 18:46 logo.png
It shows up when i edit my letterhead.html but when i send an email it is not there just the border I added and one of those browser palace holder thingys.
Have this in my letterhead.html what am i doing wrong?
<td>
<h4>
<%company%><br>
<%address%>
</h4>
</td>
<th><img src=logo.png border=1 width=105 height=47></th>
<td align=right>
<h4>
Tel: <%tel%><br>
Fax: <%fax%>
</h4>
</td>
</tr>
----- Stroller <linux.luser@myrea
lbox.com> wrote:
> On 22 Oct 2006, at 21:39, RYAN M. vAN GINNEKEN wrote:
> >>
> >> What happens when you `echo yo...@yo...p > foo && cat foo
> >> some_file.txt | /usr/sbin/sendmail -t`? (again without the quotes)
> >
> >
> > echo van...@ya... > foo && cat foo ghost.bat | /usr/sbin/
>
> > sendmail -t
> > sendmail: fatal: No recipient addresses found in message header
> >
> > here is the postfix log is this supposed to happen? Also i get no
> > email
> > Oct 22 14:30:03 tokyo postfix/sendmail[47523]: fatal: No recipient
>
> > addresses found in message header
> > Oct 22 14:30:35 tokyo postfix/sendmail[47536]: fatal: No recipient
>
> > addresses found in message header
>
> My bad. That should have read:
> echo To: yo...@yo...p > foo && cat foo some_file.txt | /usr/sbin/
> sendmail -t
>
> Glad you're now sorted.
>
> Stroller
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
--
Computer King/CaNMail
http://www.computerking.ca http://www.canmail.org
Sales, Service, and Hosting
Email, Data, and Web Packages
Ask about web design specials
Affiliates
http://www.computerking.ca/pages/links/affiliates/affiliates.htm
Maybe Computer Science should be in the College of Theology. -- R. S. Barton
|
|
From: Stroller <lin...@my...> - 2006-10-23 11:21:15
|
On 23 Oct 2006, at 02:57, RYAN M. vAN GINNEKEN wrote: > ... > It shows up when i edit my letterhead.html but when i send an email > it is not there just the border I added and one of those browser > palace holder thingys. > > Have this in my letterhead.html what am i doing wrong? What format are you sending the invoice in? There's a drop-down on the email page, the page where you type the email subject & body, to choose html, postscript or pdf. The layout for PDF is controlled by invoice.tex Stroller |
|
From: Stroller <lin...@my...> - 2006-10-25 12:50:47
|
On 23 Oct 2006, at 02:57, RYAN M. vAN GINNEKEN wrote:
> Thanks agian for your reply now that i have email working i am
> stumped on the logo thing. I have added my logo to /usr/local/sql-
> ledger directory it has the following perms and onwerships.
>
> -rwxrwxrwx 1 www www 2425 Oct 22 18:46 logo.png
>
> It shows up when i edit my letterhead.html but when i send an email
> it is not there just the border I added and one of those browser
> palace holder thingys.
I seem to have just experienced the same thing, but using my logo in
invoice.tex
I had honestly disregarded Mr Van Ginneken's problem as "existing
between keyboard & chair" however the problem seems to have
inexplicably resolved itself for me, and I can only conclude that
something glitchy may sometimes occur with the logo.
I have spent some time this morning paying attention to the full
format of the .png file - for instance note that:
$ file /usr/local/sql-ledger/templates/Service-logo.png
/usr/local/sql-ledger/templates/Service-logo.png: PNG image data,
220 x 138, 8-bit colormap, non-interlaced
$ convert my_logo.eps foo.png
$ file foo.png
foo.png: PNG image data, 584 x 576, 16-bit/color RGB, non-interlaced
$ convert my_logo.eps -depth 8 foo.png
$ file foo.png
foo.png: PNG image data, 584 x 576, 8-bit/color RGB, non-interlaced
$
However in frustration I copied back the original logo and it STILL!
didn't work!!?! After making trivial edits in my invoice.tex the logo
reappeared, only to remain there when I reverted those very same edits!!
When I copied back my_logo.png, suddenly it worked perfectly!!
So I am completely unable to explain why the image didn't work in the
first place.
My permissions are the same as Ryan's, and I have changed them at no
time.
I can't believe I have made some stupid mistake - even though that's
the only logical explanation! - because I used my bash history to go
back to the same `cp working.png /usr/local/sql-ledger/templates/
stroller/logo.png` each time. Likewise, I used up-arrow in bash to
edit the `convert` command (ImageMagick), then `file` & `identify` to
check the file format.
So my only suggestion to someone else experiencing this is to copy
the original logo back and then try again from scratch. Maybe there's
something in the email generation process that caches the logo?
Stroller.
|
|
From: RYAN M. v. G. <lu...@co...> - 2006-10-23 13:00:39
|
----- Stroller <lin...@my...> wrote: > On 23 Oct 2006, at 02:57, RYAN M. vAN GINNEKEN wrote: > > ... > > It shows up when i edit my letterhead.html but when i send an email > > > it is not there just the border I added and one of those browser > > palace holder thingys. > > > > Have this in my letterhead.html what am i doing wrong? > > What format are you sending the invoice in? There's a drop-down on > the email page, the page where you type the email subject & body, to > > choose html, postscript or pdf. The layout for PDF is controlled by > invoice.tex I am using html format because i cannot get PDF to work at all just gives me a big red error. I am editing the letterhead.html file which by the look of it is included in several other html templates ie quotos and sales invoice. > > Stroller > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users -- Computer King/CaNMail http://www.computerking.ca http://www.canmail.org Sales, Service, and Hosting Email, Data, and Web Packages Ask about web design specials Affiliates http://www.computerking.ca/pages/links/affiliates/affiliates.htm Maybe Computer Science should be in the College of Theology. -- R. S. Barton |
|
From: RYAN M. v. G. <lu...@co...> - 2006-10-25 23:50:14
|
----- Stroller <lin...@my...> wrote: > On 23 Oct 2006, at 02:57, RYAN M. vAN GINNEKEN wrote: > > > Thanks agian for your reply now that i have email working i am > > stumped on the logo thing. I have added my logo to /usr/local/sql- > > > ledger directory it has the following perms and onwerships. > > > > -rwxrwxrwx 1 www www 2425 Oct 22 18:46 logo.png > > > > It shows up when i edit my letterhead.html but when i send an email > > > it is not there just the border I added and one of those browser > > palace holder thingys. > > I seem to have just experienced the same thing, but using my logo in > > invoice.tex > > I had honestly disregarded Mr Van Ginneken's problem as "existing > between keyboard & chair" however the problem seems to have > inexplicably resolved itself for me, and I can only conclude that > something glitchy may sometimes occur with the logo. Thank for the Vote of confidence hehe as i must admit most of my errors are usually related to something between the chair and the keyboard. > > I have spent some time this morning paying attention to the full > format of the .png file - for instance note that: > $ file /usr/local/sql-ledger/templates/Service-logo.png > /usr/local/sql-ledger/templates/Service-logo.png: PNG image data, > > 220 x 138, 8-bit colormap, non-interlaced > $ convert my_logo.eps foo.png > $ file foo.png > foo.png: PNG image data, 584 x 576, 16-bit/color RGB, > non-interlaced > $ convert my_logo.eps -depth 8 foo.png > $ file foo.png > foo.png: PNG image data, 584 x 576, 8-bit/color RGB, > non-interlaced > $ > > However in frustration I copied back the original logo and it STILL! > > didn't work!!?! After making trivial edits in my invoice.tex the logo > > reappeared, only to remain there when I reverted those very same > edits!! > > When I copied back my_logo.png, suddenly it worked perfectly!! > So I am completely unable to explain why the image didn't work in the > > first place. > > My permissions are the same as Ryan's, and I have changed them at no > > time. > I can't believe I have made some stupid mistake - even though that's > > the only logical explanation! - because I used my bash history to go > > back to the same `cp working.png /usr/local/sql-ledger/templates/ > stroller/logo.png` each time. Likewise, I used up-arrow in bash to > edit the `convert` command (ImageMagick), then `file` & `identify` to > > check the file format. > > So my only suggestion to someone else experiencing this is to copy > the original logo back and then try again from scratch. Maybe there's > > something in the email generation process that caches the logo? I have try ed this and it did not work for me however i will try it again and again just to make sure. I will post back to this list with my results in the next few days as i am very busy for the next while. > > Stroller. > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > sql-ledger-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users -- Computer King/CaNMail http://www.computerking.ca http://www.canmail.org Sales, Service, and Hosting Email, Data, and Web Packages Ask about web design specials Affiliates http://www.computerking.ca/pages/links/affiliates/affiliates.htm Maybe Computer Science should be in the College of Theology. -- R. S. Barton |
|
From: Stroller <lin...@my...> - 2006-10-22 19:17:08
|
On 22 Oct 2006, at 04:54, RYAN M. vAN GINNEKEN wrote: > ...When I try to send an invoce using SL i get no confirmation from > SL that anything got send and nothing in my sendmail logs. I've only tried sending invoices by email a couple of times so far (I'm about to set up the correct template layout for my invoices & then it'll be full-steam ahead), but SL seems to give no confirmation - it only adds a general note to the invoice to the effect of "sent at 22/10/2006". > This is was appears in my /usr/local/sql-ledger.conf about email. > > # location of sendmail > $sendmail = "| /usr/sbin/sendmail -t"; > > Is this correct for FreeBSD using Postfix? because nothing seems to > happen This is correct under on my Linux install for Postifx - the -t flag is required to "extract recipients from message headers". What happens when you type at the command line `cat some_file.txt | / usr/sbin/sendmail -t yo...@yo...p`? (without the quotes) What happens when you `echo yo...@yo...p > foo && cat foo some_file.txt | /usr/sbin/sendmail -t`? (again without the quotes) If the messages are not delivered then this is a postfix problem, not one with SQL-Ledger. Check `postqueue -p` immediately after sending, or have `watch -n 0.5 postqueue -p` running in another terminal. Stroller. |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X