<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hi all,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am trying to use mysql as database for ceilometer. I created database as follows<o:p></o:p></p>
<p class="MsoNormal">CREATE DATABASE ceilometer;<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">GRANT ALL PRIVILEGES ON ceilometer.* TO 'ceilometer'@'localhost' \<o:p></o:p></p>
<p class="MsoNormal">IDENTIFIED BY 'CEILOMETER_DBPASS';
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">GRANT ALL PRIVILEGES ON ceilometer.* TO 'ceilometer'@'%' \<o:p></o:p></p>
<p class="MsoNormal">IDENTIFIED BY 'CEILOMETER_DBPASS';<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">And mentioned it in ceilometer conf file.<o:p></o:p></p>
<p class="MsoNormal">connection=mysql://ceilometer:CEILOMETER_DBPASS@100.30.30.221/ceilometer?charset=utf8<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">But ceilometer collector is failing to create metering data <o:p>
</o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">root@koteswar-ice-osc:~# ceilometer meter-list<o:p></o:p></p>
<p class="MsoNormal">WARNING (http:172) Request returned failure status.<o:p></o:p></p>
<p class="MsoNormal">HTTPInternalServerError (HTTP 500)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">LOG:<o:p></o:p></p>
<p class="MsoNormal">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',)<o:p></o:p></p>
<p class="MsoNormal">2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database Traceback (most recent call last):<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database self.storage_conn.record_metering_data(meter)<o:p></o:p></p>
<p class="MsoNormal">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<o:p></o:p></p>
<p class="MsoNormal">2014-06-01 22:26:41.220 32219 TRACE ceilometer.dispatcher.database data['source'])<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Am I missed anything here? Please give me some pointers to “how to use mysql for celometer”.<o:p></o:p></p>
<p class="MsoNormal">It is working fine with mongoDB but failing with MYSQL with the above errors.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks in advance,<o:p></o:p></p>
<p class="MsoNormal">Koteswar<o:p></o:p></p>
</div>
</body>
</html>