[VoIP] AstLinux MySQL?

[Mad Mark]

I see some stuff relating to MySQL, but it wants to be configured by a DSN, not hostname/dbname. Also, I don't see a libmysql module in /usr/lib

> From: spenadel at gmail.com
> To: voip at ckts.info
> Date: Mon, 11 Feb 2008 07:57:14 -0500
> Subject: Re: [VoIP] AstLinux MySQL?
> 
> 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/
> 
> _______________________________________________
> VoIP mailing list
> VoIP at ckts.info
> http://lists.ckts.info/mailman/listinfo/voip
> Project Web Page: http://www.ckts.info/

_________________________________________________________________
What are you waiting for? Join Lavalife FREE
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Flavalife9%2Eninemsn%2Ecom%2Eau%2Fclickthru%2Fclickthru%2Eact%3Fid%3Dninemsn%26context%3Dan99%26locale%3Den%5FAU%26a%3D30288&_t=764581033&_r=email_taglines_Join_free_OCT07&_m=EXT