Filr HTTP Status 500 Error (database credentials mismatch)

  • 7012468
  • 23-May-2013
  • 26-Jul-2013

Environment

Novell Filr 1.0

Situation

Filr webpage displays error:
HTTP Status 500 - Filter execution threw an exception

SSF log (/opt/novell/filr/apache-tomcat/logs/ssf.log)
Follow the steps in Section A to resolve - SSF log:
WARN [localhost-startStop-1] [org.hibernate.cfg.SettingsFactory] - Could not obtain connection to query metadata
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
Follow the steps in Section B to resolve - SSF Log:
ERROR [localhost-startStop-1] [org.kablink.util.dao.hibernate.DynamicDialect] - org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))
ERROR [localhost-startStop-1] [org.springframework.web.context.ContextLoader] - Context initialization failed

Resolution

Section A. Reconfigure Filr MySQL Database credentials via Appliance Administration:
  1. Navigate to the Novell Filr Appliance Administration (https://serverAddress:9443)
  2. Select Novell Filr Appliance Configuration
  3. Select Database on the Configuration panel
  4. Enter the current Filr MySQL Database Administrator's username and password
  5. Select OK
  6. Select Reconfigure Filr Server on the Configuration panel
 
Section B. Change MySQL Database password via terminal session to match the Novell Filr Appliance (or update the Filr Appliance to match the MySQL Database credentials by following Section A):
  1. From a terminal window on the server that hosts the Filr MySQL database:
    • Enter the following, updating the MySQL Administrator's password:
      mysqladmin -u<MySQL-Admin> -p<password> password <newpassword>
    • Replace <MySQL-Admin> with the MySQL Filr Administrator's username
    • Replace <password> with the current database password
    • Replace <newpassword> with the correct password
  2. Restart the Filr Appliance:
    • Navigate to the Novell Filr Appliance Administration (https://serverAddress:9443)
    • Select Appliance System Configuration
    • Select Reboot
    • Select OK

Cause

Section A - Novell Filr Appliance is not updated with the MySQL database credentials.
Section B - MySQL database credentials do not match the Novell Filr Appliance.

Additional Information

https://www.novell.com/documentation/novell-filr1/filr1_inst/data/database.html#b12rkbdu

Troubleshooting Steps: Verify the Appliance can connect to the MySQL database as the specified user.

  1. From a terminal on the Novell Filr Appliance server, enter the following command:
    mysql -h <host name or ipAddress of MySQL Appliance server> -u<username> -p
    • Replace <host name or ipAddress of MySQL Appliance server>
    • Replace <username> with the username provided to the Appliance (see how to determine this from the introduction paragraph of this TID)
    • For example: mysql -h 151.155.133.25 -uFilr -p
  2. Once the command has been entered, it will prompt for the password of the database user provided with the -u switch. Provide the password and press Enter.
  3. The following demonstrates a successful connection:
    mysql -h 151.155.133.25 -ufilr -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 640
    Server version: 5.0.96-log SUSE MySQL RPM

    Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql>