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

[Andrew Pogrebennyk]

Hi,
you can delete the permanent contacts without web interface: just run
the SELECT query i posted, see what it returns, then replace select with
delete.. after that run the upgrade script again.

The apache may not start for a different reason. Just asking, do you
have enough RAM? The minimum requirement for 3.0 is 2GB RAM and apache
won't start if you have less..

HTH.
Andrew

On 22/08/2013 22:41, Theo wrote:
> 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 <mailto: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>
>     <mailto: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?
>     >
>     >
> 
>