[Freeswitch-users] Moving Voicemails

[Joel White]

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
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141118/4a2595e5/attachment.html