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.

Free(BSD)
Search for duplicated files

This will be short (but hopefully I will find more time to show entire process to search duplicated files together with some examples). In case you are searching for duplicated files I can recommend two software which actually rocks in openSource world

Linux
2
“Gaming laptop”, steam link and rustdesk.

Not really related to this article, but just wanted to describe the situation.  Most of the time I am working on Linux or Mac. Not a big deal, but last year we bought my daughter a kind of gaming laptop. I am saying kind of, because IMHO there is no …

Azure
NFS issue, cannot be mounted or is not visible

The same kind of issue I have encountered numerous times while working across different environments and with various customers. The problem with NFS mounts connected from remote locations is so common. This issue extends beyond communication solely over WAN and also include connections between datacenters (DC) where we lack control …