sr-users September 2007

sr-users@lists.kamailio.org

158 participants
248 discussions

Start a nNew thread

Recall: [OpenSER-Users]
by Martin.Gruber1＠infineon.com 26 Sep '07

26 Sep '07

Gruber Martin (IFKL IT OS NV) would like to recall the message, "[OpenSER-Users]".

1 0

[OpenSER-Users]
by Martin.Gruber1＠infineon.com 26 Sep '07

26 Sep '07

Hi @all, I have following problem. I have registered all my phones on OpenSER with the full number. e.g. 43 11555 1007 When one employee from one site wants to call an employee from the same site I want them only to dial 1007 not The whole number. I have following perl script, but when I use the "canonical" function, it always adds "+" in front of the number. I get following message: canonical number in 'sip:1777@server.com' is '+43115551007' After the execution of the perl script I want to check, if the user with 43115551007: It looks like this: if (uri=~"sip:[0-9]+@.*") { perl_exec("canonical"); if (does_uri_exist()) { route(2); } else { #route to LCR-Module route(3); }; } But it does not run well. The script looks like this: ------------------------------------------------- use OpenSER::Constants; use OpenSER::Utils::PhoneNumbers; sub canonical { my $m = shift; if ($m->getMethod() eq "INVITE") { my $p = new OpenSER::Utils::PhoneNumbers(publicAccessPrefix => "", internationalPrefix => "", longDistancePrefix => "", countryCode => "43", areaCode => "11555", pbxCode => ""); my $u = $m->getRURI(); if ($u =~ m/(.*)sip:([+0-9]+)\@(.*)/) { my $c = $p->canonicalForm($2); OpenSER::log(L_INFO, "canonical number in '$u' is '$c'\n"); } else { OpenSER::log(L_INFO, "Not a POTS number.\n"); } } return 1; } Can anyone provide me some help? Thanks martin

1 0

[Serusers] How Can i select the version of ser?
by 程千 26 Sep '07

26 Sep '07

hi: I want to get a sip proxy that support Call , MESSAGE , NOTIFY ,SUBSCRIBE. When the destination ua is offline the message is storing. The storing message is send when it is online. The two ua can call each other. What statble version i can use? How can i config the ser.cfg? Thanks very much ! 2007-09-25 程千

2 1

[OpenSER-Users] RE: Call Forwarding Issue
by Ariadne Ramos 25 Sep '07

25 Sep '07

Hello Im trying to implement call forwarding unconditional redirect to a PSTN destination. Call flow: PSTN-->SIP-CallFW-->PSTN On my PSTN side I have a cisco AS5300. We succesfuly forwarded to a PSTN destination. We have changed calling party (for billing purposes) and called party to complete call forwarding. In other words we generate a new call attempt. Everything looks ok but if calling party (PSTN originating side) finishes the call before called party answers (PSTN destination side), cisco GW receives a CANCEL message and it answers with message 481 Call leg/Transaction does not exist to the Proxy. The call still ringing and goes to voice mail on PSTN destination side that means cisco GW never receives a BYE regarding to the original INVITE message. Can you give me a hint on how to handle this issue ? Thanks Captured attached Ariadne L. Ramos Solís Depto. Ingeniería Aprovisionamiento y Señalización VoIP Galaxy Communications Corp. Tel. 2000117 e-mail aramos(a)clarocom.com

1 0

[OpenSER-Users] Looking for an OpenSER configuration contractor
by Daryl G. Jurbala 25 Sep '07

25 Sep '07

I'm looking for someone who can assist with an OpenSER/MySQL/Radius setup which needs to perform LCR from MySQL, write proper CDRs (and fail calls if they can not be written), and allow for routing a specific group of inbound IPs to specific gateways. Essentially, I'm looking to create a multi-tenant session border controller for wholesale VoIP to VoIP. If you have experience in this and are interested in doing hourly contracting work, both to assist with the initial setup as well as ongoing support, please contact me. Daryl G. Jurbala Director of Network Operations Global Convergence Solutions Phone: +1 732-853-0513

1 0

[OpenSER-Users] reset record-route in branch route
by Klaus Darilion 25 Sep '07

25 Sep '07

Hi! Openser 1.2: I put some routing info into the record-route header. If a transaction gets redirected to another destination in failure route, I have to adopt the parameter and add a record-route header with the new parameter. Currently, I do add_rr_param and record_route again in failure route, but this leads to 2 Record-Route headers in the outgoing request. Is there a way to reset RR in failure route - or am I just doing something wrong? thanks klaus

3 4

[OpenSER-Users] OpenXCAP install and config problem?
by harini.dhanasekaran＠wipro.com 25 Sep '07

25 Sep '07

Hi, I m facing the same problem while configuring openxcap. I have installed openxcap in FC4 Linux and also the prerequisites packages. Can someone please let me know how to start the daemon. Thanks in advance. Thank you, Regards, Harini Dhanasekaran. ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------------------------------------------ -------------------------- KevinKinnan kinnan2224 at hotmail.com <mailto:users%40openser.org?Subject=%5BOpenSER-Users%5D%20OpenXCAP%20ins tall%20and%20config%20problem%3F&In-Reply-To=> wrote: Thu Sep 6 17:47:14 CEST 2007 I am not sure whether or not my procedure is right as server doesnt work at the moment, but I will keep working on it. Here is the Fedora installation [1] Fedora 6 linux install; [2] pre-dependencies package; Because I installed OpenIMSCore and Openser Presence module before, so some dependencies was already installed. In this case I just installed clearsilver from Add&Remove Package, and copy lxml folder(1.3.4 download from lxml site) to /usr/lib/python2.5/site-packages/. [3] install OpenXCAP, followed installation guide/Debain unstable installation By now, that's it. Coz no daemon can be run from /etc/init.d/openxcap. Also, I haven't modified anything in the config.ini and openxcap files Cheers, Kevin The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com

1 0

[OpenSER-Users] Openser with Mysql, rtpproxy and dispatcher module
by Arya 25 Sep '07

25 Sep '07

Hi Everyone I have tested openser 1.1 with the Mysql module and now I want to test 1.2with mysql, rtpproxy and the dispatcher module. When I'm compiling openser should I do anything differently? I saw rtpproxy listed in APT and the dispatcher modules was in /usr/local/lib/openser/modules last time I had openser 1.1 installed. should I only change my opernser.cfg in order for it to load? -- Thank You

3 2

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 25 Sep '07

25 Sep '07

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? Thanks SW ----- Original Message ---- From: Norman Brandinger <norm(a)goes.com> To: Live Great <livegreat007(a)yahoo.com> Cc: users(a)openser.org Sent: Tuesday, September 25, 2007 10:07:10 AM Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser Take a look at the "location" table. The save("location") writes information about the device registering to OpenSER to this table. You should see entries for your xlite phones (both of them). Note the lookup("location") line. This, as you can probably guess, tries to locate the device (specified by the RURI, which in telephone terms, is the called number) in the location table. That's why both xlite phones should have entries in the location table. The "Not Found" message is telling you that the lookup("location") didn't find call callee. Regards, Norm Live Great wrote: > Now, I replaced the openser.cfg file with the one from the openser source. > This openser.cfg does not have avp configuration.. > After restarted openser and registered xlite, dialed an off-line user > number eg. 5678 shown "Call failed: Not Found" on the xlite panel. > Openser does not write any error/wraning message to the system's log > file. Is this normal? > Here is the new configuration of the openser.cfg: > listen = udp:127.0.0.1:5060 > listen = udp:1x.x.x.x: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 > # ------------------ module loading ---------------------------------- > > #set module path > mpath="/usr/local/lib/openser/modules/" > > # Uncomment this if you want to use SQL database > #loadmodule "mysql.so" > > loadmodule "sl.so" > loadmodule "tm.so" > loadmodule "rr.so" > loadmodule "maxfwd.so" > loadmodule "usrloc.so" > loadmodule "registrar.so" > loadmodule "textops.so" > loadmodule "mi_fifo.so" > modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo") > modparam("usrloc", "db_mode", 0) > route{ > > # initial sanity checks -- messages with > # max_forwards==0, or excessively long requests > if (!mf_process_maxfwd_header("10")) { > sl_send_reply("483","Too Many Hops"); > exit; > }; > > if (msg:len >= 2048 ) { > sl_send_reply("513", "Message too big"); > exit; > }; > > # we record-route all messages -- to make sure that > # subsequent messages will go through our proxy; that's > # particularly good if upstream and downstream entities > # use different transport protocol > if (!method=="REGISTER") > record_route(); > > # subsequent messages withing a dialog should take the > # path determined by record-routing > if (loose_route()) { > # mark routing logic in request > append_hf("P-hint: rr-enforced\r\n"); > route(1); > }; > > > # if the request is for other domain use UsrLoc > # (in case, it does not work, use the following command > # with proper names and addresses in it) > if (uri==myself) { > > if (method=="REGISTER") { > > # Uncomment this if you want to use digest > authentication > #if (!www_authorize("openser.org", > "subscriber")) { > # www_challenge("openser.org", "0"); > # exit; > #}; > > save("location"); > exit; > }; > > lookup("aliases"); > if (!uri==myself) { > append_hf("P-hint: outbound alias\r\n"); > route(1); > }; > > # native SIP destinations are handled using our USRLOC DB > if (!lookup("location")) { > sl_send_reply("404", "Not Found"); > exit; > }; > append_hf("P-hint: usrloc applied\r\n"); > }; > > route(1); > } > > > route[1] { > # send it out now; use stateful forwarding as it works reliably > # even for UDP2TCP > if (!t_relay()) { > sl_reply_error(); > }; > exit; > } > > What should be a *normal* openser.cfg config file look like? > > Thanks > SW > > > ----- Original Message ---- > From: Norman Brandinger <norm(a)goes.com> > To: Live Great <livegreat007(a)yahoo.com> > Cc: users(a)openser.org > Sent: Monday, September 24, 2007 9:12:08 PM > Subject: Re: [OpenSER-Users] how to register xlite user for testing > with openser > > 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 <livegreat007(a)yahoo.com> > > To: Norman Brandinger <norm(a)goes.com> > > 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 <norm(a)goes.com> > > To: Live Great <livegreat007(a)yahoo.com> > > 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 <norm(a)goes.com> > > > To: Live Great <livegreat007(a)yahoo.com> > > > 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 <norm(a)goes.com> > > > > To: Live Great <livegreat007(a)yahoo.com> > > > > 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 <norm(a)goes.com> > > > > > To: Live Great <livegreat007(a)yahoo.com> > > > > > 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 <livegreat007(a)yahoo.com> > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >

2 2

Re: [OpenSER-Users] how to register xlite user for testing with openser
by Live Great 25 Sep '07

25 Sep '07

Now, I replaced the openser.cfg file with the one from the openser source. This openser.cfg does not have avp configuration. After restarted openser and registered xlite, dialed an off-line user number eg. 5678 shown "Call failed: Not Found" on the xlite panel. Openser does not write any error/wraning message to the system's log file. Is this normal? Here is the new configuration of the openser.cfg: listen = udp:127.0.0.1:5060 listen = udp:1x.x.x.x: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 # ------------------ module loading ---------------------------------- #set module path mpath="/usr/local/lib/openser/modules/" # Uncomment this if you want to use SQL database #loadmodule "mysql.so" loadmodule "sl.so" loadmodule "tm.so" loadmodule "rr.so" loadmodule "maxfwd.so" loadmodule "usrloc.so" loadmodule "registrar.so" loadmodule "textops.so" loadmodule "mi_fifo.so" modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo") modparam("usrloc", "db_mode", 0) route{ # initial sanity checks -- messages with # max_forwards==0, or excessively long requests if (!mf_process_maxfwd_header("10")) { sl_send_reply("483","Too Many Hops"); exit; }; if (msg:len >= 2048 ) { sl_send_reply("513", "Message too big"); exit; }; # we record-route all messages -- to make sure that # subsequent messages will go through our proxy; that's # particularly good if upstream and downstream entities # use different transport protocol if (!method=="REGISTER") record_route(); # subsequent messages withing a dialog should take the # path determined by record-routing if (loose_route()) { # mark routing logic in request append_hf("P-hint: rr-enforced\r\n"); route(1); }; # if the request is for other domain use UsrLoc # (in case, it does not work, use the following command # with proper names and addresses in it) if (uri==myself) { if (method=="REGISTER") { # Uncomment this if you want to use digest authentication #if (!www_authorize("openser.org", "subscriber")) { # www_challenge("openser.org", "0"); # exit; #}; save("location"); exit; }; lookup("aliases"); if (!uri==myself) { append_hf("P-hint: outbound alias\r\n"); route(1); }; # native SIP destinations are handled using our USRLOC DB if (!lookup("location")) { sl_send_reply("404", "Not Found"); exit; }; append_hf("P-hint: usrloc applied\r\n"); }; route(1); } route[1] { # send it out now; use stateful forwarding as it works reliably # even for UDP2TCP if (!t_relay()) { sl_reply_error(); }; exit; } What should be a *normal* openser.cfg config file look like? Thanks SW ----- Original Message ---- From: Norman Brandinger <norm(a)goes.com> To: Live Great <livegreat007(a)yahoo.com> Cc: users(a)openser.org Sent: Monday, September 24, 2007 9:12:08 PM Subject: Re: [OpenSER-Users] how to register xlite user for testing with openser 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 <livegreat007(a)yahoo.com> > To: Norman Brandinger <norm(a)goes.com> > 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 <norm(a)goes.com> > To: Live Great <livegreat007(a)yahoo.com> > 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 <norm(a)goes.com> > > To: Live Great <livegreat007(a)yahoo.com> > > 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 <norm(a)goes.com> > > > To: Live Great <livegreat007(a)yahoo.com> > > > 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 <norm(a)goes.com> > > > > To: Live Great <livegreat007(a)yahoo.com> > > > > 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 <livegreat007(a)yahoo.com> > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > >

2 1

← Newer
1
2
3
4
5
6
7
8
9
...
25
Older →

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

sr-users September 2007