Chapter 4: Dumping Applications Manager's data to MySQL 5.1

Prerequisites:

It's very important, you have to backup Applications Manager data before you execute this task. We recommended take complete backup of everything in Applications Manager. ( see Chapter 3)

Dumping Applications Manager's data to MySQL 5.1

When starting Applications Manager, MySQL Server 5.0.5, which is bundled with the product, is started. Applications Manager uses this MySQL by default. We strongly recommend you to use this default database itself. If you need to dump data into your own MySQL in that same machine, follow the steps given below.

1. Edit the database_params.conf file located in the <Applications Manager Home>/working/conf directory and change the following URL.

Default URL: jdbc:mysql://localhost:13326/AMDB

Change to: jdbc:mysql://<HOSTNAME>:<PORT>/<DATABASE>

Change the Username and Password to that of the MySQL Server you use.

For example:

[root@poller1 AppManager10]# vim working/conf/database_params.conf /$Id$ # url is of the form jdbc:subprotocol:DataSourceName for eg.jdbc:odbc:RMEDB #url jdbc:mysql://localhost:13327/AMDB?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8 AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB url jdbc:mysql://localhost:3306/AMDB?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8 AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB # driver name drivername org.gjt.mm.mysql.Driver AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB # login username for database if any username root AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB # login password for the database if any #encryptedpassword eK6q1CJ9697s7O AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB password ********* AppModules TopoDB-MapDB-EventDB-AlertDB-PollDB-PolicyDB-USERSTORAGEDB-ApplnDB # 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 ~

2. Edit the AppManager_Home/conf/AMServer.properties file, change the port of MySQL from true to false.

[root@poller1 AppManager10]# vim conf/AMServer.properties #These are the ports that are used by the server. am.webserver.port=9090 am.ssl.port=8443 am.ssl.enabled=true am.slasubgroups.enabled=false am.subgroups.enabled=true #If installed as service,then on changing am.ssl.enabled=true, Please follow the steps given in the below troubleshooting link before starting the server. http://manageengine.com/products/applications_manager/troubleshoot.html#g7 am.dbserver.type=mysql am.mysql.port=13327 am.tomcat.shutdown.port=18005 am.webcontainer.port=18009 am.rmiregistry.port=11099 am.shutdown.port=12000 am.traplistener.port=1620 # specify whether these ports need to be checked or not. am.mysqlport.check=false am.webserverport.check=true # This value is used for testing the availability of services. am.sockettest.timeout=15 am.discover.managed.weblogic=false am.server.language=en am.server.country=US #am.pingtest.command=/bin/ping -c 1 -w 1 #Start up the browser when the serer starts up. am.browser.startup=true am.upload.enabled=true am.cam.mbeanslistsize=250 am.spacecheck.warning=true am.server.type=NORM am.edition.type= am.adminserver.host=N.A am.adminserver.port=N.A am.server.startresidrange=10000000 am.adminserver.deletesql=true am.standalonesdp.enabled=false am.ssl.truststore= # These value are used for supporting websites with Windows NTLM authentication. am.ntlm.securityprovider=cryptix.jce.provider.CryptixCrypto am.ntlm.hostname=appmanager.vtg am.ntlm.hostdomainname= # The drives begining with the characters given below will not be monitored in server monitor. am.disks.ignore= am.weblogic78.authenabled=false am.telnet.loginTimeOut=30000 am.server.command.responsetimeout=40 am.sendmonerrormail.enabled=true am.errorpoll.count=3 am.mqdelrow.enabled=false am.alertmsgchange.enabled=false am.filesize.unit=KB am.dirsize.unit=MB am.script.deleterow=true am.host.deleteDisk=true am.processinstance.equals=false am.executeaction.size=400 am.querymonitor.rowcount=50 am.query.timeout=60 am.ftp.filesize=10 am.appmanager.hostname=appmanager.vtg am.html.dirsize=10485760 am.htmldata.jre.daystoretain=30 am.htmldata.mysql.daystoretain=30 am.oomexception.duration=30 am.oomexception.count=20 am.report.weekStartDay=1 # The below values is used to enable the Monitor Group Status View option in EnterPrise/Professional Edition Admin Tab. am.admin.mgstatusview.enabled=false am.log.dir=../logs/ am.createSupportZipFile=true am.expandWidgets=false

3. Start the Applications Manager. Note: When starting Applications Manager, you will get a warning message MySQL Port is used by some other Application. You can ignore this message.

[root@poller1 AppManager10]# nohup sh startApplicationsManager.sh & [root@poller1 AppManager10]# tailf nohup.out Log handler name : com.adventnet.management.log.Log4jHandler XML File name : log4j_conf.xml Starting Applications Manager "Primary" Server Modules, please wait ... Process : AMScriptProcess [ Started ] Process : AMExtProdIntegrationProcess [ Started ] Process : AuthMgr [ Started ] Process : AMDataCleanupProcess [ Started ] Process : NmsPolicyMgr [ Started ] Process : DBUserStorageServer [ Started ] Process : StartRelatedServices [ Started ] Process : NMSMServer [ Started ] Process : AMUrlMonitorProcess [ Started ] Process : WSMProcess [ Started ] Process : RunRmiRegistry [ Started ] Process : NmsAuthenticationManager [ Started ] Process : APMTracker [ Started ] Process : NmsConfigurationServer [ Started ] Process : StandaloneApplnProcess [ Started ] Process : RunJSPModule [ Started ] Process : AMRBMProcess [ Started ] Process : ApplnStandaloneBE [ Started ] Process : AMDistributionProcess [ Started ] Process : AMCAMProcess [ Started ] Process : NMSSAServer [ Started ] Process : AMServerStartUp [ Started ] Process : NmsAuthManager [ Started ] Process : MapServerBE [ Started ] Process : Collector [ Started ] Process : DBServer [ Started ] Process : AMFaultProcess [ Started ] Process : AMEventProcess [ Started ] Process : MonitorsAdder [ Started ] Process : AMServerFramework [ Started ] Process : AMDataArchiverProcess [ Started ] Process : EventFE [ Started ] Process : AlertFE [ Started ] Process : NmsMainFE [ Started ] Verifying connection with web server... verified Applications Manager started successfully. Please connect your client to the web server on port: 9090

Tweet