I rebooted my computer and then tried to start mysql using /etc/init.d/mysqld-ib start. I got the following message:

Mysql manager or server pid file could not be found.

What can I do? I also tried /etc/init.d/mysqld-ib restart but got the same error message.

Thank you,

R.

Hi

Can you check the owner ship of the data and cache directory? It must be accessible by user mysql and group mysql.

You can change the permission by:

chown -R mysql.mysql /usr/local/infobright/data /usr/local/infobright/cache

Also check if another mysqld is running in the same port/socket. If so, please terminate(kill) that process.

I am not sure how the permission can be changed after installation. If you always use mysqld_safe and init.d script, it should not happen.

Let us know if it helps.

best regards,

Rodrigo,

Hi!  Dave Lutz here.  Quick question:  Were you executing the ‘start’ command as the root user or a user with sudo privileges and prefacing the command with sudo?  I think I’ve seen that when I try to start the server as an “under-privileged” user.

Rodrigo,

The best way to start Infobright is to have it automatically started and shutdown during the boot and shutdown process. Log in as root and enter these commands, then reboot to see if it worked -

chkconfig—add mysqld-ib
chkconfig—level 2345 mysqld-ib on
chkconfig—level 016 mysqld-ib off

Carl

That’s good advice!  Thanks, Carl.