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.
"restart" "'mysql'" failed after upgrade
"restart" "'mysql'" failed after upgrade
Hello first of all thank you for the new version.
Unfortonatly I have the same problem at least in 3 different servers (Centos 6.6) if I try to restart the mysql I allways get "restart" "'mysql'"
Any solution?
Update: Restart the server also failed, the other services seems ok
Unfortonatly I have the same problem at least in 3 different servers (Centos 6.6) if I try to restart the mysql I allways get "restart" "'mysql'"
Any solution?
Update: Restart the server also failed, the other services seems ok
Re: "restart" "'mysql'" failed after upgrade
Loot at mysql error log in /var/log and show us.
Re: "restart" "'mysql'" failed after upgrade
I look at mysql error and there are none. If I restart via ssh everything works I think that the problem is on the website. But the strange thing is this occur on all my serversskurudo wrote:Loot at mysql error log in /var/log and show us.
Re: "restart" "'mysql'" failed after upgrade
New update:
If i ran the code
Via ssh with root login the service restart without problems but within the vesta panel it fail always.
If i ran the code
Code: Select all
v-restart-service mysqld
Re: "restart" "'mysql'" failed after upgrade
Try to restart service and then look at /usr/local/vesta/log/nginx-error.log
Re: "restart" "'mysql'" failed after upgrade
Everytime refresh the "server" page I get an error:skurudo wrote:Try to restart service and then look at /usr/local/vesta/log/nginx-error.log
Code: Select all
[error] 3227#0: *596 FastCGI sent in stderr: "PHP message: PHP Notice: Undefined variable: status in /usr/local/vesta/web/templates/admin/list_services.html on line 51" while reading upstream, client: 37.189.xx.xx, server: _, request: "GET /list/server/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/vesta-php.sock:", host: "xxxx.info:8083", referrer: "https://xxxx.info:8083/list/server/"
I look and every logs that I remember and don't find anything. The strange thing is this occurs on all my servers
Re: "restart" "'mysql'" failed after upgrade
Same problem
"restart" "'mysql'" failed
Today I received an email 'Vesta Control Panel"
Can't connect to localhost
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
https://myservip:8083/list/server/ - here I found that mysql is disabled and it's not restarted with an error "restart" "'mysql'" failed
Any ideas?
"restart" "'mysql'" failed
Today I received an email 'Vesta Control Panel"
Can't connect to localhost
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
https://myservip:8083/list/server/ - here I found that mysql is disabled and it's not restarted with an error "restart" "'mysql'" failed
Any ideas?
Re: "restart" "'mysql'" failed after upgrade
Why you think problem the same? Be more clear, tell us about your OS, VestaCP version?Zuzlan wrote:Same problem
"restart" "'mysql'" failed
What's in mysql error log? /var/log/Zuzlan wrote:Today I received an email 'Vesta Control Panel"
Can't connect to localhost
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When you restart mysql from console, you get error?Zuzlan wrote:https://myservip:8083/list/server/ - here I found that mysql is disabled and it's not restarted with an error "restart" "'mysql'" failed
too many for this late night show ;-)Zuzlan wrote:Any ideas?
need more data about your server
Re: "restart" "'mysql'" failed after upgrade
Broken sudo ;-(kandalf wrote:Code: Select all
[error] 3227#0: *596 FastCGI sent in stderr: "PHP message: PHP Notice: Undefined variable: status in /usr/local/vesta/web/templates/admin/list_services.html on line 51" while reading upstream, client: 37.189.xx.xx, server: _, request: "GET /list/server/ HTTP/1.1", upstream: "fastcgi://unix:/var/run/vesta-php.sock:", host: "xxxx.info:8083", referrer: "https://xxxx.info:8083/list/server/"
viewtopic.php?f=16&t=7063#p27116
Re: "restart" "'mysql'" failed after upgrade
Hello
Thank you for you reply, skurudo
You are right. It wasn't the same problem. Just similar simptom with "restart" "'mysql'" failed.
But about everything in order.
Operating system: Centos 6 x86
VestaCP version: was installed the latest version on 17 Feb 2015. And updated (after problem appeared) to 0.9.8 (i686)
In my case the problem was with mysql database server. It was down. I have tried to start it from Vesta Panel ( "restart" "'mysql'" failed ), also tried to start it by SSH. It was still down, so I looked at the log file.
There was records about "InnoDB: We intentionally generate a memory trap." and links to http://dev.mysql.com/doc/refman/5.5/en/ ... overy.html for some ways to fix this issue.
mysql service was falling each time right after start
Full log for that moment - http://www.zuzlan.name/hlam/mysqld.log-old.zip
Then we tried to change config: innodb_force_recovery = ['1'..'6']. It helped to start mysql, but still site not worked with an error - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Logs file was increased it's size extremely fast - http://www.zuzlan.name/hlam/mysqld.log-old2.zip
From this time I could successfully restore DB from backups, but the problem isn't gone anywhere
We had no idea what to do with this, so decision was reinstall "mysql" manually (dont know how to do it with Vesta Panel).It wasn't help, so we decided to delete all DB files with Midnight Commander (it was impossible to delete bases with Panel). After files delete - everything is fine. Then we resore DB from backup again. At this time problem was gone.
Still have no idea how fix it simply in case the problem appears again
Thank you for you reply, skurudo
You are right. It wasn't the same problem. Just similar simptom with "restart" "'mysql'" failed.
But about everything in order.
Operating system: Centos 6 x86
VestaCP version: was installed the latest version on 17 Feb 2015. And updated (after problem appeared) to 0.9.8 (i686)
In my case the problem was with mysql database server. It was down. I have tried to start it from Vesta Panel ( "restart" "'mysql'" failed ), also tried to start it by SSH. It was still down, so I looked at the log file.
There was records about "InnoDB: We intentionally generate a memory trap." and links to http://dev.mysql.com/doc/refman/5.5/en/ ... overy.html for some ways to fix this issue.
mysql service was falling each time right after start
Full log for that moment - http://www.zuzlan.name/hlam/mysqld.log-old.zip
Then we tried to change config: innodb_force_recovery = ['1'..'6']. It helped to start mysql, but still site not worked with an error - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Logs file was increased it's size extremely fast - http://www.zuzlan.name/hlam/mysqld.log-old2.zip
From this time I could successfully restore DB from backups, but the problem isn't gone anywhere
We had no idea what to do with this, so decision was reinstall "mysql" manually (dont know how to do it with Vesta Panel).It wasn't help, so we decided to delete all DB files with Midnight Commander (it was impossible to delete bases with Panel). After files delete - everything is fine. Then we resore DB from backup again. At this time problem was gone.
Still have no idea how fix it simply in case the problem appears again