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#subscriberThere 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.htmlThe 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@goes.com>
> To: Live Great <livegreat007@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@goes.com>
> > To: Live Great <livegreat007@yahoo.com>
> > Cc: users@openser.org
> > Sent: Saturday, September 22, 2007 9:43:54 PM
> > Subject: Re: [OpenSER-Users] how to register xlite user for testing
> > with openser
> >
> > Is is possible that you turned on database support but forgot to make
> > the database tables ? The error message you posted is pretty explicit:
> > "Unknown column"....
> > I used openser_mysql.sh create to populate openser database and its
> > tables.
> > Here is all its tables:
> > mysql> show tables;
> > +-----------------------+
> > | Tables_in_openser |
>
> +-----------------------+
> > | acc |
> > | active_sessions |
> > | active_watchers |
> > | address |
> > | admin_privileges |
> > | aliases |
> > | cpl |
> > | dbaliases |
> > | domain |
> > |
domainpolicy |
> > | grp |
> > | gw |
> > | gw_grp |
> > | imc_members |
> > | imc_rooms |
> > | lcr |
> > | location |
> > |
missed_calls |
> > | pdt |
> > | pending |
> > | phonebook |
> > | presentity |
> > | pua |
> > | re_grp |
> > | server_monitoring |
> > | server_monitoring_agg |
> > |
silo |
> > | sip_trace |
> > | speed_dial |
> > | subscriber |
> > | trusted |
> > | uri |
> > | usr_preferences |
> > | usr_preferences_types |
> > | version |
> > |
watchers |
> > | xcap_xml |
> > +-----------------------+
> > 37 rows in set (0.00 sec)
> >
> >
> >
> > The warnings about missing permissions files can be ignored (unless you
> > really do need them), but in your case, it seems that you are not at
> > that point yet.
> >
> > Take a look at openserdbctl as it automates the process of creating the
> > database and tables needed by the various openser modules. openserctlrc
> > (usually located in /usr/local/etc/openser) contains a number of startup
> > settings, some of which are database related.
> >
> > The standard request you will receive from people trying to assist you
> > is
to post your config file (or at least the interesting sections of
> it).
> >
> > The part of the content of openser.cfg is:
> > listen = udp:127.0.0.1:5060
> > listen = udp:125.255.1.2:5060
> > mpath = "/usr/local/lib/openser/modules"
> > children = 8
> > debug = 3
> > fork = yes
> > group = "openser"
> > user = "openser"
> > disable_tcp = no
> > log_facility = LOG_DAEMON
> > #log_facility = LOG_LOCAL7
> > log_stderror = no
> > tcp_children = 4
> > mhomed = no
> > server_signature = yes
> > sock_group = "openser"
> > sock_mode = 0600
> > sock_user = "openser"
> > unix_sock = "/tmp/openser.sock"
> > unix_sock_children = 1
> > reply_to_via = no
> > sip_warning = no
> > check_via = no
> > dns = no
> > rev_dns =
no
> > disable_core_dump = no
> > dns_try_ipv6 = yes
> > dns_use_search_list = yes
> >
> > openserctlrc:
> > ## your SIP domain
> > SIP_DOMAIN=ip6.com.au
> >
> > ## database type: MYSQL or PGSQL, by defaulte none is loaded
> > DBENGINE=MYSQL
> >
> > ## database host
> > DBHOST=localhost
> >
> > ## database name
> > DBNAME=openser
> >
> > ## database read/write user
> > DBRWUSER=openser
> > # DBRWUSER=admin
> >
> > ## database read only user
> > DBROUSER=openserro
> >
> > ## password for database read only user
> > DBROPW=openserro
> >
> > ## database super user
> > DBROOTUSER="root"
> >
>
> HAS_SERWEB="yes"
> >
> > I am not too sure the correct way to define openserctlrc file..
> > Your comment is much appreciated.
> >
> > Thanks
> > SW
> >
> > Norm
> >
> > Live Great wrote:
> > > Hi,
> > >
> > > After changed the port 5077 to 5060 in openser.cfg file, restarted
> > > openser.
> > > When xlite initiate a registartion request, openser system log file
> > > shown a different message:
> > > Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: Default allow
> > > file (/usr/local/etc/openser/permissions.allow) not found => empty
> > > rule set
> > > Sep 22 16:18:55 core /usr/local/sbin/openser[49941]: WARNING: File not
> > > found: /usr/local/etc/openser/permissions.deny
> > > Sep 22 16:18:55
core /usr/local/sbin/openser[49941]: Default deny file
> > > (/usr/local/etc/openser/permissions.deny) not found => empty rule set
> > > Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:01 core /usr/local/sbin/openser[49953]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:04 core /usr/local/sbin/openser[49956]: get_ha1(): Error
> > > while querying database
> > > Sep
22 16:19:06 core /usr/local/sbin/openser[49957]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:06 core /usr/local/sbin/openser[49957]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:08 core /usr/local/sbin/openser[49952]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:08 core
/usr/local/sbin/openser[49954]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:08 core /usr/local/sbin/openser[49954]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:09 core /usr/local/sbin/openser[49955]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:11 core /usr/local/sbin/openser[49957]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:11 core /usr/local/sbin/openser[49957]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:11 core /usr/local/sbin/openser[49957]:
get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:13 core /usr/local/sbin/openser[49959]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:14 core /usr/local/sbin/openser[49952]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: submit_query:
> > > Unknown
column 'uuid' in 'field list'
> > > Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:16 core /usr/local/sbin/openser[49954]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:16 core /usr/local/sbin/openser[49955]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: db_query: Error
> > > while submitting query
>
> > Sep 22 16:19:21 core /usr/local/sbin/openser[49957]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:22 core /usr/local/sbin/openser[49952]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:29 core /usr/local/sbin/openser[49954]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:42 core
/usr/local/sbin/openser[49956]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:42 core /usr/local/sbin/openser[49956]: get_ha1(): Error
> > > while querying database
> > > Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: submit_query:
> > > Unknown column 'uuid' in 'field list'
> > > Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: db_query: Error
> > > while submitting query
> > > Sep 22 16:19:46 core /usr/local/sbin/openser[49958]: get_ha1(): Error
> > > while querying database
> > >
> > > In Xlite, it said Registration error 500, server internal error.
> > > What is possibility wrong in my openser server configuration?
> > >
>
> >
> > > Thanks
> > > SW
> > >
> > > ----- Original Message ----
> > > From: Live Great <livegreat007@yahoo.com>
> > > To: users@openser.org
> > > Sent: Saturday, September 22, 2007 2:03:07 PM
> > > Subject: [OpenSER-Users] how to register xlite user for testing with
> > > openser
> > >
> > > Hi,
> > >
> > > I used the following command to add xlite user, but xlite failed to
> > > register the user in openser server.
> > > # openserctl add 1234 1234 sam@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@openser.org
> > >
http://openser.org/cgi-bin/mailman/listinfo/users> > >
> >
> >
>
>