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 |
> | |
> | 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/