MTOP question - cant find socket

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

MTOP question - cant find socket

Postby KeithHBW » Tue Jul 24, 2012 1:15 pm

I built my database server on opensuse 12.1 with mysql 5.1.

I attempt to run mtop but I get the error:
Unable to connect to mysql [Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)]
at main(/usr/local/bin/mtop:535)

The socket is at /var/run/mysql/mysql.sock
It is also stated as that in my my.cnf file
How do I get mtop to point to the correct location or not point at a socket at all.
Vicibox 7.0.1 from .iso | Vicidial 2.12b0.5 Build 160122-1401 | Asterisk 11.21.0-vici | Cluster | No Digium/Sangoma Hardware | No Extra Software After Installation | [Six Core CPU] Intel Xeon E5-2640 @ 2.50GHz
KeithHBW
 
Posts: 104
Joined: Fri Jan 13, 2012 12:58 pm

Re: MTOP question - cant find socket

Postby williamconley » Wed Jul 25, 2012 11:58 am

mtop has its own configuration file. that file is pointing to /tmp/mysql.sock (or not pointing at all, and it defaults to that). You could try finding the mtop configuration file and altering it.

But: as this server is not stock and you have not installed Vicidial on the server in question (just mysql), I would say this is a question for a mysql forum or an mtop forum (or even a mytop forum if you want to use that one instead).

Of course, you COULD copy the configuration from a working Vicidial server ...
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20278
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: MTOP question - cant find socket

Postby KeithHBW » Wed Jul 25, 2012 2:24 pm

Good thinking. But incase someone else has this problem in the future I used this to get around it:
mtop --host=192.168.x.x --dbuser=cron --password=1234
Vicibox 7.0.1 from .iso | Vicidial 2.12b0.5 Build 160122-1401 | Asterisk 11.21.0-vici | Cluster | No Digium/Sangoma Hardware | No Extra Software After Installation | [Six Core CPU] Intel Xeon E5-2640 @ 2.50GHz
KeithHBW
 
Posts: 104
Joined: Fri Jan 13, 2012 12:58 pm


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 75 guests