Shulou(Shulou.com)06/01 Report--

Error

ERROR: Error appeared during Puppet run: x.x.x.x_keystone.ppError: / stage [main] / Keystone::Db::Sync/Exec [keystone-manage db_sync]: Failed to call refresh: Command exceeded timeoutYou will find full trace in log / var/tmp/packstack/20160801-185048-pwY8Y8/manifests/x.x.x.x_keystone.pp.logPlease check log file / var/tmp/packstack/20160801-185048-pwY8Y8/openstack-setup.log for more information

Resolve:

The error occurs when installing the latest version of mitaka from openstack using RDO mode packstack.

It's in the cloud environment.

Inet 192.168.1.7 scope global dynamic eth0 24 brd 192.168.1.255 has a public network IP 42.62.X.X

View the log

[root@controller ~] # cd / var/log/keystone/ [root@controller keystone] # lskeystone.log2016-08-01 20 purge 34 purl 33.513 14145 ERROR keystone.common.wsgi DBConnectionError: (pymysql.err.OperationalError) (2003) "Can't connect to MySQL server on 'x.x.x.x'([Errno 110x] Connection timed out") 2016-08-01 20ERROR keystone.common.wsgi2016-08-01 20ERROR keystone.common.wsgi2016-01 20ERROR keystone.common.wsgi2016-08-01 20ERROR keystone.common.wsgi2016-08-01 20 ERROR keystone.common.wsgi2016-08-01 20 ERROR keystone.common.wsgi2016-08-01 20 WARNING oslo_db.sqlalchemy.engines 34.671 14150 WARNING oslo_db.sqlalchemy.engines [req-12a5fe87-1163-4fbb-a049-5225ea65a05a -] SQL connection failed. 10 attempts left.

View the database

MariaDB [(none)] > show databases +-+ | Database | +-+ | cinder | | glance | | gnocchi | | information_schema | | keystone | | mysql | | neutron | | nova | | nova_api | | performance_schema | | test | +-+ 11 rows in set (0.00 sec) MariaDB [(none)] > use keystone | Database changedMariaDB [keystone] > show tables;Empty set (0.00 sec) generated the library without content. See user MariaDB [mysql] > select host,user from user. +-+-+ | host | user | +-+-+ |% | cinder |% | glance | |% | gnocchi |% | keystone_admin | |% | | neutron | |% | nova | |% | nova_api | | 127.0.0.1 | keystone_admin | | localhost | root | +-+-+ 9 rows in set (0.00 sec) permission is% | It should be possible.

Refer to the difference of mysql authorization localhost&% and the solution to the error of continuous authorization

Http://blog.csdn.net/tantexian/article/details/44861733

One more sentence here, if you configure% remote other host to have permission to access, then you also need to make some configuration in the mysql configuration file / etc/my.cnf to block this item or block this item directly. For more information, please find out by yourself.

If you want the outside host to access the database: (yunjisuan is the root password)

GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' yunjisuan'

Flush privileges

Modify hosts [root@controller keystone] # cat / etc/hosts127.0.0.1 controller localhost localhost.localdomain localhost4 localhost4.localdomain4 # # and add host name:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6x.x.x.x controller [root@controller keystone] # mysql-ukeystone_admin-pEnter password:Welcome to the MariaDB monitor in 127.0.0.1. Commands end with; or\ g. # # the local test can log in because only one eth0 is built in the cloud environment, and the cloud is the public network ip. Now we are not sure how the server accesses the bound public network ip, whether to eth0 directly to the public network ip and come back, or return after routing. If so, it is equivalent to remote access to the mysql database. The relationship is so messy. [root@controller ~] # route-n # this is the default route Kernel IP routing tableDestination Gateway Genmask Flags Metric Ref Use Iface0.0.0.0 192.168.1.1 0.0.0.0 UG 10000 eth0192.168.1.0 0.0.0.0 255.255.255.0 U 10000 eth0 So now we need to check the security team. The test root could not log in remotely. You can test the mysql server with other machines. There is no problem with the security group MariaDB [mysql] > grant all privileges on *. * to 'root'@'%' identified by' xxxxxxxx'; # add%, and you can log in remotely. [root@hequan ~] # mysql-hip-p-ukeystone_admin # # there is no problem with local test login. Enter password:Welcome to the MariaDB monitor. Commands end with; or\ g.MariaDB [mysql] > use keystone;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with-ADatabase changedMariaDB [keystone] > show tables +-+ | Tables_in_keystone | +-+ | access_token | | assignment | | config_register | | consumer | | credential | | domain | | endpoint | # check the table and execute again. RROR: Error appeared during Puppet run: x.x.x.x_cinder.ppError: Could not prefetch cinder_type provider 'openstack': Execution of' / usr/bin/openstack volume type list-- quiet-- format csv-- long' returned 1: Unable to CONFIG_CINDER_NETAPP_ESERIES_HOST_TYPE=linux_dm_mp # # this is cinder_typeMariaDB [keystone] > use cinderDatabase changedMariaDB [cinder] > show tables Empty set (0. 00 sec) check that there is no table in cinder, but there is still a problem. MariaDB [cinder] > use glance;Database changedMariaDB [glance] > show tables;Empty set (0.00 sec) glance does not generate tables either, but only keystone. Applying x.x.x.x_keystone.ppApplying x.x.x.x_glance.ppApplying x.x.x.x_cinder.ppx.x.x.x_keystone.pp: [DONE] Testing if puppet apply is finished: x.x.x.x_cinder.pp [\] $$# # the card uninstalls the database here and retests it. Oh, my God. I touched God. | |% | cinder | |% | glance | | 127.0.0.1 | keystone_admin |

Summary: there are 3 methods: 1 is to add the hostname at 127.0.0.1, and 2 to reset root's permission in msyql% 3 to uninstall the database and retest.

It should be better to test using the intranet ip later, and then do the 80 mapping on the router. I don't know if it's okay. It's like dying to build openstack on the cloud. After the test.

* Installation completed successfully *

Additional information:

* Time synchronization installation was skipped. Please note that unsynchronized time on server instances might be problem for some OpenStack components.

* File / root/keystonerc_admin has been created on OpenStack client host x.x.x.x. To use the command line tools you need to source the file.

* To access the OpenStack Dashboard browse to http://x.x.x.x / dashboard.

Please, find your login credentials stored in the keystonerc_admin in your home directory.

* Because of the kernel update the host x.x.x.x requires reboot.

* Because of the kernel update the host 127.0.0.1 requires reboot.

* The installation log file is available at: / var/tmp/packstack/20160801-224547-mTb9CN/openstack-setup.log

* The generated manifests are available at: / var/tmp/packstack/20160801-224547-mTb9CN/manifests

[root@controller] # netstat-lntupActive Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0 0. 0 7 7 7 0 0 0. 0 LISTEN 21105/python2 tcp 0 0 0 7 7 7 0 0. 0. 0LISTEN 1307/httpd tcp * LISTEN 21105/python2 tcp 00 0.0.0.014 9191 0.0.0.0 LISTEN 19676/python2 tcp 00 0.0.0.0000 0.0.0.0 LISTEN 1307/httpd tcp 0 0 0.0.0.0 8776 0.0.0.0 LISTEN 20207/python2 tcp 0 0 0.0.0 0.015 25672 0.0.0 0 LISTEN 10588/beam.smp tcp 0 0 0.0.0 0 7 777 0.0.0 0 * LISTEN 1307/httpd tcp 0 0 0 LISTEN 31512/mongod tcp 8041 0 0 0 LISTEN 1307/httpd tcp 0 0 12 7 0 0 0 1 0 0 0 17 0 0 0 .0.0.0: 8042 0.0.0.0 * LISTEN 1307/httpd tcp 0 0 0.0.0.0 3306 0.0.0.015 * LISTEN 17028/mysqld tcp 0 0 0.0.0.015 0.0.0.015 * LISTEN 25302/memcached tcp 0 0 0.0.0.0 LISTEN 22134/rpcbind tcp 9292 0.0.0.0 LISTEN 22134/rpcbind tcp 0 0 0.0.0.0 LISTEN 22134/rpcbind tcp 0 0 0.0.0.0 .0:80 0.0.0.0 * LISTEN 1307/httpd tcp 0 0 0.0.0.0 4369 0.0.0.015 * LISTEN 1/systemd tcp 00 0.0.0.0 22 0.0.0.0 LISTEN 816/sshd tcp 0 0 0.0.0.0 LISTEN 22855/libvirtd tcp 35357 0.0.0.0 LISTEN 1307/httpd tcp 0 0 0.0.0 0. 0 LISTEN 22855/libvirtd tcp 0 0 0 .0.0LISTEN 9696 0.0.0.0LISTEN * LISTEN 24517/python2 tcp 0 0 0.0.0.0 LISTEN 6080 0.0.0.0 LISTEN 0: 5672:: 10588/beam.smp tcp6 0 0: 11 1: * LISTEN 22134/rpcbind tcp6 0 0: 22: * LISTEN 816/sshd tcp6 0 0: 16509: * LISTEN 22855/libvirtd udp 0 0 0.0.0.0 585/dhclient udp 11211 0.0.0.0 585/dhclient udp * 25302/memcached udp 0 0 0.0.0.0 0 0 0 585/dhclient udp 8125 0 0 0 29029/python2 udp 0 0 0 V 68 0 0 0 V 11 11 0.0.0.0 * 22134/rpcbind udp 0 0127.0.0.1VO323 0.0.0.0VOV * 558/chronyd udp 0 00.0.0.0VOV 685 0.0.0.0Vol * 22134/rpcbind udp 0 0 0.0 0 22134/rpcbind udp6 0 0:: 1 22134/rpcbind udp6 0 0:: 1 : 323: * 558/chronyd udp6 0 0: 685: * 22134/rpcbind udp6 0 0: 38397:: * 585/dhclient

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.