vicidial.org

by **cayo.narciso** » Fri Sep 16, 2016 9:53 pm

Hi,

I'm using GoAutoDial CE 3.3 with softphone Zoiper and I'm facing the following issue: After the login, the conference with softphone is not made and after a few seconds the goautodial screen get the error

"You have been disconnected.
Go Back

RECONNECT"

This problem started after we rebooted the server. It was working fine for months before that.
I've tried a lot of procedures but I can't find what's wrong. SIP registry seems to be fine:

Code: Select all: BRSP-ETN-AUTODIAL*CLI> sip show registry Host dnsmgr Username Refresh State Reg.Time 189.84.129.12:5060 N EN324 45 Registered Fri, 16 Sep 2016 23:52:50 1 SIP registrations.

[edited for legibility - williamconley]

[root@BRSP-ETN-AUTODIAL ~]# asterisk -r
Asterisk 1.8.23.0-1_centos5.go RPM by demian@goautodial.com, Copyright (C) 1999 - 2012 Digium, Inc. and others.
Created by Mark Spencer <markster@digium.com>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
=========================================================================
Connected to Asterisk 1.8.23.0-1_centos5.go RPM by demian@goautodial.com currently running on BRSP-ETN-AUTODIAL (pid = 5992)
Verbosity is at least 4

by **williamconley** » Sat Sep 17, 2016 12:00 pm

1) In all that information, I do not see your Vicidial version with Build. This information is required to get free support on this forum. And since you did not list it, I feel the urge to point out to you that Goautodial is merely an installer. It's not the actual software dialer suite. Vicidial is the Dialer. You could also have installed Vicidial with the Vicibox.com .iso CD (which is always more up-to-date and installs the latest version of Vicidial).

2) While you state that the sip registry "seems to be fine", you did not mention if the phone listed is the SIP account your zoiper phone is using. You also did not show a CLI example from the moment when you tried to log in.

by **cayo.narciso** » Sat Sep 17, 2016 3:12 pm

williamconley wrote:1) In all that information, I do not see your Vicidial version with Build. This information is required to get free support on this forum. And since you did not list it, I feel the urge to point out to you that Goautodial is merely an installer. It's not the actual software dialer suite. Vicidial is the Dialer. You could also have installed Vicidial with the Vicibox.com .iso CD (which is always more up-to-date and installs the latest version of Vicidial).

2) While you state that the sip registry "seems to be fine", you did not mention if the phone listed is the SIP account your zoiper phone is using. You also did not show a CLI example from the moment when you tried to log in.

Thank you for replying. I'd like to add the info that this is not a fresh install, we have been using this dialer for over a year. The issue started happening after the disk got full (recordings) and we had to move the calls and reboot the dialer. After that it seems that meetme.conf is no longer working and the error described earlier occurs.

1) Could you please help me finding the "build" version? This is the info I was able to get, vicidial is version 2.9rc1:

[root@gef ~]# cat /etc/goautodial-release
GoAutoDial CE 3.3
You have new mail in /var/spool/mail/root
[root@gef ~]# cat /usr/src/vicidial/version
2.9rc1

2)

This is an example of how we configure Zoiper softphone:

This is the carrier we use:

When I register the softphone Zoiper, I got these logs:

[Sep 17 17:08:10] -- Registered SIP '7000' at 10.14.100.180:60910
[Sep 17 17:08:10] NOTICE[3863]: chan_sip.c:25645 handle_request_subscribe: Received SIP subscribe for peer without mailbox: 7000

And when I log in to the goautodial screen, Zoiper softphone should receive a call to make the conference, but this is not happening. Zoiper is not receiving the conf call from Goautodial.

This is an example of when it was working. After logging in on the Zoiper softphone and Goautodial, these used to be the logs:

[Sep 14 17:08:33] > Channel SIP/7000-0000000c was answered.
[Sep 14 17:08:33] -- Executing [8600051@default:1] MeetMe("SIP/7000-0000000c", "8600051,F") in new stack
[Sep 14 17:08:33] == Manager 'sendcron' logged off from 127.0.0.1
[Sep 14 17:08:33] == Parsing '/etc/asterisk/meetme.conf': [Sep 17 17:08:33] == Found
[Sep 14 17:08:33] == Parsing '/etc/asterisk/meetme-vicidial.conf': [Sep 17 17:08:33] == Found
[Sep 14 17:08:33] -- Created MeetMe conference 1023 for conference '8600051'
[Sep 14 17:08:33] -- <SIP/7000-0000000c> Playing 'conf-onlyperson.gsm' (language 'en')
gef*CLI>

But now the conf is not being made and these logs are not shown on the CLI

by **williamconley** » Sat Sep 17, 2016 3:29 pm

If your drive was full, you need to check for broken tables after deleting enough files to have at least 5% available (and you should not use it in production unless you can start the day with 25% available).

Code: Select all: mysql asterisk -e "show table status where comment like '%crashed%'" --user=cron -p1234 mysqlcheck --auto-repair --user=cron -p1234 asterisk broken_table_name(s)

Or just check/fix everything, takes longer but is quite thorough:

Code: Select all: mysqlcheck --all-databases --auto-repair --user=cron -p1234

If any tables were repaired, reboot

by **cayo.narciso** » Sat Sep 17, 2016 9:17 pm

williamconley wrote:If your drive was full, you need to check for broken tables after deleting enough files to have at least 5% available (and you should not use it in production unless you can start the day with 25% available).
Code: Select all
mysql asterisk -e "show table status where comment like '%crashed%'" --user=cron -p1234 mysqlcheck --auto-repair --user=cron -p1234 asterisk broken_table_name(s)

Or just check/fix everything, takes longer but is quite thorough:
Code: Select all
mysqlcheck --all-databases --auto-repair --user=cron -p1234

If any tables were repaired, reboot

Thank you William. It has repaired two tables (asterisk.vicidial_user_log and asterisk.vicidial_manager ).
But the issue has changed. Now when I try to login, the softphone receives the conf call, but when I answer, I listen a message "I'm sorry, that's not a valid extension, please try again."
The goautodial screen redirects to the message: "Sorry, there are no available sessions"

And these are the logs:

[Sep 17 21:47:12] > Channel SIP/7000-00000003 was answered.
[Sep 17 21:47:12] == Starting SIP/7000-00000003 at default,,1 failed so falling back to exten 's'
[Sep 17 21:47:12] == Starting SIP/7000-00000003 at default,s,1 still failed so falling back to context 'dult'
[Sep 17 21:47:12] -- Sent into invalid extension 's' in context 'default' on SIP/7000-00000003
[Sep 17 21:47:12] -- Executing [i@default:1] Playback("SIP/7000-00000003", "invalid") in new stack
[Sep 17 21:47:12] == Manager 'sendcron' logged off from 127.0.0.1
[Sep 17 21:47:12] -- <SIP/7000-00000003> Playing 'invalid.gsm' (language 'en')
[Sep 17 21:47:16] -- Executing [i@default:2] Hangup("SIP/7000-00000003", "") in new stack
[Sep 17 21:47:16] == Spawn extension (default, i, 2) exited non-zero on 'SIP/7000-00000003'
[Sep 17 21:47:16] -- Executing [h@default:1] AGI("SIP/7000-00000003", "agi://127.0.0.1:4577/call_log--Huses--PRI-----NODEBUG-----16---------------") in new stack
[Sep 17 21:47:16] -- <SIP/7000-00000003>AGI Script agi://127.0.0.1:4577/call_log--HVcauses ... ---------- completed, returning 0

Also, the output for "cat /etc/asterisk/sip-vicidial.conf" doesn't show all the extensions I have created. If try to login using one of the old extensions created on goautodial, logs show that password is wrong, even though it is correct. Example:

[Sep 17 23:17:06] NOTICE[5028]: chan_sip.c:25486 handle_request_subscribe: Failed to authenticate device <sip:4006@10.14.25.18;transport=UDP>;tag=895d1905
[Sep 17 23:17:06] NOTICE[5028]: chan_sip.c:25829 handle_request_register: Registration from '<sip:4006@10.14.25.18;transport=UDP>' failed for '10.14.100.180:64200' - Wrong password

by **williamconley** » Sat Sep 17, 2016 11:01 pm

Now you need to rebuild your asterisk.conf files by going to admin->servers and changing all the "N" entries regarding rebuild to "Y". Those files were likely unable to be written and need to be forced to be created now that the system is up and has enough hard drive space to write them.

by **cayo.narciso** » Mon Sep 19, 2016 8:08 am

williamconley wrote:Now you need to rebuild your asterisk.conf files by going to admin->servers and changing all the "N" entries regarding rebuild to "Y". Those files were likely unable to be written and need to be forced to be created now that the system is up and has enough hard drive space to write them.

Thank you again. I've found it and changed the "Rebuild conf Files" from "N" to "Y", saved and rebooted the server, but it is like it didn't affect anything...

I've checked the content of astguiclient.conf to make sure the ip address was correct and it is correct (10.14.25.18):

Code: Select all: [root@BRSP-ETN-AUTODIAL etc]# cat astguiclient.conf # astguiclient.conf - configuration elements for the astguiclient package # this is the astguiclient configuration file # all comments will be lost if you run install.pl again # Paths used by astGUIclient PATHhome => /usr/share/astguiclient PATHlogs => /var/log/astguiclient PATHagi => /var/lib/asterisk/agi-bin PATHweb => /var/www/html PATHsounds => /var/lib/asterisk/sounds PATHmonitor => /var/spool/asterisk/monitor PATHDONEmonitor => /var/spool/asterisk/monitorDONE # The IP address of this machine VARserver_ip => 10.14.25.18 # Database connection information VARDB_server => localhost VARDB_database => asterisk VARDB_user => cron VARDB_pass => 1234 VARDB_custom_user => custom VARDB_custom_pass => custom1234 VARDB_port => 3306 # Alpha-Numeric list of the astGUIclient processes to be kept running # (value should be listing of characters with no spaces: 123456) # X - NO KEEPALIVE PROCESSES (use only if you want none to be keepalive) # 1 - AST_update # 2 - AST_send_listen # 3 - AST_VDauto_dial # 4 - AST_VDremote_agents # 5 - AST_VDadapt (If multi-server system, this must only be on one server) # 6 - FastAGI_log # 7 - AST_VDauto_dial_FILL (only for multi-server, this must only be on one server) # 8 - ip_relay (used for blind agent monitoring) # 9 - Timeclock auto logout VARactive_keepalives => 1234568 # Asterisk version VICIDIAL is installed for VARasterisk_version => 1.8 # FTP recording archive connection information VARFTP_host => 10.14.25.14 VARFTP_user => admin VARFTP_pass => pwc@062014 VARFTP_port => 22 VARFTP_dir => GoAutoDialRec VARHTTP_path => http://10.14.25.14 # REPORT server connection information VARREPORT_host => 10.0.0.4 VARREPORT_user => cron VARREPORT_pass => test VARREPORT_port => 21 VARREPORT_dir => REPORTS # Settings for FastAGI logging server VARfastagi_log_min_servers => 3 VARfastagi_log_max_servers => 16 VARfastagi_log_min_spare_servers => 2 VARfastagi_log_max_spare_servers => 8 VARfastagi_log_max_requests => 1000 VARfastagi_log_checkfordead => 30 VARfastagi_log_checkforwait => 60 [root@BRSP-ETN-AUTODIAL etc]#

So the extensions I've created earlier are not on the sip-vicidial.conf file and the new ones I create are there, but doesn't work (I get redirected to a page "Sorry, there are no available sessions" and listen to a message "I am sorry, that's not a valid extension, please try again).

After some research I found that mysql table "vicidial_conferences" has the server_ip field empty instead of having the correct address, I think that's the problem, just don't know how to fix it.

Code: Select all: mysql> select * from vicidial_conferences; +------------+-----------+-----------+------------+---------------------+ | conf_exten | server_ip | extension | leave_3way | leave_3way_datetime | +------------+-----------+-----------+------------+---------------------+ | 8600051 | | | 0 | NULL | | 8600052 | | | 0 | NULL | | 8600053 | | | 0 | NULL | | 8600054 | | | 0 | NULL | | 8600055 | | | 0 | NULL | | 8600056 | | | 0 | NULL | | 8600057 | | | 0 | NULL | | 8600058 | | | 0 | NULL | | 8600059 | | | 0 | NULL | | 8600060 | | | 0 | NULL | | 8600061 | | | 0 | NULL | | 8600062 | | | 0 | NULL | | 8600063 | | | 0 | NULL | | 8600064 | | | 0 | NULL | | 8600065 | | | 0 | NULL | | 8600066 | | | 0 | NULL | | 8600067 | | | 0 | NULL | | 8600068 | | | 0 | NULL | | 8600069 | | | 0 | NULL | | 8600070 | | | 0 | NULL | | 8600071 | | | 0 | NULL | | 8600072 | | | 0 | NULL | | 8600073 | | | 0 | NULL | | 8600074 | | | 0 | NULL | | 8600075 | | | 0 | NULL | | 8600076 | | | 0 | NULL | | 8600077 | | | 0 | NULL | | 8600078 | | | 0 | NULL | | 8600079 | | | 0 | NULL | | 8600080 | | | 0 | NULL | | 8600081 | | | 0 | NULL | | 8600082 | | | 0 | NULL | | 8600083 | | | 0 | NULL | | 8600084 | | | 0 | NULL | | 8600085 | | | 0 | NULL | | 8600086 | | | 0 | NULL | | 8600087 | | | 0 | NULL | | 8600088 | | | 0 | NULL | | 8600089 | | | 0 | NULL | | 8600090 | | | 0 | NULL | | 8600091 | | | 0 | NULL | | 8600092 | | | 0 | NULL | | 8600093 | | | 0 | NULL | | 8600094 | | | 0 | NULL | | 8600095 | | | 0 | NULL | | 8600096 | | | 0 | NULL | | 8600097 | | | 0 | NULL | | 8600098 | | | 0 | NULL | | 8600099 | | | 0 | NULL | | 8600100 | | | 0 | NULL | | 8600101 | | | 0 | NULL | | 8600102 | | | 0 | NULL | | 8600103 | | | 0 | NULL | | 8600104 | | | 0 | NULL | | 8600105 | | | 0 | NULL | | 8600106 | | | 0 | NULL | | 8600107 | | | 0 | NULL | | 8600108 | | | 0 | NULL | | 8600109 | | | 0 | NULL | | 8600110 | | | 0 | NULL | | 8600111 | | | 0 | NULL | | 8600112 | | | 0 | NULL | | 8600113 | | | 0 | NULL | | 8600114 | | | 0 | NULL | | 8600115 | | | 0 | NULL | | 8600116 | | | 0 | NULL | | 8600117 | | | 0 | NULL | | 8600118 | | | 0 | NULL | | 8600119 | | | 0 | NULL | | 8600120 | | | 0 | NULL | | 8600121 | | | 0 | NULL | | 8600122 | | | 0 | NULL | | 8600123 | | | 0 | NULL | | 8600124 | | | 0 | NULL | | 8600125 | | | 0 | NULL | | 8600126 | | | 0 | NULL | | 8600127 | | | 0 | NULL | | 8600128 | | | 0 | NULL | | 8600129 | | | 0 | NULL | | 8600130 | | | 0 | NULL | | 8600131 | | | 0 | NULL | | 8600132 | | | 0 | NULL | | 8600133 | | | 0 | NULL | | 8600134 | | | 0 | NULL | | 8600135 | | | 0 | NULL | | 8600136 | | | 0 | NULL | | 8600137 | | | 0 | NULL | | 8600138 | | | 0 | NULL | | 8600139 | | | 0 | NULL | | 8600140 | | | 0 | NULL | | 8600141 | | | 0 | NULL | | 8600142 | | | 0 | NULL | | 8600143 | | | 0 | NULL | | 8600144 | | | 0 | NULL | | 8600145 | | | 0 | NULL | | 8600146 | | | 0 | NULL | | 8600147 | | | 0 | NULL | | 8600148 | | | 0 | NULL | | 8600149 | | | 0 | NULL | | 8600150 | | | 0 | NULL | | 8600151 | | | 0 | NULL | | 8600152 | | | 0 | NULL | | 8600153 | | | 0 | NULL | | 8600154 | | | 0 | NULL | | 8600155 | | | 0 | NULL | | 8600156 | | | 0 | NULL | | 8600157 | | | 0 | NULL | | 8600158 | | | 0 | NULL | | 8600159 | | | 0 | NULL | | 8600160 | | | 0 | NULL | | 8600161 | | | 0 | NULL | | 8600162 | | | 0 | NULL | | 8600163 | | | 0 | NULL | | 8600164 | | | 0 | NULL | | 8600165 | | | 0 | NULL | | 8600166 | | | 0 | NULL | | 8600167 | | | 0 | NULL | | 8600168 | | | 0 | NULL | | 8600169 | | | 0 | NULL | | 8600170 | | | 0 | NULL | | 8600171 | | | 0 | NULL | | 8600172 | | | 0 | NULL | | 8600173 | | | 0 | NULL | | 8600174 | | | 0 | NULL | | 8600175 | | | 0 | NULL | | 8600176 | | | 0 | NULL | | 8600177 | | | 0 | NULL | | 8600178 | | | 0 | NULL | | 8600179 | | | 0 | NULL | | 8600180 | | | 0 | NULL | | 8600181 | | | 0 | NULL | | 8600182 | | | 0 | NULL | | 8600183 | | | 0 | NULL | | 8600184 | | | 0 | NULL | | 8600185 | | | 0 | NULL | | 8600186 | | | 0 | NULL | | 8600187 | | | 0 | NULL | | 8600188 | | | 0 | NULL | | 8600189 | | | 0 | NULL | | 8600190 | | | 0 | NULL | | 8600191 | | | 0 | NULL | | 8600192 | | | 0 | NULL | | 8600193 | | | 0 | NULL | | 8600194 | | | 0 | NULL | | 8600195 | | | 0 | NULL | | 8600196 | | | 0 | NULL | | 8600197 | | | 0 | NULL | | 8600198 | | | 0 | NULL | | 8600199 | | | 0 | NULL | | 8600200 | | | 0 | NULL | | 8600201 | | | 0 | NULL | | 8600202 | | | 0 | NULL | | 8600203 | | | 0 | NULL | | 8600204 | | | 0 | NULL | | 8600205 | | | 0 | NULL | | 8600206 | | | 0 | NULL | | 8600207 | | | 0 | NULL | | 8600208 | | | 0 | NULL | | 8600209 | | | 0 | NULL | | 8600210 | | | 0 | NULL | | 8600211 | | | 0 | NULL | | 8600212 | | | 0 | NULL | | 8600213 | | | 0 | NULL | | 8600214 | | | 0 | NULL | | 8600215 | | | 0 | NULL | | 8600216 | | | 0 | NULL | | 8600217 | | | 0 | NULL | | 8600218 | | | 0 | NULL | | 8600219 | | | 0 | NULL | | 8600220 | | | 0 | NULL | | 8600221 | | | 0 | NULL | | 8600222 | | | 0 | NULL | | 8600223 | | | 0 | NULL | | 8600224 | | | 0 | NULL | | 8600225 | | | 0 | NULL | | 8600226 | | | 0 | NULL | | 8600227 | | | 0 | NULL | | 8600228 | | | 0 | NULL | | 8600229 | | | 0 | NULL | | 8600230 | | | 0 | NULL | | 8600231 | | | 0 | NULL | | 8600232 | | | 0 | NULL | | 8600233 | | | 0 | NULL | | 8600234 | | | 0 | NULL | | 8600235 | | | 0 | NULL | | 8600236 | | | 0 | NULL | | 8600237 | | | 0 | NULL | | 8600238 | | | 0 | NULL | | 8600239 | | | 0 | NULL | | 8600240 | | | 0 | NULL | | 8600241 | | | 0 | NULL | | 8600242 | | | 0 | NULL | | 8600243 | | | 0 | NULL | | 8600244 | | | 0 | NULL | | 8600245 | | | 0 | NULL | | 8600246 | | | 0 | NULL | | 8600247 | | | 0 | NULL | | 8600248 | | | 0 | NULL | | 8600249 | | | 0 | NULL | | 8600250 | | | 0 | NULL | | 8600251 | | | 0 | NULL | | 8600252 | | | 0 | NULL | | 8600253 | | | 0 | NULL | | 8600254 | | | 0 | NULL | | 8600255 | | | 0 | NULL | | 8600256 | | | 0 | NULL | | 8600257 | | | 0 | NULL | | 8600258 | | | 0 | NULL | | 8600259 | | | 0 | NULL | | 8600260 | | | 0 | NULL | | 8600261 | | | 0 | NULL | | 8600262 | | | 0 | NULL | | 8600263 | | | 0 | NULL | | 8600264 | | | 0 | NULL | | 8600265 | | | 0 | NULL | | 8600266 | | | 0 | NULL | | 8600267 | | | 0 | NULL | | 8600268 | | | 0 | NULL | | 8600269 | | | 0 | NULL | | 8600270 | | | 0 | NULL | | 8600271 | | | 0 | NULL | | 8600272 | | | 0 | NULL | | 8600273 | | | 0 | NULL | | 8600274 | | | 0 | NULL | | 8600275 | | | 0 | NULL | | 8600276 | | | 0 | NULL | | 8600277 | | | 0 | NULL | | 8600278 | | | 0 | NULL | | 8600279 | | | 0 | NULL | | 8600280 | | | 0 | NULL | | 8600281 | | | 0 | NULL | | 8600282 | | | 0 | NULL | | 8600283 | | | 0 | NULL | | 8600284 | | | 0 | NULL | | 8600285 | | | 0 | NULL | | 8600286 | | | 0 | NULL | | 8600287 | | | 0 | NULL | | 8600288 | | | 0 | NULL | | 8600289 | | | 0 | NULL | | 8600290 | | | 0 | NULL | | 8600291 | | | 0 | NULL | | 8600292 | | | 0 | NULL | | 8600293 | | | 0 | NULL | | 8600294 | | | 0 | NULL | | 8600295 | | | 0 | NULL | | 8600296 | | | 0 | NULL | | 8600297 | | | 0 | NULL | | 8600298 | | | 0 | NULL | | 8600299 | | | 0 | NULL | +------------+-----------+-----------+------------+---------------------+ 249 rows in set (0.00 sec) mysql>

===============================

EDIT:

I think I just fixed it. I've run the "update_server_ip" again but this time I've copied and paste an empty field to the "old server" option and then it finally got replaced by the correct server IP address

Now I think I have to check if other tables needs to be updated

by **Qressor** » Wed Sep 28, 2016 11:31 pm

Thank you again. I've found it and changed the "Rebuild conf Files" from "N" to "Y", saved and rebooted the server, but it is like it didn't affect anything

by **williamconley** » Tue Oct 18, 2016 8:30 pm

cayo.narciso wrote:So the extensions I've created earlier are not on the sip-vicidial.conf file and the new ones I create are there ....

I'm a little lost here. Either the extensions listed under admin->phones assigned to this server are present in sip-vicidial.conf, or not. "created earlier" vs "new ones I create" aren't clear enough for me. LOL

by **cayo.narciso** » Wed Oct 19, 2016 5:38 am

williamconley wrote:
cayo.narciso wrote:So the extensions I've created earlier are not on the sip-vicidial.conf file and the new ones I create are there ....

I'm a little lost here. Either the extensions listed under admin->phones assigned to this server are present in sip-vicidial.conf, or not. "created earlier" vs "new ones I create" aren't clear enough for me. LOL

Sorry, the extensions I created before the issue were not present in sip-vicidial.conf. But when I create new ones, the new ones appear on the sip-vicidial.conf. (But doesn't work anyways).
But the issue was fixed by replacing an empty field by the correct ip address. Thank you.

by **williamconley** » Tue Oct 25, 2016 12:55 am

Thanks for taking the time to clarify. Someone next month may benefit! 8-)

vicidial.org

"You have been disconnected. Go Back RECONNECT"

"You have been disconnected. Go Back RECONNECT"

Re: "You have been disconnected. Go Back RECONNECT"

Re: "You have been disconnected. Go Back RECONNECT"

Re: "You have been disconnected. Go Back RECONNECT"

Re: "You have been disconnected. Go Back RECONNECT"

Re: "You have been disconnected. Go Back RECONNECT"

Re: "You have been disconnected. Go Back RECONNECT"

Re: "You have been disconnected. Go Back RECONNECT"

Re: "You have been disconnected. Go Back RECONNECT"

Re: "You have been disconnected. Go Back RECONNECT"

Re: "You have been disconnected. Go Back RECONNECT"

Who is online