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?
Thanks in advance
Send instant messages to your online friends http://au.messenger.yahoo.com
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.
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@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
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@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
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@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@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
Send instant messages to your online friends http://au.messenger.yahoo.com
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@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@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
Send instant messages to your online friends http://au.messenger.yahoo.com
-
Gareth Holly -
Jan Janak