Open Stack

> OperationalError: (OperationalError) unable to open database file None None

Your config file implies mongodb usage for the metering store:

  [database]
  connection = mongodb://ceilometer:ceilometer@controller:27017/ceilometer

Is mongo installed and running the expected host & port? (controller:27017)

----- Original Message -----
> Hi
> 
> please find the log file for ceilometer api
> 
> [root at controller ceilometer]# tailf /var/log/ceilometer/api.log
> 2014-05-27 15:16:30.236 4914 WARNING keystoneclient.middleware.auth_token
> [-] Configuring auth_uri to point to the public identity endpoint is
> required; clients may not be able to authenticate against an admin endpoint
> 2014-05-27 15:16:30.237 4914 INFO keystoneclient.middleware.auth_token [-]
> Using /tmp/keystone-signing-FvjNMu as cache directory for signing
> certificate
> 2014-05-27 15:16:30.654 4914 CRITICAL ceilometer [-] OperationalError:
> (OperationalError) unable to open database file None None
> 
> 2014-05-27 15:19:08.520 4950 INFO keystoneclient.middleware.auth_token [-]
> Starting keystone auth_token middleware
> 2014-05-27 15:19:08.521 4950 WARNING keystoneclient.middleware.auth_token
> [-] Configuring admin URI using auth fragments. This is deprecated, use
> 'identity_uri' instead.
> 2014-05-27 15:19:08.521 4950 WARNING keystoneclient.middleware.auth_token
> [-] Configuring auth_uri to point to the public identity endpoint is
> required; clients may not be able to authenticate against an admin endpoint
> 2014-05-27 15:19:08.523 4950 INFO keystoneclient.middleware.auth_token [-]
> Using /tmp/keystone-signing-14uzsO as cache directory for signing
> certificate
> 2014-05-27 15:19:08.913 4950 CRITICAL ceilometer [-] OperationalError:
> (OperationalError) unable to open database file None None
> 
> please find the log file for ceilometer central.
> 
> 2014-05-27 15:19:59.182 4969 ERROR ceilometer.openstack.common.threadgroup
> [-] coercing to Unicode: need string or buffer, NoneType found
> 2014-05-27 15:19:59.182 4969 TRACE ceilometer.openstack.common.threadgroup
> Traceback (most recent call last):
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup   File
> "/usr/lib/python2.6/site-packages/ceilometer/openstack/common/threadgroup.py",
> line 125, in wait
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup     x.wait()
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup   File
> "/usr/lib/python2.6/site-packages/ceilometer/openstack/common/threadgroup.py",
> line 47, in wait
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup     return self.thread.wait()
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup   File
> "/usr/lib/python2.6/site-packages/eventlet/greenthread.py", line 168, in
> wait
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup     return self._exit_event.wait()
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup   File
> "/usr/lib/python2.6/site-packages/eventlet/event.py", line 116, in wait
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup     return hubs.get_hub().switch()
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup   File
> "/usr/lib/python2.6/site-packages/eventlet/hubs/hub.py", line 187, in switch
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup     return self.greenlet.switch()
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup   File
> "/usr/lib/python2.6/site-packages/eventlet/greenthread.py", line 194, in
> main
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup     result = function(*args,
> **kwargs)
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup   File
> "/usr/lib/python2.6/site-packages/ceilometer/openstack/common/service.py",
> line 486, in run_service
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup     service.start()
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup   File
> "/usr/lib/python2.6/site-packages/ceilometer/agent.py", line 137, in start
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup     self.pipeline_manager =
> pipeline.setup_pipeline()
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup   File
> "/usr/lib/python2.6/site-packages/ceilometer/pipeline.py", line 524, in
> setup_pipeline
> 2014-05-27 15:19:59.182 4969 TRACE
> ceilometer.openstack.common.threadgroup     with open(cfg_file) as fap:
> 2014-05-27 15:19:59.182 4969 TRACE ceilometer.openstack.common.threadgroup
> TypeError: coercing to Unicode: need string or buffer, NoneType found
> 2014-05-27 15:19:59.182 4969 TRACE ceilometer.openstack.common.threadgroup
> (END)
> 
> 
> Regards,
> Dhanesh
> 
> 
> On Tue, May 27, 2014 at 2:49 PM, Eoghan Glynn <eglynn at redhat.com> wrote:
> 
> >
> > Set debug=True and verbose=True in your ceilometer.conf.
> >
> > Restart the ceilometer API service.
> >
> > Check /var/log/ceilometer/api.log for errors.
> >
> > Similarly for the central agent.
> >
> > ----- Original Message -----
> > > Hi All,
> > >
> > >
> > > 8777 port is not up i started all the service.
> > >
> > > I have followed the icehouse document for fedora.
> > >
> > >
> > > [root at controller ~]# /etc/init.d/openstack-ceilometer-api restart
> > > Stopping openstack-ceilometer-api:                         [FAILED]
> > > Starting openstack-ceilometer-api:                         [  OK  ]
> > > [root at controller ~]# /etc/init.d/openstack-ceilometer-api restart
> > > Stopping openstack-ceilometer-api:                         [  OK  ]
> > > Starting openstack-ceilometer-api:                         [  OK  ]
> > > [root at controller ~]# netstat -atlpn | grep 8777
> > >
> > > note: not showing the 8777 port
> > >
> > > ceilometer service  status
> > >
> > >
> > > [root at controller ~]# /etc/init.d/openstack-ceilometer-api status
> > > openstack-ceilometer-api dead but pid file exists
> > >
> > > [root at controller ~]# /etc/init.d/openstack-ceilometer-central status
> > > openstack-ceilometer-central dead but pid file exists
> > >
> > > [root at controller ~]# /etc/init.d/openstack-ceilometer-collector status
> > > openstack-ceilometer-collector (pid  8905) is running...
> > >
> > > [root at controller ~]# /etc/init.d/openstack-ceilometer-notification
> > status
> > > openstack-ceilometer-agent-notification (pid  10307) is running...
> > >
> > >
> > > [root at controller ~]# /etc/init.d/openstack-ceilometer-alarm-notifier
> > status
> > > openstack-ceilometer-alarm-notifier (pid  8947) is running...
> > >
> > > [root at controller ~]# /etc/init.d/openstack-ceilometer-alarm-evaluator
> > status
> > > openstack-ceilometer-alarm-evaluator (pid  8926) is running...
> > >
> > >
> > >
> > >
> > >
> > > Attaching the ceilometer.conf file along with this mail. Please fing the
> > > attachment.
> > >
> > >
> > >
> > > Verify the Telemetry installation
> > >
> > > To test the Telemetry installation, download an image from the Image
> > > Service, and use the *ceilometer* command to display usage statistics.
> > >
> > >    1.
> > >
> > >    Use the ceilometer meter-list command to test the access to Telemetry:
> > >
> > >    $ ceilometer meter-list
> > >
> > >
> > >
> > > Error:
> > >
> > >  ceilometer meter-list
> > > Error communicating with http://controller:8777 [Errno 111] Connection
> > > refused
> > >
> > >
> > > Regards,
> > > Dhanesh.
> > >
> > >
> > > On Tue, May 20, 2014 at 3:04 PM, Eoghan Glynn <eglynn at redhat.com> wrote:
> > >
> > > >
> > > > What's your configured database connection?
> > > >
> > > > (in /etc/ceilometer/ceilometer.conf)
> > > >
> > > > If its a sqlalchemy-based URL (e.g. mysql or postgres) have you run
> > > > ceilometer-dbsync?
> > > >
> > > > (either directly, or a side-effect of the installation process)
> > > >
> > > >
> > > > ----- Original Message -----
> > > > > Hi All,
> > > > >
> > > > > ps -fe | grep ceilometer-api
> > > > >
> > > > > No process is running.
> > > > >
> > > > > status is showing its dead.
> > > > >
> > > > >
> > > > > Api Error log.
> > > > >
> > > > > [root at controller ceilometer]# tailf api.log
> > > > > 2014-05-20 14:42:39.476 10768 WARNING
> > > > keystoneclient.middleware.auth_token
> > > > > [-] Configuring auth_uri to point to the public identity endpoint is
> > > > > required; clients may not be able to authenticate against an admin
> > > > endpoint
> > > > > 2014-05-20 14:42:39.477 10768 INFO
> > keystoneclient.middleware.auth_token
> > > > [-]
> > > > > Using /tmp/keystone-signing-w05DPS as cache directory for signing
> > > > > certificate
> > > > > 2014-05-20 14:42:39.877 10768 CRITICAL ceilometer [-]
> > OperationalError:
> > > > > (OperationalError) unable to open database file None None
> > > > >
> > > > > 2014-05-20 14:49:47.686 12502 INFO
> > keystoneclient.middleware.auth_token
> > > > [-]
> > > > > Starting keystone auth_token middleware
> > > > > 2014-05-20 14:49:47.687 12502 WARNING
> > > > keystoneclient.middleware.auth_token
> > > > > [-] Configuring admin URI using auth fragments. This is deprecated,
> > use
> > > > > 'identity_uri' instead.
> > > > > 2014-05-20 14:49:47.687 12502 WARNING
> > > > keystoneclient.middleware.auth_token
> > > > > [-] Configuring auth_uri to point to the public identity endpoint is
> > > > > required; clients may not be able to authenticate against an admin
> > > > endpoint
> > > > >
> > > > > 2014-05-20 14:49:47.688 12502 INFO
> > keystoneclient.middleware.auth_token
> > > > [-]
> > > > > Using /tmp/keystone-signing-zXbRzr as cache directory for signing
> > > > > certificate
> > > > > 2014-05-20 14:49:48.080 12502 CRITICAL ceilometer [-]
> > OperationalError:
> > > > > (OperationalError) unable to open database file None None
> > > > >
> > > > >
> > > > >
> > > > > Regards,
> > > > > Dhanesh.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > On Tue, May 20, 2014 at 1:29 PM, Eoghan Glynn <eglynn at redhat.com>
> > wrote:
> > > > >
> > > > > >
> > > > > >
> > > > > > > Hi All,
> > > > > > >
> > > > > > > Please find the error iam getting after finishing the ceilometer
> > > > > > > configuration in controller and compute.
> > > > > > >
> > > > > > > Error:
> > > > > > >
> > > > > > > [root at compute1 ceilometer]# ceilometer meter-list
> > > > > > > Error communicating with http://controller:8777 [Errno 111]
> > > > Connection
> > > > > > > refused
> > > > > > >
> > > > > > > I have started all the services. I noticed 8777 port is not
> > > > listening.
> > > > > > >
> > > > > > > Please gimme some advice.
> > > > > >
> > > > > > Check if the ceilometer-api service is actually running on the
> > expected
> > > > > > node.
> > > > > >
> > > > > > e.g. on Fedora and derivatives with RPMs installed:
> > > > > >
> > > > > >   $ sudo service openstack-ceilometer-api status
> > > > > >
> > > > > > elsewhere:
> > > > > >
> > > > > >   $ ps -fe | grep ceilometer-api
> > > > > >
> > > > > > Also check your firewall rules to ensure that the ceilometer-api
> > > > endpoint
> > > > > > (i.e. port 8777) is accessible from the host on which you run the
> > > > client.
> > > > > >
> > > > > > Cheers,
> > > > > > Eoghan
> > > > > >
> > > > > > > I have finished almost all except ceilometer.
> > > > > > >
> > > > > > > Attaching the output of #ceilometer --debug meter-list
> > > > > > >
> > > > > > > Regards,
> > > > > > > Dhanesh
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>