[Users] problem to create DB in openser cvs (1.2)

Rafael J. Risco G.V. rafael.risco at gmail.com
Tue Oct 3 18:18:32 CEST 2006


thankyou daniel , I  am testing right now:

1.- Multi Call-Legs accounting works ok, please let me know if I am
wrong when populate the avps using this configuration:

modparam("acc", "multi_leg_info", "leg_src=$avp(i:110);leg_dst=$avp(i:111)")
...
        ## populate the avps (for Multi call leg accounting):
        if (!method=="REGISTER" && !method=="NOTIFY") {
                avp_write("$from/username", "$avp(i:110)");
                avp_write("$ruri/username", "$avp(i:111)");
          };

2.- I've found that missed call cdr's  are storing in 'acc' table
instead of 'missed_calls' table by default as in 1.1.x .

3.- I need to correlate INVITEs with BYEs to generate session time in
CDRs, wich field can I use, from_tag or to_tag?

thanks
rafael




On 9/29/06, Daniel-Constantin Mierla <daniel at voice-system.ro> wrote:
> Hello Rafael,
>
> the special characters added by 'show create table ...' conflicts with
> shell interpreter. The error should be fixed on CVS, please get latest
> version and try again.
>
> Cheers,
> Daniel
>
>
> On 09/29/06 02:11, Rafael J. Risco G.V. wrote:
> > Hi
> > I've installed openser dev 1.2 to test new acc module in my lab but
> > cant create DB in mysql server using ist openser_mysql, please see
> > this error:
> >
> > ]# openser_mysql.sh create
> > MySql password for root:
> > Domain (realm) for the default user 'admin': 10.0.1.231
> >
> > creating database openser ...
> > /usr/local/sbin/openser_mysql.sh: line 262: method: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: from_uri: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: from_tag: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: to_uri: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: to_tag: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: callid: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: cseq_no: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: sip_code: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: sip_reason: command not found
> >
> > real    0m0.000s
> > user    0m0.000s
> > sys     0m0.000s
> > /usr/local/sbin/openser_mysql.sh: line 262: callid: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: method: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: from_uri: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: from_tag: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: to_uri: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: to_tag: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: callid: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: cseq_no: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: sip_code: command not found
> > /usr/local/sbin/openser_mysql.sh: line 262: sip_reason: command not found
> >
> > real    0m0.000s
> > user    0m0.000s
> > sys     0m0.000s
> > /usr/local/sbin/openser_mysql.sh: line 262: callid: command not found
> > ERROR 1064 (42000) at line 80: You have an error in your SQL syntax;
> > check the manual that corresponds to your MySQL serverversion for the
> > right syntax to use near '=0(root) gid=0(root)
> > groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wh'at line 2
> >
> > _______________________________________________
> > Users mailing list
> > Users at openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
>




More information about the sr-users mailing list