<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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!<br>
<br>
John<br>
<br>
<div class="moz-cite-prefix">On 18/11/14 14:21, Joel White wrote:<br>
</div>
<blockquote
cite="mid:CAK0YwNkYjn01g6a9OOW8Lv+X3hcbo07ME7KxPwEoPBe0qJpExg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>The change went smoothly. I really only used the update
***=replace function to change out the IP to Domain<br>
<br>
</div>
Everything looks good<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Tue, Nov 18, 2014 at 8:58 AM, Joel
White <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:joelewhite@gmail.com" target="_blank">joelewhite@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>
<div>
<div>
<div>Thank you<br>
<br>
</div>
Changing the domain worked.<br>
<br>
</div>
Here is my file path as it has existed<br>
<br>
/usr/local/freeswitch/storage/voicemail/default/<a
moz-do-not-send="true"
href="http://10.111.252.10/26343/msg_418e9e26-df74-11e3-b0cd-d9415cbdfb71.wav"
target="_blank">10.111.252.10/26343/msg_418e9e26-df74-11e3-b0cd-d9415cbdfb71.wav</a><br>
<br>
</div>
I just need the IP changed to the domain<br>
<br>
</div>
I will try the update of the file path today<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">
<div>
<div class="h5">On Mon, Nov 17, 2014 at 1:56 PM,
Michael Jerris <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>></span>
wrote:<br>
</div>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<div class="h5">
<div style="word-wrap:break-word">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.<span>
<div><br>
<div>
<blockquote type="cite">
<div>On Nov 17, 2014, at 1:44 PM, John
<<a moz-do-not-send="true"
href="mailto:freeswitch@earthspike.net"
target="_blank">freeswitch@earthspike.net</a>>
wrote:</div>
<br>
<div><span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);float:none;display:inline!important">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.</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);float:none;display:inline!important">$
sqlite3 voicemail_default.db<span> </span></span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);float:none;display:inline!important">sqlite>
update voicemail_msgs set
file_path='/var/lib' ||
substr(replace(file_path,'172.16.12.34','</span><a
moz-do-not-send="true"
href="http://pbx.somewhere.net/"
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)"
target="_blank">pbx.somewhere.net</a><span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);float:none;display:inline!important">'),11);</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);float:none;display:inline!important">sqlite>
update voicemail_msgs set
file_path=replace(file_path,'172.16.12.34','</span><a
moz-do-not-send="true"
href="http://pbx.somewhere.net/"
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)"
target="_blank">pbx.somewhere.net</a><span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);float:none;display:inline!important">');</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);float:none;display:inline!important">sqlite>
update voicemail_prefs set
greeting_path='/var/lib' ||
substr(replace(greeting_path,'172.16.12.34','</span><a
moz-do-not-send="true"
href="http://pbx.somewhere.net/"
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)"
target="_blank">pbx.somewhere.net</a><span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);float:none;display:inline!important">'),11);</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);float:none;display:inline!important">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.</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);float:none;display:inline!important">John</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
<div
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">On
17/11/14 18:08, Ken Rice wrote:<br>
</div>
<blockquote type="cite"
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)"><font
face="Monaco, Courier New"><span
style="font-size:11pt">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.<br>
<br>
But all metadata for voicemail
is in the sqlite db and that
includes file paths etc<br>
<br>
<br>
On 11/17/14 10:07 AM, "Joel
White" <<a
moz-do-not-send="true">joelewhite@gmail.com</a>>
wrote:<br>
<br>
</span></font>
<blockquote><font face="Monaco,
Courier New"><span
style="font-size:11pt">What is
the easiest way to make this
change?<br>
<br>
SQLite3 via command line? Or
is there another way to
manipulate the database?<br>
<br>
On Mon, Nov 17, 2014 at 7:22
AM, Avi Marcus <<a
moz-do-not-send="true">avi@avimarcus.net</a>>
wrote:<br>
</span></font>
<blockquote><font face="Monaco,
Courier New"><span
style="font-size:11pt">The
path isn't dynamically
generated based on the
domain, it's stored per-file
in the database.<br>
You can update the db or
symlink the folders so they
are available in the old
structure too.<br>
<font color="#888888">-Avi<br>
<br>
</font>On Mon, Nov 17, 2014
at 10:35 AM, Joel White <<a
moz-do-not-send="true">joelewhite@gmail.com</a>>
wrote:<br>
</span></font>
<blockquote><font face="Monaco,
Courier New"><span
style="font-size:11pt">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?<br>
<br>
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.<br>
<br>
How do I transfer them
over? <span> </span><br>
<br>
Thank you in advance for
any light you may shed on
this predicament <span> </span><br>
</span></font></blockquote>
</blockquote>
</blockquote>
</blockquote>
</div>
</blockquote>
</div>
<br>
</div>
</span></div>
<br>
</div>
</div>
<span class="">_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org"
target="_blank">consulting@freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com"
target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://confluence.freeswitch.org"
target="_blank">http://confluence.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a moz-do-not-send="true"
href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</span></blockquote>
</div>
<br>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a></pre>
</blockquote>
<br>
</body>
</html>