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)
Help?
- 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 2.9.0.12
Per instructions, tried (sperately):
ln -s /usr/lib64/libcrypto.so.1.0.0 /usr/lib64/libcrypto.so.6
ln -s /usr/lib64/libcrypto.so.10 /usr/lib64/libcrypto.so.6
/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 0.0.0.0:4445 0.0.0.0:* LISTEN 12760/fop2_server
netstat -lnp | grep 4444
tcp 0 0 0.0.0.0:4444 0.0.0.0:* LISTEN 12709/perl
uname -r
2.6.32-279.el6.x86_64
asterisk -rx "core show version"
Asterisk 1.8.17.0 built by root on a x86_64 running Linux on 2012-11-02 20:09:04 UTC
I've tried redownloading & reinstalling to no avail, and it did take my license (just purchased)
Help?
- 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 2.9.0.12
Per instructions, tried (sperately):
ln -s /usr/lib64/libcrypto.so.1.0.0 /usr/lib64/libcrypto.so.6
ln -s /usr/lib64/libcrypto.so.10 /usr/lib64/libcrypto.so.6
/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 0.0.0.0:4445 0.0.0.0:* LISTEN 12760/fop2_server
netstat -lnp | grep 4444
tcp 0 0 0.0.0.0:4444 0.0.0.0:* LISTEN 12709/perl
uname -r
2.6.32-279.el6.x86_64
asterisk -rx "core show version"
Asterisk 1.8.17.0 built by root on a x86_64 running Linux on 2012-11-02 20:09:04 UTC
Comments
/usr/local/fop2/autoconfig-users-freepbx.sh
/usr/local/fop2/autoconfig-buttons-freepbx.sh
It is a warning from mysql due to mixed collations (character encodings).
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 autoconfig-buttons-freepbx.sh 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).