<br />Yes, you are correct. The username column in the location table is what you're looking
for.<br /><br />Norm<br /><br /><br /><br />> If the other *online* xlite user has registered
to the openser server successfully, I think the <br />> 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 />> ----- Original Message ---- <br />> <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 />> 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 />>> <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 />>> > <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 />>> > <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 />>> > >
<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
/>>> > > http://openser.org/dokuwiki/doku.php/database:1.2.x#subscriber <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 http://ag-projects.com/MediaProxy.html <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 />>>
> > > <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 />>> > > > > <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 />>> > > > > > <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 />>> > >
> > > http://openser.org/cgi-bin/mailman/listinfo/users <br />>> > > >
> > <br />>> > > > > <br />>> > > > > <br />>>
> > > <br />>> > > > <br />>> > > <br />>> > > <br
/>>> > <br />>> > <br />>> > <br />>> > <br />>> <br
/>>> <br />> <br />> <br />> <br />> <br />> <br />> <br />