How To Restart Mysql
Mar 16, 2007
I'm on FreeBSD 6.2 dedicated server with root access control-panel Directadmin
Today i check that i cann't login into directadmin. at the same time ftp and ssh access are live.
try to do restart and after this mysql service is down too.
all my attempts to do restart aren't successful.
1. don't have http access to DA
2. have ftp access, but cann't overwrite files
3. have ssh access
4. mysql service is stoped
try to do mysql restart with this command
/usr/local/etc/rc.d/mysql-server.sh stop
but there isn't such file
try to connect to mysql and get such output
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2) in
View 9 Replies
ADVERTISEMENT
Jun 16, 2008
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies
View Related
Mar 16, 2007
I'm on FreeBSD 6.2 dedicated server with root access
control-panel Directadmin
Today i check that i cann't login into directadmin. at the same time ftp and ssh access are live.
try to do restart and after this mysql service is down too.
all my attempts to do restart aren't successful.
1. don't have http access to DA
2. have ftp access, but cann't overwrite files
3. have ssh access
4. mysql service is stoped
try to do mysql restart with this command
/usr/local/etc/rc.d/mysql-server.sh stop
but there isn't such file
try to connect to mysql and get such output
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2) in
View 1 Replies
View Related
Dec 5, 2008
Is anyone experiencing that cpanel automatically restarts mysql at 2AM?
I'm curious is that new feature or something has gone wrong?
This has started after cpanel upgrade mysql to 5.0.67 version.
I'm not so good with cpanel so please can somebody tell me where cpanel holds its crons?
I cannot find nothing in /etc/cron.* or in cron -l, and I want to turn this option off.
View 2 Replies
View Related
Nov 23, 2008
How to set up cron job automatic restart mysqld at specified time. My case, mysqld will auto restart every 23 hours running.
How to set up this cron job?
View 12 Replies
View Related
Apr 12, 2009
My vps is run well, then i reboot and i see mysql no longer working. I check in WHM
mysql (5.0.67-community) failed
And when restart (by WHM )
Restarting MySQL Server
whmappname='Restarting Service'; if (self['update_ui_status']) { update_ui_status('MySQL Server'); } Waiting for mysql to restart..............finished.
mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.xxxx.com.pid) running as root with PID 5275
mysql has failed, please contact the sysadmin (result was "mysql has failed").
My VPS in unmanaged, i can't access mysql.
View 4 Replies
View Related
Jun 1, 2008
One of our servers mysql daemon is restarting most of the time and got the error message in the message file. Did anyone see similar error message?
Jun 1 05:46:44 kernel: audit(1212317204.342:6991): avc: denied { read } for pid=17286 comm="mysqld" name="/" dev=loop0 ino=2 scontext=user_uystem_r:mysqld_t0 tcontext=system_ubject_r:file_t0 tclass=dir
Jun 1 05:46:44 kernel: audit(1212317204.343:6992): avc: denied { getattr } for pid=17286 comm="mysqld" path="/tmp" dev=loop0 ino=2 scontext=user_uystem_r:mysqld_t0 tcontext=system_ubject_r:file_t0 tclass=dir
Jun 1 05:46:44 kernel: audit(1212317204.346:6993): avc: denied { read } for pid=17286 comm="mysqld" name="time_zone_leap_second.frm" dev=hda2 in
View 1 Replies
View Related
Nov 22, 2007
I am not being able to restart the server, or MySQL or httpd via SSH.
PHP Code:
root@server [~]# /etc/init.d/httpd fullstatusLooking up localhostMaking HTTP connection to localhostAlert!: Unable to connect to remote host.lynx: Can't access startfile http://localhost/server-statusroot@server [~]#
PHP Code:
root@server [~]# /etc/init.d/mysql reload/etc/init.d/mysql: line 244: kill: (3375) - No such processtouch: cannot touch `/var/lib/mysql/server.lubnan.us.pid': Read-only file system
View 14 Replies
View Related
Sep 18, 2007
I have a lot of tables, being that I host multi forums. One thing I noticed when doing a mysql start up or restart is that it takes at least 15 minutes to do it. The server isn't bad, it's a Pentium D with 3GB of RAM and it runs perfectly fine. What I noticed is that after I do an SQL restart, I checked "top." The command that was running is "chown" and it sat at the top of the list, and kept going. Until finally mysql started and it stopped.
I imagine that all of the files in the data folder are being CHOWNed... and that's why it takes forever. If this is the case, how can I stop this, if at all? I don't see why they need to be CHOWNed?
View 4 Replies
View Related
Jan 29, 2009
Anyone know a good script that I can run with cron or something? Mysql seems to be the #1 problem with a lot of my web sites, a restart usually fixes it right away for me, but I can't keep restarting my servers everyday manually.
View 1 Replies
View Related
Jun 5, 2014
What could I fix by trying to start mysql server, recieve following errors:
plesk interface:
Code:
Failed to restart the "mysql" service.
Cannot start/stop/restart service: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) and then start(8) utilities,
e.g. stop mysql ; start mysql. The restart(8) utility is also available.
start: Job failed to start
from the console:
Code:
sudo service mysql start
start: Job failed to start
Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
output of plesk_11.5.30_reset_instance_data.log:
[Code] ...
View 4 Replies
View Related
Jul 3, 2007
I have directory shared by NFS on server1 this directory mounted at startup on server2.
problem happened when twice servers restarted and server2 started before server1. directory not mounted I must mount it manually.
View 4 Replies
View Related
Jul 19, 2007
One of my server's http daemon is restarting more often and it doesn't have any control panel. How can I checked the load or memory usage history?
View 3 Replies
View Related
May 8, 2009
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
View 4 Replies
View Related
Aug 31, 2006
I get the following message via SSH when i try named restart
named: symbol lookup error: named: undefined symbol: dns_resolver_setudpsize
All my sites are currently down but the server is up and bind wont restart either in WHM or SSH
i am using WHM 10.6.0 cPanel 10.8.0-R8
CentOS 4.3 i686 - WHM X v3.1.0
Linux ***.server.com 2.6.9-11.EL #1 Wed Jun 8 16:59:52 CDT 2005 i686 i686 i386 GNU/Linux
I spoke to live support at nexpoint but they told me to email their dedicated server support but I havent had a reply in the last few hours.
View 5 Replies
View Related
Apr 23, 2008
I have 8 apache servers that is sharing one httpd.conf file... When changes made in the httpd.conf, you have you restart httpd... How can I restart all 8 servers at the same time instead of logging into each server and do it manually?
View 2 Replies
View Related
Oct 13, 2009
i am having an issue with my vps recently my ftp is down and i cant restart my ftp not sure how i can get this fix.
View 8 Replies
View Related
May 28, 2009
how to restart lighthttpd?
I was asked to restart lighthttpd at my friend host, he has 6 sites running, and of the site is down, host has asked him to restart the server, as he is away, he wanted me to restart, but I have no clue how to restart lighthttpd,
It will be really helpful if u can guide me for : if possible for the domain alone, else for the entire server
current options available :
lxadmin - hypervm
ssh connection
let me know the steps and code if any.
View 4 Replies
View Related
Jul 17, 2009
We are unable to restart apache on our server, as a result no sites are accessible in the browser. Our host states we need to clear out the following files:
[root@server1 logs]# ls -lAh|grep -v ' 0 '
total 1.9G
-rw-r--r-- 1 root root 92M Jul 17 07:55 access_log
-rw-r----- 1 root root 463K Dec 9 2007 audit_log
-rw-r--r-- 1 root root 1.2G Jul 17 07:57 error_log
-rw-r--r-- 1 root root 6 Jul 17 07:42 httpd.pid
-rw-r--r-- 1 root root 92K Feb 18 2008 ssl_engine_log
-rw-r--r-- 1 root root 535M Jul 17 07:46 suexec_log
-rw-r--r-- 1 root root 10 Jul 17 03:21 suexec_log.offset
-rw------- 1 root nobody 5.6M Dec 10 2007 suphp_log
Is it ok to simply delete these files? If so, will they recreate
themselves?
View 14 Replies
View Related
May 23, 2008
after restarting my server i tried to start my shoutcast servers whicj right now its not working...i am getting an error when i am trying to start them again "error opening source socket! FATAL ERROR! Some other process is using this port!"
View 2 Replies
View Related
Mar 14, 2008
I have a few domains in a DA server whose stats stop working for a few months, any idea how to restart these few domains Webalizer? The rest of the domains' stats are working properly though
View 3 Replies
View Related
Nov 15, 2008
I just bought new DS 3 days ago : Intel Core2Duo 2.33 GHz, 2GB DDR2 RAM , 250 GB.
Today mysql automatic stop and not auto restart :|
I checked cron job: has no cron job there. I have just only one site on this server.
I check Check mysql error log:
081115 10:47:52 [Note] /usr/sbin/mysqld: Normal shutdown
081115 10:47:52 InnoDB: Starting shutdown...
081115 10:47:54 InnoDB: Shutdown completed; log sequence number 0 72782
081115 10:47:54 [Note] /usr/sbin/mysqld: Shutdown complete
081115 10:47:54 mysqld ended
081115 10:47:55 mysqld started
/usr/sbin/mysqld: File '/var/log/mysql-slow-queries.log' not found (Errcode: 13)
081115 10:47:55 [ERROR] Could not use /var/log/mysql-slow-queries.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
081115 10:47:55 InnoDB: Started; log sequence number 0 72782
081115 10:47:56 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
my.cnf file ....
View 8 Replies
View Related
Jan 22, 2008
when my clients log in into the webmail... they cant access Horde.. it just dont load.. if you go for squirrelmail it loads perfectly..
how can i restart horde from ssh(putty)?
View 8 Replies
View Related
Sep 12, 2007
[root@server1 /]# ps -aux |grep httpd
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.3/FAQ
apache 26023 0.5 0.9 12064 8744 ? S 05:28 0:04 /usr/sbin/lighttpd -f /etc/lighttpd/lighttpd.conf
root 32333 0.7 2.5 24456 22772 ? S 05:39 0:00 /usr/local/cpanel/whostmgr/bin/whostmgr ./reshttpd
root 32384 0.0 0.0 2152 524 pts/1 S+ 05:39 0:00 grep httpd
i want removed "lighttpd"
how may?
i don`t want killed it
View 0 Replies
View Related
Jul 1, 2007
I have configured the iptables ruleset to fit my taste, however after I did a reboot, my server still loaded the old one, any steps did I missed ?
What i did was :
1. edit rules
2. iptables-save > firewall.log
3. service iptables save
4. reboot
View 2 Replies
View Related
May 6, 2007
I'm running Apache 2.0.52 on a CentOS 4.4 server.
Running two static sites and one CMS.
I have no trouble logging in through SSH
Also no problem accessing webmin on port 10000
I've tried to restart Apache httpd
And tried to reboot the server...
Nothing.
I recently did a Yum Update,
also removed ISPconfig - it's probably the latter thats the problem, although I haven't used it - at all - just playing around setting up PHPmyadmin, Squirrelmail and a couple of email accounts.
But the only error log output I get is that there are no virtual servers for 88.198.81.186:80 and 88.198.81.187:80 and Unable to open logs | unable to start piped log program
Since the update and removal of ISPconfig 4-5 days ago there hasn't been any issues. I haven't done anything. Yet I do think might be some of the old ISPconfig settings acting up.
View 4 Replies
View Related
Dec 18, 2007
I'm on my first VPS with Virtuozzo / WHM and I'm wondering about what some general guidelines regarding best practices are in regards to restarting services and or the server. Specifically, I'm wondering what a good time frame it to restart the server and sevices.
I've been told VZ doesn't need to be restarted, but I figured that by restarting VZ, I restart everything at once... is this bad? How often should I do this or not do this?
Alternatively, if I just restart specific services, what is your experience on a good timeline and what services are important to restart?
I've read that mysql doesn't need to be restarted, but am wondering EXIM, http server, dns server, pop3 server, imap server, etc.... specifically what good schedule would be regarding restarting.
I'm simply trying to avoid issues that may occur due to not restarting and trying to be proactive as my clients are extremely important to me... ...
View 3 Replies
View Related
Sep 30, 2007
I'm having problems with Apache 2.0.54 on my Debian server. The command "apache2ctl restart" will not work properly. Let me explain. Whenever I run "apache2ctl restart" Apache will tell me it's running with no problems while it actually isn't. I run "apache2ctl start" and it tells me that httpd is already running according to a PID.
When I need to restart Apache I need to go and run "apache2ctl stop" and "apache2ctl start" which seems to work effectively. I tried recoding the system to run these two commands in the Perl backend of my web hosting control panel, but these two commands don't work since they seem to run at the same time.
So my question is this: how can I get the "apache2ctl restart" command to work again? Or better yet, how do I get Perl to run the "apache2ctl stop" and "apache2ctl start" commands without having them being run simultaneously?
View 14 Replies
View Related
Mar 11, 2007
maildir is enabled
1) Restore system to mbox (non-maildir) state.
2) Request Technical Support
3) Convert partially converted mail accounts
*) Exit
Enter Selection---] 3
quotaoff: quotactl on /dev/sda3 [/]: No such process
[1]+ Stopped /scripts/convert2maildir
root@server [~]#
The above just freezes and does nothing, had to manually stop after 5 minutes.
Restarting pop3 via whm gives this error:
cppop has failed, please contact the sysadmin.
Restart imap gives this:
imap has failed, please contact the sysadmin (result was "couriertcpd is not runningauthdaemond is not running").
I ran:
/scripts/courierup --force
/scripts/eximup --force
Did nothing, still cannot restart pop3/imapd
root@server [~]# /scripts/restartsrv_cppop
/etc/init.d/courier-imap: line 19: /usr/lib/courier-imap/etc/imapd: No such file or directory
/etc/authlib/authdaemonrc does not exist, forgot make install-configure?
root@server [~]# /scripts/restartsrv_imap
/etc/init.d/courier-imap: line 19: /usr/lib/courier-imap/etc/imapd: No such file or directory
/etc/authlib/authdaemonrc does not exist, forgot make install-configure?
I changed maildir=1 to 0 in cpanel.config file and ran convert2maildir again,
I got at the very end when it halted:
Unable to install courier. at /usr/local/cpanel/bin/maildirupdate line 51.
I tried to restart exim:
root@server [~]# /scripts/restartsrv_exim
Starting clamd: [ OK ]
Starting exim: 2007-03-11 10:25:37 Exim configuration error in line 670 of /etc/exim.conf:
option "maildir_format" unknown
[FAILED]
Starting exim-smtps: 2007-03-11 10:25:37 Exim configuration error in line 670 of /etc/exim.conf:
option "maildir_format" unknown
[FAILED]
Starting antirelayd: [ OK ]
Starting antirelayd: [ OK ]
View 1 Replies
View Related
Jun 3, 2008
We changed our SSH port (for the slight added security that this offers) and updated our CSF config with the new port so that we can accept connections on this port.
We restarted CSF and we could connect successfully on the new port. When the server is rebooted connections are refused on the port until we *RESTART* CSF then it's all good again.
I would think being that we opened the port in CSF's config that on reboot the port would be opened back up but this is not happening and any time the server is rebooted we have to restart the firewall.
Does anybody have any suggestions on how to "fix" this or at least make it so we don't have to manually restart the firewall?
View 6 Replies
View Related
