search

fhem / fhem-docker

A basic Docker image for FHEM house automation system, based on Debian Linux.
https://fhem.de/
MIT License
84 stars 27 forks source link

Postgresql does not work #264

Closed sidey79 closed 2 weeks ago

sidey79 commented 2 weeks ago

Describe the bug

Using a postgresql database for dblog, causes an errror:

https://forum.fhem.de/index.php?topic=89745.msg1319071#msg1319071

To Reproduce Steps to reproduce the behavior:

  1. create db.conf with postgresql 
    ####################################################################################
#
## for PostgreSQL
####################################################################################
%dbconfig= (
connection => "Pg:database=fhem;host=pgdb",
user => "postgres",
password => "postgres"
);
  2. define a DBLog definition using the db.conf file named pgDbLog

  3. Look in the logfile for the following error:

    pgDbLog - ERROR: install_driver(Pg) failed: Attempt to reload DBD/Pg.pm aborted.
Compilation failed in require at (eval 404) line 3.

at ./FHEM/93_DbLog.pm line 2559.

Expected behavior dblog connects to postgredatabase without compilation failed error

Docker Image 4.0.4-Bullsexe

Additional context Reported at forum: https://forum.fhem.de/index.php?topic=89745.msg1319071#msg1319071