Hi all,
Ok the database is populated (simply re-ran the Prizm setup) and the database.xml looks good ->
<?xml version=“1.0” encoding=“UTF-8”?>
<!-- Requires exactly 1 database tag specifying the database to connect to -->
<database host=“localhost” port=“3306” user=“user” password=“password” dbname=“prizm” driver=“MySql”>
<driver name=“SqlServer” driverpath="%base%/3rdParty/Java/jdbc_drivers/sqlserver" profile=“sqlsvr.xml”/>
<driver name=“MySql” driverpath="%base%/3rdParty/Java/jdbc_drivers/mysql" profile=“mysql.xml”/>
<driver name=“PostGreSQL” driverpath="%base%/3rdParty/Java/jdbc_drivers/postgresql" profile=“postgresql.xml”/>
<driver name=“Derby” driverpath="%base%/3rdParty/Java/jdbc_drivers/derby" profile=“derby.xml”/>
I’ve also updated the config/bamconfig.xml with similar details ->
<database xsi:type=“canopy:Database”>
<driver xsi:type=“xsd:string”>MySql</driver>
<dsn xsi:type=“xsd:string”>mysql</dsn>
<username xsi:type=“xsd:string”>user</username>
<password xsi:type=“xsd:string”>password</password>
</database>
I’ve edited this file ->
/usr/local/Canopy/Prizm/3rdParty/Java/jdbc_drivers/mysql/mysql.xml
<JDBC_DRIVER jdbcDriver=“com.mysql.jdbc.Driver”
prefix=“jdbc:mysql”
urlPattern="%prefix%://%host%:%port%/%dbname%"
jar=“mysql-connector-java-3.1.13-bin.jar”
connMaxCount=“50”
connInitCount=“1”
connWaitTime=“30000”
connAgingTime=“10000”
/>
So mysql-connector-java-3.1.13-bin.jar reflects the connector version downloaded and placed into the same directory.
-rw-r–r-- 1 root root 456729 Jun 26 16:07 mysql-connector-java-3.1.13-bin.jar
I can also connect to MySQL from the CLI without errors ->
[root@bam config]# mysql -u user -p prizm
Enter password: password
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or 'g.
Your MySQL connection id is 1284 to server version: 3.23.58
Type ‘help;’ or '‘h’ for help. Type '‘c’ to clear the buffer.
mysql> show tables
-> ;
±-------------------------------+
| Tables_in_prizm |
±-------------------------------+
| LogEvent_01_10_00 |
| UsrPerms |
| UsrUserPerms |
| UsrUserPref_01_10_00 |
| UsrUsers |
| alert_manager_01_10_00 |
| bam_bad_sm |
| bam_sm |
| config_element_history |
…etc
The web server is running and I can see the Prizm front page, which reports that the server is not running. When I try to start the server I get these errors about odbc ->
Info 06/27/2006 9:04:44 File: main.cpp Line: 477 Message: Main application daemonized
Info 06/27/2006 9:04:44 File: config.cpp Line: 100 Message: Created API Configuration Object
Info 06/27/2006 9:04:44 File: config.cpp Line: 110 Message: Created Radius Configuration Object
Info 06/27/2006 9:04:44 File: config.cpp Line: 82 Message: Main Configuration Object Created
Info 06/27/2006 9:04:44 File: main.cpp Line: 478 Message: DSN name: mysql
Info 06/27/2006 9:04:44 File: main.cpp Line: 479 Message: Radius mode: false
Info 06/27/2006 9:04:44 File: main.cpp Line: 480 Message: Allow License Underutilization: true
Info 06/27/2006 9:04:44 File: database.cpp Line: 52 Message: Base class constructor of Database called
Info 06/27/2006 9:04:44 File: odbc.cpp Line: 129 Message: Creating ODBC driver for interfacing with the DB
Info 06/27/2006 9:04:44 File: odbc.cpp Line: 150 Message: constructor of Database called with keep alive: 0
Info 06/27/2006 9:04:44 File: odbc.cpp Line: 78 Message: ODBC: Open connection
Severe 06/27/2006 9:04:44 File: odbc.cpp Line: 118 Message: Unable to make connection with ODBC driver
Severe 06/27/2006 9:04:44 File: main.cpp Line: 503 Message: Unable to establish ODBC connection: Unable to connect Exiting.
06/27/06 09:04:41 INFO SYSTEM Get Remote Service: Canopy.Prizm.LogEventManager Internal/Unknown Requester: java.rmi.server.ServerNotActiveException: not in a remote call
06/27/06 09:04:41 INFO SYSTEM Get Remote Service: Canopy.Prizm.NodeManager Internal/Unknown Requester: java.rmi.server.ServerNotActiveException: not in a remote call
06/27/06 09:04:41 INFO SYSTEM Get Remote Service: Canopy.Prizm.NodeManager Internal/Unknown Requester: java.rmi.server.ServerNotActiveException: not in a remote call
06/27/06 09:04:41 INFO SYSTEM Get Remote Service: Canopy.Prizm.NetworkManager Internal/Unknown Requester: java.rmi.server.ServerNotActiveException: not in a remote call
06/27/06 09:04:41 INFO SYSTEM Get Remote Service: Canopy.Prizm.UserManager Internal/Unknown Requester: java.rmi.server.ServerNotActiveException: not in a remote call
06/27/06 09:04:41 WARN SYSTEM Utilizing bamconfigfile: /usr/local/Canopy/Prizm/config/bamconfig.xml
06/27/06 09:04:41 INFO SYSTEM BAM Radius Mode is Disabled
06/27/06 09:04:41 INFO SYSTEM NodeManagerListenerManager: Dispatcher Thread started for listener com.mot.canopy.prizm.services.bammanager.BAMManager$1@676437
06/27/06 09:04:41 INFO SYSTEM Get Remote Service: Canopy.Prizm.ElementConfigManager Internal/Unknown Requester: java.rmi.server.ServerNotActiveException: not in a remote call
06/27/06 09:04:41 INFO SYSTEM Get Remote Service: Canopy.Prizm.ElementConfigManager Internal/Unknown Requester: java.rmi.server.ServerNotActiveException: not in a remote call
06/27/06 09:04:41 WARN SYSTEM [JavaUtils]-Unable to find required classes (javax.activation.DataHandler and javax.mail.internet.MimeMultipart). Attachment support is disabled.
06/27/06 09:04:56 WARN SYSTEM Unable to get newly authenticated SMs: ; nested exception is:
java.net.ConnectException: Connection refused
06/27/06 09:04:56 WARN SYSTEM Unable to get failed license attempts: ; nested exception is:
java.net.ConnectException: Connection refused
06/27/06 09:05:03 WARN SYSTEM Unable to get newly authenticated SMs: ; nested exception is:
java.net.ConnectException: Connection refused
06/27/06 09:05:03 WARN SYSTEM Unable to get failed license attempts: ; nested exception is:
java.net.ConnectException: Connection refused
06/27/06 09:05:10 WARN SYSTEM Unable to get newly authenticated SMs: ; nested exception is:
java.net.ConnectException: Connection refused
06/27/06 09:05:10 WARN SYSTEM Unable to get failed license attempts: ; nested exception is:
java.net.ConnectException: Connection refused
06/27/06 09:05:11 INFO SYSTEM Operation[System Maintenance Operation] start run …
06/27/06 09:05:11 INFO SYSTEM Operation[System Maintenance Operation] status:completed_ok
06/27/06 09:05:14 SEVERE SYSTEM Unable to launch BAM process. See log_#1_bam_engine.txt in the logs directory for additional details.
06/27/06 09:05:14 INFO SYSTEM Operation: System Maintenance Operation for schedule:System Maintenance Schedule done.
06/27/06 09:05:14 INFO SYSTEM Notification Dispatcher exit
06/27/06 09:05:14 INFO SYSTEM Operation: Backhaul - Unpaired Master for schedule:10 Minutes (From Start of the Hour) done.
06/27/06 09:05:14 INFO SYSTEM Operation: RF - dBm Threshold Monitor for schedule:10 Minutes (From Start of the Hour) done.
06/27/06 09:05:14 INFO SYSTEM Operation: Element - Recently Rebooted for schedule:10 Minutes (From Start of the Hour) done.
06/27/06 09:05:14 INFO SYSTEM Operation: Element - Ethernet Down for schedule:10 Minutes (From Start of the Hour) done.
06/27/06 09:05:14 INFO SYSTEM Operation: Access Point - Unregistered Unit for schedule:10 Minutes (From Start of the Hour) done.
06/27/06 09:05:14 INFO SYSTEM Operation: Backhaul - Unpaired Slave for schedule:10 Minutes (From Start of the Hour) done.
06/27/06 09:05:14 INFO SYSTEM Operation: Element - Poll Failed for schedule:10 Minutes (From Start of the Hour) done.
06/27/06 09:05:14 INFO SYSTEM NodeManagerListenerManager: Dispatcher Thread completed for listener com.mot.canopy.prizm.services.elementconfigmanager.ElementConfigManager$1@1ce784b
06/27/06 09:05:14 INFO SYSTEM Configuration Manager: Updater Thread exited
06/27/06 09:05:14 INFO SYSTEM Configuration Manager: CPLRelationshipChangeProcessor Thread completed
06/27/06 09:05:14 INFO SYSTEM Task scheduler exit
06/27/06 09:05:14 INFO SYSTEM NodeManagerListenerManager: Dispatcher Thread completed for listener com.mot.canopy.prizm.services.perfdb.PerformanceDB$1@19b1de
06/27/06 09:05:14 INFO SYSTEM NodeManagerListenerManager: Dispatcher Thread completed for listener com.mot.canopy.prizm.services.networkmanager.NetworkManager$1@16921fd
06/27/06 09:05:14 INFO SYSTEM NodeManagerListenerManager: Dispatcher Thread completed for listener com.mot.canopy.prizm.services.nodemanager.NodeStatusManager@87c268
06/27/06 09:05:14 INFO SYSTEM LogEvent Dispatcher: Thread completed
06/27/06 09:05:14 SEVERE SYSTEM Start Server failed: Failed to startup required Prizm Service: Canopy.Prizm.BAMManager
06/27/06 09:05:14 SEVERE SYSTEM EXCEPTION: com.mot.canopy.prizm.core.InvalidConfigurationException: Failed to startup required Prizm Service: Canopy.Prizm.BAMManager
com.mot.canopy.prizm.core.Server.loadServices(Server.java:1012)
com.mot.canopy.prizm.core.Server.startup(Server.java:740)
com.mot.canopy.prizm.core.Server.startServer(Server.java:563)
com.mot.canopy.prizm.core.Server.main(Server.java:276)
06/27/06 09:05:14 SEVERE SYSTEM Prizm Server Failed to Start. See above errors.
Anyone got any clues about this? Using RedHatEL.
Cheers.