Page 1 of 1

no one in your session

PostPosted: Thu May 05, 2011 10:43 am
by striker
goautodial ce 2.0 | 2.2.1 | no extra software

upgrade to svn and svn verison VERSION: 2.4-309a |BUILD: 110430-1642


i have changed the server ip and also run the update ip script

but only the ADMIN=>server ip gets updated , but the conference server ip is not chaging and it is empty

if i manually modify the conference no and assign the server ip its not taking effect.
due to this i am getting no one session

how to make the conference no get the server ips

PostPosted: Thu May 05, 2011 2:37 pm
by williamconley
if you upgrade to the latest svn, you can no longer use gardo's cool web interface for ip updating.

you have to use the /usr/share/astguiclient script.

i'm not sure if it'll work now that there is a "blank" ip in there, but you can try it with a blank "before" ip and see if it works. 8)

SOLVED

PostPosted: Thu May 05, 2011 10:58 pm
by striker
i have solved

i deleted all the conferences and created new one , now its working perfect

PostPosted: Sat May 07, 2011 12:15 am
by williamconley
for the next guy: a sql command to change all conference IP's to the server ip would work. if the system is "standalone". 8)

But that would require sql access ... and your method didn't. :)

sql command

PostPosted: Sat May 07, 2011 12:24 am
by striker
i did through the sql command only


delete from phones where extension like 'cc3%';
delete from conferences where conf_exten like '86000%'
delete from vicidial_conferences where conf_exten like '86000%'

and edited the sip-iax_phone.sql and first-server.sql with the current ip and only the required datas
and i run \. /usr/src/astguiclient/sip-iax_phone.sql
\. /usr.src.astguiclient/first-server.sql

PostPosted: Sat May 07, 2011 12:57 am
by williamconley
interesting:

update phones set ip ='xxx.xxx.xx.xx';

same with the other two tables ... (since there's only one server)

also: you can run the sql file without alteration, then run the update server ip script with 10.10.10.15 as the before and your present ip as the after and ... bob's your uncle, they are all correct with no editing of the file. :)

Tips and Tricks.

update

PostPosted: Sat May 07, 2011 1:03 am
by striker
thanks for this command.

i just started learning mysql little bit

PostPosted: Sun May 08, 2011 12:51 am
by williamconley
sql (my and ms) is a neverending battle (the more you learn the less you know). But it is fun. 8)