Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 302681 - net-misc/asterisk-addons-1.6.1: unable to store cdr to mysql DB with
Summary: net-misc/asterisk-addons-1.6.1: unable to store cdr to mysql DB with
Status: VERIFIED NEEDINFO
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High normal (vote)
Assignee: Tony Vroon
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-01-28 19:02 UTC by tomasz
Modified: 2010-02-09 16:54 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description tomasz 2010-01-28 19:02:28 UTC
After succesfully installation of additional asterisk components(asterisk-addons-1.6.1) I can see:linux-1i0f*CLI> realtime mysql status
general connected to asteriskcdrdb@127.0.0.1, port 3306 with username asteriskuser for 0 seconds.
linux-1i0f*CLI>module show like sql cdr_addon_mysql.so,res_config_mysql.s,app_addon_sql_mysql.so, but:cdr show status  Logging:                    Enabled
  Mode:                       Simple
  Log unanswered calls:       No

* Registered Backends
  -------------------
    cdr-custom
    csv
and: 
ls -ltr -rw-r--r-- 1 root root   195 Jan 28 18:01 cdr_mysql.conf
vim cdr_mysql.conf 
[globals]
hostname=localhost
;dbname=asterisk
password=asterisk
;user=asterisk
table=cdr
;port=3306
;userfield=1
;sock=/var/lib/mysql/mysql.sock
dbname=asteriskcdrdb
user=asteriskuser
;user=root



 

Reproducible: Always




[Jan 28 18:57:26] ERROR[28468] codec_dahdi.c: Failed to open /dev/dahdi/transcode: No such file or directory
[Jan 28 18:57:26] WARNING[28468] res_config_mysql.c: MySQL realtime: no requirements setting found, using 'warn' as default.
[Jan 28 18:57:26] NOTICE[28468] config.c: Registered Config Engine mysql
[Jan 28 18:57:26] NOTICE[28468] pbx_ael.c: Starting AEL load process.

mysql> SELECT host,user,password,Grant_priv from mysql.user;
+------------+--------------+-------------------------------------------+------------+
| host       | user         | password                                  | Grant_priv |
+------------+--------------+-------------------------------------------+------------+
| localhost  | root         |                                           | Y          | 
| linux-1i0f | root         |                                           | Y          | 
| 127.0.0.1  | root         |                                           | Y          | 
| localhost  |              |                                           | N          | 
| linux-1i0f |              |                                           | N          | 
| localhost  | asterisk     | *7C99FE2524A21E88E9DBE310DB2F754773BF383E | N          | 
| localhost  | asteriskuser | *7C99FE2524A21E88E9DBE310DB2F754773BF383E | N          | 
+------------+--------------+-------------------------------------------+------------+

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

mysql> show tables;
+-------------------------+
| Tables_in_asteriskcdrdb |
+-------------------------+
| cdr                     | 
+-------------------------+
1 row in set (0.01 sec)
Comment 1 Tony Vroon gentoo-dev 2010-01-29 21:38:19 UTC
emerge --info really would be the bare minimum I could work with here. Please include:
emerge -pv asterisk asterisk-addons

Try:
core set debug 10
core set verbose 10

Make a few test calls and check for error messages. If so, please attach the relevant log file.
Comment 2 tomasz 2010-02-09 16:54:46 UTC
Hello, I found the problem. It was my mistake with letters. I wrote:

vim cdr_mysql.conf 
[globals]
hostname=localhost


and it should be:
vim cdr_mysql.conf 
[global]
hostname=localhost

without "s"

Regards
swider