Re: [Serusers] Alternative to Mysql?

Hello David, attached please find updated ser.cfg with authentication enabled using plaintext files instead of mysql. Do the following: 1) Get the latest CVS snapshot (yes, again) 2) Compile it, but do not install it (don't do make install) 3) Create a directory where your plaintext files containing database tables will be stored 4) Put attached "subscriber" and "location" files in the directory 5) Edit attached ser.cfg 6) Replace /home/janakj/ser with path to the directory (2 occurrencies) 7) save ser.cfg in sip_router directory (the CVS snaphot) 7) Edit subscriber and replace jan with your username, heslo with your password and iptel.org with your domain 8) cd sip_router 9) ./ser -f ser.cfg Please report any problems to us. Jan. PS: See sip_router/modules/dbtext/Readme for description of format of the plaintext files. On 12-03 13:57, David Beckemeyer wrote: > > Unstable indeed. I built SER from CVS and even using the > stock (no DB) ser.cfg, it won't start, and reports: > > ERROR: bad config file (16 errors) > > ser: parse error (36,13-47): failed to load module > ser: set_mod_param(): Parameter not found > ser: parse error (46,34-35): Can't set module parameter > ser: parse error (70,36-37): unknown command, missing loadmodule? > ser: parse error (71,38-39): unknown command, missing loadmodule? > ser: parse error (75,41-42): unknown command, missing loadmodule? > ser: parse error (80,19-20): unknown command, missing loadmodule? > ser: parse error (95,19-20): unknown command, missing loadmodule? > ser: parse error (100,25-26): unknown command, missing loadmodule? > ser: parse error (101,36-37): unknown command, missing loadmodule? > ser: parse error (106,15-16): unknown command, missing loadmodule? > ser: parse error (107,18-19): unknown command, missing loadmodule? > ser: INFO: signal 15 received > > On Wed, Mar 12, 2003 at 08:40:04PM +0100, Daniel-Constantin MIERLA wrote: > > > > > > Hello, > > see dbtext for that. But notice that the module has not been thoroughly > > tested. It is not included in v0.8.10 so you have to use a CVS snapshot > > which is quite unstable these days due to lots of changes. If you want > > to use it before the new release of ser is out you might get weird > > situations, but you can provide us some help with testing ... It is your > > choice ... > > > > -.- > > Best regards, > > Daniel > > > > > > David Beckemeyer wrote: > > > > >I'm trying to get SER up and I need auth. I'm not a Mysql user > > >and, frankly, I'd rather not need to learn it, just to get > > >authentication support. I wish there were a middle-ground > > >between no-auth at all and a full-blown Mysql installation. > > > > > >I tried the Cookbook approach, using Dan Austin's HOWTO for > > >setting up Mysql for SER, but the commands do not work as shown > > >so I'm left with learning Mysql through and through to debug > > >why those cookbook commands don't work. > > > > > >I'm very familiar with SIP and I want to test SER, not a new Sql > > >server DB engine. It seems like Mysql is a distraction to that > > >effort. > > > > > >Is anyone working on something like a flat-file module to > > >replace Mysql? Any pointers for the best place to start on > > >developing such a module (i.e. shortcuts)? > > > > > >Thanks, > > > > > > - david > > > > > >_______________________________________________ > > >Serusers mailing list > > >serusers(a)lists.iptel.org > > >http://lists.iptel.org/mailman/listinfo/serusers > > > > > > > > > > > > > > > > > _______________________________________________ > > Serusers mailing list > > serusers(a)lists.iptel.org > > http://lists.iptel.org/mailman/listinfo/serusers > _______________________________________________ > Serusers mailing list > serusers(a)lists.iptel.org > http://lists.iptel.org/mailman/listinfo/serusers

# # $Id: dbtext.cfg,v 1.2 2003/03/13 00:07:28 janakj Exp $ # # simple quick-start config script # # ----------- global configuration parameters ------------------------ debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=no # (cmd line: -E) /* 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 "./modules/dbtext/dbtext.so" loadmodule "./modules/sl/sl.so" loadmodule "./modules/tm/tm.so" loadmodule "./modules/rr/rr.so" loadmodule "./modules/maxfwd/maxfwd.so" loadmodule "./modules/usrloc/usrloc.so" loadmodule "./modules/registrar/registrar.so" # Uncomment this if you want digest authentication # mysql.so must be loaded ! loadmodule "./modules/auth/auth.so" loadmodule "./modules/auth_db/auth_db.so" # ----------------- setting module-specific parameters --------------- # -- 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", 1) modparam("usrloc", "db_url", "/home/janakj/ser") modparam("auth_db", "db_url", "/home/janakj/ser") # -- 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") # ------------------------- 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 (len_gt( max_len )) { sl_send_reply("513", "Message too big"); break; }; # Do strict routing if pre-loaded route headers present loose_route(); # 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") { if (!www_authorize("", "subscriber")) { www_challenge("", "0"); break; }; save("location"); break; }; # native SIP destinations are handled using our USRLOC DB if (!lookup("location")) { sl_send_reply("404", "Not Found"); break; }; }; # forward to current uri now if (!t_relay()) { sl_reply_error(); }; }

user(str) contact(str) expires(int) q(double) callid(str) cseq(int)

username(str) password(str) ha1(str) domain(str) ha1b(str) jan:heslo:xxx:iptel.org:xxx