[OpenSIPS-Users] Problems with DB_TEXT

[discodog62 at aol.com]

I figured it out.  I needed to escape the ":"  like so \:





-----Original Message-----
From: discodog62 <discodog62 at aol.com>
To: users <users at lists.opensips.org>
Sent: Tue, Jan 10, 2012 5:14 am
Subject: [OpenSIPS-Users] Problems with DB_TEXT


I am trying to just use DB_TEXT.  When I start opensips I get this error.  I am using opensips 1.7 on archlinux 64bit.



ERROR:db_text:dbt_query: table does not exist!
ERROR:domain:reload_domain_table: Error while querying database
ERROR:db_text:dbt_query: table does not exist!
ERROR:drouting:dr_load_routing_info: DB query failed
ERROR:core:init_mod_child: failed to initializing module drouting, rank 1
ERROR:core:main_loop: init_child failed for UDP listener





Here is the top of my config.





loadmodule "db_text.so"
loadmodule "signaling.so"
loadmodule "sl.so"
loadmodule "tm.so"
loadmodule "rr.so"
loadmodule "maxfwd.so"
loadmodule "usrloc.so"
loadmodule "dialog.so"
loadmodule "registrar.so"
loadmodule "textops.so"
loadmodule "mi_fifo.so"
loadmodule "uri.so"
loadmodule "acc.so"
loadmodule "alias_db.so"
loadmodule "domain.so"
loadmodule "permissions.so"
loadmodule "rtpproxy.so"
loadmodule "drouting.so"


modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")


modparam("rr", "append_fromtag", 0)


modparam("uri", "use_uri_table", 0)


modparam("alias_db", "db_url","text:///zxa/opensipsdb")


modparam("domain", "db_url","text:///zxa/opensipsdb")
modparam("domain", "db_mode", 1)   # Use caching
modparam("domain", "domain_table", "domain")
modparam("domain", "domain_col", "domain")


modparam("dialog", "db_mode", 1)
modparam("dialog", "db_url", "text:///zxa/opensipsdb")
modparam("dialog", "default_timeout", 90)


modparam("drouting", "use_domain", 1)
modparam("drouting","db_url", "text:///zxa/opensipsdb")


modparam("permissions", "db_url","text:///zxa/opensipsdb")



I set the file and folder permissions for  /zxa/opensipsdb to 777.  


I grabbed the database files from the opensips 1.7 media


Is there a step that I am missing




Thanks,


James




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

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20120110/dbebe958/attachment.htm>