Page 1 of 1

Vicidial Database connection with sqlyog

PostPosted: Fri Feb 28, 2020 10:23 am
by pintudas9051
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

Re: Vicidial Database connection with sqlyog

PostPosted: Sat Mar 07, 2020 12:40 pm
by williamconley
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-)

Re: Vicidial Database connection with sqlyog

PostPosted: Mon Mar 09, 2020 3:57 am
by pintudas9051
thank you so much