23 Sep
2007
23 Sep
'07
noon
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
23 Sep
23 Sep
3:50 p.m.
New subject: [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
6270
days inactive
6270
days old
1 comments
2 participants
participants (2)
-
Live Great -
Norman Brandinger