Hello Bogdan,
as usual you are right! :o) I tried to use the table subscriber as follow:
if (method=="INVITE") { setflag(2); record_route(); if (!lookup("subscriber")) { sl_send_reply("401", "Dialled Number not Authorizied"); exit; if (!lookup("location")) { sl_send_reply("404", "Dialled number off line !"); exit; }; };
Of course commenting the part related to subscriber table it works fine. My idea was to check whether the dialled number is only off line or it is not existent; this because I would like to have the choice to send a registered vocal message (or for mow an email) to dialled numbers.
I tried to put 1003 in table domain and subscriber, but now I get this error:
ACC - initializing AVPops - initializing submit_query: Unknown column 'contact' in 'field list' db_query: Error while submitting query preload_udomain(): Error while doing db_query register_udomain(): Error while preloading domain 'subscriber' domain_fixup(): Error while registering domain fix_actions: fixing failed (code=-1) at cfg line 211 ERROR: fix_expr : fix_actions error
Can I fix this problem with configuration, or should I modify the logic to access the db (I mean I shouldn't use the subscriber table)?
Thanks a lot Alessandro
---------- Initial Header -----------
From : "Bogdan-Andrei Iancu" bogdan@voice-system.ro
To : "buxalex@libero.it" buxalex@libero.it Cc : "users" users@openser.org Date : Tue, 11 Apr 2006 20:34:58 +0300 Subject : Re: [Users] Fwd:Invalid table version
Hi,
the error is generated by the usrloc module - the used tables must have version 1003; are you using a different tablet then "location" or "aliases"? if not, check in version table their records.
regards, bogdan
buxalex@libero.it wrote:
Hello, I tried also to drop and the to install the db, but still I get the same error....
Please anybody can help me?
I am using openser version 1.1.0 dev17 tls
thanks in advance Alessandro
Hello,
running openser with mysql db (through monitor), I retrieve:
ACC - initializing Apr 11 18:58:32 dhc27-53-93pc /usr/local/sbin/openser[7806]: register_udomain(): Invalid table version (use openser_mysql.sh reinstall)
If I comment the module ACC loading I get the same error for the other modules. I reinstalled, as suggested from the log the db, but still I get the error.
in table version I can see that the domain table has version 1
Any idea? This is a test db, do you suggest to erase it and to install it again?
thanks a lot Alessandro
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Hi,
subscriber table is not meant to be used with location, so lookup("subscriber") is not correctly at all.
if you want to check if a user is subscriber, use the the "uri_db" module: http://openser.org/docs/modules/1.0.x/uri_db.html#AEN205
regards, bogdan
buxalex@libero.it wrote:
Hello Bogdan,
as usual you are right! :o) I tried to use the table subscriber as follow:
if (method=="INVITE") { setflag(2); record_route(); if (!lookup("subscriber")) { sl_send_reply("401", "Dialled Number not Authorizied"); exit; if (!lookup("location")) { sl_send_reply("404", "Dialled number off line !"); exit; }; };
Of course commenting the part related to subscriber table it works fine. My idea was to check whether the dialled number is only off line or it is not existent; this because I would like to have the choice to send a registered vocal message (or for mow an email) to dialled numbers.
I tried to put 1003 in table domain and subscriber, but now I get this error:
ACC - initializing AVPops - initializing submit_query: Unknown column 'contact' in 'field list' db_query: Error while submitting query preload_udomain(): Error while doing db_query register_udomain(): Error while preloading domain 'subscriber' domain_fixup(): Error while registering domain fix_actions: fixing failed (code=-1) at cfg line 211 ERROR: fix_expr : fix_actions error
Can I fix this problem with configuration, or should I modify the logic to access the db (I mean I shouldn't use the subscriber table)?
Thanks a lot Alessandro
---------- Initial Header -----------
From : "Bogdan-Andrei Iancu" bogdan@voice-system.ro To : "buxalex@libero.it" buxalex@libero.it Cc : "users" users@openser.org Date : Tue, 11 Apr 2006 20:34:58 +0300 Subject : Re: [Users] Fwd:Invalid table version
Hi,
the error is generated by the usrloc module - the used tables must have version 1003; are you using a different tablet then "location" or "aliases"? if not, check in version table their records.
regards, bogdan
buxalex@libero.it wrote:
Hello, I tried also to drop and the to install the db, but still I get the same error....
Please anybody can help me?
I am using openser version 1.1.0 dev17 tls
thanks in advance Alessandro
Hello,
running openser with mysql db (through monitor), I retrieve:
ACC - initializing Apr 11 18:58:32 dhc27-53-93pc /usr/local/sbin/openser[7806]: register_udomain(): Invalid table version (use openser_mysql.sh reinstall)
If I comment the module ACC loading I get the same error for the other modules. I reinstalled, as suggested from the log the db, but still I get the error.
in table version I can see that the domain table has version 1
Any idea? This is a test db, do you suggest to erase it and to install it again?
thanks a lot Alessandro
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-
Bogdan-Andrei Iancu -
buxalex＠libero.it