[OpenSIPS-Users] Error starting opensips after upgrade

[Zahid Mehmood]

Steve,
   alter db table "pua" to add a new column "to_uri".  That should do it.  I don't think it is documented yet.

--
Zahid


On Mar 2, 2010, at 1:19 PM, Steven C. Blair wrote:


After upgrading to the svn head release I get the following error when starting opensips with my previously working config file. I don’t see any mention of a database table update being required as part of update. Could someone explain this error?

Thanks,Steve

INFO: Starting OpenSIPS :

ERROR: PID file /var/run/opensips.pid does not exist -- OpenSIPS start failed
Mar  2 13:13:10 ps1-dev /usr/local/sbin/opensips[19042]: INFO:options:mod_init: initializing...
Mar  2 13:13:10 ps1-dev /usr/local/sbin/opensips[19042]: INFO:registrar:mod_init: initializing...
Mar  2 13:13:10 ps1-dev /usr/local/sbin/opensips[19042]: NOTICE:signaling:mod_init: initializing module ...
Mar  2 13:13:10 ps1-dev /usr/local/sbin/opensips[19042]: ERROR:db_mysql:db_mysql_submit_query: driver error: Unknown column 'to_uri' in 'field list'
Mar  2 13:13:10 ps1-dev /usr/local/sbin/opensips[19042]: ERROR:core:db_do_query: error while submitting query
Mar  2 13:13:10 ps1-dev /usr/local/sbin/opensips[19042]: ERROR:pua:db_restore: while querying table
Mar  2 13:13:10 ps1-dev /usr/local/sbin/opensips[19042]: ERROR:pua:mod_init: while restoring hash_table
Mar  2 13:13:10 ps1-dev /usr/local/sbin/opensips[19042]: ERROR:core:init_mod: failed to initialize module pua
Mar  2 13:13:10 ps1-dev /usr/local/sbin/opensips[19042]: ERROR:core:main: error while initializing modules
Mar  2 13:13:10 ps1-dev /usr/local/sbin/opensips[19042]: NOTICE:presence:destroy: destroy module ...


<ATT00001..txt>