Periodic signals (School Bells) app

Status
Not open for further replies.

Samael28

Member
Apr 5, 2017
73
30
18
39
A small app designed actually for schools. When you have PBX connected to your announcement system, it would be logical if PBX can handle periodic signals as well. So, the name of the app is also obvious in this case - School Bells

Now it's a part of my FusionPBX fork and fusionpbx-apps repo as well.

The idea is quite simple - to manage signals from GUI in cron-like style. Not super friendly, but most of us know what cron is.


Limitation - it will allow you to choose only from Recordings, not like tone_stream or so.


Installation:


# cd /usr/src/
# git clone https://github.com/fusionpbx/fusionpbx-apps
# cd fusionpbx-apps/
# cp -R school_bells /var/www/fusionpbx/app/

Add

* * * * * php /var/www/fusionpbx/app/school_bells/school_bells_cron.php

to your crontab

Go to GUI

Upgrades -> Schema; App Defaults; Menu Defaults; Permission Defaults

Log out and back in

Apps -> School Bells

Enjoy!
 

ricofranco

New Member
Jun 8, 2018
10
0
1
45
Hello Friend,
First of all this APP great, but after I install this one we getting this error :

2020-08-22 15:28:02.051 -03 [20115] fusionpbx@fusionpbx ERROR: column reference "domain_uuid" is ambiguous at character 42
2020-08-22 15:28:02.051 -03 [20115] fusionpbx@fusionpbx STATEMENT: SELECT v_domains.domain_name AS context, domain_uuid AS domain_uuid, school_bell_leg_a_data AS extension, school_bell_leg_b_type AS full_path, school_bell_ring_timeout AS ring_timeout, school_bell_min as min, school_bell_hour as hour, school_bell_dom as dom, school_bell_mon as mon, school_bell_dow as dow, school_bell_timezone as timezone FROM v_school_bells JOIN v_domains ON v_domains.domain_uuid = v_school_bells.domain_uuid WHERE school_bell_min = $1 OR school_bell_min = -1

We got this error with two diferent version os Fusionpbx = 4.4.1 and 4.5.16 .

Can you help me with this incident ?
 

mydigitalself

Member
Oct 20, 2019
71
7
8
I'm seeing the same error on Postgres 9.4 and FusionPBX version 4.5.23

ERROR: column reference "domain_uuid" is ambiguous at character 42

Error shows when the event is triggered either by the schedule set on the school bell application or running it manually with the below
sudo /usr/bin/php /var/www/fusionpbx/app/school_bells/school_bells_cron.php

Any suggestions?
 

Samael28

Member
Apr 5, 2017
73
30
18
39
I'm a bit off from Fusion/Freeswitch world now, but app is opensource. You can modify and fix it by yourself
 

bdmonsey

Member
Jul 23, 2019
146
6
18
42
A small app designed actually for schools. When you have PBX connected to your announcement system, it would be logical if PBX can handle periodic signals as well. So, the name of the app is also obvious in this case - School Bells

Now it's a part of my FusionPBX fork and fusionpbx-apps repo as well.

The idea is quite simple - to manage signals from GUI in cron-like style. Not super friendly, but most of us know what cron is.


Limitation - it will allow you to choose only from Recordings, not like tone_stream or so.


Installation:


# cd /usr/src/
# git clone https://github.com/fusionpbx/fusionpbx-apps
# cd fusionpbx-apps/
# cp -R school_bells /var/www/fusionpbx/app/

Add

* * * * * php /var/www/fusionpbx/app/school_bells/school_bells_cron.php

to your crontab

Go to GUI

Upgrades -> Schema; App Defaults; Menu Defaults; Permission Defaults

Log out and back in

Apps -> School Bells

Enjoy!
Works Great! Love it. Thanks
 

bdmonsey

Member
Jul 23, 2019
146
6
18
42
Just tested it on my other server and this is what I got as an error , is this because of the version of Fusionpbx I am at, or something else? I'm on fusion 4.5.26 1626320758984.png
 

Samael28

Member
Apr 5, 2017
73
30
18
39
I was designing it for Fusion 4.4, never upgraded it to 4.5. But it should be rather easy.
 

bdmonsey

Member
Jul 23, 2019
146
6
18
42
i just realized the server i'm running it and it's working is also version 4.5.23
what am i doing wrong?
 

Xtc_Voip

New Member
Jul 28, 2021
15
0
1
59
Hello,

I like the app, but I am having an audio quality issue. How would I make the call quality better with this ? Playing audio at L16:8000 is not ideal and sounds a little garbled.

switch_core_state_machine.c:329 loopback/8000-a Standard EXECUTE
EXECUTE [depth=0] loopback/8000-a playback(/var/lib/freeswitch/recordings/XXXXXXXXXXX/schoolbell2_16000.wav)
2021-10-29 17:41:02.299809 [DEBUG] switch_core_file.c:405 File /var/lib/freeswitch/recordings/XXXXXXXXXXX/schoolbell2_16000.wav sample rate 16000 doesn't match requested rate 8000
2021-10-29 17:41:02.299809 [WARNING] switch_core_file.c:424 File has 2 channels, muxing to 1 channel will occur.
2021-10-29 17:41:02.299809 [DEBUG] switch_ivr_play_say.c:1486 Codec Activated L16@8000hz 1 channels 20ms
2021-10-29 17:41:02.319812 [DEBUG] switch_core_codec.c:223 loopback/8000-b Push codec L16:100

Not sure whats requesting the 8000hz, all the phones are set to G722 and the call should be at 16000hz on both legs.
 
Status
Not open for further replies.