/l3/users/gnatishen/nt-voip/linux3.unix.nt/root :1 :2 :3 :4 :5 :6 :7 :8 :9 :10 :11 :12 :13 :14 :15
[ править ]

Журнал лабораторных работ

Содержание

Журнал

Пятница (04/12/13)

/dev/pts/1
14:00:03
#cat Master.csv 
"","1302","8000","default","1302","SIP/1302-00000001","","Playback","welcome","2013-04-08 14:19:51","2013-04-08 14:19:51","2013-04-08 14:19:52",1,1,"ANSWERED","DOCUMENTATION","1365430791.1",""
"","1302","8000","default","1302","SIP/1302-00000002","","Playback","welcome","2013-04-08 14:20:08","2013-04-08 14:20:08","2013-04-08 14:20:09",1,1,"ANSWERED","DOCUMENTATION","1365430808.2",""
"","1302","1301","default","1302","SIP/1302-00000003","","Answer","","2013-04-08 14:23:19","2013-04-08 14:23:19","2013-04-08 14:23:19",0,0,"ANSWERED","DOCUMENTATION","1365430999.3",""
"","1302","1301","default","1302","SIP/1302-00000004","SIP/1301-00000005","Dial","SIP/1301","2013-04-08 14:27:31",,"2013-04-08 14:27:36",5,0,"NO ANSWER","DOCUMENTATION","1365431251.4",""
"","1301","1302","default","1301","SIP/1301-00000006","SIP/1302-00000007","Dial","SIP/1302","2013-04-08 14:30:12",,"2013-04-08 14:30:15",3,0,"NO ANSWER","DOCUMENTATION","1365431412.6",""
"","1302","101301","default","1302","SIP/1302-00000008","SIP/1301-00000009","Dial","SIP/1301","2013-04-08 14:38:33",,"2013-04-08 14:38:36",3,0,"NO ANSWER","DOCUMENTATION","1365431913.8",""
"","1301","101302","default","1301","SIP/1301-0000000a","SIP/1302-0000000b","Dial","SIP/1302","2013-04-08 14:38:52",,"2013-04-08 14:38:55",3,0,"NO ANSWER","DOCUMENTATION","1365431932.10",""
"","1302","1301","default","1302","SIP/1302-00000000","SIP/1301-00000001","Dial","SIP/1301","2013-04-09 06:42:47",,"2013-04-09 06:42:51",4,0,"NO ANSWER","DOCUMENTATION","1365489767.0",""
"","1301","1401","default","1301","SIP/1301-00000002","SIP/harare-00000003","Dial","SIP/harare/1401","2013-04-09 07:14:21","2013-04-09 07:14:31","2013-04-09 07:14:38",17,7,"ANSWERED","DOCUMENTATION","1365491661.2",""
"","1401","1301","default","""1401"" <1401>","SIP/harare-00000004","SIP/1301-00000005","Dial","SIP/1301","2013-04-09 07:18:21","2013-04-09 07:18:24","2013-04-09 07:18:28",7,4,"ANSWERED","DOCUMENTATION","1365491901.4",""
...
"","asterisk","1302","gr3","""asterisk"" <asterisk>","SIP/harare-00000039","SIP/1302-0000003a","VoiceMail","1302@default","2013-04-11 14:13:14","2013-04-11 14:13:21","2013-04-11 14:15:32",138,131,"ANSWERED","DOCUMENTATION","1365689594.57",""
"","asterisk","1302","gr3","""asterisk"" <asterisk>","SIP/harare-0000003c","SIP/1302-0000003e","VoiceMail","1302@default","2013-04-11 14:15:09","2013-04-11 14:15:18","2013-04-11 14:17:29",140,131,"ANSWERED","DOCUMENTATION","1365689709.60",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-00000000","SIP/1301-00000001","Dial","SIP/1301,10,wWtTm","2013-04-12 11:41:56",,"2013-04-12 11:41:59",3,0,"NO ANSWER","DOCUMENTATION","1365766916.0",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-00000002","SIP/1301-00000003","Dial","SIP/1301,10,wWtTm","2013-04-12 11:42:44",,"2013-04-12 11:42:48",4,0,"NO ANSWER","DOCUMENTATION","1365766964.2",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-00000004","SIP/1301-00000005","Dial","SIP/1301,10,wWtTm","2013-04-12 11:44:17",,"2013-04-12 11:44:23",6,0,"NO ANSWER","DOCUMENTATION","1365767057.4",""
"","1301","1302","gr3","""gweru Yuriy IPphone"" <1301>","SIP/1301-00000006","SIP/1302-00000007","Dial","SIP/1302,10,wWtTm","2013-04-12 11:44:41",,"2013-04-12 11:44:45",4,0,"NO ANSWER","DOCUMENTATION","1365767081.6",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-00000008","SIP/1301-00000009","Dial","SIP/1301,10,wWtTm","2013-04-12 11:45:07",,"2013-04-12 11:45:10",3,0,"NO ANSWER","DOCUMENTATION","1365767107.8",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-0000000a","SIP/1301-0000000b","Dial","SIP/1301,10,wWtTm","2013-04-12 11:46:46",,"2013-04-12 11:46:51",5,0,"NO ANSWER","DOCUMENTATION","1365767206.10",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-0000000c","SIP/1301-0000000d","Dial","SIP/1301,10,wWtTm","2013-04-12 11:47:01",,"2013-04-12 11:47:03",2,0,"NO ANSWER","DOCUMENTATION","1365767221.12",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-0000000e","SIP/1301-0000000f","Dial","SIP/1301,10,wWtTm","2013-04-12 11:48:36",,"2013-04-12 11:48:40",4,0,"NO ANSWER","DOCUMENTATION","1365767316.14",""
/dev/pts/2
14:00:03
#cat Master.csv
"","1302","8000","default","1302","SIP/1302-00000001","","Playback","welcome","2013-04-08 14:19:51","2013-04-08 14:19:51","2013-04-08 14:19:52",1,1,"ANSWERED","DOCUMENTATION","1365430791.1",""
"","1302","8000","default","1302","SIP/1302-00000002","","Playback","welcome","2013-04-08 14:20:08","2013-04-08 14:20:08","2013-04-08 14:20:09",1,1,"ANSWERED","DOCUMENTATION","1365430808.2",""
"","1302","1301","default","1302","SIP/1302-00000003","","Answer","","2013-04-08 14:23:19","2013-04-08 14:23:19","2013-04-08 14:23:19",0,0,"ANSWERED","DOCUMENTATION","1365430999.3",""
"","1302","1301","default","1302","SIP/1302-00000004","SIP/1301-00000005","Dial","SIP/1301","2013-04-08 14:27:31",,"2013-04-08 14:27:36",5,0,"NO ANSWER","DOCUMENTATION","1365431251.4",""
"","1301","1302","default","1301","SIP/1301-00000006","SIP/1302-00000007","Dial","SIP/1302","2013-04-08 14:30:12",,"2013-04-08 14:30:15",3,0,"NO ANSWER","DOCUMENTATION","1365431412.6",""
"","1302","101301","default","1302","SIP/1302-00000008","SIP/1301-00000009","Dial","SIP/1301","2013-04-08 14:38:33",,"2013-04-08 14:38:36",3,0,"NO ANSWER","DOCUMENTATION","1365431913.8",""
"","1301","101302","default","1301","SIP/1301-0000000a","SIP/1302-0000000b","Dial","SIP/1302","2013-04-08 14:38:52",,"2013-04-08 14:38:55",3,0,"NO ANSWER","DOCUMENTATION","1365431932.10",""
"","1302","1301","default","1302","SIP/1302-00000000","SIP/1301-00000001","Dial","SIP/1301","2013-04-09 06:42:47",,"2013-04-09 06:42:51",4,0,"NO ANSWER","DOCUMENTATION","1365489767.0",""
"","1301","1401","default","1301","SIP/1301-00000002","SIP/harare-00000003","Dial","SIP/harare/1401","2013-04-09 07:14:21","2013-04-09 07:14:31","2013-04-09 07:14:38",17,7,"ANSWERED","DOCUMENTATION","1365491661.2",""
"","1401","1301","default","""1401"" <1401>","SIP/harare-00000004","SIP/1301-00000005","Dial","SIP/1301","2013-04-09 07:18:21","2013-04-09 07:18:24","2013-04-09 07:18:28",7,4,"ANSWERED","DOCUMENTATION","1365491901.4",""
...
"","asterisk","1302","gr3","""asterisk"" <asterisk>","SIP/harare-00000039","SIP/1302-0000003a","VoiceMail","1302@default","2013-04-11 14:13:14","2013-04-11 14:13:21","2013-04-11 14:15:32",138,131,"ANSWERED","DOCUMENTATION","1365689594.57",""
"","asterisk","1302","gr3","""asterisk"" <asterisk>","SIP/harare-0000003c","SIP/1302-0000003e","VoiceMail","1302@default","2013-04-11 14:15:09","2013-04-11 14:15:18","2013-04-11 14:17:29",140,131,"ANSWERED","DOCUMENTATION","1365689709.60",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-00000000","SIP/1301-00000001","Dial","SIP/1301,10,wWtTm","2013-04-12 11:41:56",,"2013-04-12 11:41:59",3,0,"NO ANSWER","DOCUMENTATION","1365766916.0",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-00000002","SIP/1301-00000003","Dial","SIP/1301,10,wWtTm","2013-04-12 11:42:44",,"2013-04-12 11:42:48",4,0,"NO ANSWER","DOCUMENTATION","1365766964.2",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-00000004","SIP/1301-00000005","Dial","SIP/1301,10,wWtTm","2013-04-12 11:44:17",,"2013-04-12 11:44:23",6,0,"NO ANSWER","DOCUMENTATION","1365767057.4",""
"","1301","1302","gr3","""gweru Yuriy IPphone"" <1301>","SIP/1301-00000006","SIP/1302-00000007","Dial","SIP/1302,10,wWtTm","2013-04-12 11:44:41",,"2013-04-12 11:44:45",4,0,"NO ANSWER","DOCUMENTATION","1365767081.6",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-00000008","SIP/1301-00000009","Dial","SIP/1301,10,wWtTm","2013-04-12 11:45:07",,"2013-04-12 11:45:10",3,0,"NO ANSWER","DOCUMENTATION","1365767107.8",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-0000000a","SIP/1301-0000000b","Dial","SIP/1301,10,wWtTm","2013-04-12 11:46:46",,"2013-04-12 11:46:51",5,0,"NO ANSWER","DOCUMENTATION","1365767206.10",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-0000000c","SIP/1301-0000000d","Dial","SIP/1301,10,wWtTm","2013-04-12 11:47:01",,"2013-04-12 11:47:03",2,0,"NO ANSWER","DOCUMENTATION","1365767221.12",""
"","1302","1301","gr2","""gweru Yuriy SOFTphone"" <1302>","SIP/1302-0000000e","SIP/1301-0000000f","Dial","SIP/1301,10,wWtTm","2013-04-12 11:48:36",,"2013-04-12 11:48:40",4,0,"NO ANSWER","DOCUMENTATION","1365767316.14",""
/dev/pts/1
14:00:07
#apt-get install asterisk-mysql 
Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
Будут установлены следующие дополнительные пакеты:
  libmysqlclient16 mysql-common
НОВЫЕ пакеты, которые будут установлены:
  asterisk-mysql libmysqlclient16 mysql-common
обновлено 0, установлено 3 новых пакетов, для удаления отмечено 0 пакетов, и 2 пакетов не обновлено.
Необходимо скачать 47,4 kB/2.056 kB архивов.
После данной операции, объём занятого дискового пространства возрастёт на 4.604 kB.
...
Выбор ранее не выбранного пакета mysql-common.
(Чтение базы данных ... на данный момент установлено 134342 файла и каталога.)
Распаковывается пакет mysql-common (из файла .../mysql-common_5.1.66-0+squeeze1_all.deb)...
Выбор ранее не выбранного пакета libmysqlclient16.
Распаковывается пакет libmysqlclient16 (из файла .../libmysqlclient16_5.1.66-0+squeeze1_i386.deb)...
Выбор ранее не выбранного пакета asterisk-mysql.
Распаковывается пакет asterisk-mysql (из файла .../asterisk-mysql_1.6.2.1-1_i386.deb)...
Настраивается пакет mysql-common (5.1.66-0+squeeze1) ...
Настраивается пакет libmysqlclient16 (5.1.66-0+squeeze1) ...
Настраивается пакет asterisk-mysql (1.6.2.1-1) ...
/dev/pts/2
14:00:07
#apt-get install asterisk-mysql
Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
Будут установлены следующие дополнительные пакеты:
  libmysqlclient16 mysql-common
НОВЫЕ пакеты, которые будут установлены:
  asterisk-mysql libmysqlclient16 mysql-common
обновлено 0, установлено 3 новых пакетов, для удаления отмечено 0 пакетов, и 2 пакетов не обновлено.
Необходимо скачать 47,4 kB/2.056 kB архивов.
После данной операции, объём занятого дискового пространства возрастёт на 4.604 kB.
...
Выбор ранее не выбранного пакета mysql-common.
(Чтение базы данных ... на данный момент установлено 134342 файла и каталога.)
Распаковывается пакет mysql-common (из файла .../mysql-common_5.1.66-0+squeeze1_all.deb)...
Выбор ранее не выбранного пакета libmysqlclient16.
Распаковывается пакет libmysqlclient16 (из файла .../libmysqlclient16_5.1.66-0+squeeze1_i386.deb)...
Выбор ранее не выбранного пакета asterisk-mysql.
Распаковывается пакет asterisk-mysql (из файла .../asterisk-mysql_1.6.2.1-1_i386.deb)...
Настраивается пакет mysql-common (5.1.66-0+squeeze1) ...
Настраивается пакет libmysqlclient16 (5.1.66-0+squeeze1) ...
Настраивается пакет asterisk-mysql (1.6.2.1-1) ...
/dev/pts/1
14:02:54
#cd /tmp 










/dev/pts/2
14:02:54




#cd /tmp












/dev/pts/1
14:03:03




#nano cdr_mysql.txt













/dev/pts/2
14:03:03




#nano cdr_mysql.txt





--- /dev/null	2013-04-12 08:59:42.416736042 +0300
+++ cdr_mysql.txt	2013-04-12 15:05:10.000000000 +0300
@@ -0,0 +1,21 @@
+DROP DATABASE asterisk;
+CREATE DATABASE asterisk;
+USE asterisk;
+CREATE TABLE cdr (
+  calldate datetime NOT NULL default '0000-00-00 00:00:00',
+  clid varchar(80) NOT NULL default '',
+  src varchar(80) NOT NULL default '',
+  dst varchar(80) NOT NULL default '',
+  dcontext varchar(80) NOT NULL default '',
+  channel varchar(80) NOT NULL default '',
+  dstchannel varchar(80) NOT NULL default '',
+  lastapp varchar(80) NOT NULL default '',
+  lastdata varchar(80) NOT NULL default '',
+  duration int(11) NOT NULL default '0',
+  billsec int(11) NOT NULL default '0',
+  disposition varchar(45) NOT NULL default '',
+  amaflags int(11) NOT NULL default '0',
+  accountcode varchar(20) NOT NULL default '',
+  uniqueid varchar(32) NOT NULL default '',
+  userfield varchar(255) NOT NULL default ''
+);









/dev/pts/1
14:05:10




#DROP DATABASE asterisk;





Call Detail Recording for MySQL
===============================
Usage:
======
Include the module in your modules.conf.  Change the database hostname, database name, username, and password in cdr_mysql.conf.
Create a table called cdr under the database name you will be using the following schema.
CREATE TABLE cdr (
  calldate datetime NOT NULL default '0000-00-00 00:00:00',
  clid varchar(80) NOT NULL default '',
  src varchar(80) NOT NULL default '',
...
~
~
~
~
~
~
~
~
~
~











/dev/pts/2
14:05:10




#DROP DATABASE asterisk;


Call Detail Recording for MySQL
===============================
Usage:
======
Include the module in your modules.conf.  Change the database hostname, database name, username, and password in cdr_mysql.conf.
Create a table called cdr under the database name you will be using the following schema.
CREATE TABLE cdr (
  calldate datetime NOT NULL default '0000-00-00 00:00:00',
  clid varchar(80) NOT NULL default '',
  src varchar(80) NOT NULL default '',
...
~
~
~
~
~
~
~
~
~
~











/dev/pts/1
14:08:03




#apt-get install mysql-server





Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
Будут установлены следующие дополнительные пакеты:
  libdbd-mysql-perl libdbi-perl libhtml-template-perl libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-server-5.1
  mysql-server-core-5.1
Предлагаемые пакеты:
  libipc-sharedcache-perl libterm-readkey-perl tinyca
НОВЫЕ пакеты, которые будут установлены:
  libdbd-mysql-perl libdbi-perl libhtml-template-perl libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-server
...
130412 15:12:03 [Note] Plugin 'FEDERATED' is disabled.
130412 15:12:03  InnoDB: Initializing buffer pool, size = 8.0M
130412 15:12:03  InnoDB: Completed initialization of buffer pool
130412 15:12:03  InnoDB: Started; log sequence number 0 44233
130412 15:12:03  InnoDB: Starting shutdown...
130412 15:12:08  InnoDB: Shutdown completed; log sequence number 0 44233
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Настраивается пакет libhtml-template-perl (2.9-2) ...
Настраивается пакет mysql-server (5.1.66-0+squeeze1) ...











/dev/pts/2
14:08:03




#apt-get install mysql-server


Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
Будут установлены следующие дополнительные пакеты:
  libdbd-mysql-perl libdbi-perl libhtml-template-perl libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-server-5.1
  mysql-server-core-5.1
Предлагаемые пакеты:
  libipc-sharedcache-perl libterm-readkey-perl tinyca
НОВЫЕ пакеты, которые будут установлены:
  libdbd-mysql-perl libdbi-perl libhtml-template-perl libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-server
...
130412 15:12:03 [Note] Plugin 'FEDERATED' is disabled.
130412 15:12:03  InnoDB: Initializing buffer pool, size = 8.0M
130412 15:12:03  InnoDB: Completed initialization of buffer pool
130412 15:12:03  InnoDB: Started; log sequence number 0 44233
130412 15:12:03  InnoDB: Starting shutdown...
130412 15:12:08  InnoDB: Shutdown completed; log sequence number 0 44233
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
Настраивается пакет libhtml-template-perl (2.9-2) ...
Настраивается пакет mysql-server (5.1.66-0+squeeze1) ...











/dev/pts/1
14:12:28




#mysql





mysql                       mysql_convert_table_format  mysqlhotcopy                mysqlshow
mysqlaccess                 mysqld                      mysqlimport                 mysqlslap
mysqladmin                  mysqld_multi                mysql_install_db            mysqltest
mysqlanalyze                mysqld_safe                 mysqlmanager                mysqltest_embedded
mysqlbinlog                 mysqldump                   mysqloptimize               mysql_tzinfo_to_sql
mysqlbug                    mysqldumpslow               mysqlrepair                 mysql_upgrade
mysqlcheck                  mysql_find_rows             mysqlreport                 mysql_waitpid
mysql_client_test           mysql_fix_extensions        mysql_secure_installation   mysql_zap
mysql_client_test_embedded  mysql_fix_privilege_tables  mysql_setpermission











/dev/pts/2
14:12:28




#mysql





mysql                       mysql_convert_table_format  mysqlhotcopy                mysqlshow
mysqlaccess                 mysqld                      mysqlimport                 mysqlslap
mysqladmin                  mysqld_multi                mysql_install_db            mysqltest
mysqlanalyze                mysqld_safe                 mysqlmanager                mysqltest_embedded
mysqlbinlog                 mysqldump                   mysqloptimize               mysql_tzinfo_to_sql
mysqlbug                    mysqldumpslow               mysqlrepair                 mysql_upgrade
mysqlcheck                  mysql_find_rows             mysqlreport                 mysql_waitpid
mysql_client_test           mysql_fix_extensions        mysql_secure_installation   mysql_zap
mysql_client_test_embedded  mysql_fix_privilege_tables  mysql_setpermission











/dev/pts/1
14:12:28




#vim /tmp/













/dev/pts/2
14:12:28




#vim /tmp/













/dev/pts/1
14:12:28




#vim /tmp/cdr_mysql.txt













/dev/pts/2
14:12:28




#vim /tmp/cdr_mysql.txt










/dev/pts/1
14:13:14




#~















/dev/pts/2
14:13:14




#~












/dev/pts/1
14:13:21




#mysql -p < ./cdr_mysql.txt





Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)











/dev/pts/2
14:13:21




#mysql -p < ./cdr_mysql.txt





Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)











/dev/pts/1
14:13:51




#mysql -p < ./cdr_mysql.txt





Enter password:
ERROR 1008 (HY000) at line 1: Can't drop database 'asterisk'; database doesn't exist











/dev/pts/2
14:13:51




#mysql -p < ./cdr_mysql.txt





Enter password:
ERROR 1008 (HY000) at line 1: Can't drop database 'asterisk'; database doesn't exist











/dev/pts/1
14:14:26




#~





CREATE DATABASE asterisk;
USE asterisk;
CREATE TABLE cdr (
  calldate datetime NOT NULL default '0000-00-00 00:00:00',
  clid varchar(80) NOT NULL default '',
  src varchar(80) NOT NULL default '',
  dst varchar(80) NOT NULL default '',
  dcontext varchar(80) NOT NULL default '',
  channel varchar(80) NOT NULL default '',
  dstchannel varchar(80) NOT NULL default '',
...
~
~
~
~
~
~
~
~
~
-- ВСТАВ                                                                                                       2,1          Весь











/dev/pts/2
14:14:26




#~


CREATE DATABASE asterisk;
USE asterisk;
CREATE TABLE cdr (
  calldate datetime NOT NULL default '0000-00-00 00:00:00',
  clid varchar(80) NOT NULL default '',
  src varchar(80) NOT NULL default '',
  dst varchar(80) NOT NULL default '',
  dcontext varchar(80) NOT NULL default '',
  channel varchar(80) NOT NULL default '',
  dstchannel varchar(80) NOT NULL default '',
...
~
~
~
~
~
~
~
~
~
-- ВСТАВ                                                                                                       2,1          Весь











/dev/pts/1
14:15:04




#mysql -p





Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 43
Server version: 5.1.66-0+squeeze1 (Debian)
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> GRANT SELECT,UPDATE,INSERT,DELETE,DROP on asterisk.* to 'asterisk'@'localhost'^CCtrl-C -- exit!
Aborted











/dev/pts/2
14:15:04




#mysql -p





Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 43
Server version: 5.1.66-0+squeeze1 (Debian)
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> GRANT SELECT,UPDATE,INSERT,DELETE,DROP on asterisk.* to 'asterisk'@'localhost'^CCtrl-C -- exit!
Aborted











/dev/pts/1
14:16:21




#mysql -p





Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 44
Server version: 5.1.66-0+squeeze1 (Debian)
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
...
mysql> CREATE USER 'asterisk'@'localhost' IDENTIFIED BY 'asterpass';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT,UPDATE,INSERT,DELETE,DROP on asterisk.* to 'asterisk'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql>
mysql> Bye











/dev/pts/2
14:16:21




#mysql -p


Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 44
Server version: 5.1.66-0+squeeze1 (Debian)
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
...
mysql> CREATE USER 'asterisk'@'localhost' IDENTIFIED BY 'asterpass';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT SELECT,UPDATE,INSERT,DELETE,DROP on asterisk.* to 'asterisk'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql>
mysql> Bye











/dev/pts/1
14:19:25




#vim /etc/













/dev/pts/2
14:19:25




#vim /etc/













/dev/pts/1
14:19:25




#cp /usr/share/doc/asterisk-mysql/examples/cdr_mysql.conf.sample /etc/asterisk/cdr_mysql.conf















/dev/pts/2
14:19:25




#cp /usr/share/doc/asterisk-mysql/examples/cdr_mysql.conf.sample /etc/asterisk/cdr_mysql.conf










прошло 33 минуты




/dev/pts/1
14:52:49




#vim /etc/asterisk/cdr_mysql.conf













/dev/pts/2
14:52:49




#vim /etc/asterisk/cdr_mysql.conf


--- /tmp/l3-saved-2297.9235.5722	2013-04-12 15:52:55.000000000 +0300
+++ /etc/asterisk/cdr_mysql.conf	2013-04-12 15:54:18.000000000 +0300
@@ -10,12 +10,12 @@
 ; "localhost", then cdr_mysql will attempt to connect to the socket file 
 ; specified by sock or otherwise use the default socket file.
 ;
-;[global]
-;hostname=database.host.name
-;dbname=asteriskcdrdb
-;table=cdr
-;password=password 
-;user=asteriskcdruser
+[global]
+hostname=127.0.0.1
+dbname=asterisk
+table=cdr
+password=asterpass 
+user=asterisk
 ;port=3306
 ;sock=/tmp/mysql.sock
 ;









/dev/pts/1
14:54:23




#;alias disposition => disposition















/dev/pts/2
14:54:23




#;alias disposition => disposition












/dev/pts/1
14:54:23




#/etc/init.d/asterisk restart





Stopping Asterisk PBX: asterisk.
Starting Asterisk PBX: asterisk.











/dev/pts/2
14:54:23




#/etc/init.d/asterisk restart


Stopping Asterisk PBX: asterisk.
Starting Asterisk PBX: asterisk.









прошло 15 минут




/dev/pts/1
15:10:21




#cp root@192.168.70.1:/root/asterisk-11.3.0.tar.gz /usr/src/





cp: невозможно выполнить stat для «root@192.168.70.1:/root/asterisk-11.3.0.tar.gz»: Нет такого файла или каталога











/dev/pts/2
15:10:21




#cp root@192.168.70.1:/root/asterisk-11.3.0.tar.gz /usr/src/





cp: невозможно выполнить stat для «root@192.168.70.1:/root/asterisk-11.3.0.tar.gz»: Нет такого файла или каталога











/dev/pts/1
15:11:15




#scp root@192.168.70.1:/root/asterisk-11.3.0.tar.gz /usr/src/





root@192.168.70.1's password:
asterisk-11.3.0.tar.gz                                  100%   29MB   9.7MB/s   00:03











/dev/pts/2
15:11:15




#scp root@192.168.70.1:/root/asterisk-11.3.0.tar.gz /usr/src/


root@192.168.70.1's password:
asterisk-11.3.0.tar.gz                                  100%   29MB   9.7MB/s   00:03











/dev/pts/1
15:11:32




#cd /usr/src/





asterisk-11.3.0.tar.gz               linux-headers-3.2.0-0.bpo.4-686-pae/
dahdi-linux-2.6.2/                   linux-headers-3.2.0-0.bpo.4-common/
dahdi-linux-2.6.2.tar.gz             linux-kbuild-3.2/
dahdi.tar.bz2                        modules/
linux/                               vpb-driver.tar.bz2











15:11:32




#cd /usr/src/















/dev/pts/2
15:11:32




#cd /usr/src/





asterisk-11.3.0.tar.gz               linux-headers-3.2.0-0.bpo.4-686-pae/
dahdi-linux-2.6.2/                   linux-headers-3.2.0-0.bpo.4-common/
dahdi-linux-2.6.2.tar.gz             linux-kbuild-3.2/
dahdi.tar.bz2                        modules/
linux/                               vpb-driver.tar.bz2











15:11:32




#cd /usr/src/












/dev/pts/1
15:11:43




#tar ./





asterisk-11.3.0.tar.gz               linux-headers-3.2.0-0.bpo.4-686-pae/
dahdi-linux-2.6.2/                   linux-headers-3.2.0-0.bpo.4-common/
dahdi-linux-2.6.2.tar.gz             linux-kbuild-3.2/
dahdi.tar.bz2                        modules/
linux/                               vpb-driver.tar.bz2











/dev/pts/2
15:11:43




#tar ./





asterisk-11.3.0.tar.gz               linux-headers-3.2.0-0.bpo.4-686-pae/
dahdi-linux-2.6.2/                   linux-headers-3.2.0-0.bpo.4-common/
dahdi-linux-2.6.2.tar.gz             linux-kbuild-3.2/
dahdi.tar.bz2                        modules/
linux/                               vpb-driver.tar.bz2











/dev/pts/1
15:11:43




#tar xfz ./asterisk-11.3.0.tar.gz















/dev/pts/2
15:11:43




#tar xfz ./asterisk-11.3.0.tar.gz












/dev/pts/1
15:12:07




#cd asterisk-11.3.0















/dev/pts/2
15:12:07




#cd asterisk-11.3.0












/dev/pts/1
15:12:12




#make menuconfig





make: -F.: Команда не найдена
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
...
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
****
**** The configure script must be executed before running 'make'.
****               Please run "./configure".
****
make: *** [makeopts] Ошибка 1











/dev/pts/2
15:12:12




#make menuconfig





make: -F.: Команда не найдена
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
...
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
/bin/sh: Illegal option -
****
**** The configure script must be executed before running 'make'.
****               Please run "./configure".
****
make: *** [makeopts] Ошибка 1











/dev/pts/1
15:12:25




#./con





config.guess  configs/      config.sub    configure     contrib/











15:12:25




#./con





config.guess  configs/      config.sub    configure     contrib/











/dev/pts/2
15:12:25




#./con





config.guess  configs/      config.sub    configure     contrib/











15:12:25




#./con





config.guess  configs/      config.sub    configure     contrib/











/dev/pts/1
15:12:25




#./configure





checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
...
checking arpa/nameser.h presence... yes
checking for arpa/nameser.h... yes
checking sys/io.h usability... yes
checking sys/io.h presence... yes
checking for sys/io.h... yes
checking for tgetent in -ltermcap... no
checking for tgetent in -ltinfo... no
checking for initscr in -lcurses... no
checking for initscr in -lncurses... no
configure: error: *** termcap support not found (on modern systems, this typically means the ncurses development package is missing)











/dev/pts/2
15:12:25




#./configure





checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
...
checking arpa/nameser.h presence... yes
checking for arpa/nameser.h... yes
checking sys/io.h usability... yes
checking sys/io.h presence... yes
checking for sys/io.h... yes
checking for tgetent in -ltermcap... no
checking for tgetent in -ltinfo... no
checking for initscr in -lcurses... no
checking for initscr in -lncurses... no
configure: error: *** termcap support not found (on modern systems, this typically means the ncurses development package is missing)











/dev/pts/1
15:13:05




#apt-cache search srtp





libsrtp0-dev - Secure RTP (SRTP) and UST Reference Implementations - development files
libsrtp0 - Secure RTP (SRTP) and UST Reference Implementations - shared library
srtp-docs - Secure RTP (SRTP) and UST Reference Implementations - documentation
srtp-utils - Secure RTP (SRTP) and UST Reference Implementations - utilities
uanytun - tiny implementation of the secure anycast tunneling protocol
twinkle - передача голоса по IP-протоколу (VoIP) — SIP-телефон











/dev/pts/2
15:13:05




#apt-cache search srtp


libsrtp0-dev - Secure RTP (SRTP) and UST Reference Implementations - development files
libsrtp0 - Secure RTP (SRTP) and UST Reference Implementations - shared library
srtp-docs - Secure RTP (SRTP) and UST Reference Implementations - documentation
srtp-utils - Secure RTP (SRTP) and UST Reference Implementations - utilities
uanytun - tiny implementation of the secure anycast tunneling protocol
twinkle - передача голоса по IP-протоколу (VoIP) — SIP-телефон











/dev/pts/1
15:13:37




#apt-cache install libsrtp0





E: Неверная операция install











/dev/pts/2
15:13:37




#apt-cache install libsrtp0





E: Неверная операция install











/dev/pts/1
15:13:52




#apt-cache install libsrtp0-dev





E: Неверная операция install











/dev/pts/2
15:13:52




#apt-cache install libsrtp0-dev





E: Неверная операция install











/dev/pts/1
15:14:02




#apt-get install libsrtp0-dev





Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
НОВЫЕ пакеты, которые будут установлены:
  libsrtp0-dev
обновлено 0, установлено 1 новых пакетов, для удаления отмечено 0 пакетов, и 2 пакетов не обновлено.
Необходимо скачать 84,2 kБ архивов.
После данной операции, объём занятого дискового пространства возрастёт на 385 kB.
Получено:1 http://192.168.15.253/debian/ squeeze/main libsrtp0-dev i386 1.4.4~dfsg-6 [84,2 kB]
Получено 84,2 kБ за 0с (3.277 kБ/c)
Выбор ранее не выбранного пакета libsrtp0-dev.
(Чтение базы данных ... на данный момент установлено 134826 файлов и каталогов.)
Распаковывается пакет libsrtp0-dev (из файла .../libsrtp0-dev_1.4.4~dfsg-6_i386.deb)...
Настраивается пакет libsrtp0-dev (1.4.4~dfsg-6) ...











/dev/pts/2
15:14:02




#apt-get install libsrtp0-dev


Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
НОВЫЕ пакеты, которые будут установлены:
  libsrtp0-dev
обновлено 0, установлено 1 новых пакетов, для удаления отмечено 0 пакетов, и 2 пакетов не обновлено.
Необходимо скачать 84,2 kБ архивов.
После данной операции, объём занятого дискового пространства возрастёт на 385 kB.
Получено:1 http://192.168.15.253/debian/ squeeze/main libsrtp0-dev i386 1.4.4~dfsg-6 [84,2 kB]
Получено 84,2 kБ за 0с (3.277 kБ/c)
Выбор ранее не выбранного пакета libsrtp0-dev.
(Чтение базы данных ... на данный момент установлено 134826 файлов и каталогов.)
Распаковывается пакет libsrtp0-dev (из файла .../libsrtp0-dev_1.4.4~dfsg-6_i386.deb)...
Настраивается пакет libsrtp0-dev (1.4.4~dfsg-6) ...











/dev/pts/1
15:14:11




#apt-get install libsrtp0





Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
Уже установлена самая новая версия libsrtp0.
libsrtp0 установлен вручную.
обновлено 0, установлено 0 новых пакетов, для удаления отмечено 0 пакетов, и 2 пакетов не обновлено.











/dev/pts/2
15:14:11




#apt-get install libsrtp0


Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
Уже установлена самая новая версия libsrtp0.
libsrtp0 установлен вручную.
обновлено 0, установлено 0 новых пакетов, для удаления отмечено 0 пакетов, и 2 пакетов не обновлено.











/dev/pts/1
15:14:16




#cd /usr/src/















/dev/pts/2
15:14:16




#cd /usr/src/












/dev/pts/1
15:14:41




#apt-get install libssl-dev





Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
Будут установлены следующие дополнительные пакеты:
  zlib1g-dev
НОВЫЕ пакеты, которые будут установлены:
  libssl-dev zlib1g-dev
обновлено 0, установлено 2 новых пакетов, для удаления отмечено 0 пакетов, и 2 пакетов не обновлено.
Необходимо скачать 2.349 kБ архивов.
После данной операции, объём занятого дискового пространства возрастёт на 6.443 kB.
...
Получено:2 http://192.168.15.253/debian/ squeeze/main libssl-dev i386 0.9.8o-4squeeze14 [2.163 kB]
Получено 2.349 kБ за 3с (730 kБ/c)
Выбор ранее не выбранного пакета zlib1g-dev.
(Чтение базы данных ... на данный момент установлен 134871 файл и каталог.)
Распаковывается пакет zlib1g-dev (из файла .../zlib1g-dev_1%3a1.2.3.4.dfsg-3_i386.deb)...
Выбор ранее не выбранного пакета libssl-dev.
Распаковывается пакет libssl-dev (из файла .../libssl-dev_0.9.8o-4squeeze14_i386.deb)...
Обрабатываются триггеры для man-db ...
Настраивается пакет zlib1g-dev (1:1.2.3.4.dfsg-3) ...
Настраивается пакет libssl-dev (0.9.8o-4squeeze14) ...











/dev/pts/2
15:14:41




#apt-get install libssl-dev


Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
Будут установлены следующие дополнительные пакеты:
  zlib1g-dev
НОВЫЕ пакеты, которые будут установлены:
  libssl-dev zlib1g-dev
обновлено 0, установлено 2 новых пакетов, для удаления отмечено 0 пакетов, и 2 пакетов не обновлено.
Необходимо скачать 2.349 kБ архивов.
После данной операции, объём занятого дискового пространства возрастёт на 6.443 kB.
...
Получено:2 http://192.168.15.253/debian/ squeeze/main libssl-dev i386 0.9.8o-4squeeze14 [2.163 kB]
Получено 2.349 kБ за 3с (730 kБ/c)
Выбор ранее не выбранного пакета zlib1g-dev.
(Чтение базы данных ... на данный момент установлен 134871 файл и каталог.)
Распаковывается пакет zlib1g-dev (из файла .../zlib1g-dev_1%3a1.2.3.4.dfsg-3_i386.deb)...
Выбор ранее не выбранного пакета libssl-dev.
Распаковывается пакет libssl-dev (из файла .../libssl-dev_0.9.8o-4squeeze14_i386.deb)...
Обрабатываются триггеры для man-db ...
Настраивается пакет zlib1g-dev (1:1.2.3.4.dfsg-3) ...
Настраивается пакет libssl-dev (0.9.8o-4squeeze14) ...











/dev/pts/1
15:15:05




#apt-get install libncurses5-dev





Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
НОВЫЕ пакеты, которые будут установлены:
  libncurses5-dev
обновлено 0, установлено 1 новых пакетов, для удаления отмечено 0 пакетов, и 2 пакетов не обновлено.
Необходимо скачать 1.597 kБ архивов.
После данной операции, объём занятого дискового пространства возрастёт на 6.685 kB.
Получено:1 http://192.168.15.253/debian/ squeeze/main libncurses5-dev i386 5.7+20100313-5 [1.597 kB]
Получено 1.597 kБ за 0с (10,3 MБ/c)
Выбор ранее не выбранного пакета libncurses5-dev.
(Чтение базы данных ... на данный момент установлено 136133 файла и каталога.)
Распаковывается пакет libncurses5-dev (из файла .../libncurses5-dev_5.7+20100313-5_i386.deb)...
Обрабатываются триггеры для man-db ...
Настраивается пакет libncurses5-dev (5.7+20100313-5) ...











/dev/pts/2
15:15:05




#apt-get install libncurses5-dev


Чтение списков пакетов... Готово
Построение дерева зависимостей
Чтение информации о состоянии... Готово
НОВЫЕ пакеты, которые будут установлены:
  libncurses5-dev
обновлено 0, установлено 1 новых пакетов, для удаления отмечено 0 пакетов, и 2 пакетов н