Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Cloudkitty install error on mitaka

Hello.

I am trying to install Cloudkitty on OpenStack Mitaka. and got the db permission error.

[DEFAULT]
verbose = True
log_dir = /var/log/cloudkitty

[oslo_messaging_rabbit]
rabbit_userid = guest
rabbit_password = guest
rabbit_hosts = controller:5672

[auth]
username = cloudkitty
password = cloudkitty
tenant = services
region = RegionOne
url = http://controller:5000/v2.0

[keystone_authtoken]
username = cloudkitty
password = cloudkitty
project_name = services
region = RegionOne
auth_url = http://controller:5000/v2.0
auth_plugin = password
identity_uri=http://controller:35357

[database]
connection = mysql://cloudkitty:cloudkitty@controller/cloudkitty

[keystone_fetcher]
username = admin
password = adminpass from keystonerc_admin
tenant = admin
region = RegionOne
url = http://controller:5000/v2.0

[ceilometer_collector]
username = cloudkitty
password = cloudkitty 
tenant = services
region = RegionOne
url = http://controller:5000

This is my /etc/cloudkitty/cloudkitty.conf file.

mysql -uroot -p
 CREATE DATABASE cloudkitty;
 GRANT ALL PRIVILEGES ON cloudkitty.* TO 'cloudkitty'@'controller' IDENTIFIED BY 'cloudkitty';

and i made "cloudkitty" database like this.

   # cloudkitty-dbsync upgrade

than, i tried to dbsync.

  Option "verbose" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
CRITI [cloudkitty] OperationalError: (_mysql_exceptions.OperationalError) (1044, "Access denied for user 'cloudkitty'@'192.168.1.26' to database 'cloudkitty'")
Traceback (most recent call last):
  File "/bin/cloudkitty-dbsync", line 10, in <module>
    sys.exit(main())
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 143, in main
    CONF.command.func()
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 94, in upgrade
    self._version_change('upgrade')
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 91, in _version_change
    func(revision)
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/sqlalchemy/migration.py", line 27, in upgrade
    return migration.upgrade(config, revision)
  File "/usr/lib/python2.7/site-packages/cloudkitty/common/db/alembic/migration.py", line 37, in upgrade
    return alembic.command.upgrade(config, version or 'head')
  File "/usr/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade
    script.run_env()
  File "/usr/lib/python2.7/site-packages/alembic/script/base.py", line 397, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/usr/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/sqlalchemy/alembic/env.py", line 25, in <module>
    env.run_migrations_online(target_metadata, version_table)
  File "/usr/lib/python2.7/site-packages/cloudkitty/common/db/alembic/env.py", line 37, in run_migrations_online
    engine = db.get_engine()
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/__init__.py", line 32, in get_engine
    facade = _create_facade_lazily()
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/__init__.py", line 27, in _create_facade_lazily
    _FACADE = session.EngineFacade.from_config(cfg.CONF, sqlite_fk=True)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1056, in from_config
    expire_on_commit=expire_on_commit, _conf=conf)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 977, in __init__
    slave_connection=slave_connection)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 338, in _start
    engine_args, maker_args)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 362, in _setup_for_connection
    sql_connection=sql_connection, **engine_kwargs)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 152, in create_engine
    test_conn = _test_connection(engine, max_retries, retry_interval)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 326, in _test_connection
    return engine.connect()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in connect
    return self._connection_cls(self, **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in __init__
    if connection is not None else engine.raw_connection()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
    self.pool.unique_connection, _connection)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect
    e, dialect, self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection
    util.raise_from_cause(newraise, exc_info)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
    return fn()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 318, in unique_connection
    return _ConnectionFairy._checkout(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 480, in checkout
    rec = pool._do_get()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1060, in _do_get
    self._dec_overflow()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1057, in _do_get
    return self._create_connection()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 323, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 449, in __init__
    self.connection = self.__connect()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 607, in __connect
    connection = self.__pool._invoke_creator(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 97, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 385, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (_mysql_exceptions.OperationalError) (1044, "Access denied for user 'cloudkitty'@'controller' to database 'cloudkitty'")

...and this is what i got.

I just followed the install guide on OpenStack docs. (http://docs.openstack.org/developer/cloudkitty/installation.html)

What did i wrong? I need a help.

Thanks.

Cloudkitty install error on mitaka

Hello.

I am trying to install Cloudkitty on OpenStack Mitaka. and got the db permission error.error. I will show my whole step that i did. Help me to solve the problem.

git clone git://git.openstack.org/openstack/cloudkitty
cd cloudkitty
python setup.py install

mkdir /etc/cloudkitty

I git cloned cloudkitty from github like this.

[DEFAULT]
verbose = True
log_dir = /var/log/cloudkitty

[oslo_messaging_rabbit]
rabbit_userid = guest
rabbit_password = guest
rabbit_hosts = controller:5672

[auth]
username = cloudkitty
password = cloudkitty
tenant = services
region = RegionOne
url = http://controller:5000/v2.0

[keystone_authtoken]
username = cloudkitty
password = cloudkitty
project_name = services
region = RegionOne
auth_url = http://controller:5000/v2.0
auth_plugin = password
identity_uri=http://controller:35357

[database]
connection = mysql://cloudkitty:cloudkitty@controller/cloudkitty

[keystone_fetcher]
username = admin
password = adminpass from keystonerc_admin
tenant = admin
region = RegionOne
url = http://controller:5000/v2.0

[ceilometer_collector]
username = cloudkitty
password = cloudkitty 
tenant = services
region = RegionOne
url = http://controller:5000

This is my /etc/cloudkitty/cloudkitty.conf file.

mysql -uroot -p
 CREATE DATABASE cloudkitty;
 GRANT ALL PRIVILEGES ON cloudkitty.* TO 'cloudkitty'@'controller' IDENTIFIED BY 'cloudkitty';

and i made "cloudkitty" database like this.

   # cloudkitty-dbsync upgrade

than, i tried to dbsync.

  Option "verbose" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
CRITI [cloudkitty] OperationalError: (_mysql_exceptions.OperationalError) (1044, "Access denied for user 'cloudkitty'@'192.168.1.26' to database 'cloudkitty'")
Traceback (most recent call last):
  File "/bin/cloudkitty-dbsync", line 10, in <module>
    sys.exit(main())
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 143, in main
    CONF.command.func()
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 94, in upgrade
    self._version_change('upgrade')
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 91, in _version_change
    func(revision)
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/sqlalchemy/migration.py", line 27, in upgrade
    return migration.upgrade(config, revision)
  File "/usr/lib/python2.7/site-packages/cloudkitty/common/db/alembic/migration.py", line 37, in upgrade
    return alembic.command.upgrade(config, version or 'head')
  File "/usr/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade
    script.run_env()
  File "/usr/lib/python2.7/site-packages/alembic/script/base.py", line 397, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/usr/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/sqlalchemy/alembic/env.py", line 25, in <module>
    env.run_migrations_online(target_metadata, version_table)
  File "/usr/lib/python2.7/site-packages/cloudkitty/common/db/alembic/env.py", line 37, in run_migrations_online
    engine = db.get_engine()
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/__init__.py", line 32, in get_engine
    facade = _create_facade_lazily()
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/__init__.py", line 27, in _create_facade_lazily
    _FACADE = session.EngineFacade.from_config(cfg.CONF, sqlite_fk=True)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1056, in from_config
    expire_on_commit=expire_on_commit, _conf=conf)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 977, in __init__
    slave_connection=slave_connection)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 338, in _start
    engine_args, maker_args)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 362, in _setup_for_connection
    sql_connection=sql_connection, **engine_kwargs)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 152, in create_engine
    test_conn = _test_connection(engine, max_retries, retry_interval)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 326, in _test_connection
    return engine.connect()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in connect
    return self._connection_cls(self, **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in __init__
    if connection is not None else engine.raw_connection()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
    self.pool.unique_connection, _connection)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect
    e, dialect, self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection
    util.raise_from_cause(newraise, exc_info)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
    return fn()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 318, in unique_connection
    return _ConnectionFairy._checkout(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 480, in checkout
    rec = pool._do_get()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1060, in _do_get
    self._dec_overflow()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1057, in _do_get
    return self._create_connection()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 323, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 449, in __init__
    self.connection = self.__connect()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 607, in __connect
    connection = self.__pool._invoke_creator(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 97, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 385, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (_mysql_exceptions.OperationalError) (1044, "Access denied for user 'cloudkitty'@'controller' to database 'cloudkitty'")

...and this is what i got.

I just followed the install guide on OpenStack docs. (http://docs.openstack.org/developer/cloudkitty/installation.html)

What did i wrong? I need a help.

Thanks.

Cloudkitty install error on mitaka

Hello.

I am trying to install Cloudkitty on OpenStack Mitaka. and got the db permission error. I will show my whole step that i did. Help me to solve the problem.

git clone git://git.openstack.org/openstack/cloudkitty
cd cloudkitty
python setup.py install

mkdir /etc/cloudkitty

I git cloned cloudkitty from github like this.

[DEFAULT]
verbose = True
log_dir = /var/log/cloudkitty

[oslo_messaging_rabbit]
rabbit_userid = guest
rabbit_password = guest
rabbit_hosts = controller:5672

[auth]
username = cloudkitty
password = cloudkitty
tenant = services
region = RegionOne
url = http://controller:5000/v2.0

[keystone_authtoken]
username = cloudkitty
password = cloudkitty
project_name = services
region = RegionOne
auth_url = http://controller:5000/v2.0
auth_plugin = password
identity_uri=http://controller:35357

[database]
connection = mysql://cloudkitty:cloudkitty@controller/cloudkitty

[keystone_fetcher]
username = admin
password = adminpass from keystonerc_admin
tenant = admin
region = RegionOne
url = http://controller:5000/v2.0

[ceilometer_collector]
username = cloudkitty
password = cloudkitty 
tenant = services
region = RegionOne
url = http://controller:5000

This is my /etc/cloudkitty/cloudkitty.conf file.

mysql -uroot -p
 CREATE DATABASE cloudkitty;
 GRANT ALL PRIVILEGES ON cloudkitty.* TO 'cloudkitty'@'controller' IDENTIFIED BY 'cloudkitty';

and i made "cloudkitty" database like this.

   # cloudkitty-dbsync upgrade

than, i tried to dbsync.

  Option "verbose" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
CRITI [cloudkitty] OperationalError: (_mysql_exceptions.OperationalError) (1044, "Access denied for user 'cloudkitty'@'192.168.1.26' to database 'cloudkitty'")
Traceback (most recent call last):
  File "/bin/cloudkitty-dbsync", line 10, in <module>
    sys.exit(main())
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 143, in main
    CONF.command.func()
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 94, in upgrade
    self._version_change('upgrade')
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 91, in _version_change
    func(revision)
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/sqlalchemy/migration.py", line 27, in upgrade
    return migration.upgrade(config, revision)
  File "/usr/lib/python2.7/site-packages/cloudkitty/common/db/alembic/migration.py", line 37, in upgrade
    return alembic.command.upgrade(config, version or 'head')
  File "/usr/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade
    script.run_env()
  File "/usr/lib/python2.7/site-packages/alembic/script/base.py", line 397, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/usr/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/sqlalchemy/alembic/env.py", line 25, in <module>
    env.run_migrations_online(target_metadata, version_table)
  File "/usr/lib/python2.7/site-packages/cloudkitty/common/db/alembic/env.py", line 37, in run_migrations_online
    engine = db.get_engine()
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/__init__.py", line 32, in get_engine
    facade = _create_facade_lazily()
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/__init__.py", line 27, in _create_facade_lazily
    _FACADE = session.EngineFacade.from_config(cfg.CONF, sqlite_fk=True)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1056, in from_config
    expire_on_commit=expire_on_commit, _conf=conf)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 977, in __init__
    slave_connection=slave_connection)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 338, in _start
    engine_args, maker_args)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 362, in _setup_for_connection
    sql_connection=sql_connection, **engine_kwargs)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 152, in create_engine
    test_conn = _test_connection(engine, max_retries, retry_interval)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 326, in _test_connection
    return engine.connect()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in connect
    return self._connection_cls(self, **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in __init__
    if connection is not None else engine.raw_connection()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
    self.pool.unique_connection, _connection)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect
    e, dialect, self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection
    util.raise_from_cause(newraise, exc_info)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
    return fn()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 318, in unique_connection
    return _ConnectionFairy._checkout(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 480, in checkout
    rec = pool._do_get()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1060, in _do_get
    self._dec_overflow()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1057, in _do_get
    return self._create_connection()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 323, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 449, in __init__
    self.connection = self.__connect()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 607, in __connect
    connection = self.__pool._invoke_creator(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 97, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 385, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (_mysql_exceptions.OperationalError) (1044, "Access denied for user 'cloudkitty'@'controller' to database 'cloudkitty'")

...and this is what i got.

I just followed the install guide on OpenStack docs. (http://docs.openstack.org/developer/cloudkitty/installation.html)

What did i wrong? I need a help.

Thanks.

(Solved) Cloudkitty install error on mitaka

Hello.

I am trying to install Cloudkitty on OpenStack Mitaka. and got the db permission error. I will show my whole step that i did. Help me to solve the problem.

git clone git://git.openstack.org/openstack/cloudkitty
cd cloudkitty
python setup.py install

mkdir /etc/cloudkitty

I git cloned cloudkitty from github like this.

[DEFAULT]
verbose = True
log_dir = /var/log/cloudkitty

[oslo_messaging_rabbit]
rabbit_userid = guest
rabbit_password = guest
rabbit_hosts = controller:5672

[auth]
username = cloudkitty
password = cloudkitty
tenant = services
region = RegionOne
url = http://controller:5000/v2.0

[keystone_authtoken]
username = cloudkitty
password = cloudkitty
project_name = services
region = RegionOne
auth_url = http://controller:5000/v2.0
auth_plugin = password
identity_uri=http://controller:35357

[database]
connection = mysql://cloudkitty:cloudkitty@controller/cloudkitty

[keystone_fetcher]
username = admin
password = adminpass from keystonerc_admin
tenant = admin
region = RegionOne
url = http://controller:5000/v2.0

[ceilometer_collector]
username = cloudkitty
password = cloudkitty 
tenant = services
region = RegionOne
url = http://controller:5000

This is my /etc/cloudkitty/cloudkitty.conf file.

mysql -uroot -p
 CREATE DATABASE cloudkitty;
 GRANT ALL PRIVILEGES ON cloudkitty.* TO 'cloudkitty'@'controller' IDENTIFIED BY 'cloudkitty';

and i made "cloudkitty" database like this.

   # cloudkitty-dbsync upgrade

than, i tried to dbsync.

  Option "verbose" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
CRITI [cloudkitty] OperationalError: (_mysql_exceptions.OperationalError) (1044, "Access denied for user 'cloudkitty'@'192.168.1.26' to database 'cloudkitty'")
Traceback (most recent call last):
  File "/bin/cloudkitty-dbsync", line 10, in <module>
    sys.exit(main())
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 143, in main
    CONF.command.func()
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 94, in upgrade
    self._version_change('upgrade')
  File "/usr/lib/python2.7/site-packages/cloudkitty/cli/dbsync.py", line 91, in _version_change
    func(revision)
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/sqlalchemy/migration.py", line 27, in upgrade
    return migration.upgrade(config, revision)
  File "/usr/lib/python2.7/site-packages/cloudkitty/common/db/alembic/migration.py", line 37, in upgrade
    return alembic.command.upgrade(config, version or 'head')
  File "/usr/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade
    script.run_env()
  File "/usr/lib/python2.7/site-packages/alembic/script/base.py", line 397, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/usr/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/sqlalchemy/alembic/env.py", line 25, in <module>
    env.run_migrations_online(target_metadata, version_table)
  File "/usr/lib/python2.7/site-packages/cloudkitty/common/db/alembic/env.py", line 37, in run_migrations_online
    engine = db.get_engine()
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/__init__.py", line 32, in get_engine
    facade = _create_facade_lazily()
  File "/usr/lib/python2.7/site-packages/cloudkitty/db/__init__.py", line 27, in _create_facade_lazily
    _FACADE = session.EngineFacade.from_config(cfg.CONF, sqlite_fk=True)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1056, in from_config
    expire_on_commit=expire_on_commit, _conf=conf)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 977, in __init__
    slave_connection=slave_connection)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 338, in _start
    engine_args, maker_args)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 362, in _setup_for_connection
    sql_connection=sql_connection, **engine_kwargs)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 152, in create_engine
    test_conn = _test_connection(engine, max_retries, retry_interval)
  File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 326, in _test_connection
    return engine.connect()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018, in connect
    return self._connection_cls(self, **kwargs)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in __init__
    if connection is not None else engine.raw_connection()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection
    self.pool.unique_connection, _connection)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect
    e, dialect, self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection
    util.raise_from_cause(newraise, exc_info)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect
    return fn()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 318, in unique_connection
    return _ConnectionFairy._checkout(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 713, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 480, in checkout
    rec = pool._do_get()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1060, in _do_get
    self._dec_overflow()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1057, in _do_get
    return self._create_connection()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 323, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 449, in __init__
    self.connection = self.__connect()
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 607, in __connect
    connection = self.__pool._invoke_creator(self)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 97, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 385, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (_mysql_exceptions.OperationalError) (1044, "Access denied for user 'cloudkitty'@'controller' to database 'cloudkitty'")

...and this is what i got.

I just followed the install guide on OpenStack docs. (http://docs.openstack.org/developer/cloudkitty/installation.html)

What did i wrong? I need a help.

Thanks.