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

[Theo]

ok thinking a little more - I ran your query and found the entries, but my
database knowledge is REALLY limited. How would I delete those entries? I
tried to be clever and simply replace SELECT with DELETE but that's clearly
wrong....


On Thu, Aug 22, 2013 at 10:41 PM, Theo <axessofficetheo at gmail.com> 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> 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/0e87431a/attachment-0001.html>