Move voicemail recordings only to new server

Status
Not open for further replies.
J

jrosetto

Member
Apr 29, 2020
71
6
8
38
I found the recordings for voicemail in /var/lib/freeswitch/storage/voicemail/default/{domain}/{extension#} and copied them to a new server. Did chmod so www-data was owner.

When I call the extension I am still getting the canned response.

What am I missing here?

I am starting with a fresh FusionPBX install because I am changing providers and with my original provider I had to make a ton of modifications to deal with the NAT issues I was facing. I figured it would be easier to just just start with a default install and move only the recordings over but so far no go.

Help is greatly appreciated,

Thanks.
 
J

jrosetto

Member
Apr 29, 2020
71
6
8
38
Still struggling with this.

I have found that I can set the recordings that I copied to active in the voicemail menus but I have to do this per extension.
This leads me to believe that there is a variable set for the recording in the database.

Does anyone know the location in PSQL for the recordings?
 
Adrian Fretwell

Adrian Fretwell

Well-Known Member
Aug 13, 2017
1,498
413
83
The greeting messages are referenced in the v_voicemail_greetings table:
Code: 
select * from v_voicemail_greetings;

       voicemail_greeting_uuid        |             domain_uuid              | voicemail_id | greeting_id | greeting_name | greeting_filename | greeting_description | greeting_base64
--------------------------------------+--------------------------------------+--------------+-------------+---------------+-------------------+----------------------+-----------------
b3c41e05-3f7d-4421-9878-c63569c77506 | dbd96359-0814-4e23-8773-f45618b614a9 | 201          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
40ab47ac-970e-4d43-ab28-0df1c89608f8 | dbd96359-0814-4e23-8773-f45618b614a9 | 202          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
49958d60-23d4-49ae-8346-6bd050e81c5c | dbd96359-0814-4e23-8773-f45618b614a9 | 203          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
fbf66c24-2d8d-4017-bc73-77d492087993 | dbd96359-0814-4e23-8773-f45618b614a9 | 301          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
cd95b9dc-2637-4dc5-b323-bb51c5c769c7 | 9054f605-26f8-4df6-ad48-648700046be3 | 201          |           1 | Greeting 1    | greeting_1.wav    |                      |
64021ee7-575a-41ff-b2b1-4aaa023ca246 | e930a2d6-e55e-4102-843e-3f2a468d0958 | 202          |           1 | Greeting 1    | greeting_1.wav    |                      |
c05df3af-1cfc-48dd-a332-d18f4507d27a | dbd96359-0814-4e23-8773-f45618b614a9 | 301          |           2 | Greeting 2    | greeting_2.wav    | greeting_2.wav       |
6619dd98-8780-4e7a-bdd2-afcc0b6ec82d | 135eafb6-b4b7-4454-a0af-1dfb4f22016f | 201          |           1 | Greeting 1    | greeting_1.wav    |                      |


There are five tables in the schema, associated with voicemail:
Code: 
public | v_voicemail_destinations        | table | fusionpbx
public | v_voicemail_greetings           | table | fusionpbx
public | v_voicemail_messages            | table | fusionpbx
public | v_voicemail_options             | table | fusionpbx
public | v_voicemails                    | table | fusionpbx
 
  • Like
Reactions: jrosetto
J

jrosetto

Member
Apr 29, 2020
71
6
8
38
Adrian Fretwell said:
The greeting messages are referenced in the v_voicemail_greetings table:
Code: 
select * from v_voicemail_greetings;

       voicemail_greeting_uuid        |             domain_uuid              | voicemail_id | greeting_id | greeting_name | greeting_filename | greeting_description | greeting_base64
--------------------------------------+--------------------------------------+--------------+-------------+---------------+-------------------+----------------------+-----------------
b3c41e05-3f7d-4421-9878-c63569c77506 | dbd96359-0814-4e23-8773-f45618b614a9 | 201          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
40ab47ac-970e-4d43-ab28-0df1c89608f8 | dbd96359-0814-4e23-8773-f45618b614a9 | 202          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
49958d60-23d4-49ae-8346-6bd050e81c5c | dbd96359-0814-4e23-8773-f45618b614a9 | 203          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
fbf66c24-2d8d-4017-bc73-77d492087993 | dbd96359-0814-4e23-8773-f45618b614a9 | 301          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
cd95b9dc-2637-4dc5-b323-bb51c5c769c7 | 9054f605-26f8-4df6-ad48-648700046be3 | 201          |           1 | Greeting 1    | greeting_1.wav    |                      |
64021ee7-575a-41ff-b2b1-4aaa023ca246 | e930a2d6-e55e-4102-843e-3f2a468d0958 | 202          |           1 | Greeting 1    | greeting_1.wav    |                      |
c05df3af-1cfc-48dd-a332-d18f4507d27a | dbd96359-0814-4e23-8773-f45618b614a9 | 301          |           2 | Greeting 2    | greeting_2.wav    | greeting_2.wav       |
6619dd98-8780-4e7a-bdd2-afcc0b6ec82d | 135eafb6-b4b7-4454-a0af-1dfb4f22016f | 201          |           1 | Greeting 1    | greeting_1.wav    |                      |


There are five tables in the schema, associated with voicemail:
Code: 
public | v_voicemail_destinations        | table | fusionpbx
public | v_voicemail_greetings           | table | fusionpbx
public | v_voicemail_messages            | table | fusionpbx
public | v_voicemail_options             | table | fusionpbx
public | v_voicemails                    | table | fusionpbx
Click to expand...

That was what I was missing. I really appreciate your time.

Thanks.
 
J

jrosetto

Member
Apr 29, 2020
71
6
8
38
Adrian Fretwell said:
The greeting messages are referenced in the v_voicemail_greetings table:
Code: 
select * from v_voicemail_greetings;

       voicemail_greeting_uuid        |             domain_uuid              | voicemail_id | greeting_id | greeting_name | greeting_filename | greeting_description | greeting_base64
--------------------------------------+--------------------------------------+--------------+-------------+---------------+-------------------+----------------------+-----------------
b3c41e05-3f7d-4421-9878-c63569c77506 | dbd96359-0814-4e23-8773-f45618b614a9 | 201          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
40ab47ac-970e-4d43-ab28-0df1c89608f8 | dbd96359-0814-4e23-8773-f45618b614a9 | 202          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
49958d60-23d4-49ae-8346-6bd050e81c5c | dbd96359-0814-4e23-8773-f45618b614a9 | 203          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
fbf66c24-2d8d-4017-bc73-77d492087993 | dbd96359-0814-4e23-8773-f45618b614a9 | 301          |           1 | Greeting 1    | greeting_1.wav    | greeting_1.wav       |
cd95b9dc-2637-4dc5-b323-bb51c5c769c7 | 9054f605-26f8-4df6-ad48-648700046be3 | 201          |           1 | Greeting 1    | greeting_1.wav    |                      |
64021ee7-575a-41ff-b2b1-4aaa023ca246 | e930a2d6-e55e-4102-843e-3f2a468d0958 | 202          |           1 | Greeting 1    | greeting_1.wav    |                      |
c05df3af-1cfc-48dd-a332-d18f4507d27a | dbd96359-0814-4e23-8773-f45618b614a9 | 301          |           2 | Greeting 2    | greeting_2.wav    | greeting_2.wav       |
6619dd98-8780-4e7a-bdd2-afcc0b6ec82d | 135eafb6-b4b7-4454-a0af-1dfb4f22016f | 201          |           1 | Greeting 1    | greeting_1.wav    |                      |


There are five tables in the schema, associated with voicemail:
Code: 
public | v_voicemail_destinations        | table | fusionpbx
public | v_voicemail_greetings           | table | fusionpbx
public | v_voicemail_messages            | table | fusionpbx
public | v_voicemail_options             | table | fusionpbx
public | v_voicemails                    | table | fusionpbx
Click to expand...

One more quiestion. How does voicemail_greeting_uuid correlate with the system? Is it randomly generated?

Basically I'm thinking copy files over/chown dir
export v_voicemail_greetings/change domain_uuid to match new server/import

In theory this should move my voicemail greetings to the new system and set the active one correct?
 
Adrian Fretwell

Adrian Fretwell

Well-Known Member
Aug 13, 2017
1,498
413
83
Yes, the voicemail_greeting_uuid is just a unique primary key, so your existing records should import without duplicating the PK.

Your strategy sounds fine to me.
 
  • Like
Reactions: jrosetto
Status
Not open for further replies.
Top Bottom