[Serusers] Is it possible to configure SER to authenticate from a third party db table?

Gareth Holly garethholly at yahoo.com.au
Thu Aug 11 02:05:15 CEST 2005


Hi Jan, 
       I'm getting the following errors in the log
now:

auth_db:str_fixup(): Invalid table version (use
ser_mysql.sh reinstall)

ERROR: fix_expr : fix_actions error

I'm running Version 0.9.3 of SER

Thanks,

Gareth



--- Jan Janak <jan at iptel.org> wrote:

> OK, you need to reconfigure auth_db module:
> 
> modparam("auth_db", "db_url",
> "mysql://username:password@host/SIPDB")
> modparam("auth_db", "use_domain", 0)
> modparam("auth_db", "avps_column_str", "")
> 
> and then use "users" as the 2nd parameter of
> www_authorize:
> 
> if (!www_authorize("your.domain", "users")) ...
> 
>    Jan.
> 
> On 10-08-2005 09:15, Gareth Holly wrote:
> > Hi Jan, 
> >        Here's the info:
> > 
> > Database: SIPDB
> > Table: Users
> > UserName Column: Username
> > Password Column: Password
> > 
> > 
> > I don't have a domain (or realm ) column because
> all
> > the users will always be on the same realm. 
> > 
> > Is there anything else you need to know?
> > 
> > Thanks
> > 
> > 
> > --- Jan Janak <jan at iptel.org> wrote:
> > 
> > > On 05-08-2005 13:42, Gareth Holly wrote:
> > > > Hi, 
> > > >    I'm trying to configure SER to perform
> proxy
> > > > authentication using username and password
> > > information
> > > > from a users table in my own database. Is this
> > > > possible? and if it is could you please point
> me
> > > in
> > > > the direction of configuration examples?
> > > 
> > >   Yes, it is possible if you store passwords in
> > > plaintex. Please let me
> > >   know the table definition and I will tell you
> how
> > > to configure it (i
> > >   need to know the name of the database, table,
> and
> > > columns).
> > > 
> > >     Jan.
> > > 
> > 
> > 
> > Send instant messages to your online friends
> http://au.messenger.yahoo.com 
> 


Send instant messages to your online friends http://au.messenger.yahoo.com 




More information about the sr-users mailing list