FOP2 completely empty
-
Please run the following script in the linux command line:
/usr/local/fop2/autoconfig-buttons-freepbx.sh
And look at the output, it should look like valid fop2 button configuration data. If that script fails and it does not produce output, then that is the problem you have and that needs fixing.
-
Hey there,
I have found a "problem" with the script (and this is a fresh install of the OS). Since my first post, I have reinstalled the entire OS and I am still getting the same problem.
Apparently, some rows contain a * in the SQL request, causing the while loop to fail:
mysql -ENB -u $DBUSER -p$DBPASS -h $DBHOST $DBNAME -e \ "SELECT if(type='extension',CONCAT('USER/',exten),device) AS channel,type,if(type<>'trunk',exten,' ') AS extension,\ label,mailbox,context,'$QUEUECONTEXT' as queuecontext,concat('*',mailbox) AS extenvoicemail, \ privacy,\`group\`,IF(type='trunk',IF(email<>'',concat('splitme-',email),''),email) as email, \ queuechannel,originatechannel FROM fop2buttons WHERE device<>'' ORDER BY type,exten" | \ sed '/\*\*/d' | sed 's/: /=/g' | sed '/.*=$/d' | while read LINEAIf the line is a *, then it will parse the files in the directoy, like so:
SIP/100 extension 100 Main Line from-internal from-queue autobuttons.cfg autobuttons.cfg.~1~ autobuttons.cfg.~2~ autobuttons.cfg.~3~ autoconfig-buttons-freepbx.sh autoconfig-buttons-freepbx.sh.~1~ autoconfig-buttons-freepbx.sh.~2~ autoconfig-buttons-freepbx.sh.~3~ autoconfig-users-freepbx.sh autoconfig-users-freepbx.sh.~1~ autoconfig-users-freepbx.sh.~2~ autoconfig-users-freepbx.sh.~3~ buttons.cfg.sample buttons.cfg.sample.~1~ buttons.cfg.sample.~2~ buttons.cfg.sample.~3~ extensions_override_freepbx.conf extensions_override_freepbx.conf~ FOP2Callbacks.pm FOP2Callbacks.pm.sample FOP2Callbacks.pm.sample.~1~ FOP2Callbacks.pm.sample.~2~ fop2.cfg fop2.cfg.new fop2_server op_lang_de.cfg op_lang_de.cfg~ op_lang_en.cfg op_lang_en.cfg~ op_lang_es.cfg op_lang_es.cfg~ op_lang_fr_FR.cfg op_lang_fr_FR.cfg~ op_lang_it.cfg op_lang_it.cfg~ op_lang_pt_BR.cfg op_lang_pt_BR.cfg~ op_lang_zh.cfg op_lang_zh.cfg~ noneNow, I added a sed 's/*/ /' before the while, but the buttons are still not showing up in the interface. I don't know exactly what it's supposed to look like (the final output) so it's hard to figure out what's wrong with the output I get. Could you enlighten me?
This is the actual output from the SQL request, without the sed:
SIP/100 extension 100 Main Line from-internal from-queue * none -
-
./autoconfig-buttons-freepbx.sh SIP/100 extension 100 Main Line from-internal from-queue autobuttons.cfg autobuttons.cfg.~1~ autobuttons.cfg.~2~ autobuttons.cfg.~3~ autoconfig-buttons-freepbx.sh autoconfig-buttons-freepbx.sh.~1~ autoconfig-buttons-freepbx.sh.~2~ autoconfig-buttons-freepbx.sh.~3~ autoconfig-users-freepbx.sh autoconfig-users-freepbx.sh.~1~ autoconfig-users-freepbx.sh.~2~ autoconfig-users-freepbx.sh.~3~ buttons.cfg.sample buttons.cfg.sample.~1~ buttons.cfg.sample.~2~ buttons.cfg.sample.~3~ extensions_override_freepbx.conf extensions_override_freepbx.conf~ FOP2Callbacks.pm FOP2Callbacks.pm.sample FOP2Callbacks.pm.sample.~1~ FOP2Callbacks.pm.sample.~2~ fop2.cfg fop2.cfg.new fop2_server op_lang_de.cfg op_lang_de.cfg~ op_lang_en.cfg op_lang_en.cfg~ op_lang_es.cfg op_lang_es.cfg~ op_lang_fr_FR.cfg op_lang_fr_FR.cfg~ op_lang_it.cfg op_lang_it.cfg~ op_lang_pt_BR.cfg op_lang_pt_BR.cfg~ op_lang_zh.cfg op_lang_zh.cfg~ noneApparently, it only removes the CRs from the request.
Any other ideas?
-
Just as an FYI, this is what the table looks like with your query
mysql -NB -u $DBUSER -p$DBPASS -h $DBHOST $DBNAME -e "SELECT if(type='extension',CONCAT('USER/',exten),device) AS channel,type,if(type<>'trunk',exten,' ') AS extension,label,mailbox,context,'$QUEUECONTEXT' as queuecontext,CONCAT('*',mailbox) AS extenvoicemail, privacy,\`group\`,IF(type='trunk',IF(email<>'',CONCAT('splitme-',email),''),email) as email, queuechannel,originatechannel FROM fop2buttons WHERE device<>'' ORDER BY type,exten"The table:
USER/100 extension 100 Main Line from-internal * none wickedsun@gmail.com USER/200 extension 200 Charles from-internal * none wickedsun@gmail.com USER/900 extension 900 Fop2 900@default from-internal *900@default none wickedsun@gmail.com PARK/default park parkedcalls * SIP/voicenetwork-canada trunk SIP/voicenetwork-canada * SIP/callcentric trunk SIP/callcentric * SIP/voipms trunk SIP/voipms * SIP/voicenetwork-usa trunk SIP/voicenetwork-usa * -
Try using only -E . The output should look like this (vertical display):
*************************** 36. row ***************************
channel: SIP/gsm
type: trunk
extension:
label: SIP/gsm
mailbox:
context:
queuecontext:
extenvoicemail: *
privacy:
group:
email:
queuechannel:
originatechannel: -
There you go:
*************************** 1. row *************************** channel: USER/100 type: extension extension: 100 label: Main Line mailbox: context: from-internal queuecontext: extenvoicemail: * privacy: none group: email: wickedsun@gmail.com queuechannel: originatechannel: *************************** 2. row *************************** channel: USER/200 type: extension extension: 200 label: Charles mailbox: context: from-internal queuecontext: extenvoicemail: * privacy: none group: email: wickedsun@gmail.com queuechannel: originatechannel: *************************** 3. row *************************** channel: USER/900 type: extension extension: 900 label: Fop2 mailbox: 900@default context: from-internal queuecontext: extenvoicemail: *900@default privacy: none group: email: wickedsun@gmail.com queuechannel: originatechannel: *************************** 4. row *************************** channel: PARK/default type: park extension: label: mailbox: context: parkedcalls queuecontext: extenvoicemail: * privacy: group: email: queuechannel: originatechannel: *************************** 5. row *************************** channel: SIP/voicenetwork-canada type: trunk extension: label: SIP/voicenetwork-canada mailbox: context: queuecontext: extenvoicemail: * privacy: group: email: queuechannel: originatechannel: *************************** 6. row *************************** channel: SIP/callcentric type: trunk extension: label: SIP/callcentric mailbox: context: queuecontext: extenvoicemail: * privacy: group: email: queuechannel: originatechannel: *************************** 7. row *************************** channel: SIP/voipms type: trunk extension: label: SIP/voipms mailbox: context: queuecontext: extenvoicemail: * privacy: group: email: queuechannel: originatechannel: *************************** 8. row *************************** channel: SIP/voicenetwork-usa type: trunk extension: label: SIP/voicenetwork-usa mailbox: context: queuecontext: extenvoicemail: * privacy: group: email: queuechannel: originatechannel:Does anything look out of place?
-
-
-
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login