Не работают отчеты в FreePBX

[Vlad1983]

cdr_mysql.conf
[global]
hostname = localhost
dbname=asteriskcdrdb
password = **PASSWORD
user = **asteriskuser
userfield=1

поробуй подцепиться так
mysql -u **asteriskuser -p**PASSWORD asteriskcdrdb

Код: Выделить всё

mysql> show tables;
+-------------------------+
| Tables_in_asteriskcdrdb |
+-------------------------+
| cdr                     |
+-------------------------+

что говорит на это
CLI> module reload cdr_addon_mysql.so

[Parenek]

localhost*CLI> module reload cdr_addon_mysql.so
No such module 'cdr_addon_mysql.so'
Но в папке /usr/lib/asterisk/modules он есть (cdr_addon_mysql.so)


mysql -uuser -ppassword -hlocalhost
Далее прошу его показать мне базы какие есть show databases он не чего не выдает т.е. получается так:

mysql> show databases
->
Может что то не так с mysql?

[Vlad1983]

mysql> show databases
->
Может что то не так с mysql?

точку с запятой кто ставить в конце будет?

Код: Выделить всё

mysql> show databases;

есть но прав на запуск нет скорей всего

Код: Выделить всё

chown -R asterisk:asterisk /usr/lib/asterisk/modules/
chmod 755 /usr/lib/asterisk/modules/

[Parenek]

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| asterisk |
| asteriskcdrdb |
| test |
+--------------------+
4 rows in set (0.01 sec)


[root@localhost ~]# chown -R asterisk:asterisk /usr/lib/asterisk/modules/
[root@localhost ~]# chmod 755 /usr/lib/asterisk/modules/
[root@localhost ~]# asterisk -r
Asterisk 1.6.2.11, Copyright (C) 1999 - 2010 Digium, Inc. and others.
Created by Mark Spencer <markster@digium.com>
Asterisk comes with ABSOLUTELY NO WARRANTY; type 'core show warranty' for details.
This is free software, with components licensed under the GNU General Public
License version 2 and other licenses; you are welcome to redistribute it under
certain conditions. Type 'core show license' for details.
=========================================================================
Connected to Asterisk 1.6.2.11 currently running on localhost (pid = 3088)
Verbosity is at least 3
localhost*CLI> module reload cdr_addon_mysql.so
No such module 'cdr_addon_mysql.so'

[ded]

Если бы открыли /var/log/aserisk/full
то увидели, чего не хватает при загрузке cdr_mysql. А не хватает mysql client.

[Parenek]

Как не странно в логах не чего нет.

[root@localhost ~]# yum install mysql-client
Loaded plugins: fastestmirror, kmod
Loading mirror speeds from cached hostfile
* addons: mirror.yandex.ru
* base: centos.hostace.ru
* extras: centos.hostace.ru
* rpmforge: ftp-stud.fht-esslingen.de
* updates: centos.hostace.ru
Setting up Install Process
No package mysql-client available.
Nothing to do

[ded]

Тупим?

Код: Выделить всё

[root@insanity ~]# yum provides mysqlclient
Loading "installonlyn" plugin
Loading "repolist" plugin
Loading "downloadonly" plugin
Loading "protectbase" plugin
Setting up repositories
base 100% |=========================| 1.1 kB 00:00 
updates 100% |=========================| 951 B 00:00 


mysql.i386 5.0.22-2.2.el5_1.1 updates 
Matched from:
/usr/lib/mysql/libmysqlclient_r.so.15
/usr/lib/mysql/libmysqlclient.so.15.0.0
/usr/lib/mysql/libmysqlclient.so.15
/usr/lib/mysql/libmysqlclient_r.so.15.0.0
libmysqlclient_r.so.15
libmysqlclient_r.so.15(libmysqlclient_15)
libmysqlclient.so.15
libmysqlclient.so.15(libmysqlclient_15)


mysql-devel.i386 5.0.22-2.2.el5_1.1 updates 
Matched from:
/usr/lib/mysql/libmysqlclient.so
/usr/lib/mysql/libmysqlclient_r.a
/usr/lib/mysql/libmysqlclient_r.so
/usr/lib/mysql/libmysqlclient.a

[Parenek]

Код: Выделить всё

[root@localhost log]# yum provides mysqlclient
Loaded plugins: fastestmirror, kmod
Loading mirror speeds from cached hostfile
 * addons: mirror.yandex.ru
 * base: mirror.corbina.net
 * extras: mirror.corbina.net
 * rpmforge: ftp-stud.fht-esslingen.de
 * updates: mirror.corbina.net
Warning: 3.0.x versions of yum would erroneously match against filenames.
 You can use "*/mysqlclient" and/or "*bin/mysqlclient" to get that behaviour
No Matches found

Код: Выделить всё

[root@localhost log]# yum list available|grep sql
apr-util-mysql.x86_64                   1.2.7-11.el5_5.2        base
asterisk14-addons-mysql.x86_64          1.4.13-1_centos5        asterisk-current
asterisk14-pgsql.x86_64                 1.4.42-1_centos5        asterisk-current
asterisk16-pgsql.x86_64                 1.6.2.20-1_centos5      asterisk-current
asterisk16-sqlite3.x86_64               1.6.2.20-1_centos5      asterisk-current
asterisk18-addons-mysql.x86_64          1.8.5.0-1_centos5       asterisk-current
asterisk18-pgsql.x86_64                 1.8.5.0-1_centos5       asterisk-current
asterisk18-sqlite3.x86_64               1.8.5.0-1_centos5       asterisk-current
bytefx-data-mysql.x86_64                1.2.4-2.el5.centos      extras
cyrus-sasl-sql.i386                     2.1.22-5.el5_4.3        base
cyrus-sasl-sql.x86_64                   2.1.22-5.el5_4.3        base
freeradius-mysql.x86_64                 1.1.3-1.6.el5           base
freeradius-postgresql.x86_64            1.1.3-1.6.el5           base
freeradius2-mysql.x86_64                2.1.7-7.el5             base
freeradius2-postgresql.x86_64           2.1.7-7.el5             base
gtksql.x86_64                           0.4.2-2.2.el5.rf        rpmforge
hsqldb.x86_64                           1:1.8.0.9-1jpp.2        base
hsqldb-demo.x86_64                      1:1.8.0.9-1jpp.2        base
hsqldb-javadoc.x86_64                   1:1.8.0.9-1jpp.2        base
hsqldb-manual.x86_64                    1:1.8.0.9-1jpp.2        base
libdbi-dbd-mysql.x86_64                 0.8.1a-1.2.2            base
libdbi-dbd-pgsql.x86_64                 0.8.1a-1.2.2            base
lighttpd-mod_mysql_vhost.x86_64         1.4.28-2.el5.rf         rpmforge
mod_auth_mysql.x86_64                   1:3.0.0-3.2.el5_3       base
mod_auth_pgsql.x86_64                   2.0.3-2.3.1             base
mod_log_sql.x86_64                      1.100-1.2.el5.rf        rpmforge
mono-data-postgresql.x86_64             1.2.4-2.el5.centos      extras
mono-data-sqlite.x86_64                 1.2.4-2.el5.centos      extras
mysql.i386                              5.0.77-4.el5_6.6        updates
mysql.x86_64                            5.0.77-4.el5_6.6        updates
mysql-bench.x86_64                      5.0.77-4.el5_6.6        updates
mysql-devel.i386                        5.0.77-4.el5_6.6        updates
mysql-devel.x86_64                      5.0.77-4.el5_6.6        updates
mysql-server.x86_64                     5.0.77-4.el5_6.6        updates
mysql-test.x86_64                       5.0.77-4.el5_6.6        updates
openldap-servers-sql.x86_64             2.3.43-12.el5_6.7       updates
pdns-backend-mysql.x86_64               2.9.21-4.el5.centos     extras
pdns-backend-postgresql.x86_64          2.9.21-4.el5.centos     extras
pdns-backend-sqlite.x86_64              2.9.21-4.el5.centos     extras
perl-Class-DBI-mysql.noarch             1.00-1.el5.rf           rpmforge
perl-Qmail-Mysql.noarch                 0.02-1.el5.rf           rpmforge
php-mssql.x86_64                        5.1.6-15.el5.centos.1   extras
php-mysql.x86_64                        5.1.6-27.el5_5.3        base
php-pear-MDB2-Driver-mysql.noarch       1.4.1-3.el5.centos      extras
php-pecl-session_mysql.x86_64           1.9-2.el5.rf            rpmforge
php-pgsql.x86_64                        5.1.6-27.el5_5.3        base
php53-mysql.x86_64                      5.3.3-1.el5_6.1         updates
php53-pgsql.x86_64                      5.3.3-1.el5_6.1         updates
postgresql.x86_64                       8.1.23-1.el5_6.1        updates
postgresql-contrib.x86_64               8.1.23-1.el5_6.1        updates
postgresql-devel.i386                   8.1.23-1.el5_6.1        updates
postgresql-devel.x86_64                 8.1.23-1.el5_6.1        updates
postgresql-docs.x86_64                  8.1.23-1.el5_6.1        updates
postgresql-jdbc.x86_64                  8.1.407-1jpp.4          base
postgresql-libs.i386                    8.1.23-1.el5_6.1        updates
postgresql-libs.x86_64                  8.1.23-1.el5_6.1        updates
postgresql-odbc.x86_64                  08.01.0200-3.1          base
postgresql-pl.x86_64                    8.1.23-1.el5_6.1        updates
postgresql-python.x86_64                8.1.23-1.el5_6.1        updates
postgresql-relay.x86_64                 1.3-2.2.el5.rf          rpmforge
postgresql-server.x86_64                8.1.23-1.el5_6.1        updates
postgresql-tcl.x86_64                   8.1.23-1.el5_6.1        updates
postgresql-test.x86_64                  8.1.23-1.el5_6.1        updates
postgresql84.x86_64                     8.4.7-1.el5_6.1         updates
postgresql84-contrib.x86_64             8.4.7-1.el5_6.1         updates
postgresql84-devel.i386                 8.4.7-1.el5_6.1         updates
postgresql84-devel.x86_64               8.4.7-1.el5_6.1         updates
postgresql84-docs.x86_64                8.4.7-1.el5_6.1         updates
postgresql84-libs.i386                  8.4.7-1.el5_6.1         updates
postgresql84-libs.x86_64                8.4.7-1.el5_6.1         updates
postgresql84-plperl.x86_64              8.4.7-1.el5_6.1         updates
postgresql84-plpython.x86_64            8.4.7-1.el5_6.1         updates
postgresql84-pltcl.x86_64               8.4.7-1.el5_6.1         updates
postgresql84-python.x86_64              8.4.7-1.el5_6.1         updates
postgresql84-server.x86_64              8.4.7-1.el5_6.1         updates
postgresql84-tcl.x86_64                 8.4.7-1.el5_6.1         updates
postgresql84-test.x86_64                8.4.7-1.el5_6.1         updates
proftpd-mysql.x86_64                    1.3.3c-1.el5.rf         rpmforge
proftpd-postgresql.x86_64               1.3.3c-1.el5.rf         rpmforge
python-mssql.x86_64                     0.8.0-1.el5.rf          rpmforge
python-sqlalchemy.noarch                0.3.4-1.el5.rf          rpmforge
python-sqlite2.x86_64                   2.3.3-1.el5.rf          rpmforge
qt4-mysql.x86_64                        4.2.1-1                 base
qt4-postgresql.x86_64                   4.2.1-1                 base
qt4-sqlite.x86_64                       4.2.1-1                 base
rsyslog-mysql.x86_64                    3.22.1-3.el5_6.1        updates
rsyslog-pgsql.x86_64                    3.22.1-3.el5_6.1        updates
shellsql.x86_64                         0.7.3-1.2.el5.rf        rpmforge
sqlite.i386                             3.3.6-5                 base
sqlite-devel.i386                       3.3.6-5                 base
sqlite-devel.x86_64                     3.3.6-5                 base
sqlitemanager.noarch                    1.2.0-1.el5.rf          rpmforge
tedia2sql.noarch                        1.2.12-1.el5.rf         rpmforge

Может обновить mysql на mysql.x86_64 5.0.77-4.el5_6.6

[Vlad1983]

yum install -y mysql-devel

[Parenek]

сделал. но в базу не чего не пишется.
Какие еще будет идеи?
может в /etc/asterisk/modules.conf
внизу написать
load => cdr_addon_mysql.so