Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I am installing keystone and mysql failed to start

Hi all,

I am installing keystone in a VM configured by vagrant. I am following the instruction http://docs.openstack.org/havana/install-guide/install/apt/content/basics-database.html and when I do "sudo service mysql restart" mysql first goes to stop/waiting mode and then mysql it fails to start. Any idea what could be wrong?? I checked the log file, it complain about another mysqld listening on prot 3306, I checked for it, and no other mysqld exists. Even I changed the port from 3306 to 1036 and still the same message in the log file.!!

Regards.

I am installing keystone and mysql failed to start

Hi all,

I am installing keystone in a VM configured by vagrant. I am following the instruction http://docs.openstack.org/havana/install-guide/install/apt/content/basics-database.html and when I do "sudo sudo service mysql restart" restart mysql first goes to stop/waiting mode and then mysql it fails to start. Any idea what could be wrong?? wrong??

I checked the log file, it complain about another mysqld listening on prot 3306, I checked for it, and no other mysqld exists. Even I changed the port from 3306 to 1036 and still the same message in the log file.!!

Regards.The bind address is 172.16.0.200 which is an interface configured in Vagrant file, and port number is 3306. The error.log contains:

31119 14:51:33 [Note] Server hostname (bind-address): '172.16.0.200'; port: 3306 131119 14:51:33 [Note] - '172.16.0.200' resolves to '172.16.0.200'; 131119 14:51:33 [Note] Server socket created on IP: '172.16.0.200'. 131119 14:51:33 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address 131119 14:51:33 [ERROR] Do you already have another mysqld server running on port: 3306 ? 131119 14:51:33 [ERROR] Aborting

I am mysql failed to start while installing keystone and mysql failed to startin vagrant VM

I am installing keystone in a VM configured by vagrant. I am following the instruction http://docs.openstack.org/havana/install-guide/install/apt/content/basics-database.html and when I do sudo service mysql restart mysql first goes to stop/waiting mode and then mysql it fails to start. Any idea what could be wrong??

I checked the log file, it complain about another mysqld listening on prot 3306, I checked for it, and no other mysqld exists. Even I changed the port from 3306 to 1036 and still the same message in the log file.!!file!!

The bind address is 172.16.0.200 which is an interface configured in Vagrant file, and port number is 3306. The error.log contains:

31119

131119 14:51:33 [Note] Server hostname (bind-address): '172.16.0.200'; port: 3306  131119 14:51:33 [Note] - '172.16.0.200' resolves to '172.16.0.200';  131119 14:51:33 [Note] Server socket created on IP: '172.16.0.200'.  131119 14:51:33 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address  131119 14:51:33 [ERROR] Do you already have another mysqld server running on port: 3306 ?  131119 14:51:33 [ERROR] AbortingAborting

Checking running processes and listening ports:

vagrant@controller:~$ netstat -paln|grep :3306 (No info could be read for "-p": geteuid()=1000 but you should be root.) 
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN -

vagrant@controller:~$ ps awux|grep mysql 
mysql 6686 0.0 2.1 623800 44292 ? Ssl 16:38 0:00 /usr/sbin/mysqld vagrant 6855 0.0 0.0 11676 936 pts/0 S+ 16:56 0:00 grep --color=auto mysql

131120 16:38:31 InnoDB: 5.5.34 started; log sequence number 1595675 
131120 16:38:31 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 131120 16:38:31 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 
131120 16:38:31 [Note] Server socket created on IP: '127.0.0.1'. 
131120 16:38:31 [Note] Event Scheduler: Loaded 0 events 
131120 16:38:31 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.34-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)

mysql failed to start while installing keystone in vagrant VM

I am installing keystone in a VM configured by vagrant. I am following the instruction http://docs.openstack.org/havana/install-guide/install/apt/content/basics-database.html and when I do sudo service mysql restart mysql first goes to stop/waiting mode and then mysql it fails to start. Any idea what could be wrong??

I checked the log file, it complain about another mysqld listening on prot 3306, I checked for it, and no other mysqld exists. Even I changed the port from 3306 to 1036 and still the same message in the log file!!

The bind address is 172.16.0.200 which is an interface configured in Vagrant file, and port number is 3306. The error.log contains:

131119 14:51:33 [Note] Server hostname (bind-address): '172.16.0.200'; port: 3306 
131119 14:51:33 [Note] - '172.16.0.200' resolves to '172.16.0.200'; 
131119 14:51:33 [Note] Server socket created on IP: '172.16.0.200'. 
131119 14:51:33 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address 
131119 14:51:33 [ERROR] Do you already have another mysqld server running on port: 3306 ? 
131119 14:51:33 [ERROR] Aborting

Checking running processes and listening ports:

vagrant@controller:~$ netstat -paln|grep :3306 (No info could be read for "-p": geteuid()=1000 but you should be root.) 
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN -

vagrant@controller:~$ ps awux|grep mysql 
mysql 6686 0.0 2.1 623800 44292 ? Ssl 16:38 0:00 /usr/sbin/mysqld vagrant 6855 0.0 0.0 11676 936 pts/0 S+ 16:56 0:00 grep --color=auto mysql
 

and from MySQL log:

131120 16:38:31 InnoDB: 5.5.34 started; log sequence number 1595675 
131120 16:38:31 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 131120 16:38:31 [Note] - '127.0.0.1' resolves to '127.0.0.1'; 
131120 16:38:31 [Note] Server socket created on IP: '127.0.0.1'. 
131120 16:38:31 [Note] Event Scheduler: Loaded 0 events 
131120 16:38:31 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.34-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)