Database Entry Not Matching

[Yanela08]

Hi Gurus,

Trying to setup a cluster, 1 database, 1 web and 1 telephony by running vicibox-install. Web and Telephony is not connecting to the database as it says "Database entry does not match settings supplied! Enabling legacy mode!". I didn't change the default credentials and I can login to the other machine remotely by mysql -h <remote database ip> -u:<username> -p<password>. Please help.

Thanks in advance.

[Yanela08]

Anyone to help?

[DomeDan]

Make sure that the database ip you enter is exactly the same as the ip used to install the database server.
in other words, you cant install the database with the ip 127.0.0.1 (if that is possible, don't remember)

when you say you cant login remotely, what message did you get when trying?

login to the database server (locally) and run this query:
SELECT * FROM asterisk.vicidial;
I'm mostly interested to see what the 'server_ip' field contains, but post it all here,
and what was the ip-address to the database server that you wrote during the install when you got the "Database entry does not..." message?

also post the version name of the ISO you are installing with, you have been writing a few posts, you should know this

[Kumba]

Did you follow the vicibox documentation for installation? What ISO are you using? What are the installation options you used on each server?

[Yanela08]

Hi DomeDan, I'm typing in the ip address of the database server and it "CAN" log me into it use the syntax mysql -h <remote database ip> -u<user> -p<pass>. It's just that when I ran vicibox-install and type in the ip of the database server when it ask that it gives me the message "Database entry does not match settings supplied! Enabling legacy mode". I executed SELECT * FROM asterisk.vicidial from MYSQL and it gives me the message, "ERROR 1146 (42S02): Table 'asterisk.vicidial' doesn't exist. The remote ip of the database server is 192.168.70.50. Sorry about not having to post the version, it's Vicibox.x86_64-5.03.

@Kumba, I'm following Vicibox documentation installation from vicibox site. I executed vicibox-install for clustering server.

[Kumba]

What's the output of this SQL query: select * from asterisk.vicibox;

[DomeDan]

oh sorry, typed that query wrong, its how Kumba wrote it