[Users] Dbtext module problem

Daniel-Constantin Mierla daniel at voice-system.ro
Sat Jun 25 10:06:11 CEST 2005


Hello,

the db_url parameters must include the name of the database driver (same 
as module name) to use:

so you must have

modparam("usrloc", "db_url", "dbtext:///home/alexandre/Devel/openser-0.9.4/bin/dbtext")

where /home/alexandre/Devel/openser-0.9.4/bin/dbtext is the directory where the files representing the tables are stored.

See the README file, there you will find some examples of tables and config file. You can browse online the cvs at:
http://cvs.sourceforge.net/viewcvs.py/openser/sip-server/modules/dbtext/README?rev=1.1.1.1&only_with_tag=MAIN&view=auto

Best regards,
Daniel



On 06/25/05 04:07, Alexandre Passito wrote:

>Hi everybody,
>
>I was trying to install dbtext module, but i got the following error:
>
> 0(0) unixsock_register_cmd: New command (ul_stats) registered
> 0(0) unixsock_register_cmd: New command (ul_rm) registered
> 0(0) unixsock_register_cmd: New command (ul_rm_contact) registered
> 0(0) unixsock_register_cmd: New command (ul_dump) registered
> 0(0) unixsock_register_cmd: New command (ul_flush) registered
> 0(0) unixsock_register_cmd: New command (ul_add) registered
> 0(0) unixsock_register_cmd: New command (ul_show_contact) registered
> 0(0) find_mod_export: <db_use_table> in module
>/home/alexandre/Devel/openser-0.9.4/bin/dbtext not found
> 0(0) bind_dbmod: Module
>/home/alexandre/Devel/openser-0.9.4/bin/dbtext does not export
>db_use_table function
> 0(0) ERROR: mod_init(): Can't bind database module
> 0(0) init_mod(): Error while initializing module usrloc
>ERROR: error while initializing modules
> 0(0) DEBUG: tm_shutdown : start
> 0(0) DEBUG: unlink_timer_lists : emptying DELETE list
> 0(0) DEBUG: tm_shutdown : emptying hash table
> 0(0) DEBUG: tm_shutdown : releasing timers
> 0(0) DEBUG: tm_shutdown : removing semaphores
> 0(0) DEBUG: tm_shutdown : destroying tmcb lists
> 0(0) DEBUG: tm_shutdown : done
> 0(0) DBT:destroy ...
> 0(24535) shm_mem_destroy
> 0(24535) destroying the shared memory lock
>
>
>
>the openser.cfg is:
>
>#
># $Id: ser.cfg,v 1.21.4.1 2003/11/10 15:35:15 andrei Exp $
>#
># simple quick-start config script
>#
>
># ----------- global configuration parameters ------------------------
>
>#debug=3         # debug level (cmd line: -dddddddddd)
>#fork=yes
>#log_stderror=no        # (cmd line: -E)
>
># Uncomment these lines to enter debugging mode
>debug=7
>fork=no
>log_stderror=yes
>
>
>check_via=no    # (cmd. line: -v)
>dns=no           # (cmd. line: -r)
>rev_dns=no      # (cmd. line: -R)
>#port=5060
>#children=4
>fifo="/tmp/ser_fifo"
>
># ------------------ module loading ----------------------------------
>
># Uncomment this if you want to use SQL database
>#loadmodule "/home/alexandre/Devel/ser-0.8.14/bin//lib/ser/modules/mysql.so"
>
>loadmodule "/home/alexandre/Devel/openser-0.9.4/bin//lib/openser/modules/dbtext.so"
>loadmodule "/home/alexandre/Devel/openser-0.9.4/bin//lib/openser/modules/sl.so"
>loadmodule "/home/alexandre/Devel/openser-0.9.4/bin//lib/openser/modules/tm.so"
>loadmodule "/home/alexandre/Devel/openser-0.9.4/bin//lib/openser/modules/rr.so"
>loadmodule "/home/alexandre/Devel/openser-0.9.4/bin//lib/openser/modules/maxfwd.so"
>loadmodule "/home/alexandre/Devel/openser-0.9.4/bin//lib/openser/modules/usrloc.so"
>
>
>loadmodule "/home/alexandre/Devel/openser-0.9.4/bin//lib/openser/modules/registrar.so"
>loadmodule "/home/alexandre/Devel/openser-0.9.4/bin//lib/openser/modules/avpops.so"
>
># Uncomment this if you want digest authentication
># mysql.so must be loaded !
>
>loadmodule "/home/alexandre/Devel/openser-0.9.4/bin//lib/openser/modules/auth.so"
>loadmodule "/home/alexandre/Devel/openser-0.9.4/bin//lib/openser/modules/auth_db.so"
>
># ----------------- setting module-specific parameters ---------------
>
># -- usrloc params --
>
>modparam("usrloc", "db_url", "/home/alexandre/Devel/openser-0.9.4/bin/dbtext")
>modparam("usrloc", "db_mode", 2)
>
>modparam("auth_db", "db_url", "/home/alexandre/Devel/openser-0.9.4/bin/dbtext")
>modparam("auth_db", "calculate_ha1", yes)
>modparam("auth_db", "password_column", "password")
>
>
>
># 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");
>                break;
>        };
>        if ( msg:len > max_len ) {
>                sl_send_reply("513", "Message too big");
>                break;
>        };
>
>        # 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
>        record_route();
>        # loose-route processing
>
>(...)
>
>
>Any Help?
>
>
>Best regards,
>
>
>
>  
>




More information about the Users mailing list