[jira] [Comment Edited] (CLOUDSTACK-5613) CloudStack 4.2.0 - Usage server is running but tables remain empty

["Guy Beaupré (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-5613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13857370#comment-13857370 ] 

Guy Beaupré edited comment on CLOUDSTACK-5613 at 12/27/13 7:40 AM:
-------------------------------------------------------------------

Additional Information:

I have tried the following setup in db.properties under /etc/cloudstack/usage:

### usage database settings
db.usage.username=cloud
db.usage.password=ENC(sDrl+Mn6Lni+epWVJOhaNS8BwW8PR4uK)

db.usage.host=localhost
db.usage.port=3306
db.usage.name=cloud_usage

### usage database tuning parameters
db.usage.maxActive=100
db.usage.maxIdle=30
db.usage.maxWait=10000
db.usage.autoReconnect=true

Still no luck....


was (Author: beauprgu):
Additional Information:

I have tried the following setup in db.properties under /etc/cloudstack/usage:

# usage database settings
db.usage.username=cloud
db.usage.password=ENC(sDrl+Mn6Lni+epWVJOhaNS8BwW8PR4uK)

db.usage.host=localhost
db.usage.port=3306
db.usage.name=cloud_usage

# usage database tuning parameters
db.usage.maxActive=100
db.usage.maxIdle=30
db.usage.maxWait=10000
db.usage.autoReconnect=true

Still no luck....

> CloudStack 4.2.0 - Usage server is running but tables remain empty
> ------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-5613
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5613
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Usage
>    Affects Versions: 4.2.0
>         Environment: Ubuntu 12.04.03 LTS
>            Reporter: Guy Beaupré
>            Priority: Blocker
>
> CloudStack Usage service is installed and reported as running by Ubuntu 12.04.03 LTS but usage tables remains empty.
> I have tried to install cloudstack-usage from the source and the provided package ( .deb ) but I get the same issue.
> CloudStack event manager report the following even if Ubuntu is showing "running":
> No usage server process running
> An internet colleague reported the same issue with Ubuntu 12.04.03 and confirmed that it is working with CentOS.
> Supplemental Information:
> 1. Usage server is running:
>  
>      service cloudstack-usage status
>  
>         * cloudstack-usage is running
>  
>  2. Management log shows:
>  
> [cloud.ha.HighAvailabilityManagerImpl] (HA-1:null)  checking health of usage server
>  
> [cloud.ha.HighAvailabilityManagerImpl] (HA-1:null) usage server
> running? false, heartbeat: null
>  
> [apache.cloudstack.alerts] (HA-1:null)  alertType:
>  
> : 13 // dataCenterId:: 0 // podId:: 0 // clusterId:: null // message:: No usage server process running
>  



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)