We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Need to stop mySQL Service for websites to work
Need to stop mySQL Service for websites to work
Hi i am new to vestacp and after i had everything set up i run from ssh the command to reset my stats after that the server collapsed and i had to restart. I used
After the restart the server comes back online and mySQL shuts down after a few seconds and i am getting this error (among others)
Anyhow after i shutdown the mySQL service everything seems to work perfectly normal.
I am running on 1gb RAM VPS from DO and Ubuntu 14.04.1 LTS.
Edit: I have also noticed something strange in Services page where memory from apache2 is 5773 mb.
Is this normal?
Any ideas where did i screwed up and how to fix this?
Thanks in advance.
Code: Select all
/usr/local/vesta/bin/v-update-sys-queue disk
Code: Select all
shutdown -r now
After the restart the server comes back online and mySQL shuts down after a few seconds and i am getting this error (among others)
Code: Select all
Can't open file: './db_name_main/t64hj_session.frm' (errno: 24) SQL=INSERT INTO `t64hj_session` (`session_id`, `client_id`, `time`) VALUES ('16e5eab189acfbf9e6d1e5d36145e9ed', 0, '1428994228')
Anyhow after i shutdown the mySQL service everything seems to work perfectly normal.
I am running on 1gb RAM VPS from DO and Ubuntu 14.04.1 LTS.
Edit: I have also noticed something strange in Services page where memory from apache2 is 5773 mb.
Is this normal?
Any ideas where did i screwed up and how to fix this?
Thanks in advance.
Re: Need to stop mySQL Service for websites to work
https://github.com/serghey-rodin/vesta/ ... t-63156504 – fixed it: `update-rc.d mysql disable`
Proof - viewtopic.php?f=11&t=6887&p=20759#p20759
Proof - viewtopic.php?f=11&t=6887&p=20759#p20759
Re: Need to stop mySQL Service for websites to work
Hi, thanks for the reply but it did not work for me.
I run the command
and then I tried again the command with the edited file but still the same :(
I run the command
Code: Select all
update-rc.d mysql disable
Look in /etc/init/mysql.conf and edit the following:
Near the topc of mysql.conf, comment the following line:
start on runlevel [2345]
Add the following line directly after that commented code:
#start on runlevel [2345] start on (net-device-up IFACE=eth0 and local-filesystems and runlevel [2345])
After commenting the following line, it should look like this:
#start on runlevel [2345]
start on (net-device-up IFACE=eth0 and local-filesystems and runlevel [2345])
stop on starting rc RUNLEVEL=[016]
Or IFACE=lo but that may present issues. Successfully tested on 14.04 with multiple restarts after running into this issue.
Re: Need to stop mySQL Service for websites to work
Hi i have fixed my issue by editing the file
Under
Paste
Code: Select all
/etc/mysql/my.cnf
Code: Select all
[mysqld]
Code: Select all
open_files_limit = 5000
Re: Need to stop mySQL Service for websites to work
Yep, open_files_limit - this second thing