MySQL and vm-Pop3d service

sky

Verified User
Joined
Nov 12, 2004
Messages
321
DA have just neeb installed.

MySQL and vm-Pop3d service are not started, and, when i click on restart or start, nothing happens, and i get a message saying mysql is not started.

I also tried to stop mysql, then start, but no luck ...

Have someone got a idea please ?
Thx

Sky
 
Well, the last 5 line :

Nov 15 13:26:12 h9-45 vm-pop3d: vm-pop3d startup succeeded
Nov 15 13:26:16 h9-45 vm-pop3d: vm-pop3d startup succeeded
Nov 15 13:26:21 h9-45 vm-pop3d: vm-pop3d startup succeeded
Nov 15 13:26:31 h9-45 vm-pop3d: vm-pop3d shutdown failed
Nov 15 13:26:31 h9-45 vm-pop3d: vm-pop3d startup succeeded

I suppose it mean's its ok, but, the statut of MySQL and pop3 is "Process is stopped"
 
OK POP3 Welcome to vm-pop3d etc...

So, i suppose its because of the domain is not yet propageted ?

And for the MySQL problem?
Have you got a idea ?

Thx :)

Sky
 
Euh, what should i restart?
In the /var/log/messages there is nothing abour mysqld...

When i type in mysqld in putty, its just sai :
[root@server root]# mysqld
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
041115 15:19:16 Aborting

041115 15:19:16 mysqld: Shutdown Complete

So, how to start mysqld if not in root ?


Thx for your time :)
Sky
 
Last edited:
Hmmm :)

Do the following through SSH:

su mysql (switch to user mysql)
mysqld (start mysql deamon)
exit (exit session [back to root])

Errors ;)
 
I log as root.

I type in : su mysql

he reply : su: user mysql does not exist

Hum, what now? :(
 
When i type just mysql as root, it send out :

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


Sky
 
Ok just run mysqld as any user on your system except root

mysql is the client :) if mysqld isn't running it will print out that error ;)
 
[root@server dayd]# su sky
sh-2.05b$ mysqld
041115 18:05:01 Warning: Can't create test file /var/lib/mysql/server.lower-test
041115 18:05:01 Can't start server : Bind on unix socket: Permission denied
041115 18:05:01 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
041115 18:05:01 Aborting

041115 18:05:01 mysqld: Shutdown Complete

sh-2.05b$


There it is ^^ lol
Hum, im starting to cry :(

Well, is it normal?
 
Not likely normal.

Are you sure there isn't another mysql running ?

ps aux | grep mysqld

??

Else try upgrading mysql (reinstalling).
 
When i do a ps aux | grep mysqld , i get this :

root 3139 0.0 0.1 4208 608 pts/6 S 22:00 0:00 grep mysqld

What does it mean? That there is one running ?

Thx again for your reply's ^^
 
No it doesn't look like one is running. What it's showing is that the grep mysqld is running ;)

I would recommend reinstalling mysql
 
Ok, john created a mysql user and fixed that up :)

Lol, know there is still a problem :(

Its says i cant connect to mysql with da_admin with a password ...

I whent into phpmyadmin, i tried root/nopassword and it worked, so, i whent into the user table, set a password on localhost and server.domain.fr....

And, know, cant login to phpmyadmin ...
I suppose that the password should be crypted yes?

After doing that stupid thing, what know?
And, appenrentl, there is no da_admin user in mysql ...

Sky
 
Hum, im realy not very good at all this stuff :confused:

Now, i managed to erase the mysql user table .... So, at least i can go into phpmyadmin, but, without the user table :(

Ill ask John...

Thx for your help

Sky
 
Back
Top