Home » Forums » trixbox CE development Forum » General Development

Can't find database documentation

mateuszzz88
Posts: 2
 Member Since:
2010-07-25
Submitted by mateuszzz88 on Sun, 07/25/2010 - 3:09am.

Hello
I'm new both to Asterisk and this forums, so i'm sorry for my probably lame question. I'm developing app to produce reports on trixbox usage and a little more. I plan to read MySQL database (I see no reason to use specific API at the moment, but maybe I'm missing something). Now my question:
where can I find documentation for Trixbox MySQL database structure?
I spent some time on google with little luck (http://www.asterisk.org/docs -> "database use" is surprisingly useless for me..). I figured that most of what I need is in asteriskcdrdb.cdr but probably other tables would be useful for me too, and it's quite a lot of structures to reverse-engineer.
Thanks in advance
Mateusz

‹ IVR hooked to MySQL DB? dial from asterisk using calling card ›


DungeonMaster3000
Posts: 124
 Member Since:
2010-05-21
Not sure but...
Sun, 07/25/2010 - 5:55am

I'd just connect to the trixbox MySQL database with MySQL Workbench and take a look - i'm sure you'll need to browse many times anyway.
http://www.mysql.com/downloads/workbench/



mateuszzz88
Posts: 2
 Member Since:
2010-07-25
hello, thanks for your
Sun, 07/25/2010 - 1:32pm

hello,
thanks for your answer. I already did that, I just hoped for some detailed documentation from devs with field descriptions and allowed values - I'm newbie to this field. Is it avilable anywhere? If not, I guess I'll use what I have ;-)



obeliks
Posts: 878
 Member Since:
2010-03-14
You can check
Sun, 07/25/2010 - 2:16pm

You can check /var/trixbox_load/sql/asteriskcdr.sql to see how the table is created.



Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.