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 <[EMAIL PROTECTED]> To: Live Great <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > To: Live Great <[EMAIL PROTECTED]> > Cc: users@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 <[EMAIL PROTECTED]> > > To: Live Great <[EMAIL PROTECTED]> > > 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 <[EMAIL PROTECTED]> > > > To: Live Great <[EMAIL PROTECTED]> > > > Cc: users@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 <[EMAIL PROTECTED]> > > > > To: users@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 [EMAIL PROTECTED] > > > > > > > > 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 > > > > [EMAIL PROTECTED] > > > > http://openser.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > > > > > > >
_______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users