[Serusers] Alternative to Mysql?
Jan Janak
jan at iptel.org
Thu Mar 13 01:53:54 CET 2003
Sorry, auth was excluded from compilation by default.
Either update sip_router/Makefile from the repository
or edit sip_router/Makefile, look for line containing excluded_modules,
remove auth from it and do again make all.
Jan.
PS: Please CC the mailing list too.
On 12-03 16:39, David Beckemeyer wrote:
>
> Thanks for your help.
>
> For some reason modules/auth/auth.so didn't get built so that ser.cfg
> doesn't start.
>
> ser: ERROR: load_module: could not open module <./modules/auth/auth.so>: ./modules/auth/auth.so: cannot open shared object file: No such file or directory
> ser: parse error (40,13-36): failed to load module
> ser: parse error (92,26-27): unknown command, missing loadmodule?
> ser: INFO: signal 15 received
>
> It looks like the Makefile nevver tried to build that module.
>
> Other modules got built, as follows:
> modules/acc/acc.so
> modules/auth_db/auth_db.so
> modules/dbtext/dbtext.so
> modules/domain/domain.so
> modules/enum/enum.so
> modules/exec/exec.so
> modules/group/group.so
> modules/maxfwd/maxfwd.so
> modules/pike/pike.so
> modules/print/print.so
> modules/registrar/registrar.so
> modules/rr/rr.so
> modules/sl/sl.so
> modules/textops/textops.so
> modules/tm/tm.so
> modules/uri/uri.so
> modules/usrloc/usrloc.so
> modules/vm/vm_mod.so
>
> On Thu, Mar 13, 2003 at 01:15:26AM +0100, Jan Janak wrote:
> > 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 at lists.iptel.org
> > > > >http://lists.iptel.org/mailman/listinfo/serusers
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > Serusers mailing list
> > > > serusers at lists.iptel.org
> > > > http://lists.iptel.org/mailman/listinfo/serusers
> > > _______________________________________________
> > > Serusers mailing list
> > > serusers at 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
> >
>
>
>
More information about the sr-users
mailing list