[Serusers] Re: error with cdrtool installation

[Adrian Georgescu]

The location of the mysql script to create radius database is OS 
dependent. List the content of your radius RPM package to locate that 
script.

Adrian

On Jun 8, 2004, at 6:13 AM, varala ramakanth wrote:

> 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 at 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 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
>>
> === message truncated ===
>
>
>
> 	
> 		
> __________________________________
> Do you Yahoo!?
> Friends.  Fun.  Try the all-new Yahoo! Messenger.
> http://messenger.yahoo.com/