Unknown database 46_ll_<name>_logs error after upgrading to TIBCO LogLogic LMI 4.9 and higher
Article ID: KB0077498
Updated On:
| Products | Versions |
|---|---|
| TIBCO LogLogic Log Management Intelligence | 4.9.0 and higher |
Description
After upgrading from 4.6.x to 4.9 and running the post upgrade script, /loglogic/bin/rundbm, as per the upgrade guide, when monitoring the post upgrade process the last line will show:
: ERROR 1049 (42000): Unknown database '46_ll_auth_logs'
: ERROR 1049 (42000): Unknown database '46_ll_auth_logs'
There are 2 methods to resolving this depending on whether you have already upgraded the appliance software.
Issue/Introduction
This article explains how to resolve an 'unknown database' error when upgrading from LogLogic LMI 4.6 to 4.9 and higher.
Resolution
If you read this before you upgrade then while 4.6.x is still on the appliance execute the /loglogic/scripts/postupgrade script and be sure to extend the post upgrade time period, as explained in 4.6 Upgrade Guide, page 18.
For example here is what you may see during post upgrade:
Choose which module to be modified:
1) ASA
2) DBAUDIT
3) ALERTHISTORY
4) AUTH
5) Return to Configuration Menu
6) Help
You will need to extend the post upgrade time period for all the modules listed above (ASA, DBAUDIT, ALERTHISTORY, and AUTH).
If you've already upgraded you will need to create a database in MySQL named just like it's specified in the error.
1. Execute the mysql client.
$ mysql
2. Create the database:
mysql> create database 46_ll_[name]_logs;
3. Now re-run the post upgrade script:
$ /loglogic/bin/rundbm
For example here is what you may see during post upgrade:
Choose which module to be modified:
1) ASA
2) DBAUDIT
3) ALERTHISTORY
4) AUTH
5) Return to Configuration Menu
6) Help
You will need to extend the post upgrade time period for all the modules listed above (ASA, DBAUDIT, ALERTHISTORY, and AUTH).
If you've already upgraded you will need to create a database in MySQL named just like it's specified in the error.
1. Execute the mysql client.
$ mysql
2. Create the database:
mysql> create database 46_ll_[name]_logs;
3. Now re-run the post upgrade script:
$ /loglogic/bin/rundbm
Feedback
Yes
No
Powered by
