[Serusers] Re: error with cdrtool installation

[Adrian Georgescu]

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 at 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 at 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 at 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 at 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
>> wrote:
>>>>
>>>>> INSERT INTO auth_user
>>>>>
>>>>
>>>
>>
> (user_id,username,password,perms,expire,organization,name,tel,email,dis
>>>>
>>>>>
>>>>
>>>
>>
> play_cli,dispaly_card,domainFilter,codeFilter,aNumberFilter,afterDateFi
>>>>
>>>>>
>>>>
>>>
>>
> lter,sources,otp_enable,otp_rcpt,otp_expire,otp_passwd)
>>>>> VALUES
>>>>>
>>>>
>>>
>>
> ('c14cbf141ab1b7cd009356f555b607dc','admin','admin','admin,callsearch,s
>>>>
>>>>> tatistics,sqlquery','2099-01-01','AG
>>>>> Projects','Adrian
>>>>> Georgescu','31-620-534309','support at ag-
>>>>> projects.com','1','1','','','','','0000-00
>>>>>
>>>>
>>>
>>
> -00','ipnxcdr,ipnxlog,telecats,asterisk,cisco,ser','0','','2003-10-28
>>>>> 12:52:00','8n36r');
>>>>
>>>
>>>
>>>
>>> 	
>>> 		
>>> __________________________________
>>> Do you Yahoo!?
>>> Friends.  Fun.  Try the all-new Yahoo! Messenger.
>>> http://messenger.yahoo.com/
>>
>
>
>
> 	
> 		
> __________________________________
> Do you Yahoo!?
> Friends.  Fun.  Try the all-new Yahoo! Messenger.
> http://messenger.yahoo.com/