[Spce-user] Permanent Contacts after upgrade from 2.8 to 3.8.6

[Alex Lutay]

Dear Robert,

I believe something went wrong during the upgrade,
I will re-check it soonish in a LAB.

I notice the reason for the error and it will be fixed for the next
upgrades:
> ERROR 1045 (28000): Access denied for user 'root'@'localhost'
It stays here for 3 years... nobody uses permanent registrations?
Or nobody have root password in MySQL?

Can you please check on your side, do you have table
kamailio.location_perm in MySQL DB right now?

P.S. Sipwise nightly upgrade tests has root password for MySQL
configured to catch the problems like that, but it has no check
for permanent registrations, I will improve the test here.

Thank you for the report!

On 05/17/2016 09:58 PM, Robert Cuaresma wrote:
> In log ngcp-upgrade at 90% of file:
> 
> 
> Generating /etc/mysql/my.cnf: OK
> [....] Starting MySQL database server: mysqld
> Checking for tables which need an upgrade, are corrupt or were
> not closed cleanly..
> Fix permanent contacts, 'pre' stage
> Copying libnss and libnsl libraries
> Copying PAM-Modules (/lib/x86_64-linux-gnu/security) to jail
> Could not determine provisioning db hostname
> OK
> 
> At the end of the file:
> 
> Fix permanent contacts, 'post' stage...
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
> Need reboot to finish installation.
> 
> Also, I ran /usr/share/ngcp-upgrade-mr3.8.6/recreate_perm_contacts
> Script and the result was:
> 
> # ./recreate_perm_contacts post
> 
> Error: temporary table location_perm does not exists
> 
>  
> 
> Thanks!
> 
>  
> 
> Robert Cuaresma
> 
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
> 

-- 
Alexander Lutay
Head of Quality Assurance
Sipwise GmbH, Campus 21/Europaring F15
AT-2345 Brunn am Gebirge

Office: +43(0)13012036
Email: alutay at sipwise.com
Website: https://www.sipwise.com

Meet us @ ANGACOM: Hall 10.1 / booth N10
Exhibition and Congress for Broadband,
Cable & Satellite: 07 – 09 June, 2016 in Cologne