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

Markus Maria Miedaner markusmiedaner at googlemail.com
Sun Sep 23 09:28:56 CEST 2007


On Sat, Sep 22, 2007 at 11:45:50PM -0700, you (Live Great) wrote:
> Thanks for your suggestion.
> I don't wanna mess up the package in freebsd.
> Actually when I added the colnum uuid, my xlite program is able to register
> with the default admin user in the 'subscriber' table.
> I also used openserctl created my account name with password, but in the
> subscriber table, I found the phone number field is empty.
> Do you know how to create a phone number for a newly created user account?
> eg. openserctl sam passwd sam at my.dot.com
> create my openser account, but how to add a phone number to my account?
> 
> Thanks
> SW
> 

HI SW,

you can add user by using openserctl add username userpassword useremail
this works perfectly on my linux box.....

cheers,
markus



> ----- Original Message ----
> From: Norman Brandinger <norm at goes.com>
> To: Live Great <livegreat007 at yahoo.com>
> Sent: Sunday, September 23, 2007 1:42:18 PM
> Subject: Re: [OpenSER-Users] how to register xlite user for testing with
> openser
> 
> It's possible that openserdbctl is only available on the development
> versions.  I've found that the current development version is very
> stable and you might want to give it a try.
> 
> If you are going to stay with 1.2.2, then you might want to try dropping
> the openser database, then recreate it and keep a close eye out for any
> errors.  After the database has been rebuilt, check the subscriber
> table.  I believe it used to have a uuid column (the current development
> version does not have a uuid column).
> 
> The ha1 field is the encrypted password and is probably used in your
> config during the registration of your xlite phones.  Without a
> successful registration, it's unlikely you will be able to complete any
> calls.
> 
> A quick look at the database structures from the online doc at:
> http://openser.org/dokuwiki/doku.php shows that the subscriber table had
> a uuid column in 1.0.x, but in 1.2.x that column is gone.  Is it
> possible that the openser database was created with version 1.2.x but
> you are running openser 1.0.x ?
> 
> Regards,
> Norm
> 
> 
> Live Great wrote:
> > Hi,
> >
> > The openser version in freebsd is the latest one I got:
> >  # openser -V
> > version: openser 1.2.2-notls (i386/freebsd)
> >
> > Is this the correct version for getting openserdbctl ?
> >
> > Thanks
> > SW
> >
> > ----- Original Message ----
> > From: Norman Brandinger <norm at goes.com>
> > To: Live Great <livegreat007 at 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 at goes.com>
> > > To: Live Great <livegreat007 at yahoo.com>
> > > Cc: users at 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 at yahoo.com>
> > > > To: users at 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 at 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 at openser.org
> > > > http://openser.org/cgi-bin/mailman/listinfo/users
> > > >  
> > >
> > >
> >
> >
> 
> 

> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users


-- 
 ______________________________________
/ I give presents to the mother, but I \
\ think of the daughter.               /
 --------------------------------------
   \
    \
        .--.
       |o_o |
       |:_/ |
      //   \ \
     (|     | )
    /'\_   _/`\
    \___)=(___/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.kamailio.org/pipermail/users/attachments/20070923/dca9c58f/attachment.pgp 


More information about the Users mailing list