[Freeswitch-users] Moving Voicemails

[Joel White]

I got it working good.  The domain field as well as the file_path needed to
be modified in the voicemail_msgs table.

Thank you again :)

On Tue, Nov 18, 2014 at 5:13 PM, John <freeswitch at earthspike.net> wrote:

>  I've just remembered why there were 2 updates of file_path. I moved the
> voicemails from a box compiled from git into /usr/local/freeswitch to an
> Ubuntu box with debian-style file paths. And I put a typo in the first
> update, so had to do the IP-to-FQDN replace as a second transaction.
> Anyway, glad you got it work despite my slightly misleading guidance!
>
> John
>
>
> On 18/11/14 14:21, Joel White wrote:
>
>  The change went smoothly.  I really only used the update ***=replace
> function to change out the IP to Domain
>
>  Everything looks good
>
> On Tue, Nov 18, 2014 at 8:58 AM, Joel White <joelewhite at gmail.com> wrote:
>
>>   Thank you
>>
>>  Changing the domain worked.
>>
>>  Here is my file path as it has existed
>>
>> /usr/local/freeswitch/storage/voicemail/default/
>> 10.111.252.10/26343/msg_418e9e26-df74-11e3-b0cd-d9415cbdfb71.wav
>>
>>  I just need the IP changed to the domain
>>
>>  I will try the update of the file path today
>>
>>  On Mon, Nov 17, 2014 at 1:56 PM, Michael Jerris <mike at jerris.com> wrote:
>>
>>>  This does seem kind of clumsy... I'd be happy to accept a patch for
>>> mod_voicemail change domain that moves files and updates db correctly if
>>> anyone wants to give it a try.
>>>
>>>  On Nov 17, 2014, at 1:44 PM, John <freeswitch at earthspike.net> wrote:
>>>
>>> I've done this and for exactly the same reason. I moved the files to the
>>> domain-named path and updated the database using sqlite3. I found this in
>>> my command history, but you should test first on a copy of the db. It's for
>>> upgrading from 1.2.quite_old to 1.4.quite_recent.
>>>
>>> $ sqlite3 voicemail_default.db
>>> sqlite> update voicemail_msgs set file_path='/var/lib' ||
>>> substr(replace(file_path,'172.16.12.34','pbx.somewhere.net'),11);
>>> sqlite> update voicemail_msgs set
>>> file_path=replace(file_path,'172.16.12.34','pbx.somewhere.net');
>>> sqlite> update voicemail_prefs set greeting_path='/var/lib' ||
>>> substr(replace(greeting_path,'172.16.12.34','pbx.somewhere.net'),11);
>>>
>>> I cannot remember what the '11' was for; I've changed the IP address and
>>> FQDN so you might need to tune this value; check with SELECTs in place of
>>> the UPDATEs.
>>>
>>> John
>>>
>>> On 17/11/14 18:08, Ken Rice wrote:
>>>
>>> You got it sqlite3 is the way to go... I doubt doing what you are trying
>>> is heavily documented tho as its not something normally done.
>>>
>>> But all metadata for voicemail is in the sqlite db and that includes
>>> file paths etc
>>>
>>>
>>> On 11/17/14 10:07 AM, "Joel White" <joelewhite at gmail.com> wrote:
>>>
>>>  What is the easiest way to make this change?
>>>
>>> SQLite3 via command line?  Or is there another way to manipulate the
>>> database?
>>>
>>> On Mon, Nov 17, 2014 at 7:22 AM, Avi Marcus <avi at avimarcus.net> wrote:
>>>
>>> The path isn't dynamically generated based on the domain, it's stored
>>> per-file in the database.
>>> You can update the db or symlink the folders so they are available in
>>> the old structure too.
>>> -Avi
>>>
>>> On Mon, Nov 17, 2014 at 10:35 AM, Joel White <joelewhite at gmail.com>
>>> wrote:
>>>
>>> I initially configured my FreeSWITCH with an IP address, but now for
>>> scalability and high availability I am changing to a domain name.  I
>>> successfully changed the system over, but was wondering how do I move the
>>> voicemails to the new domain folder under voicemail?
>>>
>>> The obvious answer is to move the files, I already did that and
>>> restarted the system.  The existing voicemails and greetings are not
>>> visible to FreeSWITCH when I call voicemail.
>>>
>>> How do I transfer them over?
>>>
>>> Thank you in advance for any light you may shed on this predicament
>>>
>>>
>>>
>>>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org
>>> http://www.freeswitchsolutions.com
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://confluence.freeswitch.org
>>> http://www.cluecon.com
>>>
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at lists.freeswitch.org
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> http://www.freeswitch.org
>>>
>>
>>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services: consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>
> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141120/90871c66/attachment-0001.html