[Users] Fwd:Invalid table version

Bogdan-Andrei Iancu bogdan at voice-system.ro
Wed Apr 12 10:28:27 CEST 2006


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 at 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 at voice-system.ro
>To          : "buxalex at libero.it" buxalex at libero.it
>Cc          : "users" users at 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 at 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 at openser.org
>>>http://openser.org/cgi-bin/mailman/listinfo/users
>>>
>>> 
>>>
>>>      
>>>
>
>
>  
>





More information about the Users mailing list