I am having a problem with Designate when installing the DB. Apt runs through the configuration portion and I receive a ECONNREFUSED when connecting to localhost as the mysql server. Mysql connections work fine from the command line to localhost, 127.0.0.1. Has anyone seen this before?
dbconfig-common: writing config to /etc/dbconfig-common/designate-common.conf granting access to database designatedb for designate-common@localhost: success. verifying access for designate-common@localhost: success. creating database designatedb: success. verifying database designatedb exists: success. dbconfig-common: flushing administrative password Now doing 'designate-manage database sync': this may take a while... No handlers could be found for logger "oslo_config.cfg" 2016-02-05 16:52:29.827 3169 CRITICAL designate [designate-manage - - - - -] OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] ECONNREFUSED)") 2016-02-05 16:52:29.827 3169 ERROR designate Traceback (most recent call last): 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/bin/designate-manage", line 10, in <module> 2016-02-05 16:52:29.827 3169 ERROR designate sys.exit(main()) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/designate/cmd/manage.py", line 130, in main 2016-02-05 16:52:29.827 3169 ERROR designate fn(*fn_args) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/designate/manage/database.py", line 63, in sync 2016-02-05 16:52:29.827 3169 ERROR designate get_manager().upgrade(None) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration_cli/manager.py", line 65, in upgrade 2016-02-05 16:52:29.827 3169 ERROR designate results.append(plugin.upgrade(None)) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration_cli/ext_migrate.py", line 48, in upgrade 2016-02-05 16:52:29.827 3169 ERROR designate init_version=self.init_version) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 74, in db_sync 2016-02-05 16:52:29.827 3169 ERROR designate current_version = db_version(engine, abs_path, init_version) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 129, in db_version 2016-02-05 16:52:29.827 3169 ERROR designate meta.reflect(bind=engine) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3594, in reflect 2016-02-05 16:52:29.827 3169 ERROR designate with bind.connect() as conn: 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2018, in connect 2016-02-05 16:52:29.827 3169 ERROR designate return self._connection_cls(self, **kwargs) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 72, in __init__ 2016-02-05 16:52:29.827 3169 ERROR designate if connection is not None else engine.raw_connection() 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection 2016-02-05 16:52:29.827 3169 ERROR designate self.pool.unique_connection, _connection) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect 2016-02-05 16:52:29.827 3169 ERROR designate e, dialect, self) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1405, in _handle_dbapi_exception_noconnection 2016-02-05 16:52:29.827 3169 ERROR designate exc_info 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause 2016-02-05 16:52:29.827 3169 ERROR designate reraise(type(exception), exception, tb=exc_tb) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect 2016-02-05 16:52:29.827 3169 ERROR designate return fn() 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection 2016-02-05 16:52:29.827 3169 ERROR designate return _ConnectionFairy._checkout(self) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 713, in _checkout 2016-02-05 16:52:29.827 3169 ERROR designate fairy = _ConnectionRecord.checkout(pool) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 480, in checkout 2016-02-05 16:52:29.827 3169 ERROR designate rec = pool._do_get() 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1151, in _do_get 2016-02-05 16:52:29.827 3169 ERROR designate return self._create_connection() 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection 2016-02-05 16:52:29.827 3169 ERROR designate return _ConnectionRecord(self) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 449, in __init__ 2016-02-05 16:52:29.827 3169 ERROR designate self.connection = self.__connect() 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 607, in __connect 2016-02-05 16:52:29.827 3169 ERROR designate connection = self.__pool._invoke_creator(self) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect 2016-02-05 16:52:29.827 3169 ERROR designate return dialect.connect(*cargs, **cparams) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 385, in connect 2016-02-05 16:52:29.827 3169 ERROR designate return self.dbapi.connect(*cargs, **cparams) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 88, in Connect 2016-02-05 16:52:29.827 3169 ERROR designate return Connection(*args, **kwargs) 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 626, in __init__ 2016-02-05 16:52:29.827 3169 ERROR designate self._connect() 2016-02-05 16:52:29.827 3169 ERROR designate File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 818, in _connect 2016-02-05 16:52:29.827 3169 ERROR designate 2003, "Can't connect to MySQL server on %r (%s)" % (self.host, e)) 2016-02-05 16:52:29.827 3169 ERROR designate OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 111] ECONNREFUSED)") 2016-02-05 16:52:29.827 3169 ERROR designate root@controller01:/etc/designate# root@controller01:/etc/designate# root@controller01:/etc/designate# mysql -u root -p -h localhost Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 143 Server version: 5.5.46-MariaDB-1ubuntu0.14.04.2 (Ubuntu) Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> Steven Searles, CTO | [email protected]<mailto:[email protected]> Zimcom Internet Solutions | www.zimcom.net<http://www.zimcom.net/> O: 513.231.9500 | D: 513.233.4130 [cid:C0917625-7CD3-48D9-A1DE-1C9B82C658E9]
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected] Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
