[Pdns-users] Cannot load plugin … /usr//usr/...

[Nick Williams]

I just installed PowerDNS 3.1.0.6 (using package management on OpenSUSE 12.3) on a new machine and copied my MySQL database over to it. As usual, on the first time starting it I tried /etc/init.d/pdns monitor` to see the output. gmysql can't load plugins because it's doubling the first part of the path (/usr//usr/ instead of /usr/):

% Aug 14 21:46:47 gmysql Connection failed: Unable to connect to database: Authentication plugin 'sha256_password' cannot be loaded: /usr//usr/lib64/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory

Now, granted, the file /usr/lib64/mysql/plugin/sha256_password.so doesn't exist, either. But PowerDNS is still trying the wrong path. Furthermore, sha256_password.so is imaginary. The sha256_password plugin is part of the client library; it's not a separate module. Is PowerDNS gmysql just now ready for the sha256 password hashing authentication in MySQL 5.6?

And what could I be doing wrong that it's using the double /usr//usr/ path?

Here's the full monitor output.

# /etc/init.d/pdns monitor
Aug 14 21:46:47 Reading random entropy from '/dev/urandom'
Aug 14 21:46:47 This is module gmysqlbackend.so reporting
Aug 14 21:46:47 This is a standalone pdns
Aug 14 21:46:47 It is advised to bind to explicit addresses with the --local-address option
Aug 14 21:46:47 UDP server bound to 0.0.0.0:53
Aug 14 21:46:47 TCP server bound to 0.0.0.0:53
Aug 14 21:46:47 PowerDNS 3.1 (C) 2001-2012 PowerDNS.COM BV (Jan 28 2013, 07:31:55, gcc 4.7.2 20130108 [gcc-4_7-branch revision 195012]) starting up
Aug 14 21:46:47 PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of the GPL version 2.
Aug 14 21:46:47 Creating backend connection for TCP
% Aug 14 21:46:47 gmysql Connection failed: Unable to connect to database: Authentication plugin 'sha256_password' cannot be loaded: /usr//usr/lib64/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory
Aug 14 21:46:47 Caught an exception instantiating a backend, cleaning up
Aug 14 21:46:47 TCP server is unable to launch backends - will try again when questions come in: Unable to launch gmysql connection: Unable to connect to database: Authentication plugin 'sha256_password' cannot be loaded: /usr//usr/lib64/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory
Aug 14 21:46:47 About to create 3 backend threads for UDP
Aug 14 21:46:47 gmysql Connection failed: Unable to connect to database: Authentication plugin 'sha256_password' cannot be loaded: /usr//usr/lib64/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory
Aug 14 21:46:47 Caught an exception instantiating a backend, cleaning up
Aug 14 21:46:47 gmysql Connection failed: Unable to connect to database: Authentication plugin 'sha256_password' cannot be loaded: /usr//usr/lib64/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory
Aug 14 21:46:47 Caught an exception instantiating a backend, cleaning up
Aug 14 21:46:47 gmysql Connection failed: Unable to connect to database: Authentication plugin 'sha256_password' cannot be loaded: /usr//usr/lib64/mysql/plugin/sha256_password.so: cannot open shared object file: No such file or directory
Aug 14 21:46:47 Caught an exception instantiating a backend, cleaning up
Aug 14 21:46:47 Done launching threads, ready to distribute questions