Пожалуйста, войдите здесь. Часто задаваемые вопросы О нас
Задайте Ваш вопрос

История изменений [назад]

нажмите, чтобы скрыть/показать версии 1
изначальная версия
редактировать

спросил 2015-01-28 12:58:25 +0400

trooper23 Gravatar trooper23

Asterisk+voiceone

Значится так: Поставил 11.7.0 и скачал надстройку для него:voiceone. Еле как нашёл для всего этого дела инструкцию(я про voiceone). Примерный порядок действий мой таков: apt-get install apache2 apache2-doc sox madplay php5-cgi php-pear php5 php5-cli php5-common php5-dev libapache2-mod-php5 php5-mhash php5-mysql php5-odbc mysql-server mysql-client sudo build-essential linux-headers-uname -r g++ subversion libmysqlclient-dev libxml2-dev libncurses5-dev libsqlite3-dev libssl-dev libsrtp0-dev unixodbc-dev mysql-server mysql-client php5-mysql echo "Введите пароль рута от мускула" mysqladmin -u root create voiceone mkdir -p /usr/src/asterisk-src cd /usr/src/asterisk-src wget http://downloads.asterisk.org/pub/telephony/asterisk/releases/asterisk-11.7.0.tar.gz wget http://downloads.asterisk.org/pub/telephony/dahdi-linux-complete/dahdi-linux-complete-2.6.1+2.6.1.tar.gz wget http://downloads.asterisk.org/pub/telephony/libpri/libpri-1.4.14.tar.gz tar xvf dahdi-linux-complete-2.6.tar.gz tar xvf libpri-1.4.tar.gz tar xvf asterisk-11.tar.gz cd dahdi-linux-complete-2.6 make all && make install && make config cd ../libpri-1.4.14* make && make install rm -rf /var/lib/asterisk cd ../asterisk-1* ./configure make menuselect make && make install make samples make config adduser asterisk --disabled-password --no-create-home --gecos "asterisk PBX user" mkdir /home/src/voiceone cd /home/src/voiceone wget http://sourceforge.net/projects/voiceone/files/VoiceOne%20Sources/1.8/voiceone-1.8.425.tar.gz tar xvfz voiceone-1.8.425.tar.gz mv ./voiceone/admin/config/config.inc.php.default ./voiceone/admin/config/config.inc.php mv ./voiceonewebservices/config/config.inc.php.default ./voiceonewebservices/config/config.inc.php

chown www-data:www-data voiceone -R chown www-data:www-data voiceonewebservices -R chmod 777 voiceone/admin/config/config.inc.php chmod 777 voiceone/sandbox -R chmod 777 voiceone/admin/public/template/cache -R chmod 755 voiceonewebservices/script/vo-tools.sh chmod 777 voiceone_webservices/utility/provisioning/firmware/data ln -s /usr/share/asterisk /var/lib/asterisk

ln -s /usr/share/asterisk/moh /usr/share/asterisk/mohmp3 mkdir /usr/share/asterisk/moh/voiceone mkdir /usr/share/asterisk/moh/voiceone/default

echo -n "/etc/sudoers " echo www-data ALL=NOPASSWD:/var/www/voiceone_webservices/script/vo-tools.sh >> /etc/sudoers echo " [OK]"

echo -n "/etc/asterisk/modules.conf " echo "preload => resconfigmysql.so" >> /etc/asterisk/modules.conf echo " [OK]"

echo -n "/etc/asterisk/extconfig.conf " cat > /etc/asterisk/extconfig.conf << EOF [settings] agents.conf => mysql,general,astconfig extensions.conf => mysql,general,astconfig features.conf => mysql,general,astconfig iax.conf => mysql,general,astconfig meetme.conf => mysql,general,astconfig musiconhold.conf => mysql,general,astconfig queues.conf => mysql,general,astconfig sip.conf => mysql,general,astconfig iaxusers => mysql,general,iaxbuddies iaxpeers => mysql,general,iaxbuddies sipusers => mysql,general,sipbuddies sippeers => mysql,general,sipbuddies voicemail => mysql,general,voicemailusers extensions => mysql,general,extensionstable gtalk.conf => mysql,general,astconfig jabber.conf => mysql,general,astconfig EOF echo " [OK]" echo -n "/etc/asterisk/resconfigmysql.conf " cat > /etc/asterisk/resconfigmysql.conf << EOF [general] dbhost = 127.0.0.1 dbname = voiceone dbuser = voiceone dbpass = voiceone dbport = 3306 dbsock = /var/lib/mysql/mysql.sock requirements = warn EOF echo " [OK]" echo -n "/etc/asterisk/cdrmysql.conf " cat > /etc/asterisk/cdrmysql.conf << EOF [global] hostname=127.0.0.1 dbname=voiceone table=cdr user=voiceone password=voiceone port=3306 sock=/var/lib/mysql/mysql.sock userfield=1 EOF echo " [OK]" echo -n "/etc/asterisk/manager.conf " cat > /etc/asterisk/manager.conf << EOF [general] enabled=yes

[voiceone] secret=voiceone deny=0.0.0.0/0.0.0.0 permit=127.0.0.1/255.255.255.0 read=system,call,log,verbose,command,agent,user write=system,call,log,verbose,command,agent,user EOF echo " [OK]" /etc/init.d/apache2 restart echo -n "[Install good]" echo "mysql -u root GRANT ALL PRIVILEGES ON voiceone.* TO 'voiceone'@'localhost' IDENTIFIED BY 'voiceone' WITH GRANT OPTION;

Так вот. Как только я перехожу к настройке voiceone через браузер я дохожу вот до этой штуки: [img] http://rghost.ru/8VWzFYmJJ и получаю вот такую портянку [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> core: IMPORTED , referer: http://192.168.7.97/voiceone/setup.php?step=3 ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='This table contains the list of the possible trunk country ' at line 12 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> locations: IMPORTED , referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> queue: IMPORTED , referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> backup: NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> contacts: IMPORTED , referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> aststat: IMPORTED , referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> moh: NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> astmanager: NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> sounds: IMPORTED , referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> gtalk: IMPORTED , referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> voicemail: NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> meetme: IMPORTED , referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> recording: NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> setup: NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> rule: IMPORTED , referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] -> cdr: NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] Write extensions config files in astconfig..., referer: http://192.168.7.97/voiceone/setup.php?step=3 [Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] PHP Fatal error: mysql error: [1146: Table 'voiceone.astconfig' doesn't exist] in EXECUTE("DELETE FROM astconfig WHERE filename='extensions.conf' AND category like '%' AND zsection='' ")\n in /var/www/voiceonewebservices/lib/adodb/adodb-errorhandler.inc.php on line 77, referer: http://192.168.7.97/voiceone/setup.php?step=3 В душе то я понимаю, что кмне говорится, но вот как это вылечить я не имею ни малейшего понятия. Кто нибудь сталкивался? К слову: Linux asterisk11 3.2.0-4-amd64 #1 SMP Debian 3.2.65-1+deb7u1 x8664 GNU/Linux Voiceone 1.8.425

нажмите, чтобы скрыть/показать версии 2
No.2 Revision
редактировать

обновил 2015-01-28 13:54:33 +0400

zzuz Gravatar zzuz flag of Russian Federation

http://line24.ru/

Asterisk+voiceone

Значится так: Поставил 11.7.0 и скачал надстройку для него:voiceone. Еле как нашёл для всего этого дела инструкцию(я про voiceone). Примерный порядок действий мой таков: таков:

apt-get install apache2 apache2-doc sox madplay php5-cgi php-pear php5 php5-cli php5-common php5-dev libapache2-mod-php5 php5-mhash php5-mysql php5-odbc mysql-server mysql-client sudo build-essential linux-headers-uname -r linux-headers-`uname -r` g++  subversion libmysqlclient-dev libxml2-dev libncurses5-dev libsqlite3-dev libssl-dev libsrtp0-dev unixodbc-dev mysql-server mysql-client php5-mysql
 echo "Введите пароль рута от мускула"
mysqladmin -u root  create voiceone
mkdir -p /usr/src/asterisk-src
cd /usr/src/asterisk-src
wget http://downloads.asterisk.org/pub/telephony/asterisk/releases/asterisk-11.7.0.tar.gz http://downloads.asterisk.org/pub/telephony/asterisk/releases/asterisk-11.7.0.tar.gz
wget http://downloads.asterisk.org/pub/telephony/dahdi-linux-complete/dahdi-linux-complete-2.6.1+2.6.1.tar.gz http://downloads.asterisk.org/pub/telephony/dahdi-linux-complete/dahdi-linux-complete-2.6.1+2.6.1.tar.gz
wget http://downloads.asterisk.org/pub/telephony/libpri/libpri-1.4.14.tar.gz http://downloads.asterisk.org/pub/telephony/libpri/libpri-1.4.14.tar.gz
tar xvf dahdi-linux-complete-2.6.tar.gz
dahdi-linux-complete-2.6*.tar.gz
tar xvf libpri-1.4.tar.gz
libpri-1.4*.tar.gz
tar xvf asterisk-11.tar.gz
asterisk-11*.tar.gz
cd dahdi-linux-complete-2.6 dahdi-linux-complete-2.6*
make all && make install && make config
cd ../libpri-1.4.14*
make && make install
rm -rf /var/lib/asterisk
cd ../asterisk-1*
./configure
make menuselect
make && make install
make samples
make config
adduser asterisk --disabled-password --no-create-home --gecos "asterisk PBX user"
mkdir /home/src/voiceone
cd /home/src/voiceone
wget http://sourceforge.net/projects/voiceone/files/VoiceOne%20Sources/1.8/voiceone-1.8.425.tar.gz http://sourceforge.net/projects/voiceone/files/VoiceOne%20Sources/1.8/voiceone-1.8.425.tar.gz
tar xvfz voiceone-1.8.425.tar.gz
mv ./voiceone/admin/config/config.inc.php.default ./voiceone/admin/config/config.inc.php
mv ./voiceonewebservices/config/config.inc.php.default ./voiceonewebservices/config/config.inc.php
 
./voiceone_webservices/config/config.inc.php.default ./voiceone_webservices/config/config.inc.php

chown www-data:www-data voiceone -R
chown www-data:www-data voiceonewebservices voiceone_webservices -R
chmod 777 voiceone/admin/config/config.inc.php
chmod 777 voiceone/sandbox -R
chmod 777 voiceone/admin/public/template/cache -R
chmod 755 voiceonewebservices/script/vo-tools.sh
voiceone_webservices/script/vo-tools.sh
chmod 777 voiceone_webservices/utility/provisioning/firmware/data
ln -s /usr/share/asterisk /var/lib/asterisk
 
/var/lib/asterisk

ln -s /usr/share/asterisk/moh /usr/share/asterisk/mohmp3
mkdir /usr/share/asterisk/moh/voiceone
mkdir /usr/share/asterisk/moh/voiceone/default
 
/usr/share/asterisk/moh/voiceone/default

echo -n "/etc/sudoers "
echo www-data ALL=NOPASSWD:/var/www/voiceone_webservices/script/vo-tools.sh >> /etc/sudoers
echo "  [OK]"
 
[OK]"

echo -n "/etc/asterisk/modules.conf "
echo "preload => resconfigmysql.so" res_config_mysql.so" >> /etc/asterisk/modules.conf
echo "  [OK]"
 
[OK]"

echo -n "/etc/asterisk/extconfig.conf "
cat > /etc/asterisk/extconfig.conf << EOF
[settings]
agents.conf => mysql,general,astconfig
mysql,general,ast_config
extensions.conf => mysql,general,astconfig
mysql,general,ast_config
features.conf => mysql,general,astconfig
mysql,general,ast_config
iax.conf => mysql,general,astconfig
mysql,general,ast_config
meetme.conf => mysql,general,astconfig
mysql,general,ast_config
musiconhold.conf => mysql,general,astconfig
mysql,general,ast_config
queues.conf => mysql,general,astconfig
mysql,general,ast_config
sip.conf => mysql,general,astconfig
mysql,general,ast_config
iaxusers => mysql,general,iaxbuddies
mysql,general,iax_buddies
iaxpeers => mysql,general,iaxbuddies
mysql,general,iax_buddies
sipusers => mysql,general,sipbuddies
mysql,general,sip_buddies
sippeers => mysql,general,sipbuddies
mysql,general,sip_buddies
voicemail => mysql,general,voicemailusers
mysql,general,voicemail_users
extensions => mysql,general,extensionstable
mysql,general,extensions_table
gtalk.conf => mysql,general,astconfig
mysql,general,ast_config
jabber.conf => mysql,general,astconfig
mysql,general,ast_config
EOF
echo "  [OK]"
echo -n "/etc/asterisk/resconfigmysql.conf "/etc/asterisk/res_config_mysql.conf "
cat > /etc/asterisk/resconfigmysql.conf /etc/asterisk/res_config_mysql.conf << EOF
[general]
dbhost = 127.0.0.1
dbname = voiceone
dbuser = voiceone
dbpass = voiceone
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
requirements = warn
EOF
echo "  [OK]"
echo -n "/etc/asterisk/cdrmysql.conf "/etc/asterisk/cdr_mysql.conf "
cat > /etc/asterisk/cdrmysql.conf /etc/asterisk/cdr_mysql.conf << EOF
[global]
hostname=127.0.0.1
dbname=voiceone
table=cdr
user=voiceone
password=voiceone
port=3306
sock=/var/lib/mysql/mysql.sock
userfield=1
EOF
echo "  [OK]"
echo -n "/etc/asterisk/manager.conf "
cat > /etc/asterisk/manager.conf << EOF
[general]
enabled=yes
 
enabled=yes

[voiceone]
secret=voiceone
deny=0.0.0.0/0.0.0.0
permit=127.0.0.1/255.255.255.0
read=system,call,log,verbose,command,agent,user
write=system,call,log,verbose,command,agent,user
EOF
echo "  [OK]"
 /etc/init.d/apache2 restart
echo -n "[Install good]"
echo "mysql -u root  GRANT ALL PRIVILEGES ON voiceone.* TO 'voiceone'@'localhost' IDENTIFIED BY 'voiceone' WITH GRANT OPTION;
OPTION;

Так вот. Как только я перехожу к настройке voiceone через браузер я дохожу вот до этой штуки: [img] http://rghost.ru/8VWzFYmJJ штуки:

image description

и получаю вот такую портянку портянку

[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> core:                             IMPORTED  , referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='This table contains the list of the possible trunk country ' at line 12
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> locations:                        IMPORTED  , referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> queue:                            IMPORTED  , referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> backup:                         NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> contacts:                         IMPORTED  , referer: http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> aststat: http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> ast_stat:                         IMPORTED  , referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> moh:                            NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> astmanager: http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> ast_manager:                    NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> sounds:                           IMPORTED  , referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> gtalk:                            IMPORTED  , referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> voicemail:                      NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> meetme:                           IMPORTED  , referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> recording:                      NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> setup:                          NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> rule:                             IMPORTED  , referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103]   -> cdr:                            NOT IMPORTED, referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] Write extensions config files in astconfig..., referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3
[Wed Jan 28 03:53:54 2015] [error] [client 192.168.7.103] PHP Fatal error:  mysql error: [1146: Table 'voiceone.astconfig' 'voiceone.ast_config' doesn't exist] in EXECUTE("DELETE FROM astconfig ast_config WHERE filename='extensions.conf' AND category like '%' AND zsection='' ")\n in /var/www/voiceonewebservices/lib/adodb/adodb-errorhandler.inc.php /var/www/voiceone_webservices/lib/adodb/adodb-errorhandler.inc.php on line 77, referer: http://192.168.7.97/voiceone/setup.php?step=3 http://192.168.7.97/voiceone/setup.php?step=3

В душе то я понимаю, что кмне говорится, но вот как это вылечить я не имею ни малейшего понятия. Кто нибудь сталкивался? К слову: Linux asterisk11 3.2.0-4-amd64 #1 SMP Debian 3.2.65-1+deb7u1 x8664 x86_64 GNU/Linux Voiceone 1.8.425

О проекте | Часто задаваемые вопросы | политика конфиденциальности | оставить отзыв

Проект компании "АТС Дизайн"
Asterisk® и Digium® являются зарегистрированными торговыми марками компании Digium, Inc., США.
IP АТС Asterisk распространяется под лицензией GNU GPL.