Unable to authenticate when connecting to to Fedora Server

45 views
Skip to first unread message

Matthew Prythero

unread,
Dec 29, 2016, 3:56:28 AM12/29/16
to islandora
Me again! As I'm slowly moving along, I have finally come near to the end of the installation and configuration process, however, it appears I have hit another snag.

When Configuring the Islandora Base Module, I go to edit the Fedora Server port (which had to change to 8082 and is currently running without an issue) and I get the following:

Unable to authenticate when connecting to to Fedora Server (Version 3.8.1). Please configure the Drupal Filter.

The problem is that I know my login information is correct (I've double checked through both terminal and the obvious 'settings.php' file in drupal. Below is my 'filter-drupal.xml' file:

<!--Place this file in $FEDORA_HOME/server/config

    Drupal connection info for the FilterDrupal servlet filter.  
    For multisite drupal installs you can include multiple connection elements.  
    We will query all the databases and assume any user in any drupal db with
    the same username and password are the same user.  

    We will gather all roles for that user from all databases.  This is a
    potential security risk if a user in one drupal database has the same
    username and password as another user in a seperate drupal database.  
-->
<FilterDrupal_Connection><!-- The values to be inserted below can be found in your drupal site's
         settings.php file at the line:

         $db_url = 'mysqli://drupaldbuser:drupaldbpass@localhost/drupaldb';

         Defaults:
           - port = 3306
           - jdbcDriverClass = "com.mysql.jdbc.Driver"
           - jdbcURLProtocol = "jdbc:mysql"

           postgresql users can set: jdbcDriverClass="org.postgresql.Driver" jdbcURLProtocol="jdbc:postgresql"
     
-->
<connection server="localhost" port="3306" dbname="drupal" user="drupalAdmin" password="drupalAdmin"><sql><!--Different sql statement for each connection.  This is for drupal
            multisites that are setup using one database with table prefixes.
            We don't do this but some people might.
-->

       SELECT DISTINCT u.uid AS userid, u.name AS Name, u.pass AS Pass,r.name AS Role FROM (users u LEFT JOIN users_roles ON u.uid=users_roles.uid) LEFT JOIN role r ON r.rid=users_roles.rid WHERE u.name=? AND u.pass=?;
   
</sql></connection></FilterDrupal_Connection>

Does anyone have any ideas as to how to fix this? Thanks! Matt
Reply all
Reply to author
Forward
0 new messages