Pdns installed with PostgreSQL backend. The logs say: ................... Unable to load module '/usr/lib/pdns/libgpsqlbackend.so': /usr/lib/pdns/libgpsqlbackend.so: cannot open shared object file: No such file or directory ................... I can't find the file libgpsqlbackend.so indeed.
Not only is the file missing but pdns should be looking for libgpgsqlbackend.so instead (see the extra 'g' inside the name) as it is the case in previous releases, Fedora 8 for example. I need a quick fix here, where can I get this file? MySQL includes this files in the package libs-mysql. Is there such a package for PostgreSQL?
Do you have pdns-backend-postgresql installed?
Yes, definitively. When I did a yum install pdns-backend-postgresql however, I didn't get an extra package as it does with pdns-backend-mysql that adds libs-mysql.
It pulls in postgresql-libs: [root@ruben yum.repos.d]# sudo yum install pdns-backend-postgresql Loading "installonlyn" plugin Setting up Install Process Setting up repositories Reading repository metadata in from local files Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for pdns-backend-postgresql to pack into transaction set. pdns-backend-postgresql-2 100% |=========================| 3.9 kB 00:00 ---> Package pdns-backend-postgresql.x86_64 0:2.9.21-4.el5.centos set to be updated --> Running transaction check --> Processing Dependency: libpq.so.4()(64bit) for package: pdns-backend-postgresql --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql-libs to pack into transaction set. postgresql-libs-8.1.11-1. 100% |=========================| 16 kB 00:00 ---> Package postgresql-libs.x86_64 0:8.1.11-1.el5_1.1 set to be updated --> Running transaction check Dependencies Resolved ============================================================================= Package Arch Version Repository Size ============================================================================= Installing: pdns-backend-postgresql x86_64 2.9.21-4.el5.centos extras 35 k Installing for dependencies: postgresql-libs x86_64 8.1.11-1.el5_1.1 updates 195 k
Actually, it doesn't. I'll fix the package, in the meantime you can install postgresql-libs.
Actually pdns is expecting libgpsqlbackend.so and not libgpgsqlbackend.so. So I created a link: ln -s /usr/lib/pdns/libgpgsqlbackend.so /usr/lib/pdns/libgpsqlbackend.so But pdns still complains with this error: ---------------------------------------------- pdns[2687]: Guardian is launching an instance pdns[2687]: This is module gpgsqlbackend.so reporting pdns[2687]: Fatal error: Trying to launch unknown backend 'gpsql' pdns[2680]: Our pdns instance exited with code 1 pdns[2680]: Respawning ----------------------------------------------
Forget about my last post. That was due to a bad config file. Somehow there must have been a change of name for the backend and I was perhaps reading an older documentation. The backend name to use PostgreSQL is 'gpgsql' and not 'gpsql', so I corrected the config file /etc/pdns/pdns.conf like this: ------------------------ launch=gpsql gpgsql-host=127.0.0.1 gpgsql-user=***** gpgsql-dbname=***** gpgsql-password=***** ------------------------
Hi Eric Regarding comment #5, I just installed the backend on Fedora devel, and it pulls in postgresql-libs: [ruben@localhost devel]$ sudo yum install pdns-backend-postgresql Setting up Install Process Parsing package install arguments Resolving Dependencies --> Running transaction check ---> Package pdns-backend-postgresql.i386 0:2.9.21-4.fc9 set to be updated --> Processing Dependency: libpq.so.5 for package: pdns-backend-postgresql --> Running transaction check ---> Package postgresql-libs.i386 0:8.3.1-1.fc9 set to be updated --> Finished Dependency Resolution Dependencies Resolved ============================================================================= Package Arch Version Repository Size ============================================================================= Installing: pdns-backend-postgresql i386 2.9.21-4.fc9 fedora 33 k Installing for dependencies: postgresql-libs i386 8.3.1-1.fc9 fedora 210 k The backend is indeed named gpgsql (and has been since at least FC-5) Is everything working for you now?
Hi Ruben, Yes, it now pulls in the postgresql-libs package. Everything's working fine. Thank you.