[Spce-user] sip:provider CE v3.0 released!

[Theo]

Hi

I have two servers running. This particular one only has a few permanent
contacts and are in fact not needed so I could easily delete them. If I
could get into the webinterface. I see now that after this I can't get to
the webgui anymore. Apache error log gives me:

Subroutine Sipwise::Base::CLASS redefined at /usr/share/perl5/CLASS.pm line
20.

Do I wait for the fix and run it again, or is there a quickish way around
this in the meantime?


On Thu, Aug 22, 2013 at 6:00 PM, Andrew Pogrebennyk <
apogrebennyk at sipwise.com> wrote:

> Theo,
>
> this is the problem John reported here:
> http://lists.sipwise.com/pipermail/spce-user/2013-August/004605.html
>
> The problem is that in 2.8 installation when we create permanent
> contacts the ruid is not unique. In 3.0 it must be unique.
>
> Please check how many permanent contacts you have:
>
> SELECT  *
> FROM    location loc1
> WHERE   EXISTS
>         (
>         SELECT  1
>         FROM    location loc2
>         WHERE   loc2.ruid = loc1.ruid
>         LIMIT 1, 1
>         )
>
> if there are just a few of them you can delete them, re-run upgrade
> script and re-create the permanent contacts afterwards.
>
> Victor is working on the permanent fix, ETA: tomorrow.
>
> Andrew
>
> On 08/22/2013 05:46 PM, Theo wrote:
> > Hi Andrew
> >
> > Thanks as always for quick replies! Got past that now but now have:
> >
> > Applying revision script
> > /usr/share/ngcp-db-schema/db_scripts/diff/13659.up: ERROR 1062 (23000)
> > at line 13: Duplicate entry 'ulcx-516bff41-36e4-1' for key 'ruid_idx'
> > failed. :(
> > Please resolve the problem and run ngcp-update-db-schema again.
> > root at sipwise:~#
> >
> >
> >
> > On Thu, Aug 22, 2013 at 5:42 PM, Andrew Pogrebennyk
> > <apogrebennyk at sipwise.com <mailto:apogrebennyk at sipwise.com>> wrote:
> >
> >     Hi Theo,
> >
> >     it seems you've had postgresql installed. Could you please deinstall
> it
> >     manually (apt-get remove --purge) and re-run the upgrade script
> again?
> >     It should continue from where it stopped last time.
> >
> >     On 08/22/2013 04:42 PM, Theo wrote:
> >     > Hi
> >     >
> >     > That didn't go as planned :-( - I did not get the request to
> reboot at
> >     > the end. It ended with the famous last words:
> >     >
> >     > Removing linux-kbuild-2.6.32 ...
> >     > Removing postgresql-contrib-8.4 ...
> >     > Removing postgresql-8.4 ...
> >     > invoke-rc.d: policy-rc.d denied execution of stop.
> >     > Purging configuration files for postgresql-8.4 ...
> >     > Dropping cluster main...
> >     > Can't exec "": No such file or directory at /usr/bin/pg_ctlcluster
> >     line 268.
> >     > Error: could not stop server, aborting
> >     > dpkg: error processing postgresql-8.4 (--purge):
> >     >  subprocess installed post-removal script returned error exit
> status 1
> >     > Removing postgresql-client-8.4 ...
> >     > Removing postgresql-doc-8.4 ...
> >     > Processing triggers for man-db ...
> >     > Errors were encountered while processing:
> >     >  postgresql-8.4
> >     > E: Sub-process /usr/bin/dpkg returned an error code (1)
> >     >
> >     >
> >     > I can no longer login on the webinterface - not accepting my user
> and
> >     > pass and presumably most other things are borked? Any thoughts?
> >
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130822/81db91d5/attachment-0001.html>