[asterisk-bugs] [JIRA] (ASTERISK-15540) I can't store CDRs in mysql DB

[Joshua Colp (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-15540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joshua Colp closed ASTERISK-15540.
----------------------------------


> I can't store CDRs in mysql DB
> ------------------------------
>
>                 Key: ASTERISK-15540
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-15540
>             Project: Asterisk
>          Issue Type: Bug
>          Components: Addons/General
>            Reporter: swider
>
> I installed asterisk-addons-1.6.1 and didn't find any errors during compilation. I created mysql db, modules were loaded but I can't still load cdrs to my new my sql DB:
>  +----	 Asterisk-Addons Build Complete ----+
>  +                                           +
>  +   Addons has successfully been built .    +
>  +   If you would like to install it :       +
>  +                                           +
>  +                make install               +
>  +-------------------------------------------+
> 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 at 127.0.0.1, port 3306 with username asteriskuser for 0 seconds.
> 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> 
> ****** ADDITIONAL INFORMATION ******
> 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
> 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> 



--
This message was sent by Atlassian JIRA
(v6.2#6252)