|
Sorry Jan,
The following adjustment also should have
been done.
- "into" should be changed
to "int" in "call_number into
zerofill," line of the CDR table structure.
With all these adjustments everybody could
just copy and paste the content to have it all without any
hassle.
Thanks again.
Bahram.
----- Original Message -----
Sent: Tuesday, September 13, 2005 2:36
PM
Subject: Re: Mysql
Schemes
Jan,
Thank you for adding this
information into the CVS manual in benefit of everybody.
I just noticed that some of the "GNUGK"
terms in the content of my email had been changed to "GUNK" by mistake
probably during the spell check. It seems you also
noticed it but corrected it to GUNGK instead of GNUGK.
Would you please change these all back to
"GNUGK" again to have a consistent document for everybody because later in the
content of the [SQLAcct] settings the GNUGK is written as the name
of the database. Please just run a quick replace for replacing all
the "GUNGK" to "GNUGK".
I'd really appreciate
it.
Regards,
Bahram.
----- Original Message -----
Sent: Tuesday, September 13, 2005 3:36
AM
Subject: Re: Mysql
Schemes
Thanks Bahram,
I copied this to the CVS manual and
edited out a few typos etc. (HTML
version attached). It would be nice if
somebody could actually run this
in a sample setup and make sure there
are no typos left.
Having the same for authentication would also be
nice. ;-)
Regards,
Jan
Bahram S. Biria wrote:
>
Lucas,
>
> I had the same problem awhile ago and could find
nothing on it.
Consequently I did it myself. Here is what I did. Hope it
helps you and
anyone else who is (and will be) looking for something like
these.
>
> What I did was creating a new database in the name
of GUNK. You can do
it using the following command in myself
environment.
>
> create database GUNK;
>
> Then I
created a table in the name of CDR as follows.
>
> create table
GUNK.CDR (
>
gatekeeper_name
archer(255),
>
call_number into
zerofill,
>
call_duration mediumint unsigned
zerofill,
>
index duration_idx
(call_duration),
>
disconnect_cause smallint unsigned
zerofill,
>
index dcc_idx
(disconnect_cause),
>
acct_session_id
varchar(255),
>
h323_id
varchar(255),
> gkip
varchar(15),
> CallId
varchar(255),
> ConfID
varchar(255),
>
setup_time datetime,
>
connect_time
datetime,
>
disconnect_time
datetime,
> caller_ip
varchar(15),
>
index srcip_idx
(caller_ip),
>
caller_port smallint unsigned
zerofill,
> callee_ip
varchar(15),
>
index destip_idx
(callee_ip),
>
callee_port smallint unsigned
zerofill,
> src_info
varchar(255),
>
dest_info
varchar(255),
>
Calling_Station_Id
varchar(255),
>
Called_Station_Id
varchar(255),
>
index dialednumber_idx (Called_Station_Id
(20)),
> Dialed_Number
varchar(255)
> );
>
>
> You can copy and paste it
in the mysql environment.
>
> Then you need to creat a username
for accessing the data. You can do
it throught the following command in
mysql environment.
>
> GRANT delete,insert,select,update ON
GNUGK.* TO
'YourDesireUsername'@'localhost' IDENTIFIED BY
'APassword';
>
> With this command you will permit accessing
the data from only the
local server. If you need to access these data
from any other computer
then you have to set the proper security
options.
>
> Then you can add the following settings ( at the
bottom of this email)
into your gnugk.ini file to insert and update the
history of the calls
into your database.
>
> Please note
the fields that I used were based on version 2.2.1 and I
beleive there
are more available data to keep in the latest version
(2.2.3-2) which I
haven't added them yet for myself. By the way, I used
the same
definitions with the latest version and it worked fine. Please
add the
new data fields yourself if you think you need them to keep.
>
> Hope these save a little bit of time for you and whomever who
will
possibly use these later.
>
> Good luck,
>
Bahram.
>
> P.S. I guess it would have been helpful if
something like this was
included in the original manual of the GNUGK to
save some time for the
people who are looking for something as a
startup.
>
>
> [Gatekeeper::Acct]
>
SQLAcct=optional;start,stop,update
> FileAcct=sufficient;stop
>
> [FileAcct]
> DetailFile=Add your desire path here something
like /var/log/cdr.log
>
StandardCDRFormat=0
>
CDRString=%g|%n|%d|%c|%s|%u|%{gkip}|%{CallId}|%{ConfId}|%{setup-time}|%
{connect-time}|%{disconnect-time}|%{caller-ip}|%{caller-port}|%{callee-
ip}|%{callee-port}|%{src-info}|%{dest-info}|%{Calling-Station-Id}|%{Cal
led-Station-Id}|%{Dialed-Number}
>
Rotate=daily
> RotateTime=23:59
>
>
>
[SQLAcct]
> Driver=MySQL
> Database=GNUGK
>
Username=YourDesireUsername
> Password=APassword
> StartQuery=
insert into CDR (gatekeeper_name, call_number,
call_duration,
disconnect_cause, acct_session_id, h323_id, gkip, CallId,
ConfId,
setup_time, connect_time, disconnect_time, caller_ip,
caller_port,
callee_ip, callee_port, src_info, dest_info,
Calling_Station_Id,
Called_Station_Id, Dialed_Number) values ('%g',
'%n', %d, %c, '%s', '%u',
'%{gkip}', '%{CallId}', '%{ConfId}',
'%{setup-time}', '%{connect-time}',
'%{disconnect-time}',
'%{caller-ip}', '%{caller-port}', '%{callee-ip}',
'%{callee-port}',
'%{src-info}', '%{dest-info}',
'%{Calling-Station-Id}',
'%{Called-Station-Id}',
'%{Dialed-Number}')
>
> StartQueryAlt= insert into CDR
(gatekeeper_name, call_number,
call_duration, disconnect_cause,
acct_session_id, h323_id, gkip, CallId,
ConfID, setup_time, connect_time,
disconnect_time, caller_ip,
caller_port, callee_ip, callee_port,
src_info, dest_info,
Calling_Station_Id, Called_Station_Id,
Dialed_Number) values ('%g',
'%n', %d, %c, '%s', '%u', '%{gkip}',
'%{CallId}', '%{ConfID}',
'%{setup-time}', '%{connect-time}',
'%{disconnect-time}',
'%{caller-ip}', '%{caller-port}', '%{callee-ip}',
'%{callee-port}',
'%{src-info}', '%{dest-info}',
'%{Calling-Station-Id}',
'%{Called-Station-Id}',
'%{Dialed-Number}')
>
> UpdateQuery= update CDR set
call_duration=%d where
gatekeeper_name='%g' and
acct_session_id='%s'
>
> StopQuery= update CDR set
call_duration=%d,
disconnect_cause=%c,
disconnect_time='%{disconnect-time}' where
gatekeeper_name='%g' and
acct_session_id='%s'
>
>
StopQueryAlt= insert into CDR (gatekeeper_name,
call_number,
call_duration, disconnect_cause, acct_session_id, h323_id,
gkip, CallId,
ConfID, setup_time, connect_time, disconnect_time,
caller_ip,
caller_port, callee_ip, callee_port, src_info,
dest_info,
Calling_Station_Id, Called_Station_Id, Dialed_Number) values
('%g STOP
Alt', '%n', %d, %c, '%s', '%u', '%{gkip}', '%{CallId}',
'%{ConfID}',
'%{setup-time}', '%{connect-time}',
'%{disconnect-time}',
'%{caller-ip}', '%{caller-port}', '%{callee-ip}',
'%{callee-port}',
'%{src-info}', '%{dest-info}',
'%{Calling-Station-Id}',
'%{Called-Station-Id}',
'%{Dialed-Number}')
>
> TimestampFormat=MySQL
>
>
>
>
>
> ----- Original Message -----
> From: Lucas Nishimura
> To:
openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
> Sent: Sunday,
September 11, 2005 5:24 PM
> Subject:
Mysql Schemes
>
>
> Hi
All,
> I'm Trying to configure GNUGK with mysql but i cant
find the
database schemes could anyone help?
>
>
--
> Lucas Nishimura
>
-----------------------------------------------------------------------
---------
> Tel: (43)9911-3440
> Email:
lucas.nishimura@xxxxxxxxxx
> GVT - LONDRINA - PR
>
-----------------------------------------------------------------------
---------
>
>
--
Jan Willamowius,
jan@xxxxxxxxxxxxxx,
http://www.gnugk.org/
|
