[Serusers] mySQL

[Jan Janak]

Gary,

this script authenticates only REGISTERs. That means it will make sure
that only authorized users can register with your server. INVITEs are
not authenticated, that means if you try to call someone no
authentication will be performed.
  
  Jan.

On 07-05 04:29, Gary Goodloff wrote:
> I finnaly have this thing in and running. I can make a call to another
> person on the same server. But it appears that it is not checking a
> password.  I have everything configured the way all the how-to's say for
> mysql authentication - but I am at a loss.
>  
> Also  it does not appear to be supporting accounting (missed calls).
>  
> Can anyone help?
>  
> Here is my ser.cfg file.
>  
> #
> # $Id: ser.cfg,v 1.12 2002/10/21 02:40:06 jiri Exp $
> #
> # simple quick-start config script
> #
>  
> # ----------- global configuration parameters ------------------------
>  
> debug=3          # debug level (cmd line: -dddddddddd)
> fork=yes
> log_stderror=yes        # (cmd line: -E)
> check_via=no    # (cmd. line: -v)
> dns=yes           # (cmd. line: -r)
> rev_dns=yes      # (cmd. line: -R)
> port=5060
> children=4
> fifo="/tmp/ser_fifo"
>  
> # ------------------ module loading ----------------------------------
>  
> # Uncomment this if you want to use SQL database
> loadmodule "/usr/local/lib/ser/modules/mysql.so"
>  
> loadmodule "/usr/local/lib/ser/modules/sl.so"
> loadmodule "/usr/local/lib/ser/modules/tm.so"
> loadmodule "/usr/local/lib/ser/modules/rr.so"
> loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
> loadmodule "/usr/local/lib/ser/modules/usrloc.so"
> loadmodule "/usr/local/lib/ser/modules/registrar.so"
>  
> # Uncomment this if you want digest authentication
> # mysql.so must be loaded !
> loadmodule "/usr/local/lib/ser/modules/auth.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)
>  
> # -- auth params --
>                                                            [ Read 105
> lines ]
>  
> root: /www/kalgonline/ser % cat/usr/local/etc/ser/ser.cfg
> cat/usr/local/etc/ser/ser.cfg: Command not found.
> root: /www/kalgonline/ser % cat /usr/local/etc/ser/ser.cfg
> #
> # $Id: ser.cfg,v 1.12 2002/10/21 02:40:06 jiri Exp $
> #
> # simple quick-start config script
> #
>  
> # ----------- global configuration parameters ------------------------
>  
> debug=3          # debug level (cmd line: -dddddddddd)
> fork=yes
> log_stderror=yes        # (cmd line: -E)
> check_via=no    # (cmd. line: -v)
> dns=yes           # (cmd. line: -r)
> rev_dns=yes      # (cmd. line: -R)
> port=5060
> children=4
> fifo="/tmp/ser_fifo"
>  
> # ------------------ module loading ----------------------------------
>  
> # Uncomment this if you want to use SQL database
> loadmodule "/usr/local/lib/ser/modules/mysql.so"
>  
> loadmodule "/usr/local/lib/ser/modules/sl.so"
> loadmodule "/usr/local/lib/ser/modules/tm.so"
> loadmodule "/usr/local/lib/ser/modules/rr.so"
> loadmodule "/usr/local/lib/ser/modules/maxfwd.so"
> loadmodule "/usr/local/lib/ser/modules/usrloc.so"
> loadmodule "/usr/local/lib/ser/modules/registrar.so"
>  
> # Uncomment this if you want digest authentication
> # mysql.so must be loaded !
> loadmodule "/usr/local/lib/ser/modules/auth.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)
>  
> # -- auth params --
> # Uncomment if you are using auth module
> #
> modparam("auth", "secret", "alsdkhglaksdhfkloiwr")
> modparam("auth", "calculate_ha1", yes)
> #
> # If you set "calculate_ha1" parameter to yes (which true in this
> config),
> # uncomment also the following parameter)
> #
> modparam("auth", "password_column", "password")
>  
> # -------------------------  request routing logic -------------------
>  
> # main routing logic
>  
> route{
>  
>         # initial sanity checks -- messages with
>         # max_forwars==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
>         rewriteFromRoute();
>  
>         # 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=="kalg.net") {
>  
>                 if (method=="REGISTER") {
>  
> # Uncomment this if you want to use digest authentication
>                         if (!www_authorize("kalg.net", "subscriber")) {
>                                 www_challenge("kalg.net", "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();
>         };
>  
> }
>  
> Gary Goodloff
> KALG Communications / Nebraska Classifieds
> T: 402-898-4152
> C: 402-208-5183
> F: 413-294-3404
>  
>  
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20030507/8ee6b157/attachment.pgp>