CDR in a different server


#1

Hi,
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
[color=green]
;
; 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.
;
[general]
dbhost = 194.98.xxx.xxx
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.
;
[color=green][global]
hostname=194.98.xxx.xxx
dbname=asterisk
table=cdr
password=
user=root
;port=3306
sock=/var/lib/mysql/mysql.sock
;userfield=1[/color]

Any ideas ?
Thanks
Aicha


#2

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:


#3

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

[color=green]*CLI>
*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 194.98.xxx.xxx Check debug for more info.[/color]
[color=brown]

[cdr_addon_mysql.so] => (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 194.98.xxx.xxx.[/color]

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


#4

hi
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.*
TO root@194.98.xxx.xxx
IDENTIFIED BY ‘yourpassword’; [/color]

thanks a lot !
Aicha