[Asterisk-Users] cdr mysql problem

[Tilghman Lesher]

On Tuesday 03 February 2004 01:44, Tomica Crnek wrote:
> [global]
> hostname=localhost
> dbname=asteriskcdrdb
> password=******
> user=asteriskcdruser
> ;port=3306
> ;sock=/tmp/mysql.sock
> sock=/var/lib/mysql/mysql.sock

Okay, and so does this work?

bash$ echo "select max(calldate) from cdr;" | \
> mysql -uasteriskcdruser -S/var/lib/mysql/mysql.sock \
> -p asteriskcdrdb
Enter password:
max(calldate)
2004-02-02 19:19:22
bash$

-Tilghman