Unable to install designate - In Openstack Ubuntu 14.04 - Liberty

asked 2016-03-18 01:59:38 -0500

ajithpathiyil gravatar image

updated 2016-03-18 02:10:58 -0500

Hi All,

WHile installing designate in my openstack environment, I am receiving the below error. Any help should be appreciated.

"(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] ECONNREFUSED)")"

---------------Terminal Snippet Begins------------------------------------------------
 root@controller:~# apt-get install designate
Reading package lists... Done
Building dependency tree       
Reading state information... Done
designate is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 242 not upgraded.
5 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up designate-common (1:1.0.0-0ubuntu1~cloud0) ...
PKG-Openstack now calling: dbc_go designate-common configure
dbconfig-common: writing config to /etc/dbconfig-common/designate-common.conf
granting access to database designatedb for designate-common@localhost: already exists.
creating database designatedb: already exists.
dbconfig-common: flushing administrative password
Now doing 'designate-manage database sync': this may take a while...
Option "verbose" from group "DEFAULT" is deprecated for removal.  Its value may be silently ignored in the future.
2016-03-18 12:06:32.435 1075 CRITICAL designate [designate-manage - - - - -] OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] ECONNREFUSED)")
2016-03-18 12:06:32.435 1075 ERROR designate Traceback (most recent call last):
2016-03-18 12:06:32.435 1075 ERROR designate   File "/usr/bin/designate-manage", line 10, in <module>
2016-03-18 12:06:32.435 1075 ERROR designate     sys.exit(main())
2016-03-18 12:06:32.435 1075 ERROR designate   File "/usr/lib/python2.7/dist-packages/designate/cmd/manage.py", line 130, in main
2016-03-18 12:06:32.435 1075 ERROR designate     fn(*fn_args)
2016-03-18 12:06:32.435 1075 ERROR designate   File "/usr/lib/python2.7/dist-packages/designate/manage/database.py", line 63, in sync
2016-03-18 12:06:32.435 1075 ERROR designate     get_manager().upgrade(None)
2016-03-18 12:06:32.435 1075 ERROR designate   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration_cli/manager.py", line 65, in upgrade
2016-03-18 12:06:32.435 1075 ERROR designate     results.append(plugin.upgrade(None))
2016-03-18 12:06:32.435 1075 ERROR designate   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration_cli/ext_migrate.py", line 48, in upgrade
2016-03-18 12:06:32.435 1075 ERROR designate     init_version=self.init_version)
2016-03-18 12:06:32.435 1075 ERROR designate   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 74, in db_sync
2016-03-18 12:06:32.435 1075 ERROR designate     current_version = db_version(engine, abs_path, init_version)
2016-03-18 12:06:32.435 1075 ERROR designate   File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 129, in db_version
2016-03-18 12:06:32.435 1075 ERROR designate     meta.reflect(bind=engine)
2016-03-18 12:06:32.435 1075 ERROR designate   File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3594, in reflect
2016-03-18 12:06:32.435 1075 ERROR designate     with bind.connect() as conn:
2016-03-18 12:06:32.435 1075 ERROR designate   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2018, in connect
2016-03-18 12:06:32.435 1075 ERROR ...
(more)
edit retag flag offensive close merge delete

Comments

1

Hi All,

My issue got resolved, I changed the below line in designate config file. It worked perfectly.

Config file = /etc/designate/designate.conf [storage:sqlalchemy] connection = mysql://designate-common:<pwd>@<mgmt-nw-ip-of-controller>/designatedb. Hope this helps other who are stuck with this.

ajithpathiyil gravatar imageajithpathiyil ( 2016-03-18 03:14:29 -0500 )edit