Filr HTTP Status 500 Error (database credentials mismatch)

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

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

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
     
     

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>