Hi Steven, the table is populated and used only by opensips (all writes and reads by itself), so you do not have to populate it - just have the column created.
Regards, Bogdan Steven C. Blair wrote: > Zahid, > > I added the to_uri column with arbitrary values and that enables OpenSIPS to > start. Please let me know if specific field values should be used. > > Thanks,Steve > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Zahid Mehmood > Sent: Tuesday, March 02, 2010 2:25 PM > To: OpenSIPS users mailling list > Subject: Re: [OpenSIPS-Users] Error starting opensips after upgrade > > 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> > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- Bogdan-Andrei Iancu www.voice-system.ro _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
