Re: [OpenSER-Users] how to register xlite user for testing with openser

24 Sep 2007

Based on the xlog's in your config, you should be able to see which
avp_db_load() is being called with no value.  Once you know which
variable is blank, you can then try to determine why it's not being
populated.

Your config appears to be taken from one of the automatically generated
ones from sipwise.  You should double check the documentation and make
sure that you have followed all of the instructions.  If their
instructions are not complete, you should let them know.

Hope this helps,
Norm

Live Great wrote:
...
  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=$ci\n");
         # 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=$ci\n");
                 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=$ci\n");
                 avp_copy("$avp(s:ringtimeout)",
 "$avp(s:callee_fr_inv_timer)/d");
         }

 }

 ----- Original Message ----
 From: Live Great &lt;livegreat007(a)yahoo.com&gt;
 To: Norman Brandinger &lt;norm(a)goes.com&gt;
 Cc: users(a)openser.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]
 {
         route(1);
         xlog("L_INFO", "Load caller preferences for uuid
 '$avp(s:caller_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n");
         # load caller avps
         avp_db_load("$avp(s:caller_uuid)", "*");
         avp_copy("$avp(s:cli)", "$avp(s:caller_cli)/d");
         if(is_avp_set("$avp(s:clir)/n") &&
avp_check("$avp(s:clir)",
 "eq/i:1"))
         {
                 # mark for anonymization
                 setflag(28);
         }

 }

 I never change this configuration.

 Thanks
 SW

 ----- Original Message ----
 From: Norman Brandinger &lt;norm(a)goes.com&gt;
 To: Live Great &lt;livegreat007(a)yahoo.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 ?  That might
 explain the error message.  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.

 Thanks
 SW

 ----- Original Message ----
 From: Norman Brandinger &lt;norm(a)goes.com&gt;
 To: Live Great &lt;livegreat007(a)yahoo.com&gt;
 Cc: users(a)openser.org
 Sent: Sunday, September 23, 2007 10:50:38 PM
 Subject: Re: [OpenSER-Users] how to register xlite user for testing
 with openser

 Hi,

 The subscriber "username" IS the "phone number".  The phone number
field
 in the subscriber table is only used by SERWEB.  I believe the
 "username" column name is better than "phone" because in SIP, the
idea
 of a telephone number is being blurred.

 Please refer to the online doc at:
 http://openser.org/dokuwiki/doku.php/database:1.2.x#subscriber

 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.  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.  This is generally used for multi-leg call accounting (for
 example, in a call forwarding situation where the initial callee changes
 to the caller .. of the forwarded call).  You will have to manually add
 these column to the acc and missed_calls tables (varchar(64)) should be
 fine for most purposes.

 Regards,
 Norm

 Live Great wrote:
 > Now is getting other errors.
 > When I tried to dial a number, eg. 123 - the default Admin account, I
 > got the following errors shown in /var/log/messages:
 >
 > 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
 >
 >
 > ----- Original Message ----
 > From: Norman Brandinger &lt;norm(a)goes.com&gt;
 > To: Live Great &lt;livegreat007(a)yahoo.com&gt;
 > Sent: Saturday, September 22, 2007 11:53:53 PM
 > Subject: Re: [OpenSER-Users] how to register xlite user for testing
 > with openser
 >
 > 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
  > your installation doesn't have
/usr/local/sbin/openserdbctl I strongly
 > suggest that you upgrade to a version of OpenSER that contains it.
 >
 > The rest of your settings appear to to be ok.
 >
 > Regards,
 > Norm
 >
 > Live Great wrote:
 > >
 > >
 > > ----- Original Message ----
 > > From: Norman Brandinger &lt;norm(a)goes.com&gt;
 > > To: Live Great &lt;livegreat007(a)yahoo.com&gt;
 > > Cc: users(a)openser.org
 > > Sent: Saturday, September 22, 2007 9:43:54 PM
 > > Subject: Re: [OpenSER-Users] how to register xlite user for testing
 > > with openser
 > >
 > > Is is possible that you turned on database support but forgot to  make
   > the
database tables ?  The error message you posted is pretty  explicit:
  > "Unknown column"....
 > I used openser_mysql.sh create to populate openser database and its
 > tables.
 > Here is all its tables:
 > mysql> show tables;
 > +-----------------------+
 > | Tables_in_openser     |
 > +-----------------------+
 > | acc                   |
 > | active_sessions       |
 > | active_watchers       |
 > | address               |
 > | admin_privileges      |
 > | aliases               |
 > | cpl                   |
 > | dbaliases             |
 > | domain                |
 > | domainpolicy          |
 > | grp                   |
 > | gw                    |
 > | gw_grp                |
 > | imc_members           |
 > | imc_rooms             |
 > | lcr                   |
 > | location              |
 > | missed_calls          |
 > | pdt                   |
 > | pending               |
 > | phonebook             |
 > | presentity            |
 > | pua                   |
 > | re_grp                |
 > | server_monitoring     |
 > | server_monitoring_agg |
 > | silo                  |
 > | sip_trace             |
 > | speed_dial            |
 > | subscriber            |
 > | trusted               |
 > | uri                   |
 > | usr_preferences       |
 > | usr_preferences_types |
 > | version               |
 > | watchers              |
 > | xcap_xml              |
 > +-----------------------+
 > 37 rows in set (0.00 sec)
 >
 >
 >
 > The warnings about missing permissions files can be ignored  (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  modules.  openserctlrc
  > (usually located in /usr/local/etc/openser)
contains a number of  startup
 > > settings, some of which are database related.
 > >
 > > 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
 > > 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"
 > > 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
 > >
 > > ## database host
 > >  DBHOST=localhost
 > >
 > > ## database name
 > >  DBNAME=openser
 > >
 > > ## 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.
 > > > When xlite initiate a registartion request, openser system log 
file
   > >
shown a different message:
 > > 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:  File not
  > > found:
/usr/local/etc/openser/permissions.deny
 > > Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: Default  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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > > 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
 > > >
 > > > 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 &lt;livegreat007(a)yahoo.com&gt;
 > > > To: users(a)openser.org
 > > > Sent: Saturday, September 22, 2007 2:03:07 PM
 > > > Subject: [OpenSER-Users] how to register xlite user for  testing
with
  > > > openser
 > > >
 > > > Hi,
 > > >
 > > > I used the following command to add xlite user, but xlite  failed
to
  > > > register the user in openser
server.
 > > > # openserctl add 1234 1234 sam(a)my.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
 > Users(a)openser.org
 > http://openser.org/cgi-bin/mailman/listinfo/users
 >  

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

Re: [OpenSER-Users] how to register xlite user for testing with openser