diff options
author | russell <russell@f38db490-d61c-443f-a65b-d21fe96a405b> | 2007-01-30 23:30:59 +0000 |
---|---|---|
committer | russell <russell@f38db490-d61c-443f-a65b-d21fe96a405b> | 2007-01-30 23:30:59 +0000 |
commit | f1094c7e8f32dd745170b72ef804a78f9a6566e1 (patch) | |
tree | 2b0b225e1c9109d18b46b8e314f6bdc28d14916e /doc | |
parent | 137db7490c7b03f8ec778e4796db7bbeac77b6bb (diff) |
Merged revisions 52999 via svnmerge from
https://origsvn.digium.com/svn/asterisk/branches/1.4
........
r52999 | russell | 2007-01-30 17:30:34 -0600 (Tue, 30 Jan 2007) | 2 lines
Add documentation for using cdr_pgsql. (issue #8942, lters)
........
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@53000 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'doc')
-rw-r--r-- | doc/cdrdriver.txt | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/doc/cdrdriver.txt b/doc/cdrdriver.txt index 9bc6fa102..8a7e2e328 100644 --- a/doc/cdrdriver.txt +++ b/doc/cdrdriver.txt @@ -160,10 +160,56 @@ MSSQL: Asterisk can currently store CDRs into an MSSQL database in logs a connection to the database and will now record every call to the database when it's complete. + MYSQL: + PGSQL: + If you want to go directly to postgresql database, and have the cdr_pgsql.so + compiled you can use the following sample setup. + On Debian, before compiling asterisk, just install libpqxx-dev. + Other distros will likely have a similiar package. + + Once you have the compile done, + copy the sample cdr_pgsql.conf file or create your own. + + Here is a sample: + + /etc/asterisk/cdr_pgsql.conf + ; Sample Asterisk config file for CDR logging to PostgresSQL + [global] + hostname=localhost + port=5432 + dbname=asterisk + password=password + user=postgres + table=cdr + + ;Now create a table in postgresql for your cdrs + + ;SQL table where CDRs will be inserted + ;Copy and paste this into your postgresql prompt. + CREATE TABLE cdr ( + calldate time NOT NULL , + clid varchar (80) NOT NULL , + src varchar (80) NOT NULL , + dst varchar (80) NOT NULL , + dcontext varchar (80) NOT NULL , + channel varchar (80) NOT NULL , + dstchannel varchar (80) NOT NULL , + lastapp varchar (80) NOT NULL , + lastdata varchar (80) NOT NULL , + duration int NOT NULL , + billsec int NOT NULL , + disposition varchar (45) NOT NULL , + amaflags int NOT NULL , + accountcode varchar (20) NOT NULL , + uniqueid varchar (32) NOT NULL , + userfield varchar (255) NOT NULL + ); + SQLLITE: + RADIUS: See doc/radius.txt for more information on cdr_radius |