Fwd: [Serusers] Invalid table version AGAIN

Vaclav Kubart vaclav.kubart at iptel.org
Mon Feb 20 08:18:08 CET 2006


Hi,
in the latest version of presence snapshot should be used table
"credentials" inastead of "subscriber". This table can be filled using
new serctl utility (in tools/serctl in source tree; utility ser_cred).

	Vaclav


On Fri, Feb 17, 2006 at 05:02:51PM -0800, Yi Zheng wrote:
> Hi,
>    
>   I found the problem is that the new ser_mysql.sh did not create a
>   subscriber entry in its version table.  Now I am trying to use
>   admin/heslo to login and got 500 internal server error. Here is the
>   log:
>    
>   Feb 17 17:31:46 localhost ./ser[9700]: parsing accept header: application/watcherinfo+xml
> Feb 17 17:31:46 localhost ./ser[9700]: winfo_implicit_auth(sip:admin at 10.1.104.254): enabled for sip:admin at 10.1.104.254
> Feb 17 17:31:46 localhost ./ser[9700]: handle_subscription about to return 1: w->event_package=2 w->accept=196618 p->flags=4 w->flags=1 w=0xb61c33e4
> Feb 17 17:31:47 localhost pam_timestamp_check: pam_timestamp: `/' owner UID != 0
> Feb 17 17:31:52 localhost ./ser[9708]: ! unregistering callback to admin, 0xb61c3048
> Feb 17 17:31:52 localhost ./ser[9708]: ! unregistered callback to admin, 0xb61c3048
> Feb 17 17:31:52 localhost pam_timestamp_check: pam_timestamp: `/' owner UID != 0
> Feb 17 17:32:27 localhost last message repeated 7 times
> Feb 17 17:32:31 localhost ./ser[9701]: new_presentity_no_wb=0xb61c3048 for uri=sip:admin at 10.1.104.254 uuid=admin
>   Feb 17 17:32:31 localhost ./ser[9701]: ! registering callback to admin, 0xb61c3048
>   Feb 17 17:32:31 localhost ./ser[9701]: read_presentity(ns=urn:ietf:params:xml:ns:pidf)Feb 17 17:32:31 localhost ./ser[9701]: read_tuple()
>   Feb 17 17:32:31 localhost ./ser[9694]: parsing accept header: application/watcherinfo+xml
> Feb 17 17:32:31 localhost ./ser[9694]: winfo_implicit_auth(sip:admin at 10.1.104.254): enabled for sip:admin at 10.1.104.254
>   Feb 17 17:32:31 localhost ./ser[9694]: handle_subscription about to return 1: w->event_package=2 w->accept=196618 p->flags=5 w->flags=1 w=0xb61c33e4
>   Feb 17 17:32:32 localhost pam_timestamp_check: pam_timestamp: `/' owner UID != 0
>   Feb 17 17:32:33 localhost ./ser[9707]: submit_query: Unknown column 'flags' in 'field list'
>   Feb 17 17:32:33 localhost ./ser[9707]: db_query: Error while submitting query
>   Feb 17 17:32:33 localhost ./ser[9707]: auth_db:get_ha1: Error while querying database
>   Feb 17 17:32:37 localhost pam_timestamp_check: pam_timestamp: `/' owner UID != 0
> 
>   Can someone please shed light on this?
>    
>   - ming
>   
> 
> Yi Zheng <yizheng at sbcglobal.net> wrote:
>   Date: Fri, 17 Feb 2006 15:28:18 -0800 (PST)
> From: Yi Zheng <yizheng at sbcglobal.net>
> To: ser sip <serusers at lists.iptel.org>
> Subject: [Serusers] Invalid table version AGAIN
> 
>   I was able to have SER working with MySql database.  I can see the location table updated with the registered users. 
>    
>   However if I add the following line to ser.cfg to use digest authentication and restart ser, then I saw the following errors in /var/log/messages and ser failed to start.
>    
>   ser.cfg
>   ----------
>   # Uncomment this if you want to use digest authentication
>                         if (!www_authenticate("10.1.104.254", "subscriber")) {
>                                 www_challenge("10.1.104.254", "0");
>                                 break;
>                         };
>    
>   /var/log/messages:
>   --------------------------
>   Feb 17 16:25:39 localhost ./ser[32533]: authdb_fixup: Invalid table version (use ser_mysql.sh reinstall)
> Feb 17 16:25:39 localhost ./ser[32533]: ERROR: fix_expr : fix_actions error
> 
>    
>   I am using the presence server snapshot. There is no reinstall for this version of ser_mysql.sh. And I made no change to the database or version table. So what is it complaining? I found this strange.
>    
>   - ming
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>   
> 

Content-Description: pat160862120
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers

> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers




More information about the sr-users mailing list