- Script started on Fri 08 Mar 2013 11:55:33 AM EST
- root@test1:~# nova-manage service list
- 2013-03-08 11:56:35 DEBUG nova.utils [req-e2812806-9c1c-402b-b9c2-885b592e3688 None None] backend <module 'nova.db.sqlalchemy.api' from '/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.pyc'> __get_backend /usr/lib/python2.7/dist-packages/nova/utils.py:506
- Command failed, please check log for more info
- 2013-03-08 11:56:35 CRITICAL nova [req-e2812806-9c1c-402b-b9c2-885b592e3688 None None] (OperationalError) (1045, "Access denied for user 'nova'@'test1' (using password: YES)") None None
- 2013-03-08 11:56:35 24636 TRACE nova Traceback (most recent call last):
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/bin/nova-manage", line 1404, in <module>
- 2013-03-08 11:56:35 24636 TRACE nova main()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/bin/nova-manage", line 1391, in main
- 2013-03-08 11:56:35 24636 TRACE nova fn(*fn_args, **fn_kwargs)
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/bin/nova-manage", line 623, in list
- 2013-03-08 11:56:35 24636 TRACE nova services = db.service_get_all(ctxt)
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/api.py", line 133, in service_get_all
- 2013-03-08 11:56:35 24636 TRACE nova return IMPL.service_get_all(context, disabled)
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 111, in wrapper
- 2013-03-08 11:56:35 24636 TRACE nova return f(*args, **kwargs)
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 353, in service_get_all
- 2013-03-08 11:56:35 24636 TRACE nova query = model_query(context, models.Service)
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py", line 199, in model_query
- 2013-03-08 11:56:35 24636 TRACE nova session = kwargs.get('session') or get_session()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/session.py", line 46, in get_session
- 2013-03-08 11:56:35 24636 TRACE nova engine = get_engine()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/session.py", line 140, in get_engine
- 2013-03-08 11:56:35 24636 TRACE nova _ENGINE.connect()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2472, in connect
- 2013-03-08 11:56:35 24636 TRACE nova return self._connection_cls(self, **kwargs)
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 878, in __init__
- 2013-03-08 11:56:35 24636 TRACE nova self.__connection = connection or engine.raw_connection()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2558, in raw_connection
- 2013-03-08 11:56:35 24636 TRACE nova return self.pool.unique_connection()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 183, in unique_connection
- 2013-03-08 11:56:35 24636 TRACE nova return _ConnectionFairy(self).checkout()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 387, in __init__
- 2013-03-08 11:56:35 24636 TRACE nova rec = self._connection_record = pool._do_get()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 741, in _do_get
- 2013-03-08 11:56:35 24636 TRACE nova con = self._create_connection()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 188, in _create_connection
- 2013-03-08 11:56:35 24636 TRACE nova return _ConnectionRecord(self)
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 270, in __init__
- 2013-03-08 11:56:35 24636 TRACE nova self.connection = self.__connect()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 330, in __connect
- 2013-03-08 11:56:35 24636 TRACE nova connection = self.__pool._creator()
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect
- 2013-03-08 11:56:35 24636 TRACE nova return dialect.connect(*cargs, **cparams)
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 281, in connect
- 2013-03-08 11:56:35 24636 TRACE nova return self.dbapi.connect(*cargs, **cparams)
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
- 2013-03-08 11:56:35 24636 TRACE nova return Connection(*args, **kwargs)
- 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
- 2013-03-08 11:56:35 24636 TRACE nova super(Connection, self).__init__(*args, **kwargs2)
- 2013-03-08 11:56:35 24636 TRACE nova OperationalError: (OperationalError) (1045, "Access denied for user 'nova'@'test1' (using password: YES)") None None
- 2013-03-08 11:56:35 24636 TRACE nova
- root@test1:~# cagrep sql_connection /etc/novan/cnocva.conf
- sql_connection=mysql://nova:********************************@mysql-ha/nova
- # sql_connection_debug=0
- # sql_connection_trace=false
- root@test1:~# mysql -unova -hmysql-ha -u root nova -p********************************
- Welcome to the MySQL monitor. Commands end with ; or \g. .
- Your MySQL connection id is 8
- Server version: 5.5.29-0ubuntu0.12.04.2-log (Ubuntu)
- Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
- Oracle is a registered trademark of Oracle Corporation and/or its
- affiliates. Other names may be trademarks of their respective
- owners.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- mysql> quit
- Bye
- root@test1:~# digff /etc/nova//nova.conf <(ssh root@test12 'cat /etc/nova/nova.conf')
- 109c109
- < my_ip=10.21.0.1
- ---
- > my_ip=10.21.0.2
- root@test1:~# diff /etc/hosts <(ssh root@test1 "cat /etc/hosts")
- root@test1:~# cat /etc/hosts
- 127.0.0.1 localhost
- # The following lines are desirable for IPv6 capable hosts
- ::1 ip6-localhost ip6-loopback
- fe00::0 ip6-localnet
- ff00::0 ip6-mcastprefix
- ff02::1 ip6-allnodes
- ff02::2 ip6-allrouters
- 10.21.0.1 test1 test1-int
- 10.21.0.2 test2 test2-int
- 10.21.1.1 mysql-ha
- 10.21.1.2 rabbitmq-ha
- 10.21.2.1 keystone-ha
- 10.21.2.2 glance-api-ha
- 10.21.2.3 glance-reg-ha
- 10.21.2.4 nova-ha
- 10.21.2.5 quantum-ha
- root@test1:~# exit
- Script done on Fri 08 Mar 2013 12:01:55 PM EST