Połączenie LibreOffice z PostgreSQL za pomocą JDBC.

  1. Konfiguracja postgresql: pg_hba.conf: host all all 192.168.1.0/24(albo inna sieć) md5, postgresql.conf: listen_address = ‘*’
  2. Konfiguracja użytkownika i bd: sudo -i, su – postgres, createdb nazwa, createuser nazwa, psql, alter user nazwa encrypted password ‘haslo’
  3. Należy pobrać sterownik ze strony: http://jdbc.postgresql.org/download.html
  4. Zapisać sterownik, najlepiej w ścieżce ogólnodostępnej typu: C:\Program Files (x86)\LibreOffice 3.4\program\jdbcdrivers (wymagane odpowiendie uprawnienia)
  5. Dodać ścieżkę do zapisanego sterownika w programie LibreOffice: narzędzia -> opcje -> java -> ścieżka do klas -> dodaj archiwum
  6. W LibreOffice Base wybrać połączenie typu JDBC, dalej Datasource Url: postgresql://host:port/nazwa_bazy, jdbc driver class: org.postgresql.Driver (z uwzględnieniem dużego D)

UWAGI:

Dokładny opis:

http://www.postgresonline.com/journal/archives/8-Using-OpenOffice-Base-2.3.1-with-PostgreSQL.html

Sterownik działa bezproblemowo na systemach 32 i 64 bit.

No Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Linux
Multi-Linux Manager, what makes this product interesting for the Enterprises.

Interesting links: [1] https://documentation.suse.com/liberty/7/html/suma-quickstart/art-suma-quickstart.html[2] https://documentation.suse.com/liberty/7/html/compliance-scans/art-compliance-scans.html[3] https://documentation.suse.com/liberty/7/html/quickstart-scc/art-quickstart-scc.html[4] https://documentation.suse.com/liberty/9/[5] https://documentation.suse.com/en-us/sles/15-SP7/html/SLES-all/cha-klp.html[6] https://documentation.suse.com/multi-linux-manager/5.1/en/docs/administration/maintenance-windows.html[7] https://documentation.suse.com/multi-linux-manager/5.1/en/docs/administration/maintenance-windows.html

Linux
Creating random (not empty, thin provisioned) files in Linux

Recently I have found the command that can generate random file in linux environment where non empty (thin provisioned) files are required for testing: todo: combine that command with parallel command (or parallel that in python).

Linux
Nginx configuration for joplin note taking app

Introduction Joplin may not be the most perfect note-taking application, but it is open-source, well-known, has a long release history, works on multiple operating systems, and supports plugins. It’s not perfect, but it’s good enough and highly usable. In case of this type of application, it is important to have …