[Users] active_watchers table

Jeremy George jeremy at georgeco.us
Thu May 24 12:57:40 CEST 2007


Hi Henning,

  Perfect.  Thanks again.

- Jeremy


>-----Original Message-----
>From: Henning Westerholt [mailto:henning.westerholt at 1und1.de]
>Sent: Thursday, May 24, 2007 04:39 AM
>To: users at openser.org, 'Jeremy George'
>Subject: Re: [Users] active_watchers table
>
>On Mittwoch, 23. Mai 2007, Jeremy George wrote:
>> Hello All,
>>
>>   I'm getting this error message:
>>
>> 0(0) PRESENCE:mod_init: Wrong version v1 for table <active_watchers>, need
>> v4
>> 0(0) init_mod(): Error while initializing module presence
>> ERROR: error while initializing modules
>>
>>   I downloaded and compiled the current svn head (2276), and created the
>> mysql active_watchers table defined in the README (see below).  
>> [..]
>>   Can anyone tell me where to find the right table?  Thanks much.
>
>Hello Jeremy,
>
>the table that is defined by the README is to old. You can extract at the 
>moment all tables from the mysqldb.sh script.
>
>In the next weeks the db stuff will be updated, then all db schemas would be 
>up to date in a central place.
>
>I've attached the current table too.
>
>#################
>INSERT INTO version (table_name, table_version) values 
>('active_watchers','4');
>CREATE TABLE active_watchers (
>    id INT(10) UNSIGNED AUTO_INCREMENT NOT NULL,
>    pres_user VARCHAR(64) NOT NULL,
>    pres_domain VARCHAR(128) NOT NULL,
>    to_user VARCHAR(64) NOT NULL,
>    to_domain VARCHAR(128) NOT NULL,
>    from_user VARCHAR(64) NOT NULL,
>    from_domain VARCHAR(128) NOT NULL,
>    event VARCHAR(64) NOT NULL DEFAULT 'presence',
>    event_id VARCHAR(64),
>    to_tag VARCHAR(128) NOT NULL,
>    from_tag VARCHAR(128) NOT NULL,
>    callid VARCHAR(128) NOT NULL,
>    local_cseq INT(11) NOT NULL,
>    remove_cseq INT(11) NOT NULL,
>    contact VARCHAR(128) NOT NULL,
>    record_route TEXT,
>    expires INT(11) NOT NULL,
>    status VARCHAR(32) NOT NULL DEFAULT 'pending',
>    version INT(11) NOT NULL DEFAULT '0',
>    socket_info VARCHAR(128) NOT NULL,
>    local_contact VARCHAR(255) NOT NULL,
>    UNIQUE KEY tt_watchers (to_tag),
>    KEY due_activewatchers (to_domain, to_user, event),
>    PRIMARY KEY (id)
>) Type=MyISAM;
>########
>
>
>Best regards,
>
>Henning 	
>






More information about the sr-users mailing list