Hi
You have to follow this steps and obviously you got success because we have followed
this steps and got success.
Configure the cdr_mysql.conf file in the location /etc/asterisk. The configuration is
as follows:
[global]
hostname=localhost ;This is the host name of MySql
dbname=asteriskcdrdb ;This is the database name of MySql
password=password ;This is the password of user
user=asteriskcdruser ;This is the user in MySql
port=3306 ;This is the port number running the MySql
sock=/var/lib/mysql/mysql.sock ;This is the socket of MySql and the location
Then follow the steps in the MySql server
1. Go to Start Application>>System>>Service Configuration. Check the mysqld box. Click
the save button
Then click the start button.
2. Open a kolsole.
3. Type: "mysql -u root" to enter into mysql.
4. Type: "SET PASSWORD FOR root = PASSWORD("password");" for setting the root password.
5. Type: "GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY "password"
WITH GRANT OPTION;"
6. Type: "\q;" to Quit mysql.
7. Type: In konsole "mysql -u asteriskcdruser -p" and use the password "password",
to reenter mysql as "asteriskcdruser" user.
8. Type: "CREATE DATABASE asteriskcdrdb;"
9. Type:
"CREATE TABLE cdr (
calldate datetime NOT NULL default '0000-00-00 00:00:00',
clid varchar(45) NOT NULL default '',
src varchar(45) NOT NULL default '',
dst varchar(45) NOT NULL default '',
dcontext varchar(45) NOT NULL default '',
channel varchar(45) NOT NULL default '',
dstchannel varchar(45) NOT NULL default '',
lastapp varchar(45) NOT NULL default '',
lastdata varchar(45) NOT NULL default '',
duration int(11) NOT NULL default '0',
billsec int(11) NOT NULL default '0',
disposition varchar(45) NOT NULL default '',
amaflags int(11) NOT NULL default '0',
accountcode varchar(45) NOT NULL default '',
uniqueid varchar(45) NOT NULL default ''
);"
for create a table "cdr".
10. To reload the configuration, type reload from the Asterisk command prompt.
These are the steps of Configuration of MySql with Asterisk server. Contact me if you
need any further clarifications.
Dipak Kumar Paul.
Sigmabit Technology India.
[EMAIL PROTECTED] wrote:
Hi, here it is...
[EMAIL PROTECTED] asterisk]# cat 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.
;
[global]
hostname=localhost
dbname=asteriskcdrdb
password=******
user=asteriskcdruser
;port=3306
;sock=/tmp/mysql.sock
sock=/var/lib/mysql/mysql.sock
srwxrwxrwx 1 mysql mysql 0 Feb 2 19:37
/var/lib/mysql/mysql.sock
Tomica
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tilghman
Lesher
Sent: Tuesday, February 03, 2004 12:32 AM
To: [EMAIL PROTECTED]
Subject: Re: [Asterisk-Users] cdr mysql problem
On Monday 02 February 2004 15:27, Tomica Crnek wrote:
> Yes, I have checked the logs. There is nothing there. I think asterisk
> doesn't try to connect.
Please paste the contents of /etc/asterisk/cdr_mysql.conf. Also, paste
the output of:
ls -l /tmp/mysql.sock /var/lib/mysql/mysql.sock ; locate mysql.sock
-Tilghman
_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com
Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com
Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to
http://airsahara.indiatimes.com and Bid Now!
_______________________________________________
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
