logo
Apache Lounge
Webmasters

 

About Forum Index Downloads Search Register Log in  RSS Apache Lounge  


Keep Server Online

If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.

or

Bitcoin

A donation makes a contribution towards the costs, the time and effort that's going in this site and building.

Thank You! Steffen

Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.


Post new topic   Forum Index -> Apache View previous topic :: View next topic
Reply to topic   Topic: Can't load driver file apr_dbd_pgsql.so
Author
skumar



Joined: 04 Apr 2018
Posts: 3
Location: USA, Atlanta

PostPosted: Thu 05 Apr '18 15:39    Post subject: Can't load driver file apr_dbd_pgsql.so Reply with quote

Hi everyone,

I am using Apache HTTPD 2.4.33 VC11 (32 & 64 bit) windows server. For user's authentication I am using DBD (postgresql) module, but getting error:
Can't load driver file apr_dbd_pgsql.so

Looks like driver is missing. Can someone help me with psql driver (for windows, apr_dbd_pgsql-1.dll) for HTTPD 2.4.33 VC11?
Back to top
Jan-E



Joined: 09 Mar 2012
Posts: 1103
Location: Amsterdam, NL, EU

PostPosted: Fri 06 Apr '18 4:53    Post subject: Reply with quote

Try Gregg at AH:
https://forum.apachehaus.com/index.php?topic=1485.msg4165#msg4165
Back to top
glsmith
Moderator


Joined: 16 Oct 2007
Posts: 2251
Location: Sun Diego, USA

PostPosted: Fri 06 Apr '18 8:15    Post subject: Reply with quote

Yeah, about that.

The only potential problem I see is that all the windows PostgreSQL binaries are built with vc12, most software isn't forward compatible and VC11 apr_dbd_pgsql.dll will be loading vc12 dlls from your installation. It may not be stable if it works at all. Don't know.

You can ask at that link Jan posted.
Back to top
Steffen
Moderator


Joined: 15 Oct 2005
Posts: 2857
Location: Hilversum, NL, EU

PostPosted: Fri 06 Apr '18 11:12    Post subject: Reply with quote

@Gregg Maybe you can try the headers and libs at

https://windows.php.net/downloads/php-sdk/deps/vc11/


Last edited by Steffen on Fri 06 Apr '18 11:49; edited 2 times in total
Back to top
glsmith
Moderator


Joined: 16 Oct 2007
Posts: 2251
Location: Sun Diego, USA

PostPosted: Fri 06 Apr '18 11:42    Post subject: Reply with quote

I don't have/use PostgreSQL, I just have the headers and libs and am willing to build. But since you have, I guess I do not need to Very Happy

Which pgsql did you use, 10.3?
Back to top
Steffen
Moderator


Joined: 15 Oct 2005
Posts: 2857
Location: Hilversum, NL, EU

PostPosted: Fri 06 Apr '18 11:47    Post subject: Reply with quote

I found them at https://windows.php.net/downloads/php-sdk/deps/vc11/
Back to top
glsmith
Moderator


Joined: 16 Oct 2007
Posts: 2251
Location: Sun Diego, USA

PostPosted: Fri 06 Apr '18 11:57    Post subject: Reply with quote

Oh ok. Was wondering where you got those, once I looked. I spoke before I looked, I thought you built the dbd connecter. That will teach me to look first.

I wonder if it matter what pgsql version skumar is using.

That said, when I did this back in 1/2018, libpg.dll was dependent on libintl-8.dll, which was dependent on libiconv-2.dll. So php obviously doesn't have the internationalization ... cool. For the connector it shouldn't be needed anyway.
Back to top
Jan-E



Joined: 09 Mar 2012
Posts: 1103
Location: Amsterdam, NL, EU

PostPosted: Sat 07 Apr '18 0:07    Post subject: Reply with quote

glsmith wrote:
I wonder if it matter what pgsql version skumar is using.

I recently had to get PostgreSQL running with PHP 5.6.35 (VC11). My phpinfo is reporting:
Code:
PostgreSQL(libpq) Version 9.6.2
PostgreSQL(libpq) PostgreSQL 9.6.2 (win32)
Multibyte character support enabled
SSL support enabled
Active Persistent Links 0
Active Links 0

For this I used the libpq.dll 9.6.2 from https://windows.php.net/downloads/php-sdk/deps/vc11/x86/

However, the backend is PostgreSQL 9.3.22 which is compiled using VC10.
Downloads:
https://get.enterprisedb.com/postgresql/postgresql-9.3.22-1-windows.exe
https://get.enterprisedb.com/postgresql/postgresql-9.3.22-1-windows-x64.exe
https://www.enterprisedb.com/download-postgresql-binaries

The libpq.dll is not dependent on any non-native dll except the dll's for OpenSSL 1.0.2 (*eay32.dll) and the VC10/VC11 redistributables: MSVCR100.dll for PostgreSQL 9.3.22 and MSVCR110.dll for the libpq.dll 9.6.2.

TL;DR: the only relevant PostgreSQL dependency when compiling apr_dbd_pgsql-1.dll seems to be the libpq.dll.
Back to top
Jan-E



Joined: 09 Mar 2012
Posts: 1103
Location: Amsterdam, NL, EU

PostPosted: Sat 07 Apr '18 2:59    Post subject: Reply with quote

@skumar check the files inside
https://phpdev.toolsforresearch.com/openssl-1.0.2o-fips-2.4.33-x64-vc11.zip
https://phpdev.toolsforresearch.com/openssl-1.0.2o-fips-2.4.33-x86-vc11.zip
Back to top
glsmith
Moderator


Joined: 16 Oct 2007
Posts: 2251
Location: Sun Diego, USA

PostPosted: Sat 07 Apr '18 21:17    Post subject: Reply with quote

Boy has this thread evolved into something it wasn't, keeping with that I built pgsql 10.3 yesterday and it was easy and smooth right up until the postgre.exe file (or whatever it's name is). The lib built fine and doesn't require openssl so you're certainly correct there Jan.

I'll do 9.6.8 later today or tomorrow and then make some connectors as time permits. I've been focused on a new 2.4/LibreSSL build so far today.
Back to top
skumar



Joined: 04 Apr 2018
Posts: 3
Location: USA, Atlanta

PostPosted: Mon 09 Apr '18 20:16    Post subject: Reply with quote

Thanks everyone for your replies.

While i was going through discussion forum, I came across below link:
https://www.apachelounge.com/viewtopic.php?t=2545

I have tried this approach for postgresql (using pgsql-odbc driver - https://www.postgresql.org/ftp/odbc/versions/msi/) and solution worked without requiring psql connector (apr_dbd_pgsql-1.dll).

Do you see any harm in above approach?
Back to top
glsmith
Moderator


Joined: 16 Oct 2007
Posts: 2251
Location: Sun Diego, USA

PostPosted: Mon 09 Apr '18 21:56    Post subject: Reply with quote

That has been working for others with many DBs so I assume it should. I would suggest keeping an eye on it for awhile but if Tom said it's ok which it seems he has there then it's ok.
Back to top
skumar



Joined: 04 Apr 2018
Posts: 3
Location: USA, Atlanta

PostPosted: Tue 10 Apr '18 17:28    Post subject: Reply with quote

Thanks glsmith.
Back to top


Reply to topic   Topic: Can't load driver file apr_dbd_pgsql.so View previous topic :: View next topic
Post new topic   Forum Index -> Apache