<DIV>Hi,</DIV> <DIV> </DIV> <DIV>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:</DIV> <DIV> </DIV> <DIV>Feb 17 17:31:46 localhost ./ser[9700]: parsing accept header: application/watcherinfo+xml<BR>Feb 17 17:31:46 localhost ./ser[9700]: winfo_implicit_auth(sip:admin@10.1.104.254): enabled for sip:admin@10.1.104.254<BR>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<BR>Feb 17 17:31:47 localhost pam_timestamp_check: pam_timestamp: `/' owner UID != 0<BR>Feb 17 17:31:52 localhost ./ser[9708]: ! unregistering callback to admin, 0xb61c3048<BR>Feb 17 17:31:52 localhost ./ser[9708]: ! unregistered callback to admin, 0xb61c3048<BR>Feb 17 17:31:52 localhost pam_timestamp_check: pam_timestamp: `/' owner UID !=
0<BR>Feb 17 17:32:27 localhost last message repeated 7 times<BR>Feb 17 17:32:31 localhost ./ser[9701]: new_presentity_no_wb=0xb61c3048 for uri=sip:admin@10.1.104.254 uuid=admin</DIV> <DIV>Feb 17 17:32:31 localhost ./ser[9701]: ! registering callback to admin, 0xb61c3048</DIV> <DIV>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()</DIV> <DIV>Feb 17 17:32:31 localhost ./ser[9694]: parsing accept header: application/watcherinfo+xml<BR>Feb 17 17:32:31 localhost ./ser[9694]: winfo_implicit_auth(sip:admin@10.1.104.254): enabled for sip:admin@10.1.104.254</DIV> <DIV>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</DIV> <DIV>Feb 17 17:32:32 localhost pam_timestamp_check: pam_timestamp: `/' owner UID != 0</DIV> <DIV>Feb 17 17:32:33 localhost ./ser[9707]: submit_query: Unknown column
'flags' in 'field list'</DIV> <DIV>Feb 17 17:32:33 localhost ./ser[9707]: db_query: Error while submitting query</DIV> <DIV>Feb 17 17:32:33 localhost ./ser[9707]: auth_db:get_ha1: Error while querying database</DIV> <DIV>Feb 17 17:32:37 localhost pam_timestamp_check: pam_timestamp: `/' owner UID != 0<BR></DIV> <DIV>Can someone please shed light on this?</DIV> <DIV> </DIV> <DIV>- ming</DIV> <DIV><BR><BR><B><I>Yi Zheng <yizheng@sbcglobal.net></I></B> wrote:</DIV> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Date: Fri, 17 Feb 2006 15:28:18 -0800 (PST)<BR>From: Yi Zheng <yizheng@sbcglobal.net><BR>To: ser sip <serusers@lists.iptel.org><BR>Subject: [Serusers] Invalid table version AGAIN<BR><BR> <DIV id=RTEContent>I was able to have SER working with MySql database. I can see the location table updated with the registered users. </DIV> <DIV> </DIV> <DIV>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.</DIV> <DIV> </DIV> <DIV>ser.cfg</DIV> <DIV>----------</DIV> <DIV># Uncomment this if you want to use digest authentication<BR> if (!www_authenticate("10.1.104.254", "subscriber")) {<BR> www_challenge("10.1.104.254", "0");<BR>
break;<BR> };</DIV> <DIV> </DIV> <DIV>/var/log/messages:</DIV> <DIV>--------------------------</DIV> <DIV>Feb 17 16:25:39 localhost ./ser[32533]: authdb_fixup: Invalid table version (use ser_mysql.sh reinstall)<BR>Feb 17 16:25:39 localhost ./ser[32533]: ERROR: fix_expr : fix_actions error<BR></DIV> <DIV> </DIV> <DIV>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.</DIV> <DIV> </DIV> <DIV>- ming<BR></DIV>_______________________________________________<BR>Serusers mailing list<BR>serusers@lists.iptel.org<BR>http://lists.iptel.org/mailman/listinfo/serusers<BR></BLOCKQUOTE> <DIV><BR></DIV>