Hi people! i'm trying to work together the cdr with mysql. MySQL works on a windows machine, it seems ok but when i hangup with the sip phone, * write: Failed to insert into database. I have tryed to insert manually some values into the table and after i have seen that values in a php web page, and the sql server accept the incoming calls and display it properly. With MySQL Administrator i see the *'s pid The cdr table is the same reported in Wiki's link. where is the problem? Sorry for the non perfect english thanks to all Walter
Eng. Vanzetti Walter schrieb: ...> The cdr table is the same reported in Wiki's link. > where is the problem?. ... Hi, when everthing is according to the Wiki's mysql_cdr pages, it should work. Please check permissions! (Insert permission granted to the user as defined in cdr_mysql.conf? Even if other host, respectively even if same host? Did you realize, that host '%' does not include localhost in mysql?) Roger.
Hi Roger! the databse i have created has all the immaginable permission.....if i try to access it with dbtools with the username and the password of asterisk from another pc inside the network, i can see the table and i can read/write. Only * can't write into the table. So,cecking the conf file and the username, password and domain are ok. Need to configure other modules?or the information passed by sip are incorrect? I use a budgettone grand stream and msn client it make me crazy.... regards Walter> Hi, > > when everthing is according to the Wiki's mysql_cdr pages, > it should work. > > Please check permissions! > (Insert permission granted to the user as defined in > cdr_mysql.conf? Even if other host, respectively even > if same host? Did you realize, that host '%' does not > include localhost in mysql?) > > > Roger.