[freeside] Latex printing issues on FreeBSD

[ivan]

On Fri, Apr 01, 2005 at 10:09:54AM -0500, Stephen D. Bechard wrote:
> I have upgrade my 1.4.1 system to 5.1.0pre6 and can not seem to
> get the latex invoices to work. Here is the error I am getting:
> 
> pslatex
> /usr/local/etc/freeside/cache.DBI:Pg:host=localhost;dbname=freeside/invoice.200
> 50549.fJWWNslL.tex failed: No such file or directory at
> /usr/local/lib/perl5/site_perl/5.8.6//FS/cust_bill.pm line 1219. ,
> /usr/local/lib/perl5/site_perl/5.8.6/Apache/ASP.pm line 1518
> 
> 
> I attempted it from the command prompt and found get the same error:
> 
> I think it might be related to the path as on the local system the ; has to
> be escaped, such as \;

Looking at the code it does appear the filenames *are* escaped
properly...

> LaTeX Warning: File `/usr/local/etc/freeside/conf.DBI:Pg:dbname=freeside/logo.eps' not found on input line 164.
> 
> 
> ! LaTeX Error: File `/usr/local/etc/freeside/conf.DBI:Pg:dbname=freeside/logo.eps' not found.

This is the problem, I think.  Edit your "invoice_latex" template file 
and change the 

\includegraphics{/usr/local/etc/freeside/conf.DBI:Pg:dbname=freeside/logo.eps}

line to match the location of your .eps logo.

> I think this could be historical, but should I attempt to change the 
> DB Schema:
> 
> from=>  DBI:Pg:host=localhost;dbname=freeside
> to=>    DBI:Pg:dbname=freeside

Shouldn't be necessary, though you might prefer to connect to the 
database over a UNIX socket rather than TCP/IP to localhost...

-- 
_ivan