http://bugzilla.novell.com/show_bug.cgi?id=574936 http://bugzilla.novell.com/show_bug.cgi?id=574936#c0 Summary: I can't store CDRs in mySQL DB using Asterisk asterisk-addons-1.6.1 package Classification: openSUSE Product: openSUSE 11.1 Version: Final Platform: i586 OS/Version: openSUSE 11.1 Status: NEW Severity: Major Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: tswiderski@op.pl QAContact: qa@suse.de Found By: Other Blocker: No After installing asterisk-addons-1.6.1 opackage and compilling witjout errors I have problems with storing CDRs to mySQL DB. +---- Asterisk-Addons Installation Complete ----+ + + + Addons has successfully been installed. + + If you would like to install the sample + + configuration files (overwriting any + + existing config files), run: + + + + make samples + +-----------------------------------------------+ The modules were correctly loaded: linux-1i0f*CLI> module show like sql Module Description Use Count cdr_addon_mysql.so MySQL CDR Backend 0 res_config_mysql.so MySQL RealTime Configuration Driver 0 app_addon_sql_mysql.so Simple Mysql Interface 0 3 modules loaded linux-1i0f*CLI> cdr mysql status No such command 'cdr mysql status' (type 'help cdr mysql status' for other possible commands) linux-1i0f*CLI> realtime mysql status general connected to asteriskcdrdb@127.0.0.1, port 3306 with username asteriskuser for 0 seconds. **************************************** But mysql DB wasn't connected as place for storing CDRs: **************************************** linux-1i0f*CLI> cdr show status linux-1i0f*CLI> Call Detail Record (CDR) settings ---------------------------------- Logging: Enabled Mode: Simple Log unanswered calls: No * Registered Backends ------------------- cdr-custom csv linux-1i0f*CLI> ***************************************** DB is created properly: mysql> show databases; Current database: asteriskcdrdb +--------------------+ | Database | +--------------------+ | information_schema | | asterisk | | asteriskcdrdb | | mysql | | test | +--------------------+ 5 rows in set (0.00 sec) 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) mysql> ****************************** And the config file: ****************************** 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 ls -ltr -rw-r--r-- 1 root root 1766 Jan 28 13:11 cdr_mysql.conf.orig -rw-r--r-- 1 root root 1880 Jan 28 16:11 res_mysql.conf -rw-r--r-- 1 root root 195 Jan 28 18:01 cdr_mysql.conf ~ -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.