mysql startup script was not found

Submitted by Imhotep on Fri, 10/11/2013 - 12:03

I'm receiving this error message after upgrading webmin recently can you give me detailed instructions on how to fix please?

I need to modify the max allowed packet for MySQL but I can't access the module via Webmin anymore after the update. I do know that MySQL is running but I can't access it from the Webmin console.

The MySQL startup script (/usr/local/bin/safe_mysqld was not found on your system. Maybe MySQL is not installed, or your module configuration is incorrect.

The package can be automatically installed by Webmin. Click here to have it downloaded and installed using FreeBSD ports.

Status: 
Active

Comments

Submitted by JamieCameron on Fri, 10/11/2013 - 12:26

Does the script /usr/local/etc/rc.d/mysql-server exist on your system? If so, try editing the file /etc/webmin/mysql/config and adding the following lines at the end :

start_cmd=/usr/local/etc/rc.d/mysql-server forcestart
stop_cmd=/usr/local/etc/rc.d/mysql-server forcestop

Submitted by Imhotep on Mon, 10/14/2013 - 15:05

Hi Jamie I wasn't able to find that directory on my system. I'm running FreeBSD 8.0. Is there another way I can fix the mysql module so I can see it in the webmin gui? This problem started happening after I upgraded webmin a few weeks ago.

Submitted by JamieCameron on Mon, 10/14/2013 - 16:28

Sorry, I forgot that on FreeBSD the file is actually /usr/local/etc/webmin/mysql/config

Submitted by Imhotep on Mon, 10/14/2013 - 16:50

Thanks I found the location, do I still add the same 2 commands you listed below in the config file?

Submitted by Imhotep on Mon, 10/14/2013 - 16:56

never mind I think I got it, I'll reply if I still have trouble thanks Jamie!

Submitted by JamieCameron on Mon, 10/14/2013 - 17:28

Yes, please add those lines.

Submitted by Imhotep on Tue, 10/15/2013 - 06:39

Hi Jamie I tried this but its still not working. Just so I'm clear mysql is running but I can't modify mysql within the gui.

Submitted by andreychek on Tue, 10/15/2013 - 18:08

Another thing you may want to verify is to look in Webmin -> Servers -> MySQL -> Module Config -> System Configuration, and there, you may want to check that the paths listed there are the correct paths for your system.