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
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 …

Linux
podcast

All podcast applications I have tested were quite OK(ish) – but I have always struggled with organizing podcasts, creating playlists, etc. It has always been challenging. Therefore, for me, it is more convenient to download podcasts as MP3s and manage them myself (in VLC, for example). There are many ways to do that, but my favorite …