by doberman36 » Mon Aug 03, 2015 3:18 pm
Hi friends your problems fix whith it is
Sorry, there are no available sessions error in vicidial goautodial vicibox or Asterisk
Sorry, there are no available sessions
(vicidial , goautodial , vicibox, asterisk)
*****************************************
Error: Sorry, there are no available sessions
*****************************************
The major cause for this alert in vicidial
The vicidial is using the MeetMe conference module for the agent sessions.,These MeetMe conference module requires timing resources like DAHDI, ZAPTEL, or hardware based module like sangoma USB timer , if they are not installed or loaded properly this alert will be displayed
Forget to update the new ipaddress in the vicidial database
Wrong ip set in DB even after ip updated using the vicidial script
MeetMe conference sessions are not created or deleted accidently
*****************************************
Updating the server ip in DB
*****************************************
Once you have changed the server ip address you need to update the same ip in the vicidial database , run the below command to update ip in vicidial db
#/usr/share/astguiclient/ADMIN_update_server_ip.pl
just press enter fro prompts.
*****************************************
Force update the IP in DB
*****************************************
Sometimes the new ip wont get updated ,even after running the IP update script. or db get updated with some funcky letters instead of ip (like localhost,a]b]d],127.0.0.1:mask2
run the below command to force the new ip to update in db
#/usr/share/astguiclient/ADMIN_update_server_ip.pl --old-server_ip=oldipaddress
enter your new ip when it prompts for new ip.
note: if your db is update with ip as 127.0.0.1:mask2 then run below command
#/usr/share/astguiclient/ADMIN_update_server_ip.pl --old-server_ip=127.0.0.1:mask2
*****************************************
update ip with mysql commands
*****************************************
you can update the mysql commands to update the ip, below are the commands and tables to be udpated with new ip
login to mysql cli using below commands
mysql -p ; if you know the mysql root password
or
mysql -u cron -p 1234
mysql>use asterisk
mysql>UPDATE conferences SET server_ip='newip' where server_ip='oldip'
mysql>UPDATE vicidial_conferences SET server_ip='newip' where server_ip='oldip'
mysql>UPDATE servers SET server_ip='newip' where server_ip='oldip'
mysql>UPDATE phones SET server_ip='newip' where server_ip='oldip'
myql>quit
reboot the server
note ** replace newip and oldip with your server ipaddress.
****************************************
once rebooted and login as agent and check whether your issue resolved.
if problem still arises, kindly post in the vicidial or goautodial
bye