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

[Robert Cuaresma]

Hi Alex, thanks for your help.

There are no table named lcation_perm in BDD Kamailio:
| lcr_gw                  |
| lcr_rule                  |
| lcr_rule_target           |
| location                  |
| location_attrs            |
| mobile_push_registrations |
| mohqcalls                 |
| mohqueues                 |

Regards.

Saludos, 
Robert Cuaresma
Dpto. Ingeniería de Clientes 

-----Mensaje original-----
De: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] En nombre de Alex Lutay
Enviado el: miércoles, 18 de mayo de 2016 12:07
Para: spce-user at lists.sipwise.com
Asunto: Re: [Spce-user] Permanent Contacts after upgrade from 2.8 to 3.8.6

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 _______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com
https://lists.sipwise.com/listinfo/spce-user