В общем проблема следующая:
Новая установка астериска на
Ubuntu 12.04
Asterisk 1.8.24
mysql Ver 14.14 Distrib 5.5.31
FreePBX 2.11.0
Установка производилась по инструкции с вики http://help.ubuntu.ru/wiki/asterisk
после установки freepbx дошел до ошибки и на этом все встало (
когда вносишь изменения в в freepbx и нажимаешь "apply config" то получаешь следующее
Код: Выделить всё
Reload failed because retrieve_conf encountered an error: 1
exit: 1
found language dir fr for directory, not installed on system, skipping
[FATAL] SELECT a.extension, a.cidnum, b.description, a.destination FROM fax_incoming a JOIN incoming b WHERE a.extension = b.extension AND a.cidnum = b.cidnum AND a.legacy_email IS NULL ORDER BY extension, cidnum [nativecode=1267 ** Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=']SQL -
SELECT a.extension, a.cidnum, b.description, a.destination FROM fax_incoming a JOIN incoming b WHERE a.extension = b.extension AND a.cidnum = b.cidnum AND a.legacy_email IS NULL ORDER BY extension, cidnum
Trace Back:
/var/www/freepbx/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: SELECT a.extension, a.cidnum, b.description, a.destination FROM fax_incoming a JOIN incoming b WHERE a.extension = b.extension AND a.cidnum = b.cidnum AND a.legacy_email IS NULL ORDER BY extension, cidnum [nativecode=1267 ** Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=']SQL -
SELECT a.extension, a.cidnum, b.description, a.destination FROM fax_incoming a JOIN incoming b WHERE a.extension = b.extension AND a.cidnum = b.cidnum AND a.legacy_email IS NULL ORDER BY extension, cidnum
/var/www/freepbx/admin/modules/fax/functions.inc.php:41 sql()
[0]: SELECT a.extension, a.cidnum, b.description, a.destination FROM fax_incoming a JOIN incoming b WHERE a.extension = b.extension AND a.cidnum = b.cidnum AND a.legacy_email IS NULL ORDER BY extension, cidnum
[1]: getAll
[2]: 2
/var/www/freepbx/admin/libraries/usage_registry.functions.php:145 fax_check_destinations()
[0]: 1
/var/www/freepbx/admin/libraries/usage_registry.functions.php:338 framework_check_destination_usage()
[0]: 1
[1]:
/var/lib/asterisk/bin/retrieve_conf:612 framework_list_problem_destinations()
[0]:
[1]:
1 error(s) occurred, you should view the notification log on the dashboard or main screen to check for more details.
