[VoIP] AstLinux MySQL?

[John Novack]

I don't believe the distribution has the MySQL add on compiled into it.

Making a version of AstLinux from source can be done on a development 
system, but how that is done is far above my level of understanding.
Many of the users on the AstLinux users list are doing similar things, 
but it just makes my head swim.
AstLinux does generate a log file of calls, and I suppose one could 
write a script to export those to another machine.
The original concept of AstLinux was a small packaged system equipped 
with the most often used features to run on a minimal piece of hardware.
It does a nice job of that.

John Novack


Mad Mark wrote:
> 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
> _______________________________________________
> VoIP mailing list
> VoIP at ckts.info
> http://lists.ckts.info/mailman/listinfo/voip
> Project Web Page: http://www.ckts.info/
>
>   

-- 
Dog is my co-pilot