[Serusers] Message Store problem

[Daniel-Constantin Mierla]

You need the latest structure of table silo, which must be:

    mid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
    src_addr VARCHAR(255) NOT NULL DEFAULT *""*,
    dst_addr VARCHAR(255) NOT NULL DEFAULT *""*,
    r_uri VARCHAR(255) NOT NULL DEFAULT *""*,
    username VARCHAR(64) NOT NULL DEFAULT *""*,
    domain VARCHAR(128) NOT NULL DEFAULT *""*,
    inc_time INTEGER NOT NULL DEFAULT 0,
    exp_time INTEGER NOT NULL DEFAULT 0,
    ctype VARCHAR(32) NOT NULL DEFAULT *"text/plain"*,
    body BLOB NOT NULL DEFAULT *""*


and then to update the table version to have ( 'silo', '2').

All these are in the ser_mysql.sh from CVS head.

Daniel


On 9/15/2004 11:29 AM, Sean wrote:

> Hi,all
> I try to use the module(msilo) to implement web Message Store.
> I add this part in my ser.cfg
> loadmodule "/usr/local/lib/ser/modules/msilo.so"
> modparam("msilo", "registrar", "sip:registrar@<my_domain>")
> modparam("msilo", "db_url", "mysql://ser:heslo@dbhost/ser")
> and I can't start my ser server.
> It appear this error.
> Sep 15 17:36:35 knuth /usr/local/sbin/ser[7092]: MSILO:mod_init: Wrong
> version v2 for table <silo>, need v3
> Sep 15 17:36:35 knuth /usr/local/sbin/ser[7092]: init_mod(): Error
> while initializing module msilo
> my ser is download by cvs.
> could anyone call solve it.
> thanks.
>
> 	
> 	
>
> <http://www.incredimail.com/index.asp?id=54475>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>  
>