Question best way for migration from 1.7.20 to 2.1.x

This data will be retained automatically, as it is in your database. Just upgrade.

1. Restore the entire webtrees 1.9.20 installation with all old PHP scripts and the DB
2. Unzip the new PHP scripts into the existing directory structure
3. The open question for me: How do I avoid artifacts / file orphans and thus a mix of old and new scripts?
   

1. Restoring the DB
2. Unzip the webtrees 2.1 scripts into the target structure
3. Replace the../data folder with the old data and the old config.ini.php
4. Adjust the config.php for Pretty Links

bertkoor wrote:

Option 2 is simpler, and should just work.
This procedure is not really an upgrade, but more akin a server migration.
webtrees.net/faq/move-server/
 

1. Installed the new server, all works fine
2. Installed WordPress and restored my site, all works fine
3. Restored the webtrees-DB via phpMyadmn-import, no errors
4. created the directory
   Code:

   /phpgedview
   (for compatibility reasons, as in my previous installation)
5. chowned /phpgedview
   Code:

   chown -R www-data:staff phpgedview/
6. Installed the webtrees scripts
7. chowned all subfolders within
   Code:

   /phpgedview
8. created 
   Code:

   config.ini.php
   Code:

   ; DO NOT DELETE THIS LINE dbhost="127.0.0.1" dbport="3313" dbuser="DBUSER_NAME" dbpass="DB_PW" dbname="DB_NAME" tblpfx="wt_" base_url="https://FQDN/phpgedview" rewrite_urls="1"
9. If I want to ooen the URL i get:
   Code:

   RuntimeException: SQLSTATE[HY000] [2002] Connection refused in /app/phpgedview/app/Http/Middleware/UseDatabase.php:119 Stack trace: #0 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\UseDatabase->process() #1 /app/phpgedview/app/Http/Middleware/BadBotBlocker.php(308): Middleland\Dispatcher->handle() #2 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BadBotBlocker->process() #3 /app/phpgedview/app/Http/Middleware/CompressResponse.php(71): Middleland\Dispatcher->handle() #4 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\CompressResponse->process() #5 /app/phpgedview/app/Http/Middleware/ContentLength.php(40): Middleland\Dispatcher->handle() #6 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ContentLength->process() #7 /app/phpgedview/vendor/middlewares/client-ip/src/ClientIp.php(65): Middleland\Dispatcher->handle() #8 /app/phpgedview/app/Http/Middleware/ClientIp.php(47): Middlewares\ClientIp->process() #9 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ClientIp->process() #10 /app/phpgedview/app/Http/Middleware/HandleExceptions.php(89): Middleland\Dispatcher->handle() #11 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\HandleExceptions->process() #12 /app/phpgedview/app/Http/Middleware/BaseUrl.php(73): Middleland\Dispatcher->handle() #13 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\BaseUrl->process() #14 /app/phpgedview/app/Http/Middleware/ReadConfigIni.php(68): Middleland\Dispatcher->handle() #15 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\ReadConfigIni->process() #16 /app/phpgedview/app/Http/Middleware/SecurityHeaders.php(48): Middleland\Dispatcher->handle() #17 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\SecurityHeaders->process() #18 /app/phpgedview/app/Http/Middleware/EmitResponse.php(57): Middleland\Dispatcher->handle() #19 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(136): Fisharebest\Webtrees\Http\Middleware\EmitResponse->process() #20 /app/phpgedview/vendor/oscarotero/middleland/src/Dispatcher.php(118): Middleland\Dispatcher->handle() #21 /app/phpgedview/app/Webtrees.php(275): Middleland\Dispatcher->dispatch() #22 /app/phpgedview/app/Webtrees.php(262): Fisharebest\Webtrees\Webtrees::dispatch() #23 /app/phpgedview/index.php(51): Fisharebest\Webtrees\Webtrees->httpRequest() #24 {main}
   
   What did I miss, or what could I have done wrong?
   
   Addition information:
   Code:

   root@lamp:/app/phpgedview/data# ls -lsh total 12K 4.0K drwxr-xr-x 3 www-data staff 4.0K Oct  1 08:15 cache 4.0K -rw-r--r-- 1 www-data staff  229 Oct  1 08:14 config.ini.php 4.0K -rw-r--r-- 1 www-data staff  793 Apr  8 20:07 index.php
   Code:

   root@lamp:/app/phpgedview# ls -lsh total 120K 8.0K -rw-r--r--  1 root     root  5.0K Apr  8 20:07 CONTRIBUTING.md  36K -rw-r--r--  1 root     root   35K Apr  8 20:07 LICENSE.md  16K -rw-r--r--  1 root     root   15K Apr  8 20:07 README.md 4.0K -rw-r--r--  1 root     root  1.1K Apr  8 20:07 SECURITY.md 4.0K drwxr-xr-x 21 www-data staff 4.0K Apr  8 20:07 app  12K -rw-r--r--  1 www-data staff  12K Apr  8 20:07 apple-touch-icon.png 4.0K drwxr-xr-x  3 www-data staff 4.0K Oct  1 08:15 data  16K -rw-r--r--  1 www-data staff  15K Apr  8 20:07 favicon.ico 4.0K -rw-r--r--  1 www-data staff 1.5K Apr  8 20:07 index.php 4.0K drwxr-xr-x  2 www-data staff 4.0K Apr  8 20:07 modules_v4 4.0K drwxr-xr-x  5 www-data staff 4.0K Apr  8 20:07 public 4.0K drwxr-xr-x  7 www-data staff 4.0K Apr  8 20:07 resources 4.0K drwxr-xr-x 31 www-data staff 4.0K Apr  8 20:08 vendor

To see what accounts you have in your database, run this query:

select Host, User from mysql.user;

RuntimeException: SQLSTATE[HY000] [1044] Access denied for user 'webtreesadmin'@'%' to database 'dbwebtrees' in /app/phpgedview/app/Http/Middleware/UseDatabase.php:119