search

nilsteampassnet / TeamPass

Collaborative Passwords Manager
https://www.teampass.net
1.67k stars 546 forks source link

Installation Stuck BEFORE Database Population #3036

Open ccolussi opened 2 years ago

ccolussi commented 2 years ago

Steps to reproduce

  1. New install of version 3.0.0.10
  2. Change folder permissions based on https://teampass.readthedocs.io/en/latest/install/install-linux/#set-folders-permissions
  3. Start install
  4. Stuck after "next" on database configuration

Expected behaviour

Stuck after "next" on database configuration

Server configuration

Operating system: CentOS Stream release 8

Web server: Apache 2

Database: Mysql 5.7.31

PHP version: 7.4.27

Teampass version: 3.0.0.10

Teampass configuration file: -- new instalation --

Updated from an older Teampass or fresh install: PLEASE attach to this issue the file /includes/config/tp.config.php.

Client configuration

Browser: Latest versions of Chrome and Edge

Operating system: Windows 10

Logs

Web server error log

192.168.1.53 - - [11/Feb/2022:08:59:53 -0300] "POST /teampass/install/install.php HTTP/1.1" 200 6004 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 52 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 52 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 52 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 52 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 52 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 52 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 52 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 52 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 52 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 52 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 53 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 53 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 53 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 53 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 53 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:55 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 200 32 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:08:59:56 -0300] "POST /teampass/install/install.php HTTP/1.1" 200 4744 "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36" 192.168.1.53 - - [11/Feb/2022:09:00:34 -0300] "POST /teampass/install/install.queries.php HTTP/1.1" 500 - "http://srvpro09.keyworks.com.br/teampass/install/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.82 Safari/537.36"

Log from the web-browser developer console (CTRL + SHIFT + i)

kerneus commented 2 years ago

screenshot-2022-02-12 081719 +1

kerneus commented 2 years ago

Please anyone attach u own the file /includes/config/tp.config.php

gmontequi commented 2 years ago

Could you please check your install.queries.php file, during the creation of "nested_tree" table, if you have this line twice (renewal_period int(5) NOT null DEFAULT '0',):

$dbTmp,
                        "CREATE TABLE IF NOT EXISTS `" . $var['tbl_prefix'] . "nested_tree` (
                        `id` bigint(20) unsigned NOT null AUTO_INCREMENT,
                        `parent_id` int(11) NOT NULL,
                        `title` varchar(255) NOT NULL,
                        `nleft` int(11) NOT NULL DEFAULT '0',
                        `nright` int(11) NOT NULL DEFAULT '0',
                        `nlevel` int(11) NOT NULL DEFAULT '0',
                        `bloquer_creation` tinyint(1) NOT null DEFAULT '0',
                        `bloquer_modification` tinyint(1) NOT null DEFAULT '0',
                        `personal_folder` tinyint(1) NOT null DEFAULT '0',
                        **`renewal_period` int(5) NOT null DEFAULT '0',
                        `renewal_period` int(5) NOT null DEFAULT '0',**
                        `fa_icon` VARCHAR(100) NOT NULL DEFAULT 'fa-folder',
                        `fa_icon_selected` VARCHAR(100) NOT NULL DEFAULT 'fa-fa_icon_selected',
                        PRIMARY KEY (`id`),
                        KEY `nested_tree_parent_id` (`parent_id`),
                        KEY `nested_tree_nleft` (`nleft`),
                        KEY `nested_tree_nright` (`nright`),
                        KEY `nested_tree_nlevel` (`nlevel`),
                        KEY `personal_folder_idx` (`personal_folder`)
                        ) CHARSET=utf8;"

If so, please, delete one of the lines and try again.

Best regards

nilsteampassnet commented 2 years ago

This has been fixed within latest commits

kerneus commented 2 years ago

renewal_period int(5) NOT null DEFAULT '0',

Alas, it's not about me. Version 3.0.0.11 has the same error, installation stops at the same step. screenshot-2022-02-12 081719

#  grep "int(5) NOT null DEFAULT '0'" ./install.queries.php
                            `renewal_period` int(5) NOT null DEFAULT '0',
gmontequi commented 2 years ago

Ok! if the error is in that step, maybe the problem is the creation of some tables. The error only occurs with mysql but not with mariadb.

Please, create manually private_key, publick_key (users table) and encrypted (otv table) columns as text and try again.

Best regards