[CLOUDSTACK-9284] CloudStack usage service tries to get access to "cloud.event_usage" table only via IP from cloud.usage.host field in db.properties

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.2.1, 4.5.2
• Component/s: Usage
• Security Level: Public (Anyone can view this level - this is the default.)
• Environment: OS - centos6
• Assignee: Unassigned
• Reporter: Dmitriy Pavlov
• Created: 11/Feb/16 12:43
• Updated: 11/Feb/16 12:43

Description

Have tried to separate cloud and cloud_usage databases on two different servers. db.properties file was updated in following way:

db.usage.host=IP_of_remote_server1
db.cloud.host=localhost

Database of cloud_usage was dumped from localhost and imported to the remote mysql server. After that both services cloudstack-usage and cloudstack-management were restarted. Both services started properly, but during next usage running logs shown following error message:

com.cloud.utils.exception.CloudRuntimeException: SELECT command denied to user 'cloud'@'XX.XX.XX.XX' for table 'usage_event'
at com.cloud.event.dao.UsageEventDaoImpl.getMaxEventId(UsageEventDaoImpl.java:209)
at com.cloud.event.dao.UsageEventDaoImpl.getRecentEvents(UsageEventDaoImpl.java:101)
at com.cloud.event.dao.UsageEventDaoImpl_EnhancerByCloudStack_c0063fe7.CGLIB$getRecentEvents$3(<generated>)
at com.cloud.event.dao.UsageEventDaoImpl_EnhancerByCloudStack_c0063fe7_FastClassByCloudStack_48924ead.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
at com.cloud.event.dao.UsageEventDaoImpl_EnhancerByCloudStack_c0063fe7.getRecentEvents(<generated>)
at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:582)
at com.cloud.usage.UsageManagerImpl.runInContextInternal(UsageManagerImpl.java:376)
at com.cloud.usage.UsageManagerImpl$1.runInContext(UsageManagerImpl.java:318)
at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:49)
at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56)
at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103)
at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53)
at org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:46)
at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:315)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

After mysql query logging was enabled I found that usage service was trying to access cloud.usage_event table (from 'cloud' database, not cloud_usage) on the remote mysql server where I want to keep only one database 'cloud_usage'. Same error was reproduce on CS 4.2.1 and CS 4.5.2 versions.
The main question is why usage service tries to get information from 'cloud' database using IP address which was configured in db.usage.host field in place of db.cloud.host ?

Have posted this issue to user's mail list, but got only suggestion to place a bug http://mail-archives.apache.org/mod_mbox/cloudstack-users/201601.mbox/browser