Ask Your Question
0

Adding networking service on network node, an error occured when connecting database

asked 2014-06-19 21:38:44 -0500

dwyaneini gravatar image

updated 2014-07-02 01:02:41 -0500

I deploy openstack architecture with openstack networking(neutron) according to offcial document icehouse step by step. When I try to add networking service on network node (to configure ml2 plugin), the system prompts me to install a database while I have already had MySQL on controller node. Maybe there exists some problems on connecting to database on controller node.

Following are the prompt information in configureing neutron-common: An error occured while installing the database:

Error 2002 (HY000): can't connect to local MySQL server through socket 'var/run/mysqld/mysqld.sock'

Thx.

edit retag flag offensive close merge delete

Comments

1

On Controller :-

[root@icehouse1 ~(keystone_admin)]# iptables-save | grep mysql
-A INPUT -s 192.168.1.127/32 -p tcp -m multiport --dports 3306 -m comment --comment "001 mysql incoming mysql_192.168.1.127" -j ACCEPT
-A INPUT -s 192.168.1.137/32 -p tcp -m multiport --dports 3306 -m comment --comment "001 mysql incoming mysql_192.168.1.137" -j ACCEPT
[root@icehouse1 ~(keystone_admin)]# netstat -lntp | grep 3306
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      3815/mysqld
dbaxps gravatar imagedbaxps ( 2014-06-19 21:54:52 -0500 )edit

1 answer

Sort by ยป oldest newest most voted
0

answered 2014-06-19 22:25:23 -0500

dwyaneini gravatar image

thank you for your comments, dbaxps! I've solved my problem that MySQL server on controller node can't allow remote connection. I configure MySQL by allowing remote connection from network node and compute node1.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2014-06-19 21:38:44 -0500

Seen: 336 times

Last updated: Jul 02 '14