MySQL and vm-Pop3d service

[sky]

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

[fusionictnl]

Maybe look in your log files ?? !

/var/log/messages

and give the output here!

[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"

[fusionictnl]

CAn you connect throug POP ?

[sky]

NO, i cant :(

[fusionictnl]

Can you run the command: vm-pop3d

and give the output

[sky]

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

[fusionictnl]

Same restart and check /var/log/messages

*EDIT* or run mysqld

[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

[fusionictnl]

Hmmm :)

Do the following through SSH:

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

Errors ;)

[sky]

I log as root.

I type in : su mysql

he reply : su: user mysql does not exist

Hum, what now? :(

[sky]

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

[fusionictnl]

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 ;)

[sky]

[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?

[fusionictnl]

Not likely normal.

Are you sure there isn't another mysql running ?

ps aux | grep mysqld

??

Else try upgrading mysql (reinstalling).

[sky]

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 ^^

[fusionictnl]

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

[sky]

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

[fusionictnl]

You can reset this by doing the steps explained on the mysql site:

http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html

[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

[sky]

Hum, i managed your tutoriel in fact :) afterall ^^

But, in DA, i still have :

Error connecting to MySQL: Access denied for user: 'da_admin@localhost' (Using password: YES)

Sky

[fusionictnl]

Why remove the user table ????

If you followed the steps explained on the Mysql site, you should just start mysql (deamon) with no security at all and set the root password.

It didn't say anywhere to remove the user table.

[fusionictnl]

Ok that's easy to fix ;)

Create a user in Mysql, all the rights GLOBAL

username: da_admin

password: look in the file /usr/local/directadmin/conf/mysql.conf

Or just change the settings in that file to:

username=root
password=[root password]

[sky]

Ok, when set to root (password), it work fine :)

Ok, well, kno, ill transfer all the website ^^

Thx for all your help :D

Cya soon,

Sky