[Serusers] Re: error with cdrtool installation

[varala ramakanth]

i have followed all the steps 

but when i run http://ip/CDRTool

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 at 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 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
> |
> >>>>>   |                |
> 
=== message truncated ===



	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/