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

[Theo]

Hi

sorry didn't see the replies:

No, delete doesn't do it. I had thought of that but it gives me:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near '* FROM    location loc1 WHERE   EXISTS         (         SELECT
1         FROM ' at line 1


Apache: it does start. RAM is 8GB?


On Thu, Aug 22, 2013 at 11:04 PM, Theo <axessofficetheo at gmail.com> wrote:

> 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/edc24b58/attachment-0001.html>