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)
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.
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
