Hi,

It finally works!

Why is it not working with the base script? Is it a version problem (mysql) ?

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: [email protected]
    queuechannel: 
originatechannel: 
*************************** 2. row ***************************
         channel: USER/200
            type: extension
       extension: 200
           label: Charles
         mailbox: 
         context: from-internal
    queuecontext: 
  extenvoicemail: *
         privacy: none
           group: 
           email: [email protected]
    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: [email protected]
    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?

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            [email protected]
USER/200        extension       200     Charles         from-internal           *       none            [email protected]
USER/900        extension       900     Fop2    900@default     from-internal           *900@default    none            [email protected]
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                            *

./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~ none

Apparently, it only removes the CRs from the request.

Any other ideas?

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 LINEA

If 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~
none

Now, 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

Hi,

I was trying to install FOP2, and everything went fine, from the logs, everything should be working as intended. However, when I log into FOP2, I do not see anything. No extensions, no trunks. I see the filter bar, but no other button (except the phonebook).

I am using FreePBX 2.7, all the tables (fop2) are there in the database, all the auto-scripts seem to work (the tables are populated), but no matter what I do, nothing is showing up. I have spent a great deal of time trying to figure it out, but I am at a loss now. I have installed the FreePBX module as well and configured some users, but no matter what I do, nothing shows up.

I have created users that match users of my Asterisk installation, with the same password as the voicemail password I set up on Asterisk.

I would really appreciate any help. I have tried pretty much everything I could think of before posting this.

Thanks!