Storage Manager Data Collector 18.1.10.171\u5b89\u88c5\u5728win7x64\u4e0a\uff0c\u9009\u62e9\u5f02\u673aMySQL\uff0c\u5e76\u4e14\u5df2\u5728MySQL\u4e0a\u8fdb\u884c\u76f8\u5173\u914d\u7f6e\uff08\u6570\u636e\u5e93\u3001\u7528\u6237\u3001\u6743\u9650\uff09\uff0c\u800c\u5728\u5b89\u88c5\u7ed3\u675f\u540e\uff0cui\u9875\u9762\u59cb\u7ec8\u63d0\u793a\u7528\u6237\u767b\u9646\u5931\u8d25<\/p>\n
\u5728Dell EMC\\Storage Manager\\msaservice\\etc\\compservices\\compservice \u6587\u4ef6\u4e2d\uff0c\u63d0\u793a<\/p>\n
01\/17\/2019 10:33:57 | ERROR | DManager | Error with database setup (try again in 30 seconds) (192.168.8.130:3306): java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:\/jdbc\/compmsadb\r\ncom.compellent.common.sql.DatabaseConnection.generateDatabaseException(DatabaseConnection.java:220)\r\ncom.compellent.common.sql.DatabaseConnection.getJndiConnection(DatabaseConnection.java:208)\r\ncom.compellent.common.sql.JndiMySQLConnection.getConnection(JndiMySQLConnection.java:35)\r\ncom.compellent.emdatacollector.DataManager.DatabaseManager.startup(DatabaseManager.java:385)\r\ncom.compellent.emdatacollector.DataManager.DataManager.createGlobalDataManager(DataManager.java:185)\r\ncom.compellent.emdatacollector.MainBean.start(MainBean.java:552)\r\nsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\nsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\nsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\njava.lang.reflect.Method.invoke(Method.java:498)\r\norg.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)\r\norg.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)\r\norg.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)\r\norg.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)\r\norg.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)\r\norg.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)\r\norg.jboss.as.ejb3.concurrency.ContainerManagedConcurrencyInterceptor.processInvocation(ContainerManagedConcurrencyInterceptor.java:104)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)\r\norg.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:55)\r\norg.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)\r\norg.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:52)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:273)\r\norg.jboss.as.ejb3.tx.CMTTxInterceptor.requiresNew(CMTTxInterceptor.java:369)\r\norg.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:241)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)\r\norg.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:448)\r\norg.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)\r\norg.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)\r\norg.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)\r\norg.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.component.interceptors.LogDiagnosticContextRecoveryInterceptor.processInvocation(LogDiagnosticContextRecoveryInterceptor.java:79)\r\norg.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)\r\norg.jboss.as.ejb3.component.interceptors.AsyncFutureInterceptorFactory$1$2.runInvocation(AsyncFutureInterceptorFactory.java:97)\r\norg.jboss.as.ejb3.component.interceptors.AsyncInvocationTask.run(AsyncInvocationTask.java:73)\r\njava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\njava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\r\njava.lang.Thread.run(Thread.java:745)\r\norg.jboss.threads.JBossThread.run(JBossThread.java:122)<\/pre>\n\u5f02\u673aMySQL \u4e0a\u914d\u7f6e\u00a0general_log=1 \u53c2\u6570\u540e\uff0c\u65e5\u5fd7\u8f93\u51fa\u5982\u4e0b<\/p>\n
compmsauser@192.168.180.16 as anonymous on<\/pre>\n\u8fd9\u5c31\u5f88\u8be1\u5f02\u4e86\uff0c\u548c\u6211\u8bbe\u7f6e\u7684\u7528\u6237\u540d\u5b8c\u5168\u4e0d\u540c<\/p>\n
\u65e2\u7136\u7528\u6237\u540d\u4e0d\u4e00\u6837\u4e86\uff0c\u90a3\u4e48\u5bc6\u7801\u548c\u6743\u9650\u4e5f\u4e00\u5b9a\u8981\u91cd\u65b0\u505a\u4e86\u3002\u5bc6\u7801\u6211\u901a\u8fc7\u9010\u4e2a\u8bfbData Collector\u5b89\u88c5\u540e\u7684\u6587\u4ef6\u83b7\u53d6\uff0c\u6bd4\u5982<\/p>\n
\u5b89\u88c5\u76ee\u5f55configuration\\standalone_xml_history\\standalone.boot\u4e2d\u5b58\u5728\uff1a<\/p>\n
<datasource jta=\"false\" jndi-name=\"java:\/jdbc\/compmsadb\" pool-name=\"compmsadb\" enabled=\"true\" use-ccm=\"false\">\r\n <connection-url>jdbc:mysql:\/\/192.168.8.130:3306\/compmsadb?allowMultiQueries=true<\/connection-url>\r\n <driver-class>org.mariadb.jdbc.Driver<\/driver-class>\r\n <driver>mariadb<\/driver>\r\n <security>\r\n <user-name>compmsauser<\/user-name>\r\n <password>${VAULT::passwords::compmsadb::1}<\/password>\r\n <\/security>\r\n <validation>\r\n <valid-connection-checker class-name=\"org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker\"\/>\r\n <validate-on-match>true<\/validate-on-match>\r\n <background-validation>false<\/background-validation>\r\n <stale-connection-checker class-name=\"org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLStaleConnectionChecker\"\/>\r\n <exception-sorter class-name=\"org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter\"\/>\r\n <\/validation>\r\n <statement>\r\n <share-prepared-statements>false<\/share-prepared-statements>\r\n <\/statement>\r\n<\/datasource><\/pre>\n\u770b\u5230\u4e86\u8fd9\u6837\u7684\u4fe1\u606f\uff0c\u80fd\u591f\u786e\u5b9a\u7528\u6237\u662f compmsauser \u5bc6\u7801\u662f compmsadb DB\u662f\u00a0compmsadb<\/p>\n
\u5728MySQL\u4e0a\u521b\u5efa\u8be5\u7528\u6237\u540e\uff0c\u5b89\u88c5\u4ecd\u7136\u5931\u8d25\uff0c\u5728MySQL\u65e5\u5fd7\u4e2d\uff1a<\/p>\n
284 Connect compmsauser@192.8.180.16 as anonymous on compmsadb\r\n284 Connect Access denied for user 'compmsauser'@'192.168.8.16' (using password: YES)\r\n285 Connect compmsauser@192.168.8.16 as anonymous on compmsadb\r\n285 Connect Access denied for user 'compmsauser'@'192.168.8.16' (using password: YES)\r\n286\u3000GRANT ALL PRIVILEGES ON compmsadb.* TO compmsauser@'%' IDENTIFIED BY 'R3p0r!cty4sgs'<\/pre>\n\u731c\u6d4bData Collector\u5e76\u4e0d\u4f1a\u6309\u7167\u754c\u9762\u586b\u5199\u5185\u5bb9\u53bb\u8fde\u63a5\u6570\u636e\u5e93<\/p>\n
\u5c06\u6388\u6743\u8bed\u53e5\u624b\u5de5\u6267\u884c<\/p>\n
GRANT ALL PRIVILEGES ON compmsadb.* TO compmsauser@'%' IDENTIFIED BY 'R3p0r!cty4sgs'<\/pre>\n\u5728\u5b89\u88c5\u9875\u9762\u4e2d\u586b\u5199\u00a0 R3p0r!cty4sgs<\/p>\n
\u5b89\u88c5\u80fd\u591f\u987a\u5229\u901a\u8fc7<\/p>\n
\u53ef\u4ee5\u5728\u6570\u636e\u5e93\u4e2d\u770b\u5230\u76f8\u5173\u6570\u636e\u8868\uff0c\u5e76\u4e14\u8f6f\u4ef6\u4e5f\u53ef\u4ee5\u767b\u9646\u4e86<\/p>\n
MariaDB [compmsadb]> show tables;\r\n+----------------------------------------------+\r\n| Tables_in_compmsadb |\r\n+----------------------------------------------+\r\n| API_EmAutomatedReportConfiguration |\r\n| API_EmAutomatedReportSettings |\r\n| API_EmDataCollectorUsage |\r\n| API_EmDirectoryService |\r\n| API_EmIoUsageComparisonSelections |\r\n| API_FluidCacheCluster |\r\n| API_FluidCacheClusterIoUsage |\r\n| API_FluidCacheClusterStorageUsage |\r\n| API_FluidCacheDeviceIoUsage |\r\n| API_FluidCacheDeviceStorageUsage |\r\n| API_FluidCacheServer |\r\n| API_FluidCacheServerIoUsage |\r\n| API_FluidCacheServerStorageUsage |\r\n| API_FluidCacheVolumeIoUsage |\r\n| API_FluidCacheVolumeStorageUsage |\r\n| API_FluidFsCluster |\r\n| API_FluidFsClusterCapacityStatistics |\r\n| API_FluidFsClusterTrafficStatisticsRate |\r\n| API_FluidFsControllerLoadBalancingStatistics |\r\n| API_FluidFsControllerTrafficStatisticsRate |\r\n| API_FluidFsNasVolumeStatus |\r\n| API_FluidFsVolumesCapacity |\r\n| API_StorageCenter |\r\n| API_StorageCenterStorageUsage |\r\n| ApiApplicationTracker |\r\n| ApiCommandTracker |\r\n| ApiMethodCall |\r\n| ApiSession |\r\n| ApiSourceTracker |\r\n| ApiUserTracker |\r\n| AuthInitStats |\r\n| CBDepartment |\r\n| CBDepartmentStats |\r\n| CBDeptmentLineItem |\r\n| CBDeptmentLineItemStats |\r\n| CBDiskClass |\r\n| CBDiskClassStats |\r\n| CBRun |\r\n| CBSystemStats |\r\n| CBTier |\r\n| CBVolume |\r\n| CBVolumeFolder |\r\n| CBVolumeFolderStats |\r\n| CBVolumeStats |\r\n| ControllerStats |\r\n| DSM_CONFIG |\r\n| DiskStats |\r\n| DiskTierStats |\r\n| EMAutomatedReport |\r\n| EMAutomatedSubReport |\r\n| EMChartAlert |\r\n| EMEvent |\r\n| EMEvent_LOG |\r\n| EMServerAgentClusterVolume |\r\n| EMServerAgentClusterVolumeStats |\r\n| EMServerAgentVolume |\r\n| EMServerAgentVolumeCompMap |\r\n| EMServerAgentVolumeStats |\r\n| EMSpaceRecoveryRun |\r\n| EMThresholdAlert |\r\n| EMThresholdDefinition |\r\n| EMThresholdObject |\r\n| EMThresholdQuery |\r\n| EmServerAgentFolder |\r\n| EmServerAgentServer |\r\n| FaultDomainStats |\r\n| FluidFsClusterV3 |\r\n| GrowthDiskTier |\r\n| GrowthSystem |\r\n| GrowthVolume |\r\n| LPortTStats |\r\n| LegacyFluidFsClusterScCluster |\r\n| LocalPortStats |\r\n| LogObject |\r\n| NasServerStats |\r\n| PagepoolStats |\r\n| QoSStats |\r\n| QosProfileStats |\r\n| ReplicationStats |\r\n| SCAlertObject |\r\n| SaNasServer |\r\n| SaServerCluster |\r\n| SaServerCompMap |\r\n| SanHqServer |\r\n| ServerFolderStats |\r\n| ServerStats |\r\n| StorageConsumption |\r\n| StorageContainerStats |\r\n| StorageDisk |\r\n| StorageDiskFolderTier |\r\n| StoragePPClass |\r\n| StoragePPTier |\r\n| StoragePagepool |\r\n| StorageProfileStats |\r\n| StorageReplayProfile |\r\n| StorageRsProfileStats |\r\n| StorageServer |\r\n| StorageServerFolder |\r\n| StorageStorageCenter |\r\n| StorageStorageContainer |\r\n| StorageVolFolder |\r\n| StorageVolume |\r\n| StrorageDiskFol |\r\n| SystemStats |\r\n| VASA_PROPERTIES |\r\n| VVOL_METADATA |\r\n| VmCluster |\r\n| VmHostServer |\r\n| VmManagementServer |\r\n| VmVirtualMachine |\r\n| VmVolume |\r\n| VolumeFolderStats |\r\n| VolumeStats |\r\n+----------------------------------------------+\r\n113 rows in set (0.00 sec)<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Storage Manager Data Collector …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[13,1],"tags":[],"class_list":["post-379","post","type-post","status-publish","format-standard","hentry","category-mysql","category-uncategorized"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7zRbQ-67","_links":{"self":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=379"}],"version-history":[{"count":3,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/379\/revisions"}],"predecessor-version":[{"id":382,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/379\/revisions\/382"}],"wp:attachment":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}