it gives error as
fataerror:Call to undefined function:mysql_connect()
in
/var/www/CDRTool/phplib/db_mysql.inc on line 73
i have browsed that file
does i need manully give the
database,username,host,pasword in it
if yes which does i need to provide
with regards
rama kanth
--- Adrian Georgescu <ag(a)ag-projects.com> wrote:
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(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
|
>>>> | |
=== message truncated ===
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.