Hi I am adding a subscriber and I get this error below:
/usr/local/sbin/openserctl add 100 100 100@localhost database engine 'PGSQL' loaded Control engine 'FIFO' loaded is_user: user counter=0 check_db_alias: alias counter= ERROR: user '100' already exists as alias
I am sure this user does not exist as I checked the table subscriber and there is only one row with user 'admin' Thanks mark
Hello,
are you using db aliases? Can you check dbaliases table?
Might be also because of return code from shell functions, what is your OS and shell?
Cheers, Daniel
On 03/18/07 05:35, rkmr.em@gmail.com wrote:
Hi I am adding a subscriber and I get this error below:
/usr/local/sbin/openserctl add 100 100 100@localhost database engine 'PGSQL' loaded Control engine 'FIFO' loaded is_user: user counter=0 check_db_alias: alias counter= ERROR: user '100' already exists as alias
I am sure this user does not exist as I checked the table subscriber and there is only one row with user 'admin' Thanks mark
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
On 3/18/07, Daniel-Constantin Mierla daniel@voice-system.ro wrote:
are you using db aliases? Can you check dbaliases table?
Can you tell how I can check this?
Might be also because of return code from shell functions, what is your OS and shell?
OS - Linux Fedora Core 5 Shell - Bash
On 03/18/07 22:12, rkmr.em@gmail.com wrote:
On 3/18/07, Daniel-Constantin Mierla daniel@voice-system.ro wrote:
are you using db aliases? Can you check dbaliases table?
Can you tell how I can check this?
if you load alias db module and do alias_db_lookup() in config script.
also, the openserctlrc should have ALIASES_TYPE="DB"
Cheers, Daniel
Might be also because of return code from shell functions, what is your OS and shell?
OS - Linux Fedora Core 5 Shell - Bash
Hi Thanks for your reply. I do not load alias db module. and There is no alias_db_lookup() in my config script. Here is the config: thanks
# # $Id: openser.cfg 1827 2007-03-12 15:22:53Z bogdan_iancu $ # # simple quick-start config script # Please refer to the Core CookBook at http://www.openser.org/dokuwiki/doku.php # for a explanation of possible statements, functions and parameters. #
# ----------- global configuration parameters ------------------------ debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=no # (cmd line: -E) children=4
# Uncomment these lines to enter debugging mode #fork=no #log_stderror=yes #
port=5060
# uncomment the following lines for TLS support #disable_tls = 0 #listen = tls:your_IP:5061 #tls_verify_server = 1 #tls_verify_client = 1 #tls_require_client_certificate = 0 #tls_method = TLSv1 #tls_certificate = "/usr/local/etc/openser/tls/user/user-cert.pem" #tls_private_key = "/usr/local/etc/openser/tls/user/user-privkey.pem" #tls_ca_list = "/usr/local/etc/openser/tls/user/user-calist.pem"
# ------------------ module loading ----------------------------------
#set module path mpath="/usr/local/lib/openser/modules/"
# Uncomment this if you want to use SQL database loadmodule "postgres.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" loadmodule "xlog.so"
# Uncomment this if you want digest authentication # mysql.so must be loaded ! #loadmodule "auth.so" #loadmodule "auth_db.so"
# ----------------- setting module-specific parameters ---------------
# -- mi_fifo params --
modparam("mi_fifo", "fifo_name", "/tmp/openser_fifo")
# -- usrloc params --
modparam("usrloc", "db_mode", 0) modparam("usrloc", "db_url", "postgres://postgres:community@localhost:5432/voip")
log_facility=LOG_LOCAL7 modparam("xlog", "buf_size", 8192)
# Uncomment this if you want to use SQL database # for persistent storage and comment the previous line #modparam("usrloc", "db_mode", 2)
# -- auth params -- # Uncomment if you are using auth module # #modparam("auth_db", "calculate_ha1", yes) # # If you set "calculate_ha1" parameter to yes (which true in this config), # uncomment also the following parameter) # #modparam("auth_db", "password_column", "password")
# -- rr params -- # add value to ;lr param to make some broken UAs happy modparam("rr", "enable_full_lr", 1)
# ------------------------- request routing logic -------------------
# main routing logic
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 (!uri==myself) { # mark routing logic in request append_hf("P-hint: outbound\r\n"); # if you have some interdomain connections via TLS #if(uri=~"@tls_domain1.net") { # t_relay("tls:domain1.net"); # exit; #} else if(uri=~"@tls_domain2.net") { # t_relay("tls:domain2.net"); # exit; #} 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; }
On 3/18/07, Daniel-Constantin Mierla daniel@voice-system.ro wrote:
On 03/18/07 22:12, rkmr.em@gmail.com wrote:
On 3/18/07, Daniel-Constantin Mierla daniel@voice-system.ro wrote:
are you using db aliases? Can you check dbaliases table?
Can you tell how I can check this?
if you load alias db module and do alias_db_lookup() in config script.
also, the openserctlrc should have ALIASES_TYPE="DB"
Cheers, Daniel
Might be also because of return code from shell functions, what is your OS and shell?
OS - Linux Fedora Core 5 Shell - Bash