anca, henning, i studied a bit more presence/notify.c/get_subs_db db query problem. syslog shows this:
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:presence:get_subs_db: querying database table = active_watchers Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:core:db_new_result: allocate 28 bytes for result set at 0x8215480 Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_get_columns: 2 columns returned from the query Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:core:db_allocate_columns: allocate 8 bytes for result names at 0x82150e8 Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:core:db_allocate_columns: allocate 8 bytes for result types at 0x8215108 Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[0] at 0x82154f8 Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x82154f8)[0]=[status] Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[1] at 0x8215510 Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8215510)[1]=[reason] Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_convert_rows: allocate 8 bytes for rows at 0x8215520 Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_convert_row: allocate 40 bytes for row values at 0x8215530 Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_str2val: converting INT [1] why there is only 2 columns returned from the query and why their names are [status] and [reason] instead of [to_user], [to_domain], etc? for comparison, here is the same kind of output from location table query, which looks as one would expect: Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:core:db_new_result: allocate 28 bytes for result set at 0x8215308 Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: 13 columns returned from the query Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:core:db_allocate_columns: allocate 52 bytes for result names at 0x82150d0 Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:core:db_allocate_columns: allocate 52 bytes for result types at 0x8215348 Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[0] at 0x8215208 Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8215208)[0]=[contact] Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[1] at 0x82151f8 Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x82151f8)[1]=[expires] Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[2] at 0x8214d98 Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8214d98)[2]=[q] Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[3] at 0x8215228 Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8215228)[3]=[callid] ... -- juha _______________________________________________ Devel mailing list [email protected] http://lists.openser.org/cgi-bin/mailman/listinfo/devel
