Open Stack

You need to run:

  ceilometer-dbsync --config-file /etc/ceilometer/ceilometer.conf

in order to create the required schema in the database.

Cheers,
Eoghan

----- Original Message -----
> 
> 
> Hi all,
> 
> 
> 
> I am trying to use mysql as database for ceilometer. I created database as
> follows
> 
> CREATE DATABASE ceilometer;
> 
> 
> 
> GRANT ALL PRIVILEGES ON ceilometer.* TO 'ceilometer'@'localhost' \
> 
> IDENTIFIED BY 'CEILOMETER_DBPASS';
> 
> 
> 
> GRANT ALL PRIVILEGES ON ceilometer.* TO 'ceilometer'@'%' \
> 
> IDENTIFIED BY 'CEILOMETER_DBPASS';
> 
> 
> 
> And mentioned it in ceilometer conf file.
> 
> connection=mysql://ceilometer:CEILOMETER_DBPASS@100.30.30.221/ceilometer?charset=utf8
> 
> 
> 
> But ceilometer collector is failing to create metering data
> 
> 
> 
> root at koteswar-ice-osc:~# ceilometer meter-list
> 
> WARNING (http:172) Request returned failure status.
> 
> HTTPInternalServerError (HTTP 500)
> 
> 
> 
> LOG:
> 
> 2014-06-01 22:26:41.220 32219 ERROR ceilometer.dispatcher.database
> [req-c0453bd8-2849-4cfb-9698-3032f65e4d32 - - - - -] Failed to record
> metering data: (ProgrammingError) (1146, "Table 'ceilometer.source' doesn't
> exist") 'SELECT source.id AS source_id \nFROM source \nWHERE source.id = %s'
> ('openstack',)
> 
> 2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database Traceback
> (most recent call last):
> 
> 2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database File
> "/usr/lib/python2.7/dist-packages/ceilometer/dispatcher/database.py", line
> 67, in record_metering_data
> 
> 2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database
> self.storage_conn.record_metering_data(meter)
> 
> 2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database File
> "/usr/lib/python2.7/dist-packages/ceilometer/storage/impl_sqlalchemy.py",
> line 322, in record_metering_data
> 
> 2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database
> data['source'])
> 
> 
> 
> Am I missed anything here? Please give me some pointers to “how to use mysql
> for celometer”.
> 
> It is working fine with mongoDB but failing with MYSQL with the above errors.
> 
> 
> 
> Thanks in advance,
> 
> Koteswar
> 
> _______________________________________________
> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to     : openstack at lists.openstack.org
> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>