SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to index page
Thread view  Board view
hartundweich(R)

Homepage

Austria,
02.04.2016, 16:43
 

Apache 2.4 and latex / PDF Output (General)

Hello,

I'm using SQL Ledger since 2008 as we started our company. We are an Austrian company and so we have to deal with some special Characters like "ö ä ü" - until last week everything worked perfect with SQL Ledger 3.0.5. Last week we upgraded apache from 2.2 to 2.4 - in the vhost.conf we added "AddDefaultCharset On" so that we can see this special Characters in the webgui of SQL Ledger - but when we print an invoice to PDF these special characters are gone - instead of them nothing is printed.
Database is UTF8 encoded - on PHPPGADMIN everything shows as it is supposed to do. Only PDF output seems to be broken.

If we change the tex template header from "\usepackage[utf8]{inputenc}" to "\usepackage[latin1]{inputenc}" the special characters are displayed correct, but the fixed text of the template gets destroyed.

How can we correct this behaviour? We do not want to convert all Latex templates to latin1 as we want to do our work in UTF8.

Any tip or trick? At the moment I'm a bit confused, beccause database is UTF8 and Latex PDF output will work with latin1...

Maybe an update to SQL Ledger 3.2.0 can solve this problem?

By the way: our fixed texts with special characters in the webfrontend are also a problem since upgrading apache from 2.2 to 2.4 - maybe SQL Ledger 3.2.0 will fix this also?

Thank you for answering this post and I have to say: SQL Ledger is really great work.

Andreas

Dieter Simader(R)

02.04.2016, 19:20

@ hartundweich
 

Apache 2.4 and latex / PDF Output

» Hello,
»
» I'm using SQL Ledger since 2008 as we started our company. We are an
» Austrian company and so we have to deal with some special Characters like
» "ö ä ü" - until last week everything worked perfect with SQL Ledger 3.0.5.
» Last week we upgraded apache from 2.2 to 2.4 - in the vhost.conf we added
» "AddDefaultCharset On" so that we can see this special Characters in the
» webgui of SQL Ledger - but when we print an invoice to PDF these special
» characters are gone - instead of them nothing is printed.
» Database is UTF8 encoded - on PHPPGADMIN everything shows as it is supposed
» to do. Only PDF output seems to be broken.
»
» If we change the tex template header from "\usepackage[utf8]{inputenc}" to
» "\usepackage[latin1]{inputenc}" the special characters are displayed
» correct, but the fixed text of the template gets destroyed.
»
» How can we correct this behaviour? We do not want to convert all Latex
» templates to latin1 as we want to do our work in UTF8.
»
» Any tip or trick? At the moment I'm a bit confused, beccause database is
» UTF8 and Latex PDF output will work with latin1...
»
» Maybe an update to SQL Ledger 3.2.0 can solve this problem?
»
» By the way: our fixed texts with special characters in the webfrontend are
» also a problem since upgrading apache from 2.2 to 2.4 - maybe SQL Ledger
» 3.2.0 will fix this also?
»
» Thank you for answering this post and I have to say: SQL Ledger is really
» great work.
»
» Andreas

use xelatex instead of pdflatex

Edit Form.pm and change

system("pdflatex --interaction=nonstopmode $self->{tmpfile} > $self->{errfile}");

to

system("xelatex --interaction=nonstopmode $self->{tmpfile} > $self->{errfile}");

hartundweich(R)

Homepage

Austria,
03.04.2016, 08:25

@ Dieter Simader
 

Apache 2.4 and latex / PDF Output

Thank you for your advice - I changed the line like you told me to do - now all special german characters are gone in the resulting pdf - even the special characters in the fixtext of invoice.tex
It does not matter if I change "\usepackage[utf8]{inputenc}" to "\usepackage[latin1]{inputenc}" - special characters are not shown.

Any tips or hints?

Maybe update to 3.2.0 will solve my problem? Or is there something I have to take care of in my latex installation?

Thank you very much for your time you are spending in helping us to solve this issue.

We do not want to change back to apache 2.2 and we do not want to leave UTF8.

Kind regards,

Andreas Fragner

hartundweich(R)

Homepage

Austria,
03.04.2016, 10:47

@ hartundweich
 

Apache 2.4 and latex / PDF Output

upgraded to 3.2.0 ---> works as expected even with pdflatex in Form.pm

BUT: no special german characters are not working in webfrontend...

eg. stöttinger is presented as stöttinger

Any suggestions? Also month names in dropdown boxes have this "special feature"...

hartundweich(R)

Homepage

Austria,
03.04.2016, 11:07

@ hartundweich
 

Apache 2.4 and latex / PDF Output

Solved it by myself - removed "AddDefaultCharset on" from Apache vhost configuration - now everything works as expected...

localguru(R)

E-mail

Germany,
03.04.2016, 14:19

@ hartundweich
 

Apache 2.4 and latex / PDF Output

» Solved it by myself - removed "AddDefaultCharset on" from Apache vhost
» configuration - now everything works as expected...

That's what I did too. German umlauts are fine since then (Apache 2.4.7 and 3.2.0 on Ubuntu 14.04 LTS). My Apache config looks like this:

AddHandler cgi-script .pl
# deaktiviert, sonst Umlaute im Webinterface zerschossen
###AddDefaultCharset On

Alias /sql-ledger /opt/sql-ledger/

<Directory /opt/sql-ledger>
Options +ExecCGI +Includes +FollowSymlinks -Indexes
</Directory>

<Directory /opt/sql-ledger/>
AllowOverride All
Require all granted
</Directory>

<Directory /opt/sql-ledger/users/>
Require all denied
</Directory>

Ciao!

Back to index page
Thread view  Board view
964 Postings in 318 Threads, 322 registered users, 165 users online (0 registered, 165 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum