[Serusers] Re: error with cdrtool installation

[varala ramakanth]

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/