Mysql error while installing rubystack

Hi,
I am getting following error while installing rubystack.

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/media/disk/bloglearn/deployment/rubystack/mysql/tmp/mysql.sock’ (2)

I have given mysql port as 3307.

Hi,

Could you post your Operating System? Do you have any firewall enabled?

Thanks beltran for your reply.

The operating system is ubuntu.

its a remote server…… i access it through putty. I am not sure about firewall, this is an organization server, I think firewall is enabled.
Can this be a port blocking problem.
Please list out the possible causes for this error. I will check out everything.

Hi,

It seems that you are trying to install in a mounted folder “/media/disk”. It is possible that this mounted disk has not a etx3 format so it could have problems with users privileges. Try to install in the same operating system disk. Once the Stack is running you can move the folder to a mounted disk and create a symlink.

Hi,

The media is of type ext3 and it is installed on same operating system.

Can you please specify other causes for this problem.
We have also checked that port 3307 is already open.

Could you post the /mysql/data/mysqld.log file?

100901 12:32:23 mysqld_safe Starting mysqld.bin daemon with databases from /media/disk/bloglearn/deployment/rubystack/mysql/data
/media/disk/bloglearn/deployment/rubystack/mysql/bin/mysqld.bin: Table ‘plugin’ is read only
100901 12:32:23 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
/media/disk/bloglearn/deployment/rubystack/mysql/bin/mysqld.bin: Can’t create/write to file ‘/media/disk/bloglearn/deployment/rubystack/mysql/tmp/ib4qc5d2’ (Errcode: 13)
100901 12:32:23 InnoDB: Error: unable to create temporary file; errno: 13
100901 12:32:23 [ERROR] Plugin ‘InnoDB’ init function returned error.
100901 12:32:23 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
100901 12:32:23 [ERROR] Unknown/unsupported table type: InnoDB
100901 12:32:23 [ERROR] Aborting

100901 12:32:23 [Note] /media/disk/bloglearn/deployment/rubystack/mysql/bin/mysqld.bin: Shutdown complete

100901 12:32:23 mysqld_safe mysqld from pid file /media/disk/bloglearn/deployment/rubystack/mysql/data/grid0-37-f3-09.cust43.cloud.*.com.pid ended
100901 14:11:17 mysqld_safe Starting mysqld.bin daemon with databases from /media/disk/bloglearn/deployment/rubystack/mysql/data
/media/disk/bloglearn/deployment/rubystack/mysql/bin/mysqld.bin: Table ‘plugin’ is read only
100901 14:11:18 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
/media/disk/bloglearn/deployment/rubystack/mysql/bin/mysqld.bin: Can’t create/write to file ‘/media/disk/bloglearn/deployment/rubystack/mysql/tmp/ibSyXafc’ (Errcode: 13)
100901 14:11:18 InnoDB: Error: unable to create temporary file; errno: 13
100901 14:11:18 [ERROR] Plugin ‘InnoDB’ init function returned error.
100901 14:11:18 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
100901 14:11:18 [ERROR] Unknown/unsupported table type: InnoDB
100901 14:11:18 [ERROR] Aborting

100901 14:11:18 [Note] /media/disk/bloglearn/deployment/rubystack/mysql/bin/mysqld.bin: Shutdown complete

100901 14:11:18 mysqld_safe mysqld from pid file /media/disk/bloglearn/deployment/rubystack/mysql/data/grid0-37-f3-09.cust43.cloud.**.com.pid ended
100901 14:13:20 mysqld_safe Starting mysqld.bin daemon with databases from /media/disk/bloglearn/deployment/rubystack/mysql/data
/media/disk/bloglearn/deployment/rubystack/mysql/bin/mysqld.bin: Table ‘plugin’ is read only
100901 14:13:20 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
/media/disk/bloglearn/deployment/rubystack/mysql/bin/mysqld.bin: Can’t create/write to file ‘/media/disk/bloglearn/deployment/rubystack/mysql/tmp/ibM94ckh’ (Errcode: 13)
100901 14:13:20 InnoDB: Error: unable to create temporary file; errno: 13
100901 14:13:20 [ERROR] Plugin ‘InnoDB’ init function returned error.
100901 14:13:20 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
100901 14:13:20 [ERROR] Unknown/unsupported table type: InnoDB
100901 14:13:20 [ERROR] Aborting

100901 14:13:20 [Note] /media/disk/bloglearn/deployment/rubystack/mysql/bin/mysqld.bin: Shutdown complete

100901 14:13:20 mysqld_safe mysqld from pid file /media/disk/bloglearn/deployment/rubystack/mysql/data/grid0-37-f3-09.cust43.cloud.*.com.pid ended

Hi,

Could you check if the /media/disk/bloglearn/deployment/rubystack/mysql/tmp/ folder exists? Could you check the owner/group of this folder?

Hi,

mysql/tmp folder exists but it is empty.mysql.sock file does not exist.

I am actually doing bitnami installation from root user, so it has read write permissions for every folder.

I have checked the folder permissions again i am getting same error.

bash-3.2# mysql -u root -p
Warning: World-writable config file ‘/media/disk/bloglearn/deployment/rubystack/mysql/my.cnf’ is ignored
Enter password:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

Hi,

It seems that the problem is installing in a media disk. Not sure what is your configuration. Could you install in a different location?