V4 -> V5 Migration Errors

Self-Hosted | v5
1

Hello !

I am trying to migrate my data from my V4 Instance to a freshly installed V5.

I created a user with same credentials and started the migration process.
There are 5 “companies” on my V4 Instance

Company 1 : Success !

Company 2 error email :

                Undefined index: notifications
Undefined index: notifications

Company 3, 4 and 5 error email :

SQLSTATE[HY000] [1045] Access denied for user ‘ninja’@‘localhost’ (using password: YES) (SQL: select exists(select * from users where (email = info@kidjdk.be) and users.deleted_at is null) as exists) SQLSTATE[HY000] [1045] Access denied for user ‘ninja’@‘localhost’ (using password: YES) (SQL: select exists(select * from users where (email = info@kidjdk.be) and users.deleted_at is null) as exists)

Can someone guide me on what to check /change to make this work ?

Thank you !

Florian

2

Are there any additional errors in the logs in your V5 installation in storage/logs/laravel.log

3

Hello @david,

Thank your for your reply !

Here are some additional information from the laravel.log

[2021-06-12 05:09:02] production.INFO: db fails
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: file_put_contents(/var/www/invoicesv5.xxx.be/htdocs/.env): failed to open stream: Permission denied
[2021-06-12 05:10:35] production.INFO: SQLSTATE[HY000] [1045] Access denied for user ‘ninja’@‘localhost’ (using password: YES) (SQL: select * from information_schema.tables where table_schema = ninja and table_name = migrations and table_type = ‘BASE TABLE’)
[2021-06-12 05:10:42] production.INFO: db fails
[2021-06-12 05:11:24] production.INFO: db fails
[2021-06-12 05:17:06] production.INFO: db fails
[2021-06-12 05:18:09] production.INFO: SQLSTATE[HY000] [1045] Access denied for user ‘ninja’@‘localhost’ (using password: YES) (SQL: select * from information_schema.tables where table_schema = ninja and table_name = migrations and table_type = ‘BASE TABLE’)
[2021-06-12 05:25:46] production.INFO: latest version = 5.2.1

Hope this helps

Florian

4

ok,

this makes sense.

It looks like the permissions on the directory need to be writable by the webuser - the .env file isn’t being written.

5

Permissions on .env file are defined like this, do you see a problem with this line ?

-rw-r–r-- 1 www-data www-data 1453 Jun 12 07:15 .env

6

The error indicates that the application isn’t able to write to the .env file… perhaps another user process is attempting to write?