[Users] local mysql access problem cont'd
Bogdan-Andrei Iancu
bogdan at voice-system.ro
Wed Dec 7 16:22:22 CET 2005
Hi Rick,
the error is generated by usrloc module - your script does not set the
db_url for this module. Try to disable the DB support:
modparam("usrloc", "db_mode", 0)
or to set the db_url:
modparam("usrloc", "db_url", "mysql://serusr:testpass@192.168.0.54/ser")
regards,
bogdan
rick at eltopia.com wrote:
>Alright.. here is some dbg level 9 output of my problem. Basically openser starts, says it starts successfully, and then quits. I think it may have something to do with the fact that it is trying to access a local database even though it has been configured to access a remote one. I am quite sure that it is accessing the proper cfg, cause when I put garbage in it I get an error.
>Any help, clues, snide remarks, cryptic-guru-riddle-answers would be appreciated.
>
>Dec 1 11:48:41 amnesiac openser: 0(0) db_init: Connection 'mysql://openser:openserrw@localhost
>/openser' not found in pool
>Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Opening MySQL connection: mysql://opense
>r:openserrw at localhost/openser
>Dec 1 11:48:41 amnesiac openser: 0(0) new_connection: Can't connect to local MySQL server thro
>ugh socket '/var/lib/mysql/mysql.sock' (2)
>Dec 1 11:48:41 amnesiac openser: 0(0) register_udomain(): Can not open database connection
>Dec 1 11:48:41 amnesiac openser: 0(0) domain_fixup(): Error while registering domain
>Dec 1 11:48:41 amnesiac openser: ERROR: error -1 while trying to fix configuration
>Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : start
>Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: unlink_timer_lists : emptying DELETE list
>Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : emptying hash table
>Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : releasing timers
>Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : removing semaphores
>Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : destroying tmcb lists
>Dec 1 11:48:41 amnesiac openser: 0(0) DEBUG: tm_shutdown : done
>Dec 1 11:48:41 amnesiac openser: 0(3791) shm_mem_destroy
>Dec 1 11:48:41 amnesiac openser: 0(3791) destroying the shared memory lock
>Dec 1 11:48:41 amnesiac openser: openser startup succeeded
>
>
>my config file is simply the sample config, modified with the suggestions to access a remote mysql database, it looks like this:
>
>#
># $Id: openser.cfg,v 1.5 2005/10/28 19:45:33 bogdan_iancu Exp $
>#
># simple quick-start config script
>#
>
># ----------- global configuration parameters ------------------------
>
>debug=9 # debug level (cmd line: -dddddddddd)
>fork=yes
>log_stderror=yes # (cmd line: -E)
>
>/* Uncomment these lines to enter debugging mode
>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/openser_fifo"
># Uncomment this if you want to use SQL database
>loadmodule "//lib/openser/modules/mysql.so"
>
>loadmodule "//lib/openser/modules/sl.so"
>loadmodule "//lib/openser/modules/tm.so"
>loadmodule "//lib/openser/modules/rr.so"
>loadmodule "//lib/openser/modules/maxfwd.so"
>loadmodule "//lib/openser/modules/usrloc.so"
>loadmodule "//lib/openser/modules/registrar.so"
>loadmodule "//lib/openser/modules/textops.so"
>
># Uncomment this if you want digest authentication
># mysql.so must be loaded !
>loadmodule "//lib/openser/modules/auth.so"
>loadmodule "//lib/openser/modules/auth_db.so"
>
># ----------------- setting module-specific parameters ---------------
>
>modparam("auth_db", "db_url", "mysql://serusr:testpass@192.168.0.54/ser")
>
># -- usrloc params --
>
>#modparam("usrloc", "db_mode", 0)
>
># 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_to_tls("IP_domain1","port_domain1");
> # exit;
> #} else if(uri=~"@tls_domain2.net") {
> # t_relay_to_tls("IP_domain2","port_domain2");
> # 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;
>}
>
>
>
>_______________________________________________
>Users mailing list
>Users at openser.org
>http://openser.org/cgi-bin/mailman/listinfo/users
>
>
>
More information about the sr-users
mailing list