OpManagerDB running on a external mysql-server (ubuntu)
Hi!
I've tryed to get the database on a axternal machine. Can't quite get it to work. It creates the database and some tables (318 to be precise). What ive done is change some parameters in: database_params.conf
# url is of the form jdbc:subprotocol:DataSourceName for eg.jdbc:odbc:WebNmsDB
url jdbc:mysql://xxx.xxx.xxx.xxx:3306/opmanager?dontTrackOpenResources=true&useUnicode=true&characterEncoding=utf8 AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# driver name
drivername org.gjt.mm.mysql.Driver AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# login username for database if any
username XXX AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# login password for the database if any
password XXX AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB
# Number of transactional connections. (This number has to be zero for transaction disable mode).
TRANS_CONNECTIONS 0
# Number of non-transactional connections.
NON_TRANS_CONNECTIONS 6
#database name
databasename MYSQL
----------------------------------------------------------------------------------------------------------------------------
Ideas?