[VoIP] AstLinux MySQL?

[Lee Spenadel]

I'm no guru in this, but in the Asterisk res_mysql.conf and cdr.mysql.conf
files, can't you merely specify the IP address of the box running mysql?  It
seems that any mysql box could be used so long as the configurations in
those two files match the mysql accounts on the target server.

For example (cdr_mysql.conf):

[global]
hostname=166.77.201.20  - YOU WOULD MAKE THIS THE IP ADDRESS OF THE TARGET
SERVER
dbname=cdr
user=asterisk
password=
port=3306
sock=/var/lib/mysql/mysql.sock
;userfield=1


Res_mysql.conf:

[general]
dbhost=166.77.201.20 - - YOU WOULD MAKE THIS THE IP ADDRESS OF THE TARGET
SERVER
dbname=cdr
table=cdr
dbuser=asterisk
dbpass= 
dbport=3306
dbsock=/var/lib/mysql/mysql.sock


Hope this helps.
Lee

-----Original Message-----
From: voip-bounces at ckts.info [mailto:voip-bounces at ckts.info] On Behalf Of
Mad Mark
Sent: Monday, February 11, 2008 6:49 AM
To: voip at ckts.info
Subject: [VoIP] AstLinux MySQL?


I hear things about how Asterisk can send call logs to a MySQL database. How
would you set this up on AstLinux? I have another machine on my network
running MySQL and would like AstLinux to write all call logs to this
database, rather than the local CF card. Is this possible, or would it be
incompatible? I have 10 Mb free space on the sys drive.

_________________________________________________________________
It's simple! Sell your car for just $30 at CarPoint.com.au
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2
Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fa
i%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT
_______________________________________________
VoIP mailing list
VoIP at ckts.info
http://lists.ckts.info/mailman/listinfo/voip
Project Web Page: http://www.ckts.info/