<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">If the other *online* xlite user has registered to the openser server successfully, I think the phone number that I am trying to call should be presented in the *location* table. Am I correct?<br><br>Thanks<br>SW<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Norman Brandinger <norm@goes.com><br>To: Live Great <livegreat007@yahoo.com><br>Cc: users@openser.org<br>Sent: Tuesday, September 25, 2007 10:07:10 AM<br>Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser<br><br><div>Take a look at the "location" table. <br><br>The save("location") writes information about the device registering to<br>OpenSER
to this table. <br><br>You should see entries for your xlite phones (both of them).<br><br>Note the lookup("location") line. This, as you can probably guess,<br>tries to locate the device (specified by the RURI, which in telephone<br>terms, is the called number) in the location table. That's why both<br>xlite phones should have entries in the location table.<br><br>The "Not Found" message is telling you that the lookup("location")<br>didn't find call callee.<br><br>Regards,<br>Norm<br><br><br><br>Live Great wrote:<br>> Now, I replaced the openser.cfg file with the one from the openser source.<br>> This openser.cfg does not have avp configuration..<br>> After restarted openser and registered xlite, dialed an off-line user<br>> number eg. 5678 shown "Call failed: Not Found" on the xlite panel.<br>> Openser does not write any error/wraning message to the system's log<br>> file. Is this normal?<br>> Here is the new
configuration of the openser.cfg:<br>> listen = udp:127.0.0.1:5060<br>> listen = udp:1x.x.x.x:5060<br>> mpath = "/usr/local/lib/openser/modules"<br>> children = 8<br>> debug = 3<br>> fork = yes<br>> group = "openser"<br>> user = "openser"<br>> disable_tcp = no<br>> log_facility = LOG_DAEMON<br>> #log_facility = LOG_LOCAL7<br>> log_stderror = no<br>> tcp_children = 4<br>> mhomed = no<br>> server_signature = yes<br>> sock_group = "openser"<br>> sock_mode = 0600<br>> sock_user = "openser"<br>> unix_sock = "/tmp/openser.sock"<br>> unix_sock_children = 1<br>> reply_to_via = no<br>> sip_warning = no<br>> check_via = no<br>> dns = no<br>> rev_dns = no<br>> disable_core_dump = no<br>> dns_try_ipv6 = yes<br>> dns_use_search_list = yes<br>> # ------------------ module loading ----------------------------------<br>><br>> #set module path<br>>
mpath="/usr/local/lib/openser/modules/"<br>><br>> # Uncomment this if you want to use SQL database<br>> #loadmodule "mysql.so"<br>><br>> loadmodule "sl.so"<br>> loadmodule "tm.so"<br>> loadmodule "rr.so"<br>> loadmodule "maxfwd.so"<br>> loadmodule "usrloc.so"<br>> loadmodule "registrar.so"<br>> loadmodule "textops.so"<br>> loadmodule "mi_fifo.so"<br>> modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")<br>> modparam("usrloc", "db_mode", 0)<br>> route{<br>><br>> # initial sanity checks -- messages with<br>> # max_forwards==0, or excessively long requests<br>> if (!mf_process_maxfwd_header("10")) {<br>> sl_send_reply("483","Too Many
Hops");<br>> exit;<br>> };<br>><br>> if (msg:len >= 2048 ) {<br>> sl_send_reply("513", "Message too big");<br>> exit;<br>> };<br>><br>> # we record-route all messages -- to make sure that<br>> # subsequent messages will go through our proxy; that's<br>> # particularly good if upstream and downstream
entities<br>> # use different transport protocol<br>> if (!method=="REGISTER")<br>> record_route();<br>><br>> # subsequent messages withing a dialog should take the<br>> # path determined by record-routing<br>> if (loose_route()) {<br>> # mark routing logic in request<br>> append_hf("P-hint:
rr-enforced\r\n");<br>> route(1);<br>> };<br>><br>><br>> # if the request is for other domain use UsrLoc<br>> # (in case, it does not work, use the following command<br>> # with proper names and addresses in it)<br>> if (uri==myself) {<br>><br>> if (method=="REGISTER") {<br>><br>> # Uncomment this if you want to use digest<br>>
authentication<br>> #if (!www_authorize("openser.org",<br>> "subscriber")) {<br>> # www_challenge("openser.org", "0");<br>> # exit;<br>> #};<br>><br>>
save("location");<br>> exit;<br>> };<br>><br>> lookup("aliases");<br>> if (!uri==myself) {<br>> append_hf("P-hint: outbound alias\r\n");<br>>
route(1);<br>> };<br>><br>> # native SIP destinations are handled using our USRLOC DB<br>> if (!lookup("location")) {<br>> sl_send_reply("404", "Not Found");<br>> exit;<br>>
};<br>> append_hf("P-hint: usrloc applied\r\n");<br>> };<br>><br>> route(1);<br>> }<br>><br>><br>> route[1] {<br>> # send it out now; use stateful forwarding as it works reliably<br>> # even for UDP2TCP<br>> if (!t_relay()) {<br>> sl_reply_error();<br>> };<br>> exit;<br>> }<br>><br>> What should be a *normal* openser.cfg config file look like?<br>><br>> Thanks<br>>
SW<br>><br>><br>> ----- Original Message ----<br>> From: Norman Brandinger <norm@goes.com><br>> To: Live Great <livegreat007@yahoo.com><br>> Cc: users@openser.org<br>> Sent: Monday, September 24, 2007 9:12:08 PM<br>> Subject: Re: [OpenSER-Users] how to register xlite user for testing<br>> with openser<br>><br>> Based on the xlog's in your config, you should be able to see which<br>> avp_db_load() is being called with no value. Once you know which<br>> variable is blank, you can then try to determine why it's not being<br>> populated.<br>><br>> Your config appears to be taken from one of the automatically generated<br>> ones from sipwise. You should double check the documentation and make<br>> sure that you have followed all of the instructions. If their<br>> instructions are not complete, you should let them know.<br>><br>> Hope this
helps,<br>> Norm<br>><br>><br>> Live Great wrote:<br>> > Hi, in openser.cfg file, there is a route[4] section where also<br>> > involve avp_db_load():<br>> ><br>> > ########################################################################<br>> > # Request route 'usr-preferences-callee'<br>> > ########################################################################<br>> > route[4]<br>> > {<br>> > xlog("L_INFO", "Load callee preferences for uuid<br>> > '$avp(s:callee_uuid)' - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n");<br>> > # load callee avps<br>> > avp_db_load("$avp(s:callee_uuid)", "*");<br>> > if(is_avp_set("$avp(s:cfu)/s"))<br>>
> {<br>> ><br>> > xlog("L_INFO", "Call-forward-unconditional to<br>> > '$avp(s:cfu)' found - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n");<br>> > route(8);<br>> > avp_delete("$avp(s:caller_uuid)/g");<br>> > avp_copy("$avp(s:callee_uuid)",<br>> "$avp(s:caller_uuid)/d");<br>> > avp_pushto("$ru", "$avp(s:cfu)");<br>> ><br>>
> route(3);<br>> > route(14);<br>> > exit;<br>> > }<br>> > if(is_avp_set("$avp(s:ringtimeout)/n"))<br>> > {<br>> ><br>> > xlog("L_INFO", "Setting ring timeout to<br>> > $avp(s:ringtimeout) secs - M=$rm RURI=$ru F=$fu T=$tu IP=$si ID=$ci\n");<br>> >
avp_copy("$avp(s:ringtimeout)",<br>> > "$avp(s:callee_fr_inv_timer)/d");<br>> > }<br>> ><br>> > }<br>> ><br>> ><br>> > ----- Original Message ----<br>> > From: Live Great <livegreat007@yahoo.com><br>> > To: Norman Brandinger <norm@goes.com><br>> > Cc: users@openser.org<br>> > Sent: Monday, September 24, 2007 2:02:19 PM<br>> > Subject: Re: [OpenSER-Users] how to register xlite user for testing<br>> > with openser<br>> ><br>> > Hi, here is the configuration specific to avp_db_load in the<br>> > openser.cfg file:<br>> ><br>> > route[3]<br>> > {<br>> > route(1);<br>> > xlog("L_INFO", "Load caller preferences for uuid<br>> > '$avp(s:caller_uuid)' - M=$rm RURI=$ru F=$fu T=$tu
IP=$si ID=$ci\n");<br>> > # load caller avps<br>> > avp_db_load("$avp(s:caller_uuid)", "*");<br>> > avp_copy("$avp(s:cli)", "$avp(s:caller_cli)/d");<br>> > if(is_avp_set("$avp(s:clir)/n") && avp_check("$avp(s:clir)",<br>> > "eq/i:1"))<br>> > {<br>> > # mark for anonymization<br>> > setflag(28);<br>> > }<br>> ><br>> > }<br>> ><br>> > I never change this configuration.<br>> ><br>> >
Thanks<br>> > SW<br>> ><br>> > ----- Original Message ----<br>> > From: Norman Brandinger <norm@goes.com><br>> > To: Live Great <livegreat007@yahoo.com><br>> > Sent: Monday, September 24, 2007 12:59:19 PM<br>> > Subject: Re: [OpenSER-Users] how to register xlite user for testing<br>> > with openser<br>> ><br>> > Are you issuing an avp_db_load() call with no value ? That might<br>> > explain the error message. Probably be a good idea to post the config<br>> > you are using.<br>> ><br>> > Regards,<br>> > Norm<br>> ><br>> ><br>> ><br>> > Live Great wrote:<br>> > > Hi, thanks very much for the suggestion.<br>> > > I have added the required columns in the acc and missed_calls table.<br>> > > Now when I tried to call an off-line number, it still show one error:<br>> > ><br>>
> > ERROR:avpops:load_avps: no value for first param<br>> > ><br>> > > The errors related to the acc and missed_calls tables are already<br>> gone.<br>> > > In xlite panel, the error message says "Call failed: Proxy<br>> > > Authentication Required.".<br>> > > I am not sure what happened if I call a on-line phone number.<br>> > ><br>> > > Thanks<br>> > > SW<br>> > ><br>> > > ----- Original Message ----<br>> > > From: Norman Brandinger <norm@goes.com><br>> > > To: Live Great <livegreat007@yahoo.com><br>> > > Cc: users@openser.org<br>> > > Sent: Sunday, September 23, 2007 10:50:38 PM<br>> > > Subject: Re: [OpenSER-Users] how to register xlite user for testing<br>> > > with openser<br>> > ><br>> > > Hi,<br>> > ><br>> > > The subscriber "username" IS the
"phone number". The phone number<br>> field<br>> > > in the subscriber table is only used by SERWEB. I believe the<br>> > > "username" column name is better than "phone" because in SIP, the idea<br>> > > of a telephone number is being blurred.<br>> > ><br>> > > Please refer to the online doc at:<br>> > > <a target="_blank" href="http://openser.org/dokuwiki/doku.php/database:1.2.x#subscriber">http://openser.org/dokuwiki/doku.php/database:1.2.x#subscriber</a><br>> > ><br>> > > There is alot of material at the openser.org web site that can<br>> help you.<br>> > ><br>> > > The mediaproxy errors are a result of your script calling a mediaproxy<br>> > > function but mediaproxy isn't running.. This can be downloaded<br>> thanks to<br>> > > AG Projects from <a target="_blank"
href="http://ag-projects.com/MediaProxy.html">http://ag-projects.com/MediaProxy.html</a><br>> > ><br>> > > The src_leg / dst_leg errors are a result of you trying to save<br>> > > additional (accounting) fields into the "acc" and/or "missed_calls"<br>> > > table. This is generally used for multi-leg call accounting (for<br>> > > example, in a call forwarding situation where the initial callee<br>> changes<br>> > > to the caller .. of the forwarded call). You will have to<br>> manually add<br>> > > these column to the acc and missed_calls tables (varchar(64))<br>> should be<br>> > > fine for most purposes.<br>> > ><br>> > > Regards,<br>> > > Norm<br>> > ><br>> > > Live Great wrote:<br>> > > > Now is getting other errors.<br>> > > > When I tried to dial a number, eg. 123 - the default
Admin<br>> account, I<br>> > > > got the following errors shown in /var/log/messages:<br>> > > ><br>> > > > ERROR:avpops:load_avps: no value for first param<br>> > > > error: mediaproxy/sendMediaproxyCommand(): can't connect to<br>> MediaProxy<br>> > > > error: mediaproxy/sendMediaproxyCommand(): can't connect to<br>> MediaProxy<br>> > > > submit_query: Unknown column 'src_leg' in 'field list'<br>> > > > db_insert: Error while submitting query<br>> > > > ERROR:acc:acc_db_request: Error while inserting to database<br>> > > ><br>> > > ><br>> > > > ----- Original Message ----<br>> > > > From: Norman Brandinger <norm@goes.com><br>> > > > To: Live Great <livegreat007@yahoo.com><br>> > > > Sent: Saturday, September 22, 2007 11:53:53 PM<br>> > > > Subject: Re:
[OpenSER-Users] how to register xlite user for testing<br>> > > > with openser<br>> > > ><br>> > > > I believe the openser_mysql.sh script is being phased out. It has<br>> > been<br>> > > > replaced by openserdbctl (thanks to a big effort from Henning<br>> > !!!). If<br>> > > > your installation doesn't have /usr/local/sbin/openserdbctl I<br>> strongly<br>> > > > suggest that you upgrade to a version of OpenSER that contains it.<br>> > > ><br>> > > > The rest of your settings appear to to be ok.<br>> > > ><br>> > > > Regards,<br>> > > > Norm<br>> > > ><br>> > > > Live Great wrote:<br>> > > > ><br>> > > > ><br>> > > > > ----- Original Message ----<br>> > > > > From: Norman Brandinger
<norm@goes.com><br>> > > > > To: Live Great <livegreat007@yahoo.com><br>> > > > > Cc: users@openser.org<br>> > > > > Sent: Saturday, September 22, 2007 9:43:54 PM<br>> > > > > Subject: Re: [OpenSER-Users] how to register xlite user for<br>> testing<br>> > > > > with openser<br>> > > > ><br>> > > > > Is is possible that you turned on database support but forgot to<br>> > make<br>> > > > > the database tables ? The error message you posted is pretty<br>> > > explicit:<br>> > > > > "Unknown column"....<br>> > > > > I used openser_mysql.sh create to populate openser database<br>> and its<br>> > > > > tables.<br>> > > > > Here is all its tables:<br>> > > > > mysql> show tables;<br>> > > > >
+-----------------------+<br>> > > > > | Tables_in_openser |<br>> > > > > +-----------------------+<br>> > > > > | acc |<br>> > > > > | active_sessions |<br>> > > > > | active_watchers |<br>> > > > > | address |<br>> > > > > | admin_privileges |<br>> > > > > | aliases |<br>> > > > > | cpl |<br>> > > >
> | dbaliases |<br>> > > > > | domain |<br>> > > > > | domainpolicy |<br>> > > > > | grp |<br>> > > > > | gw |<br>> > > > > | gw_grp |<br>> > > > > | imc_members |<br>> > > > > |
imc_rooms |<br>> > > > > | lcr |<br>> > > > > | location |<br>> > > > > | missed_calls |<br>> > > > > | pdt |<br>> > > > > | pending |<br>> > > > > | phonebook |<br>> > > > > | presentity |<br>> >
> > > | pua |<br>> > > > > | re_grp |<br>> > > > > | server_monitoring |<br>> > > > > | server_monitoring_agg |<br>> > > > > | silo |<br>> > > > > | sip_trace |<br>> > > > > | speed_dial |<br>> > > > > | subscriber |<br>> > > > > |
trusted |<br>> > > > > | uri |<br>> > > > > | usr_preferences |<br>> > > > > | usr_preferences_types |<br>> > > > > | version |<br>> > > > > | watchers |<br>> > > > > | xcap_xml |<br>> > > > > +-----------------------+<br>> > > > > 37 rows in set (0.00 sec)<br>> > > > ><br>> > > > ><br>> > > > ><br>> > > > >
The warnings about missing permissions files can be ignored<br>> > > (unless you<br>> > > > > really do need them), but in your case, it seems that you are<br>> not at<br>> > > > > that point yet..<br>> > > > ><br>> > > > > Take a look at openserdbctl as it automates the process of<br>> > > creating the<br>> > > > > database and tables needed by the various openser<br>> > > modules. openserctlrc<br>> > > > > (usually located in /usr/local/etc/openser) contains a number of<br>> > > startup<br>> > > > > settings, some of which are database related.<br>> > > > ><br>> > > > > The standard request you will receive from people trying to<br>> > assist you<br>> > > > > is to post your config file (or at least the interesting<br>> sections of<br>> >
> > it).<br>> > > > ><br>> > > > > The part of the content of openser..cfg is:<br>> > > > > listen = udp:127.0.0.1:5060<br>> > > > > listen = udp:125.255.1.2:5060<br>> > > > > mpath = "/usr/local/lib/openser/modules"<br>> > > > > children = 8<br>> > > > > debug = 3<br>> > > > > fork = yes<br>> > > > > group = "openser"<br>> > > > > user = "openser"<br>> > > > > disable_tcp = no<br>> > > > > log_facility = LOG_DAEMON<br>> > > > > #log_facility = LOG_LOCAL7<br>> > > > > log_stderror = no<br>> > > > > tcp_children = 4<br>> > > > > mhomed = no<br>> > > > > server_signature = yes<br>> > > > > sock_group = "openser"<br>> > > > > sock_mode = 0600<br>> > > > >
sock_user = "openser"<br>> > > > > unix_sock = "/tmp/openser.sock"<br>> > > > > unix_sock_children = 1<br>> > > > > reply_to_via = no<br>> > > > > sip_warning = no<br>> > > > > check_via = no<br>> > > > > dns = no<br>> > > > > rev_dns = no<br>> > > > > disable_core_dump = no<br>> > > > > dns_try_ipv6 = yes<br>> > > > > dns_use_search_list = yes<br>> > > > ><br>> > > > > openserctlrc:<br>> > > > > ## your SIP domain<br>> > > > > SIP_DOMAIN=ip6.com.au<br>> > > > ><br>> > > > > ## database type: MYSQL or PGSQL, by defaulte none is loaded<br>> > > > > DBENGINE=MYSQL<br>> > > > ><br>> > > > > ## database host<br>> > > >
> DBHOST=localhost<br>> > > > ><br>> > > > > ## database name<br>> > > > > DBNAME=openser<br>> > > > ><br>> > > > > ## database read/write user<br>> > > > > DBRWUSER=openser<br>> > > > > # DBRWUSER=admin<br>> > > > ><br>> > > > > ## database read only user<br>> > > > > DBROUSER=openserro<br>> > > > ><br>> > > > > ## password for database read only user<br>> > > > > DBROPW=openserro<br>> > > > ><br>> > > > > ## database super user<br>> > > > > DBROOTUSER="root"<br>> > > > ><br>> > > > > HAS_SERWEB="yes"<br>> > > > ><br>> > > > > I am not too sure the correct way to define
openserctlrc file..<br>> > > > > Your comment is much appreciated.<br>> > > > ><br>> > > > > Thanks<br>> > > > > SW<br>> > > > ><br>> > > > > Norm<br>> > > > ><br>> > > > > Live Great wrote:<br>> > > > > > Hi,<br>> > > > > ><br>> > > > > > After changed the port 5077 to 5060 in openser.cfg file,<br>> restarted<br>> > > > > > openser.<br>> > > > > > When xlite initiate a registartion request, openser system log<br>> > file<br>> > > > > > shown a different message:<br>> > > > > > Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: Default<br>> allow<br>> > > > > > file (/usr/local/etc/openser/permissions.allow) not found =><br>> empty<br>> > > > > > rule
set<br>> > > > > > Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: WARNING:<br>> > > File not<br>> > > > > > found: /usr/local/etc/openser/permissions.deny<br>> > > > > > Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: Default<br>> > > deny file<br>> > > > > > (/usr/local/etc/openser/permissions.deny) not found => empty<br>> > > rule set<br>> > > > > > Sep 22 16:19:01 core /usr/local/sbin/openser[49953]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: get_ha1():<br>> > > Error<br>> > > > > > while
querying database<br>> > > > > > Sep 22 16:19:04 core /usr/local/sbin/openser[49956]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:06 core /usr/local/sbin/openser[49957]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:06 core
/usr/local/sbin/openser[49957]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49952]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49954]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: db_query:<br>> > Error<br>> > >
> > > while submitting query<br>> > > > > > Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:09 core /usr/local/sbin/openser[49955]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:11 core /usr/local/sbin/openser[49957]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22
16:19:11 core /usr/local/sbin/openser[49957]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:11 core /usr/local/sbin/openser[49957]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:13 core /usr/local/sbin/openser[49959]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:14 core /usr/local/sbin/openser[49952]:<br>> submit_query:<br>> > > >
> > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49954]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22
16:19:16 core /usr/local/sbin/openser[49955]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:21 core /usr/local/sbin/openser[49957]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: get_ha1():<br>> > > Error<br>>
> > > > > while querying database<br>> > > > > > Sep 22 16:19:22 core /usr/local/sbin/openser[49952]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:29 core /usr/local/sbin/openser[49954]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22
16:19:29 core /usr/local/sbin/openser[49954]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:42 core /usr/local/sbin/openser[49956]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: db_query:<br>> > Error<br>> > > > > > while submitting query<br>> > > > > > Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > > Sep 22 16:19:46 core /usr/local/sbin/openser[49958]:<br>> submit_query:<br>> > > > > > Unknown column 'uuid' in 'field list'<br>> > > > > > Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: db_query:<br>> > Error<br>>
> > > > > while submitting query<br>> > > > > > Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: get_ha1():<br>> > > Error<br>> > > > > > while querying database<br>> > > > > ><br>> > > > > > In Xlite, it said Registration error 500, server internal error.<br>> > > > > > What is possibility wrong in my openser server configuration?<br>> > > > > ><br>> > > > > ><br>> > > > > > Thanks<br>> > > > > > SW<br>> > > > > ><br>> > > > > > ----- Original Message ----<br>> > > > > > From: Live Great <livegreat007@yahoo.com><br>> > > > > > To: users@openser.org<br>> > > > > > Sent: Saturday, September 22, 2007 2:03:07 PM<br>> > > > > > Subject: [OpenSER-Users] how to
register xlite user for<br>> > testing with<br>> > > > > > openser<br>> > > > > ><br>> > > > > > Hi,<br>> > > > > ><br>> > > > > > I used the following command to add xlite user, but xlite<br>> > failed to<br>> > > > > > register the user in openser server.<br>> > > > > > # openserctl add 1234 1234 sam@my.domain.com<br>> > > > > ><br>> > > > > > where 1234 is user id and password.<br>> > > > > ><br>> > > > > > If this is not the correct way to add user for testing from<br>> > xlite to<br>> > > > > > openser, what are the alternative way I can use?<br>> > > > > ><br>> > > > > ><br>> > > > > > Thanks<br>> > > > > > SW<br>> > > > >
><br>> > > > > ><br>> > > ><br>> > ------------------------------------------------------------------------<br>> > > > > ><br>> > > > > > _______________________________________________<br>> > > > > > Users mailing list<br>> > > > > > Users@openser.org<br>> > > > > > <a target="_blank" href="http://openser.org/cgi-bin/mailman/listinfo/users">http://openser.org/cgi-bin/mailman/listinfo/users</a><br>> > > > > > <br>> > > > ><br>> > > > ><br>> > > ><br>> > > ><br>> > ><br>> > ><br>> ><br>> ><br>> ><br>> ><br>><br>><br><br></div></div><br></div></div></body></html>