Code Forums - View Single Post

sde · 12-07-2002, 12:47 PM

a friend of mine and myself share a server that we have co-located in l.a.

last week, we shipped the admins there some ram to upgrade the box.

every since they did the upgrade, mysql hasn't worked. in a "ps aux", it shows that mysqld is running. when i do a [SHELL]# /etc/init.d/mysqld restart[/SHELL] it will always "fail" the shutdown, but it will say "ok" for the start.

another thing that doesn't work since those guys changed the ram is "ntsysv". after i re-binded the /usr/sbin to the path, i can get it loaded, but it does not show, or retain the settings i make for the services to start. it is almost like it has nothing to do with what services are starting/stopping... i know this because "httpd" is not checked, but it does start on boot.

the mysql problem is the biggest though. i've removed all apache/mysql/php rpms and re-installed them all together, but i am still getting the same problem.

an "namp localhost" shows that port 3306 is open.

the error logs say that port 3306 is in use when i try to restart it. but even when i kill -9 all pids for mysql, it starts and says it's ok, but i get the same results.

any ideas?

12-07-2002, 12:47 PM	#1 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,487	MySQL problems a friend of mine and myself share a server that we have co-located in l.a. last week, we shipped the admins there some ram to upgrade the box. every since they did the upgrade, mysql hasn't worked. in a "ps aux", it shows that mysqld is running. when i do a [SHELL]# /etc/init.d/mysqld restart[/SHELL] it will always "fail" the shutdown, but it will say "ok" for the start. another thing that doesn't work since those guys changed the ram is "ntsysv". after i re-binded the /usr/sbin to the path, i can get it loaded, but it does not show, or retain the settings i make for the services to start. it is almost like it has nothing to do with what services are starting/stopping... i know this because "httpd" is not checked, but it does start on boot. the mysql problem is the biggest though. i've removed all apache/mysql/php rpms and re-installed them all together, but i am still getting the same problem. an "namp localhost" shows that port 3306 is open. the error logs say that port 3306 is in use when i try to restart it. but even when i kill -9 all pids for mysql, it starts and says it's ok, but i get the same results. any ideas?