Mytop error

[majdi33]

I am unable to run mytop. Any ideas on how to fix it guys ?

Cannot connect to MySQL server. Please check the:

* database you specified "admin_openxtt" (default is "")
* username you specified "da_admin" (default is "root")
* password you specified "MYda_adminPASSWD" (default is "")
* hostname you specified "localhost" (default is "localhost")
* port you specified "3306" (default is 3306)
* socket you specified "/tmp/mysqld.sock" (default is "")

The options my be specified on the command-line or in a ~/.mytop or
~/.my.cnf config file. See the manual (perldoc mytop) for details.

Here's the exact error from DBI. It might help you debug:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

root@mothership:/#

 

[SeLLeRoNe]

You need a ~/.mytop configuration file

Regards

 

[majdi33]

how to get it ? shall i mv usr/bin/mytop ?

 

[SeLLeRoNe]

you need the config file not the executable

Create a file as root in /root/.mytop and put:

user=da_admin
pass=DAPASS
host=localhost
db=mysql
delay=1
port=3306
socket=
batchmode=0
header=1
color=1
idle=1

Change the DAPASS with the pass listed in /usr/local/directadmin/conf/mysql.conf

Regards

 

[majdi33]

still not working

 

[SeLLeRoNe]

had you put the correct password? Have you put the file in the correct location? Are you starting mytop as root (or the user where you put the file)?

Regards

 

[majdi33]

The answer is yes to all of the above.

 

[SeLLeRoNe]

The error is the same? Check if you have an /etc/mytop file, and, ensure that mysql is working.

Regards

 

[majdi33]

mysql is working but i dont have a etc/mytop file

 

[SeLLeRoNe]

Honestly ive no more ideas, maybe someone else will have, otherwise, if you want i can log in your box and check it.

Regards

 

[Arieh]

What seems odd to me @ first post is

* socket you specified "/tmp/mysqld.sock" (default is "")

vs

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

 

[SeLLeRoNe]

Now ive got a new question, did you manually edited /usr/bin/mytop with wrong data?

Regards

 

[majdi33]

Now ive got a new question, did you manually edited /usr/bin/mytop with wrong data?

Regards

i did edit it with correct data -at least to my knowledge-

 

[SeLLeRoNe]

So thats why the /root/.mytop isnt working, i suppose that you edited not with correct data...

 

[majdi33]

here it is:

my %config = (
vt100 => 0,
batchmode => 0,
color => 1,
db => '',
database => '',
delay => 5,
filter_user => qr/.?/,
filter_db => qr/.?/,
filter_host => qr/.?/,
header => 1,
help => 0,
host => 'localhost',
idle => 1,
long_nums => 0,
mode => 'top',
prompt => 0,
pass => 'mydapassword',
password => '',
port => 3306,
resolve => 1,
socket => '',
sort => 0, # default or reverse sort ("s")
user => 'da_admin',
);

 

[SeLLeRoNe]

I would suggest you to remove and reinstall mytop (or restore this orignal file) and check with the /root/.mytop file ive suggested

Regards

 

[majdi33]

Honestly ive no more ideas, maybe someone else will have, otherwise, if you want i can log in your box and check it.

Regards

i've sent you the request login details.

 

[SeLLeRoNe]

i had full inbox, please resend.

Regards