[Spce-user] Stuck on PRESENCE (PUBLISH) database error

Skyler skchopperguy at gmail.com
Mon Jul 4 19:30:54 EDT 2011

Hi all,


 I now have IM/voice working but presence is not updating, the below errors
are in the logs when a PUBLISH is received. The database tables are
installed and match
http://www.kamailio.org/dokuwiki/doku.php/presence:database-tables . Has
anyone seen this before or know what the problem might be?  Any help is



Kamailio-proxy.log -


INFO: <script>: New request - M=PUBLISH R=sip:testuser at dev.mydomain.com
F=sip:testuser at dev.mydomain.com T=sip:testuser at dev.mydomain.com
IP= ( ID=26096

ERROR: db_mysql [km_dbase.c:120]: driver error on query: Field 'sender'
doesn't have a default value

ERROR: <core> [db_query.c:179]: error while submitting query

ERROR: presence [presentity.c:389]: inserting new record in database

ERROR: presence [publish.c:498]: when updating presentity



My Kamailio.proxy.cfg.tt2 -



modparam("presence", "db_url", "mysql://[% kamailio.proxy.dbrwuser %]:[%
kamailio.proxy.dbrwpw %]@[% database.dbhost %]/[% kamailio.proxy.dbname %]")

modparam("presence", "fallback2db", 1)

modparam("presence", "db_update_period", 20)

modparam("presence_xml", "db_url", "mysql://[% kamailio.proxy.dbrwuser %]:[%
kamailio.proxy.dbrwpw %]@[% database.dbhost %]/[% kamailio.proxy.dbname %]")

modparam("presence_xml", "force_active", 0)

modparam("presence_xml", "integrated_xcap_server", 1)




.and I'm doing the below in proxy.cfg.tt2










-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20110704/d3fbecad/attachment.html>

More information about the Spce-user mailing list