CDR in a different server

I want to move my CDR in another server. So I modified cdr_mysql.conf and res_mysql.conf
And I have already create the database and the table cdr !

this is my res_mysql.conf
; Sample configuration for res_config_mysql.c
; The value of dbhost may be either a hostname or an IP address.
; If dbhost is commented out or the string “localhost”, a connection
; to the local host is assumed and dbsock is used instead of TCP/IP
; to connect to the server.
dbhost =
dbname = asterisk
dbuser = root
dbpass =
;dbport = 3306
dbsock = /var/lib/mysql/mysql.sock[/color]

this is my cdr_mysql.conf

; Note - if the database server is hosted on the same machine as the
; asterisk server, you can achieve a local Unix socket connection by
; setting hostname=localhost
; port and sock are both optional parameters. If hostname is specified
; and is not “localhost”, then cdr_mysql will attempt to connect to the
; port specified or use the default port. If hostname is not specified
; or if hostname is “localhost”, then cdr_mysql will attempt to connect
; to the socket file specified by sock or otherwise use the default socket
; file.

Any ideas ?

I assume it doesn’t work (not clear since you never actually said so.) Any information in logfiles or anything? You didn’t provide much info :frowning:

I have problem to connect to the distant server
I got this :

*CLI> realtime mysql status
Apr 19 17:29:11 ERROR[13107]: res_config_mysql.c:615 mysql_reconnect: MySQL RealTime: Failed to connect database server asterisk on Check debug for more info.[/color]

[] => (MySQL CDR Backend)
== Parsing ‘/etc/asterisk/cdr_mysql.conf’: Found
Apr 19 17:35:24 ERROR[13256]: cdr_addon_mysql.c:437 my_load_module: Failed to connect to mysql database asterisk on[/color]

I check the username, password, the adress but nothing to solve this problem.
Any propositions?

I found the solution. :laughing:
I deleted the database in the distant server and I ceate a new database ; but I indicated that the user of the database in the distant server will be the root of the serveur where I have asterisk.

[color=green]GRANT INSERT
ON asterisk.*
IDENTIFIED BY ‘yourpassword’; [/color]

thanks a lot !