Project

General

Profile

Forums » Open discussion »

update recording link

Added by george lagardo almost 9 years ago

Hello

I am currently using goautodial 3.0 since last fewmonths, due to some requirement i need to move complete server to another location as it is quite big server i descided to take a backup of the server and install the same version on to another new server.

old server ip was 192.168.1.253

new server ip is 192.168.1.153

so i did the backup using /usr/share/astguiclient/ADMIN_backup.pl

Restore by following Process:
- ls lat /var/log/astguiclient/archive/
 cd /var/log/astguiclient/archive/
- tar xvfz 192.168.1.253_ALL_0.tar.gz
- cd var/log/astguiclient/archive/
- mv 192.168.1.253* /
- cd /
- ls lat
 tar xvf 192.168.1.253_VOICEMAIL_0.tar
- tar xvf 192.168.1.253_CONF_0.tar
- tar xvf 192.168.1.253_BIN_0.tar
- tar xvf 192.168.1.253_LINUX_0.tar
- tar xvf 192.168.1.253_SOUNDS_0.tar
- (check for other tar files if you used other backup options)
- gunzip 192.168.1.253asterisk0.gz
- mysql asterisk
- \. 192.168.1.253asterisk0
- quit

now all the lists , carriers and users etc all got loaded on to the new server properly, later
i did update_server_ip and changed 192.168.1.253 ip to 192.168.1.153..

but when i try to access recordings it goes to my old server ip and fetches the recordings from there. as both the servers are still in same network i guess it is possible . so i disconnected my old server from the network and now my recordings are not beeing displayed eventhough i copied the recordings from old server to new server to exect location where they belong.

so i loggedin to new sever http://192.168.1.153/phpmyadmin/ with root.. went to asterisk database and found a table with recording_log, there the field name "location" show 'http://192.168.1.253/RECORDINGS/MP3/20140516-06555...'

so if i change the ip address http://192.168.1.253/RECORDINGS/MP3/20140516-06555... from 253 to 153 in that link it points to the correct path of the recordings which i copied on the new server. but how can i get all the recordings path change from old to new .. please help me ...

or is there any easy way to get the recording path point to the correct location once we do complete backup and restore to new machine.

regards
George


Replies (1)

RE: update recording link - Added by Demian Biscocho almost 9 years ago

You can do this by modifying the IP address entries via MySQL commands. Update the MySQL table that contains the recordings and change the IP address to the new one.

UPDATE recording_log SET server_ip="192.168.1.153" where server_ip="192.168.1.253";

Alternately, the easiest is to just do an IP aliasing to the old IP (192.168.1.253) so you don't need to do anything.

    (1-1/1)     Go to top