1. Script started on Fri 08 Mar 2013 11:55:33 AM EST
  2. root@test1:~# nova-manage service list
  3. 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
  4. Command failed, please check log for more info
  5. 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
  6. 2013-03-08 11:56:35 24636 TRACE nova Traceback (most recent call last):
  7. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/bin/nova-manage", line 1404, in <module>
  8. 2013-03-08 11:56:35 24636 TRACE nova main()
  9. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/bin/nova-manage", line 1391, in main
  10. 2013-03-08 11:56:35 24636 TRACE nova fn(*fn_args, **fn_kwargs)
  11. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/bin/nova-manage", line 623, in list
  12. 2013-03-08 11:56:35 24636 TRACE nova services = db.service_get_all(ctxt)
  13. 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
  14. 2013-03-08 11:56:35 24636 TRACE nova return IMPL.service_get_all(context, disabled)
  15. 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
  16. 2013-03-08 11:56:35 24636 TRACE nova return f(*args, **kwargs)
  17. 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
  18. 2013-03-08 11:56:35 24636 TRACE nova query = model_query(context, models.Service)
  19. 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
  20. 2013-03-08 11:56:35 24636 TRACE nova session = kwargs.get('session') or get_session()
  21. 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
  22. 2013-03-08 11:56:35 24636 TRACE nova engine = get_engine()
  23. 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
  24. 2013-03-08 11:56:35 24636 TRACE nova _ENGINE.connect()
  25. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2472, in connect
  26. 2013-03-08 11:56:35 24636 TRACE nova return self._connection_cls(self, **kwargs)
  27. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 878, in __init__
  28. 2013-03-08 11:56:35 24636 TRACE nova self.__connection = connection or engine.raw_connection()
  29. 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
  30. 2013-03-08 11:56:35 24636 TRACE nova return self.pool.unique_connection()
  31. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 183, in unique_connection
  32. 2013-03-08 11:56:35 24636 TRACE nova return _ConnectionFairy(self).checkout()
  33. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 387, in __init__
  34. 2013-03-08 11:56:35 24636 TRACE nova rec = self._connection_record = pool._do_get()
  35. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 741, in _do_get
  36. 2013-03-08 11:56:35 24636 TRACE nova con = self._create_connection()
  37. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 188, in _create_connection
  38. 2013-03-08 11:56:35 24636 TRACE nova return _ConnectionRecord(self)
  39. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 270, in __init__
  40. 2013-03-08 11:56:35 24636 TRACE nova self.connection = self.__connect()
  41. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 330, in __connect
  42. 2013-03-08 11:56:35 24636 TRACE nova connection = self.__pool._creator()
  43. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 80, in connect
  44. 2013-03-08 11:56:35 24636 TRACE nova return dialect.connect(*cargs, **cparams)
  45. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 281, in connect
  46. 2013-03-08 11:56:35 24636 TRACE nova return self.dbapi.connect(*cargs, **cparams)
  47. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
  48. 2013-03-08 11:56:35 24636 TRACE nova return Connection(*args, **kwargs)
  49. 2013-03-08 11:56:35 24636 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
  50. 2013-03-08 11:56:35 24636 TRACE nova super(Connection, self).__init__(*args, **kwargs2)
  51. 2013-03-08 11:56:35 24636 TRACE nova OperationalError: (OperationalError) (1045, "Access denied for user 'nova'@'test1' (using password: YES)") None None
  52. 2013-03-08 11:56:35 24636 TRACE nova
  53. root@test1:~# cagrep sql_connection /etc/novan/cnocva.conf
  54. sql_connection=mysql://nova:********************************@mysql-ha/nova
  55. # sql_connection_debug=0
  56. # sql_connection_trace=false
  57. root@test1:~# mysql -unova -hmysql-ha -u root nova -p********************************
  58. Welcome to the MySQL monitor. Commands end with ; or \g. .
  59. Your MySQL connection id is 8
  60. Server version: 5.5.29-0ubuntu0.12.04.2-log (Ubuntu)
  61. Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
  62. Oracle is a registered trademark of Oracle Corporation and/or its
  63. affiliates. Other names may be trademarks of their respective
  64. owners.
  65. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  66. mysql> quit
  67. Bye
  68. root@test1:~# digff /etc/nova//nova.conf <(ssh root@test12 'cat /etc/nova/nova.conf')
  69. 109c109
  70. < my_ip=10.21.0.1
  71. ---
  72. > my_ip=10.21.0.2
  73. root@test1:~# diff /etc/hosts <(ssh root@test1 "cat /etc/hosts")
  74. root@test1:~# cat /etc/hosts
  75. 127.0.0.1 localhost
  76. # The following lines are desirable for IPv6 capable hosts
  77. ::1 ip6-localhost ip6-loopback
  78. fe00::0 ip6-localnet
  79. ff00::0 ip6-mcastprefix
  80. ff02::1 ip6-allnodes
  81. ff02::2 ip6-allrouters
  82. 10.21.0.1 test1 test1-int
  83. 10.21.0.2 test2 test2-int
  84. 10.21.1.1 mysql-ha
  85. 10.21.1.2 rabbitmq-ha
  86. 10.21.2.1 keystone-ha
  87. 10.21.2.2 glance-api-ha
  88. 10.21.2.3 glance-reg-ha
  89. 10.21.2.4 nova-ha
  90. 10.21.2.5 quantum-ha
  91. root@test1:~# exit
  92. Script done on Fri 08 Mar 2013 12:01:55 PM EST