FOP 2 shows Duplicate Users in Extension Panel

[rustybeans]

Hello. I am not sure why but my Extension Panel shows the users twice. I am using FreePBX 2.9.0.0. So far FOP2 seems to work very nicely. I just need to find a way to remove the duplicates. With that said, Usually 1 works and the other doesn't.
Any assistance would help.
Thanks

[nicolas]

the button configuration is created by the /usr/local/fop2/autoconfig-buttons-freepbx.sh script.

That script will read the freepbx database and create buttons based on those entries. Do you see duplicate buttons when running the above script in the command line? Perhaps you have some kind of configuration in your DB that is generating duplicate records with a slight difference?

[rustybeans]

It looks like there are 2 different configurations.... here is a pastebin link if you want to look at it http://pastebin.com/chscH3YD

Here is an example....

[SIP/2005]
type=extension
extension=2005
label=Serina Mendoza
mailbox=2005@default
context=from-internal
queuecontext=from-queue
extenvoicemail=*2005@default
privacy=none
customastdb=CF/2005

SIP/2005]
type=extension
extension=2005
label=Serina Mendoza
mailbox=2005@default
context=from-internal
queuecontext=from-queue
extenvoicemail=*2005@default
privacy=none
queuechannel=Local/2005@from-queue/n|Penalty=0|MemberName=Serina Mendoza|StateInterfac e=SIP/2005
customastdb=CF/2005

[nicolas]

Did you modify the autoconfig button script in any way? As it seems the script is running the mysql query TWICE? The 2nd one has some strange spacing issues (or perhaps it was a problem with the copy&paste for the long lines).

If you did not modify the scripts then you have some kind of strange data in your freepbx mysql tables. If using fop2admin, try uninstalling it. You will lose your fop2 permissions and custom config if you have any. Then run the autoconfig script again, inspect the output. Then install fop2admin again, apply changes, and run the autoconfig script once more.

[rustybeans]

Nothing changed. when I ran the script agian, it still showed me the same list of names. I have not modified anything that would cause this. I did what you said and I re ran the script /usr/local/fop2/autoconfig-buttons-freepbx.sh. what else can I do to resolve?

[nicolas]

The script does nothing, it will not fix nothing. It will show you the button list and configuration as taken from the mysql tables in freepbx, joined with the fop2 talbes if you installed fop2admin.

Did you install fop2admin for freepbx? If so, how many buttons do you see on the fop2 buttons page? Do you see them duplicated? This is not a fop2 problem itself, is an interaction with probably some dirty data in your mysql tables and freepbx. If you installed fop2admin, UNINSTALL it, as I recommended before. Then check again.

[rustybeans]

Hello. I did install fop2admin. I see the correct amount of buttons. They are not duplicated. I have uninstalled and I get the same problem. do I install fop2 completely? if the DB is dirty, wont the data remain in the tables?

[nicolas]

If you uninstall fop2admin, the autoconfiguration scripts will not use the fop2 tables but only the freepbx tables. After uninstalling fop2admin, is the output from the autoconfiguration script still duplicate? If so, the dirty data is in freepbx tables, so installing or uninstalling fop2 will not make any difference.