Filr HTTP Status 500 Error (phpMyAdmin rights of filr user)

  • 7012952
  • 26-Jul-2013
  • 26-Jul-2013

Environment

Novell Filr

Situation

Visiting http://filr_hostname:8443, https://filr_hostname:8443 displays:
HTTP Status 500 - Filter execution threw an exception

Resolution

If the Novell Filr Appliance is configured to use an alternative database user to root, the rights for this user must be configured properly. To determine if an alternative user is configured, visit the Novell Filr Appliance Administration - https://filr_hostname:9443 | Novell Filr Appliance Configuration | Database | User Name.

Please follow the steps provided below to configure this user for proper global database privileges.
  1. From a web-browser, open the Novell MySQL Database Appliance https://ip_address:9443
  2. Select phpMyAdmin and log in with root credentials (default: root, root)
  3. Select Users from the top navigation bar
  4. Select Edit Privileges for the Filr or alternative user
  5. From the top Global privileges, select Check All
  6. From the Change Login Information / Copy User section near the bottom, in the Host field, select Use text field in the drop-down list, then specify the IP address or host name of the Filr application server. Alternatively, select Any Host from the drop-down list, which enters the % value.
  7. At the end of the section, select Go.

Cause

The rights to the alternative database user, such as Filr, needs to have Global Privileges set to ALL PRIVILEGES.

Additional Information

See documentation for Configuring and Maintaining the MySQL Database Appliance. It is recommended to create a new Filr user to administer the MySQL database. Provided are the steps to do so, which includes granting all privileges to this new user.

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>