[Freeswitch-users] Moving Voicemails
John
freeswitch at earthspike.net
Wed Nov 19 01:13:33 MSK 2014
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
> <mailto: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
> <http://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
> <mailto: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
>> <mailto: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
>> <http://pbx.somewhere.net/>'),11);
>> sqlite> update voicemail_msgs set
>> file_path=replace(file_path,'172.16.12.34','pbx.somewhere.net
>> <http://pbx.somewhere.net/>');
>> sqlite> update voicemail_prefs set greeting_path='/var/lib'
>> ||
>> substr(replace(greeting_path,'172.16.12.34','pbx.somewhere.net <http://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 <mailto: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
> <mailto: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.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/de15f93e/attachment-0001.html
Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users
mailing list