List Info

Thread: Re: how to register xlite user for testing with openser




Re: how to register xlite user for testing with openser
country flaguser name
United States
2007-09-23 23:09:09
Hi, in openser.cfg file, there is a route[4] section where also involve avp_db_load():

########################################################################
# Request route 'usr-preferences-callee'
########################################################################
route[4]
{
  ;      xlog("L_INFO", "Load callee preferences for uuid '$avp(s:callee_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$cin");
        # load callee avps
 ;       avp_db_load("$avp(s:callee_uuid)", "*");
        if(is_avp_set("$avp(s:cfu)/s"))
  ;      {

     ;           xlog("L_INFO", "Call-forward-unconditional to '$avp(s:cfu)' found - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$cin");
           ;     route(8);
  ;           ;   avp_delete("$avp(s:caller_uuid)/g");
   ;           ;  avp_copy("$avp(s:callee_uuid)", "$avp(s:caller_uuid)/d");
   ;           ;  avp_pushto("$ru", "$avp(s:cfu)");

          ;      route(3);
  ;           ;   route(14);
           ;     exit;
        }
       ; if(is_avp_set("$avp(s:ringtimeout)/n"))
        {

     ;           xlog("L_INFO", "Setting ring timeout to $avp(s:ringtimeout) secs - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$cin");
           ;     avp_copy("$avp(s:ringtimeout)", "$avp(s:callee_fr_inv_timer)/d");
        }

}


----- Original Message ----
From: Live Great <livegreat007yahoo.com&gt;
To: Norman Brandinger <normgoes.com&gt;
Cc: usersopenser.org
Sent: Monday, September 24, 2007 2:02:19 PM
Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser

Hi, here is the configuration specific to avp_db_load in the openser.cfg file:

route[3]
{
&nbsp; &nbsp; &nbsp;   route(1);
  ; &nbsp; &nbsp;  xlog("L_INFO", "Load caller preferences for uuid '$avp(s:caller_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$cin");
 &nbsp; &nbsp; &nbsp;  # load caller avps
 ; &nbsp; &nbsp; &nbsp; avp_db_load("$avp(s:caller_uuid)", "*");
&nbsp; &nbsp; &nbsp; &nbsp; avp_copy("$avp(s:cli)", "$avp(s:caller_cli)/d");
 &nbsp;   ; &nbsp; if(is_avp_set("$avp(s:clir)/n") && avp_check("$avp(s:clir)", "eq/i:1"))
 &nbsp; &nbsp; &nbsp;  {
 &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp; # mark for anonymization
 &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   setflag(28);
 &nbsp; &nbsp;   ; }

}

I never change this configuration.

Thanks
SW

----- Original Message ----
From: Norman Brandinger <normgoes.com&gt;
To: Live Great <livegreat007yahoo.com&gt;
Sent: Monday, September 24, 2007 12:59:19 PM
Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser

Are you issuing an avp_db_load() call with no value ? &nbsp;That might
explain the error message.&nbsp; Probably be a good idea to post the config
you are using.

Regards,
Norm



Live Great wrote:
>; Hi, thanks very much for the suggestion.
> I have added the required columns in the acc and missed_calls table.
>; Now when I tried to call an off-line number, it still show one error:
>;
> ERROR:avpops:load_avps: no value for first param
>
> The errors related to the acc and missed_calls tables are already gone.
> In xlite panel, the error message says "Call failed: Proxy
> Authentication Required.".
> I am not sure what happened if I call a on-line phone number.
&gt;
> Thanks
>; SW
>
&gt; ----- Original Message ----
> From: Norman Brandinger <normgoes.com&gt;
> To: Live Great <livegreat007yahoo.com&gt;
> Cc: usersopenser.org
> Sent: Sunday, September 23, 2007 10:50:38 PM
> Subject: Re: [OpenSER-Users] how to register xlite user for testing
&gt; with openser
&gt;
> Hi,
>
&gt; The subscriber "username" IS the "phone number".&nbsp; The phone number field
> in the subscriber table is only used by SERWEB.&nbsp; I believe the
> "username" column name is better than "phone" because in SIP, the idea
> of a telephone number is being blurred.
&gt;
> Please refer to the online doc at:
> http://openser.org/dokuwiki/doku.php/database:1.2.x#subscriber
&gt;
> There is alot of material at the openser.org web site that can help you.
>
> The mediaproxy errors are a result of your script calling a mediaproxy
> function but mediaproxy isn't running.&nbsp; This can be downloaded thanks to
> AG Projects from http://ag-projects.com/MediaProxy.html
>;
> The src_leg / dst_leg errors are a result of you trying to save
> additional (accounting) fields into the "acc" and/or "missed_calls"
> table.&nbsp; This is generally used for multi-leg call accounting (for
> example, in a call forwarding situation where the initial callee changes
&gt; to the caller .. of the forwarded call).&nbsp; You will have to manually add
> these column to the acc and missed_calls tables (varchar(64)) should be
> fine for most purposes.
>
> Regards,
&gt; Norm
>
> Live Great wrote:
>; > Now is getting other errors.
&gt; > When I tried to dial a number, eg. 123 - the default Admin account, I
> > got the following errors shown in /var/log/messages:
&gt; >
> > ERROR:avpops:load_avps: no value for first param
> > error: mediaproxy/sendMediaproxyCommand(): can't connect to MediaProxy
> > error: mediaproxy/sendMediaproxyCommand(): can't connect to MediaProxy
> > submit_query: Unknown column 'src_leg' in 'field list'
> > db_insert: Error while submitting query
> > ERROR:acc:acc_db_request: Error while inserting to database
&gt; >
> >
> > ----- Original Message ----
> > From: Norman Brandinger <normgoes.com&gt;
> > To: Live Great <livegreat007yahoo.com&gt;
> > Sent: Saturday, September 22, 2007 11:53:53 PM
> > Subject: Re: [OpenSER-Users] how to register xlite user for testing
&gt; > with openser
&gt; >
> > I believe the openser_mysql.sh script is being phased out.  It has been
> > replaced by openserdbctl (thanks to a big effort from Henning !!!). ; If
&gt; > your installation doesn't have /usr/local/sbin/openserdbctl I strongly
&gt; > suggest that you upgrade to a version of OpenSER that contains it.
> >
> > The rest of your settings appear to to be ok.
> >
> > Regards,
&gt; > Norm
> >
> > Live Great wrote:
>; > >
> > >
> > > ----- Original Message ----
> > > From: Norman Brandinger <normgoes.com&gt;
> > > To: Live Great <livegreat007yahoo.com&gt;
> > > Cc: usersopenser.org
> > > Sent: Saturday, September 22, 2007 9:43:54 PM
> > > Subject: Re: [OpenSER-Users] how to register xlite user for testing
&gt; > > with openser
&gt; > >
> > > Is is possible that you turned on database support but forgot to make
> > > the database tables ? &nbsp;The error message you posted is pretty
>; explicit:
> > > "Unknown column"....
> > > I used openser_mysql.sh create to populate openser database and its
> > > tables.
&gt; > > Here is all its tables:
&gt; > > mysql> show tables;
&gt; > > +-----------------------+
> > > | Tables_in_openser&nbsp; &nbsp;  |
> > > +-----------------------+
> > > | acc &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; |
> > > | active_sessions   ; &nbsp;  |
> > > | active_watchers   ; &nbsp;  |
> > > | address&nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; |
> > > | admin_privileges ; &nbsp; &nbsp; |
> > > | aliases&nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; |
> > > | cpl &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; |
> > > | dbaliases&nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp; |
> > > | domain&nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp;|
> > > | domainpolicy &nbsp; &nbsp; &nbsp;   ; |
&gt; > > | grp &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; |
> > > | gw &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp;|
> > > | gw_grp&nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp;|
> > > | imc_members &nbsp; &nbsp; &nbsp; &nbsp;   |
> > > | imc_rooms&nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp; |
> > > | lcr &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; |
> > > | location&nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;|
> > > | missed_calls &nbsp; &nbsp; &nbsp;   ; |
&gt; > > | pdt &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; |
> > > | pending&nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; |
> > > | phonebook&nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp; |
> > > | presentity  ; &nbsp; &nbsp; &nbsp; &nbsp;  |
>; > > | pua &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; |
> > > | re_grp&nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp;|
> > > | server_monitoring&nbsp; &nbsp;  |
> > > | server_monitoring_agg |
> > > | silo   ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp;|
> > > | sip_trace&nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp; |
> > > | speed_dial  ; &nbsp; &nbsp; &nbsp; &nbsp;  |
>; > > | subscriber  ; &nbsp; &nbsp; &nbsp; &nbsp;  |
>; > > | trusted&nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; |
> > > | uri &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;   ; &nbsp; |
> > > | usr_preferences   ; &nbsp;  |
> > > | usr_preferences_types |
> > > | version&nbsp; &nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; |
> > > | watchers&nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;|
> > > | xcap_xml&nbsp; &nbsp;   ; &nbsp; &nbsp; &nbsp; &nbsp;|
> > > +-----------------------+
> > > 37 rows in set (0.00 sec)
> > >
> > >
> > >
> > > The warnings about missing permissions files can be ignored
&gt; (unless you
> > > really do need them), but in your case, it seems that you are not at
> > > that point yet..
> > >
> > > Take a look at openserdbctl as it automates the process of
> creating the
> > > database and tables needed by the various openser
&gt; modules.&nbsp; openserctlrc
> > > (usually located in /usr/local/etc/openser) contains a number of
> startup
&gt; > > settings, some of which are database related.
&gt; > >
> > > The standard request you will receive from people trying to assist you
> > > is to post your config file (or at least the interesting sections of
> > it).
> > >
> > > The part of the content of openser..cfg is:
> > > listen = udp:127.0.0.1:5060
&gt; > > listen = udp:125.255.1.2:5060
> > > mpath = "/usr/local/lib/openser/modules"
> > > children = 8
> > > debug = 3
> > > fork = yes
> > > group = "openser"
> > > user = "openser"
> > > disable_tcp = no
> > > log_facility = LOG_DAEMON
> > > #log_facility = LOG_LOCAL7
> > > log_stderror = no
> > > tcp_children = 4
> > > mhomed = no
> > > server_signature = yes
> > > sock_group = "openser"
> > > sock_mode = 0600
> > > sock_user = "openser"
> > > unix_sock = "/tmp/openser.sock"
&gt; > > unix_sock_children = 1
> > > reply_to_via = no
> > > sip_warning = no
> > > check_via = no
> > > dns = no
> > > rev_dns = no
> > > disable_core_dump = no
> > > dns_try_ipv6 = yes
> > > dns_use_search_list = yes
> > >
> > > openserctlrc:
> > > ## your SIP domain
>; > >  SIP_DOMAIN=ip6.com.au
> > >
> > > ## database type: MYSQL or PGSQL, by defaulte none is loaded
>; > >  DBENGINE=MYSQL
&gt; > >
> > > ## database host
> > >  DBHOST=localhost
> > >
> > > ## database name
> > >  DBNAME=openser
&gt; > >
> > > ## database read/write user
> > >  DBRWUSER=openser
> > > # DBRWUSER=admin
> > >
> > > ## database read only user
> > >  DBROUSER=openserro
> > >
> > > ## password for database read only user
> > >  DBROPW=openserro
> > >
> > > ## database super user
> > >  DBROOTUSER="root"
> > >
> > >  HAS_SERWEB="yes"
> > >
> > > I am not too sure the correct way to define openserctlrc file..
>; > > Your comment is much appreciated.
> > >
> > > Thanks
>; > > SW
> > >
> > > Norm
> > >
> > > Live Great wrote:
>; > > > Hi,
> > > >
> > > > After changed the port 5077 to 5060 in openser.cfg file, restarted
> > > > openser.
&gt; > > > When xlite initiate a registartion request, openser system log file
> > > > shown a different message:
&gt; > > > Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: Default allow
> > > > file (/usr/local/etc/openser/permissions.allow) not found => empty
> > > > rule set
> > > > Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: WARNING:
&gt; File not
> > > > found: /usr/local/etc/openser/permissions.deny
>; > > > Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: Default
&gt; deny file
> > > > (/usr/local/etc/openser/permissions.deny) not found => empty
> rule set
> > > > Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:11 core /usr/local/sbin/openser[49957]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:11 core /usr/local/sbin/openser[49957]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:11 core /usr/local/sbin/openser[49957]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: get_ha1():
> Error
> > > > while querying database
&gt; > > > Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: submit_query:
> > > > Unknown column 'uuid' in 'field list'
> > > > Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: db_query: Error
> > > > while submitting query
> > > > Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: get_ha1():
> Error
> > > > while querying database
&gt; > > >
> > > > In Xlite, it said Registration error 500, server internal error.
>; > > > What is possibility wrong in my openser server configuration?
> > > >
> > > >
> > > > Thanks
>; > > > SW
> > > >
> > > > ----- Original Message ----
> > > > From: Live Great <livegreat007yahoo.com&gt;
> > > > To: usersopenser.org
> > > > Sent: Saturday, September 22, 2007 2:03:07 PM
> > > > Subject: [OpenSER-Users] how to register xlite user for testing with
> > > > openser
&gt; > > >
> > > > Hi,
> > > >
> > > > I used the following command to add xlite user, but xlite failed to
> > > > register the user in openser server.
&gt; > > > # openserctl add 1234 1234 sammy.domain.com
> > > >
> > > > where 1234 is user id and password.
> > > >
> > > > If this is not the correct way to add user for testing from xlite to
> > > > openser, what are the alternative way I can use?
> > > >
> > > >
> > > > Thanks
>; > > > SW
> > > >
> > > >
> > ------------------------------------------------------------------------
>; > > >
> > > > _______________________________________________
> > > > Users mailing list
> > > > Usersopenser.org
> > > > http://openser.org/cgi-bin/mailman/listinfo/users
>; > > >  
> > >
> > >
> >
> >
>
>



[1]

about | contact  Other archives ( Real Estate discussion Medical topics )