hello all, I am using the msql cdr module to store cdr in db, I realised that it does't capture the start and end time af a particular call record. Therefore I dive into the source code to add the start and end time into the query (add something like cdr->start, cdr->end), but end up getting segfault. the original version of cdr_mysql.so works fine but I need the start time and end time of calling as well. I wonder what would I get with cdr->start? the start time field in my db is of type date or should i use varchar? thanks Foong -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20030804/6f3f2272/attachment.htm
Skipped content of type multipart/alternative-------------- next part -------------- A non-text attachment was scrubbed... Name: cdr_mysql2.c Type: application/octet-stream Size: 5990 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20030804/6f82036f/cdr_mysql2.obj -------------- next part -------------- A non-text attachment was scrubbed... Name: billing.sql Type: application/octet-stream Size: 1132 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20030804/6f82036f/billing.obj
Hi all I just installed the mysql cdr support and my database is not registering the calls :( using show modules i see that the cdr_csv.so and the cdr_addon_mysql.so are loaded It is necessary to unload the cdr_csv.so? how to do it? in crd_mysql.conf i have: [global] hostname=localhost dbname=asteriskcdrdb password=new_password user=asteriskcdruser ;port=3306 ;sock=/tmp/mysql.sock i copied the crd_mysql.conf to the /etc/asterisk directory..it is to be there ..or not? and in modules.conf i have: load => cdr_addon_mysql.so It is correct? something more is needed? ( i created the database and table from wiki instructions) How can i know if asterisk is or not trying to register the calls to the database? Thanks! miklos iPFONE Telefonia IP Rua Caio Graco 735 S?o Paulo SP iPBX +55 11 3801-3702 UK +44 870 - 3403539 FWD 64662 sip:ipfone@sipserver.com.br www.ipfone.com.br info@ipfone.com.br -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20031212/6105eb75/attachment.htm
Hi!> I just installed the mysql cdr support and my database is not registering > the calls :( > > It is necessary to unload the cdr_csv.so? how to do it?No.> [global] > hostname=localhost > dbname=asteriskcdrdb > password=new_password > user=asteriskcdruserMake sure you can connect from the box that runs Asterisk to mySQL: mysql -u asteriskcdruser -p then: use asteriskcdrdb then: explain cdr; If that works ok but you still cannot write to mySQL with Asterisk: use hostname=<fqdn> instead of hostname=localhost also uncomment the port=3306 part> i copied the crd_mysql.conf to the /etc/asterisk directory..it is to be > there ..or not?Yep, but check the name - it is "cdr" not "crd".> How can i know if asterisk is or not trying to register the calls to the > database?Check /var/log/asterisk/messages Hint: You should probably also want to enable the UNIQUEID field Read more at http://www.voip-info.org/wiki-Asterisk+billing and click on the red "comments" tab on the top of the screen, then scroll down. Cheers, Philipp
Were it me, I would see if MySQL is creating the socket where Asterisk expects it. -----Original Message----- From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users-admin@lists.digium.com] On Behalf Of listas iPfone Sent: Friday, December 12, 2003 1:47 PM To: Asterisk-Users@lists.digium.com Subject: [Asterisk-Users] Mysql CDR Hi all I just installed the mysql cdr support and my database is not registering the calls :( using show modules i see that the cdr_csv.so and the cdr_addon_mysql.so are loaded It is necessary to unload the cdr_csv.so? how to do it? in crd_mysql.conf i have: [global] hostname=localhost dbname=asteriskcdrdb password=new_password user=asteriskcdruser ;port=3306 ;sock=/tmp/mysql.sock i copied the crd_mysql.conf to the /etc/asterisk directory..it is to be there ..or not? and in modules.conf i have: load => cdr_addon_mysql.so It is correct? something more is needed? ( i created the database and table from wiki instructions) How can i know if asterisk is or not trying to register the calls to the database? Thanks! miklos iPFONE Telefonia IP Rua Caio Graco 735 S?o Paulo SP iPBX +55 11 3801-3702 UK +44 870 - 3403539 FWD 64662 sip:ipfone@sipserver.com.br www.ipfone.com.br info@ipfone.com.br -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20031212/34e08045/attachment.htm
Hi Miklos, try starting * with -vvvvvvvvvvvc and see if there is any warning also, try connecting to your mysql server by issuing >mysql asteriskcdrdb then> show tables; > select * from cdr;best, PHM -----Original Message----- From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users-admin@lists.digium.com] On Behalf Of listas iPfone Sent: sexta-feira, 12 de dezembro de 2003 16:47 To: Asterisk-Users@lists.digium.com Subject: [Asterisk-Users] Mysql CDR Hi all I just installed the mysql cdr support and my database is not registering the calls :( using show modules i see that the cdr_csv.so and the cdr_addon_mysql.so are loaded It is necessary to unload the cdr_csv.so? how to do it? in crd_mysql.conf i have: [global] hostname=localhost dbname=asteriskcdrdb password=new_password user=asteriskcdruser ;port=3306 ;sock=/tmp/mysql.sock i copied the crd_mysql.conf to the /etc/asterisk directory..it is to be there ..or not? and in modules.conf i have: load => cdr_addon_mysql.so It is correct? something more is needed? ( i created the database and table from wiki instructions) How can i know if asterisk is or not trying to register the calls to the database? Thanks! miklos iPFONE Telefonia IP Rua Caio Graco 735 S?o Paulo SP iPBX +55 11 3801-3702 UK +44 870 - 3403539 FWD 64662 sip:ipfone@sipserver.com.br www.ipfone.com.br info@ipfone.com.br -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20031212/d6b5e58b/attachment.htm
Hi! The line with ;sock=/tmp/mysql.sock, i think you must write it without the ";". You need this socket to connect with mysql. Best regards, Mireia> -----Original Message----- > From: asterisk-users-admin@lists.digium.com > [mailto:asterisk-users-admin@lists.digium.com] On Behalf Of listas > iPfone > Sent: sexta-feira, 12 de dezembro de 2003 16:47 > To: Asterisk-Users@lists.digium.com > Subject: [Asterisk-Users] Mysql CDR > > > Hi all > > I just installed the mysql cdr support and my database is not > registering the calls :( > > using show modules i see that the cdr_csv.so and the cdr_addon_mysql.so > are loaded > > It is necessary to unload the cdr_csv.so? how to do it? > > in crd_mysql.conf i have: > > [global] > hostname=localhost > dbname=asteriskcdrdb > password=new_password > user=asteriskcdruser > ;port=3306 > ;sock=/tmp/mysql.sock > > i copied the crd_mysql.conf to the /etc/asterisk directory..it is to be > there ..or not? > > and in modules.conf i have: > > load => cdr_addon_mysql.so > > It is correct? something more is needed? ( i created the database and > table from wiki instructions) > > How can i know if asterisk is or not trying to register the calls to the > database? > > > > Thanks! > > miklos > > > > iPFONE Telefonia IP > Rua Caio Graco 735 S?o Paulo SP > iPBX +55 11 3801-3702 > UK +44 870 - 3403539 > FWD 64662 > sip:ipfone@sipserver.com.br > www.ipfone.com.br > info@ipfone.com.br > >
Hi, I'm trying to get CDR recording via MySQL working. I've setup my database and compiled the asterisk-addons from cvs and setup the config file, but when i start asterisk i get this: [cdr_addon_mysql.so] => (MySQL CDR Backend) == Parsing '/etc/asterisk/cdr_mysql.conf': Found Apr 8 11:03:59 WARNING[16384]: config.c:551 cfg_process: parse error: No category context for line 15 of cdr_mysql.conf Apr 8 11:03:59 WARNING[16384]: cdr_addon_mysql.c:267 my_load_module: Unable to load config for mysql CDR's: cdr_mysql.conf Does anyone know what this means? -- jeremy bogan [ jeremy@segpub.com.au ] segment publishing - design.develop.host
Sounds like an error in your config file. Want to paste the contents in? Thanks... Sean -----Original Message----- From: Jeremy Bogan [mailto:jeremy@segpub.com.au] Sent: Wednesday, April 07, 2004 8:06 PM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] MySQL CDR Hi, I'm trying to get CDR recording via MySQL working. I've setup my database and compiled the asterisk-addons from cvs and setup the config file, but when i start asterisk i get this: [cdr_addon_mysql.so] => (MySQL CDR Backend) == Parsing '/etc/asterisk/cdr_mysql.conf': Found Apr 8 11:03:59 WARNING[16384]: config.c:551 cfg_process: parse error: No category context for line 15 of cdr_mysql.conf Apr 8 11:03:59 WARNING[16384]: cdr_addon_mysql.c:267 my_load_module: Unable to load config for mysql CDR's: cdr_mysql.conf Does anyone know what this means? -- jeremy bogan [ jeremy@segpub.com.au ] segment publishing - design.develop.host _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
> Sounds like an error in your config file. Want to paste the contents > in? Thanks...Sorry: ;[global] ;hostname=localhost dbname=asterisk password=<password> user=asterisk ;port=3306 sock=/tmp/mysql.sock userfield=1 -- jeremy bogan [ jeremy@segpub.com.au ] segment publishing - design.develop.host
Remove the semi-colon in front of "[global]" HTH, Ryan Thrash On Apr 7, 2004, at 8:15 PM, Jeremy Bogan wrote:>> Sounds like an error in your config file. Want to paste the contents >> in? Thanks... > > Sorry: > > ;[global] > ;hostname=localhost > dbname=asterisk > password=<password> > user=asterisk > ;port=3306 > sock=/tmp/mysql.sock > userfield=1 > > -- > jeremy bogan [ jeremy@segpub.com.au ] > segment publishing - design.develop.host > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
I am looking for a ISDN BRI card (u-INTERFACE) to connect * to a US 5ESS switch (Qwest). According to Qwest they support CNAME delivery on their 5ESS switches. Does * chan_capi support CNAME ? Regards. Alfred.
Hi, I can?t do a registry into Mysql database. When the call finished I received : ERROR : FAILED TO INSERT INTO DATABASE. I change many things but I did not obtain the problem resolution. Somebody can help me ? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050521/337a6596/attachment.htm
Hi, When I finished a call, the asterisk give a message : FAILED TO INSERT INTO DATABASE. I changed table in data base, change de Makefile file located in asterisk-addon and nothing it functioned. Somebody can help me ? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050521/98d614d6/attachment.htm
Hi everyone, I finished installing the Xorcom Rapid's Asterisk Packages with amportal (1.10.10), but i wasn't able to find the asterisk-mysql package. Any idea what happened there?, Is there another reposiitory for that package for asterisk 1.0.11. Or could somebody send me the cdr_addon_mysql.so file? Thanks for your responses, -- Diego Quintana a.k.a. RouterMaN Ingenier?a de las Telecomunicaciones PUCP Linux Registered User #382615 - http://counter.li.org/ SIP # 1-747-633-6676 Ext. 1011 FWD # 764839 Ext. 1011 http://routerman.blogsome.com http://planeta.debianperu.org