Page 1 of 1

Database Entry Not Matching

PostPosted: Mon Sep 16, 2013 1:47 pm
by 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.

Re: Database Entry Not Matching

PostPosted: Mon Sep 16, 2013 4:25 pm
by Yanela08
Anyone to help?

Re: Database Entry Not Matching

PostPosted: Tue Sep 17, 2013 3:51 am
by 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 :wink:

Re: Database Entry Not Matching

PostPosted: Tue Sep 17, 2013 10:43 am
by Kumba
Did you follow the vicibox documentation for installation? What ISO are you using? What are the installation options you used on each server?

Re: Database Entry Not Matching

PostPosted: Tue Sep 17, 2013 3:37 pm
by 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.

Re: Database Entry Not Matching

PostPosted: Tue Sep 17, 2013 7:37 pm
by Kumba
What's the output of this SQL query: select * from asterisk.vicibox;

Re: Database Entry Not Matching

PostPosted: Wed Sep 18, 2013 4:33 am
by DomeDan
oh sorry, typed that query wrong, its how Kumba wrote it