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

[Jan Janak]

Ah, ok, then create the table:

#
# Table structure versions
#

CREATE TABLE version (
   table_name varchar(64) NOT NULL,
   table_version smallint(5) DEFAULT '0' NOT NULL
) Type=MyISAM;

INSERT INTO version VALUES ( 'users', '5');

  Jan.      

On 11-08-2005 10:05, Gareth Holly wrote:
> 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