Error starting opensips after upgrade

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Error starting opensips after upgrade

Steven C. Blair

 

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 ...

 

 


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: 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>


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Error starting opensips after upgrade

Steven C. Blair

Thanks I'll try that

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Error starting opensips after upgrade

Steven C. Blair
In reply to this post by Zahid Mehmood

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: [hidden email] [mailto:[hidden email]] 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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Error starting opensips after upgrade

Bogdan-Andrei Iancu
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: [hidden email] [mailto:[hidden email]] 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
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>  


--
Bogdan-Andrei Iancu
www.voice-system.ro


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users