Converting Express to Cluster

[shanepearce]

Hello,

I am new to vicidial. I have been using it some time and i have attempted my first installation. i have managed to get the express install working fairly well for both inbound and outbound calls. Please see my settings below:

Linux vicibox7 4.1.31-30-default #1 SMP PREEMPT Wed Aug 24 06:20:09 UTC 2016 (de9ddf8) x86_64 x86_64 x86_64 GNU/Linux
VERSION: 2.12-565a
BUILD: 160827-0917
Asterisk 11.22.0-vici
Installed from ISO on vicibox website.
No customization

However, i wanted to manage the load and increase agents so i decided to change my install to a cluster. I downloaded a fresh copy of the vicibox ISO from the website today (21 Feb 2016) and installed using vicibox-install. Used expert installation, used my previous express as the database and web server and used the new server as a telephony server. I select not first device in cluster and dont have an archive server and didnt use this server to be an archived server.

The installation completed, i added the server details on the database/web of the new telephony server. everything seemed good up to there. The problem occurred when i tried to register a softphone on the new telephony server. I keep getting the following error (despite the password being correct):

Code: Select all

NOTICE[1513]: chan_sip.c:28490 handle_request_register: Registration from '"3000"<sip:3000@10.0.1.120:5060>' failed for '10.0.1.213:50481' - Wrong password

I restarted both servers and tried several times but i keep getting the same issue.

I turned on sip debug and get the following results:

Code: Select all

[Feb 21 18:53:36] <--- SIP read from UDP:10.0.1.213:57250 --->
[Feb 21 18:53:36] REGISTER sip:10.0.1.120:5060 SIP/2.0
[Feb 21 18:53:36] Via: SIP/2.0/UDP 10.0.1.213:57250;branch=z9hG4bK-d8754z-3d2f0020f96a8c43-1---d8754z-;rport
[Feb 21 18:53:36] Max-Forwards: 70
[Feb 21 18:53:36] Contact: <sip:3000@10.0.1.213:57250;rinstance=91a7dd41e40b6ec3>
[Feb 21 18:53:36] To: "3000"<sip:3000@10.0.1.120:5060>
[Feb 21 18:53:36] From: "3000"<sip:3000@10.0.1.120:5060>;tag=3b1b4775
[Feb 21 18:53:36] Call-ID: NTA2ZmM0MGJmNzM0MWNlMTQ5ZjBhYjhhZTJkOTFjNWY.
[Feb 21 18:53:36] CSeq: 1 REGISTER
[Feb 21 18:53:36] Expires: 120
[Feb 21 18:53:36] Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REGISTER, SUBSCRIBE, NOTIFY, REFER, INFO, MESSAGE
[Feb 21 18:53:36] Supported: replaces
[Feb 21 18:53:36] User-Agent: 3CXPhone 6.0.25732.0
[Feb 21 18:53:36] Content-Length: 0
[Feb 21 18:53:36]
[Feb 21 18:53:36] <------------->
[Feb 21 18:53:36] --- (13 headers 0 lines) ---
[Feb 21 18:53:36] Sending to 10.0.1.213:57250 (NAT)
[Feb 21 18:53:36] Sending to 10.0.1.213:57250 (NAT)
[Feb 21 18:53:36]
[Feb 21 18:53:36] <--- Transmitting (NAT) to 10.0.1.213:57250 --->
[Feb 21 18:53:36] SIP/2.0 401 Unauthorized
[Feb 21 18:53:36] Via: SIP/2.0/UDP 10.0.1.213:57250;branch=z9hG4bK-d8754z-3d2f0020f96a8c43-1---d8754z-;received=10.0.1.213;rport=57250
[Feb 21 18:53:36] From: "3000"<sip:3000@10.0.1.120:5060>;tag=3b1b4775
[Feb 21 18:53:36] To: "3000"<sip:3000@10.0.1.120:5060>;tag=as38109a32
[Feb 21 18:53:36] Call-ID: NTA2ZmM0MGJmNzM0MWNlMTQ5ZjBhYjhhZTJkOTFjNWY.
[Feb 21 18:53:36] CSeq: 1 REGISTER
[Feb 21 18:53:36] Server: Asterisk PBX 11.25.1-vici
[Feb 21 18:53:36] Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE
[Feb 21 18:53:36] Supported: replaces, timer
[Feb 21 18:53:36] WWW-Authenticate: Digest algorithm=MD5, realm="asterisk", nonce="23610c5e"
[Feb 21 18:53:36] Content-Length: 0
[Feb 21 18:53:36]
[Feb 21 18:53:36]
[Feb 21 18:53:36] <------------>
[Feb 21 18:53:36] Scheduling destruction of SIP dialog 'NTA2ZmM0MGJmNzM0MWNlMTQ5ZjBhYjhhZTJkOTFjNWY.' in 32000 ms (Method: REGISTER)
[Feb 21 18:53:36]
[Feb 21 18:53:36] <--- SIP read from UDP:10.0.1.213:57250 --->
[Feb 21 18:53:36] REGISTER sip:10.0.1.120:5060 SIP/2.0
[Feb 21 18:53:36] Via: SIP/2.0/UDP 10.0.1.213:57250;branch=z9hG4bK-d8754z-347359089b6fde2f-1---d8754z-;rport
[Feb 21 18:53:36] Max-Forwards: 70
[Feb 21 18:53:36] Contact: <sip:3000@10.0.1.213:57250;rinstance=91a7dd41e40b6ec3>
[Feb 21 18:53:36] To: "3000"<sip:3000@10.0.1.120:5060>
[Feb 21 18:53:36] From: "3000"<sip:3000@10.0.1.120:5060>;tag=3b1b4775
[Feb 21 18:53:36] Call-ID: NTA2ZmM0MGJmNzM0MWNlMTQ5ZjBhYjhhZTJkOTFjNWY.
[Feb 21 18:53:36] CSeq: 2 REGISTER
[Feb 21 18:53:36] Expires: 120
[Feb 21 18:53:36] Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REGISTER, SUBSCRIBE, NOTIFY, REFER, INFO, MESSAGE
[Feb 21 18:53:36] Supported: replaces
[Feb 21 18:53:36] User-Agent: 3CXPhone 6.0.25732.0
[Feb 21 18:53:36] Authorization: Digest username="3000",realm="asterisk",nonce="23610c5e",uri="sip:10.0.1.120:5060",response="78908e39362c973fb3e6932f961947f1",algorithm=MD5
[Feb 21 18:53:36] Content-Length: 0
[Feb 21 18:53:36]
[Feb 21 18:53:36] <------------->
[Feb 21 18:53:36] --- (14 headers 0 lines) ---
[Feb 21 18:53:36] Sending to 10.0.1.213:57250 (NAT)
[Feb 21 18:53:36]
[Feb 21 18:53:36] <--- Transmitting (NAT) to 10.0.1.213:57250 --->
[Feb 21 18:53:36] SIP/2.0 403 Forbidden
[Feb 21 18:53:36] Via: SIP/2.0/UDP 10.0.1.213:57250;branch=z9hG4bK-d8754z-347359089b6fde2f-1---d8754z-;received=10.0.1.213;rport=57250
[Feb 21 18:53:36] From: "3000"<sip:3000@10.0.1.120:5060>;tag=3b1b4775
[Feb 21 18:53:36] To: "3000"<sip:3000@10.0.1.120:5060>;tag=as38109a32
[Feb 21 18:53:36] Call-ID: NTA2ZmM0MGJmNzM0MWNlMTQ5ZjBhYjhhZTJkOTFjNWY.
[Feb 21 18:53:36] CSeq: 2 REGISTER
[Feb 21 18:53:36] Server: Asterisk PBX 11.25.1-vici
[Feb 21 18:53:36] Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE
[Feb 21 18:53:36] Supported: replaces, timer
[Feb 21 18:53:36] Content-Length: 0
[Feb 21 18:53:36]
[Feb 21 18:53:36]
[Feb 21 18:53:36] <------------>
[Feb 21 18:53:36] NOTICE[1513]: chan_sip.c:28490 handle_request_register: Registration from '"3000"<sip:3000@10.0.1.120:5060>' failed for '10.0.1.213:57250' - Wrong password
[Feb 21 18:53:36] Scheduling destruction of SIP dialog 'NTA2ZmM0MGJmNzM0MWNlMTQ5ZjBhYjhhZTJkOTFjNWY.' in 32000 ms (Method: REGISTER)
[Feb 21 18:54:01]   == Manager 'sendcron' logged on from 127.0.0.1


can someone please help me out with this?

[williamconley]

Please list the full version of the installer. It can make a difference. (not just "7", but "7.X.X")

i added the server details on the database/web of the new telephony server

What does that mean?

Did you add a phone to your new server under admin->Phones (or move an existing one)?

[shanepearce]

Thanks for the response.

the version is: ViciBox v.7.0.3-160505

"i added the server details on the database/web of the new telephony server" means: I logged in the express installed server, navigated to admin=>servers and then Added a new server. Please the IP address of the Telephony server and it was linked.

i tried both: I added a phone and i moved one. Both instances resulted in the same Authentication Issue.

[williamconley]

... I logged in the express installed server, navigated to admin=>servers and then Added a new server...

If the server wasn't there already, you installed it wrong. Likely the new dialer did not have DB access.

Where in the installation instructions did you see "navigated to admin=>servers and then Added a new server"? Are you using the PDF from Vicibox.com to install?

That step doesn't exist in the PDF because the installation script does it for you. If the server isn't listed under Admin->Servers when the install is complete ... something went wrong and you need to start over and pay attention for errors.

Before you begin, try this at the command line of the new server (replace 00.00.00.00 with the local IP of the original server):

Code: Select all

mysql -h 00.00.00.00 -u cron -p1234 asterisk -e "select * from vicidial_users"

If this fails, then your new server can't access the original server's DB, and installation will fail.

[shanepearce]

Thanks William. I will start over.

I don't recall seeing any errors. A couple of times I had to retry the install because the database couldn't connect and the install was halted. But I turned off my firewall and everything went thru.

Nevertheless I will retry it and see what happens. Those instructions were not in the guide. I just assumed I had to do it since I didn't see it pop up. I have one question tho. Would it havery made a different if the first server was done in express mode?

Also when installing the telephony service since this would be the first addition to the express install server (that will now turn the DB and Web server) what are the correct options to select?

I selected: expert mode - Yes. First system in cluster - No. Have archive server - No. Is this archive server - No. Telephony server - yes. I set the IP address for the database and for the Telephony server and let the installation continue. Then reboot.

Thank you so far for the assistance.

[williamconley]

... But I turned off my firewall and everything went thru.

Would it havery made a different if the first server was done in express mode?

Also when installing the telephony service since this would be the first addition to the express install server (that will now turn the DB and Web server) what are the correct options to select?

I selected: expert mode - Yes. First system in cluster - No. Have archive server - No. Is this archive server - No. Telephony server - yes. I set the IP address for the database and for the Telephony server and let the installation continue. Then reboot.

Everything did not "go through" if there was no entry. If you have to take steps not listed in the instructions, something is wrong. Usually it's best to start over (doing this several times until you get it right will increase your understanding of the system, too: less fear!)

The installation method of the original server doesn't matter except in some very technical ways. A good way to be sure everything is compatible is to upgrade the original server first (instructions in the svn folder in a document called "upgrade"). Perform a full backup before upgrade. Get the backup file off the server. Perform another full backup after the upgrade AND verifying the everything still works. Get that backup off the server, too.

There is no "correct options" to select. There are only the option you want. If you want it to perform a role, select it. It *can* be both web and dialer. It can even be archive if you want. That part's up to you.

Do remember to delete the entry you made in admin->servers before you try again.

[shanepearce]

thanks William.

I am about to do this now.

Will let you know.

[shanepearce]

Hi William,

So i am trying to redo the install.

After the prompt: Please input the master database IP address (10.0.1.120): 10.0.1.119
Do you want to connect using the default ViciDial DB settings? [Y/n]:y
Database entry does not match settings supplied! Enabling legacy mode!
Please verify all data before continuing! Installing on a cluster that is already set-up can cause irreparable damage! You have been warned.

Will this server be used as a Web Server?

----

Could this be whats causing the issue

[williamconley]

Database entry does not match settings supplied!

I's complaining because something doesn't match. SVN revision level? DB Schema of the vicidial in the new server vs the previously installed one ...

did you upgrade the old server first so they definitely match?

The SVN revision level of the two servers must match before you initiate the install. Upgrading the old one to the newest level and "svn up" in the new server (in case there's been an update to the svn since your original install attempt) will ensure that both servers are on the latest svn.

[shanepearce]

I am trying to access the instructions - but i am getting a Permission denied message.

-bash: /usr/src/astguiclient/trunk/UPGRADE: Permission denied

[williamconley]

"access" the instructions? using bash?

bash is a script execution program. the upgrade file is not a "script" it's a text file designed for a human to read it in english. you'll want to "access" it by using a text editor or displaying the contents directly on the screen. You could even use "WinSCP" and copy the file to your local hard drive and open it in Word/Wordpad/Notepad/Notepad++

"nano" is a good text editor. "cat" will display the contents on the screen.

You may need to take a quick course in "linux basics". Just sayin' ...

[shanepearce]

Thank you. i got it with Nano.

I have used nano before but couldnt remember.

Indeed i need to do a quick course. lol I am currently learning along the way.

[shanepearce]

Quick question William:

The document states instructions for upgrade from 2.11 to 2.12. However, then i check from the web portal on the bottom left side and the version is:
VERSION: 2.12-565a
BUILD: 160827-0917

would that alter any of the instructions?

[williamconley]

2.12 is not a "single version point". It's a major revision. The DB structure probably changes a hundred times *During* each revision, and the other scripts probably change several hundred times. So each time you install and get the "latest svn", you may still be within 2.12 (or whatever the present version is), but the DB structure may have several minor changes in it. So you always have to apply, at least, the latest sql script. We like to check the db schema version (admin->System Settings) and delete all the sql lines before that schema level in the sql script. That way we're starting at the last applied line and moving forward instead of overlapping.

In summary: When you're in 2.12, you still need to run the 2.12 sql script for later upgrades within 2.12.

If you want to avoid changes to the DB, you would instead match the Vicidial SVN Revision level of the DB on all the other servers (assuming the svn folder has the same scripts as those actually running on the server).

Complex, I know. But an understanding of this concept is required:

The astguiclient/trunk/ folder contains the SVN controlled scripts and files. These are not used at all. They are ONLY for storage. When you run the install script in this folder, it takes all these files and populates the rest of the server by merely copying them to their proper locations outside that folder. At that moment, the /trunk/ folder and all those other locations now have identical files. But what if you "svn up" in the /trunk/ folder later? Then the /trunk/ folder may have a more recent copy of the files, but this has no effect on the running server. So now "svn info" will return the svn level of the /trunk/ folder, but NOT of the running system. Awkward.

[shanepearce]

Update:

So i did the back up and decided to try the update. I typed in the: mysql -f --database=asterisk < /usr/src/astguiclient/trunk/extras/upgrade_2.12.sql
and it resulted in a series of errors at various lines. (ERROR 1060 (42S21) at line XXX: Duplicate column name 'xxxxxxxxx' or Duplicate entry 'AGENTDIRECT_CHAT' for key 'PRIMARY' or Table 'vicidial_ivr_response' already exists.

[williamconley]

... We like to check the db schema version (admin->System Settings) and delete all the sql lines before that schema level in the sql script. That way we're starting at the last applied line and moving forward instead of overlapping. ...

We usually make a copy of the file and delete the "already run" lines from it, and then run the copy instead of the original.

[shanepearce]

Okay

i have completed the update and tried to redo the installation of the telephony server, but i get the same message about connecting to the DB.

[williamconley]

"the same message"? doesn't tell me much. If it's that mismatch complaint, be sure you svn upgraded both servers and upgraded the db with that same svn upgraded sql script.then the db schema and the scripts on both servers should all match.

I posted an example mysql connection string earlier. Until it works you can not begin the installation attempt. Pointless.

[shanepearce]

So i have tried a different approach.

Decided to start from scratch and install on two fresh systems.

I did the cluster install using the .iso file. I have the DB, Web and telephony installed on one, and just the Web and Telephony on the other. I rebooted after installation. I visited the reports section and i saw both of my servers listed at the bottom of the page. The times were also insync. The default phones that were created i got get them to register on my softphone.

However, my problem arises when i try to add new phones.

DB/web/tele Server: 10.0.1.120
ViciBox v.7.0.4-170113
Asterisk 11.25.1-vici
VERSION: 2.14-596a
BUILD: 170228-1621
No customizations

web/tele Server: 10.0.1.121
- ViciBox v.7.0.4-170113
Asterisk 11.25.1-vici
VERSION: 2.14-596a
BUILD: 170228-1621
No customizations

the only difference i see (i dont know if its right or wrong) but when i go to the servers section. In the list under the asterisk column, i see two different numbers shown for the servers.

DB/wb/tele: 11.25.1-vici
web/tele: 1.4.21.2

I am not sure what the problem is, but i am adding all the mandatory information and i am still presented with the following message every time i try to add a phone:
PHONE NOT ADDED - Please go back and look at the data you entered
The following fields must have data: extension, server_ip, dialplan_number, voicemail_id, login, pass

Please assist.

[williamconley]

the only difference i see (i dont know if its right or wrong) but when i go to the servers section. In the list under the asterisk column, i see two different numbers shown for the servers.

DB/wb/tele: 11.25.1-vici
web/tele: 1.4.21.2

I am not sure what the problem is, but i am adding all the mandatory information and i am still presented with the following message every time i try to add a phone:
PHONE NOT ADDED - Please go back and look at the data you entered
The following fields must have data: extension, server_ip, dialplan_number, voicemail_id, login, pass

The asterisk value should be the result of "asterisk -V" on each of the servers. If you installed both with Vicibox 7.0.4, they should both be 11.25.1-vici.

But this does not have anything to do with your inability to add a phone. Your error message states that specific values are required. Were they all provided?

[shanepearce]

Hi William. Yes i have entered all the information. I tried it several time. Whenever i click the submit button, it shows the error message and removes all the data i supplied and just show the page with all the other fields.

[williamconley]

Perhaps you should try posting the information you're supplying.