RES: [Asterisk-Users] Mysql CDR

[Rodrigo Otavio de Fraga]

I used the exemple listed in voip-info, but this list is wrong.

I run de debug and I find de correct table, the error was in INSERT
mysql command.

Now all is function.

-----Mensagem original-----
De: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] Em nome de Matt Riddell
Enviada em: domingo, 22 de maio de 2005 00:28
Para: Asterisk Users Mailing List - Non-Commercial Discussion
Assunto: Re: [Asterisk-Users] Mysql CDR

Rodrigo Otavio de Fraga wrote:
> Hi,
> When I finished a call, the asterisk give a message : FAILED TO INSERT

> INTO DATABASE.

Make sure that the details inside cdr_mysql.conf are correct.

I.E. if it has username bob, password fred, host 127.0.0.1, run mysql -u

bob -p

Then it will ask you for a password.

Type fred (or whatever your password is).

Then it should connect (if the user/pass is in the db).

If you then type use cdr (where cdr is the name of your cdr database) it

should work.

So, if you go through these steps, you should be able to find out where 
the problem is.

(BTW: you did create the tables didn't you?)

:)

-- 
Cheers,

Matt Riddell
_______________________________________________

http://www.sineapps.com/news.php (Daily Asterisk News - html)
http://www.sineapps.com/rssfeed.php (Daily Asterisk News - rss)
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users at 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