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?
Hi,
depends on what openser version you are using...for 1.0.x you need to set 1001. For 0.9.x, use 5.
anyhow, set for the new table the same version as already is set for "subscriber" table.
regards, bogdan
Script Head wrote:
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?
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Setting to 1001 worked. Now, what does this 1001 actually mean?
On 3/7/06, Bogdan-Andrei Iancu bogdan@voice-system.ro wrote:
Hi,
depends on what openser version you are using...for 1.0.x you need to set 1001. For 0.9.x, use 5.
anyhow, set for the new table the same version as already is set for "subscriber" table.
regards, bogdan
Script Head wrote:
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?
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
it;s the version for the table format. each time the table format is changed, the version is incremented to avoid missusage between different openser and table versions.
regards, bogdan
Script Head wrote:
Setting to 1001 worked. Now, what does this 1001 actually mean?
On 3/7/06, *Bogdan-Andrei Iancu* <bogdan@voice-system.ro mailto:bogdan@voice-system.ro> wrote:
Hi, depends on what openser version you are using...for 1.0.x you need to set 1001. For 0.9.x, use 5. anyhow, set for the new table the same version as already is set for "subscriber" table. regards, bogdan Script Head wrote: > 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? > >------------------------------------------------------------------------ > >_______________________________________________ >Users mailing list >Users@openser.org <mailto:Users@openser.org> >http://openser.org/cgi-bin/mailman/listinfo/users > >
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-
Bogdan-Andrei Iancu -
Script Head