"can't load driver file apr_dbd_mysql.so" when trying to enable mod_authn_dbd

sh699 2020-12-09 20:08:42 UTC #1

Keywords: LAMP/MAMP/WAMP - Google Cloud Platform - How to - Other
Description:
Hi, this is my first apache server, I used the bitnami launchpad lamp stack for Google cloud platform. I'm trying to enable authenticaton using a mysql db to store credentials. I followed this guide as it was the most applicable one I could find, though I of course used the equivalent paths for my distro. When I try to run apache with ctlscript I get:

Job for bitnami.service failed because the control process exited with error code.
See "systemctl status bitnami.service" and "journalctl -xe" for details.

When I run 'sudo systemctl status bitnami.service' I get:

● bitnami.service - LSB: bitnami init script
   Loaded: loaded (/etc/init.d/bitnami; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Wed 2020-12-09 19:24:12 UTC; 31min ago
  Process: 2423 ExecStart=/etc/init.d/bitnami start (code=exited, status=1/FAILURE)
    Tasks: 21 (limit: 2011)
   Memory: 104.1M
   CGroup: /system.slice/bitnami.service
           ├─803 php-fpm: master process (/opt/bitnami/php/etc/php-fpm.conf)
           ├─807 php-fpm: pool www
           ├─808 php-fpm: pool www
           ├─809 php-fpm: pool www
           ├─810 php-fpm: pool www
           ├─811 php-fpm: pool www
           ├─812 php-fpm: pool www
           ├─813 php-fpm: pool www
           ├─814 php-fpm: pool www
           ├─815 php-fpm: pool www
           ├─816 php-fpm: pool www
           ├─817 php-fpm: pool www
           ├─818 php-fpm: pool www
           ├─819 php-fpm: pool www
           ├─820 php-fpm: pool www
           ├─821 php-fpm: pool www
           ├─822 php-fpm: pool www
           ├─823 php-fpm: pool www
           ├─824 php-fpm: pool www
           ├─825 php-fpm: pool www
           └─826 php-fpm: pool www

Dec 09 19:24:11 bitnami-lampstack-5edc bitnami[2423]: Can't load driver file apr_dbd_mysql.so
Dec 09 19:24:12 bitnami-lampstack-5edc bitnami[2423]: 2020-12-09T19:24:11.999Z - error: Unable to perform start operation Export start for apache failed with exit code 1
Dec 09 19:24:12 bitnami-lampstack-5edc bitnami[2423]: ## 2020-12-09 19:24:12+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/010_bitnami_agent_extra...
Dec 09 19:24:12 bitnami-lampstack-5edc bitnami[2423]: ## 2020-12-09 19:24:12+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/020_bitnami_agent...
Dec 09 19:24:12 bitnami-lampstack-5edc bitnami[2423]: ## 2020-12-09 19:24:12+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/030_update_welcome_file...
Dec 09 19:24:12 bitnami-lampstack-5edc bitnami[2423]: ## 2020-12-09 19:24:12+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/040_bitnami_credentials_file...
Dec 09 19:24:12 bitnami-lampstack-5edc bitnami[2423]: ## 2020-12-09 19:24:12+00:00 ## INFO ## Running /opt/bitnami/var/init/post-start/050_clean_metadata...
Dec 09 19:24:12 bitnami-lampstack-5edc systemd[1]: bitnami.service: Control process exited, code=exited, status=1/FAILURE
Dec 09 19:24:12 bitnami-lampstack-5edc systemd[1]: bitnami.service: Failed with result 'exit-code'.
Dec 09 19:24:12 bitnami-lampstack-5edc systemd[1]: Failed to start LSB: bitnami init script.
~

I have been trying to check my logs but for some reason they don't seem to be being written to, even though I checked the envvar for APACHE_LOG_DIR and made sure I was looking in that directory.

Searching around, I found this link where people reported this error being due to a bug but I understood them to say it had been patched and (I think) I have updated apr-util to the latest version.

I've been wrestling with this for a few days now and am entirely confused, any advice would be greatly appreciated. I can post screenshots/copies of logs/outputs as needed

Ibone 2020-12-10 08:07:05 UTC #2

Hi @sh699,

Thanks for using Bitnami. We have a configuration of apache for the stack, you can check this link to know more https://docs.bitnami.com/google/infrastructure/lamp/get-started/understand-config/

I don't know if you a trying something similar to this https://docs.bitnami.com/google/apps/wordpress/administration/use-htpasswd/ or if this is valid for you.

Regards,
Ibone.

sh699 2020-12-10 09:51:50 UTC #3

Hi @Ibone,

Thank you for the links and reply.

I want to use a mysql database to store the authentication credentials, rather than a passwordfile as they suggest in that link. This is why I am trying to get mod_authn_dbd working.

I have made a table to store credentials, a DB user with correct privileges to be admin for the table and I have inserted a user to the credentials table.

In my conf file I have created a

<Directory "path to protected folder">
...
<\Directory>

I have included directives in there to specify it should require valid-user and should be using mysql db as the credential source, as well as specifying the driver and database details. This was all done in following the example in the first link I posted. I also enabled the relevant modules.

I can post the contents of any files, or outputs of any commands, that would be helpful to see.
Thank you

Ibone 2020-12-10 10:09:12 UTC #4

Hi @sh699,

We have a Support Tool that will gather relevant information for us to analyze your configuration and logs. Could you please execute it on the machine where the stack is running by following the steps described in the guide below?

How to Run the Bitnami Support Tool in a cloud image or virtual machine

Please note that you need to paste the code ID that is shown at the end.

Regards,
Ibone.

sh699 2020-12-10 15:13:07 UTC #5

Hi @Ibone,

I have now run the support tool, my ID is : 5121347c-189f-42cd-966c-d10e0bf384f4

Many thanks

Ibone 2020-12-11 11:02:14 UTC #6

Hi @sh699,

I check your data of the bnsupport and in your apache's logs appears:

[Wed Dec 09 18:14:13.633853 2020] [core:error] [pid 9517:tid 140718249801472] [client 142.93.99.114:59028] AH00027: No authentication done but request not allowed without authentication for /wp-login.php. Authentication not configured?
[Wed Dec 09 18:14:27.227259 2020] [core:error] [pid 9517:tid 140718051895040] [client 213.6.254.38:57293] AH00027: No authentication done but request not allowed without authentication for /. Authentication not configured?

Maybe you need your code (<Directory...> ...</Directory>) inside of the virtual host

Could you try this? Remember to restart apache after that change.

Regards,
Ibone.

sh699 2020-12-11 19:21:09 UTC #7

Hi @Ibone,

Which configuration file should I put my config in?
I wish to make some folders forbidden, I put it in my apache.conf and restarted and it made no change, so I then tried adding it to my bitnami.conf as well and this also made no change so I tried putting it in the default site in sites-available and this also made no change? It seems these configs are being ignored/overwritten?

Thanks

sh699 2020-12-11 19:22:03 UTC #8

I added this to the config files

<Directory />
        Options FollowSymLinks
        AllowOverride None
        Require all denied
</Directory>

<Directory /usr/share>
        AllowOverride None
</Directory>

<Directory /var/www/>
        Options Indexes FollowSymLinks
        AllowOverride None
</Directory>

<Directory /opt/bitnami/apache/htdocs>
        Options FollowSymLinks
        AllowOverride None

</Directory>

<Directory /opt/bitnami/apache/htdocs/assets>
        Options FollowSymLinks
        AllowOverride None
        Require all denied
</Directory>

<Directory /opt/bitnami/apache/htdocs/images>
        Options FollowSymLinks
        AllowOverride None
        Require all denied
</Directory>
<Directory /opt/bitnami/apache/htdocs/passmech>
        Options FollowSymLinks
        AllowOverride None
        Require all denied
</Directory>
<Directory /opt/bitnami/apache/htdocs/vendor>
        Options FollowSymLinks
        AllowOverride None
        Require all denied
</Directory>

Ibone 2020-12-15 08:40:23 UTC #9

Hi @sh699,

like you a using a virtual host, maybe the code that appears on the page you need to put into the virtual host,
something like this:

<VirtualHost 127.0.0.1:443 _default_:443>
  ...
  <Directory "..../protecteddir">

....

Regards,
Ibone.

system 2020-12-29 08:40:24 UTC #10

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!