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@gmail.com <mailto:joelewhite@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@jerris.com <mailto:mike@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@earthspike.net <mailto:freeswitch@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@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@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@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@freeswitch.org <mailto:consulting@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@lists.freeswitch.org <mailto:FreeSWITCH-users@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org