Vicidial Database connection with sqlyog

All installation and configuration problems and questions

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

Vicidial Database connection with sqlyog

Postby pintudas9051 » Fri Feb 28, 2020 10:23 am

Hello all,

Am using vicidial cluster base CTI+WWW CTI+WWW and one Database I just want to know that how can i connected my database server with sqlyog am trying to do that but it's not happening i tried to turn off the firewall also but it's not happening can anyone please help me

VERSION: 2.14-714a
BUILD: 190628-1511

Asterisk Version: 11.25.3-vici
Posts: 13
Joined: Thu Jan 30, 2020 6:47 am

Re: Vicidial Database connection with sqlyog

Postby williamconley » Sat Mar 07, 2020 12:40 pm

Good job posting your Vicidial Version with Build. Please try to remember to also post your Installer with Full Version. It helps. :)

I don't know what CTI+WWW CTI+WWW is. Please elucidate.

I don't know what sqlyog is either.

If you are trying to connect to the sql server from ... anywhere other than the sql server, you need a sql client. The sql client will need to have access to port 3306 (through the firewall). It will also need a valid user and password. The user being used by the sql client will also need to be in the users list in MySQL and have permission to read the Asterisk database from the IP of that client *or* from "%" (any IP). Often it's best to test access using the CLI mysql client on the accessing server (if the mysql client is on a server, of course). Then you can test with this on the cli to confirm access:

Code: Select all
mysql asterisk -h xx.xx.xx.xx -u cron -p1234

Replace xx.xx.xx.xx with the IP of the mysql/vicidial server. cron/1234 are the default user/pass and may just "work", but if you create a new user/pass, obviously you'll need to replace cron/1234 with that new user/pass. Note: It's NOT a typographical error that "-p1234" has no space in it and that "-u cron" does have a space in it.

The advantage of using this method is that any erorr will just be visible in the CLI so you can fix it. Some software is less communicative. 8-)

Review: Firewall port 3306, user/pass on client, same user/pass PLUS client IP in users table of sql server.

Happy Hunting! 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: NonDisruptive Lead Loader for Enterprise Vicidial Clusters.
(IE: Keep on dialing even while loading large lists!) # 352-269-0000 # +44(203) 769-2294
Posts: 19684
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicidial Database connection with sqlyog

Postby pintudas9051 » Mon Mar 09, 2020 3:57 am

thank you so much
Posts: 13
Joined: Thu Jan 30, 2020 6:47 am

Return to Support

Who is online

Users browsing this forum: No registered users and 72 guests