[Users] Using a table other that subscriber for authentication

Script Head scripthead at gmail.com
Tue Mar 7 21:07:15 CET 2006


I have a solid setup of OpenSER and PostgreSQL. My route in question looks
like this

        if(method=="REGISTER") {
                if (!www_authorize("domain", "subscriber")) {
                        www_challenge("domain", "0");
                        return;
                };
                save("location");
                return;
        }

I would like to use a view called subscriber_active instead of table
subscriber. It's a view that returns a result set identical to SELECT * FROM
subscriber. I also did INSERT INTO version(table_name,table_version)
VALUES('subscriber_active',1). When I replace the subscriber with
subscriber_active in the above route, I get

0(0) auth_db:str_fixup: Invalid table version (use ser_mysql.sh reinstall)
 0(0) ERROR: fix_expr : fix_actions error
ERROR: error -1 while trying to fix configuration


so can someone explain what the table version is supposed to be?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20060307/a7a30403/attachment.htm>


More information about the sr-users mailing list