hello friend,
my o.s is redhat linux 9.0
and ser is stable cvs version (ser 0.8.12-tcp_nonb)
i have the free radius server -0.9.3
this server is integrated to the ser
my cdr tool of 1.0.4 version
iam following steps given in INSTALL
i created the databases as given in the INSTALL
but i could not able to find this db_mysql.sql in
/usr/share/doc/freeradius/examples/db_mysql.sql
so how to proceed from here
has any body got success with cdrtool with ser?
kindly help me
with regards
rama kanth
--- Adrian Georgescu <ag(a)ag-projects.com> wrote:
On Jun 4, 2004, at 8:21 AM, varala ramakanth wrote:
Adrian,
as you told me i am using now 1.0.4.
and created the database succesfully
mines is redhat linux 9.0 and ser as sip server
the mysql-3.23.54a-11 and php-4.2.2-17
i have not changed the DATASOURCES in global.inc
you have to
i have not changed the php setup
you have to
iam not using any radius as of now
it does not work with a radius server and correct
radius accounting of
ser
iam not using any mediaproxy as of now
is ok just don't expect Network traffic, User agent
or Codec type
information
i copied setrace.py
cp scripts/sertrace.py
/usr/local/etc/ser/sertrace.py
Edit the file for your DB connection
and i included this statement in ser.cfg
if (method=="REGISTER" || method=="INVITE" ||
method=="BYE" || method=="CANCEL") {
# save messages in mysql for CDRTool
exec_msg("/etc/ser/sertrace.py; exit 1");
};
so when i run the ser its giveng error like this
Some SER module is missing from your config.
0(1403) find_export: <exec_msg> not found
0(1403) find_export: <exec_msg> not found
0(1403) parse error (180,44-45): unknown command,
missing loadmodule?
and shutting down
ERROR: bad config file (1 errors)
0(1403) DEBUG: tm_shutdown : start
0(1403) DEBUG: tm_shutdown : empting hash table
0(1403) DEBUG: tm_shutdown: releasing timers
0(1403) DEBUG: tm_shutdown : removing semaphores
0(1403) DEBUG: tm_shutdown : done
0(1403) shm_mem_destroy
0(1403) destroying the shared memory lock
one other new bie question after setting up
everything
where can i see the call data records i could not
able
http://IP/CDRTool
> to see that information in the INSTALL file .
> so how to proceed from here please
guide me
> with regards
> rama kanth
> --- Adrian Georgescu <ag(a)ag-projects.com> wrote:
>> Varala,
>>
>> Please download 1.0.4 these problems have been
>> corrected there.
>>
>> Adrian
>>
>> On Jun 3, 2004, at 10:54 AM, varala ramakanth
wrote:
>
>> hello adrian,
>>
>> now if i execute ./setup_mysql.sh i get this
error
>>> [root@server mysql]# ./setup_mysql.sh
>>> ERROR 1136 at line 4: Column count doesn't match
>> value
>>> count at row 1
>>>
>>> at line 4 i have
>>>
>>>
>>>
>>>
>>> i have checked the cdrtools database and
>> destinations
>>>
>>> table in that i have seen that
>>>
>>> we have only four fields
>>>
>>> mysql> desc destinations
>>> -> ;
>>>
>>
+-----------+---------------------+------+-----+---------
+----------------+
| Field | Type | Null | Key |
Default | Extra |
+-----------+---------------------+------+-----+---------
+----------------+
| id | bigint(20) unsigned | | PRI |
NULL
| auto_increment |
| dest_id | varchar(25) | | MUL |
| |
| dest_name | varchar(255) | | |
| |
| language | char(2) | | |
NL
| |
+-----------+---------------------+------+-----+---------
>
>> +----------------+
>> 4 rows in set (0.00 sec)
>>
>>
>> but while insering form create_date.sql i
observed
this
INSERT INTO destinations VALUES
(1908,'9501','Conference','NL',0,0,0,0);
so is this a bug or any other table values
with regards
rama kanth
--- Adrian Georgescu <ag(a)ag-projects.com> wrote:
> Try this
>
>
> INSERT INTO auth_user VALUES
>
('c14cbf141ab1b7cd009356f555b607dc','admin','admin','admin,callsearch,s
t
>
> atistics,sqlquery','2099-01-02','Amin user',
> 'Admin
> user','+878-11
>
-7472999222','support@x.com','1','1','','','','','','ser_radius,asteris
>
>> k
>>>
>>> ,ser_acc,cisco','0','','2006-05-14
>>> 12:55:00','94nx9');
>>>
>>> On Jun 3, 2004, at 8:29 AM, varala ramakanth
=== message
truncated ===
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/