Help w/ CentOS 6.3 x64, Asterisk 1.8.17, & FPBX 2.9

Logging into FOP2 gets me a blank page with only "Filter, Dial, & Presence" at the top...
I've tried redownloading & reinstalling to no avail, and it did take my license (just purchased)

- J

This is using:
fop2-2.26-centos5-x86_64.tgz & fop2admin-1.2.11.tgz
w/ Visual Phonebook (database looks clean as far as I can tell)
w/ FOP1 renumbered port to 4444 (works fine)
on CentOS 6.3 x64 w/ FPBX

Per instructions, tried (sperately):
ln -s /usr/lib64/ /usr/lib64/
ln -s /usr/lib64/ /usr/lib64/

/usr/local/fop2/fop2_server --test
Flash Operator Panel 2 - White Label Version.
Flash Operator Panel 2 - White Label License (3)
ERROR 1267 (HY000) at line 1: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
Connection to manager OK!

perl --version
This is perl, v5.10.1 (*) built for x86_64-linux-thread-multi

netstat -lnp | grep 4445
tcp 0 0* LISTEN 12760/fop2_server

netstat -lnp | grep 4444
tcp 0 0* LISTEN 12709/perl

uname -r

asterisk -rx "core show version"
Asterisk built by root on a x86_64 running Linux on 2012-11-02 20:09:04 UTC


  • Run the two autoconfig scripts and see which one is giving you an error:


    It is a warning from mysql due to mixed collations (character encodings).
  • Yeah, I opened a rather long support ticket w/ you @ asternic where you can see the steps I took to identify and solve the issue, for search purposes...

    asterisk.fop2buttons was in utf8_general_ci whereas everything else was in utf8_unicode_ci, causing an issue with the (rather long) sql statement in w/ comment "#si no tiene device and user, exclusimos los USER/"

    The fix was to update the database w/:

    alter table `asterisk`.`fop2buttons` convert to character set utf8 collate utf8_unicode_ci;

    ...and now the buttons.cfg is being generated correctly and users can now view fop2. I'm not sure why or how fop2buttons got to be put into utf8_general, but this has fixed me up... hopefully this will help you with other installs as well.

    Thanx Nicolas :),
    - J

    FYI: I've automated the install of FOP2, and have used the same identical process on a variety of systems (all CentOS 5 x86 though)... this was the first time I've ever had issues, figured it was yet another CentOS 6.3 x64 thing (as it was my first attempt on the new OS).
  • Thanks for the update and posting the fix!
Sign In or Register to comment.