関連記事一覧

LibreOfficeでPDF文書を自動生成
https://qiita.com/nanbuwks/items/8ea939ad497fec29c069

LibreOffice で MySQL連動 PDF帳票を作る
https://qiita.com/nanbuwks/items/d4696542760cf4b8a24a

WebアプリでPDF文書を自動生成 on Ubuntu14.04 LTS (この記事)
https://qiita.com/nanbuwks/items/7dbd2a0a79b232f864b4

WebアプリでPDF文書を自動生成 on Ubuntu20.04 LTS
https://qiita.com/nanbuwks/items/f11e4e3aabac33f9a32b

Webサーバ化

「LibreOfficeでPDF文書を自動生成」
http://qiita.com/nanbuwks/items/8ea939ad497fec29c069
で苦労しなくても


$ soffice --headless --convert-to pdf *.ods

だけでpdfコンバートできた件。

Webアプリにこのやりかたを適用してみる。

(2021/03/29追記)
Ubuntu20.04を使い別のやり方で実現した記事を以下に書きました
「WebアプリでPDF文書を自動生成 on Ubuntu20.04 LTS」
https://qiita.com/nanbuwks/items/f11e4e3aabac33f9a32b

環境

Webサーバ環境は、Ubuntu 14.04.3 LTS。
AWSのt2.small で動かしている。
X-windowは動作していない。

LibreOfficeインストール


# apt-get update
# apt-get install LibreOffice
Reading package lists... Done
Building dependency tree       
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 ca-certificates-java : Depends: openjdk-7-jre-headless (>= 7~u3-2.1.1~pre1-1) but it is not going to be installed or
                                 java6-runtime-headless
 libreoffice : Depends: fonts-sil-gentium-basic but it is not going to be installed
               Depends: libreoffice-base but it is not going to be installed
               Depends: libreoffice-calc but it is not going to be installed
               Depends: libreoffice-core (= 1:4.2.8-0ubuntu5.1) but it is not going to be installed
               Depends: libreoffice-draw but it is not going to be installed
               Depends: libreoffice-impress but it is not going to be installed
               Depends: libreoffice-math but it is not going to be installed
               Depends: libreoffice-report-builder-bin but it is not going to be installed
               Depends: libreoffice-writer but it is not going to be installed
               Depends: libreoffice-avmedia-backend-gstreamer but it is not going to be installed
               Depends: fonts-dejavu but it is not going to be installed
               Depends: libreoffice-java-common (>= 1:4.2.8~) but it is not going to be installed
               Depends: python3-uno (>= 4.0~) but it is not going to be installed
               Recommends: fonts-liberation but it is not going to be installed or
                           ttf-mscorefonts-installer but it is not installable
               Recommends: libreoffice-gnome but it is not going to be installed or
                           libreoffice-kde but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
u# apt-get -f install
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Correcting dependencies... Done
The following packages were automatically installed and are no longer required:
・
・
・
u# apt-get install LibreOffice
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are n

インストールできた

Webサーバ実行ユーザでテスト


# su - www-data

実行してみる


$ soffice --headless --convert-to pdf *.ods
[Java framework] Error in function createSettingsDocument (elements.cxx).
javaldx failed!
Warning: failed to read path from javaldx
/usr/lib/libreoffice/program/soffice.bin: error while loading shared libraries: libjpeg.so.8: cannot open shared object file: No such file or directory
$

エラー出た。
これはwww-dataのホームディレクトリに、libreofficeの設定ファイルが書き込めないため。
専用のディレクトリを作ってみる。


html  index.html
root@www:/var/www# mkdir libreoffice
root@www:/var/www# chown -R www-data:www-data libreoffice
root@www:/var/www# su - www-data

改めてwww-dataユーザで



$ soffice --headless --convert-to pdf *.ods
/usr/lib/libreoffice/program/soffice.bin: error while loading shared libraries: libjpeg.so.8: cannot open shared object file: No such file or directory

別のエラー。libjpeg.so.8はどこにあるのかな。調べるためにはapt-fileコマンドが使えるらしい。


# apt-file search libjpeg.so.8
The program 'apt-file' is currently not installed. You can install it by typing:
apt-get install apt-file

インストールしていなかったのでインストール


# apt-get install apt-file
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  gir1.2-gudev-1.0 libfile-copy-recursive-perl libgudev-1.0-0 ttf-dejavu-core
  update-inetd
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  libapt-pkg-perl libconfig-file-perl liblist-moreutils-perl
  libregexp-assemble-perl
The following NEW packages will be installed:
  apt-file libapt-pkg-perl libconfig-file-perl liblist-moreutils-perl
  libregexp-assemble-perl
0 upgraded, 5 newly installed, 0 to remove and 415 not upgraded.
Need to get 253 kB of archives.
After this operation, 870 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
・
・
・

改めて実行すると最初にapt-file update しろと出るのでやっておく

# apt-file search libjpeg.so.8
E: The cache is empty. You need to run 'apt-file update' first.
# apt-file update
Downloading complete file http://us-east-1.ec2.archive.ubuntu.com/ubuntu/dists/trusty/Contents-amd64.gz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 28.0M  100 28.0M    0     0  23.7M      0  0:00:01  0:00:01 --:--:-- 23.7M
Downloading complete file http://us-east-1.ec2.archive.ubuntu.com/ubuntu/dists/trusty-updates/Contents-amd64.gz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 45.3M  100 45.3M    0     0  22.2M      0  0:00:02  0:00:02 --:--:-- 22.2M
Downloading Index http://us-east-1.ec2.archive.ubuntu.com/ubuntu/dists/trusty/Contents-amd64.diff/Index:
No Index available.
Downloading complete file http://us-east-1.ec2.archive.ubuntu.com/ubuntu/dists/trusty/Contents-amd64.gz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0 28.0M    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
File is up-to-date.
Downloading Index http://us-east-1.ec2.archive.ubuntu.com/ubuntu/dists/trusty-updates/Contents-amd64.diff/Index:
No Index available.
Downloading complete file http://us-east-1.ec2.archive.ubuntu.com/ubuntu/dists/trusty-updates/Contents-amd64.gz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0 45.3M    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
File is up-to-date.
Downloading complete file http://security.ubuntu.com/ubuntu/dists/trusty-security/Contents-amd64.gz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 42.1M  100 42.1M    0     0  5316k      0  0:00:08  0:00:08 --:--:-- 5736k
Downloading Index http://security.ubuntu.com/ubuntu/dists/trusty-security/Contents-amd64.diff/Index:
No Index available.
Downloading complete file http://security.ubuntu.com/ubuntu/dists/trusty-security/Contents-amd64.gz
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0 42.1M    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
File is up-to-date.

やっと apt-file が実行できる


# apt-file search libjpeg.so.8
libjpeg-turbo8: /usr/lib/x86_64-linux-gnu/libjpeg.so.8
libjpeg-turbo8: /usr/lib/x86_64-linux-gnu/libjpeg.so.8.0.2

なるほど。libjpeg-turbo8をインストール。


# apt-get install libjpeg-turbo8
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  gir1.2-gudev-1.0 libfile-copy-recursive-perl libgudev-1.0-0 ttf-dejavu-core
  update-inetd
Use 'apt-get autoremove' to remove them.
The following packages will be upgraded:
  libjpeg-turbo8
1 upgraded, 0 newly installed, 0 to remove and 414 not upgraded.
Need to get 104 kB of archives.
After this operation, 23.6 kB of additional disk space will be used.
Get:1 http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ trusty/main libjpeg-turbo8 amd64 1.3.0-0ubuntu2 [104 kB]
Fetched 104 kB in 0s (6,563 kB/s)  
(Reading database ... 43600 files and directories currently installed.)
Preparing to unpack .../libjpeg-turbo8_1.3.0-0ubuntu2_amd64.deb ...
Unpacking libjpeg-turbo8:amd64 (1.3.0-0ubuntu2) over (1.1.90+svn733-0ubuntu4.4) ...
Setting up libjpeg-turbo8:amd64 (1.3.0-0ubuntu2) ...
Processing triggers for libc-bin (2.15-0ubuntu10.7) ...
ldconfig deferred processing now taking place

今度はrootで実行してみた


# soffice --headless --convert-to pdf *.ods
Fontconfig error: Cannot load default config file
Fontconfig error: Cannot load default config file
convert /hogehoge/1502089893000000002/1502089893000000002.ods -> /hogehoge/1502089893000000002/1502089893000000002.pdf using calc_pdf_Export
# ls
1502089893000000002.ods  1502089893000000002.pdf

pdfができた。しかしながら日本語が表示されていない。


# export FONTCONFIG_PATH=/etc/fonts

としたが、同じだった。

日本語環境ってこれかな？

#  apt-get install language-pack-ja-base language-pack-ja
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  gir1.2-gudev-1.0 libfile-copy-recursive-perl libgudev-1.0-0 ttf-dejavu-core
  update-inetd
Use 'apt-get autoremove' to remove them.
The following NEW packages will be installed:
  language-pack-ja language-pack-ja-base
0 upgraded, 2 newly installed, 0 to remove and 414 not upgraded.
Need to get 1,993 kB of archives.
After this operation, 9,234 kB of additional disk space will be used.
Get:1 http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main language-pack-ja-base all 1:14.04+20160720 [1,992 kB]
Get:2 http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ trusty-updates/main language-pack-ja all 1:14.04+20160720 [1,818 B]
Fetched 1,993 kB in 0s (7,500 kB/s)     
Selecting previously unselected package language-pack-ja-base.
(Reading database ... 43600 files and directories currently installed.)
Preparing to unpack .../language-pack-ja-base_1%3a14.04+20160720_all.deb ...
Unpacking language-pack-ja-base (1:14.04+20160720) ...
Selecting previously unselected package language-pack-ja.
Preparing to unpack .../language-pack-ja_1%3a14.04+20160720_all.deb ...
Unpacking language-pack-ja (1:14.04+20160720) ...
Setting up language-pack-ja (1:14.04+20160720) ...
Setting up language-pack-ja-base (1:14.04+20160720) ...
Generating locales...
  ja_JP.UTF-8... done
Generation complete.

フォントがインストールされているようには見えないし、改めて作成したPDFを見ても日本語化けは治らない。使用しているODSファイルはIPAGothic/IPAMinchoを使っているのだけれど、Ubuntuの日本語フォントにIPAGothic/IPAMinchoってヒョウジュンではいってなかったっけ？
今インストールされているフォントを確かめてみる。


# fc-list
Fontconfig error: Cannot load default config file
/usr/share/fonts/truetype/dejavu/DejaVuSerif-Bold.ttf: DejaVu Serif:style=Bold
/usr/share/fonts/truetype/dejavu/DejaVuSansMono.ttf: DejaVu Sans Mono:style=Book
/usr/share/fonts/truetype/dejavu/DejaVuSansCondensed-Oblique.ttf: DejaVu Sans,DejaVu Sans Condensed:style=Condensed Oblique,Oblique
・
・
・

それっぽいのがないので明示的にインストール。


# apt-get install fonts-ipafont-gothic fonts-ipafont-mincho
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  gir1.2-gudev-1.0 libfile-copy-recursive-perl libgudev-1.0-0 ttf-dejavu-core
  update-inetd
Use 'apt-get autoremove' to remove them.
The following NEW packages will be installed:
  fonts-ipafont-gothic fonts-ipafont-mincho
0 upgraded, 2 newly installed, 0 to remove and 414 not upgraded.
Need to get 8,245 kB of archives.
After this operation, 28.8 MB of additional disk space will be used.
Get:1 http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ trusty/main fonts-ipafont-gothic all 00303-12ubuntu1 [3,519 kB]
Get:2 http://us-east-1.ec2.archive.ubuntu.com/ubuntu/ trusty/main fonts-ipafont-mincho all 00303-12ubuntu1 [4,726 kB]
Fetched 8,245 kB in 0s (28.2 MB/s)          
Selecting previously unselected package fonts-ipafont-gothic.
(Reading database ... 43812 files and directories currently installed.)
Preparing to unpack .../fonts-ipafont-gothic_00303-12ubuntu1_all.deb ...
Unpacking fonts-ipafont-gothic (00303-12ubuntu1) ...
Selecting previously unselected package fonts-ipafont-mincho.
Preparing to unpack .../fonts-ipafont-mincho_00303-12ubuntu1_all.deb ...
Unpacking fonts-ipafont-mincho (00303-12ubuntu1) ...
Processing triggers for fontconfig (2.11.0-0ubuntu4.2) ...
Setting up fonts-ipafont-gothic (00303-12ubuntu1) ...
update-alternatives: using /usr/share/fonts/opentype/ipafont-gothic/ipag.ttf to provide /usr/share/fonts/truetype/fonts-japanese-gothic.ttf (fonts-japanese-gothic.ttf) in auto mode
Setting up fonts-ipafont-mincho (00303-12ubuntu1) ...
update-alternatives: using /usr/share/fonts/opentype/ipafont-mincho/ipam.ttf to provide /usr/share/fonts/truetype/fonts-japanese-mincho.ttf (fonts-japanese-mincho.ttf) in auto mode

これでうまくいきました。